PREVIEW / stock_daily / 2024-11-05
file: by_date/stock_daily/2024/2024-11-05.parquet size: 245 KB rows: 7,110 symbols: 670
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-05 | AAPL | Stock | 221.795 | 223.95 | 221.14 | 223.45 | 27174016.0 |
| 2024-11-05 | MSFT | Stock | 408.37 | 414.9 | 408.08 | 411.46 | 16977425.0 |
| 2024-11-05 | NVDA | Stock | 137.45 | 140.3701 | 137.33 | 139.91 | 156882082.0 |
| 2024-11-05 | AMZN | Stock | 196.04 | 199.82 | 195.99 | 199.5 | 29688718.0 |
| 2024-11-05 | GOOGL | Stock | 169.43 | 170.53 | 168.84 | 169.74 | 18242050.0 |
| 2024-11-05 | META | Stock | 567.305 | 573.48 | 566.67 | 572.43 | 9475268.0 |
| 2024-11-05 | TSLA | Stock | 247.34 | 255.2799 | 246.2101 | 251.44 | 66237201.0 |
| 2024-11-05 | TLT | Stock | 92.03 | 92.9 | 91.6 | 92.74 | 46986037.0 |
| 2024-11-05 | ES | Stock | 63.01 | 63.33 | 61.04 | 62.07 | 4760865.0 |
| 2024-11-05 | CL | Stock | 93.4 | 94.37 | 93.11 | 94.26 | 3218030.0 |
| 2024-11-05 | A | Stock | 138.18 | 140.79 | 137.241 | 140.41 | 1218180.0 |
| 2024-11-05 | AA | Stock | 41.28 | 42.875 | 41.11 | 42.78 | 4648603.0 |
| 2024-11-05 | AACG | Stock | 1.04 | 1.04 | 1.0 | 1.03 | 34610.0 |
| 2024-11-05 | AACT | Stock | 10.87 | 10.88 | 10.87 | 10.87 | 37906.0 |
| 2024-11-05 | AAL | Stock | 12.95 | 13.22 | 12.92 | 13.19 | 19034839.0 |
| 2024-11-05 | AAM | Stock | 10.05 | 10.055 | 10.04 | 10.05 | 240329.0 |
| 2024-11-05 | AAME | Stock | 1.61 | 1.6801 | 1.6049 | 1.62 | 1813.0 |
| 2024-11-05 | AAMI | Stock | 27.43 | 28.24 | 27.39 | 28.04 | 190051.0 |
| 2024-11-05 | AAOI | Stock | 16.8 | 17.35 | 16.45 | 16.54 | 2076290.0 |
| 2024-11-05 | AAON | Stock | 112.57 | 114.97 | 112.2 | 113.02 | 577533.0 |
| 2024-11-05 | AAP | Stock | 37.25 | 38.41 | 37.25 | 38.16 | 1726124.0 |
| 2024-11-05 | AAT | Stock | 27.01 | 27.425 | 27.01 | 27.32 | 153100.0 |
| 2024-11-05 | AATC | Stock | 7.52 | 7.7 | 7.52 | 7.685 | 4840.0 |
| 2024-11-05 | AAUAF-DELISTED | Stock | 0.0502 | 0.0526 | 0.0502 | 0.0519 | 3884.0 |
| 2024-11-05 | AAXJ | Stock | 77.62 | 77.87 | 77.47 | 77.79 | 694172.0 |
| 2024-11-05 | AB | Stock | 36.0 | 36.57 | 36.0 | 36.49 | 174328.0 |
| 2024-11-05 | ABAT | Stock | 1.0 | 1.01 | 0.99 | 1.01 | 254601.0 |
| 2024-11-05 | ABBV | Stock | 200.49 | 202.42 | 198.35 | 201.68 | 4398826.0 |
| 2024-11-05 | ABCB | Stock | 61.52 | 62.67 | 61.325 | 62.57 | 312805.0 |
| 2024-11-05 | ABCL | Stock | 2.5 | 2.79 | 2.5 | 2.72 | 3817359.0 |
| 2024-11-05 | ABEO | Stock | 6.04 | 6.255 | 5.97 | 6.21 | 190345.0 |
| 2024-11-05 | ABEV | Stock | 2.21 | 2.22 | 2.18 | 2.22 | 14616576.0 |
| 2024-11-05 | ABG | Stock | 235.15 | 242.87 | 235.15 | 242.04 | 163670.0 |
| 2024-11-05 | ABLLW | Stock | 1.34 | 1.4 | 1.32 | 1.38 | 16671.0 |
| 2024-11-05 | ABLV | Stock | 0.8393 | 0.91 | 0.8393 | 0.91 | 3495.0 |
| 2024-11-05 | ABM | Stock | 53.92 | 54.62 | 53.6 | 54.5 | 359872.0 |
| 2024-11-05 | ABNB | Stock | 137.55 | 140.87 | 137.07 | 137.82 | 4648965.0 |
| 2024-11-05 | ABOS | Stock | 2.96 | 3.02 | 2.95 | 3.0 | 104991.0 |
| 2024-11-05 | ABR | Stock | 14.71 | 15.0 | 14.67 | 14.94 | 1849201.0 |
| 2024-11-05 | ABR.D | Stock | 19.03 | 19.4 | 19.03 | 19.33 | 14670.0 |
| 2024-11-05 | ABR.E | Stock | 19.5 | 19.55 | 19.5 | 19.55 | 17178.0 |
| 2024-11-05 | ABR.F | Stock | 20.55 | 20.9494 | 20.55 | 20.87 | 20367.0 |
| 2024-11-05 | ABSI | Stock | 4.0 | 4.06 | 3.855 | 4.05 | 696793.0 |
| 2024-11-05 | ABT | Stock | 117.59 | 118.25 | 116.33 | 117.73 | 3906980.0 |
| 2024-11-05 | ABTC | Stock | 39.75 | 43.965 | 39.0 | 42.3375 | 5918.733333333334 |
| 2024-11-05 | ABTS | Stock | 8.85 | 8.85 | 7.5 | 8.655 | 1835.0 |
| 2024-11-05 | ABUS | Stock | 3.86 | 3.96 | 3.8 | 3.96 | 644583.0 |
| 2024-11-05 | ABVC | Stock | 0.63 | 0.636 | 0.55 | 0.5701 | 271681.0 |
| 2024-11-05 | ABVE | Stock | 0.3828 | 0.42 | 0.36 | 0.406 | 87991.0 |
| 2024-11-05 | ABVEW | Stock | 0.0249 | 0.0249 | 0.0169 | 0.0188 | 26053.0 |
> showing 50 of 7,110 rows — these rows as CSV