PREVIEW / stock_daily / 2010-03-04
file: by_date/stock_daily/2010/2010-03-04.parquet size: 189 KB rows: 5,894 symbols: 3,481
schema
date DATE symbol VARCHAR asset_type VARCHAR open DOUBLE high DOUBLE low DOUBLE close DOUBLE volume DOUBLE
sample rows
| date | symbol | asset_type | open | high | low | close | volume |
|---|---|---|---|---|---|---|---|
| 2010-03-04 | AAPL | Stock | 7.4743 | 7.5329 | 7.4511 | 7.5254 | 366041200.0 |
| 2010-03-04 | MSFT | Stock | 28.46 | 28.65 | 28.27 | 28.63 | 42890600.0 |
| 2010-03-04 | NVDA | Stock | 0.4175 | 0.4208 | 0.4112 | 0.4165 | 557396000.0 |
| 2010-03-04 | AMZN | Stock | 6.299 | 6.4425 | 6.2785 | 6.4265 | 150194000.0 |
| 2010-03-04 | TLT | Stock | 90.96 | 91.68 | 90.83 | 91.47 | 2374728.0 |
| 2010-03-04 | ES | Stock | 26.16 | 26.27 | 26.08 | 26.26 | 922100.0 |
| 2010-03-04 | CL | Stock | 41.96 | 42.32 | 41.78 | 42.08 | 3954800.0 |
| 2010-03-04 | A | Stock | 23.2189 | 23.2189 | 22.7754 | 23.0758 | 6100173.0 |
| 2010-03-04 | AABA-DELISTED | Stock | 15.6 | 15.85 | 15.52 | 15.8 | 20549113.0 |
| 2010-03-04 | AACC-DELISTED | Stock | 5.15 | 5.65 | 5.15 | 5.65 | 59638.0 |
| 2010-03-04 | AACG | Stock | 3.73 | 3.74 | 3.64 | 3.64 | 36600.0 |
| 2010-03-04 | AAI-DELISTED | Stock | 5.09 | 5.11 | 5.02 | 5.05 | 1538884.0 |
| 2010-03-04 | AAIC-DELISTED | Stock | 18.31 | 18.6 | 17.99 | 18.51 | 25946.0 |
| 2010-03-04 | AAON | Stock | 4.2686 | 4.2963 | 4.2232 | 4.2607 | 142762.0 |
| 2010-03-04 | AAP | Stock | 41.63 | 42.0 | 41.6 | 41.78 | 1159700.0 |
| 2010-03-04 | AATI-DELISTED | Stock | 3.46 | 3.47 | 3.35 | 3.37 | 279152.0 |
| 2010-03-04 | AAU-DELISTED | Stock | 0.91 | 0.97 | 0.91 | 0.94 | 81992.0 |
| 2010-03-04 | AAUAF-DELISTED | Stock | 0.91 | 0.97 | 0.91 | 0.94 | 90349.0 |
| 2010-03-04 | AAV-DELISTED | Stock | 7.1 | 7.17 | 6.99 | 7.15 | 394695.0 |
| 2010-03-04 | AAWW-DELISTED | Stock | 46.71 | 49.2 | 44.44 | 49.1 | 1062218.0 |
| 2010-03-04 | AAXJ | Stock | 53.95 | 53.95 | 53.41 | 53.73 | 126833.0 |
| 2010-03-04 | AAXN-DELISTED | Stock | 6.92 | 7.02 | 6.68 | 6.78 | 1507586.0 |
| 2010-03-04 | AB | Stock | 27.94 | 28.0 | 27.42 | 27.71 | 409600.0 |
| 2010-03-04 | ABAX-DELISTED | Stock | 26.23 | 26.27 | 25.92 | 25.99 | 95104.0 |
| 2010-03-04 | ABB-DELISTED | Stock | 20.78 | 20.8793 | 20.65 | 20.77 | 2132872.0 |
| 2010-03-04 | ABBC-DELISTED | Stock | 7.95 | 8.2 | 7.95 | 8.16 | 126387.0 |
| 2010-03-04 | ABBNY-DELISTED | Stock | 20.78 | 20.8793 | 20.65 | 20.76 | 2524432.0 |
| 2010-03-04 | ABC-DELISTED | Stock | 28.16 | 28.16 | 27.91 | 27.96 | 2653663.0 |
| 2010-03-04 | ABCB | Stock | 10.1235 | 10.1531 | 9.8568 | 9.8767 | 15491.0 |
| 2010-03-04 | ABCD-DELISTED | Stock | 3.65 | 3.69 | 3.55 | 3.6 | 500831.0 |
| 2010-03-04 | ABCO-DELISTED | Stock | 16.15 | 16.2 | 15.905 | 15.925 | 180596.0 |
| 2010-03-04 | ABCW-DELISTED | Stock | 1.21 | 1.21 | 1.16 | 1.18 | 40700.0 |
| 2010-03-04 | ABD-DELISTED | Stock | 7.9 | 7.99 | 7.71 | 7.8 | 121720.0 |
| 2010-03-04 | ABE-DELISTED | Stock | 16.32 | 16.32 | 16.13 | 16.192 | 7564.0 |
| 2010-03-04 | ABEO | Stock | 3225.0 | 3312.5 | 3187.5 | 3312.5 | 22.0 |
| 2010-03-04 | ABFS-DELISTED | Stock | 27.15 | 27.21 | 26.44 | 26.91 | 439942.0 |
| 2010-03-04 | ABG | Stock | 12.3 | 12.59 | 12.28 | 12.52 | 262800.0 |
| 2010-03-04 | ABII-DELISTED | Stock | 34.69 | 35.15 | 34.27 | 34.89 | 64840.0 |
| 2010-03-04 | ABK-DELISTED | Stock | 0.68 | 0.69 | 0.6721 | 0.6813 | 4218166.0 |
| 2010-03-04 | ABM | Stock | 19.77 | 19.81 | 19.46 | 19.75 | 242500.0 |
| 2010-03-04 | ABMD-DELISTED | Stock | 10.53 | 10.75 | 10.45 | 10.62 | 130656.0 |
| 2010-03-04 | ABR | Stock | 2.48 | 2.5 | 2.44 | 2.45 | 88900.0 |
| 2010-03-04 | ABT | Stock | 26.1443 | 26.1491 | 25.866 | 25.9476 | 13258858.0 |
| 2010-03-04 | ABTL-DELISTED | Stock | 5.4003 | 5.4003 | 5.2002 | 5.3997 | 860.0 |
| 2010-03-04 | ABV-DELISTED | Stock | 100.45 | 100.45 | 97.48 | 98.42 | 361584.0 |
| 2010-03-04 | ABVT-DELISTED | Stock | 62.96 | 63.12 | 61.52 | 61.6 | 99593.0 |
| 2010-03-04 | ABX-DELISTED | Stock | 40.11 | 40.33 | 39.34 | 39.78 | 11380350.0 |
| 2010-03-04 | ACAD | Stock | 1.4 | 1.41 | 1.35 | 1.35 | 285600.0 |
| 2010-03-04 | ACAP-DELISTED | Stock | 30.5 | 30.57 | 30.24 | 30.47 | 23761.0 |
| 2010-03-04 | ACAS-DELISTED | Stock | 4.18 | 4.32 | 4.15 | 4.31 | 3048861.0 |
> showing 50 of 5,894 rows — these rows as CSV