PREVIEW / stock_daily / 2024-12-12
file: by_date/stock_daily/2024/2024-12-12.parquet size: 246 KB rows: 7,157 symbols: 614
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-12 | AAPL | Stock | 246.89 | 248.74 | 245.68 | 247.96 | 30824280.0 |
| 2024-12-12 | MSFT | Stock | 449.11 | 456.1648 | 449.11 | 449.56 | 19711687.0 |
| 2024-12-12 | NVDA | Stock | 137.08 | 138.44 | 135.8 | 137.34 | 154490896.0 |
| 2024-12-12 | AMZN | Stock | 229.83 | 231.09 | 227.63 | 228.97 | 27282759.0 |
| 2024-12-12 | GOOGL | Stock | 195.0 | 195.18 | 191.71 | 191.96 | 34817486.0 |
| 2024-12-12 | META | Stock | 631.5 | 636.6599 | 627.2094 | 630.79 | 7288013.0 |
| 2024-12-12 | TSLA | Stock | 424.84 | 429.3 | 415.0 | 418.1 | 86964081.0 |
| 2024-12-12 | TLT | Stock | 91.64 | 91.746 | 91.0 | 91.08 | 45368386.0 |
| 2024-12-12 | ES | Stock | 59.96 | 60.3 | 59.48 | 59.79 | 2078376.0 |
| 2024-12-12 | CL | Stock | 93.04 | 94.03 | 92.55 | 93.56 | 3356952.0 |
| 2024-12-12 | A | Stock | 140.5 | 141.715 | 139.88 | 140.91 | 946352.0 |
| 2024-12-12 | AA | Stock | 39.4 | 39.89 | 39.045 | 39.62 | 3915474.0 |
| 2024-12-12 | AACG | Stock | 0.89 | 0.89 | 0.8503 | 0.88 | 8596.0 |
| 2024-12-12 | AACT | Stock | 10.93 | 10.95 | 10.93 | 10.95 | 17423.0 |
| 2024-12-12 | AAGR-DELISTED | Stock | 0.008 | 0.008 | 0.0001 | 0.0001 | 2839.0 |
| 2024-12-12 | AAL | Stock | 17.61 | 17.8 | 17.225 | 17.24 | 17537734.0 |
| 2024-12-12 | AAM | Stock | 10.07 | 10.075 | 10.07 | 10.07 | 398781.0 |
| 2024-12-12 | AAME | Stock | 1.55 | 1.55 | 1.49 | 1.53 | 4410.0 |
| 2024-12-12 | AAMI | Stock | 30.78 | 30.94 | 30.2 | 30.29 | 136847.0 |
| 2024-12-12 | AAOI | Stock | 33.5 | 35.4486 | 32.95 | 33.0 | 2449524.0 |
| 2024-12-12 | AAON | Stock | 132.45 | 133.3875 | 130.92 | 131.27 | 132556.0 |
| 2024-12-12 | AAP | Stock | 45.33 | 45.64 | 42.92 | 44.04 | 1933782.0 |
| 2024-12-12 | AAT | Stock | 27.62 | 27.97 | 27.62 | 27.65 | 187097.0 |
| 2024-12-12 | AATC | Stock | 7.95 | 8.15 | 7.95 | 8.12 | 604.0 |
| 2024-12-12 | AAUAF-DELISTED | Stock | 0.033 | 0.041 | 0.033 | 0.041 | 128159.0 |
| 2024-12-12 | AAXJ | Stock | 75.22 | 75.57 | 75.15 | 75.27 | 478917.0 |
| 2024-12-12 | AB | Stock | 36.08 | 36.47 | 36.0 | 36.17 | 210592.0 |
| 2024-12-12 | ABAT | Stock | 1.0 | 1.0 | 0.923 | 0.9765 | 406766.0 |
| 2024-12-12 | ABBV | Stock | 174.91 | 175.9061 | 171.99 | 173.19 | 4813167.0 |
| 2024-12-12 | ABCB | Stock | 67.75 | 68.04 | 66.96 | 67.41 | 313986.0 |
| 2024-12-12 | ABCL | Stock | 2.88 | 2.96 | 2.79 | 2.95 | 3681236.0 |
| 2024-12-12 | ABEO | Stock | 6.0 | 6.04 | 5.83 | 5.91 | 158374.0 |
| 2024-12-12 | ABEV | Stock | 2.21 | 2.22 | 2.17 | 2.18 | 42126281.0 |
| 2024-12-12 | ABG | Stock | 255.06 | 256.94 | 253.18 | 254.95 | 100976.0 |
| 2024-12-12 | ABLLW | Stock | 1.15 | 1.1501 | 1.13 | 1.15 | 22406.0 |
| 2024-12-12 | ABLV | Stock | 0.686 | 0.686 | 0.6105 | 0.62 | 4665.0 |
| 2024-12-12 | ABLVW | Stock | 0.0132 | 0.0133 | 0.0132 | 0.0133 | 2012.0 |
| 2024-12-12 | ABM | Stock | 56.5 | 56.8 | 56.2334 | 56.44 | 170643.0 |
| 2024-12-12 | ABNB | Stock | 138.1 | 139.1 | 134.4001 | 137.47 | 4221610.0 |
| 2024-12-12 | ABOS | Stock | 2.15 | 2.24 | 2.0508 | 2.07 | 336140.0 |
| 2024-12-12 | ABR | Stock | 14.31 | 14.54 | 14.22 | 14.27 | 1511718.0 |
| 2024-12-12 | ABR.D | Stock | 19.18 | 19.3109 | 18.8258 | 19.3 | 21700.0 |
| 2024-12-12 | ABR.E | Stock | 18.702 | 18.75 | 18.35 | 18.75 | 29579.0 |
| 2024-12-12 | ABR.F | Stock | 22.24 | 22.71 | 22.1848 | 22.38 | 17191.0 |
| 2024-12-12 | ABSI | Stock | 4.5 | 4.51 | 3.46 | 3.68 | 6567488.0 |
| 2024-12-12 | ABT | Stock | 114.4 | 114.775 | 113.3 | 113.86 | 3599615.0 |
| 2024-12-12 | ABTC | Stock | 44.4 | 45.6 | 41.2575 | 43.987500000000004 | 7617.8 |
| 2024-12-12 | ABTS | Stock | 8.85 | 8.85 | 6.15 | 6.75 | 19951.0 |
| 2024-12-12 | ABUS | Stock | 3.64 | 3.75 | 3.56 | 3.56 | 648156.0 |
| 2024-12-12 | ABVC | Stock | 0.52 | 0.52 | 0.4716 | 0.515 | 343411.0 |
> showing 50 of 7,157 rows — these rows as CSV