PREVIEW / stock_daily / 2024-06-25
file: by_date/stock_daily/2024/2024-06-25.parquet size: 231 KB rows: 7,220 symbols: 939
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-25 | AAPL | Stock | 209.15 | 211.38 | 208.61 | 209.07 | 56713900.0 |
| 2024-06-25 | MSFT | Stock | 448.25 | 451.42 | 446.75 | 450.95 | 16747500.0 |
| 2024-06-25 | NVDA | Stock | 121.2 | 126.5 | 119.32 | 126.09 | 425787500.0 |
| 2024-06-25 | AMZN | Stock | 186.81 | 188.84 | 185.42 | 186.34 | 45898500.0 |
| 2024-06-25 | GOOGL | Stock | 179.62 | 184.29 | 179.42 | 184.03 | 23235589.0 |
| 2024-06-25 | META | Stock | 497.05 | 510.71 | 495.5 | 510.6 | 12109800.0 |
| 2024-06-25 | TSLA | Stock | 184.4 | 187.97 | 182.01 | 187.35 | 63678300.0 |
| 2024-06-25 | TLT | Stock | 94.07 | 94.55 | 94.04 | 94.5 | 23160000.0 |
| 2024-06-25 | ES | Stock | 58.08 | 58.35 | 57.03 | 57.09 | 1543600.0 |
| 2024-06-25 | CL | Stock | 99.0 | 99.08 | 98.32 | 98.7 | 6376800.0 |
| 2024-06-25 | A | Stock | 135.0 | 136.01 | 134.29 | 134.69 | 2310800.0 |
| 2024-06-25 | AA | Stock | 40.1 | 40.19 | 39.17 | 39.94 | 3066200.0 |
| 2024-06-25 | AACG | Stock | 0.82 | 0.83 | 0.82 | 0.83 | 6100.0 |
| 2024-06-25 | AACIW-DELISTED | Stock | 0.1432 | 0.1432 | 0.129 | 0.1395 | 618.0 |
| 2024-06-25 | AACT | Stock | 10.65 | 10.67 | 10.65 | 10.65 | 751200.0 |
| 2024-06-25 | AAGR-DELISTED | Stock | 0.2425 | 0.26 | 0.2411 | 0.2472 | 60685.0 |
| 2024-06-25 | AAL | Stock | 11.18 | 11.37 | 11.12 | 11.13 | 28547300.0 |
| 2024-06-25 | AAMC-DELISTED | Stock | 1.74 | 1.995 | 1.72 | 1.995 | 1200.0 |
| 2024-06-25 | AAME | Stock | 1.65 | 1.66 | 1.65 | 1.66 | 900.0 |
| 2024-06-25 | AAMI | Stock | 22.21 | 22.24 | 21.94 | 22.23 | 183400.0 |
| 2024-06-25 | AAN-DELISTED | Stock | 9.94 | 10.06 | 9.9 | 9.96 | 1471300.0 |
| 2024-06-25 | AAOI | Stock | 8.68 | 8.8 | 8.48 | 8.59 | 1169400.0 |
| 2024-06-25 | AAON | Stock | 80.29 | 84.85 | 79.68 | 84.74 | 924200.0 |
| 2024-06-25 | AAP | Stock | 65.05 | 65.19 | 63.4 | 63.69 | 1212200.0 |
| 2024-06-25 | AAT | Stock | 21.54 | 21.55 | 21.21 | 21.39 | 244400.0 |
| 2024-06-25 | AATC | Stock | 6.02 | 6.02 | 5.95 | 6.0 | 2548.0 |
| 2024-06-25 | AAUAF-DELISTED | Stock | 0.07055 | 0.07794 | 0.059 | 0.073 | 117360.0 |
| 2024-06-25 | AAXJ | Stock | 71.95 | 71.98 | 71.75 | 71.96 | 304788.0 |
| 2024-06-25 | AB | Stock | 33.7 | 33.89 | 33.6 | 33.76 | 110300.0 |
| 2024-06-25 | ABAT | Stock | 1.05 | 1.11 | 1.05 | 1.05 | 1044862.0 |
| 2024-06-25 | ABBV | Stock | 172.1 | 173.41 | 170.62 | 170.75 | 5712700.0 |
| 2024-06-25 | ABCB | Stock | 48.19 | 48.35 | 47.87 | 47.98 | 158200.0 |
| 2024-06-25 | ABCL | Stock | 2.82 | 2.82 | 2.71 | 2.73 | 3085700.0 |
| 2024-06-25 | ABEO | Stock | 4.3 | 4.31 | 4.1 | 4.22 | 382700.0 |
| 2024-06-25 | ABEV | Stock | 2.08 | 2.11 | 2.08 | 2.1 | 25162000.0 |
| 2024-06-25 | ABG | Stock | 228.23 | 228.64 | 223.04 | 223.66 | 290200.0 |
| 2024-06-25 | ABLLW | Stock | 0.67 | 0.7275 | 0.63 | 0.7275 | 39536.0 |
| 2024-06-25 | ABLV | Stock | 0.986 | 0.986 | 0.986 | 0.986 | 400.0 |
| 2024-06-25 | ABM | Stock | 51.33 | 51.39 | 50.69 | 50.77 | 561700.0 |
| 2024-06-25 | ABNB | Stock | 148.97 | 151.275 | 148.85 | 150.91 | 5008300.0 |
| 2024-06-25 | ABOS | Stock | 2.25 | 2.285 | 2.14 | 2.14 | 432600.0 |
| 2024-06-25 | ABR | Stock | 14.2 | 14.23 | 14.1 | 14.14 | 1347700.0 |
| 2024-06-25 | ABR.D | Stock | 18.52 | 18.6 | 18.4211 | 18.6 | 9718.0 |
| 2024-06-25 | ABR.E | Stock | 18.09 | 18.1 | 18.03 | 18.0658 | 6708.0 |
| 2024-06-25 | ABR.F | Stock | 20.11 | 20.3799 | 20.092 | 20.22 | 5855.0 |
| 2024-06-25 | ABSI | Stock | 3.05 | 3.15 | 2.93 | 2.94 | 1675300.0 |
| 2024-06-25 | ABT | Stock | 105.4 | 105.98 | 104.82 | 105.49 | 4722600.0 |
| 2024-06-25 | ABTC | Stock | 84.0 | 86.25 | 81.0 | 84.0 | 3156.0 |
| 2024-06-25 | ABTS | Stock | 6.45 | 6.99 | 6.45 | 6.99 | 1673.0 |
| 2024-06-25 | ABUS | Stock | 3.06 | 3.08 | 2.99 | 3.05 | 598700.0 |
> showing 50 of 7,220 rows — these rows as CSV