PREVIEW / stock_daily / 2010-08-11
file: by_date/stock_daily/2010/2010-08-11.parquet size: 189 KB rows: 5,927 symbols: 3,477
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-08-11 | AAPL | Stock | 9.1214 | 9.1318 | 8.9218 | 8.9354 | 620054400.0 |
| 2010-08-11 | MSFT | Stock | 24.68 | 24.9 | 24.56 | 24.86 | 76746900.0 |
| 2010-08-11 | NVDA | Stock | 0.2263 | 0.2263 | 0.2212 | 0.222 | 796148000.0 |
| 2010-08-11 | AMZN | Stock | 6.405 | 6.406 | 6.26 | 6.2945 | 110834000.0 |
| 2010-08-11 | TSLA | Stock | 1.246 | 1.2587 | 1.19 | 1.1933 | 11964000.0 |
| 2010-08-11 | TLT | Stock | 100.31 | 101.3901 | 100.31 | 101.28 | 6778331.0 |
| 2010-08-11 | ES | Stock | 28.88 | 29.01 | 28.68 | 28.91 | 2150200.0 |
| 2010-08-11 | CL | Stock | 38.6 | 38.68 | 38.235 | 38.235 | 5965000.0 |
| 2010-08-11 | A | Stock | 20.6438 | 20.6724 | 20.0143 | 20.186 | 3952426.0 |
| 2010-08-11 | AABA-DELISTED | Stock | 14.14 | 14.2 | 13.84 | 13.86 | 13018601.0 |
| 2010-08-11 | AACC-DELISTED | Stock | 4.16 | 4.37 | 4.0 | 4.03 | 43528.0 |
| 2010-08-11 | AACG | Stock | 3.07 | 3.19 | 2.93 | 3.0 | 7900.0 |
| 2010-08-11 | AAI-DELISTED | Stock | 4.62 | 4.7 | 4.56 | 4.56 | 1867506.0 |
| 2010-08-11 | AAIC-DELISTED | Stock | 19.9 | 20.17 | 19.5714 | 19.94 | 91806.0 |
| 2010-08-11 | AAME | Stock | 1.3 | 1.3 | 1.27 | 1.27 | 1800.0 |
| 2010-08-11 | AAON | Stock | 4.6064 | 4.6202 | 4.5017 | 4.5116 | 321469.0 |
| 2010-08-11 | AAP | Stock | 52.46 | 52.48 | 51.69 | 51.91 | 1194100.0 |
| 2010-08-11 | AATI-DELISTED | Stock | 3.24 | 3.24 | 3.07 | 3.11 | 424707.0 |
| 2010-08-11 | AAU-DELISTED | Stock | 1.53 | 1.53 | 1.4 | 1.43 | 798743.0 |
| 2010-08-11 | AAUAF-DELISTED | Stock | 1.53 | 1.53 | 1.4 | 1.43 | 801143.0 |
| 2010-08-11 | AAV-DELISTED | Stock | 6.15 | 6.15 | 5.85 | 5.94 | 492110.0 |
| 2010-08-11 | AAWW-DELISTED | Stock | 47.51 | 48.17 | 46.68 | 47.23 | 445712.0 |
| 2010-08-11 | AAXJ | Stock | 55.3 | 55.48 | 54.8 | 54.8 | 248832.0 |
| 2010-08-11 | AAXN-DELISTED | Stock | 4.0 | 4.0324 | 3.92 | 3.93 | 795731.0 |
| 2010-08-11 | AB | Stock | 26.5 | 26.68 | 26.0 | 26.08 | 243700.0 |
| 2010-08-11 | ABAC-DELISTED | Stock | 3.832 | 3.99 | 3.83 | 3.83 | 6400.0 |
| 2010-08-11 | ABAX-DELISTED | Stock | 19.8 | 19.81 | 19.36 | 19.64 | 139942.0 |
| 2010-08-11 | ABB-DELISTED | Stock | 19.36 | 19.38 | 18.96 | 19.03 | 2258077.0 |
| 2010-08-11 | ABBC-DELISTED | Stock | 9.25 | 9.36 | 9.09 | 9.3 | 92223.0 |
| 2010-08-11 | ABBNY-DELISTED | Stock | 19.38 | 19.38 | 18.96 | 19.06 | 2262732.0 |
| 2010-08-11 | ABC-DELISTED | Stock | 29.54 | 29.54 | 29.05 | 29.1 | 3252476.0 |
| 2010-08-11 | ABCB | Stock | 9.17 | 9.3 | 8.73 | 8.75 | 97000.0 |
| 2010-08-11 | ABCD-DELISTED | Stock | 3.4 | 3.42 | 3.35 | 3.35 | 39744.0 |
| 2010-08-11 | ABCO-DELISTED | Stock | 22.0 | 22.34 | 21.77 | 21.94 | 328090.0 |
| 2010-08-11 | ABCW-DELISTED | Stock | 0.5818 | 0.62 | 0.5723 | 0.62 | 29350.0 |
| 2010-08-11 | ABD-DELISTED | Stock | 6.24 | 6.27 | 5.9957 | 6.03 | 567570.0 |
| 2010-08-11 | ABE-DELISTED | Stock | 17.23 | 17.23 | 16.94 | 16.94 | 9863.0 |
| 2010-08-11 | ABEO | Stock | 2437.5 | 2500.0 | 2375.0 | 2500.0 | 10.0 |
| 2010-08-11 | ABFS-DELISTED | Stock | 20.76 | 20.76 | 19.99 | 20.09 | 272365.0 |
| 2010-08-11 | ABG | Stock | 13.6 | 13.74 | 13.1 | 13.19 | 391200.0 |
| 2010-08-11 | ABII-DELISTED | Stock | 75.7 | 75.89 | 75.35 | 75.43 | 34686.0 |
| 2010-08-11 | ABK-DELISTED | Stock | 0.668 | 0.6775 | 0.65 | 0.6672 | 12653700.0 |
| 2010-08-11 | ABM | Stock | 20.67 | 20.74 | 20.09 | 20.16 | 231400.0 |
| 2010-08-11 | ABMD-DELISTED | Stock | 10.03 | 10.08 | 9.86 | 9.98 | 191355.0 |
| 2010-08-11 | ABR | Stock | 5.3 | 5.3 | 5.0 | 5.04 | 140000.0 |
| 2010-08-11 | ABT | Stock | 24.4842 | 24.5226 | 24.1195 | 24.1771 | 13175490.0 |
| 2010-08-11 | ABTL-DELISTED | Stock | 5.3215 | 5.4264 | 4.9 | 4.9 | 22564.0 |
| 2010-08-11 | ABV-DELISTED | Stock | 104.6 | 105.23 | 103.45 | 103.83 | 372106.0 |
| 2010-08-11 | ABVA-DELISTED | Stock | 2.95 | 2.95 | 2.95 | 2.95 | 100.0 |
| 2010-08-11 | ABVT-DELISTED | Stock | 52.21 | 52.21 | 51.16 | 51.45 | 149002.0 |
> showing 50 of 5,927 rows — these rows as CSV