PREVIEW / stock_daily / 2024-10-18
file: by_date/stock_daily/2024/2024-10-18.parquet size: 243 KB rows: 7,068 symbols: 675
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-10-18 | AAPL | Stock | 236.18 | 236.18 | 234.01 | 235.0 | 44216759.0 |
| 2024-10-18 | MSFT | Stock | 417.14 | 419.65 | 416.2601 | 418.16 | 16500457.0 |
| 2024-10-18 | NVDA | Stock | 138.665 | 138.9 | 137.28 | 138.0 | 172700042.0 |
| 2024-10-18 | AMZN | Stock | 187.15 | 190.74 | 186.28 | 188.99 | 36937398.0 |
| 2024-10-18 | GOOGL | Stock | 163.19 | 164.71 | 163.08 | 163.42 | 19757661.0 |
| 2024-10-18 | META | Stock | 581.1 | 583.9675 | 575.25 | 576.47 | 7575252.0 |
| 2024-10-18 | TSLA | Stock | 220.71 | 222.28 | 219.23 | 220.7 | 49136708.0 |
| 2024-10-18 | TLT | Stock | 94.05 | 94.28 | 93.86 | 93.87 | 25258632.0 |
| 2024-10-18 | ES | Stock | 65.14 | 66.495 | 64.78 | 66.13 | 1551447.0 |
| 2024-10-18 | CL | Stock | 99.73 | 100.54 | 98.76 | 100.46 | 4425623.0 |
| 2024-10-18 | A | Stock | 138.53 | 139.52 | 137.2375 | 138.83 | 1145803.0 |
| 2024-10-18 | AA | Stock | 41.77 | 42.17 | 40.85 | 41.71 | 5299324.0 |
| 2024-10-18 | AACG | Stock | 1.0 | 1.01 | 0.98 | 1.005 | 37054.0 |
| 2024-10-18 | AACT | Stock | 10.85 | 10.86 | 10.84 | 10.84 | 20727.0 |
| 2024-10-18 | AAGR-DELISTED | Stock | 0.0005 | 0.0005 | 0.0005 | 0.0005 | 35247.0 |
| 2024-10-18 | AAGRW-DELISTED | Stock | 0.0 | 0.0 | 0.0 | 0.0 | 265.0 |
| 2024-10-18 | AAL | Stock | 12.86 | 13.24 | 12.76 | 13.09 | 38155904.0 |
| 2024-10-18 | AAM | Stock | 10.02 | 10.03 | 10.02 | 10.02 | 558210.0 |
| 2024-10-18 | AAME | Stock | 1.6598 | 1.68 | 1.6499 | 1.67 | 3371.0 |
| 2024-10-18 | AAMI | Stock | 26.83 | 27.325 | 26.78 | 27.1 | 236076.0 |
| 2024-10-18 | AAOI | Stock | 19.2 | 20.34 | 18.3401 | 18.57 | 2807153.0 |
| 2024-10-18 | AAON | Stock | 110.71 | 111.3564 | 109.2 | 109.34 | 540935.0 |
| 2024-10-18 | AAP | Stock | 39.81 | 40.46 | 39.57 | 39.82 | 1296452.0 |
| 2024-10-18 | AAT | Stock | 27.91 | 28.39 | 27.775 | 28.22 | 164765.0 |
| 2024-10-18 | AATC | Stock | 7.4 | 7.49 | 7.25 | 7.3 | 5755.0 |
| 2024-10-18 | AAUAF-DELISTED | Stock | 0.0422 | 0.055 | 0.0422 | 0.055 | 46214.0 |
| 2024-10-18 | AAXJ | Stock | 79.03 | 79.03 | 78.57 | 78.61 | 854205.0 |
| 2024-10-18 | AB | Stock | 38.5 | 38.96 | 38.5 | 38.69 | 270897.0 |
| 2024-10-18 | ABAT | Stock | 1.05 | 1.05 | 0.99 | 0.998 | 483122.0 |
| 2024-10-18 | ABBV | Stock | 188.97 | 189.69 | 188.164 | 188.86 | 5461003.0 |
| 2024-10-18 | ABCB | Stock | 66.43 | 66.43 | 64.74 | 64.85 | 451965.0 |
| 2024-10-18 | ABCL | Stock | 2.69 | 2.88933 | 2.69 | 2.87 | 3155128.0 |
| 2024-10-18 | ABEO | Stock | 6.7 | 6.73 | 6.63 | 6.67 | 82011.0 |
| 2024-10-18 | ABEV | Stock | 2.305 | 2.31 | 2.27 | 2.28 | 12491807.0 |
| 2024-10-18 | ABG | Stock | 236.68 | 236.68 | 233.8 | 234.65 | 80681.0 |
| 2024-10-18 | ABLLW | Stock | 1.63 | 1.63 | 1.63 | 1.63 | 14355.0 |
| 2024-10-18 | ABLV | Stock | 0.975 | 0.975 | 0.924 | 0.9271 | 6871.0 |
| 2024-10-18 | ABLVW | Stock | 0.0194 | 0.0194 | 0.0194 | 0.0194 | 1113.0 |
| 2024-10-18 | ABM | Stock | 54.41 | 55.035 | 54.41 | 55.01 | 587032.0 |
| 2024-10-18 | ABNB | Stock | 136.81 | 136.89 | 135.16 | 136.45 | 2357521.0 |
| 2024-10-18 | ABOS | Stock | 2.7 | 2.885 | 2.6702 | 2.86 | 287257.0 |
| 2024-10-18 | ABR | Stock | 15.28 | 15.46 | 15.1601 | 15.4 | 1640940.0 |
| 2024-10-18 | ABR.D | Stock | 19.72 | 19.9 | 19.7 | 19.8 | 12785.0 |
| 2024-10-18 | ABR.E | Stock | 20.23 | 20.23 | 19.935 | 20.23 | 4008.0 |
| 2024-10-18 | ABR.F | Stock | 19.8 | 20.3 | 19.65 | 20.03 | 34740.0 |
| 2024-10-18 | ABSI | Stock | 4.11 | 4.21 | 4.055 | 4.21 | 473869.0 |
| 2024-10-18 | ABT | Stock | 117.9 | 119.85 | 117.67 | 119.39 | 5711864.0 |
| 2024-10-18 | ABTC | Stock | 46.5 | 50.64 | 45.75 | 50.0025 | 5383.6 |
| 2024-10-18 | ABTS | Stock | 7.785 | 7.785 | 7.0725 | 7.332 | 603.0 |
| 2024-10-18 | ABUS | Stock | 4.12 | 4.19 | 4.105 | 4.15 | 867732.0 |
> showing 50 of 7,068 rows — these rows as CSV