PREVIEW / stock_daily / 2024-12-18
file: by_date/stock_daily/2024/2024-12-18.parquet size: 246 KB rows: 7,200 symbols: 604
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-18 | AAPL | Stock | 252.16 | 254.28 | 247.74 | 248.05 | 54394239.0 |
| 2024-12-18 | MSFT | Stock | 451.32 | 452.65 | 437.02 | 437.39 | 23365892.0 |
| 2024-12-18 | NVDA | Stock | 133.86 | 136.7 | 128.28 | 128.91 | 264633207.0 |
| 2024-12-18 | AMZN | Stock | 230.77 | 231.3999 | 220.11 | 220.52 | 41596623.0 |
| 2024-12-18 | GOOGL | Stock | 195.22 | 197.0 | 187.74 | 188.4 | 34166074.0 |
| 2024-12-18 | META | Stock | 621.0 | 627.36 | 596.32 | 597.19 | 16274719.0 |
| 2024-12-18 | TSLA | Stock | 466.495 | 488.5399 | 427.01 | 440.13 | 147548703.0 |
| 2024-12-18 | TLT | Stock | 89.97 | 90.37 | 89.14 | 89.16 | 61328421.0 |
| 2024-12-18 | ES | Stock | 57.53 | 58.05 | 56.13 | 56.16 | 2350799.0 |
| 2024-12-18 | CL | Stock | 92.86 | 94.13 | 92.68 | 92.75 | 4586179.0 |
| 2024-12-18 | A | Stock | 136.95 | 137.57 | 132.91 | 133.01 | 1696139.0 |
| 2024-12-18 | AA | Stock | 38.46 | 39.31 | 36.92 | 37.31 | 4269698.0 |
| 2024-12-18 | AACG | Stock | 0.86 | 0.86 | 0.8022 | 0.81 | 27618.0 |
| 2024-12-18 | AACT | Stock | 10.98 | 10.98 | 10.94 | 10.95 | 28649.0 |
| 2024-12-18 | AAGR-DELISTED | Stock | 0.0074 | 0.0074 | 0.0 | 0.0 | 814.0 |
| 2024-12-18 | AAGRW-DELISTED | Stock | 0.0 | 0.0 | 0.0 | 0.0 | 8091.0 |
| 2024-12-18 | AAL | Stock | 16.77 | 17.28 | 16.26 | 16.47 | 24915084.0 |
| 2024-12-18 | AAM | Stock | 10.08 | 10.09 | 10.08 | 10.08 | 43128.0 |
| 2024-12-18 | AAME | Stock | 1.53 | 1.53 | 1.45 | 1.45 | 4801.0 |
| 2024-12-18 | AAMI | Stock | 29.82 | 30.16 | 28.3035 | 28.38 | 391634.0 |
| 2024-12-18 | AAOI | Stock | 33.06 | 38.95 | 33.05 | 33.97 | 5188804.0 |
| 2024-12-18 | AAON | Stock | 129.68 | 131.41 | 122.45 | 122.57 | 600152.0 |
| 2024-12-18 | AAP | Stock | 44.6 | 45.32 | 42.925 | 42.97 | 1695067.0 |
| 2024-12-18 | AAT | Stock | 27.54 | 27.56 | 25.73 | 25.91 | 346976.0 |
| 2024-12-18 | AATC | Stock | 7.93 | 7.93 | 7.84 | 7.84 | 10821.0 |
| 2024-12-18 | AAUAF-DELISTED | Stock | 0.036 | 0.051 | 0.036 | 0.0399 | 75799.0 |
| 2024-12-18 | AAXJ | Stock | 73.77 | 73.94 | 72.105 | 72.15 | 498904.0 |
| 2024-12-18 | AB | Stock | 35.65 | 36.09 | 34.6865 | 34.69 | 967034.0 |
| 2024-12-18 | ABAT | Stock | 1.17 | 1.24 | 0.88 | 0.88 | 35779563.0 |
| 2024-12-18 | ABBV | Stock | 176.03 | 176.5 | 172.82 | 173.02 | 5274545.0 |
| 2024-12-18 | ABCB | Stock | 65.94 | 66.17 | 61.74 | 62.08 | 593644.0 |
| 2024-12-18 | ABCL | Stock | 2.835 | 2.84 | 2.66 | 2.69 | 4473191.0 |
| 2024-12-18 | ABEO | Stock | 5.9 | 5.905 | 5.56 | 5.63 | 336476.0 |
| 2024-12-18 | ABEV | Stock | 2.08 | 2.09 | 2.01 | 2.02 | 30411373.0 |
| 2024-12-18 | ABG | Stock | 253.36 | 255.83 | 243.43 | 243.51 | 162200.0 |
| 2024-12-18 | ABLLW | Stock | 1.19 | 1.19 | 1.07 | 1.07 | 56944.0 |
| 2024-12-18 | ABLV | Stock | 0.70601 | 0.71 | 0.652 | 0.652 | 4751.0 |
| 2024-12-18 | ABLVW | Stock | 0.0113 | 0.0114 | 0.0113 | 0.0114 | 600.0 |
| 2024-12-18 | ABM | Stock | 49.73 | 53.17 | 49.2142 | 50.32 | 1018733.0 |
| 2024-12-18 | ABNB | Stock | 132.025 | 133.71 | 127.23 | 127.54 | 4182609.0 |
| 2024-12-18 | ABOS | Stock | 1.95 | 1.965 | 1.76 | 1.79 | 353840.0 |
| 2024-12-18 | ABPWW | Stock | 0.0255 | 0.0255 | 0.0254 | 0.0254 | 13159.0 |
| 2024-12-18 | ABR | Stock | 14.31 | 14.36 | 13.65 | 13.76 | 3580073.0 |
| 2024-12-18 | ABR.D | Stock | 19.05 | 19.5 | 18.9765 | 19.19 | 32276.0 |
| 2024-12-18 | ABR.E | Stock | 18.6 | 18.65 | 18.5 | 18.56 | 7798.0 |
| 2024-12-18 | ABR.F | Stock | 22.92 | 22.9821 | 22.42 | 22.75 | 27271.0 |
| 2024-12-18 | ABSI | Stock | 3.35 | 3.48 | 2.905 | 3.04 | 3381341.0 |
| 2024-12-18 | ABT | Stock | 113.03 | 114.15 | 111.85 | 111.93 | 5233822.0 |
| 2024-12-18 | ABTC | Stock | 39.75 | 40.1625 | 28.5 | 28.7175 | 31417.6 |
| 2024-12-18 | ABTS | Stock | 7.65 | 8.7 | 7.3725 | 8.055 | 9057.0 |
> showing 50 of 7,200 rows — these rows as CSV