PREVIEW / stock_daily / 2010-09-30
file: by_date/stock_daily/2010/2010-09-30.parquet size: 193 KB rows: 5,993 symbols: 3,518
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-30 | AAPL | Stock | 10.3214 | 10.3571 | 10.0446 | 10.1339 | 673391600.0 |
| 2010-09-30 | MSFT | Stock | 24.61 | 24.83 | 24.36 | 24.49 | 61262700.0 |
| 2010-09-30 | NVDA | Stock | 0.3008 | 0.3042 | 0.2895 | 0.292 | 787632000.0 |
| 2010-09-30 | AMZN | Stock | 8.0005 | 8.0465 | 7.78 | 7.853 | 152120000.0 |
| 2010-09-30 | TSLA | Stock | 1.4667 | 1.4767 | 1.346 | 1.3607 | 32937000.0 |
| 2010-09-30 | TLT | Stock | 105.4 | 105.585 | 104.03 | 105.51 | 10618386.0 |
| 2010-09-30 | ES | Stock | 30.09 | 30.25 | 29.55 | 29.57 | 2598100.0 |
| 2010-09-30 | CL | Stock | 38.4 | 38.945 | 38.175 | 38.43 | 11758800.0 |
| 2010-09-30 | A | Stock | 23.4406 | 23.9914 | 23.3476 | 23.8698 | 8493689.0 |
| 2010-09-30 | AABA-DELISTED | Stock | 14.25 | 14.35 | 13.99 | 14.18 | 20032195.0 |
| 2010-09-30 | AACC-DELISTED | Stock | 5.14 | 5.44 | 5.1 | 5.37 | 43396.0 |
| 2010-09-30 | AACG | Stock | 2.9 | 2.96 | 2.9 | 2.96 | 2400.0 |
| 2010-09-30 | AAI-DELISTED | Stock | 7.35 | 7.35 | 7.33 | 7.34 | 12724730.0 |
| 2010-09-30 | AAIC-DELISTED | Stock | 23.17 | 23.49 | 22.58 | 23.31 | 67327.0 |
| 2010-09-30 | AAME | Stock | 1.75 | 1.75 | 1.64 | 1.64 | 3800.0 |
| 2010-09-30 | AAON | Stock | 4.7941 | 4.7941 | 4.5847 | 4.6459 | 212625.0 |
| 2010-09-30 | AAP | Stock | 59.29 | 59.51 | 58.08 | 58.68 | 1027500.0 |
| 2010-09-30 | AATI-DELISTED | Stock | 3.6 | 3.6 | 3.49 | 3.51 | 147443.0 |
| 2010-09-30 | AAU-DELISTED | Stock | 2.9 | 2.91 | 2.74 | 2.83 | 443561.0 |
| 2010-09-30 | AAUAF-DELISTED | Stock | 2.9 | 2.91 | 2.74 | 2.83 | 445246.0 |
| 2010-09-30 | AAV-DELISTED | Stock | 6.26 | 6.41 | 6.22 | 6.31 | 614570.0 |
| 2010-09-30 | AAWW-DELISTED | Stock | 54.2 | 54.48 | 50.23 | 50.29 | 783517.0 |
| 2010-09-30 | AAXJ | Stock | 60.57 | 60.87 | 60.23 | 60.51 | 526136.0 |
| 2010-09-30 | AAXN-DELISTED | Stock | 3.87 | 3.89 | 3.82 | 3.88 | 380822.0 |
| 2010-09-30 | AB | Stock | 26.3 | 26.68 | 26.29 | 26.41 | 225200.0 |
| 2010-09-30 | ABAC-DELISTED | Stock | 3.87 | 3.95 | 3.86 | 3.95 | 5165.0 |
| 2010-09-30 | ABAX-DELISTED | Stock | 23.11 | 23.4 | 22.84 | 23.09 | 110420.0 |
| 2010-09-30 | ABB-DELISTED | Stock | 21.48 | 21.53 | 21.0 | 21.13 | 2488031.0 |
| 2010-09-30 | ABBC-DELISTED | Stock | 10.54 | 10.59 | 10.4 | 10.54 | 30380.0 |
| 2010-09-30 | ABBNY-DELISTED | Stock | 21.48 | 21.53 | 21.0 | 21.12 | 2739827.0 |
| 2010-09-30 | ABC-DELISTED | Stock | 30.91 | 31.14 | 30.26 | 30.66 | 3892024.0 |
| 2010-09-30 | ABCB | Stock | 9.54 | 9.75 | 9.21 | 9.35 | 105900.0 |
| 2010-09-30 | ABCD-DELISTED | Stock | 3.28 | 3.28 | 3.19 | 3.19 | 37408.0 |
| 2010-09-30 | ABCO-DELISTED | Stock | 21.8 | 22.15 | 21.57 | 22.07 | 143858.0 |
| 2010-09-30 | ABCW-DELISTED | Stock | 0.6561 | 0.6649 | 0.6561 | 0.66 | 47680.0 |
| 2010-09-30 | ABD-DELISTED | Stock | 5.93 | 5.94 | 5.67 | 5.75 | 210150.0 |
| 2010-09-30 | ABE-DELISTED | Stock | 18.61 | 18.65 | 18.51 | 18.63 | 10228.0 |
| 2010-09-30 | ABEO | Stock | 2500.0 | 2625.0 | 2437.5 | 2437.5 | 22.0 |
| 2010-09-30 | ABFS-DELISTED | Stock | 24.42 | 25.0 | 23.9 | 24.24 | 215522.0 |
| 2010-09-30 | ABG | Stock | 14.04 | 14.16 | 13.75 | 14.07 | 271700.0 |
| 2010-09-30 | ABII-DELISTED | Stock | 76.8 | 77.33 | 76.58 | 77.33 | 37648.0 |
| 2010-09-30 | ABK-DELISTED | Stock | 0.5789 | 0.5789 | 0.552 | 0.555 | 2299301.0 |
| 2010-09-30 | ABM | Stock | 21.76 | 21.84 | 21.19 | 21.59 | 360700.0 |
| 2010-09-30 | ABMD-DELISTED | Stock | 10.4 | 10.69 | 10.22 | 10.61 | 187529.0 |
| 2010-09-30 | ABR | Stock | 4.96 | 5.06 | 4.87 | 5.04 | 96500.0 |
| 2010-09-30 | ABT | Stock | 25.1559 | 25.3622 | 24.9976 | 25.0648 | 13436223.0 |
| 2010-09-30 | ABTL-DELISTED | Stock | 4.2021 | 4.35 | 4.2021 | 4.35 | 25967.0 |
| 2010-09-30 | ABV-DELISTED | Stock | 123.9 | 124.3 | 122.65 | 123.68 | 508938.0 |
| 2010-09-30 | ABVA-DELISTED | Stock | 2.8 | 2.8 | 2.8 | 2.8 | 577.0 |
| 2010-09-30 | ABVT-DELISTED | Stock | 52.5 | 52.55 | 51.4 | 52.06 | 109484.0 |
> showing 50 of 5,993 rows — these rows as CSV