PREVIEW / stock_daily / 2024-01-17
file: by_date/stock_daily/2024/2024-01-17.parquet size: 234 KB rows: 7,277 symbols: 1,163
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 |
|---|---|---|---|---|---|---|---|
| 2024-01-17 | AAPL | Stock | 181.27 | 182.93 | 180.3 | 182.68 | 47317400.0 |
| 2024-01-17 | MSFT | Stock | 387.98 | 390.11 | 384.81 | 389.47 | 22234100.0 |
| 2024-01-17 | NVDA | Stock | 56.347 | 56.471 | 54.74 | 56.053 | 474394000.0 |
| 2024-01-17 | AMZN | Stock | 151.49 | 152.15 | 149.91 | 151.71 | 34953400.0 |
| 2024-01-17 | GOOGL | Stock | 141.345 | 141.84 | 138.9 | 141.47 | 20968649.0 |
| 2024-01-17 | META | Stock | 366.3 | 368.54 | 358.61 | 368.37 | 12724800.0 |
| 2024-01-17 | TSLA | Stock | 214.86 | 215.67 | 212.01 | 215.55 | 103164400.0 |
| 2024-01-17 | TLT | Stock | 94.6 | 95.0 | 94.16 | 94.67 | 55506807.0 |
| 2024-01-17 | ES | Stock | 55.52 | 56.36 | 54.55 | 54.76 | 2880700.0 |
| 2024-01-17 | CL | Stock | 80.1 | 81.19 | 79.78 | 80.96 | 5357800.0 |
| 2024-01-17 | A | Stock | 129.98 | 130.61 | 126.74 | 128.12 | 1257400.0 |
| 2024-01-17 | AA | Stock | 27.17 | 27.67 | 27.05 | 27.18 | 9606400.0 |
| 2024-01-17 | AACG | Stock | 1.05 | 1.07 | 1.0 | 1.05 | 19100.0 |
| 2024-01-17 | AACIW-DELISTED | Stock | 0.0181 | 0.0181 | 0.0181 | 0.0181 | 1500.0 |
| 2024-01-17 | AACT | Stock | 10.46 | 10.465 | 10.46 | 10.46 | 942200.0 |
| 2024-01-17 | AAGR-DELISTED | Stock | 0.85 | 0.85 | 0.7601 | 0.837 | 94322.0 |
| 2024-01-17 | AAL | Stock | 12.96 | 13.21 | 12.87 | 12.93 | 36991500.0 |
| 2024-01-17 | AAMC-DELISTED | Stock | 4.94 | 5.5 | 4.63 | 5.2 | 154500.0 |
| 2024-01-17 | AAME | Stock | 2.58 | 2.69 | 2.58 | 2.69 | 3100.0 |
| 2024-01-17 | AAMI | Stock | 19.15 | 19.54 | 19.15 | 19.46 | 316300.0 |
| 2024-01-17 | AAN-DELISTED | Stock | 10.16 | 10.3 | 9.99 | 10.15 | 180800.0 |
| 2024-01-17 | AAOI | Stock | 16.63 | 17.5 | 16.3 | 16.86 | 1902700.0 |
| 2024-01-17 | AAON | Stock | 69.0 | 70.27 | 68.38 | 70.0 | 277500.0 |
| 2024-01-17 | AAP | Stock | 60.74 | 61.99 | 60.4 | 61.04 | 1038500.0 |
| 2024-01-17 | AAT | Stock | 22.43 | 22.75 | 22.02 | 22.47 | 287700.0 |
| 2024-01-17 | AATC | Stock | 7.7 | 7.73 | 7.6 | 7.63 | 20466.0 |
| 2024-01-17 | AAU-DELISTED | Stock | 0.135 | 0.1368 | 0.135 | 0.1356 | 135585.0 |
| 2024-01-17 | AAUAF-DELISTED | Stock | 0.135 | 0.1368 | 0.135 | 0.1356 | 137509.0 |
| 2024-01-17 | AAXJ | Stock | 61.39 | 61.82 | 61.3 | 61.78 | 896786.0 |
| 2024-01-17 | AB | Stock | 32.4 | 32.92 | 32.0 | 32.53 | 334700.0 |
| 2024-01-17 | ABAT | Stock | 3.25 | 3.28 | 2.33 | 2.69 | 2774484.0 |
| 2024-01-17 | ABBNY-DELISTED | Stock | 41.48 | 41.68 | 41.36 | 41.68 | 119808.0 |
| 2024-01-17 | ABBV | Stock | 161.75 | 162.95 | 161.52 | 162.04 | 4423100.0 |
| 2024-01-17 | ABCB | Stock | 48.83 | 50.04 | 44.0 | 49.36 | 296700.0 |
| 2024-01-17 | ABCL | Stock | 4.95 | 5.31 | 4.81 | 5.27 | 4214000.0 |
| 2024-01-17 | ABEO | Stock | 5.17 | 5.17 | 5.1 | 5.14 | 71700.0 |
| 2024-01-17 | ABEV | Stock | 2.71 | 2.73 | 2.69 | 2.69 | 7541200.0 |
| 2024-01-17 | ABG | Stock | 199.38 | 203.74 | 199.38 | 202.54 | 89000.0 |
| 2024-01-17 | ABLLW | Stock | 0.92 | 0.95 | 0.92 | 0.94 | 16960.0 |
| 2024-01-17 | ABLV | Stock | 2.67 | 2.99 | 2.62 | 2.68 | 146600.0 |
| 2024-01-17 | ABM | Stock | 41.0 | 41.85 | 40.98 | 41.47 | 570700.0 |
| 2024-01-17 | ABNB | Stock | 132.84 | 135.09 | 131.1 | 134.98 | 3039700.0 |
| 2024-01-17 | ABOS | Stock | 3.52 | 3.79 | 3.41 | 3.75 | 627200.0 |
| 2024-01-17 | ABR | Stock | 14.07 | 14.34 | 13.89 | 14.09 | 5209100.0 |
| 2024-01-17 | ABR.D | Stock | 17.82 | 17.85 | 17.68 | 17.789 | 13825.0 |
| 2024-01-17 | ABR.E | Stock | 17.55 | 17.74 | 17.5 | 17.5421 | 4681.0 |
| 2024-01-17 | ABR.F | Stock | 18.6 | 18.77 | 18.55 | 18.67 | 22750.0 |
| 2024-01-17 | ABSI | Stock | 3.95 | 4.02 | 3.555 | 3.64 | 1150300.0 |
| 2024-01-17 | ABT | Stock | 113.62 | 114.5 | 113.44 | 113.93 | 4672000.0 |
| 2024-01-17 | ABTC | Stock | 471.0 | 472.5 | 438.0 | 463.5 | 100.26666666666667 |
> showing 50 of 7,277 rows — these rows as CSV