PREVIEW / stock_daily / 2024-10-01
file: by_date/stock_daily/2024/2024-10-01.parquet size: 245 KB rows: 7,092 symbols: 711
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-01 | AAPL | Stock | 229.52 | 229.65 | 223.74 | 226.21 | 59731999.0 |
| 2024-10-01 | MSFT | Stock | 428.45 | 428.48 | 418.81 | 420.69 | 18182108.0 |
| 2024-10-01 | NVDA | Stock | 121.765 | 122.4351 | 115.79 | 117.0 | 296526454.0 |
| 2024-10-01 | AMZN | Stock | 184.9 | 186.19 | 183.4519 | 185.13 | 33884988.0 |
| 2024-10-01 | GOOGL | Stock | 167.685 | 169.16 | 164.58 | 166.99 | 28338123.0 |
| 2024-10-01 | META | Stock | 577.98 | 583.04 | 570.1 | 576.47 | 15140100.0 |
| 2024-10-01 | TSLA | Stock | 262.67 | 263.98 | 248.53 | 258.02 | 86845200.0 |
| 2024-10-01 | TLT | Stock | 98.8 | 99.33 | 98.385 | 98.49 | 45254237.0 |
| 2024-10-01 | ES | Stock | 67.63 | 68.1 | 66.71 | 67.73 | 3345398.0 |
| 2024-10-01 | CL | Stock | 103.77 | 103.82 | 102.06 | 102.33 | 3918617.0 |
| 2024-10-01 | A | Stock | 148.19 | 148.19 | 144.02 | 146.56 | 1353226.0 |
| 2024-10-01 | AA | Stock | 39.42 | 39.8399 | 38.772 | 39.18 | 4417865.0 |
| 2024-10-01 | AACG | Stock | 0.7866 | 0.85 | 0.7753 | 0.7853 | 105183.0 |
| 2024-10-01 | AACT | Stock | 11.0 | 11.0 | 10.82 | 10.83 | 11083.0 |
| 2024-10-01 | AAGR-DELISTED | Stock | 0.024 | 0.0251 | 0.0168 | 0.0176 | 620219.0 |
| 2024-10-01 | AAL | Stock | 11.27 | 11.33 | 10.82 | 10.9 | 42726009.0 |
| 2024-10-01 | AAM | Stock | 10.02 | 10.02 | 10.01 | 10.01 | 118336.0 |
| 2024-10-01 | AAME | Stock | 1.62 | 1.73 | 1.6115 | 1.6799 | 10681.0 |
| 2024-10-01 | AAMI | Stock | 25.05 | 25.205 | 24.025 | 24.26 | 204063.0 |
| 2024-10-01 | AAN-DELISTED | Stock | 9.97 | 9.98 | 9.91 | 9.92 | 1930796.0 |
| 2024-10-01 | AAOI | Stock | 14.03 | 14.3 | 13.15 | 13.32 | 1911495.0 |
| 2024-10-01 | AAON | Stock | 107.71 | 107.71 | 105.53 | 106.6 | 399752.0 |
| 2024-10-01 | AAP | Stock | 38.5 | 38.7343 | 37.52 | 37.78 | 3007788.0 |
| 2024-10-01 | AAT | Stock | 26.71 | 26.71 | 26.35 | 26.36 | 211066.0 |
| 2024-10-01 | AATC | Stock | 7.88 | 7.97 | 7.61 | 7.9 | 4355.0 |
| 2024-10-01 | AAUAF-DELISTED | Stock | 0.048 | 0.055 | 0.048 | 0.055 | 17005.0 |
| 2024-10-01 | AAXJ | Stock | 78.93 | 79.4 | 78.18 | 79.39 | 1047994.0 |
| 2024-10-01 | AB | Stock | 34.82 | 34.8499 | 34.39 | 34.6 | 160420.0 |
| 2024-10-01 | ABAT | Stock | 1.06 | 1.06 | 0.9083 | 0.9953 | 646611.0 |
| 2024-10-01 | ABBV | Stock | 197.65 | 198.97 | 196.42 | 196.96 | 3716965.0 |
| 2024-10-01 | ABCB | Stock | 61.75 | 61.75 | 59.84 | 60.0 | 342452.0 |
| 2024-10-01 | ABCL | Stock | 2.58 | 2.63 | 2.53 | 2.57 | 2287146.0 |
| 2024-10-01 | ABEO | Stock | 6.39 | 6.48 | 6.08 | 6.46 | 498448.0 |
| 2024-10-01 | ABEV | Stock | 2.48 | 2.53 | 2.47 | 2.5 | 50869919.0 |
| 2024-10-01 | ABG | Stock | 236.8 | 236.8 | 230.3 | 233.36 | 167700.0 |
| 2024-10-01 | ABLLW | Stock | 1.73 | 1.73 | 1.55 | 1.55 | 30226.0 |
| 2024-10-01 | ABLV | Stock | 0.934 | 0.9499 | 0.897 | 0.9121 | 9441.0 |
| 2024-10-01 | ABM | Stock | 52.64 | 52.73 | 51.59 | 51.65 | 314801.0 |
| 2024-10-01 | ABNB | Stock | 127.35 | 128.2 | 123.71 | 125.47 | 3849809.0 |
| 2024-10-01 | ABOS | Stock | 2.47 | 2.49 | 2.39 | 2.45 | 183537.0 |
| 2024-10-01 | ABR | Stock | 15.5 | 15.57 | 15.36 | 15.48 | 2559051.0 |
| 2024-10-01 | ABR.D | Stock | 19.54 | 19.575 | 19.2101 | 19.55 | 30395.0 |
| 2024-10-01 | ABR.E | Stock | 19.5 | 19.78 | 19.5 | 19.75 | 2288.0 |
| 2024-10-01 | ABR.F | Stock | 19.46 | 19.59 | 19.2552 | 19.48 | 35937.0 |
| 2024-10-01 | ABSI | Stock | 3.82 | 3.85 | 3.53 | 3.62 | 1022895.0 |
| 2024-10-01 | ABT | Stock | 114.21 | 114.22 | 112.8 | 113.56 | 2974547.0 |
| 2024-10-01 | ABTC | Stock | 48.0 | 50.519999999999996 | 45.7425 | 48.0075 | 2555.0666666666666 |
| 2024-10-01 | ABTS | Stock | 7.0065 | 7.05 | 6.75 | 6.9 | 1005.0 |
| 2024-10-01 | ABUS | Stock | 3.81 | 3.84 | 3.65 | 3.83 | 1202779.0 |
| 2024-10-01 | ABVC | Stock | 0.6899 | 0.6899 | 0.63 | 0.64 | 54742.0 |
> showing 50 of 7,092 rows — these rows as CSV