PREVIEW / stock_daily / 2024-11-27
file: by_date/stock_daily/2024/2024-11-27.parquet size: 246 KB rows: 7,144 symbols: 628
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-27 | AAPL | Stock | 234.465 | 235.69 | 233.8101 | 234.93 | 31583758.0 |
| 2024-11-27 | MSFT | Stock | 425.105 | 427.2299 | 422.02 | 422.99 | 17373319.0 |
| 2024-11-27 | NVDA | Stock | 135.01 | 137.22 | 131.8 | 135.34 | 221247126.0 |
| 2024-11-27 | AMZN | Stock | 206.98 | 207.64 | 205.05 | 205.74 | 26786721.0 |
| 2024-11-27 | GOOGL | Stock | 169.0 | 169.4832 | 168.02 | 169.23 | 19266511.0 |
| 2024-11-27 | META | Stock | 574.89 | 574.98 | 564.1001 | 569.2 | 6822518.0 |
| 2024-11-27 | TSLA | Stock | 341.8 | 342.55 | 326.59 | 332.89 | 56988128.0 |
| 2024-11-27 | TLT | Stock | 93.04 | 93.38 | 92.67 | 93.01 | 39442167.0 |
| 2024-11-27 | ES | Stock | 63.74 | 65.21 | 63.56 | 64.59 | 1256246.0 |
| 2024-11-27 | CL | Stock | 96.95 | 97.96 | 96.69 | 96.76 | 3311041.0 |
| 2024-11-27 | A | Stock | 134.69 | 139.0 | 134.235 | 138.14 | 2181742.0 |
| 2024-11-27 | AA | Stock | 47.24 | 47.62 | 45.42 | 45.88 | 4562251.0 |
| 2024-11-27 | AACG | Stock | 1.0 | 1.0051 | 0.9409 | 1.005 | 93574.0 |
| 2024-11-27 | AACT | Stock | 10.9 | 10.905 | 10.9 | 10.9 | 214309.0 |
| 2024-11-27 | AAGR-DELISTED | Stock | 0.0002 | 0.0002 | 0.0002 | 0.0002 | 10419.0 |
| 2024-11-27 | AAL | Stock | 14.68 | 14.75 | 14.46 | 14.64 | 14335969.0 |
| 2024-11-27 | AAM | Stock | 10.06 | 10.06 | 10.04 | 10.045 | 4034485.0 |
| 2024-11-27 | AAME | Stock | 1.59 | 1.6222 | 1.495 | 1.56 | 7699.0 |
| 2024-11-27 | AAMI | Stock | 31.35 | 31.515 | 30.94 | 31.21 | 121559.0 |
| 2024-11-27 | AAOI | Stock | 37.62 | 38.071 | 34.4317 | 36.42 | 2764765.0 |
| 2024-11-27 | AAON | Stock | 140.22 | 141.06 | 135.342 | 136.03 | 503836.0 |
| 2024-11-27 | AAP | Stock | 44.1 | 44.88 | 43.31 | 44.44 | 1999988.0 |
| 2024-11-27 | AAT | Stock | 28.83 | 29.15 | 28.6 | 28.61 | 173028.0 |
| 2024-11-27 | AATC | Stock | 7.99 | 8.19 | 7.99 | 8.13 | 4189.0 |
| 2024-11-27 | AAUAF-DELISTED | Stock | 0.0355 | 0.0429 | 0.0355 | 0.039 | 63958.0 |
| 2024-11-27 | AAXJ | Stock | 74.26 | 74.305 | 73.67 | 74.01 | 257572.0 |
| 2024-11-27 | AB | Stock | 35.99 | 36.7 | 35.94 | 36.67 | 279877.0 |
| 2024-11-27 | ABAT | Stock | 0.94 | 0.98 | 0.9 | 0.9545 | 250729.0 |
| 2024-11-27 | ABBV | Stock | 181.14 | 184.21 | 180.89 | 183.08 | 5106844.0 |
| 2024-11-27 | ABCB | Stock | 72.16 | 72.245 | 70.69 | 70.89 | 209585.0 |
| 2024-11-27 | ABCL | Stock | 2.88 | 3.0671 | 2.87 | 3.0 | 4281011.0 |
| 2024-11-27 | ABEO | Stock | 6.09 | 6.545 | 6.01 | 6.41 | 720062.0 |
| 2024-11-27 | ABEV | Stock | 2.19 | 2.2 | 2.13 | 2.15 | 33461944.0 |
| 2024-11-27 | ABG | Stock | 264.2 | 267.04 | 259.7 | 260.03 | 157913.0 |
| 2024-11-27 | ABLLW | Stock | 1.1104 | 1.27 | 1.1104 | 1.2 | 180828.0 |
| 2024-11-27 | ABLV | Stock | 0.88 | 0.928 | 0.848 | 0.9 | 20061.0 |
| 2024-11-27 | ABM | Stock | 57.1 | 57.595 | 56.95 | 56.99 | 228936.0 |
| 2024-11-27 | ABNB | Stock | 139.67 | 140.41 | 137.68 | 138.28 | 2599344.0 |
| 2024-11-27 | ABOS | Stock | 2.2 | 2.2921 | 2.18 | 2.26 | 302635.0 |
| 2024-11-27 | ABR | Stock | 14.89 | 15.05 | 14.7635 | 14.8 | 2188709.0 |
| 2024-11-27 | ABR.D | Stock | 19.23 | 19.7199 | 19.11 | 19.22 | 16686.0 |
| 2024-11-27 | ABR.E | Stock | 19.18 | 19.23 | 18.66 | 18.79 | 6707.0 |
| 2024-11-27 | ABR.F | Stock | 21.21 | 21.4 | 21.1 | 21.25 | 25469.0 |
| 2024-11-27 | ABSI | Stock | 2.81 | 3.02 | 2.8 | 2.94 | 871611.0 |
| 2024-11-27 | ABT | Stock | 118.35 | 120.53 | 118.1 | 118.95 | 3127951.0 |
| 2024-11-27 | ABTC | Stock | 46.800000000000004 | 49.2675 | 45.795 | 46.9425 | 9741.533333333333 |
| 2024-11-27 | ABTS | Stock | 9.45 | 9.45 | 8.7015 | 8.85 | 2447.0 |
| 2024-11-27 | ABUS | Stock | 3.45 | 3.5 | 3.385 | 3.47 | 470827.0 |
| 2024-11-27 | ABVC | Stock | 0.5033 | 0.5404 | 0.5033 | 0.5102 | 53020.0 |
| 2024-11-27 | ABVE | Stock | 0.545 | 1.03 | 0.5101 | 0.6935 | 5535621.0 |
> showing 50 of 7,144 rows — these rows as CSV