PREVIEW / stock_daily / 2024-11-04
file: by_date/stock_daily/2024/2024-11-04.parquet size: 244 KB rows: 7,097 symbols: 666
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-11-04 | AAPL | Stock | 220.99 | 222.79 | 219.71 | 222.01 | 41461900.0 |
| 2024-11-04 | MSFT | Stock | 409.8 | 410.415 | 405.5713 | 408.46 | 18800817.0 |
| 2024-11-04 | NVDA | Stock | 137.21 | 138.96 | 135.57 | 136.05 | 184249472.0 |
| 2024-11-04 | AMZN | Stock | 196.45 | 197.33 | 194.3101 | 195.78 | 37212733.0 |
| 2024-11-04 | GOOGL | Stock | 169.93 | 170.73 | 168.011 | 169.24 | 21492744.0 |
| 2024-11-04 | META | Stock | 564.1 | 568.69 | 557.89 | 560.68 | 11714834.0 |
| 2024-11-04 | TSLA | Stock | 244.56 | 248.9 | 238.88 | 242.84 | 68053489.0 |
| 2024-11-04 | TLT | Stock | 92.28 | 92.57 | 91.63 | 92.25 | 49747594.0 |
| 2024-11-04 | ES | Stock | 63.43 | 64.16 | 63.02 | 63.4 | 2028705.0 |
| 2024-11-04 | CL | Stock | 93.28 | 94.22 | 93.13 | 93.61 | 3988938.0 |
| 2024-11-04 | A | Stock | 137.32 | 140.64 | 136.905 | 139.65 | 1766702.0 |
| 2024-11-04 | AA | Stock | 40.5 | 41.4199 | 40.28 | 40.73 | 2896235.0 |
| 2024-11-04 | AACG | Stock | 1.0 | 1.04 | 0.92 | 1.04 | 63740.0 |
| 2024-11-04 | AACT | Stock | 10.88 | 10.9 | 10.86 | 10.87 | 26869.0 |
| 2024-11-04 | AAGR-DELISTED | Stock | 0.0001 | 0.0003 | 0.0001 | 0.0002 | 7902.0 |
| 2024-11-04 | AAL | Stock | 13.5 | 13.5 | 12.96 | 12.99 | 25573154.0 |
| 2024-11-04 | AAM | Stock | 10.05 | 10.05 | 10.05 | 10.05 | 2845.0 |
| 2024-11-04 | AAME | Stock | 1.61 | 1.68 | 1.6 | 1.68 | 877.0 |
| 2024-11-04 | AAMI | Stock | 27.33 | 27.59 | 27.0 | 27.39 | 164838.0 |
| 2024-11-04 | AAOI | Stock | 16.84 | 17.43 | 16.3302 | 16.4 | 1890593.0 |
| 2024-11-04 | AAON | Stock | 112.82 | 114.395 | 112.3 | 112.46 | 254943.0 |
| 2024-11-04 | AAP | Stock | 36.35 | 38.94 | 36.315 | 37.45 | 3384770.0 |
| 2024-11-04 | AAT | Stock | 26.68 | 27.35 | 26.595 | 27.13 | 206411.0 |
| 2024-11-04 | AATC | Stock | 7.6475 | 7.65 | 7.52 | 7.52 | 2252.0 |
| 2024-11-04 | AAUAF-DELISTED | Stock | 0.0462 | 0.06 | 0.0436 | 0.055 | 156507.0 |
| 2024-11-04 | AAXJ | Stock | 76.98 | 77.16 | 76.56 | 76.56 | 1240090.0 |
| 2024-11-04 | AB | Stock | 36.6 | 37.14 | 35.96 | 36.11 | 322457.0 |
| 2024-11-04 | ABAT | Stock | 0.99 | 1.02 | 0.9801 | 1.0 | 505787.0 |
| 2024-11-04 | ABBV | Stock | 203.79 | 204.24 | 200.22 | 200.47 | 3217065.0 |
| 2024-11-04 | ABCB | Stock | 61.68 | 61.9 | 60.4101 | 61.23 | 201244.0 |
| 2024-11-04 | ABCL | Stock | 2.755 | 2.9 | 2.72 | 2.89 | 3629973.0 |
| 2024-11-04 | ABEO | Stock | 6.29 | 6.29 | 5.95 | 6.04 | 432107.0 |
| 2024-11-04 | ABEV | Stock | 2.18 | 2.22 | 2.17 | 2.21 | 20065630.0 |
| 2024-11-04 | ABG | Stock | 227.38 | 237.625 | 227.38 | 236.98 | 234504.0 |
| 2024-11-04 | ABLLW | Stock | 1.35 | 1.4057 | 1.33 | 1.33 | 4575.0 |
| 2024-11-04 | ABLV | Stock | 0.8823 | 0.92 | 0.8823 | 0.92 | 584.0 |
| 2024-11-04 | ABM | Stock | 52.93 | 54.25 | 52.93 | 54.18 | 205488.0 |
| 2024-11-04 | ABNB | Stock | 136.23 | 137.55 | 135.45 | 136.87 | 2419606.0 |
| 2024-11-04 | ABOS | Stock | 2.84 | 3.05 | 2.7901 | 2.95 | 195805.0 |
| 2024-11-04 | ABR | Stock | 14.87 | 14.91 | 14.55 | 14.7 | 2768707.0 |
| 2024-11-04 | ABR.D | Stock | 19.0 | 19.3 | 18.82 | 19.1 | 30166.0 |
| 2024-11-04 | ABR.E | Stock | 19.79 | 19.79 | 19.0049 | 19.5 | 4271.0 |
| 2024-11-04 | ABR.F | Stock | 20.5 | 20.7 | 20.22 | 20.22 | 28369.0 |
| 2024-11-04 | ABSI | Stock | 3.88 | 4.03 | 3.82 | 4.0 | 695319.0 |
| 2024-11-04 | ABT | Stock | 119.6 | 120.57 | 117.48 | 117.65 | 5429522.0 |
| 2024-11-04 | ABTC | Stock | 38.7 | 41.6625 | 38.325 | 38.9475 | 4337.0 |
| 2024-11-04 | ABTS | Stock | 8.7 | 8.85 | 7.755 | 8.6355 | 2489.0 |
| 2024-11-04 | ABUS | Stock | 3.96 | 3.96 | 3.855 | 3.87 | 930123.0 |
| 2024-11-04 | ABVC | Stock | 0.6537 | 0.67 | 0.615 | 0.6313 | 151857.0 |
| 2024-11-04 | ABVE | Stock | 0.381 | 0.395 | 0.38 | 0.38282 | 75501.0 |
> showing 50 of 7,097 rows — these rows as CSV