PREVIEW / stock_daily / 2024-12-06
file: by_date/stock_daily/2024/2024-12-06.parquet size: 245 KB rows: 7,042 symbols: 605
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-06 | AAPL | Stock | 242.905 | 244.63 | 242.08 | 242.84 | 34168412.0 |
| 2024-12-06 | MSFT | Stock | 442.3 | 446.1 | 441.7703 | 443.57 | 17945861.0 |
| 2024-12-06 | NVDA | Stock | 144.6 | 145.7 | 141.31 | 142.44 | 179432847.0 |
| 2024-12-06 | AMZN | Stock | 220.75 | 227.15 | 220.6 | 227.03 | 42874681.0 |
| 2024-12-06 | GOOGL | Stock | 172.03 | 175.08 | 171.86 | 174.71 | 21462393.0 |
| 2024-12-06 | META | Stock | 610.1 | 629.7899 | 608.53 | 623.77 | 16812357.0 |
| 2024-12-06 | TSLA | Stock | 377.42 | 389.49 | 370.8 | 389.22 | 80008968.0 |
| 2024-12-06 | TLT | Stock | 94.72 | 94.85 | 94.02 | 94.39 | 31761525.0 |
| 2024-12-06 | ES | Stock | 61.65 | 61.88 | 59.67 | 59.78 | 2425672.0 |
| 2024-12-06 | CL | Stock | 95.2 | 96.085 | 94.2 | 94.23 | 4027182.0 |
| 2024-12-06 | A | Stock | 139.47 | 141.79 | 138.96 | 140.58 | 1265383.0 |
| 2024-12-06 | AA | Stock | 44.7 | 44.755 | 41.58 | 42.49 | 9295805.0 |
| 2024-12-06 | AACG | Stock | 0.9199 | 0.9199 | 0.82 | 0.8704 | 36625.0 |
| 2024-12-06 | AACT | Stock | 10.9284 | 10.9284 | 10.92 | 10.925 | 34649.0 |
| 2024-12-06 | AAL | Stock | 17.51 | 18.09 | 17.265 | 17.4 | 42879831.0 |
| 2024-12-06 | AAM | Stock | 10.08 | 10.08 | 10.07 | 10.07 | 5477.0 |
| 2024-12-06 | AAME | Stock | 1.5198 | 1.55 | 1.465 | 1.547 | 4261.0 |
| 2024-12-06 | AAMI | Stock | 31.21 | 31.21 | 30.63 | 30.93 | 118168.0 |
| 2024-12-06 | AAOI | Stock | 37.45 | 41.2899 | 36.35 | 38.88 | 6025871.0 |
| 2024-12-06 | AAON | Stock | 137.36 | 139.09 | 135.59 | 137.25 | 480430.0 |
| 2024-12-06 | AAP | Stock | 44.02 | 45.24 | 43.95 | 44.97 | 2192324.0 |
| 2024-12-06 | AAT | Stock | 27.83 | 27.96 | 27.64 | 27.74 | 197404.0 |
| 2024-12-06 | AATC | Stock | 8.03 | 8.03 | 7.95 | 7.9525 | 4477.0 |
| 2024-12-06 | AAUAF-DELISTED | Stock | 0.03405 | 0.0469 | 0.033 | 0.0355 | 119340.0 |
| 2024-12-06 | AAXJ | Stock | 75.46 | 75.49 | 75.07 | 75.1 | 214798.0 |
| 2024-12-06 | AB | Stock | 35.97 | 36.1753 | 35.45 | 35.6 | 253376.0 |
| 2024-12-06 | ABAT | Stock | 0.8844 | 0.899 | 0.86 | 0.888 | 247636.0 |
| 2024-12-06 | ABBV | Stock | 176.0 | 176.74 | 174.16 | 176.19 | 4704507.0 |
| 2024-12-06 | ABCB | Stock | 69.28 | 69.5923 | 68.5 | 69.39 | 175726.0 |
| 2024-12-06 | ABCL | Stock | 2.9 | 3.045 | 2.85 | 3.0 | 2369645.0 |
| 2024-12-06 | ABEO | Stock | 6.05 | 6.05 | 5.97 | 6.03 | 150686.0 |
| 2024-12-06 | ABEV | Stock | 2.35 | 2.365 | 2.27 | 2.29 | 39635419.0 |
| 2024-12-06 | ABG | Stock | 261.7 | 262.98 | 256.03 | 258.98 | 98201.0 |
| 2024-12-06 | ABLLW | Stock | 1.13 | 1.19 | 1.09 | 1.13 | 9702.0 |
| 2024-12-06 | ABLV | Stock | 0.7931 | 0.7931 | 0.7001 | 0.71 | 13607.0 |
| 2024-12-06 | ABM | Stock | 57.93 | 57.93 | 56.88 | 57.44 | 244102.0 |
| 2024-12-06 | ABNB | Stock | 137.75 | 138.86 | 136.56 | 136.92 | 4203370.0 |
| 2024-12-06 | ABOS | Stock | 2.12 | 2.185 | 2.12 | 2.16 | 366612.0 |
| 2024-12-06 | ABR | Stock | 14.1 | 14.34 | 14.06 | 14.31 | 1623334.0 |
| 2024-12-06 | ABR.D | Stock | 19.05 | 19.275 | 19.0386 | 19.08 | 25465.0 |
| 2024-12-06 | ABR.E | Stock | 18.6 | 18.74 | 18.55 | 18.55 | 33969.0 |
| 2024-12-06 | ABR.F | Stock | 21.5 | 21.6599 | 21.21 | 21.21 | 27437.0 |
| 2024-12-06 | ABSI | Stock | 2.95 | 3.26 | 2.95 | 3.11 | 3188760.0 |
| 2024-12-06 | ABT | Stock | 115.13 | 116.2 | 115.1 | 115.6 | 5177886.0 |
| 2024-12-06 | ABTC | Stock | 50.9775 | 51.614999999999995 | 46.7625 | 48.705 | 10620.533333333333 |
| 2024-12-06 | ABTS | Stock | 10.3455 | 10.365 | 9.4575 | 9.8085 | 4154.0 |
| 2024-12-06 | ABUS | Stock | 3.59 | 3.725 | 3.59 | 3.68 | 476468.0 |
| 2024-12-06 | ABVC | Stock | 0.54 | 0.54 | 0.498 | 0.5049 | 126579.0 |
| 2024-12-06 | ABVE | Stock | 0.5831 | 0.675 | 0.572 | 0.6 | 82844.0 |
| 2024-12-06 | ABVEW | Stock | 0.0283 | 0.0283 | 0.0223 | 0.0253 | 23563.0 |
> showing 50 of 7,042 rows — these rows as CSV