Question: Q1. Based on the data in the table below, please draft a paragraph (10-20 lines) that describes your data observations and description of what is

Q1. Based on the data in the table below, please draft a paragraph (10-20 lines) that describes your data observations and description of what is going on in the market during February 2014. Question related to SQL query

Information about the Sample Data for Data Observation Paragraph

  • This is transaction data that represents trades in the symbol noted in the table.
  • Date is the date on which the trade took place.
  • Firm is the Broker/Dealer who made the trade.
  • Symbol is the security that was traded.
  • Side represents whether the trade was a buy (purchase) or sell (sale) of the security.
  • Quantity is the number of shares involved in the transaction.
  • Price is the price per share.

  • Table Name: TRADES

    DATE

    FIRM

    SYMBOL

    SIDE

    QUANTITY

    PRICE

    2/3/2014

    1ABC

    A123

    B

    200

    41

    2/4/2014

    2BCD

    B234

    B

    600

    60

    2/7/2014

    1ABC

    C345

    S

    600

    70

    2/10/2014

    3CDE

    C345

    S

    600

    70

    2/12/2014

    4DEF

    B234

    B

    200

    62

    2/14/2014

    3CDE

    B234

    B

    300

    61

    2/21/2014

    1ABC

    A123

    B

    300

    40

    2/24/2014

    1ABC

    A123

    S

    300

    30

    2/25/2014

    4DEF

    C345

    B

    2100

    71

    2/27/2014

    CDE

    B234

    S

    1100

    63

    Data Observation and Description:

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!