PREVIEW / stock_daily / 2024-10-07
file: by_date/stock_daily/2024/2024-10-07.parquet size: 244 KB rows: 7,095 symbols: 700
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-07 | AAPL | Stock | 224.5 | 225.69 | 221.33 | 221.69 | 37493996.0 |
| 2024-10-07 | MSFT | Stock | 416.0 | 417.11 | 409.0 | 409.54 | 19253495.0 |
| 2024-10-07 | NVDA | Stock | 124.99 | 130.64 | 124.95 | 127.72 | 339746492.0 |
| 2024-10-07 | AMZN | Stock | 182.95 | 183.6 | 180.25 | 180.8 | 40641631.0 |
| 2024-10-07 | GOOGL | Stock | 167.72 | 168.48 | 162.75 | 162.98 | 22463140.0 |
| 2024-10-07 | META | Stock | 598.22 | 602.95 | 584.04 | 584.78 | 11756058.0 |
| 2024-10-07 | TSLA | Stock | 249.0 | 249.83 | 240.7 | 240.83 | 65205559.0 |
| 2024-10-07 | TLT | Stock | 94.98 | 95.2672 | 94.76 | 94.83 | 42606634.0 |
| 2024-10-07 | ES | Stock | 65.0 | 65.27 | 64.01 | 64.08 | 1335781.0 |
| 2024-10-07 | CL | Stock | 99.58 | 99.91 | 98.325 | 98.57 | 4753171.0 |
| 2024-10-07 | A | Stock | 144.13 | 144.4499 | 142.83 | 143.89 | 807422.0 |
| 2024-10-07 | AA | Stock | 38.68 | 39.798 | 38.68 | 39.47 | 3651258.0 |
| 2024-10-07 | AACG | Stock | 0.88 | 0.88 | 0.8051 | 0.8482 | 36129.0 |
| 2024-10-07 | AACT | Stock | 10.9 | 10.9 | 10.83 | 10.84 | 2618.0 |
| 2024-10-07 | AAGR-DELISTED | Stock | 0.0336 | 0.03925 | 0.0215 | 0.0252 | 96606.0 |
| 2024-10-07 | AAL | Stock | 11.55 | 11.6785 | 11.373 | 11.53 | 27514845.0 |
| 2024-10-07 | AAM | Stock | 10.04 | 10.04 | 10.015 | 10.02 | 19453.0 |
| 2024-10-07 | AAME | Stock | 1.66 | 1.66 | 1.6066 | 1.61 | 6430.0 |
| 2024-10-07 | AAMI | Stock | 23.58 | 23.58 | 23.095 | 23.33 | 132497.0 |
| 2024-10-07 | AAOI | Stock | 15.28 | 15.58 | 14.51 | 14.94 | 1875295.0 |
| 2024-10-07 | AAON | Stock | 107.11 | 108.1 | 106.75 | 107.83 | 312265.0 |
| 2024-10-07 | AAP | Stock | 38.88 | 39.92 | 38.49 | 39.09 | 2843608.0 |
| 2024-10-07 | AAT | Stock | 26.3 | 26.38 | 25.95 | 26.31 | 169083.0 |
| 2024-10-07 | AATC | Stock | 7.65 | 7.89 | 7.61 | 7.62 | 6011.0 |
| 2024-10-07 | AAUAF-DELISTED | Stock | 0.051 | 0.0539 | 0.04274 | 0.0501 | 72391.0 |
| 2024-10-07 | AAXJ | Stock | 81.55 | 82.25 | 81.22 | 82.16 | 905823.0 |
| 2024-10-07 | AB | Stock | 34.94 | 34.98 | 34.45 | 34.69 | 108732.0 |
| 2024-10-07 | ABAT | Stock | 1.04 | 1.11 | 1.0 | 1.06 | 772700.0 |
| 2024-10-07 | ABBV | Stock | 194.415 | 195.0918 | 192.835 | 193.61 | 3350485.0 |
| 2024-10-07 | ABCB | Stock | 61.13 | 61.54 | 60.31 | 60.9 | 400305.0 |
| 2024-10-07 | ABCL | Stock | 2.49 | 2.635 | 2.49 | 2.63 | 1664383.0 |
| 2024-10-07 | ABEO | Stock | 6.51 | 6.73 | 6.3901 | 6.54 | 428695.0 |
| 2024-10-07 | ABEV | Stock | 2.45 | 2.46 | 2.4 | 2.41 | 21599347.0 |
| 2024-10-07 | ABG | Stock | 230.07 | 230.68 | 225.95 | 229.01 | 104890.0 |
| 2024-10-07 | ABLLW | Stock | 1.42 | 1.63 | 1.34 | 1.63 | 497.0 |
| 2024-10-07 | ABLV | Stock | 0.9534 | 1.0 | 0.8736 | 0.925 | 34413.0 |
| 2024-10-07 | ABM | Stock | 51.02 | 52.31 | 50.84 | 52.29 | 326876.0 |
| 2024-10-07 | ABNB | Stock | 129.085 | 131.31 | 128.77 | 130.23 | 2799671.0 |
| 2024-10-07 | ABOS | Stock | 2.38 | 2.42 | 2.33 | 2.38 | 137470.0 |
| 2024-10-07 | ABR | Stock | 14.95 | 14.96 | 14.66 | 14.76 | 1995232.0 |
| 2024-10-07 | ABR.D | Stock | 19.7548 | 19.7652 | 19.5 | 19.56 | 31366.0 |
| 2024-10-07 | ABR.E | Stock | 19.8 | 20.2 | 19.7 | 20.2 | 4612.0 |
| 2024-10-07 | ABR.F | Stock | 19.46 | 19.6 | 19.3683 | 19.49 | 64464.0 |
| 2024-10-07 | ABSI | Stock | 3.9 | 3.949 | 3.79 | 3.92 | 452380.0 |
| 2024-10-07 | ABT | Stock | 112.3 | 113.61 | 111.8 | 113.36 | 5010849.0 |
| 2024-10-07 | ABTC | Stock | 43.5 | 45.0 | 42.09 | 43.1625 | 2206.0 |
| 2024-10-07 | ABTS | Stock | 7.335 | 7.335 | 6.852 | 6.954 | 742.0 |
| 2024-10-07 | ABUS | Stock | 3.83 | 3.84 | 3.7 | 3.73 | 659734.0 |
| 2024-10-07 | ABVC | Stock | 0.63 | 0.644 | 0.5505 | 0.5505 | 194161.0 |
| 2024-10-07 | ABVE | Stock | 0.577 | 0.58 | 0.54 | 0.54 | 19432.0 |
> showing 50 of 7,095 rows — these rows as CSV