PREVIEW / stock_daily / 2024-12-20
file: by_date/stock_daily/2024/2024-12-20.parquet size: 246 KB rows: 7,195 symbols: 597
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-20 | AAPL | Stock | 248.04 | 255.0 | 245.69 | 254.49 | 119905705.0 |
| 2024-12-20 | MSFT | Stock | 433.11 | 443.74 | 428.63 | 436.6 | 55791031.0 |
| 2024-12-20 | NVDA | Stock | 129.81 | 135.28 | 128.22 | 134.7 | 295705455.0 |
| 2024-12-20 | AMZN | Stock | 219.84 | 226.21 | 218.73 | 224.92 | 76414581.0 |
| 2024-12-20 | GOOGL | Stock | 185.78 | 192.89 | 185.22 | 191.41 | 63462934.0 |
| 2024-12-20 | META | Stock | 590.58 | 603.11 | 580.0 | 585.25 | 47597440.0 |
| 2024-12-20 | TSLA | Stock | 425.505 | 447.08 | 417.64 | 421.06 | 128247322.0 |
| 2024-12-20 | TLT | Stock | 88.53 | 88.91 | 88.29 | 88.31 | 45542412.0 |
| 2024-12-20 | ES | Stock | 55.895 | 57.14 | 55.8186 | 56.95 | 5751723.0 |
| 2024-12-20 | CL | Stock | 92.44 | 93.15 | 91.46 | 92.03 | 7677141.0 |
| 2024-12-20 | A | Stock | 133.23 | 135.53 | 133.23 | 134.51 | 3896217.0 |
| 2024-12-20 | AA | Stock | 36.4 | 38.3 | 36.28 | 37.84 | 7523205.0 |
| 2024-12-20 | AACG | Stock | 0.849 | 0.86 | 0.8101 | 0.84 | 12096.0 |
| 2024-12-20 | AACT | Stock | 10.94 | 10.955 | 10.94 | 10.95 | 230378.0 |
| 2024-12-20 | AAGR-DELISTED | Stock | 0.0005 | 0.0005 | 0.0005 | 0.0005 | 136.0 |
| 2024-12-20 | AAL | Stock | 16.57 | 17.18 | 16.53 | 16.88 | 22196364.0 |
| 2024-12-20 | AAM | Stock | 10.08 | 10.0819 | 10.08 | 10.0819 | 6679.0 |
| 2024-12-20 | AAME | Stock | 1.51 | 1.55 | 1.46 | 1.48 | 6515.0 |
| 2024-12-20 | AAMI | Stock | 27.4 | 27.8 | 26.732 | 27.01 | 745495.0 |
| 2024-12-20 | AAOI | Stock | 32.0 | 37.94 | 31.5 | 37.82 | 5114266.0 |
| 2024-12-20 | AAON | Stock | 124.32 | 127.49 | 123.73 | 124.13 | 816918.0 |
| 2024-12-20 | AAP | Stock | 41.67 | 43.84 | 41.45 | 43.52 | 2386210.0 |
| 2024-12-20 | AAT | Stock | 25.37 | 26.165 | 25.37 | 26.0 | 1145684.0 |
| 2024-12-20 | AATC | Stock | 7.9045 | 8.01 | 7.9 | 7.9 | 6282.0 |
| 2024-12-20 | AAUAF-DELISTED | Stock | 0.03 | 0.0379 | 0.03 | 0.03436 | 41722.0 |
| 2024-12-20 | AAXJ | Stock | 72.14 | 73.02 | 72.05 | 72.62 | 260041.0 |
| 2024-12-20 | AB | Stock | 35.37 | 37.77 | 35.365 | 37.26 | 1142995.0 |
| 2024-12-20 | ABAT | Stock | 1.06 | 1.26 | 1.015 | 1.11 | 6960257.0 |
| 2024-12-20 | ABBV | Stock | 171.794 | 176.8 | 170.66 | 175.58 | 13296244.0 |
| 2024-12-20 | ABCB | Stock | 61.37 | 63.5 | 61.37 | 62.81 | 1174273.0 |
| 2024-12-20 | ABCL | Stock | 2.7 | 2.88 | 2.6818 | 2.85 | 2070961.0 |
| 2024-12-20 | ABEO | Stock | 5.64 | 5.79 | 5.56 | 5.7 | 203672.0 |
| 2024-12-20 | ABEV | Stock | 2.05 | 2.07 | 2.03 | 2.06 | 27631036.0 |
| 2024-12-20 | ABG | Stock | 241.61 | 249.375 | 238.375 | 245.77 | 498301.0 |
| 2024-12-20 | ABLLW | Stock | 1.15 | 1.15 | 1.1 | 1.1 | 5946.0 |
| 2024-12-20 | ABLV | Stock | 0.608 | 0.698 | 0.608 | 0.698 | 797.0 |
| 2024-12-20 | ABM | Stock | 50.65 | 51.24 | 50.29 | 50.34 | 1090224.0 |
| 2024-12-20 | ABNB | Stock | 128.63 | 135.82 | 128.34 | 134.21 | 13245032.0 |
| 2024-12-20 | ABOS | Stock | 1.78 | 1.86 | 1.75 | 1.85 | 751473.0 |
| 2024-12-20 | ABPWW | Stock | 0.05 | 0.1374 | 0.049 | 0.1021 | 787384.0 |
| 2024-12-20 | ABR | Stock | 13.58 | 13.97 | 13.5 | 13.76 | 4098771.0 |
| 2024-12-20 | ABR.D | Stock | 18.8 | 18.9 | 18.77 | 18.77 | 8644.0 |
| 2024-12-20 | ABR.E | Stock | 18.41 | 18.63 | 18.2906 | 18.63 | 4316.0 |
| 2024-12-20 | ABR.F | Stock | 22.87 | 23.04 | 22.68 | 22.93 | 19088.0 |
| 2024-12-20 | ABSI | Stock | 2.88 | 3.085 | 2.86 | 2.99 | 2432073.0 |
| 2024-12-20 | ABT | Stock | 112.64 | 115.11 | 112.52 | 114.23 | 10286012.0 |
| 2024-12-20 | ABTC | Stock | 34.5 | 37.5 | 32.25 | 33.480000000000004 | 18201.933333333334 |
| 2024-12-20 | ABTS | Stock | 7.35 | 7.35 | 6.7515 | 6.825 | 4453.0 |
| 2024-12-20 | ABUS | Stock | 3.18 | 3.26 | 3.16 | 3.21 | 2567749.0 |
| 2024-12-20 | ABVC | Stock | 0.508 | 0.53 | 0.49 | 0.524 | 100301.0 |
> showing 50 of 7,195 rows — these rows as CSV