PREVIEW / stock_daily / 2024-06-24
file: by_date/stock_daily/2024/2024-06-24.parquet size: 231 KB rows: 7,215 symbols: 938
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-24 | AAPL | Stock | 207.72 | 212.7 | 206.59 | 208.14 | 80727000.0 |
| 2024-06-24 | MSFT | Stock | 449.8 | 452.75 | 446.41 | 447.67 | 15913700.0 |
| 2024-06-24 | NVDA | Stock | 123.24 | 124.46 | 118.04 | 118.11 | 476060900.0 |
| 2024-06-24 | AMZN | Stock | 189.33 | 191.0 | 185.33 | 185.57 | 50610400.0 |
| 2024-06-24 | GOOGL | Stock | 180.16 | 180.89 | 178.67 | 179.22 | 18298012.0 |
| 2024-06-24 | META | Stock | 499.2 | 507.8 | 494.29 | 498.91 | 13525300.0 |
| 2024-06-24 | TSLA | Stock | 184.97 | 188.8 | 182.55 | 182.58 | 61992100.0 |
| 2024-06-24 | TLT | Stock | 94.05 | 94.34 | 93.735 | 94.34 | 56939096.0 |
| 2024-06-24 | ES | Stock | 57.31 | 58.14 | 57.02 | 58.0 | 1569400.0 |
| 2024-06-24 | CL | Stock | 98.0 | 99.06 | 97.29 | 98.99 | 4444000.0 |
| 2024-06-24 | A | Stock | 135.3 | 137.71 | 134.34 | 135.08 | 3339500.0 |
| 2024-06-24 | AA | Stock | 40.42 | 41.57 | 40.42 | 40.56 | 4962800.0 |
| 2024-06-24 | AACG | Stock | 0.84 | 0.85 | 0.8 | 0.82 | 10600.0 |
| 2024-06-24 | AACT | Stock | 10.66 | 10.66 | 10.65 | 10.65 | 59700.0 |
| 2024-06-24 | AAGR-DELISTED | Stock | 0.256 | 0.279 | 0.2441 | 0.2491 | 252117.0 |
| 2024-06-24 | AAL | Stock | 11.22 | 11.34 | 11.15 | 11.16 | 25666400.0 |
| 2024-06-24 | AAMC-DELISTED | Stock | 1.96 | 2.2 | 1.68 | 2.06 | 14400.0 |
| 2024-06-24 | AAME | Stock | 1.66 | 1.66 | 1.66 | 1.66 | 300.0 |
| 2024-06-24 | AAMI | Stock | 22.02 | 22.42 | 22.02 | 22.15 | 270700.0 |
| 2024-06-24 | AAN-DELISTED | Stock | 9.9 | 9.96 | 9.87 | 9.91 | 1564900.0 |
| 2024-06-24 | AAOI | Stock | 9.04 | 9.14 | 8.65 | 8.67 | 1550800.0 |
| 2024-06-24 | AAON | Stock | 79.51 | 80.72 | 78.79 | 79.99 | 761900.0 |
| 2024-06-24 | AAP | Stock | 65.67 | 66.08 | 64.98 | 65.3 | 1482800.0 |
| 2024-06-24 | AAT | Stock | 21.62 | 21.88 | 21.48 | 21.61 | 212600.0 |
| 2024-06-24 | AATC | Stock | 5.97 | 5.97 | 5.91 | 5.97 | 3577.0 |
| 2024-06-24 | AAUAF-DELISTED | Stock | 0.06 | 0.07 | 0.059 | 0.07 | 45495.0 |
| 2024-06-24 | AAXJ | Stock | 72.19 | 72.67 | 72.09 | 72.1 | 268268.0 |
| 2024-06-24 | AB | Stock | 33.52 | 34.14 | 33.51 | 33.72 | 178400.0 |
| 2024-06-24 | ABAT | Stock | 1.04 | 1.055 | 1.02 | 1.02 | 436429.0 |
| 2024-06-24 | ABBV | Stock | 171.13 | 173.41 | 170.7 | 172.74 | 6249900.0 |
| 2024-06-24 | ABCB | Stock | 47.99 | 49.11 | 47.65 | 48.46 | 409400.0 |
| 2024-06-24 | ABCL | Stock | 2.9 | 2.97 | 2.79 | 2.79 | 2953200.0 |
| 2024-06-24 | ABEO | Stock | 4.59 | 4.63 | 4.3 | 4.35 | 271000.0 |
| 2024-06-24 | ABEV | Stock | 2.1 | 2.12 | 2.08 | 2.1 | 17067800.0 |
| 2024-06-24 | ABG | Stock | 229.84 | 234.8 | 228.46 | 229.76 | 168000.0 |
| 2024-06-24 | ABLLW | Stock | 0.64 | 0.6831 | 0.6 | 0.6831 | 134713.0 |
| 2024-06-24 | ABLV | Stock | 1.11 | 1.12 | 0.983 | 0.986 | 1700.0 |
| 2024-06-24 | ABM | Stock | 52.43 | 52.69 | 51.25 | 51.27 | 1119800.0 |
| 2024-06-24 | ABNB | Stock | 149.15 | 150.04 | 146.71 | 148.39 | 4530900.0 |
| 2024-06-24 | ABOS | Stock | 2.31 | 2.385 | 2.2 | 2.24 | 414600.0 |
| 2024-06-24 | ABR | Stock | 14.16 | 14.28 | 14.06 | 14.2 | 1816000.0 |
| 2024-06-24 | ABR.D | Stock | 18.3453 | 18.645 | 18.3453 | 18.575 | 6275.0 |
| 2024-06-24 | ABR.E | Stock | 18.09 | 18.27 | 18.0201 | 18.07 | 20575.0 |
| 2024-06-24 | ABR.F | Stock | 19.94 | 20.0599 | 19.9 | 19.95 | 9631.0 |
| 2024-06-24 | ABSI | Stock | 3.03 | 3.11 | 2.97 | 3.04 | 2158100.0 |
| 2024-06-24 | ABT | Stock | 106.29 | 106.29 | 104.94 | 105.3 | 5201300.0 |
| 2024-06-24 | ABTC | Stock | 87.0 | 87.0 | 79.5 | 84.0 | 8892.0 |
| 2024-06-24 | ABTS | Stock | 6.45 | 7.29 | 6.375 | 6.525 | 5420.0 |
| 2024-06-24 | ABUS | Stock | 3.09 | 3.12 | 3.03 | 3.07 | 734200.0 |
| 2024-06-24 | ABVC | Stock | 0.731 | 0.763 | 0.713 | 0.759 | 37000.0 |
> showing 50 of 7,215 rows — these rows as CSV