PREVIEW / stock_daily / 2009-08-14
file: by_date/stock_daily/2009/2009-08-14.parquet size: 183 KB rows: 5,778 symbols: 3,438
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 |
|---|---|---|---|---|---|---|---|
| 2009-08-14 | AAPL | Stock | 5.9979 | 6.0082 | 5.9118 | 5.9564 | 305816000.0 |
| 2009-08-14 | MSFT | Stock | 23.62 | 23.8 | 23.51 | 23.69 | 46330200.0 |
| 2009-08-14 | NVDA | Stock | 0.3453 | 0.3458 | 0.331 | 0.3355 | 427148000.0 |
| 2009-08-14 | AMZN | Stock | 4.2055 | 4.2085 | 4.139 | 4.179 | 98494000.0 |
| 2009-08-14 | TLT | Stock | 93.3 | 94.2 | 93.21 | 93.35 | 4410327.0 |
| 2009-08-14 | ES | Stock | 23.65 | 23.73 | 23.39 | 23.72 | 1399300.0 |
| 2009-08-14 | CL | Stock | 36.07 | 36.19 | 35.605 | 35.875 | 3252200.0 |
| 2009-08-14 | A | Stock | 17.5751 | 17.6896 | 16.9742 | 17.196 | 4312970.0 |
| 2009-08-14 | AABA-DELISTED | Stock | 14.98 | 15.14 | 14.85 | 15.04 | 25001768.0 |
| 2009-08-14 | AACC-DELISTED | Stock | 7.74 | 7.75 | 7.21 | 7.26 | 27321.0 |
| 2009-08-14 | AACG | Stock | 7.59 | 7.64 | 7.5 | 7.64 | 7700.0 |
| 2009-08-14 | AAI-DELISTED | Stock | 6.92 | 6.92 | 6.63 | 6.75 | 1169376.0 |
| 2009-08-14 | AAIC-DELISTED | Stock | 9.6 | 9.6 | 9.0 | 9.2 | 390046.0 |
| 2009-08-14 | AAME | Stock | 0.78 | 0.84 | 0.78 | 0.84 | 1100.0 |
| 2009-08-14 | AAON | Stock | 4.3042 | 4.3338 | 4.1896 | 4.2884 | 559912.0 |
| 2009-08-14 | AAP | Stock | 43.81 | 43.85 | 42.92 | 43.15 | 2274200.0 |
| 2009-08-14 | AATI-DELISTED | Stock | 4.76 | 4.8599 | 4.66 | 4.73 | 158267.0 |
| 2009-08-14 | AAU-DELISTED | Stock | 0.67 | 0.69 | 0.64 | 0.64 | 39937.0 |
| 2009-08-14 | AAUAF-DELISTED | Stock | 0.67 | 0.69 | 0.64 | 0.64 | 40037.0 |
| 2009-08-14 | AAV-DELISTED | Stock | 5.07 | 5.15 | 5.0 | 5.09 | 901966.0 |
| 2009-08-14 | AAWW-DELISTED | Stock | 26.89 | 27.66 | 25.25 | 25.6 | 288008.0 |
| 2009-08-14 | AAXJ | Stock | 50.3 | 50.3 | 48.97 | 49.53 | 212935.0 |
| 2009-08-14 | AAXN-DELISTED | Stock | 5.01 | 5.06 | 4.89 | 4.97 | 547257.0 |
| 2009-08-14 | AB | Stock | 21.92 | 21.92 | 21.51 | 21.85 | 327900.0 |
| 2009-08-14 | ABAX-DELISTED | Stock | 28.81 | 28.81 | 27.5 | 28.12 | 159901.0 |
| 2009-08-14 | ABB-DELISTED | Stock | 18.63 | 18.65 | 18.18 | 18.48 | 3190446.0 |
| 2009-08-14 | ABBC-DELISTED | Stock | 8.41 | 8.57 | 8.14 | 8.25 | 51385.0 |
| 2009-08-14 | ABBNY-DELISTED | Stock | 18.63 | 18.65 | 18.18 | 18.46 | 3390446.0 |
| 2009-08-14 | ABC-DELISTED | Stock | 20.6 | 20.7 | 20.21 | 20.42 | 2271476.0 |
| 2009-08-14 | ABCB | Stock | 6.4486 | 6.4584 | 6.1374 | 6.1666 | 28890.0 |
| 2009-08-14 | ABCO-DELISTED | Stock | 13.695 | 13.695 | 13.295 | 13.445 | 128974.0 |
| 2009-08-14 | ABCW-DELISTED | Stock | 1.54 | 1.62 | 1.5 | 1.6 | 54250.0 |
| 2009-08-14 | ABD-DELISTED | Stock | 4.8 | 4.92 | 4.6 | 4.76 | 282410.0 |
| 2009-08-14 | ABE-DELISTED | Stock | 16.8 | 16.8 | 16.25 | 16.348 | 7640.0 |
| 2009-08-14 | ABEO | Stock | 5062.5 | 5075.0 | 5000.0 | 5062.5 | 13.0 |
| 2009-08-14 | ABFS-DELISTED | Stock | 30.0 | 30.13 | 29.05 | 29.58 | 328642.0 |
| 2009-08-14 | ABG | Stock | 13.73 | 13.93 | 12.74 | 13.02 | 332500.0 |
| 2009-08-14 | ABII-DELISTED | Stock | 30.99 | 30.99 | 29.52 | 29.81 | 15069.0 |
| 2009-08-14 | ABK-DELISTED | Stock | 1.07 | 1.072 | 1.01 | 1.05 | 8403992.0 |
| 2009-08-14 | ABM | Stock | 21.74 | 22.09 | 21.0 | 21.37 | 153300.0 |
| 2009-08-14 | ABMD-DELISTED | Stock | 7.8 | 7.8 | 7.37 | 7.5 | 133054.0 |
| 2009-08-14 | ABR | Stock | 2.1 | 2.11 | 1.94 | 1.94 | 204700.0 |
| 2009-08-14 | ABT | Stock | 21.3511 | 21.4519 | 21.0776 | 21.2839 | 14471863.0 |
| 2009-08-14 | ABTL-DELISTED | Stock | 2.45 | 2.5 | 2.4 | 2.5 | 6541.0 |
| 2009-08-14 | ABV-DELISTED | Stock | 74.14 | 75.0 | 73.15 | 74.89 | 714901.0 |
| 2009-08-14 | ABVA-DELISTED | Stock | 2.98 | 2.98 | 2.5 | 2.5 | 400.0 |
| 2009-08-14 | ABVT-DELISTED | Stock | 92.76 | 94.92 | 92.065 | 94.25 | 124643.0 |
| 2009-08-14 | ABX-DELISTED | Stock | 34.44 | 34.66 | 33.44 | 33.89 | 6190093.0 |
| 2009-08-14 | ACAD | Stock | 6.2 | 6.49 | 6.05 | 6.22 | 2781800.0 |
| 2009-08-14 | ACAP-DELISTED | Stock | 32.67 | 32.67 | 31.3 | 32.3 | 29322.0 |
> showing 50 of 5,778 rows — these rows as CSV