PREVIEW / stock_daily / 2024-10-23
file: by_date/stock_daily/2024/2024-10-23.parquet size: 245 KB rows: 7,101 symbols: 682
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-23 | AAPL | Stock | 234.08 | 235.144 | 227.76 | 230.76 | 51364170.0 |
| 2024-10-23 | MSFT | Stock | 430.855 | 431.08 | 422.53 | 424.6 | 17868008.0 |
| 2024-10-23 | NVDA | Stock | 142.03 | 142.43 | 137.46 | 139.56 | 283751241.0 |
| 2024-10-23 | AMZN | Stock | 188.85 | 189.16 | 183.69 | 184.71 | 31325371.0 |
| 2024-10-23 | GOOGL | Stock | 164.76 | 165.82 | 161.925 | 162.78 | 18280518.0 |
| 2024-10-23 | META | Stock | 579.97 | 585.0 | 562.5 | 563.69 | 13953620.0 |
| 2024-10-23 | TSLA | Stock | 217.125 | 218.72 | 212.11 | 213.65 | 77338730.0 |
| 2024-10-23 | TLT | Stock | 91.84 | 92.37 | 91.6601 | 92.07 | 33354245.0 |
| 2024-10-23 | ES | Stock | 66.28 | 67.15 | 66.17 | 67.09 | 1287829.0 |
| 2024-10-23 | CL | Stock | 99.32 | 99.7701 | 98.775 | 98.98 | 3841910.0 |
| 2024-10-23 | A | Stock | 133.27 | 134.3 | 131.36 | 133.03 | 1619654.0 |
| 2024-10-23 | AA | Stock | 41.53 | 42.25 | 41.285 | 41.88 | 4160155.0 |
| 2024-10-23 | AACG | Stock | 1.01 | 1.01 | 0.97 | 1.005 | 48896.0 |
| 2024-10-23 | AACT | Stock | 10.88 | 10.88 | 10.86 | 10.875 | 9000.0 |
| 2024-10-23 | AAL | Stock | 12.85 | 13.04 | 12.66 | 12.83 | 30050419.0 |
| 2024-10-23 | AAM | Stock | 10.03 | 10.03 | 10.025 | 10.03 | 1417108.0 |
| 2024-10-23 | AAME | Stock | 1.72 | 1.72 | 1.617 | 1.68 | 2314.0 |
| 2024-10-23 | AAMI | Stock | 26.09 | 26.44 | 25.36 | 25.63 | 152492.0 |
| 2024-10-23 | AAOI | Stock | 17.47 | 18.45 | 16.93 | 17.01 | 2125600.0 |
| 2024-10-23 | AAON | Stock | 106.91 | 108.91 | 105.55 | 106.89 | 209029.0 |
| 2024-10-23 | AAP | Stock | 38.74 | 38.8499 | 37.05 | 37.85 | 2688875.0 |
| 2024-10-23 | AAT | Stock | 27.33 | 27.63 | 27.32 | 27.5 | 123619.0 |
| 2024-10-23 | AATC | Stock | 7.46 | 7.46 | 7.4 | 7.4 | 2176.0 |
| 2024-10-23 | AAUAF-DELISTED | Stock | 0.05265 | 0.0599 | 0.046 | 0.05 | 59834.0 |
| 2024-10-23 | AAXJ | Stock | 77.55 | 77.86 | 77.09 | 77.42 | 248528.0 |
| 2024-10-23 | AB | Stock | 37.95 | 38.1 | 37.3 | 37.65 | 293251.0 |
| 2024-10-23 | ABAT | Stock | 1.01 | 1.02 | 0.99 | 0.9977 | 176731.0 |
| 2024-10-23 | ABBV | Stock | 188.7 | 189.27 | 187.5 | 187.88 | 4134021.0 |
| 2024-10-23 | ABCB | Stock | 62.49 | 63.18 | 61.6 | 62.72 | 262265.0 |
| 2024-10-23 | ABCL | Stock | 2.81 | 2.8288 | 2.725 | 2.78 | 1112924.0 |
| 2024-10-23 | ABEO | Stock | 6.56 | 6.575 | 6.22 | 6.25 | 205215.0 |
| 2024-10-23 | ABEV | Stock | 2.26 | 2.27 | 2.23 | 2.25 | 13174954.0 |
| 2024-10-23 | ABG | Stock | 227.13 | 231.82 | 227.02 | 229.77 | 110923.0 |
| 2024-10-23 | ABLLW | Stock | 1.51 | 1.51 | 1.37 | 1.4001 | 42801.0 |
| 2024-10-23 | ABLV | Stock | 0.95 | 0.95 | 0.8929 | 0.93 | 9252.0 |
| 2024-10-23 | ABLVW | Stock | 0.0133 | 0.0133 | 0.0133 | 0.0133 | 1990.0 |
| 2024-10-23 | ABM | Stock | 53.21 | 53.43 | 52.91 | 53.35 | 294298.0 |
| 2024-10-23 | ABNB | Stock | 135.0 | 136.2 | 131.27 | 131.92 | 3392207.0 |
| 2024-10-23 | ABOS | Stock | 2.79 | 2.8499 | 2.6 | 2.69 | 121036.0 |
| 2024-10-23 | ABR | Stock | 15.19 | 15.33 | 15.07 | 15.28 | 1266509.0 |
| 2024-10-23 | ABR.D | Stock | 19.8 | 19.92 | 19.65 | 19.89 | 7195.0 |
| 2024-10-23 | ABR.E | Stock | 20.03 | 20.2 | 20.03 | 20.2 | 960.0 |
| 2024-10-23 | ABR.F | Stock | 20.2 | 20.37 | 19.95 | 20.29 | 17008.0 |
| 2024-10-23 | ABSI | Stock | 4.09 | 4.125 | 3.98 | 4.11 | 608108.0 |
| 2024-10-23 | ABT | Stock | 116.16 | 117.15 | 115.93 | 117.01 | 3583885.0 |
| 2024-10-23 | ABTC | Stock | 46.5 | 46.5 | 41.265 | 44.565000000000005 | 5907.333333333333 |
| 2024-10-23 | ABTS | Stock | 7.2945 | 7.3095 | 7.05 | 7.05 | 662.0 |
| 2024-10-23 | ABUS | Stock | 4.03 | 4.12 | 3.96 | 4.06 | 909734.0 |
| 2024-10-23 | ABVC | Stock | 0.56 | 0.57 | 0.5401 | 0.57 | 55531.0 |
| 2024-10-23 | ABVE | Stock | 0.5053 | 0.55 | 0.5025 | 0.528 | 51721.0 |
> showing 50 of 7,101 rows — these rows as CSV