PREVIEW / stock_daily / 2024-03-21
file: by_date/stock_daily/2024/2024-03-21.parquet size: 234 KB rows: 7,276 symbols: 1,069
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-03-21 | AAPL | Stock | 177.05 | 177.49 | 170.84 | 171.37 | 106181300.0 |
| 2024-03-21 | MSFT | Stock | 429.83 | 430.82 | 427.16 | 429.37 | 21296200.0 |
| 2024-03-21 | NVDA | Stock | 92.3 | 92.648 | 90.405 | 91.435 | 480372000.0 |
| 2024-03-21 | AMZN | Stock | 179.99 | 181.42 | 178.15 | 178.15 | 32824300.0 |
| 2024-03-21 | GOOGL | Stock | 149.47 | 150.37 | 146.9001 | 147.6 | 24755597.0 |
| 2024-03-21 | META | Stock | 514.71 | 515.04 | 506.01 | 507.76 | 9712500.0 |
| 2024-03-21 | TSLA | Stock | 176.39 | 178.18 | 171.8 | 172.82 | 73178000.0 |
| 2024-03-21 | TLT | Stock | 93.27 | 93.43 | 92.725 | 93.09 | 34276643.0 |
| 2024-03-21 | ES | Stock | 59.4 | 59.5 | 57.87 | 57.89 | 3736100.0 |
| 2024-03-21 | CL | Stock | 88.35 | 89.11 | 87.92 | 88.77 | 3416200.0 |
| 2024-03-21 | A | Stock | 147.58 | 150.14 | 147.18 | 148.74 | 1574200.0 |
| 2024-03-21 | AA | Stock | 31.71 | 32.13 | 31.05 | 31.35 | 5594600.0 |
| 2024-03-21 | AACG | Stock | 1.18 | 1.28 | 1.1 | 1.16 | 73200.0 |
| 2024-03-21 | AACIW-DELISTED | Stock | 0.0746 | 0.0838 | 0.05 | 0.05 | 13000.0 |
| 2024-03-21 | AACT | Stock | 10.55 | 10.57 | 10.55 | 10.57 | 115200.0 |
| 2024-03-21 | AAGR-DELISTED | Stock | 0.438 | 0.461 | 0.39 | 0.4039 | 160706.0 |
| 2024-03-21 | AAGRW-DELISTED | Stock | 0.0151 | 0.0151 | 0.013 | 0.0131 | 28362.0 |
| 2024-03-21 | AAL | Stock | 14.62 | 14.82 | 14.6 | 14.78 | 25527600.0 |
| 2024-03-21 | AAMC-DELISTED | Stock | 3.48 | 3.81 | 3.48 | 3.55 | 3100.0 |
| 2024-03-21 | AAME | Stock | 2.79 | 2.79 | 2.79 | 2.79 | 300.0 |
| 2024-03-21 | AAMI | Stock | 22.8 | 22.98 | 22.59 | 22.61 | 188700.0 |
| 2024-03-21 | AAN-DELISTED | Stock | 7.3 | 7.54 | 7.23 | 7.5 | 322800.0 |
| 2024-03-21 | AAOI | Stock | 14.55 | 15.22 | 14.51 | 14.92 | 2139500.0 |
| 2024-03-21 | AAON | Stock | 85.95 | 88.54 | 85.87 | 88.35 | 291500.0 |
| 2024-03-21 | AAP | Stock | 86.08 | 88.56 | 85.37 | 86.45 | 2671400.0 |
| 2024-03-21 | AAT | Stock | 21.7 | 21.94 | 21.35 | 21.41 | 748800.0 |
| 2024-03-21 | AATC | Stock | 7.315 | 7.35 | 7.15 | 7.3 | 2982.0 |
| 2024-03-21 | AAU-DELISTED | Stock | 0.14 | 0.1409 | 0.14 | 0.14 | 400076.0 |
| 2024-03-21 | AAUAF-DELISTED | Stock | 0.14 | 0.1409 | 0.14 | 0.14 | 400653.0 |
| 2024-03-21 | AAXJ | Stock | 68.31 | 68.37 | 67.93 | 67.93 | 437083.0 |
| 2024-03-21 | AB | Stock | 34.5 | 35.43 | 34.23 | 34.64 | 377800.0 |
| 2024-03-21 | ABAT | Stock | 2.13 | 2.13 | 1.95 | 1.98 | 539607.0 |
| 2024-03-21 | ABBV | Stock | 176.81 | 177.74 | 175.88 | 177.5 | 5743600.0 |
| 2024-03-21 | ABCB | Stock | 47.98 | 48.87 | 47.98 | 48.38 | 516000.0 |
| 2024-03-21 | ABCL | Stock | 4.8 | 4.83 | 4.67 | 4.71 | 832800.0 |
| 2024-03-21 | ABEO | Stock | 7.57 | 7.74 | 7.27 | 7.53 | 316800.0 |
| 2024-03-21 | ABEV | Stock | 2.5 | 2.51 | 2.48 | 2.49 | 17703200.0 |
| 2024-03-21 | ABG | Stock | 219.99 | 226.92 | 217.4 | 224.59 | 186700.0 |
| 2024-03-21 | ABLLW | Stock | 0.6 | 0.69 | 0.6 | 0.69 | 9916.0 |
| 2024-03-21 | ABLV | Stock | 2.78 | 2.88 | 2.64 | 2.855 | 107700.0 |
| 2024-03-21 | ABLVW | Stock | 0.0398 | 0.0775 | 0.0373 | 0.0565 | 93561.0 |
| 2024-03-21 | ABM | Stock | 44.08 | 44.75 | 43.95 | 44.65 | 585000.0 |
| 2024-03-21 | ABNB | Stock | 165.81 | 170.1 | 165.0 | 168.18 | 5986500.0 |
| 2024-03-21 | ABOS | Stock | 4.23 | 4.4 | 4.17 | 4.33 | 323500.0 |
| 2024-03-21 | ABR | Stock | 13.12 | 13.33 | 13.0 | 13.02 | 3930800.0 |
| 2024-03-21 | ABR.D | Stock | 18.77 | 19.05 | 18.77 | 18.83 | 30559.0 |
| 2024-03-21 | ABR.E | Stock | 19.25 | 19.4928 | 19.25 | 19.41 | 7208.0 |
| 2024-03-21 | ABR.F | Stock | 19.1158 | 19.36 | 19.06 | 19.2 | 31594.0 |
| 2024-03-21 | ABSI | Stock | 5.24 | 5.57 | 5.16 | 5.28 | 1561800.0 |
| 2024-03-21 | ABT | Stock | 111.95 | 112.14 | 111.01 | 111.51 | 9722700.0 |
> showing 50 of 7,276 rows — these rows as CSV