PREVIEW / stock_daily / 2024-08-06
file: by_date/stock_daily/2024/2024-08-06.parquet size: 244 KB rows: 7,184 symbols: 868
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-08-06 | AAPL | Stock | 205.3 | 209.99 | 201.07 | 207.23 | 69545387.0 |
| 2024-08-06 | MSFT | Stock | 400.0 | 405.67 | 398.5 | 399.61 | 23608739.0 |
| 2024-08-06 | NVDA | Stock | 103.84 | 107.71 | 100.55 | 104.25 | 408119698.0 |
| 2024-08-06 | AMZN | Stock | 161.71 | 165.08 | 158.5404 | 161.93 | 56863712.0 |
| 2024-08-06 | GOOGL | Stock | 159.33 | 160.57 | 156.41 | 158.29 | 49004561.0 |
| 2024-08-06 | META | Stock | 479.0 | 502.56 | 478.65 | 494.09 | 20633958.0 |
| 2024-08-06 | TSLA | Stock | 200.75 | 202.9 | 192.67 | 200.64 | 73770212.0 |
| 2024-08-06 | TLT | Stock | 98.15 | 98.41 | 96.59 | 96.59 | 61316860.0 |
| 2024-08-06 | ES | Stock | 65.06 | 65.975 | 65.02 | 65.49 | 2055766.0 |
| 2024-08-06 | CL | Stock | 101.29 | 103.6 | 101.15 | 102.66 | 5111282.0 |
| 2024-08-06 | A | Stock | 135.42 | 138.92 | 134.27 | 136.26 | 1422451.0 |
| 2024-08-06 | AA | Stock | 28.5 | 29.64 | 28.2 | 29.39 | 11710576.0 |
| 2024-08-06 | AACG | Stock | 0.65 | 0.66 | 0.645 | 0.66 | 4896.0 |
| 2024-08-06 | AACIU | Stock | 11.26 | 13.5 | 11.26 | 13.1 | 6211.0 |
| 2024-08-06 | AACIW-DELISTED | Stock | 0.14 | 0.14 | 0.14 | 0.14 | 40969.0 |
| 2024-08-06 | AACT | Stock | 10.73 | 10.76 | 10.73 | 10.74 | 278316.0 |
| 2024-08-06 | AAGR-DELISTED | Stock | 0.1291 | 0.1347 | 0.1241 | 0.1347 | 351215.0 |
| 2024-08-06 | AAGRW-DELISTED | Stock | 0.0096 | 0.0101 | 0.0096 | 0.0097 | 2879.0 |
| 2024-08-06 | AAL | Stock | 9.46 | 9.53 | 9.22 | 9.31 | 28867083.0 |
| 2024-08-06 | AAMC-DELISTED | Stock | 3.06 | 3.5 | 2.93 | 2.97 | 13103.0 |
| 2024-08-06 | AAME | Stock | 1.4901 | 1.572 | 1.4901 | 1.5202 | 12854.0 |
| 2024-08-06 | AAMI | Stock | 22.22 | 22.4 | 21.83 | 22.04 | 314372.0 |
| 2024-08-06 | AAN-DELISTED | Stock | 9.96 | 10.09 | 9.95 | 10.04 | 746498.0 |
| 2024-08-06 | AAOI | Stock | 7.17 | 7.74 | 6.8 | 7.29 | 3421634.0 |
| 2024-08-06 | AAON | Stock | 86.0 | 87.802 | 85.105 | 86.27 | 492323.0 |
| 2024-08-06 | AAP | Stock | 58.36 | 59.53 | 57.48 | 58.22 | 972569.0 |
| 2024-08-06 | AAT | Stock | 24.49 | 25.8 | 24.47 | 25.51 | 299819.0 |
| 2024-08-06 | AATC | Stock | 6.81 | 7.19 | 6.62 | 7.19 | 7361.0 |
| 2024-08-06 | AAUAF-DELISTED | Stock | 0.05 | 0.052 | 0.05 | 0.0501 | 117865.0 |
| 2024-08-06 | AAXJ | Stock | 67.7 | 68.77 | 67.535 | 68.25 | 342685.0 |
| 2024-08-06 | AB | Stock | 31.81 | 32.9 | 31.81 | 32.74 | 286293.0 |
| 2024-08-06 | ABAT | Stock | 1.0 | 1.05 | 0.97 | 0.9975 | 386579.0 |
| 2024-08-06 | ABBV | Stock | 185.43 | 187.82 | 183.08 | 185.71 | 4166421.0 |
| 2024-08-06 | ABCB | Stock | 54.96 | 56.49 | 54.77 | 55.97 | 295459.0 |
| 2024-08-06 | ABCL | Stock | 2.85 | 2.885 | 2.73 | 2.85 | 1453215.0 |
| 2024-08-06 | ABEO | Stock | 4.51 | 4.78 | 4.5 | 4.68 | 232901.0 |
| 2024-08-06 | ABEV | Stock | 2.1 | 2.16 | 2.1 | 2.13 | 16175974.0 |
| 2024-08-06 | ABG | Stock | 230.4 | 235.83 | 226.01 | 232.7 | 136272.0 |
| 2024-08-06 | ABLLW | Stock | 0.96 | 0.99 | 0.907 | 0.975 | 83818.0 |
| 2024-08-06 | ABLV | Stock | 1.1 | 1.15 | 1.03 | 1.09 | 7018.0 |
| 2024-08-06 | ABLVW | Stock | 0.0399 | 0.0399 | 0.0399 | 0.0399 | 1160.0 |
| 2024-08-06 | ABM | Stock | 52.55 | 52.86 | 51.875 | 52.16 | 437027.0 |
| 2024-08-06 | ABNB | Stock | 126.905 | 131.45 | 126.3 | 130.47 | 11116659.0 |
| 2024-08-06 | ABOS | Stock | 2.86 | 2.95 | 2.75 | 2.87 | 197382.0 |
| 2024-08-06 | ABR | Stock | 13.4 | 13.69 | 13.18 | 13.58 | 2741436.0 |
| 2024-08-06 | ABR.D | Stock | 17.31 | 17.483 | 17.1029 | 17.39 | 45902.0 |
| 2024-08-06 | ABR.E | Stock | 17.6 | 17.7 | 17.54 | 17.54 | 5453.0 |
| 2024-08-06 | ABR.F | Stock | 18.26 | 18.84 | 18.26 | 18.74 | 12471.0 |
| 2024-08-06 | ABSI | Stock | 3.6 | 3.9 | 3.44 | 3.74 | 733895.0 |
| 2024-08-06 | ABT | Stock | 108.95 | 110.64 | 108.63 | 109.5 | 5503085.0 |
> showing 50 of 7,184 rows — these rows as CSV