PREVIEW / stock_daily / 2024-09-06
file: by_date/stock_daily/2024/2024-09-06.parquet size: 242 KB rows: 7,070 symbols: 735
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-09-06 | AAPL | Stock | 223.95 | 225.24 | 219.77 | 220.82 | 45958743.0 |
| 2024-09-06 | MSFT | Stock | 409.06 | 410.65 | 400.8 | 401.7 | 18603406.0 |
| 2024-09-06 | NVDA | Stock | 108.04 | 108.15 | 100.95 | 102.83 | 405554366.0 |
| 2024-09-06 | AMZN | Stock | 177.24 | 178.38 | 171.16 | 171.39 | 38584889.0 |
| 2024-09-06 | GOOGL | Stock | 157.3 | 157.83 | 150.55 | 150.92 | 37912130.0 |
| 2024-09-06 | META | Stock | 521.88 | 524.5849 | 498.25 | 500.27 | 14443912.0 |
| 2024-09-06 | TSLA | Stock | 232.6 | 233.6 | 210.51 | 210.73 | 111111598.0 |
| 2024-09-06 | TLT | Stock | 99.55 | 100.78 | 99.1901 | 99.56 | 57406404.0 |
| 2024-09-06 | ES | Stock | 68.21 | 68.41 | 67.33 | 67.4 | 1043806.0 |
| 2024-09-06 | CL | Stock | 108.57 | 109.04 | 107.78 | 107.86 | 3876422.0 |
| 2024-09-06 | A | Stock | 138.45 | 140.0 | 136.51 | 137.2 | 1269361.0 |
| 2024-09-06 | AA | Stock | 30.0 | 30.2274 | 28.345 | 28.53 | 6620802.0 |
| 2024-09-06 | AACG | Stock | 0.6 | 0.6 | 0.5425 | 0.5425 | 8170.0 |
| 2024-09-06 | AACT | Stock | 10.78 | 10.78 | 10.77 | 10.77 | 269.0 |
| 2024-09-06 | AAGR-DELISTED | Stock | 0.14 | 0.14 | 0.1314 | 0.137 | 30338.0 |
| 2024-09-06 | AAGRW-DELISTED | Stock | 0.0098 | 0.0098 | 0.0097 | 0.0098 | 1569.0 |
| 2024-09-06 | AAL | Stock | 10.78 | 11.1 | 10.7 | 10.8 | 27746489.0 |
| 2024-09-06 | AAMC-DELISTED | Stock | 1.71 | 1.83 | 1.53 | 1.5475 | 171107.0 |
| 2024-09-06 | AAME | Stock | 1.67 | 1.69 | 1.62 | 1.67 | 3679.0 |
| 2024-09-06 | AAMI | Stock | 23.78 | 23.82 | 23.08 | 23.17 | 172036.0 |
| 2024-09-06 | AAN-DELISTED | Stock | 10.02 | 10.035 | 9.98 | 10.01 | 1014848.0 |
| 2024-09-06 | AAOI | Stock | 12.17 | 12.24 | 11.48 | 11.81 | 1804326.0 |
| 2024-09-06 | AAON | Stock | 87.68 | 88.7621 | 87.24 | 87.4 | 376456.0 |
| 2024-09-06 | AAP | Stock | 40.37 | 41.19 | 39.53 | 39.76 | 3956881.0 |
| 2024-09-06 | AAT | Stock | 26.12 | 26.21 | 25.8 | 26.02 | 241806.0 |
| 2024-09-06 | AATC | Stock | 7.35 | 7.35 | 7.33 | 7.33 | 681.0 |
| 2024-09-06 | AAUAF-DELISTED | Stock | 0.0416 | 0.0416 | 0.0402 | 0.0402 | 41170.0 |
| 2024-09-06 | AAXJ | Stock | 71.57 | 71.58 | 70.18 | 70.22 | 248874.0 |
| 2024-09-06 | AB | Stock | 33.6 | 33.7898 | 33.01 | 33.08 | 163140.0 |
| 2024-09-06 | ABAT | Stock | 1.05 | 1.0795 | 1.03 | 1.04 | 144623.0 |
| 2024-09-06 | ABBV | Stock | 193.47 | 194.74 | 192.83 | 193.4 | 4193155.0 |
| 2024-09-06 | ABCB | Stock | 60.76 | 61.07 | 59.1 | 59.33 | 197805.0 |
| 2024-09-06 | ABCL | Stock | 2.44 | 2.465 | 2.36 | 2.39 | 1825050.0 |
| 2024-09-06 | ABEO | Stock | 5.64 | 5.75 | 5.335 | 5.55 | 193184.0 |
| 2024-09-06 | ABEV | Stock | 2.34 | 2.36 | 2.31 | 2.33 | 31487497.0 |
| 2024-09-06 | ABG | Stock | 229.91 | 232.235 | 221.5 | 221.89 | 175726.0 |
| 2024-09-06 | ABLLW | Stock | 1.31 | 1.48 | 1.31 | 1.4 | 16884.0 |
| 2024-09-06 | ABLV | Stock | 1.17 | 1.27 | 1.17 | 1.19 | 4226.0 |
| 2024-09-06 | ABLVW | Stock | 0.03 | 0.03 | 0.03 | 0.03 | 100.0 |
| 2024-09-06 | ABM | Stock | 59.78 | 59.78 | 51.28 | 51.29 | 1342825.0 |
| 2024-09-06 | ABNB | Stock | 116.37 | 117.26 | 113.24 | 114.28 | 4006235.0 |
| 2024-09-06 | ABOS | Stock | 2.26 | 2.2699 | 2.1511 | 2.22 | 323961.0 |
| 2024-09-06 | ABR | Stock | 13.14 | 13.41 | 13.11 | 13.4 | 2660279.0 |
| 2024-09-06 | ABR.D | Stock | 17.89 | 18.1683 | 17.78 | 17.93 | 27335.0 |
| 2024-09-06 | ABR.E | Stock | 18.05 | 18.21 | 17.73 | 17.73 | 7381.0 |
| 2024-09-06 | ABR.F | Stock | 18.68 | 18.7584 | 18.6 | 18.61 | 24292.0 |
| 2024-09-06 | ABSI | Stock | 4.13 | 4.21 | 3.89 | 4.02 | 687857.0 |
| 2024-09-06 | ABT | Stock | 113.63 | 114.34 | 113.01 | 113.86 | 3573341.0 |
| 2024-09-06 | ABTC | Stock | 45.9225 | 45.9225 | 31.5975 | 33.3675 | 16321.8 |
| 2024-09-06 | ABTS | Stock | 7.125 | 7.8 | 7.05 | 7.8 | 197.0 |
> showing 50 of 7,070 rows — these rows as CSV