PREVIEW / stock_daily / 2009-08-21
file: by_date/stock_daily/2009/2009-08-21.parquet size: 186 KB rows: 5,840 symbols: 3,479
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-21 | AAPL | Stock | 5.9875 | 6.0489 | 5.9571 | 6.0436 | 416074400.0 |
| 2009-08-21 | MSFT | Stock | 23.93 | 24.42 | 23.77 | 24.41 | 69011400.0 |
| 2009-08-21 | NVDA | Stock | 0.3453 | 0.3488 | 0.3382 | 0.3482 | 607324000.0 |
| 2009-08-21 | AMZN | Stock | 4.239 | 4.253 | 4.177 | 4.25 | 122614000.0 |
| 2009-08-21 | TLT | Stock | 95.64 | 95.73 | 93.75 | 93.77 | 6260647.0 |
| 2009-08-21 | ES | Stock | 23.83 | 24.31 | 23.65 | 24.31 | 1586800.0 |
| 2009-08-21 | CL | Stock | 36.65 | 36.81 | 36.34 | 36.58 | 5911200.0 |
| 2009-08-21 | A | Stock | 18.3119 | 18.319 | 18.0401 | 18.2761 | 4859308.0 |
| 2009-08-21 | AABA-DELISTED | Stock | 14.93 | 14.96 | 14.73 | 14.79 | 23451858.0 |
| 2009-08-21 | AACC-DELISTED | Stock | 8.13 | 8.36 | 7.83 | 8.12 | 112043.0 |
| 2009-08-21 | AACG | Stock | 6.85 | 7.17 | 6.65 | 6.8 | 9000.0 |
| 2009-08-21 | AAI-DELISTED | Stock | 6.44 | 6.65 | 6.44 | 6.61 | 2332646.0 |
| 2009-08-21 | AAIC-DELISTED | Stock | 9.0 | 9.8 | 8.644 | 9.8 | 1070086.0 |
| 2009-08-21 | AAME | Stock | 0.82 | 0.82 | 0.78 | 0.8 | 5900.0 |
| 2009-08-21 | AAON | Stock | 4.2983 | 4.3457 | 4.239 | 4.2963 | 741656.0 |
| 2009-08-21 | AAP | Stock | 43.26 | 43.94 | 43.03 | 43.18 | 1674500.0 |
| 2009-08-21 | AATI-DELISTED | Stock | 4.75 | 4.92 | 4.69 | 4.77 | 280571.0 |
| 2009-08-21 | AAU-DELISTED | Stock | 0.61 | 0.66 | 0.61 | 0.66 | 54702.0 |
| 2009-08-21 | AAUAF-DELISTED | Stock | 0.61 | 0.66 | 0.61 | 0.66 | 55102.0 |
| 2009-08-21 | AAV-DELISTED | Stock | 5.4 | 5.67 | 5.39 | 5.61 | 1234007.0 |
| 2009-08-21 | AAWW-DELISTED | Stock | 24.16 | 24.6 | 24.06 | 24.39 | 532983.0 |
| 2009-08-21 | AAXJ | Stock | 49.24 | 49.25 | 48.74 | 49.23 | 121377.0 |
| 2009-08-21 | AAXN-DELISTED | Stock | 5.04 | 5.1 | 4.93 | 5.01 | 457939.0 |
| 2009-08-21 | AB | Stock | 21.5 | 22.0 | 20.9 | 21.06 | 676700.0 |
| 2009-08-21 | ABAX-DELISTED | Stock | 27.86 | 28.1 | 27.59 | 27.79 | 292601.0 |
| 2009-08-21 | ABB-DELISTED | Stock | 18.87 | 19.08 | 18.85 | 18.97 | 2265369.0 |
| 2009-08-21 | ABBC-DELISTED | Stock | 8.42 | 8.57 | 8.12 | 8.42 | 95499.0 |
| 2009-08-21 | ABBNY-DELISTED | Stock | 18.87 | 19.08 | 18.85 | 18.99 | 2342519.0 |
| 2009-08-21 | ABC-DELISTED | Stock | 21.14 | 21.25 | 20.9 | 21.05 | 3262261.0 |
| 2009-08-21 | ABCB | Stock | 6.6626 | 6.6626 | 6.361 | 6.5459 | 107337.0 |
| 2009-08-21 | ABCO-DELISTED | Stock | 13.682 | 13.767 | 13.448 | 13.553 | 145688.0 |
| 2009-08-21 | ABCW-DELISTED | Stock | 1.5106 | 1.531 | 1.4596 | 1.48 | 69130.0 |
| 2009-08-21 | ABD-DELISTED | Stock | 5.545 | 5.7656 | 5.4146 | 5.555 | 681440.0 |
| 2009-08-21 | ABE-DELISTED | Stock | 16.58 | 16.58 | 16.0 | 16.41 | 10701.0 |
| 2009-08-21 | ABEO | Stock | 4875.0 | 5000.0 | 4687.5 | 5000.0 | 13.0 |
| 2009-08-21 | ABFS-DELISTED | Stock | 30.47 | 31.06 | 29.77 | 30.86 | 293333.0 |
| 2009-08-21 | ABG | Stock | 13.38 | 13.56 | 13.03 | 13.31 | 401300.0 |
| 2009-08-21 | ABII-DELISTED | Stock | 28.61 | 28.81 | 27.0 | 27.82 | 66360.0 |
| 2009-08-21 | ABK-DELISTED | Stock | 1.16 | 1.22 | 1.12 | 1.13 | 15927413.0 |
| 2009-08-21 | ABM | Stock | 22.25 | 22.99 | 22.18 | 22.98 | 234400.0 |
| 2009-08-21 | ABMD-DELISTED | Stock | 8.04 | 8.32 | 8.02 | 8.14 | 265340.0 |
| 2009-08-21 | ABR | Stock | 1.83 | 1.95 | 1.77 | 1.8 | 139100.0 |
| 2009-08-21 | ABT | Stock | 21.8693 | 22.0708 | 21.7397 | 21.7781 | 17650688.0 |
| 2009-08-21 | ABTL-DELISTED | Stock | 3.35 | 3.35 | 2.8005 | 3.05 | 36351.0 |
| 2009-08-21 | ABV-DELISTED | Stock | 75.9 | 77.73 | 75.89 | 77.48 | 670411.0 |
| 2009-08-21 | ABVA-DELISTED | Stock | 2.2 | 2.41 | 2.0 | 2.2 | 5636.0 |
| 2009-08-21 | ABVT-DELISTED | Stock | 93.54 | 94.69 | 92.3 | 93.12 | 67787.0 |
| 2009-08-21 | ABX-DELISTED | Stock | 34.95 | 35.08 | 34.55 | 34.71 | 5994100.0 |
| 2009-08-21 | ACAD | Stock | 5.79 | 5.96 | 5.31 | 5.64 | 2155700.0 |
| 2009-08-21 | ACAP-DELISTED | Stock | 31.72 | 32.179 | 30.86 | 31.71 | 52837.0 |
> showing 50 of 5,840 rows — these rows as CSV