PREVIEW / stock_daily / 2010-10-28
file: by_date/stock_daily/2010/2010-10-28.parquet size: 192 KB rows: 5,974 symbols: 3,495
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-28 | AAPL | Stock | 10.9982 | 11.0 | 10.7464 | 10.9014 | 551051200.0 |
| 2010-10-28 | MSFT | Stock | 26.21 | 26.38 | 25.92 | 26.28 | 80730300.0 |
| 2010-10-28 | NVDA | Stock | 0.305 | 0.306 | 0.2985 | 0.3012 | 704448000.0 |
| 2010-10-28 | AMZN | Stock | 8.4155 | 8.4245 | 8.2525 | 8.342 | 93688000.0 |
| 2010-10-28 | TSLA | Stock | 1.426 | 1.4333 | 1.3973 | 1.4127 | 3363000.0 |
| 2010-10-28 | TLT | Stock | 99.58 | 99.83 | 99.16 | 99.49 | 8052596.0 |
| 2010-10-28 | ES | Stock | 31.2 | 31.33 | 31.03 | 31.2 | 1964100.0 |
| 2010-10-28 | CL | Stock | 37.95 | 38.0 | 37.195 | 37.46 | 15811800.0 |
| 2010-10-28 | A | Stock | 25.1288 | 25.2718 | 24.6209 | 24.9785 | 3349608.0 |
| 2010-10-28 | AABA-DELISTED | Stock | 16.45 | 16.46 | 16.31 | 16.4 | 12552522.0 |
| 2010-10-28 | AACC-DELISTED | Stock | 5.67 | 5.67 | 5.44 | 5.59 | 21612.0 |
| 2010-10-28 | AACG | Stock | 3.35 | 3.35 | 3.17 | 3.21 | 8200.0 |
| 2010-10-28 | AAI-DELISTED | Stock | 7.44 | 7.48 | 7.39 | 7.4 | 13706862.0 |
| 2010-10-28 | AAIC-DELISTED | Stock | 23.21 | 23.4101 | 22.71 | 22.74 | 29907.0 |
| 2010-10-28 | AAME | Stock | 1.71 | 1.75 | 1.61 | 1.75 | 3600.0 |
| 2010-10-28 | AAON | Stock | 4.9007 | 4.9007 | 4.8158 | 4.8751 | 235912.0 |
| 2010-10-28 | AAP | Stock | 62.19 | 64.31 | 62.04 | 63.88 | 1540200.0 |
| 2010-10-28 | AATI-DELISTED | Stock | 3.83 | 3.84 | 3.77 | 3.78 | 183858.0 |
| 2010-10-28 | AAU-DELISTED | Stock | 2.83 | 2.9 | 2.83 | 2.88 | 234085.0 |
| 2010-10-28 | AAUAF-DELISTED | Stock | 2.83 | 2.9 | 2.83 | 2.88 | 234335.0 |
| 2010-10-28 | AAV-DELISTED | Stock | 6.08 | 6.19 | 6.04 | 6.15 | 277838.0 |
| 2010-10-28 | AAWW-DELISTED | Stock | 55.4 | 55.5 | 52.92 | 53.45 | 204910.0 |
| 2010-10-28 | AAXJ | Stock | 62.12 | 62.27 | 61.9 | 62.13 | 335250.0 |
| 2010-10-28 | AAXN-DELISTED | Stock | 4.15 | 4.16 | 3.93 | 3.95 | 699192.0 |
| 2010-10-28 | AB | Stock | 25.46 | 25.73 | 24.5 | 25.01 | 1100700.0 |
| 2010-10-28 | ABAC-DELISTED | Stock | 5.85 | 6.04 | 5.65 | 5.86 | 47550.0 |
| 2010-10-28 | ABAX-DELISTED | Stock | 23.66 | 23.871 | 23.53 | 23.73 | 95591.0 |
| 2010-10-28 | ABB-DELISTED | Stock | 21.14 | 21.1699 | 20.75 | 21.0 | 3543298.0 |
| 2010-10-28 | ABBC-DELISTED | Stock | 10.75 | 10.75 | 10.62 | 10.72 | 20491.0 |
| 2010-10-28 | ABBNY-DELISTED | Stock | 21.14 | 21.1699 | 20.75 | 21.01 | 3552956.0 |
| 2010-10-28 | ABC-DELISTED | Stock | 33.44 | 33.83 | 32.94 | 33.4 | 3114083.0 |
| 2010-10-28 | ABCB | Stock | 9.35 | 9.35 | 9.17 | 9.28 | 33200.0 |
| 2010-10-28 | ABCD-DELISTED | Stock | 3.11 | 3.11 | 2.98 | 3.0 | 13814.0 |
| 2010-10-28 | ABCO-DELISTED | Stock | 23.71 | 23.71 | 23.28 | 23.45 | 44201.0 |
| 2010-10-28 | ABCW-DELISTED | Stock | 0.66 | 0.7 | 0.66 | 0.68 | 30740.0 |
| 2010-10-28 | ABD-DELISTED | Stock | 6.36 | 6.37 | 6.1 | 6.23 | 427720.0 |
| 2010-10-28 | ABE-DELISTED | Stock | 18.96 | 18.96 | 18.81 | 18.8501 | 11122.0 |
| 2010-10-28 | ABEO | Stock | 3787.5 | 3787.5 | 3700.0 | 3750.0 | 9.0 |
| 2010-10-28 | ABFS-DELISTED | Stock | 25.59 | 26.24 | 24.83 | 25.26 | 170565.0 |
| 2010-10-28 | ABG | Stock | 14.55 | 14.56 | 14.12 | 14.38 | 209600.0 |
| 2010-10-28 | ABK-DELISTED | Stock | 0.9497 | 0.95 | 0.9 | 0.9021 | 8051309.0 |
| 2010-10-28 | ABM | Stock | 22.76 | 22.92 | 22.4 | 22.56 | 123300.0 |
| 2010-10-28 | ABMD-DELISTED | Stock | 10.64 | 10.64 | 10.255 | 10.3 | 102746.0 |
| 2010-10-28 | ABR | Stock | 5.25 | 5.42 | 5.15 | 5.28 | 61300.0 |
| 2010-10-28 | ABT | Stock | 24.8728 | 25.012 | 24.6425 | 24.8296 | 13601709.0 |
| 2010-10-28 | ABTL-DELISTED | Stock | 4.0002 | 4.0002 | 3.8998 | 3.8998 | 105479.0 |
| 2010-10-28 | ABV-DELISTED | Stock | 135.44 | 136.36 | 134.86 | 135.59 | 645408.0 |
| 2010-10-28 | ABVA-DELISTED | Stock | 2.7 | 2.7 | 2.7 | 2.7 | 230.0 |
| 2010-10-28 | ABVT-DELISTED | Stock | 56.06 | 56.41 | 55.3 | 56.0 | 42717.0 |
| 2010-10-28 | ABX-DELISTED | Stock | 46.43 | 47.23 | 45.67 | 47.03 | 9662212.0 |
> showing 50 of 5,974 rows — these rows as CSV