PREVIEW / stock_daily / 2024-03-07
file: by_date/stock_daily/2024/2024-03-07.parquet size: 234 KB rows: 7,290 symbols: 1,101
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-07 | AAPL | Stock | 169.15 | 170.73 | 168.49 | 169.0 | 71765100.0 |
| 2024-03-07 | MSFT | Stock | 406.12 | 409.78 | 402.24 | 409.14 | 18718500.0 |
| 2024-03-07 | NVDA | Stock | 90.158 | 92.767 | 89.602 | 92.669 | 608119000.0 |
| 2024-03-07 | AMZN | Stock | 174.83 | 177.99 | 173.72 | 176.82 | 34063300.0 |
| 2024-03-07 | GOOGL | Stock | 132.795 | 134.94 | 131.61 | 134.38 | 37738209.0 |
| 2024-03-07 | META | Stock | 503.28 | 519.85 | 501.38 | 512.19 | 18586400.0 |
| 2024-03-07 | TSLA | Stock | 174.35 | 180.04 | 173.7 | 178.65 | 102129000.0 |
| 2024-03-07 | TLT | Stock | 96.36 | 96.4 | 95.48 | 95.9 | 39075047.0 |
| 2024-03-07 | ES | Stock | 58.98 | 59.7 | 58.7 | 59.42 | 2297900.0 |
| 2024-03-07 | CL | Stock | 87.41 | 88.16 | 87.03 | 88.14 | 3215800.0 |
| 2024-03-07 | A | Stock | 147.09 | 149.64 | 147.09 | 149.31 | 1942900.0 |
| 2024-03-07 | AA | Stock | 28.86 | 30.1 | 28.86 | 29.87 | 7740500.0 |
| 2024-03-07 | AACG | Stock | 1.56 | 1.57 | 1.42 | 1.51 | 38100.0 |
| 2024-03-07 | AACIW-DELISTED | Stock | 0.027 | 0.027 | 0.027 | 0.027 | 100.0 |
| 2024-03-07 | AACT | Stock | 10.54 | 10.54 | 10.53 | 10.54 | 33100.0 |
| 2024-03-07 | AAGR-DELISTED | Stock | 0.616 | 0.6309 | 0.515 | 0.55 | 278348.0 |
| 2024-03-07 | AAGRW-DELISTED | Stock | 0.0165 | 0.0165 | 0.011 | 0.0111 | 14230.0 |
| 2024-03-07 | AAL | Stock | 14.85 | 15.0 | 14.81 | 14.9 | 23657300.0 |
| 2024-03-07 | AAMC-DELISTED | Stock | 3.5 | 3.68 | 3.5 | 3.68 | 1300.0 |
| 2024-03-07 | AAME | Stock | 2.64 | 2.86 | 2.64 | 2.8 | 3200.0 |
| 2024-03-07 | AAMI | Stock | 22.98 | 23.05 | 22.555 | 22.72 | 289800.0 |
| 2024-03-07 | AAN-DELISTED | Stock | 7.23 | 7.35 | 7.18 | 7.18 | 240000.0 |
| 2024-03-07 | AAOI | Stock | 15.01 | 15.22 | 14.44 | 14.84 | 1989300.0 |
| 2024-03-07 | AAON | Stock | 81.18 | 81.65 | 80.8 | 81.12 | 318700.0 |
| 2024-03-07 | AAP | Stock | 72.04 | 73.99 | 72.04 | 73.68 | 1821900.0 |
| 2024-03-07 | AAT | Stock | 21.01 | 21.2 | 20.81 | 20.97 | 264400.0 |
| 2024-03-07 | AATC | Stock | 7.87 | 7.88 | 7.58 | 7.58 | 10653.0 |
| 2024-03-07 | AAU-DELISTED | Stock | 0.137 | 0.138 | 0.137 | 0.137 | 247345.0 |
| 2024-03-07 | AAUAF-DELISTED | Stock | 0.137 | 0.138 | 0.137 | 0.137 | 244988.0 |
| 2024-03-07 | AAXJ | Stock | 67.14 | 67.565 | 67.07 | 67.52 | 680424.0 |
| 2024-03-07 | AB | Stock | 33.41 | 34.11 | 32.91 | 34.0 | 433000.0 |
| 2024-03-07 | ABAT | Stock | 2.14 | 2.25 | 2.07 | 2.25 | 351145.0 |
| 2024-03-07 | ABBV | Stock | 182.19 | 182.42 | 179.54 | 180.57 | 6125200.0 |
| 2024-03-07 | ABCB | Stock | 48.14 | 48.43 | 47.37 | 47.57 | 338700.0 |
| 2024-03-07 | ABCL | Stock | 4.91 | 5.0 | 4.86 | 4.91 | 1117000.0 |
| 2024-03-07 | ABEO | Stock | 8.7 | 8.81 | 8.19 | 8.25 | 425700.0 |
| 2024-03-07 | ABEV | Stock | 2.55 | 2.55 | 2.51 | 2.55 | 7125200.0 |
| 2024-03-07 | ABG | Stock | 206.84 | 210.69 | 206.81 | 210.15 | 162300.0 |
| 2024-03-07 | ABLLW | Stock | 0.47 | 0.494 | 0.45 | 0.454 | 45329.0 |
| 2024-03-07 | ABLV | Stock | 2.92 | 3.06 | 2.92 | 3.05 | 6900.0 |
| 2024-03-07 | ABM | Stock | 43.99 | 43.99 | 41.04 | 43.35 | 1388800.0 |
| 2024-03-07 | ABNB | Stock | 165.0 | 165.385 | 162.24 | 163.54 | 3810300.0 |
| 2024-03-07 | ABOS | Stock | 4.5 | 4.57 | 4.37 | 4.37 | 216100.0 |
| 2024-03-07 | ABR | Stock | 12.85 | 12.99 | 12.71 | 12.91 | 2359000.0 |
| 2024-03-07 | ABR.D | Stock | 18.05 | 18.45 | 17.9772 | 18.05 | 14626.0 |
| 2024-03-07 | ABR.E | Stock | 18.3485 | 18.75 | 18.3485 | 18.4 | 7235.0 |
| 2024-03-07 | ABR.F | Stock | 18.66 | 18.92 | 18.6235 | 18.8 | 20289.0 |
| 2024-03-07 | ABSI | Stock | 5.38 | 5.51 | 5.03 | 5.13 | 1458500.0 |
| 2024-03-07 | ABT | Stock | 120.1 | 121.5 | 119.95 | 120.92 | 4200800.0 |
| 2024-03-07 | ABTC | Stock | 144.0 | 149.25 | 129.0 | 133.5 | 3624.0 |
> showing 50 of 7,290 rows — these rows as CSV