PREVIEW / stock_daily / 2024-01-23
file: by_date/stock_daily/2024/2024-01-23.parquet size: 233 KB rows: 7,281 symbols: 1,186
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-23 | AAPL | Stock | 195.02 | 195.75 | 193.83 | 195.18 | 42355600.0 |
| 2024-01-23 | MSFT | Stock | 395.75 | 399.38 | 393.93 | 398.9 | 20525900.0 |
| 2024-01-23 | NVDA | Stock | 59.57 | 59.91 | 58.585 | 59.873 | 294654000.0 |
| 2024-01-23 | AMZN | Stock | 154.85 | 156.21 | 153.93 | 156.02 | 37986000.0 |
| 2024-01-23 | GOOGL | Stock | 145.89 | 147.182 | 145.5 | 147.04 | 21636129.0 |
| 2024-01-23 | META | Stock | 384.62 | 388.38 | 382.08 | 385.2 | 15506100.0 |
| 2024-01-23 | TSLA | Stock | 211.3 | 215.65 | 207.75 | 209.14 | 106605900.0 |
| 2024-01-23 | TLT | Stock | 93.89 | 93.99 | 93.4299 | 93.9 | 35786747.0 |
| 2024-01-23 | ES | Stock | 53.01 | 53.44 | 52.09 | 52.88 | 4203100.0 |
| 2024-01-23 | CL | Stock | 81.11 | 81.82 | 80.81 | 81.41 | 7078300.0 |
| 2024-01-23 | A | Stock | 133.64 | 133.94 | 130.33 | 131.64 | 854900.0 |
| 2024-01-23 | AA | Stock | 29.15 | 30.485 | 29.03 | 29.51 | 9363900.0 |
| 2024-01-23 | AACG | Stock | 1.03 | 1.03 | 0.95 | 1.03 | 3000.0 |
| 2024-01-23 | AACT | Stock | 10.5 | 10.5 | 10.48 | 10.48 | 349500.0 |
| 2024-01-23 | AAGR-DELISTED | Stock | 0.79 | 0.899 | 0.7015 | 0.89 | 192831.0 |
| 2024-01-23 | AAL | Stock | 14.14 | 14.47 | 13.93 | 14.0 | 49961900.0 |
| 2024-01-23 | AAMC-DELISTED | Stock | 5.185 | 5.266 | 4.9 | 5.19 | 17200.0 |
| 2024-01-23 | AAME | Stock | 2.55 | 2.62 | 2.49 | 2.5 | 17600.0 |
| 2024-01-23 | AAMI | Stock | 21.3 | 21.6 | 21.09 | 21.29 | 352500.0 |
| 2024-01-23 | AAN-DELISTED | Stock | 10.73 | 10.84 | 10.48 | 10.49 | 219500.0 |
| 2024-01-23 | AAOI | Stock | 17.18 | 18.63 | 17.18 | 18.13 | 2990600.0 |
| 2024-01-23 | AAON | Stock | 72.82 | 73.44 | 70.56 | 70.7 | 280500.0 |
| 2024-01-23 | AAP | Stock | 67.11 | 69.38 | 65.2 | 66.08 | 2272400.0 |
| 2024-01-23 | AAT | Stock | 23.8 | 23.85 | 23.11 | 23.42 | 427600.0 |
| 2024-01-23 | AATC | Stock | 7.905 | 7.99 | 7.9 | 7.98 | 7398.0 |
| 2024-01-23 | AAU-DELISTED | Stock | 0.135 | 0.1358 | 0.135 | 0.1351 | 88736.0 |
| 2024-01-23 | AAUAF-DELISTED | Stock | 0.135 | 0.1358 | 0.135 | 0.1351 | 86593.0 |
| 2024-01-23 | AAXJ | Stock | 62.74 | 63.195 | 62.64 | 63.11 | 815138.0 |
| 2024-01-23 | AB | Stock | 33.45 | 33.83 | 33.28 | 33.49 | 267400.0 |
| 2024-01-23 | ABAT | Stock | 2.93 | 2.9598 | 2.56 | 2.81 | 1232252.0 |
| 2024-01-23 | ABBNY-DELISTED | Stock | 41.47 | 41.55 | 41.09 | 41.24 | 1050386.0 |
| 2024-01-23 | ABBV | Stock | 164.45 | 167.53 | 164.06 | 167.5 | 5784700.0 |
| 2024-01-23 | ABCB | Stock | 53.59 | 53.6 | 52.5 | 52.5 | 336200.0 |
| 2024-01-23 | ABCL | Stock | 5.52 | 5.62 | 5.18 | 5.31 | 886400.0 |
| 2024-01-23 | ABEO | Stock | 5.1 | 5.1 | 4.78 | 4.87 | 168100.0 |
| 2024-01-23 | ABEV | Stock | 2.67 | 2.69 | 2.63 | 2.67 | 9503200.0 |
| 2024-01-23 | ABG | Stock | 211.14 | 211.14 | 206.13 | 207.75 | 161500.0 |
| 2024-01-23 | ABLLW | Stock | 0.9601 | 1.05 | 0.9254 | 0.94 | 327821.0 |
| 2024-01-23 | ABLV | Stock | 2.673 | 2.705 | 2.54 | 2.58 | 144700.0 |
| 2024-01-23 | ABM | Stock | 42.69 | 42.96 | 42.24 | 42.34 | 346200.0 |
| 2024-01-23 | ABNB | Stock | 142.75 | 143.93 | 140.52 | 142.3 | 3882100.0 |
| 2024-01-23 | ABOS | Stock | 3.4 | 3.48 | 3.295 | 3.33 | 321900.0 |
| 2024-01-23 | ABR | Stock | 14.19 | 14.22 | 13.89 | 13.91 | 4103800.0 |
| 2024-01-23 | ABR.D | Stock | 17.74 | 17.8799 | 17.6 | 17.79 | 24347.0 |
| 2024-01-23 | ABR.E | Stock | 17.35 | 17.89 | 17.35 | 17.7 | 9310.0 |
| 2024-01-23 | ABR.F | Stock | 18.64 | 18.72 | 18.6115 | 18.69 | 8622.0 |
| 2024-01-23 | ABSI | Stock | 3.76 | 3.8 | 3.56 | 3.65 | 913100.0 |
| 2024-01-23 | ABT | Stock | 114.45 | 115.5 | 112.87 | 114.0 | 5037300.0 |
| 2024-01-23 | ABTC | Stock | 439.5 | 439.5 | 367.5 | 409.5 | 60.53333333333333 |
| 2024-01-23 | ABTS | Stock | 15.345 | 16.5 | 15.0 | 15.75 | 7327.0 |
> showing 50 of 7,281 rows — these rows as CSV