PREVIEW / stock_daily / 2024-12-26
file: by_date/stock_daily/2024/2024-12-26.parquet size: 244 KB rows: 7,102 symbols: 550
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-12-26 | AAPL | Stock | 258.19 | 260.1 | 257.63 | 259.02 | 26193570.0 |
| 2024-12-26 | MSFT | Stock | 439.08 | 440.94 | 436.63 | 438.11 | 7962362.0 |
| 2024-12-26 | NVDA | Stock | 139.7 | 140.85 | 137.73 | 139.93 | 113925161.0 |
| 2024-12-26 | AMZN | Stock | 228.5 | 228.5 | 226.6706 | 227.05 | 15691010.0 |
| 2024-12-26 | GOOGL | Stock | 195.15 | 196.748 | 194.375 | 195.6 | 12057210.0 |
| 2024-12-26 | META | Stock | 605.48 | 606.3 | 598.94 | 603.35 | 5973131.0 |
| 2024-12-26 | TSLA | Stock | 465.16 | 465.3299 | 451.02 | 454.13 | 76129128.0 |
| 2024-12-26 | TLT | Stock | 87.21 | 87.96 | 87.2 | 87.82 | 19996215.0 |
| 2024-12-26 | ES | Stock | 57.02 | 57.635 | 57.0 | 57.34 | 1216685.0 |
| 2024-12-26 | CL | Stock | 92.1 | 92.54 | 91.92 | 92.37 | 1867342.0 |
| 2024-12-26 | A | Stock | 135.01 | 135.98 | 134.97 | 135.83 | 540384.0 |
| 2024-12-26 | AA | Stock | 38.54 | 38.58 | 38.07 | 38.35 | 1857765.0 |
| 2024-12-26 | AACG | Stock | 0.8 | 0.838 | 0.7613 | 0.7801 | 51370.0 |
| 2024-12-26 | AAGR-DELISTED | Stock | 0.0 | 0.008 | 0.0 | 0.0001 | 168176.0 |
| 2024-12-26 | AAL | Stock | 17.07 | 17.39 | 17.05 | 17.35 | 10346197.0 |
| 2024-12-26 | AAM | Stock | 10.0889 | 10.089 | 10.08 | 10.08 | 129339.0 |
| 2024-12-26 | AAME | Stock | 1.46 | 1.5323 | 1.46 | 1.4967 | 1492.0 |
| 2024-12-26 | AAMI | Stock | 26.85 | 27.49 | 26.61 | 27.37 | 108625.0 |
| 2024-12-26 | AAOI | Stock | 39.18 | 41.27 | 38.212 | 40.94 | 1953000.0 |
| 2024-12-26 | AAON | Stock | 123.18 | 123.69 | 122.43 | 122.68 | 338623.0 |
| 2024-12-26 | AAP | Stock | 43.37 | 45.3 | 43.33 | 44.24 | 1335162.0 |
| 2024-12-26 | AAT | Stock | 26.14 | 26.55 | 26.12 | 26.51 | 105888.0 |
| 2024-12-26 | AATC | Stock | 8.0 | 8.2 | 8.0 | 8.01 | 5821.0 |
| 2024-12-26 | AAUAF-DELISTED | Stock | 0.03635 | 0.0413 | 0.033 | 0.0387 | 197240.0 |
| 2024-12-26 | AAXJ | Stock | 72.93 | 73.46 | 72.93 | 73.3 | 109577.0 |
| 2024-12-26 | AB | Stock | 36.8 | 37.45 | 36.73 | 37.41 | 154200.0 |
| 2024-12-26 | ABAT | Stock | 2.835 | 3.85 | 2.6 | 3.14 | 34857537.0 |
| 2024-12-26 | ABBV | Stock | 179.02 | 180.35 | 178.63 | 179.2 | 2481984.0 |
| 2024-12-26 | ABCB | Stock | 62.82 | 64.07 | 62.78 | 63.96 | 230700.0 |
| 2024-12-26 | ABCL | Stock | 2.9 | 3.07 | 2.89 | 3.03 | 2986076.0 |
| 2024-12-26 | ABEO | Stock | 5.63 | 5.73 | 5.585 | 5.72 | 128864.0 |
| 2024-12-26 | ABEV | Stock | 1.91 | 1.9102 | 1.88 | 1.89 | 37175121.0 |
| 2024-12-26 | ABG | Stock | 245.67 | 249.566 | 245.67 | 249.27 | 62968.0 |
| 2024-12-26 | ABLLW | Stock | 1.01 | 1.15 | 1.01 | 1.14 | 5307.0 |
| 2024-12-26 | ABLV | Stock | 0.75 | 0.7675 | 0.6824 | 0.74 | 2538.0 |
| 2024-12-26 | ABM | Stock | 50.48 | 51.5252 | 50.425 | 51.36 | 339975.0 |
| 2024-12-26 | ABNB | Stock | 134.24 | 136.27 | 134.24 | 135.32 | 2015153.0 |
| 2024-12-26 | ABOS | Stock | 1.78 | 1.9 | 1.7 | 1.89 | 589572.0 |
| 2024-12-26 | ABPWW | Stock | 0.14 | 0.14 | 0.08 | 0.12 | 5450.0 |
| 2024-12-26 | ABR | Stock | 13.91 | 14.0 | 13.84 | 13.92 | 1206081.0 |
| 2024-12-26 | ABR.D | Stock | 19.02 | 19.1 | 19.0 | 19.0 | 10273.0 |
| 2024-12-26 | ABR.E | Stock | 18.5537 | 18.7 | 18.4343 | 18.7 | 4042.0 |
| 2024-12-26 | ABR.F | Stock | 23.05 | 23.1 | 22.7001 | 23.01 | 34787.0 |
| 2024-12-26 | ABSI | Stock | 3.01 | 3.09 | 2.915 | 2.98 | 1612710.0 |
| 2024-12-26 | ABT | Stock | 114.2 | 115.81 | 113.8203 | 115.27 | 2878172.0 |
| 2024-12-26 | ABTC | Stock | 31.755 | 34.29 | 30.9975 | 33.36000000000001 | 7576.466666666666 |
| 2024-12-26 | ABTS | Stock | 6.75 | 7.3425 | 6.6585 | 6.6585 | 6019.0 |
| 2024-12-26 | ABUS | Stock | 3.15 | 3.21 | 3.135 | 3.19 | 783784.0 |
| 2024-12-26 | ABVC | Stock | 0.51 | 0.592 | 0.51 | 0.559 | 218208.0 |
| 2024-12-26 | ABVE | Stock | 0.5397 | 0.5397 | 0.5094 | 0.518 | 19876.0 |
> showing 50 of 7,102 rows — these rows as CSV