PREVIEW / stock_daily / 2010-09-10
file: by_date/stock_daily/2010/2010-09-10.parquet size: 188 KB rows: 5,901 symbols: 3,462
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-09-10 | AAPL | Stock | 9.3996 | 9.4464 | 9.3357 | 9.4075 | 387542400.0 |
| 2010-09-10 | MSFT | Stock | 23.98 | 24.03 | 23.79 | 23.85 | 58284300.0 |
| 2010-09-10 | NVDA | Stock | 0.2563 | 0.257 | 0.2495 | 0.2518 | 609292000.0 |
| 2010-09-10 | AMZN | Stock | 7.0375 | 7.13 | 7.002 | 7.122 | 100872000.0 |
| 2010-09-10 | TSLA | Stock | 1.3833 | 1.3953 | 1.3173 | 1.3447 | 5799000.0 |
| 2010-09-10 | TLT | Stock | 102.25 | 102.7 | 101.85 | 102.32 | 6910446.0 |
| 2010-09-10 | ES | Stock | 29.27 | 29.51 | 28.96 | 29.42 | 1342000.0 |
| 2010-09-10 | CL | Stock | 37.37 | 37.7 | 37.345 | 37.59 | 7164200.0 |
| 2010-09-10 | A | Stock | 20.7082 | 20.8727 | 20.5436 | 20.6795 | 2481031.0 |
| 2010-09-10 | AABA-DELISTED | Stock | 13.7 | 13.77 | 13.54 | 13.68 | 18177792.0 |
| 2010-09-10 | AACC-DELISTED | Stock | 3.78 | 3.78 | 3.7 | 3.7 | 10551.0 |
| 2010-09-10 | AACG | Stock | 2.88 | 2.9 | 2.85 | 2.85 | 1600.0 |
| 2010-09-10 | AAI-DELISTED | Stock | 4.33 | 4.41 | 4.22 | 4.25 | 3596316.0 |
| 2010-09-10 | AAIC-DELISTED | Stock | 21.66 | 21.95 | 21.51 | 21.77 | 38481.0 |
| 2010-09-10 | AAME | Stock | 1.42 | 1.47 | 1.42 | 1.45 | 7500.0 |
| 2010-09-10 | AAON | Stock | 4.4662 | 4.5452 | 4.4405 | 4.4523 | 163519.0 |
| 2010-09-10 | AAP | Stock | 56.12 | 56.49 | 55.88 | 56.07 | 449900.0 |
| 2010-09-10 | AATI-DELISTED | Stock | 3.32 | 3.47 | 3.25 | 3.34 | 457140.0 |
| 2010-09-10 | AAU-DELISTED | Stock | 2.55 | 2.64 | 2.51 | 2.61 | 293421.0 |
| 2010-09-10 | AAUAF-DELISTED | Stock | 2.55 | 2.64 | 2.51 | 2.61 | 304121.0 |
| 2010-09-10 | AAV-DELISTED | Stock | 6.28 | 6.33 | 6.23 | 6.26 | 169803.0 |
| 2010-09-10 | AAWW-DELISTED | Stock | 47.13 | 47.13 | 45.85 | 46.0 | 210578.0 |
| 2010-09-10 | AAXJ | Stock | 56.87 | 57.18 | 56.87 | 57.11 | 283280.0 |
| 2010-09-10 | AAXN-DELISTED | Stock | 3.95 | 4.0 | 3.87 | 3.91 | 213460.0 |
| 2010-09-10 | AB | Stock | 25.2 | 25.28 | 24.93 | 25.21 | 355000.0 |
| 2010-09-10 | ABAC-DELISTED | Stock | 3.93 | 3.93 | 3.7 | 3.7 | 6450.0 |
| 2010-09-10 | ABAX-DELISTED | Stock | 19.51 | 19.51 | 18.77 | 19.26 | 51337.0 |
| 2010-09-10 | ABB-DELISTED | Stock | 20.39 | 20.46 | 20.29 | 20.37 | 1278112.0 |
| 2010-09-10 | ABBC-DELISTED | Stock | 10.39 | 10.46 | 10.28 | 10.43 | 35218.0 |
| 2010-09-10 | ABBNY-DELISTED | Stock | 20.39 | 20.46 | 20.29 | 20.37 | 1320375.0 |
| 2010-09-10 | ABC-DELISTED | Stock | 28.28 | 28.51 | 28.15 | 28.5 | 1607160.0 |
| 2010-09-10 | ABCB | Stock | 8.38 | 8.56 | 8.05 | 8.34 | 43800.0 |
| 2010-09-10 | ABCD-DELISTED | Stock | 2.97 | 3.01 | 2.89 | 2.99 | 15681.0 |
| 2010-09-10 | ABCO-DELISTED | Stock | 21.57 | 21.71 | 21.14 | 21.41 | 145081.0 |
| 2010-09-10 | ABCW-DELISTED | Stock | 0.75 | 0.75 | 0.7 | 0.7 | 85510.0 |
| 2010-09-10 | ABD-DELISTED | Stock | 6.12 | 6.2404 | 6.05 | 6.09 | 128850.0 |
| 2010-09-10 | ABE-DELISTED | Stock | 17.59 | 17.6 | 17.52 | 17.52 | 4653.0 |
| 2010-09-10 | ABEO | Stock | 2437.5 | 2500.0 | 2387.5 | 2412.5 | 21.0 |
| 2010-09-10 | ABFS-DELISTED | Stock | 22.79 | 22.8599 | 22.15 | 22.2 | 264965.0 |
| 2010-09-10 | ABG | Stock | 12.91 | 12.93 | 12.64 | 12.77 | 221200.0 |
| 2010-09-10 | ABII-DELISTED | Stock | 74.65 | 74.79 | 74.43 | 74.78 | 81368.0 |
| 2010-09-10 | ABK-DELISTED | Stock | 0.52 | 0.528 | 0.5032 | 0.508 | 3268886.0 |
| 2010-09-10 | ABM | Stock | 21.47 | 21.77 | 21.23 | 21.58 | 174900.0 |
| 2010-09-10 | ABMD-DELISTED | Stock | 9.67 | 9.98 | 9.59 | 9.83 | 173610.0 |
| 2010-09-10 | ABR | Stock | 4.58 | 4.63 | 4.53 | 4.59 | 58600.0 |
| 2010-09-10 | ABT | Stock | 24.5898 | 24.7529 | 24.513 | 24.7289 | 9255315.0 |
| 2010-09-10 | ABTL-DELISTED | Stock | 4.2512 | 4.2512 | 4.15 | 4.15 | 2945.0 |
| 2010-09-10 | ABV-DELISTED | Stock | 115.44 | 115.91 | 113.58 | 115.26 | 495142.0 |
| 2010-09-10 | ABVT-DELISTED | Stock | 52.24 | 52.64 | 51.19 | 51.35 | 190266.0 |
| 2010-09-10 | ABX-DELISTED | Stock | 43.99 | 44.96 | 43.83 | 44.76 | 4256206.0 |
> showing 50 of 5,901 rows — these rows as CSV