PREVIEW / stock_daily / 2007-10-11
file: by_date/stock_daily/2007/2007-10-11.parquet size: 179 KB rows: 5,541 symbols: 3,343
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-10-11 | AAPL | Stock | 6.0532 | 6.1386 | 5.4718 | 5.7939 | 1643992000.0 |
| 2007-10-11 | MSFT | Stock | 30.3 | 30.63 | 29.79 | 29.91 | 50788400.0 |
| 2007-10-11 | NVDA | Stock | 0.9142 | 0.9258 | 0.8718 | 0.8818 | 529104000.0 |
| 2007-10-11 | AMZN | Stock | 4.7665 | 4.787 | 4.4065 | 4.467 | 196448000.0 |
| 2007-10-11 | TLT | Stock | 87.52 | 88.09 | 87.45 | 88.06 | 1533402.0 |
| 2007-10-11 | CL | Stock | 36.525 | 36.84 | 36.385 | 36.8 | 9430800.0 |
| 2007-10-11 | A | Stock | 27.1745 | 27.3534 | 26.6094 | 26.6738 | 2441887.0 |
| 2007-10-11 | AABA-DELISTED | Stock | 28.44 | 28.68 | 27.5 | 27.63 | 25301771.0 |
| 2007-10-11 | AACC-DELISTED | Stock | 11.62 | 11.7 | 11.17 | 11.37 | 185492.0 |
| 2007-10-11 | AAI-DELISTED | Stock | 10.42 | 10.42 | 9.99 | 10.04 | 1281400.0 |
| 2007-10-11 | AAIC-DELISTED | Stock | 96.2 | 97.0 | 94.0 | 94.4 | 1101000.0 |
| 2007-10-11 | AAME | Stock | 2.79 | 2.79 | 2.5 | 2.5 | 14800.0 |
| 2007-10-11 | AAON | Stock | 4.0869 | 4.1027 | 3.9368 | 3.9664 | 337669.0 |
| 2007-10-11 | AAP | Stock | 35.2 | 35.55 | 34.74 | 35.01 | 1246600.0 |
| 2007-10-11 | AATI-DELISTED | Stock | 12.57 | 13.08 | 12.09 | 12.12 | 1273301.0 |
| 2007-10-11 | AAU-DELISTED | Stock | 2.8 | 3.13 | 2.8 | 2.99 | 238500.0 |
| 2007-10-11 | AAUAF-DELISTED | Stock | 2.8 | 3.13 | 2.8 | 2.97 | 236300.0 |
| 2007-10-11 | AAV-DELISTED | Stock | 12.26 | 12.34 | 12.15 | 12.22 | 766600.0 |
| 2007-10-11 | AAWW-DELISTED | Stock | 54.84 | 54.84 | 53.912 | 54.21 | 92328.0 |
| 2007-10-11 | AAXN-DELISTED | Stock | 18.04 | 18.37 | 16.75 | 17.34 | 2952450.0 |
| 2007-10-11 | AB | Stock | 91.53 | 92.0 | 89.98 | 90.84 | 183100.0 |
| 2007-10-11 | ABAX-DELISTED | Stock | 25.5 | 26.1 | 24.7 | 25.0 | 260497.0 |
| 2007-10-11 | ABB-DELISTED | Stock | 27.86 | 28.08 | 27.41 | 27.55 | 3640500.0 |
| 2007-10-11 | ABBC-DELISTED | Stock | 9.73 | 9.79 | 9.6 | 9.66 | 37499.0 |
| 2007-10-11 | ABBNY-DELISTED | Stock | 27.86 | 28.08 | 27.41 | 27.62 | 3640500.0 |
| 2007-10-11 | ABC-DELISTED | Stock | 23.15 | 23.3 | 22.68 | 22.72 | 2961800.0 |
| 2007-10-11 | ABCB | Stock | 18.3343 | 18.665 | 17.6049 | 17.7021 | 52229.0 |
| 2007-10-11 | ABCO-DELISTED | Stock | 31.0 | 31.33 | 30.43 | 30.55 | 206617.0 |
| 2007-10-11 | ABCW-DELISTED | Stock | 27.77 | 27.9 | 27.04 | 27.04 | 70920.0 |
| 2007-10-11 | ABD-DELISTED | Stock | 24.74 | 25.04 | 24.17 | 24.46 | 444230.0 |
| 2007-10-11 | ABE-DELISTED | Stock | 26.5 | 27.0 | 25.93 | 26.2 | 70700.0 |
| 2007-10-11 | ABEO | Stock | 5000.0 | 5000.0 | 4900.0 | 4950.0 | 4.0 |
| 2007-10-11 | ABFS-DELISTED | Stock | 33.87 | 34.28 | 32.84 | 32.96 | 577536.0 |
| 2007-10-11 | ABG | Stock | 20.59 | 20.71 | 20.07 | 20.29 | 449000.0 |
| 2007-10-11 | ABK-DELISTED | Stock | 67.1 | 73.2 | 66.62 | 70.65 | 4618700.0 |
| 2007-10-11 | ABM | Stock | 23.4 | 24.32 | 23.3 | 24.08 | 520900.0 |
| 2007-10-11 | ABMD-DELISTED | Stock | 12.51 | 13.39 | 12.49 | 13.25 | 184920.0 |
| 2007-10-11 | ABP-DELISTED | Stock | 4.14 | 4.15 | 4.01 | 4.04 | 159700.0 |
| 2007-10-11 | ABR | Stock | 20.1 | 20.37 | 19.69 | 19.76 | 217100.0 |
| 2007-10-11 | ABT | Stock | 25.5733 | 25.7269 | 25.1607 | 25.6021 | 23585035.0 |
| 2007-10-11 | ABTL-DELISTED | Stock | 15.488 | 15.787 | 15.488 | 15.562 | 3044.0 |
| 2007-10-11 | ABV-DELISTED | Stock | 80.13 | 80.82 | 77.36 | 78.19 | 705400.0 |
| 2007-10-11 | ABVA-DELISTED | Stock | 10.0 | 10.15 | 10.0 | 10.05 | 21494.0 |
| 2007-10-11 | ABVT-DELISTED | Stock | 80.5 | 85.0 | 80.5 | 85.0 | 7640.0 |
| 2007-10-11 | ABX-DELISTED | Stock | 42.52 | 43.03 | 41.0 | 41.93 | 12185808.0 |
| 2007-10-11 | ACAD | Stock | 15.7 | 16.56 | 15.66 | 15.84 | 411900.0 |
| 2007-10-11 | ACAP-DELISTED | Stock | 41.68 | 42.33 | 40.97 | 41.29 | 35893.0 |
| 2007-10-11 | ACAS-DELISTED | Stock | 45.43 | 46.13 | 45.05 | 45.31 | 2622465.0 |
| 2007-10-11 | ACAT-DELISTED | Stock | 17.57 | 17.75 | 17.31 | 17.56 | 51325.0 |
| 2007-10-11 | ACC-DELISTED | Stock | 30.24 | 30.36 | 29.6 | 30.04 | 245800.0 |
> showing 50 of 5,541 rows — these rows as CSV