PREVIEW / stock_daily / 2010-10-06
file: by_date/stock_daily/2010/2010-10-06.parquet size: 192 KB rows: 5,976 symbols: 3,505
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-06 | AAPL | Stock | 10.3425 | 10.4282 | 10.1879 | 10.3282 | 670868800.0 |
| 2010-10-06 | MSFT | Stock | 24.32 | 24.54 | 24.13 | 24.43 | 50489700.0 |
| 2010-10-06 | NVDA | Stock | 0.283 | 0.2842 | 0.2668 | 0.2695 | 1057604000.0 |
| 2010-10-06 | AMZN | Stock | 8.03 | 8.034 | 7.73 | 7.77 | 121216000.0 |
| 2010-10-06 | TSLA | Stock | 1.404 | 1.4173 | 1.3547 | 1.364 | 4701000.0 |
| 2010-10-06 | TLT | Stock | 104.9 | 106.1 | 104.86 | 105.56 | 6476072.0 |
| 2010-10-06 | ES | Stock | 30.25 | 30.29 | 30.09 | 30.2 | 1442100.0 |
| 2010-10-06 | CL | Stock | 37.365 | 37.52 | 36.875 | 36.98 | 9862400.0 |
| 2010-10-06 | A | Stock | 23.6195 | 23.691 | 23.0973 | 23.3691 | 4522250.0 |
| 2010-10-06 | AABA-DELISTED | Stock | 14.61 | 14.7 | 14.34 | 14.52 | 20196031.0 |
| 2010-10-06 | AACC-DELISTED | Stock | 5.24 | 5.39 | 5.2 | 5.33 | 20457.0 |
| 2010-10-06 | AACG | Stock | 3.01 | 3.05 | 3.01 | 3.05 | 200.0 |
| 2010-10-06 | AAI-DELISTED | Stock | 7.35 | 7.35 | 7.33 | 7.33 | 8842630.0 |
| 2010-10-06 | AAIC-DELISTED | Stock | 23.37 | 23.52 | 23.37 | 23.42 | 24315.0 |
| 2010-10-06 | AAME | Stock | 1.69 | 1.74 | 1.69 | 1.71 | 3100.0 |
| 2010-10-06 | AAON | Stock | 4.7901 | 4.8316 | 4.7664 | 4.802 | 151369.0 |
| 2010-10-06 | AAP | Stock | 58.58 | 58.85 | 57.87 | 58.45 | 385100.0 |
| 2010-10-06 | AATI-DELISTED | Stock | 3.53 | 3.57 | 3.35 | 3.41 | 464083.0 |
| 2010-10-06 | AAU-DELISTED | Stock | 3.19 | 3.2 | 3.1 | 3.11 | 252782.0 |
| 2010-10-06 | AAUAF-DELISTED | Stock | 3.19 | 3.2 | 3.1 | 3.11 | 253947.0 |
| 2010-10-06 | AAV-DELISTED | Stock | 6.36 | 6.46 | 6.31 | 6.38 | 383296.0 |
| 2010-10-06 | AAWW-DELISTED | Stock | 51.23 | 53.09 | 51.15 | 52.0801 | 285691.0 |
| 2010-10-06 | AAXJ | Stock | 62.47 | 62.7172 | 62.4123 | 62.65 | 387915.0 |
| 2010-10-06 | AAXN-DELISTED | Stock | 3.93 | 4.1 | 3.82 | 4.01 | 749083.0 |
| 2010-10-06 | AB | Stock | 27.2 | 27.26 | 26.73 | 26.99 | 183400.0 |
| 2010-10-06 | ABAC-DELISTED | Stock | 4.29 | 4.29 | 4.26 | 4.26 | 248.0 |
| 2010-10-06 | ABAX-DELISTED | Stock | 23.16 | 23.53 | 22.95 | 23.38 | 47873.0 |
| 2010-10-06 | ABB-DELISTED | Stock | 21.66 | 21.82 | 21.63 | 21.82 | 2731970.0 |
| 2010-10-06 | ABBC-DELISTED | Stock | 10.76 | 10.832 | 10.75 | 10.79 | 56863.0 |
| 2010-10-06 | ABBNY-DELISTED | Stock | 21.66 | 21.82 | 21.63 | 21.82 | 3888078.0 |
| 2010-10-06 | ABC-DELISTED | Stock | 31.42 | 31.42 | 31.02 | 31.33 | 2641273.0 |
| 2010-10-06 | ABCB | Stock | 9.73 | 9.95 | 9.73 | 9.84 | 38300.0 |
| 2010-10-06 | ABCD-DELISTED | Stock | 3.09 | 3.1 | 3.03 | 3.06 | 25940.0 |
| 2010-10-06 | ABCO-DELISTED | Stock | 23.12 | 23.13 | 22.83 | 23.0 | 65534.0 |
| 2010-10-06 | ABCW-DELISTED | Stock | 0.69 | 0.69 | 0.68 | 0.68 | 28830.0 |
| 2010-10-06 | ABD-DELISTED | Stock | 5.89 | 5.9 | 5.7172 | 5.8 | 168870.0 |
| 2010-10-06 | ABE-DELISTED | Stock | 19.2 | 19.38 | 19.2 | 19.3215 | 9832.0 |
| 2010-10-06 | ABEO | Stock | 3000.0 | 3312.5 | 2962.5 | 3250.0 | 145.0 |
| 2010-10-06 | ABFS-DELISTED | Stock | 24.33 | 24.5 | 24.05 | 24.16 | 153315.0 |
| 2010-10-06 | ABG | Stock | 14.35 | 14.5 | 14.0 | 14.25 | 203800.0 |
| 2010-10-06 | ABII-DELISTED | Stock | 76.48 | 77.34 | 76.48 | 77.03 | 98471.0 |
| 2010-10-06 | ABK-DELISTED | Stock | 0.6006 | 0.803 | 0.5926 | 0.7799 | 57978226.0 |
| 2010-10-06 | ABM | Stock | 21.86 | 22.19 | 21.82 | 22.11 | 268100.0 |
| 2010-10-06 | ABMD-DELISTED | Stock | 11.11 | 11.35 | 10.86 | 10.92 | 160267.0 |
| 2010-10-06 | ABR | Stock | 5.17 | 5.17 | 5.04 | 5.16 | 81100.0 |
| 2010-10-06 | ABT | Stock | 25.415 | 25.535 | 25.2663 | 25.4198 | 10249062.0 |
| 2010-10-06 | ABTL-DELISTED | Stock | 4.2128 | 4.2629 | 4.0122 | 4.0372 | 211630.0 |
| 2010-10-06 | ABV-DELISTED | Stock | 129.63 | 130.55 | 128.7 | 129.87 | 772692.0 |
| 2010-10-06 | ABVA-DELISTED | Stock | 2.8501 | 2.8501 | 2.85 | 2.85 | 905.0 |
| 2010-10-06 | ABVT-DELISTED | Stock | 52.64 | 52.79 | 52.0 | 52.26 | 134502.0 |
> showing 50 of 5,976 rows — these rows as CSV