PREVIEW / stock_daily / 2024-03-06
file: by_date/stock_daily/2024/2024-03-06.parquet size: 236 KB rows: 7,309 symbols: 1,112
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-03-06 | AAPL | Stock | 171.06 | 171.24 | 168.68 | 169.12 | 68587700.0 |
| 2024-03-06 | MSFT | Stock | 402.97 | 405.16 | 398.39 | 402.09 | 22344100.0 |
| 2024-03-06 | NVDA | Stock | 88.022 | 89.724 | 87.03 | 88.7 | 582520000.0 |
| 2024-03-06 | AMZN | Stock | 175.54 | 176.46 | 173.26 | 173.51 | 32090900.0 |
| 2024-03-06 | GOOGL | Stock | 133.12 | 133.58 | 130.85 | 131.4 | 35318610.0 |
| 2024-03-06 | META | Stock | 497.63 | 502.97 | 494.29 | 496.09 | 11757900.0 |
| 2024-03-06 | TSLA | Stock | 179.99 | 181.58 | 173.7 | 176.54 | 107920900.0 |
| 2024-03-06 | TLT | Stock | 95.49 | 96.17 | 95.41 | 95.99 | 40571580.0 |
| 2024-03-06 | ES | Stock | 58.7 | 58.96 | 57.93 | 58.5 | 2078900.0 |
| 2024-03-06 | CL | Stock | 86.75 | 87.36 | 86.59 | 87.18 | 3522700.0 |
| 2024-03-06 | A | Stock | 145.0 | 147.44 | 144.75 | 146.22 | 2357900.0 |
| 2024-03-06 | AA | Stock | 27.67 | 28.725 | 26.9 | 28.22 | 6335600.0 |
| 2024-03-06 | AACG | Stock | 1.54 | 1.64 | 1.45 | 1.61 | 54800.0 |
| 2024-03-06 | AACT | Stock | 10.54 | 10.54 | 10.53 | 10.54 | 108000.0 |
| 2024-03-06 | AAGR-DELISTED | Stock | 0.7 | 0.7 | 0.6016 | 0.62 | 177317.0 |
| 2024-03-06 | AAGRW-DELISTED | Stock | 0.0105 | 0.0169 | 0.0105 | 0.0169 | 5940.0 |
| 2024-03-06 | AAL | Stock | 14.8 | 14.98 | 14.62 | 14.88 | 31408700.0 |
| 2024-03-06 | AAMC-DELISTED | Stock | 3.91 | 3.91 | 3.545 | 3.545 | 3300.0 |
| 2024-03-06 | AAME | Stock | 2.61 | 2.79 | 2.61 | 2.72 | 2100.0 |
| 2024-03-06 | AAMI | Stock | 22.88 | 22.98 | 22.43 | 22.78 | 227100.0 |
| 2024-03-06 | AAN-DELISTED | Stock | 7.25 | 7.357 | 7.035 | 7.16 | 416500.0 |
| 2024-03-06 | AAOI | Stock | 14.98 | 15.849 | 14.23 | 14.9 | 3216300.0 |
| 2024-03-06 | AAON | Stock | 82.41 | 82.41 | 80.62 | 81.0 | 516600.0 |
| 2024-03-06 | AAP | Stock | 73.25 | 73.36 | 70.3 | 71.9 | 1613900.0 |
| 2024-03-06 | AAT | Stock | 21.4 | 21.5 | 20.7 | 20.8 | 477400.0 |
| 2024-03-06 | AATC | Stock | 7.825 | 8.024 | 7.825 | 7.922 | 5944.0 |
| 2024-03-06 | AAU-DELISTED | Stock | 0.1372 | 0.1375 | 0.135 | 0.1371 | 271660.0 |
| 2024-03-06 | AAUAF-DELISTED | Stock | 0.1372 | 0.1375 | 0.135 | 0.1371 | 273748.0 |
| 2024-03-06 | AAXJ | Stock | 67.06 | 67.34 | 66.98 | 67.09 | 749803.0 |
| 2024-03-06 | AB | Stock | 33.6 | 33.88 | 33.22 | 33.84 | 307000.0 |
| 2024-03-06 | ABAT | Stock | 2.11 | 2.23 | 2.0535 | 2.09 | 395207.0 |
| 2024-03-06 | ABBV | Stock | 178.4 | 182.16 | 178.1 | 181.06 | 6047100.0 |
| 2024-03-06 | ABCB | Stock | 47.39 | 48.23 | 46.3 | 47.42 | 309800.0 |
| 2024-03-06 | ABCL | Stock | 4.86 | 4.96 | 4.845 | 4.87 | 1459000.0 |
| 2024-03-06 | ABEO | Stock | 8.57 | 9.01 | 8.12 | 8.68 | 408200.0 |
| 2024-03-06 | ABEV | Stock | 2.56 | 2.58 | 2.52 | 2.54 | 13487700.0 |
| 2024-03-06 | ABG | Stock | 206.88 | 209.09 | 204.6 | 206.42 | 232300.0 |
| 2024-03-06 | ABLLW | Stock | 0.5556 | 0.57 | 0.4403 | 0.452 | 186857.0 |
| 2024-03-06 | ABLV | Stock | 2.87 | 3.06 | 2.86 | 3.01 | 12000.0 |
| 2024-03-06 | ABM | Stock | 40.99 | 41.34 | 40.7 | 40.79 | 524300.0 |
| 2024-03-06 | ABNB | Stock | 160.1 | 164.59 | 160.07 | 163.87 | 5167900.0 |
| 2024-03-06 | ABOS | Stock | 4.39 | 4.51 | 4.28 | 4.45 | 341600.0 |
| 2024-03-06 | ABR | Stock | 12.97 | 13.03 | 12.67 | 12.8 | 3755100.0 |
| 2024-03-06 | ABR.D | Stock | 18.19 | 18.19 | 17.96 | 17.96 | 10511.0 |
| 2024-03-06 | ABR.E | Stock | 18.55 | 18.55 | 18.13 | 18.13 | 4337.0 |
| 2024-03-06 | ABR.F | Stock | 18.71 | 18.73 | 18.6 | 18.6 | 28590.0 |
| 2024-03-06 | ABSI | Stock | 5.7 | 5.85 | 5.3 | 5.36 | 1445400.0 |
| 2024-03-06 | ABT | Stock | 118.6 | 119.58 | 118.42 | 119.34 | 3388700.0 |
| 2024-03-06 | ABTC | Stock | 147.75 | 154.65 | 138.75 | 144.0 | 2178.6666666666665 |
| 2024-03-06 | ABTS | Stock | 15.0 | 15.0 | 13.05 | 13.23 | 7100.0 |
> showing 50 of 7,309 rows — these rows as CSV