PREVIEW / stock_daily / 2010-10-04
file: by_date/stock_daily/2010/2010-10-04.parquet size: 191 KB rows: 5,968 symbols: 3,506
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 |
|---|---|---|---|---|---|---|---|
| 2010-10-04 | AAPL | Stock | 10.0571 | 10.1036 | 9.9204 | 9.9514 | 435302000.0 |
| 2010-10-04 | MSFT | Stock | 23.96 | 23.99 | 23.78 | 23.91 | 98143400.0 |
| 2010-10-04 | NVDA | Stock | 0.281 | 0.2858 | 0.2752 | 0.281 | 749500000.0 |
| 2010-10-04 | AMZN | Stock | 7.6975 | 7.798 | 7.6395 | 7.7695 | 106930000.0 |
| 2010-10-04 | TSLA | Stock | 1.362 | 1.4113 | 1.3533 | 1.3993 | 9654000.0 |
| 2010-10-04 | TLT | Stock | 104.62 | 104.93 | 104.41 | 104.9 | 4422639.0 |
| 2010-10-04 | ES | Stock | 29.73 | 30.08 | 29.69 | 29.81 | 1160900.0 |
| 2010-10-04 | CL | Stock | 38.23 | 38.62 | 38.125 | 38.21 | 5963200.0 |
| 2010-10-04 | A | Stock | 24.0057 | 24.0415 | 23.1617 | 23.3119 | 6835801.0 |
| 2010-10-04 | AABA-DELISTED | Stock | 14.2 | 14.32 | 14.13 | 14.27 | 20342912.0 |
| 2010-10-04 | AACC-DELISTED | Stock | 5.56 | 5.59 | 5.09 | 5.16 | 41036.0 |
| 2010-10-04 | AACG | Stock | 3.02 | 3.02 | 3.01 | 3.01 | 3100.0 |
| 2010-10-04 | AAI-DELISTED | Stock | 7.33 | 7.37 | 7.32 | 7.33 | 4219754.0 |
| 2010-10-04 | AAIC-DELISTED | Stock | 23.46 | 23.51 | 22.95 | 23.05 | 34245.0 |
| 2010-10-04 | AAME | Stock | 1.65 | 1.65 | 1.43 | 1.48 | 44800.0 |
| 2010-10-04 | AAON | Stock | 4.638 | 4.638 | 4.5254 | 4.563 | 93150.0 |
| 2010-10-04 | AAP | Stock | 58.4 | 58.64 | 57.22 | 57.78 | 983800.0 |
| 2010-10-04 | AATI-DELISTED | Stock | 3.48 | 3.48 | 3.38 | 3.44 | 151813.0 |
| 2010-10-04 | AAU-DELISTED | Stock | 3.07 | 3.27 | 3.06 | 3.11 | 483550.0 |
| 2010-10-04 | AAUAF-DELISTED | Stock | 3.07 | 3.27 | 3.06 | 3.11 | 486528.0 |
| 2010-10-04 | AAV-DELISTED | Stock | 6.37 | 6.42 | 6.29 | 6.35 | 226952.0 |
| 2010-10-04 | AAWW-DELISTED | Stock | 50.09 | 50.56 | 48.37 | 49.37 | 442484.0 |
| 2010-10-04 | AAXJ | Stock | 61.74 | 61.8 | 61.31 | 61.68 | 678933.0 |
| 2010-10-04 | AAXN-DELISTED | Stock | 3.9 | 3.93 | 3.61 | 3.61 | 1068513.0 |
| 2010-10-04 | AB | Stock | 26.45 | 26.95 | 26.41 | 26.42 | 285400.0 |
| 2010-10-04 | ABAC-DELISTED | Stock | 4.3 | 4.55 | 4.03 | 4.05 | 34198.0 |
| 2010-10-04 | ABAX-DELISTED | Stock | 23.17 | 23.28 | 22.65 | 22.78 | 128891.0 |
| 2010-10-04 | ABB-DELISTED | Stock | 21.2 | 21.3025 | 20.88 | 21.0 | 1883443.0 |
| 2010-10-04 | ABBC-DELISTED | Stock | 10.6 | 10.6 | 10.47 | 10.58 | 37324.0 |
| 2010-10-04 | ABBNY-DELISTED | Stock | 21.2 | 21.3025 | 20.88 | 21.01 | 1920067.0 |
| 2010-10-04 | ABC-DELISTED | Stock | 30.81 | 30.97 | 30.55 | 30.75 | 3102476.0 |
| 2010-10-04 | ABCB | Stock | 9.34 | 9.54 | 9.26 | 9.47 | 45300.0 |
| 2010-10-04 | ABCD-DELISTED | Stock | 3.15 | 3.2 | 3.08 | 3.1 | 15231.0 |
| 2010-10-04 | ABCO-DELISTED | Stock | 23.17 | 23.35 | 22.8 | 22.86 | 170994.0 |
| 2010-10-04 | ABCW-DELISTED | Stock | 0.6599 | 0.6696 | 0.6599 | 0.66 | 29860.0 |
| 2010-10-04 | ABD-DELISTED | Stock | 5.9 | 5.9 | 5.52 | 5.62 | 232170.0 |
| 2010-10-04 | ABE-DELISTED | Stock | 18.64 | 18.79 | 18.64 | 18.72 | 2397.0 |
| 2010-10-04 | ABEO | Stock | 2700.0 | 2700.0 | 2625.0 | 2687.5 | 17.0 |
| 2010-10-04 | ABFS-DELISTED | Stock | 23.63 | 23.95 | 23.26 | 23.4 | 185142.0 |
| 2010-10-04 | ABG | Stock | 14.3 | 14.45 | 13.67 | 13.73 | 157300.0 |
| 2010-10-04 | ABII-DELISTED | Stock | 76.59 | 77.4 | 76.19 | 76.4 | 60522.0 |
| 2010-10-04 | ABK-DELISTED | Stock | 0.56 | 0.567 | 0.5453 | 0.5504 | 2743418.0 |
| 2010-10-04 | ABM | Stock | 21.58 | 21.7 | 21.35 | 21.47 | 401200.0 |
| 2010-10-04 | ABMD-DELISTED | Stock | 10.59 | 10.77 | 10.52 | 10.74 | 142233.0 |
| 2010-10-04 | ABR | Stock | 4.97 | 5.1 | 4.89 | 5.1 | 77800.0 |
| 2010-10-04 | ABT | Stock | 25.2231 | 25.3862 | 25.0312 | 25.1943 | 11171947.0 |
| 2010-10-04 | ABTL-DELISTED | Stock | 4.2913 | 4.3817 | 4.2401 | 4.25 | 6297.0 |
| 2010-10-04 | ABV-DELISTED | Stock | 124.82 | 126.49 | 124.8 | 125.89 | 502155.0 |
| 2010-10-04 | ABVA-DELISTED | Stock | 2.83 | 2.886 | 2.8 | 2.81 | 1500.0 |
| 2010-10-04 | ABVT-DELISTED | Stock | 52.48 | 52.98 | 52.33 | 52.81 | 100915.0 |
> showing 50 of 5,968 rows — these rows as CSV