PREVIEW / stock_daily / 2010-11-10
file: by_date/stock_daily/2010/2010-11-10.parquet size: 194 KB rows: 6,028 symbols: 3,535
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-11-10 | AAPL | Stock | 11.3086 | 11.3846 | 11.1982 | 11.3582 | 384227200.0 |
| 2010-11-10 | MSFT | Stock | 27.01 | 27.08 | 26.81 | 26.94 | 52277300.0 |
| 2010-11-10 | NVDA | Stock | 0.317 | 0.3185 | 0.3125 | 0.3185 | 521016000.0 |
| 2010-11-10 | AMZN | Stock | 8.5295 | 8.6685 | 8.4705 | 8.6665 | 108806000.0 |
| 2010-11-10 | TSLA | Stock | 1.632 | 1.998 | 1.6033 | 1.9573 | 45907500.0 |
| 2010-11-10 | TLT | Stock | 96.35 | 96.74 | 95.0 | 96.38 | 18540491.0 |
| 2010-11-10 | ES | Stock | 31.25 | 31.35 | 30.97 | 31.33 | 1478100.0 |
| 2010-11-10 | CL | Stock | 38.59 | 38.59 | 38.215 | 38.47 | 3476800.0 |
| 2010-11-10 | A | Stock | 25.3648 | 25.5079 | 24.9571 | 25.2217 | 4641220.0 |
| 2010-11-10 | AABA-DELISTED | Stock | 16.96 | 17.01 | 16.75 | 16.93 | 16602571.0 |
| 2010-11-10 | AACC-DELISTED | Stock | 5.81 | 5.81 | 5.6 | 5.68 | 14290.0 |
| 2010-11-10 | AACG | Stock | 3.35 | 4.19 | 3.35 | 3.87 | 47200.0 |
| 2010-11-10 | AAI-DELISTED | Stock | 7.43 | 7.45 | 7.41 | 7.41 | 3978765.0 |
| 2010-11-10 | AAIC-DELISTED | Stock | 24.86 | 25.14 | 24.54 | 25.02 | 37312.0 |
| 2010-11-10 | AAME | Stock | 1.85 | 1.85 | 1.79 | 1.79 | 1700.0 |
| 2010-11-10 | AAON | Stock | 4.9126 | 5.0212 | 4.9047 | 5.0114 | 268819.0 |
| 2010-11-10 | AAP | Stock | 66.42 | 67.27 | 66.08 | 66.72 | 2165100.0 |
| 2010-11-10 | AATI-DELISTED | Stock | 3.72 | 3.9 | 3.62 | 3.86 | 330783.0 |
| 2010-11-10 | AAU-DELISTED | Stock | 2.74 | 2.9 | 2.69 | 2.82 | 506498.0 |
| 2010-11-10 | AAUAF-DELISTED | Stock | 2.8 | 2.96 | 2.75 | 2.82 | 496649.0 |
| 2010-11-10 | AAV-DELISTED | Stock | 6.55 | 6.75 | 6.49 | 6.67 | 424228.0 |
| 2010-11-10 | AAWW-DELISTED | Stock | 59.25 | 60.1499 | 58.3 | 59.28 | 132916.0 |
| 2010-11-10 | AAXJ | Stock | 65.22 | 65.32 | 64.5619 | 65.25 | 477920.0 |
| 2010-11-10 | AAXN-DELISTED | Stock | 4.2 | 4.2147 | 4.13 | 4.18 | 172185.0 |
| 2010-11-10 | AB | Stock | 24.71 | 24.97 | 24.31 | 24.73 | 331300.0 |
| 2010-11-10 | ABAC-DELISTED | Stock | 7.2 | 7.7191 | 7.02 | 7.15 | 181892.0 |
| 2010-11-10 | ABAX-DELISTED | Stock | 25.86 | 26.48 | 25.7 | 26.35 | 163010.0 |
| 2010-11-10 | ABB-DELISTED | Stock | 21.26 | 21.29 | 20.99 | 21.24 | 2359153.0 |
| 2010-11-10 | ABBC-DELISTED | Stock | 12.25 | 12.27 | 12.0 | 12.11 | 142214.0 |
| 2010-11-10 | ABBNY-DELISTED | Stock | 21.26 | 21.29 | 20.99 | 21.24 | 2422933.0 |
| 2010-11-10 | ABC-DELISTED | Stock | 30.74 | 31.49 | 30.62 | 31.49 | 3648819.0 |
| 2010-11-10 | ABCB | Stock | 8.69 | 8.9 | 8.69 | 8.88 | 60600.0 |
| 2010-11-10 | ABCD-DELISTED | Stock | 3.13 | 3.131 | 3.0815 | 3.12 | 15700.0 |
| 2010-11-10 | ABCO-DELISTED | Stock | 24.32 | 24.46 | 23.03 | 24.38 | 152960.0 |
| 2010-11-10 | ABCW-DELISTED | Stock | 0.86 | 0.9 | 0.77 | 0.82 | 158470.0 |
| 2010-11-10 | ABD-DELISTED | Stock | 6.81 | 7.42 | 6.69 | 7.35 | 854110.0 |
| 2010-11-10 | ABE-DELISTED | Stock | 19.3 | 19.3 | 18.96 | 19.1699 | 15502.0 |
| 2010-11-10 | ABEO | Stock | 3775.0 | 3925.0 | 3750.0 | 3850.0 | 21.0 |
| 2010-11-10 | ABFS-DELISTED | Stock | 24.68 | 24.76 | 24.45 | 24.62 | 147879.0 |
| 2010-11-10 | ABG | Stock | 15.92 | 16.11 | 15.76 | 16.03 | 118000.0 |
| 2010-11-10 | ABM | Stock | 23.94 | 24.49 | 23.72 | 24.25 | 188300.0 |
| 2010-11-10 | ABMD-DELISTED | Stock | 11.85 | 12.1 | 11.72 | 12.08 | 71941.0 |
| 2010-11-10 | ABR | Stock | 5.59 | 5.64 | 5.48 | 5.61 | 40100.0 |
| 2010-11-10 | ABT | Stock | 23.9276 | 24.0716 | 23.7309 | 24.0716 | 15562526.0 |
| 2010-11-10 | ABTL-DELISTED | Stock | 4.1002 | 4.2503 | 4.0502 | 4.1998 | 19700.0 |
| 2010-11-10 | ABV-DELISTED | Stock | 139.58 | 140.16 | 136.14 | 138.68 | 666779.0 |
| 2010-11-10 | ABVA-DELISTED | Stock | 3.2 | 3.2 | 3.1999 | 3.2 | 5000.0 |
| 2010-11-10 | ABVT-DELISTED | Stock | 63.15 | 63.8 | 62.81 | 63.4 | 118606.0 |
| 2010-11-10 | ABX-DELISTED | Stock | 51.32 | 51.93 | 50.29 | 51.79 | 12906144.0 |
| 2010-11-10 | ACAD | Stock | 0.71 | 0.74 | 0.71 | 0.73 | 297600.0 |
> showing 50 of 6,028 rows — these rows as CSV