PREVIEW / stock_daily / 2024-10-25
file: by_date/stock_daily/2024/2024-10-25.parquet size: 245 KB rows: 7,113 symbols: 679
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-25 | AAPL | Stock | 229.74 | 233.22 | 229.57 | 231.41 | 37145272.0 |
| 2024-10-25 | MSFT | Stock | 426.76 | 432.52 | 426.565 | 428.15 | 16022115.0 |
| 2024-10-25 | NVDA | Stock | 140.93 | 144.13 | 140.8 | 141.54 | 200572412.0 |
| 2024-10-25 | AMZN | Stock | 187.85 | 190.45 | 187.53 | 187.83 | 27797766.0 |
| 2024-10-25 | GOOGL | Stock | 163.67 | 165.59 | 163.42 | 165.27 | 19828884.0 |
| 2024-10-25 | META | Stock | 573.935 | 581.29 | 571.72 | 573.25 | 11187970.0 |
| 2024-10-25 | TSLA | Stock | 256.01 | 269.49 | 255.32 | 269.19 | 160120107.0 |
| 2024-10-25 | TLT | Stock | 92.99 | 93.0375 | 92.02 | 92.14 | 28667060.0 |
| 2024-10-25 | ES | Stock | 66.92 | 67.14 | 65.775 | 65.84 | 1339050.0 |
| 2024-10-25 | CL | Stock | 96.54 | 97.79 | 95.15 | 95.61 | 7874846.0 |
| 2024-10-25 | A | Stock | 131.18 | 131.71 | 129.35 | 130.19 | 1207737.0 |
| 2024-10-25 | AA | Stock | 42.19 | 42.25 | 41.09 | 41.1 | 3755002.0 |
| 2024-10-25 | AACG | Stock | 1.0 | 1.01 | 0.9925 | 1.01 | 34863.0 |
| 2024-10-25 | AACT | Stock | 10.8702 | 10.88 | 10.8702 | 10.88 | 2142.0 |
| 2024-10-25 | AAGR-DELISTED | Stock | 0.0002 | 0.0002 | 0.0001 | 0.0002 | 1545.0 |
| 2024-10-25 | AAL | Stock | 12.94 | 13.44 | 12.75 | 13.15 | 44227372.0 |
| 2024-10-25 | AAM | Stock | 10.04 | 10.04 | 10.03 | 10.04 | 52493.0 |
| 2024-10-25 | AAME | Stock | 1.6555 | 1.67 | 1.65 | 1.65 | 1340.0 |
| 2024-10-25 | AAMI | Stock | 26.24 | 26.495 | 25.81 | 25.82 | 101186.0 |
| 2024-10-25 | AAOI | Stock | 17.92 | 18.55 | 17.38 | 17.44 | 1657508.0 |
| 2024-10-25 | AAON | Stock | 108.78 | 111.34 | 108.6 | 111.19 | 478004.0 |
| 2024-10-25 | AAP | Stock | 37.46 | 37.56 | 36.6715 | 36.74 | 1889785.0 |
| 2024-10-25 | AAT | Stock | 27.97 | 27.97 | 27.39 | 27.5 | 118300.0 |
| 2024-10-25 | AATC | Stock | 7.43 | 7.465 | 7.41 | 7.465 | 1909.0 |
| 2024-10-25 | AAUAF-DELISTED | Stock | 0.056 | 0.06 | 0.05 | 0.053 | 46170.0 |
| 2024-10-25 | AAXJ | Stock | 77.61 | 77.74 | 77.085 | 77.2 | 263119.0 |
| 2024-10-25 | AB | Stock | 38.36 | 38.7099 | 38.065 | 38.38 | 433323.0 |
| 2024-10-25 | ABAT | Stock | 0.9947 | 1.02 | 0.9906 | 1.0 | 419620.0 |
| 2024-10-25 | ABBV | Stock | 189.68 | 189.88 | 187.17 | 187.85 | 3873178.0 |
| 2024-10-25 | ABCB | Stock | 62.5 | 63.22 | 60.835 | 61.25 | 575688.0 |
| 2024-10-25 | ABCL | Stock | 2.7 | 2.86 | 2.7 | 2.72 | 2297704.0 |
| 2024-10-25 | ABEO | Stock | 6.36 | 6.64 | 6.3 | 6.5 | 163063.0 |
| 2024-10-25 | ABEV | Stock | 2.26 | 2.28 | 2.25 | 2.25 | 14515527.0 |
| 2024-10-25 | ABG | Stock | 225.4 | 228.28 | 222.2 | 222.87 | 191272.0 |
| 2024-10-25 | ABLLW | Stock | 1.32 | 1.54 | 1.32 | 1.5 | 39745.0 |
| 2024-10-25 | ABLV | Stock | 0.9294 | 0.9294 | 0.89 | 0.91 | 14086.0 |
| 2024-10-25 | ABM | Stock | 53.47 | 53.778 | 52.73 | 52.75 | 325649.0 |
| 2024-10-25 | ABNB | Stock | 133.38 | 135.28 | 133.17 | 134.58 | 2467898.0 |
| 2024-10-25 | ABOS | Stock | 2.75 | 3.03 | 2.75 | 2.9 | 297977.0 |
| 2024-10-25 | ABR | Stock | 15.5 | 15.55 | 15.11 | 15.12 | 1228575.0 |
| 2024-10-25 | ABR.D | Stock | 19.89 | 19.9466 | 19.67 | 19.67 | 18693.0 |
| 2024-10-25 | ABR.E | Stock | 20.1 | 20.1 | 19.81 | 19.98 | 5245.0 |
| 2024-10-25 | ABR.F | Stock | 20.05 | 20.3699 | 20.04 | 20.3 | 15699.0 |
| 2024-10-25 | ABSI | Stock | 4.15 | 4.24 | 4.055 | 4.07 | 643140.0 |
| 2024-10-25 | ABT | Stock | 116.145 | 116.39 | 113.1964 | 114.22 | 5839280.0 |
| 2024-10-25 | ABTC | Stock | 44.25 | 47.220000000000006 | 43.92 | 45.888000000000005 | 8664.533333333333 |
| 2024-10-25 | ABTS | Stock | 5.85 | 7.6065 | 5.7 | 7.2 | 177134.0 |
| 2024-10-25 | ABUS | Stock | 4.05 | 4.09 | 3.95 | 3.97 | 498355.0 |
| 2024-10-25 | ABVC | Stock | 0.6315 | 0.7468 | 0.6243 | 0.69215 | 638759.0 |
| 2024-10-25 | ABVE | Stock | 0.521 | 0.6175 | 0.51 | 0.6 | 154564.0 |
> showing 50 of 7,113 rows — these rows as CSV