PREVIEW / stock_daily / 2024-01-16
file: by_date/stock_daily/2024/2024-01-16.parquet size: 234 KB rows: 7,316 symbols: 1,190
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-16 | AAPL | Stock | 182.16 | 184.26 | 180.93 | 183.63 | 65603000.0 |
| 2024-01-16 | MSFT | Stock | 393.66 | 394.03 | 387.62 | 390.27 | 27202300.0 |
| 2024-01-16 | NVDA | Stock | 55.018 | 56.835 | 54.9 | 56.382 | 449580000.0 |
| 2024-01-16 | AMZN | Stock | 153.53 | 154.99 | 152.15 | 153.16 | 41384600.0 |
| 2024-01-16 | GOOGL | Stock | 142.0 | 144.35 | 141.45 | 142.49 | 22670467.0 |
| 2024-01-16 | META | Stock | 373.65 | 375.61 | 367.23 | 367.46 | 15306900.0 |
| 2024-01-16 | TSLA | Stock | 215.1 | 223.49 | 212.18 | 219.91 | 115355000.0 |
| 2024-01-16 | TLT | Stock | 95.62 | 95.79 | 94.51 | 94.82 | 61716698.0 |
| 2024-01-16 | ES | Stock | 56.68 | 56.91 | 55.97 | 56.24 | 2617800.0 |
| 2024-01-16 | CL | Stock | 81.0 | 81.14 | 80.01 | 80.43 | 4252000.0 |
| 2024-01-16 | A | Stock | 129.14 | 130.81 | 128.6 | 130.53 | 1382100.0 |
| 2024-01-16 | AA | Stock | 29.17 | 29.29 | 27.275 | 27.87 | 10715000.0 |
| 2024-01-16 | AACG | Stock | 1.05 | 1.08 | 0.94 | 1.05 | 10400.0 |
| 2024-01-16 | AACIU | Stock | 10.7 | 10.7 | 10.7 | 10.7 | 471.0 |
| 2024-01-16 | AACIW-DELISTED | Stock | 0.02 | 0.02 | 0.0183 | 0.02 | 97841.0 |
| 2024-01-16 | AACT | Stock | 10.455 | 10.455 | 10.45 | 10.455 | 26200.0 |
| 2024-01-16 | AAGR-DELISTED | Stock | 0.93 | 0.96 | 0.67 | 0.8611 | 697683.0 |
| 2024-01-16 | AAGRW-DELISTED | Stock | 0.0153 | 0.0153 | 0.0153 | 0.0153 | 888.0 |
| 2024-01-16 | AAL | Stock | 13.08 | 13.2 | 12.78 | 13.19 | 55891500.0 |
| 2024-01-16 | AAMC-DELISTED | Stock | 4.0 | 5.51 | 4.0 | 5.0 | 866000.0 |
| 2024-01-16 | AAME | Stock | 2.63 | 2.69 | 2.5 | 2.51 | 13300.0 |
| 2024-01-16 | AAMI | Stock | 19.02 | 19.65 | 19.01 | 19.44 | 399600.0 |
| 2024-01-16 | AAN-DELISTED | Stock | 10.34 | 10.4 | 10.18 | 10.3 | 236200.0 |
| 2024-01-16 | AAOI | Stock | 17.06 | 17.98 | 16.58 | 17.29 | 2419200.0 |
| 2024-01-16 | AAON | Stock | 70.19 | 71.5 | 69.37 | 69.96 | 275200.0 |
| 2024-01-16 | AAP | Stock | 61.0 | 62.03 | 60.82 | 61.4 | 1268200.0 |
| 2024-01-16 | AAT | Stock | 23.13 | 23.15 | 22.74 | 22.9 | 227200.0 |
| 2024-01-16 | AATC | Stock | 7.9 | 8.0 | 7.61 | 7.624 | 22596.0 |
| 2024-01-16 | AAU-DELISTED | Stock | 0.136 | 0.136 | 0.135 | 0.1352 | 185887.0 |
| 2024-01-16 | AAUAF-DELISTED | Stock | 0.136 | 0.136 | 0.135 | 0.1352 | 186700.0 |
| 2024-01-16 | AAXJ | Stock | 63.4 | 63.4 | 62.795 | 62.86 | 546629.0 |
| 2024-01-16 | AB | Stock | 32.84 | 33.3 | 32.76 | 32.94 | 281900.0 |
| 2024-01-16 | ABAT | Stock | 3.5 | 3.6 | 3.26 | 3.28 | 678648.0 |
| 2024-01-16 | ABBNY-DELISTED | Stock | 42.15 | 42.31 | 41.98 | 41.99 | 143750.0 |
| 2024-01-16 | ABBV | Stock | 161.98 | 162.3 | 161.02 | 161.48 | 4747700.0 |
| 2024-01-16 | ABCB | Stock | 49.98 | 50.61 | 49.64 | 49.9 | 315100.0 |
| 2024-01-16 | ABCL | Stock | 5.34 | 5.34 | 4.96 | 5.0 | 1857000.0 |
| 2024-01-16 | ABEO | Stock | 5.21 | 5.24 | 5.1 | 5.2 | 152800.0 |
| 2024-01-16 | ABEV | Stock | 2.75 | 2.75 | 2.69 | 2.69 | 5278500.0 |
| 2024-01-16 | ABG | Stock | 200.28 | 205.34 | 198.23 | 202.59 | 160400.0 |
| 2024-01-16 | ABLLW | Stock | 0.93 | 0.97 | 0.89 | 0.91 | 20771.0 |
| 2024-01-16 | ABLV | Stock | 2.57 | 3.94 | 2.41 | 2.53 | 264800.0 |
| 2024-01-16 | ABLVW | Stock | 0.0347 | 0.0369 | 0.0234 | 0.0234 | 3105.0 |
| 2024-01-16 | ABM | Stock | 41.71 | 41.9 | 41.16 | 41.36 | 595400.0 |
| 2024-01-16 | ABNB | Stock | 135.9 | 136.0 | 133.67 | 135.02 | 5514800.0 |
| 2024-01-16 | ABOS | Stock | 3.82 | 3.82 | 3.6 | 3.63 | 460600.0 |
| 2024-01-16 | ABR | Stock | 14.57 | 14.6 | 14.18 | 14.3 | 5063600.0 |
| 2024-01-16 | ABR.D | Stock | 17.81 | 17.94 | 17.69 | 17.82 | 42551.0 |
| 2024-01-16 | ABR.E | Stock | 17.73 | 17.74 | 17.46 | 17.51 | 5458.0 |
| 2024-01-16 | ABR.F | Stock | 18.61 | 18.73 | 18.46 | 18.57 | 28174.0 |
> showing 50 of 7,316 rows — these rows as CSV