PREVIEW / stock_daily / 2007-07-03
file: by_date/stock_daily/2007/2007-07-03.parquet size: 172 KB rows: 5,340 symbols: 3,188
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 |
|---|---|---|---|---|---|---|---|
| 2007-07-03 | AAPL | Stock | 4.3571 | 4.55 | 4.3393 | 4.5418 | 1162481600.0 |
| 2007-07-03 | MSFT | Stock | 29.79 | 30.22 | 29.78 | 30.02 | 35202600.0 |
| 2007-07-03 | NVDA | Stock | 0.7167 | 0.724 | 0.7108 | 0.7183 | 238770000.0 |
| 2007-07-03 | AMZN | Stock | 3.502 | 3.5025 | 3.451 | 3.4725 | 44470000.0 |
| 2007-07-03 | TLT | Stock | 85.25 | 85.34 | 84.71 | 84.77 | 1353675.0 |
| 2007-07-03 | CL | Stock | 32.7 | 32.86 | 32.645 | 32.79 | 3900200.0 |
| 2007-07-03 | A | Stock | 28.0401 | 28.4549 | 27.9041 | 28.3834 | 2221841.0 |
| 2007-07-03 | AABA-DELISTED | Stock | 26.95 | 27.25 | 26.9 | 26.98 | 11233480.0 |
| 2007-07-03 | AACC-DELISTED | Stock | 17.65 | 17.98 | 17.61 | 17.83 | 145052.0 |
| 2007-07-03 | AAI-DELISTED | Stock | 11.25 | 11.49 | 11.24 | 11.49 | 1234900.0 |
| 2007-07-03 | AAIC-DELISTED | Stock | 110.6 | 111.4 | 108.4 | 110.0 | 715300.0 |
| 2007-07-03 | AAME | Stock | 3.99 | 3.99 | 3.88 | 3.95 | 3700.0 |
| 2007-07-03 | AAON | Stock | 4.2588 | 4.3391 | 4.2522 | 4.2891 | 202753.0 |
| 2007-07-03 | AAP | Stock | 41.21 | 41.5 | 41.2 | 41.25 | 319300.0 |
| 2007-07-03 | AATI-DELISTED | Stock | 9.95 | 9.95 | 9.7 | 9.74 | 420558.0 |
| 2007-07-03 | AAU-DELISTED | Stock | 2.24 | 2.57 | 2.24 | 2.53 | 155100.0 |
| 2007-07-03 | AAUAF-DELISTED | Stock | 2.24 | 2.57 | 2.24 | 2.53 | 155100.0 |
| 2007-07-03 | AAV-DELISTED | Stock | 14.09 | 14.15 | 13.99 | 14.06 | 271900.0 |
| 2007-07-03 | AAWW-DELISTED | Stock | 59.53 | 60.19 | 59.53 | 60.02 | 38684.0 |
| 2007-07-03 | AAXN-DELISTED | Stock | 14.42 | 14.49 | 14.18 | 14.26 | 1878539.0 |
| 2007-07-03 | AB | Stock | 88.99 | 89.64 | 88.64 | 89.32 | 142000.0 |
| 2007-07-03 | ABAX-DELISTED | Stock | 21.01 | 21.81 | 21.01 | 21.48 | 162986.0 |
| 2007-07-03 | ABB-DELISTED | Stock | 23.54 | 23.7 | 23.47 | 23.65 | 1659800.0 |
| 2007-07-03 | ABBC-DELISTED | Stock | 9.77 | 9.77 | 9.58 | 9.69 | 129523.0 |
| 2007-07-03 | ABBNY-DELISTED | Stock | 23.54 | 23.7 | 23.47 | 23.65 | 1667600.0 |
| 2007-07-03 | ABC-DELISTED | Stock | 24.98 | 25.2 | 24.96 | 25.05 | 790800.0 |
| 2007-07-03 | ABCB | Stock | 22.4874 | 22.7695 | 22.1859 | 22.5848 | 27965.0 |
| 2007-07-03 | ABCO-DELISTED | Stock | 28.39 | 28.55 | 28.34 | 28.44 | 98356.0 |
| 2007-07-03 | ABCW-DELISTED | Stock | 26.25 | 26.7 | 26.05 | 26.43 | 149070.0 |
| 2007-07-03 | ABD-DELISTED | Stock | 23.78 | 24.1 | 23.68 | 24.02 | 161200.0 |
| 2007-07-03 | ABE-DELISTED | Stock | 21.31 | 21.35 | 21.2 | 21.35 | 9300.0 |
| 2007-07-03 | ABEO | Stock | 6375.0 | 6400.0 | 6375.0 | 6375.0 | 2.0 |
| 2007-07-03 | ABFS-DELISTED | Stock | 39.33 | 39.66 | 39.02 | 39.14 | 254713.0 |
| 2007-07-03 | ABG | Stock | 25.27 | 25.33 | 24.78 | 25.29 | 163300.0 |
| 2007-07-03 | ABK-DELISTED | Stock | 87.54 | 88.41 | 87.54 | 88.04 | 387600.0 |
| 2007-07-03 | ABM | Stock | 25.88 | 26.24 | 25.67 | 25.78 | 100700.0 |
| 2007-07-03 | ABMD-DELISTED | Stock | 10.5 | 10.51 | 10.23 | 10.39 | 121897.0 |
| 2007-07-03 | ABP-DELISTED | Stock | 4.69 | 4.7 | 4.52 | 4.58 | 134800.0 |
| 2007-07-03 | ABR | Stock | 26.34 | 26.34 | 25.95 | 26.25 | 63200.0 |
| 2007-07-03 | ABT | Stock | 26.0771 | 26.1443 | 25.9668 | 26.0627 | 4027511.0 |
| 2007-07-03 | ABTL-DELISTED | Stock | 21.6 | 22.15 | 21.4 | 21.9 | 47006.0 |
| 2007-07-03 | ABV-DELISTED | Stock | 70.59 | 70.59 | 69.6 | 70.15 | 471200.0 |
| 2007-07-03 | ABVA-DELISTED | Stock | 13.111 | 13.49 | 13.1 | 13.49 | 2004.0 |
| 2007-07-03 | ABVT-DELISTED | Stock | 62.5 | 63.25 | 61.0 | 63.25 | 135032.0 |
| 2007-07-03 | ABX-DELISTED | Stock | 29.73 | 29.75 | 29.39 | 29.66 | 2214300.0 |
| 2007-07-03 | ACAD | Stock | 13.96 | 14.02 | 13.67 | 13.98 | 250600.0 |
| 2007-07-03 | ACAP-DELISTED | Stock | 40.63 | 41.03 | 40.44 | 40.88 | 19057.0 |
| 2007-07-03 | ACAS-DELISTED | Stock | 44.6 | 45.09 | 44.5 | 45.05 | 4069972.0 |
| 2007-07-03 | ACAT-DELISTED | Stock | 20.49 | 20.49 | 19.91 | 20.41 | 73092.0 |
| 2007-07-03 | ACC-DELISTED | Stock | 28.92 | 29.02 | 28.8 | 28.87 | 75795.0 |
> showing 50 of 5,340 rows — these rows as CSV