PREVIEW / stock_daily / 2024-06-21
file: by_date/stock_daily/2024/2024-06-21.parquet size: 232 KB rows: 7,225 symbols: 958
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-06-21 | AAPL | Stock | 210.39 | 211.89 | 207.11 | 207.49 | 246421400.0 |
| 2024-06-21 | MSFT | Stock | 447.38 | 450.58 | 446.51 | 449.78 | 34486200.0 |
| 2024-06-21 | NVDA | Stock | 127.12 | 130.63 | 124.3 | 126.57 | 655484700.0 |
| 2024-06-21 | AMZN | Stock | 187.8 | 189.28 | 185.86 | 189.08 | 72931800.0 |
| 2024-06-21 | GOOGL | Stock | 177.0 | 180.85 | 176.61 | 179.63 | 58582743.0 |
| 2024-06-21 | META | Stock | 503.45 | 503.45 | 492.39 | 494.78 | 23130700.0 |
| 2024-06-21 | TSLA | Stock | 182.3 | 183.95 | 180.69 | 183.01 | 63029500.0 |
| 2024-06-21 | TLT | Stock | 94.24 | 94.479 | 93.59 | 93.96 | 22830882.0 |
| 2024-06-21 | ES | Stock | 58.0 | 58.3 | 57.18 | 57.18 | 4191400.0 |
| 2024-06-21 | CL | Stock | 96.99 | 97.67 | 96.74 | 97.27 | 6378200.0 |
| 2024-06-21 | A | Stock | 132.85 | 134.5 | 132.2 | 133.25 | 4461300.0 |
| 2024-06-21 | AA | Stock | 39.96 | 40.55 | 39.112 | 40.4 | 6499900.0 |
| 2024-06-21 | AACG | Stock | 0.8 | 0.83 | 0.8 | 0.82 | 4700.0 |
| 2024-06-21 | AACIW-DELISTED | Stock | 0.15 | 0.15 | 0.15 | 0.15 | 200.0 |
| 2024-06-21 | AACT | Stock | 10.66 | 10.66 | 10.65 | 10.66 | 38700.0 |
| 2024-06-21 | AAGR-DELISTED | Stock | 0.3135 | 0.3135 | 0.2351 | 0.2573 | 404023.0 |
| 2024-06-21 | AAL | Stock | 11.22 | 11.34 | 11.11 | 11.2 | 28098100.0 |
| 2024-06-21 | AAMC-DELISTED | Stock | 1.85 | 2.0 | 1.79 | 2.0 | 4500.0 |
| 2024-06-21 | AAME | Stock | 1.74 | 1.74 | 1.65 | 1.66 | 3600.0 |
| 2024-06-21 | AAMI | Stock | 22.39 | 22.54 | 21.96 | 22.01 | 1715700.0 |
| 2024-06-21 | AAN-DELISTED | Stock | 9.99 | 10.0 | 9.875 | 9.91 | 3516900.0 |
| 2024-06-21 | AAOI | Stock | 9.0 | 9.25 | 8.73 | 9.1 | 2069100.0 |
| 2024-06-21 | AAON | Stock | 80.22 | 80.44 | 77.31 | 79.28 | 1540400.0 |
| 2024-06-21 | AAP | Stock | 66.12 | 67.03 | 65.15 | 65.76 | 2079600.0 |
| 2024-06-21 | AAT | Stock | 21.53 | 21.69 | 21.36 | 21.53 | 783700.0 |
| 2024-06-21 | AATC | Stock | 5.98 | 5.98 | 5.66 | 5.862 | 23705.0 |
| 2024-06-21 | AAUAF-DELISTED | Stock | 0.06254 | 0.06398 | 0.0609 | 0.0615 | 29073.0 |
| 2024-06-21 | AAXJ | Stock | 72.38 | 72.38 | 72.11 | 72.13 | 349137.0 |
| 2024-06-21 | AB | Stock | 33.74 | 34.12 | 33.41 | 33.52 | 181800.0 |
| 2024-06-21 | ABAT | Stock | 1.05 | 1.09 | 1.03 | 1.03 | 454704.0 |
| 2024-06-21 | ABBV | Stock | 172.7 | 172.93 | 169.59 | 170.39 | 12308100.0 |
| 2024-06-21 | ABCB | Stock | 47.9 | 47.9 | 47.05 | 47.72 | 1171400.0 |
| 2024-06-21 | ABCL | Stock | 2.95 | 2.965 | 2.89 | 2.9 | 2549300.0 |
| 2024-06-21 | ABEO | Stock | 4.51 | 4.63 | 4.46 | 4.58 | 1648100.0 |
| 2024-06-21 | ABEV | Stock | 2.07 | 2.1 | 2.05 | 2.08 | 21612900.0 |
| 2024-06-21 | ABG | Stock | 228.22 | 231.05 | 226.9 | 228.65 | 542400.0 |
| 2024-06-21 | ABLLW | Stock | 0.55 | 0.6975 | 0.5 | 0.64 | 782508.0 |
| 2024-06-21 | ABLV | Stock | 0.99 | 1.07 | 0.99 | 1.07 | 5400.0 |
| 2024-06-21 | ABM | Stock | 51.38 | 52.64 | 50.69 | 52.64 | 5993500.0 |
| 2024-06-21 | ABNB | Stock | 148.76 | 150.0 | 147.25 | 149.57 | 7648400.0 |
| 2024-06-21 | ABOS | Stock | 2.23 | 2.32 | 2.2 | 2.31 | 421400.0 |
| 2024-06-21 | ABR | Stock | 14.06 | 14.2 | 14.05 | 14.12 | 3539100.0 |
| 2024-06-21 | ABR.D | Stock | 18.48 | 18.8257 | 18.41 | 18.45 | 12693.0 |
| 2024-06-21 | ABR.E | Stock | 18.1 | 18.1253 | 18.02 | 18.06 | 17551.0 |
| 2024-06-21 | ABR.F | Stock | 20.06 | 20.08 | 19.94 | 19.94 | 15712.0 |
| 2024-06-21 | ABSI | Stock | 2.98 | 3.02 | 2.86 | 3.02 | 4598000.0 |
| 2024-06-21 | ABT | Stock | 106.66 | 106.93 | 105.24 | 105.72 | 10329100.0 |
| 2024-06-21 | ABTC | Stock | 93.0 | 93.75 | 85.5 | 85.5 | 11070.666666666666 |
| 2024-06-21 | ABTS | Stock | 7.23 | 7.23 | 6.0 | 6.9 | 6180.0 |
| 2024-06-21 | ABUS | Stock | 3.0 | 3.07 | 2.96 | 3.05 | 2110800.0 |
> showing 50 of 7,225 rows — these rows as CSV