PREVIEW / stock_daily / 2024-07-31
file: by_date/stock_daily/2024/2024-07-31.parquet size: 246 KB rows: 7,230 symbols: 899
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-07-31 | AAPL | Stock | 221.44 | 223.82 | 220.63 | 222.08 | 47949966.0 |
| 2024-07-31 | MSFT | Stock | 420.495 | 421.775 | 412.21 | 418.35 | 41812241.0 |
| 2024-07-31 | NVDA | Stock | 112.9 | 118.34 | 110.88 | 117.02 | 464900671.0 |
| 2024-07-31 | AMZN | Stock | 185.05 | 187.94 | 184.46 | 186.98 | 40210357.0 |
| 2024-07-31 | GOOGL | Stock | 173.24 | 174.245 | 170.01 | 171.54 | 25729090.0 |
| 2024-07-31 | META | Stock | 471.02 | 476.5 | 466.75 | 474.83 | 23176363.0 |
| 2024-07-31 | TSLA | Stock | 227.9 | 234.68 | 226.7875 | 232.07 | 65987803.0 |
| 2024-07-31 | TLT | Stock | 94.53 | 94.84 | 94.24 | 94.81 | 47445288.0 |
| 2024-07-31 | ES | Stock | 65.61 | 65.8 | 64.77 | 64.91 | 4796721.0 |
| 2024-07-31 | CL | Stock | 100.49 | 100.76 | 98.45 | 99.19 | 6195887.0 |
| 2024-07-31 | A | Stock | 140.39 | 144.0 | 139.71 | 141.4 | 2535330.0 |
| 2024-07-31 | AA | Stock | 32.79 | 33.57 | 32.76 | 33.04 | 6617553.0 |
| 2024-07-31 | AACG | Stock | 0.6524 | 0.6881 | 0.6524 | 0.656 | 3127.0 |
| 2024-07-31 | AACT | Stock | 10.73 | 10.75 | 10.73 | 10.75 | 557465.0 |
| 2024-07-31 | AAGR-DELISTED | Stock | 0.1583 | 0.16 | 0.1511 | 0.1542 | 218525.0 |
| 2024-07-31 | AAL | Stock | 10.65 | 11.03 | 10.58 | 10.64 | 38810279.0 |
| 2024-07-31 | AAMC-DELISTED | Stock | 2.5 | 4.0 | 2.44 | 3.13 | 97391.0 |
| 2024-07-31 | AAME | Stock | 1.5199 | 1.5557 | 1.5195 | 1.54 | 4878.0 |
| 2024-07-31 | AAMI | Stock | 25.75 | 26.57 | 25.52 | 26.19 | 285767.0 |
| 2024-07-31 | AAN-DELISTED | Stock | 10.01 | 10.04 | 10.0 | 10.0 | 629803.0 |
| 2024-07-31 | AAOI | Stock | 8.2 | 9.73 | 8.16 | 9.55 | 3589929.0 |
| 2024-07-31 | AAON | Stock | 88.18 | 90.6263 | 87.54 | 88.53 | 511198.0 |
| 2024-07-31 | AAP | Stock | 63.14 | 64.575 | 62.81 | 63.33 | 1032138.0 |
| 2024-07-31 | AAT | Stock | 25.98 | 27.545 | 24.707 | 26.52 | 534870.0 |
| 2024-07-31 | AATC | Stock | 7.0 | 7.01 | 6.81 | 6.85 | 1935.0 |
| 2024-07-31 | AAUAF-DELISTED | Stock | 0.05 | 0.052 | 0.05 | 0.052 | 81663.0 |
| 2024-07-31 | AAXJ | Stock | 72.25 | 72.525 | 72.07 | 72.27 | 367412.0 |
| 2024-07-31 | AB | Stock | 35.0 | 35.5 | 34.9732 | 35.29 | 376723.0 |
| 2024-07-31 | ABAT | Stock | 1.01 | 1.07 | 1.01 | 1.07 | 420092.0 |
| 2024-07-31 | ABBV | Stock | 186.386 | 187.5 | 183.45 | 185.32 | 6249336.0 |
| 2024-07-31 | ABCB | Stock | 61.28 | 61.97 | 60.32 | 60.89 | 404097.0 |
| 2024-07-31 | ABCL | Stock | 3.37 | 3.435 | 3.18 | 3.26 | 2266996.0 |
| 2024-07-31 | ABEO | Stock | 4.7 | 5.0 | 4.56 | 4.9 | 355560.0 |
| 2024-07-31 | ABEV | Stock | 2.06 | 2.08 | 2.05 | 2.06 | 60818625.0 |
| 2024-07-31 | ABG | Stock | 256.55 | 277.13 | 255.65 | 269.22 | 401080.0 |
| 2024-07-31 | ABLLW | Stock | 1.0 | 1.03 | 0.99 | 1.01 | 22031.0 |
| 2024-07-31 | ABLV | Stock | 1.2199 | 1.27 | 1.12 | 1.12 | 15004.0 |
| 2024-07-31 | ABM | Stock | 55.62 | 56.3 | 54.8301 | 55.56 | 579471.0 |
| 2024-07-31 | ABNB | Stock | 140.79 | 141.2199 | 139.1 | 139.56 | 3223421.0 |
| 2024-07-31 | ABOS | Stock | 3.48 | 3.4908 | 3.2384 | 3.3 | 390317.0 |
| 2024-07-31 | ABR | Stock | 13.73 | 13.81 | 13.5 | 13.5 | 1925865.0 |
| 2024-07-31 | ABR.D | Stock | 17.21 | 17.85 | 17.2 | 17.82 | 87370.0 |
| 2024-07-31 | ABR.E | Stock | 17.34 | 18.58 | 17.25 | 18.28 | 85303.0 |
| 2024-07-31 | ABR.F | Stock | 18.75 | 19.38 | 18.62 | 19.02 | 161733.0 |
| 2024-07-31 | ABSI | Stock | 4.31 | 4.6 | 4.21 | 4.4 | 801988.0 |
| 2024-07-31 | ABT | Stock | 105.5 | 106.83 | 103.55 | 105.94 | 8007365.0 |
| 2024-07-31 | ABTC | Stock | 68.25 | 72.0 | 65.25 | 66.0 | 2435.2666666666664 |
| 2024-07-31 | ABTS | Stock | 8.25 | 8.85 | 8.25 | 8.43 | 647.0 |
| 2024-07-31 | ABUS | Stock | 3.83 | 3.885 | 3.73 | 3.77 | 916338.0 |
| 2024-07-31 | ABVC | Stock | 0.74 | 0.78 | 0.7389 | 0.7792 | 105737.0 |
> showing 50 of 7,230 rows — these rows as CSV