PREVIEW / stock_daily / 2024-12-19
file: by_date/stock_daily/2024/2024-12-19.parquet size: 245 KB rows: 7,149 symbols: 588
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-19 | AAPL | Stock | 247.5 | 252.0 | 247.0949 | 249.79 | 53101363.0 |
| 2024-12-19 | MSFT | Stock | 441.62 | 443.1834 | 436.32 | 437.03 | 19685638.0 |
| 2024-12-19 | NVDA | Stock | 131.76 | 134.03 | 129.55 | 130.68 | 197604614.0 |
| 2024-12-19 | AMZN | Stock | 224.91 | 226.09 | 222.92 | 223.29 | 33907180.0 |
| 2024-12-19 | GOOGL | Stock | 191.625 | 193.03 | 188.38 | 188.51 | 32265241.0 |
| 2024-12-19 | META | Stock | 610.39 | 611.52 | 595.0 | 595.57 | 13154731.0 |
| 2024-12-19 | TSLA | Stock | 451.88 | 456.36 | 420.02 | 436.17 | 120819745.0 |
| 2024-12-19 | TLT | Stock | 88.07 | 88.385 | 87.505 | 87.81 | 99083313.0 |
| 2024-12-19 | ES | Stock | 56.15 | 56.86 | 55.89 | 55.9 | 2488601.0 |
| 2024-12-19 | CL | Stock | 92.66 | 93.62 | 92.11 | 92.92 | 5778007.0 |
| 2024-12-19 | A | Stock | 133.14 | 134.27 | 131.62 | 133.19 | 2083649.0 |
| 2024-12-19 | AA | Stock | 37.75 | 38.15 | 36.52 | 36.62 | 3991220.0 |
| 2024-12-19 | AACG | Stock | 0.802 | 0.84 | 0.7 | 0.829 | 48524.0 |
| 2024-12-19 | AACT | Stock | 10.95 | 10.96 | 10.94 | 10.95 | 39813.0 |
| 2024-12-19 | AAL | Stock | 16.65 | 16.795 | 16.48 | 16.64 | 17745462.0 |
| 2024-12-19 | AAM | Stock | 10.0835 | 10.0835 | 10.08 | 10.08 | 50333.0 |
| 2024-12-19 | AAME | Stock | 1.5046 | 1.5201 | 1.5 | 1.51 | 2165.0 |
| 2024-12-19 | AAMI | Stock | 28.79 | 28.82 | 27.69 | 28.02 | 215063.0 |
| 2024-12-19 | AAOI | Stock | 34.9 | 36.4542 | 31.5 | 32.39 | 3786684.0 |
| 2024-12-19 | AAON | Stock | 124.35 | 126.79 | 123.22 | 123.83 | 443142.0 |
| 2024-12-19 | AAP | Stock | 43.45 | 44.16 | 41.17 | 41.96 | 2130935.0 |
| 2024-12-19 | AAT | Stock | 25.94 | 26.2808 | 25.42 | 25.42 | 355774.0 |
| 2024-12-19 | AATC | Stock | 7.84 | 7.89 | 7.7 | 7.89 | 2976.0 |
| 2024-12-19 | AAUAF-DELISTED | Stock | 0.0375 | 0.044 | 0.0323 | 0.0323 | 587090.0 |
| 2024-12-19 | AAXJ | Stock | 72.81 | 72.96 | 72.48 | 72.48 | 525884.0 |
| 2024-12-19 | AB | Stock | 34.76 | 35.96 | 34.6215 | 35.52 | 593238.0 |
| 2024-12-19 | ABAT | Stock | 0.94 | 1.19 | 0.905 | 1.11 | 7315800.0 |
| 2024-12-19 | ABBV | Stock | 172.93 | 173.88 | 170.3411 | 171.52 | 5463779.0 |
| 2024-12-19 | ABCB | Stock | 63.54 | 63.92 | 61.74 | 61.95 | 400184.0 |
| 2024-12-19 | ABCL | Stock | 2.71 | 2.75 | 2.62 | 2.71 | 2350013.0 |
| 2024-12-19 | ABEO | Stock | 5.67 | 5.725 | 5.4515 | 5.63 | 218607.0 |
| 2024-12-19 | ABEV | Stock | 2.09 | 2.09 | 2.02 | 2.03 | 31731143.0 |
| 2024-12-19 | ABG | Stock | 248.71 | 249.0 | 240.685 | 243.86 | 151119.0 |
| 2024-12-19 | ABLLW | Stock | 1.07 | 1.2 | 1.05 | 1.05 | 34359.0 |
| 2024-12-19 | ABLV | Stock | 0.6519 | 0.7276 | 0.646 | 0.67 | 4893.0 |
| 2024-12-19 | ABLVW | Stock | 0.012 | 0.012 | 0.0113 | 0.012 | 1706.0 |
| 2024-12-19 | ABM | Stock | 51.18 | 52.49 | 50.71 | 51.14 | 656933.0 |
| 2024-12-19 | ABNB | Stock | 129.13 | 131.08 | 127.91 | 129.35 | 4586091.0 |
| 2024-12-19 | ABOS | Stock | 1.84 | 1.87 | 1.715 | 1.8 | 366685.0 |
| 2024-12-19 | ABPWW | Stock | 0.05 | 0.06 | 0.0278 | 0.0495 | 33448.0 |
| 2024-12-19 | ABR | Stock | 13.88 | 14.04 | 13.71 | 13.71 | 2201450.0 |
| 2024-12-19 | ABR.D | Stock | 19.2 | 19.2 | 18.76 | 18.85 | 33711.0 |
| 2024-12-19 | ABR.E | Stock | 18.7047 | 18.7084 | 18.13 | 18.38 | 11263.0 |
| 2024-12-19 | ABR.F | Stock | 22.58 | 23.04 | 22.41 | 23.04 | 31224.0 |
| 2024-12-19 | ABSI | Stock | 3.13 | 3.15 | 2.7925 | 2.92 | 2625375.0 |
| 2024-12-19 | ABT | Stock | 111.54 | 113.295 | 111.28 | 112.42 | 5850794.0 |
| 2024-12-19 | ABTC | Stock | 31.5 | 36.57 | 29.25 | 34.545 | 17514.2 |
| 2024-12-19 | ABTS | Stock | 8.625 | 8.625 | 7.4205 | 7.4222 | 1797.0 |
| 2024-12-19 | ABUS | Stock | 3.21 | 3.26 | 3.14 | 3.21 | 735366.0 |
| 2024-12-19 | ABVC | Stock | 0.49 | 0.54 | 0.485 | 0.5177 | 188565.0 |
> showing 50 of 7,149 rows — these rows as CSV