PREVIEW / stock_daily / 2006-07-05
file: by_date/stock_daily/2006/2006-07-05.parquet size: 148 KB rows: 4,445 symbols: 2,806
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 |
|---|---|---|---|---|---|---|---|
| 2006-07-05 | AAPL | Stock | 2.0411 | 2.0571 | 2.02 | 2.0357 | 518240800.0 |
| 2006-07-05 | MSFT | Stock | 23.48 | 23.52 | 23.3 | 23.35 | 53093500.0 |
| 2006-07-05 | NVDA | Stock | 0.3543 | 0.3575 | 0.3438 | 0.3438 | 459708000.0 |
| 2006-07-05 | AMZN | Stock | 1.914 | 1.9215 | 1.839 | 1.8555 | 114680000.0 |
| 2006-07-05 | CL | Stock | 29.91 | 29.965 | 29.455 | 29.885 | 4898400.0 |
| 2006-07-05 | A | Stock | 22.6538 | 22.711 | 22.2103 | 22.4106 | 3467040.0 |
| 2006-07-05 | AABA-DELISTED | Stock | 32.8499984741211 | 32.9900016784668 | 32.3300018310547 | 32.4700012207031 | 13453900.0 |
| 2006-07-05 | AACC-DELISTED | Stock | 19.75 | 19.82 | 18.88 | 18.96 | 93090.0 |
| 2006-07-05 | AAI-DELISTED | Stock | 14.75 | 14.95 | 14.3 | 14.72 | 875600.0 |
| 2006-07-05 | AAIC-DELISTED | Stock | 224.0 | 226.2 | 221.4 | 221.6 | 1120900.0 |
| 2006-07-05 | AAME | Stock | 3.05 | 3.05 | 3.05 | 3.05 | 500.0 |
| 2006-07-05 | AAON | Stock | 3.4765 | 3.5477 | 3.4028 | 3.5292 | 170859.0 |
| 2006-07-05 | AAP | Stock | 29.53 | 29.84 | 29.15 | 29.5 | 2013000.0 |
| 2006-07-05 | AATI-DELISTED | Stock | 10.33 | 10.41 | 9.8 | 9.82 | 125757.0 |
| 2006-07-05 | AAU-DELISTED | Stock | 2.39 | 2.39 | 2.21 | 2.25 | 39600.0 |
| 2006-07-05 | AAUAF-DELISTED | Stock | 2.39 | 2.39 | 2.21 | 2.25 | 39600.0 |
| 2006-07-05 | AAV-DELISTED | Stock | 17.08 | 17.3 | 17.0 | 17.11 | 692700.0 |
| 2006-07-05 | AAWW-DELISTED | Stock | 49.24 | 50.0 | 48.32 | 48.85 | 112195.0 |
| 2006-07-05 | AAXN-DELISTED | Stock | 8.30000019073486 | 8.34000015258789 | 8.02999973297119 | 8.10999965667725 | 523900.0 |
| 2006-07-05 | AB | Stock | 60.5 | 61.03 | 60.22 | 60.9 | 108600.0 |
| 2006-07-05 | ABAX-DELISTED | Stock | 22.52 | 22.59 | 21.16 | 21.42 | 334469.0 |
| 2006-07-05 | ABB-DELISTED | Stock | 12.73 | 12.7499 | 12.52 | 12.63 | 2127800.0 |
| 2006-07-05 | ABBC-DELISTED | Stock | 14.6 | 14.85 | 14.28 | 14.48 | 33468.0 |
| 2006-07-05 | ABC-DELISTED | Stock | 20.75 | 20.8 | 20.54 | 20.6 | 2707000.0 |
| 2006-07-05 | ABCB | Stock | 21.8552 | 22.3124 | 21.4176 | 22.079 | 20048.0 |
| 2006-07-05 | ABCO-DELISTED | Stock | 23.59 | 23.88 | 23.27 | 23.75 | 159727.0 |
| 2006-07-05 | ABCW-DELISTED | Stock | 29.8 | 30.49 | 29.61 | 30.16 | 42500.0 |
| 2006-07-05 | ABD-DELISTED | Stock | 22.15 | 22.5 | 22.0 | 22.27 | 322800.0 |
| 2006-07-05 | ABE-DELISTED | Stock | 12.27 | 12.27 | 12.1 | 12.1 | 7000.0 |
| 2006-07-05 | ABFS-DELISTED | Stock | 50.36 | 50.4944 | 49.25 | 50.15 | 304006.0 |
| 2006-07-05 | ABG | Stock | 20.35 | 20.96 | 20.25 | 20.64 | 122000.0 |
| 2006-07-05 | ABK-DELISTED | Stock | 81.85 | 82.18 | 80.94 | 81.32 | 610100.0 |
| 2006-07-05 | ABM | Stock | 17.0 | 17.0 | 16.52 | 16.75 | 313600.0 |
| 2006-07-05 | ABMD-DELISTED | Stock | 12.64 | 13.0 | 12.48 | 13.0 | 58266.0 |
| 2006-07-05 | ABP-DELISTED | Stock | 4.55 | 4.86 | 4.43 | 4.8 | 312000.0 |
| 2006-07-05 | ABR | Stock | 25.39 | 25.42 | 24.94 | 25.19 | 136500.0 |
| 2006-07-05 | ABT | Stock | 20.8233 | 21.1112 | 20.7514 | 20.9241 | 9005419.0 |
| 2006-07-05 | ABTL-DELISTED | Stock | 15.694 | 16.05 | 15.491 | 16.05 | 85331.0 |
| 2006-07-05 | ABV-DELISTED | Stock | 42.1 | 42.29 | 41.24 | 41.25 | 788700.0 |
| 2006-07-05 | ABVA-DELISTED | Stock | 16.43 | 16.5 | 16.4 | 16.4 | 2862.0 |
| 2006-07-05 | ABX-DELISTED | Stock | 30.55 | 30.62 | 29.52 | 30.04 | 3368900.0 |
| 2006-07-05 | ACAD | Stock | 8.49 | 8.6 | 8.33 | 8.35 | 92700.0 |
| 2006-07-05 | ACAP-DELISTED | Stock | 50.64 | 50.69 | 50.1 | 50.67 | 46180.0 |
| 2006-07-05 | ACAS-DELISTED | Stock | 33.98 | 34.0 | 33.57 | 33.65 | 618745.0 |
| 2006-07-05 | ACAT-DELISTED | Stock | 18.9 | 18.9 | 17.96 | 18.16 | 77258.0 |
| 2006-07-05 | ACC-DELISTED | Stock | 25.05 | 25.19 | 24.7 | 24.87 | 51144.0 |
| 2006-07-05 | ACCL-DELISTED | Stock | 6.92 | 7.1 | 6.89 | 7.05 | 56754.0 |
| 2006-07-05 | ACCO | Stock | 22.15 | 22.5 | 22.0 | 22.27 | 341800.0 |
| 2006-07-05 | ACCP-DELISTED | Stock | 1.3 | 1.3 | 1.25 | 1.25 | 1307.0 |
| 2006-07-05 | ACE-DELISTED | Stock | 50.9 | 51.2 | 49.39 | 49.47 | 1566500.0 |
> showing 50 of 4,445 rows — these rows as CSV