PREVIEW / stock_daily / 2024-01-05
file: by_date/stock_daily/2024/2024-01-05.parquet size: 234 KB rows: 7,250 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-05 | AAPL | Stock | 181.99 | 182.76 | 180.17 | 181.18 | 62303300.0 |
| 2024-01-05 | MSFT | Stock | 368.97 | 372.06 | 366.5 | 367.75 | 20987000.0 |
| 2024-01-05 | NVDA | Stock | 48.462 | 49.547 | 48.306 | 49.097 | 415039000.0 |
| 2024-01-05 | AMZN | Stock | 144.69 | 146.59 | 144.53 | 145.24 | 45124800.0 |
| 2024-01-05 | GOOGL | Stock | 136.745 | 137.1558 | 135.15 | 135.73 | 22513854.0 |
| 2024-01-05 | META | Stock | 346.99 | 353.5 | 346.26 | 351.95 | 13920700.0 |
| 2024-01-05 | TSLA | Stock | 236.86 | 240.12 | 234.9 | 237.49 | 92379400.0 |
| 2024-01-05 | TLT | Stock | 96.5 | 97.68 | 96.21 | 96.29 | 45894801.0 |
| 2024-01-05 | ES | Stock | 62.7 | 62.85 | 61.66 | 62.07 | 3340600.0 |
| 2024-01-05 | CL | Stock | 80.43 | 80.52 | 79.52 | 79.98 | 2825100.0 |
| 2024-01-05 | A | Stock | 130.0 | 131.96 | 128.62 | 130.56 | 1394000.0 |
| 2024-01-05 | AA | Stock | 30.54 | 32.305 | 30.09 | 32.13 | 7313000.0 |
| 2024-01-05 | AACG | Stock | 1.09 | 1.2 | 1.05 | 1.11 | 13800.0 |
| 2024-01-05 | AACT | Stock | 10.48 | 10.48 | 10.48 | 10.48 | 100.0 |
| 2024-01-05 | AAGR-DELISTED | Stock | 1.14 | 1.16 | 1.0 | 1.04 | 358419.0 |
| 2024-01-05 | AAGRW-DELISTED | Stock | 0.021 | 0.027 | 0.021 | 0.0211 | 5608.0 |
| 2024-01-05 | AAL | Stock | 13.05 | 13.67 | 13.01 | 13.6 | 37511200.0 |
| 2024-01-05 | AAMC-DELISTED | Stock | 3.96 | 4.4 | 3.66 | 3.82 | 43600.0 |
| 2024-01-05 | AAME | Stock | 2.35 | 2.54 | 2.35 | 2.5 | 8400.0 |
| 2024-01-05 | AAMI | Stock | 18.15 | 18.54 | 18.089 | 18.38 | 726600.0 |
| 2024-01-05 | AAN-DELISTED | Stock | 11.27 | 11.61 | 11.27 | 11.32 | 391700.0 |
| 2024-01-05 | AAOI | Stock | 18.41 | 20.29 | 17.92 | 20.15 | 3031300.0 |
| 2024-01-05 | AAON | Stock | 73.07 | 73.96 | 71.73 | 72.45 | 349600.0 |
| 2024-01-05 | AAP | Stock | 60.5 | 62.9 | 60.27 | 61.52 | 1382600.0 |
| 2024-01-05 | AAT | Stock | 22.17 | 22.98 | 22.11 | 22.78 | 340500.0 |
| 2024-01-05 | AATC | Stock | 7.1 | 7.1 | 7.03 | 7.05 | 11101.0 |
| 2024-01-05 | AAU-DELISTED | Stock | 0.1393 | 0.1399 | 0.1333 | 0.1363 | 63251.0 |
| 2024-01-05 | AAUAF-DELISTED | Stock | 0.1393 | 0.1399 | 0.1333 | 0.1363 | 65358.0 |
| 2024-01-05 | AAXJ | Stock | 64.95 | 65.315 | 64.765 | 64.82 | 585257.0 |
| 2024-01-05 | AB | Stock | 31.36 | 31.43 | 30.72 | 31.1 | 238900.0 |
| 2024-01-05 | ABAT | Stock | 4.38 | 4.41 | 4.01 | 4.15 | 564550.0 |
| 2024-01-05 | ABBNY-DELISTED | Stock | 42.18 | 42.56 | 42.1 | 42.21 | 188095.0 |
| 2024-01-05 | ABBV | Stock | 161.33 | 163.03 | 160.61 | 162.14 | 5607600.0 |
| 2024-01-05 | ABCB | Stock | 49.92 | 51.24 | 49.92 | 50.57 | 355300.0 |
| 2024-01-05 | ABCL | Stock | 5.93 | 5.93 | 5.75 | 5.84 | 1400700.0 |
| 2024-01-05 | ABEO | Stock | 5.7 | 5.9 | 5.53 | 5.66 | 174000.0 |
| 2024-01-05 | ABEV | Stock | 2.78 | 2.8 | 2.76 | 2.78 | 10125600.0 |
| 2024-01-05 | ABG | Stock | 205.33 | 209.98 | 204.38 | 205.54 | 106000.0 |
| 2024-01-05 | ABLLW | Stock | 0.9 | 0.91 | 0.84 | 0.8606 | 39524.0 |
| 2024-01-05 | ABLV | Stock | 2.6 | 2.6 | 2.4 | 2.48 | 4500.0 |
| 2024-01-05 | ABM | Stock | 43.0 | 43.7 | 42.39 | 42.45 | 645000.0 |
| 2024-01-05 | ABNB | Stock | 134.25 | 136.65 | 133.895 | 135.98 | 4004600.0 |
| 2024-01-05 | ABOS | Stock | 4.0 | 4.075 | 3.85 | 4.02 | 442700.0 |
| 2024-01-05 | ABR | Stock | 14.71 | 14.91 | 14.36 | 14.56 | 4066500.0 |
| 2024-01-05 | ABR.D | Stock | 18.02 | 18.24 | 17.66 | 17.78 | 72617.0 |
| 2024-01-05 | ABR.E | Stock | 17.8508 | 18.2499 | 17.8508 | 18.14 | 1677.0 |
| 2024-01-05 | ABR.F | Stock | 18.85 | 19.0999 | 18.7 | 18.84 | 32057.0 |
| 2024-01-05 | ABSI | Stock | 3.89 | 3.89 | 3.45 | 3.62 | 1276300.0 |
| 2024-01-05 | ABT | Stock | 110.71 | 111.05 | 110.03 | 110.8 | 4127700.0 |
| 2024-01-05 | ABTC | Stock | 600.0 | 600.0 | 555.0 | 559.5 | 116.53333333333333 |
> showing 50 of 7,250 rows — these rows as CSV