PREVIEW / stock_daily / 2024-11-08
file: by_date/stock_daily/2024/2024-11-08.parquet size: 245 KB rows: 7,112 symbols: 647
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-08 | AAPL | Stock | 227.17 | 228.66 | 226.405 | 226.96 | 37600040.0 |
| 2024-11-08 | MSFT | Stock | 425.32 | 426.5 | 421.78 | 422.54 | 16255572.0 |
| 2024-11-08 | NVDA | Stock | 148.77 | 149.77 | 146.26 | 147.63 | 172836665.0 |
| 2024-11-08 | AMZN | Stock | 209.72 | 209.9633 | 207.44 | 208.18 | 36103758.0 |
| 2024-11-08 | GOOGL | Stock | 180.645 | 180.9 | 178.08 | 178.35 | 22006182.0 |
| 2024-11-08 | META | Stock | 591.54 | 593.1 | 584.52 | 589.34 | 9320458.0 |
| 2024-11-08 | TSLA | Stock | 299.14 | 328.71 | 297.66 | 321.22 | 203164087.0 |
| 2024-11-08 | TLT | Stock | 92.0 | 92.5955 | 91.84 | 92.49 | 56756175.0 |
| 2024-11-08 | ES | Stock | 61.0 | 61.61 | 60.91 | 61.4 | 2319327.0 |
| 2024-11-08 | CL | Stock | 91.14 | 92.89 | 91.05 | 92.57 | 4285208.0 |
| 2024-11-08 | A | Stock | 137.67 | 138.665 | 134.94 | 136.68 | 1878368.0 |
| 2024-11-08 | AA | Stock | 44.02 | 44.82 | 43.66 | 44.78 | 3837869.0 |
| 2024-11-08 | AACG | Stock | 1.01 | 1.06 | 0.9506 | 1.04 | 94817.0 |
| 2024-11-08 | AACT | Stock | 10.865 | 10.87 | 10.86 | 10.86077 | 241341.0 |
| 2024-11-08 | AAGR-DELISTED | Stock | 0.0002 | 0.0002 | 0.0002 | 0.0002 | 24118.0 |
| 2024-11-08 | AAGRW-DELISTED | Stock | 0.0 | 0.0 | 0.0 | 0.0 | 533.0 |
| 2024-11-08 | AAL | Stock | 13.69 | 14.03 | 13.67 | 13.81 | 20146897.0 |
| 2024-11-08 | AAM | Stock | 10.06 | 10.06 | 10.05 | 10.06 | 214429.0 |
| 2024-11-08 | AAME | Stock | 1.81 | 1.81 | 1.66 | 1.6924 | 5372.0 |
| 2024-11-08 | AAMI | Stock | 29.5 | 29.6683 | 29.22 | 29.25 | 214310.0 |
| 2024-11-08 | AAOI | Stock | 19.5 | 27.805 | 18.63 | 27.76 | 19392662.0 |
| 2024-11-08 | AAON | Stock | 124.97 | 139.63 | 123.0 | 138.24 | 691888.0 |
| 2024-11-08 | AAP | Stock | 38.57 | 38.735 | 37.31 | 37.9 | 2761160.0 |
| 2024-11-08 | AAT | Stock | 28.05 | 28.23 | 27.82 | 27.94 | 211746.0 |
| 2024-11-08 | AATC | Stock | 8.0 | 8.185 | 7.91 | 7.91 | 20261.0 |
| 2024-11-08 | AAUAF-DELISTED | Stock | 0.0508 | 0.055 | 0.0508 | 0.0523 | 34547.0 |
| 2024-11-08 | AAXJ | Stock | 77.24 | 77.31 | 76.2 | 76.52 | 598060.0 |
| 2024-11-08 | AB | Stock | 37.55 | 37.85 | 36.68 | 36.71 | 439792.0 |
| 2024-11-08 | ABAT | Stock | 1.0 | 1.0 | 0.98 | 0.9935 | 310376.0 |
| 2024-11-08 | ABBV | Stock | 201.155 | 201.8939 | 199.48 | 199.5 | 3989888.0 |
| 2024-11-08 | ABCB | Stock | 69.79 | 70.25 | 69.08 | 69.7 | 391008.0 |
| 2024-11-08 | ABCL | Stock | 2.71 | 2.745 | 2.62 | 2.7 | 2165384.0 |
| 2024-11-08 | ABEO | Stock | 6.43 | 6.45 | 6.25 | 6.4 | 193452.0 |
| 2024-11-08 | ABEV | Stock | 2.17 | 2.2 | 2.15 | 2.17 | 31300276.0 |
| 2024-11-08 | ABG | Stock | 261.2 | 263.33 | 258.33 | 260.45 | 148499.0 |
| 2024-11-08 | ABLLW | Stock | 1.4 | 1.5 | 1.3208 | 1.38 | 28127.0 |
| 2024-11-08 | ABLV | Stock | 0.87 | 0.94 | 0.8338 | 0.905 | 27319.0 |
| 2024-11-08 | ABM | Stock | 57.2 | 58.205 | 57.185 | 57.73 | 289278.0 |
| 2024-11-08 | ABNB | Stock | 134.67 | 137.71 | 132.76 | 134.61 | 19210172.0 |
| 2024-11-08 | ABOS | Stock | 3.19 | 3.29 | 3.15 | 3.27 | 157427.0 |
| 2024-11-08 | ABR | Stock | 15.19 | 15.64 | 15.1505 | 15.53 | 2996494.0 |
| 2024-11-08 | ABR.D | Stock | 19.4999 | 19.545 | 19.4 | 19.54 | 7563.0 |
| 2024-11-08 | ABR.E | Stock | 19.505 | 19.55 | 19.505 | 19.5201 | 20302.0 |
| 2024-11-08 | ABR.F | Stock | 20.75 | 20.95 | 20.63 | 20.63 | 13935.0 |
| 2024-11-08 | ABSI | Stock | 4.02 | 4.095 | 3.92 | 4.07 | 829450.0 |
| 2024-11-08 | ABT | Stock | 115.33 | 117.25 | 114.6922 | 116.59 | 5311064.0 |
| 2024-11-08 | ABTC | Stock | 49.5 | 49.5 | 42.075 | 47.355000000000004 | 12194.666666666666 |
| 2024-11-08 | ABTS | Stock | 8.403 | 9.0 | 8.4 | 8.85 | 1328.0 |
| 2024-11-08 | ABUS | Stock | 3.75 | 3.79 | 3.695 | 3.75 | 881129.0 |
| 2024-11-08 | ABVC | Stock | 0.542 | 0.58 | 0.52 | 0.5265 | 69046.0 |
> showing 50 of 7,112 rows — these rows as CSV