PREVIEW / stock_daily / 2024-03-05
file: by_date/stock_daily/2024/2024-03-05.parquet size: 236 KB rows: 7,286 symbols: 1,106
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-05 | AAPL | Stock | 170.76 | 172.04 | 169.62 | 170.12 | 95132400.0 |
| 2024-03-05 | MSFT | Stock | 413.96 | 414.25 | 400.64 | 402.65 | 26919200.0 |
| 2024-03-05 | NVDA | Stock | 85.27 | 86.097 | 83.417 | 85.964 | 520639000.0 |
| 2024-03-05 | AMZN | Stock | 176.93 | 176.93 | 173.3 | 174.12 | 37228300.0 |
| 2024-03-05 | GOOGL | Stock | 131.88 | 133.24 | 130.665 | 132.67 | 40194757.0 |
| 2024-03-05 | META | Stock | 495.0 | 495.58 | 487.89 | 490.22 | 15325300.0 |
| 2024-03-05 | TSLA | Stock | 183.05 | 184.59 | 177.57 | 180.74 | 119660800.0 |
| 2024-03-05 | TLT | Stock | 95.23 | 95.68 | 94.965 | 95.43 | 37721853.0 |
| 2024-03-05 | ES | Stock | 59.1 | 59.73 | 58.11 | 58.14 | 2516500.0 |
| 2024-03-05 | CL | Stock | 87.2 | 87.27 | 86.21 | 86.73 | 3719400.0 |
| 2024-03-05 | A | Stock | 143.0 | 146.4 | 143.0 | 144.35 | 2622500.0 |
| 2024-03-05 | AA | Stock | 27.05 | 27.21 | 26.57 | 26.91 | 5704800.0 |
| 2024-03-05 | AACG | Stock | 1.43 | 1.49 | 1.42 | 1.46 | 15700.0 |
| 2024-03-05 | AACIW-DELISTED | Stock | 0.026 | 0.026 | 0.026 | 0.026 | 151.0 |
| 2024-03-05 | AACT | Stock | 10.55 | 10.55 | 10.535 | 10.54 | 39900.0 |
| 2024-03-05 | AAGR-DELISTED | Stock | 0.74 | 0.74 | 0.62 | 0.685 | 78451.0 |
| 2024-03-05 | AAGRW-DELISTED | Stock | 0.0176 | 0.0176 | 0.0103 | 0.011 | 2987.0 |
| 2024-03-05 | AAL | Stock | 14.75 | 14.77 | 14.29 | 14.67 | 43648000.0 |
| 2024-03-05 | AAMC-DELISTED | Stock | 4.0 | 4.0 | 4.0 | 4.0 | 900.0 |
| 2024-03-05 | AAME | Stock | 2.62 | 2.83 | 2.62 | 2.71 | 5400.0 |
| 2024-03-05 | AAMI | Stock | 22.56 | 22.755 | 22.48 | 22.64 | 412500.0 |
| 2024-03-05 | AAN-DELISTED | Stock | 7.16 | 7.57 | 7.13 | 7.24 | 323500.0 |
| 2024-03-05 | AAOI | Stock | 14.74 | 15.21 | 14.53 | 14.74 | 2330600.0 |
| 2024-03-05 | AAON | Stock | 81.97 | 82.16 | 79.86 | 80.92 | 791400.0 |
| 2024-03-05 | AAP | Stock | 69.54 | 72.72 | 69.52 | 72.66 | 2275100.0 |
| 2024-03-05 | AAT | Stock | 21.35 | 21.81 | 21.35 | 21.63 | 511200.0 |
| 2024-03-05 | AATC | Stock | 8.04 | 8.25 | 7.9 | 7.9 | 9012.0 |
| 2024-03-05 | AAU-DELISTED | Stock | 0.135 | 0.1374 | 0.1336 | 0.135 | 154608.0 |
| 2024-03-05 | AAUAF-DELISTED | Stock | 0.135 | 0.1374 | 0.1336 | 0.135 | 157701.0 |
| 2024-03-05 | AAXJ | Stock | 66.32 | 66.48 | 65.91 | 66.02 | 781719.0 |
| 2024-03-05 | AB | Stock | 32.99 | 33.67 | 32.89 | 33.61 | 292800.0 |
| 2024-03-05 | ABAT | Stock | 2.39 | 2.44 | 2.04 | 2.07 | 631672.0 |
| 2024-03-05 | ABBV | Stock | 177.79 | 179.59 | 177.79 | 179.16 | 5309800.0 |
| 2024-03-05 | ABCB | Stock | 45.2 | 47.91 | 45.04 | 47.39 | 555200.0 |
| 2024-03-05 | ABCL | Stock | 4.93 | 4.94 | 4.805 | 4.81 | 1928100.0 |
| 2024-03-05 | ABEO | Stock | 7.74 | 8.7 | 7.6 | 8.46 | 484600.0 |
| 2024-03-05 | ABEV | Stock | 2.55 | 2.57 | 2.53 | 2.55 | 15139000.0 |
| 2024-03-05 | ABG | Stock | 204.08 | 208.44 | 203.75 | 205.27 | 128900.0 |
| 2024-03-05 | ABLLW | Stock | 0.5722 | 0.695 | 0.566 | 0.5761 | 3300.0 |
| 2024-03-05 | ABLV | Stock | 2.92 | 3.06 | 2.86 | 3.01 | 8100.0 |
| 2024-03-05 | ABM | Stock | 40.92 | 41.21 | 40.5 | 40.75 | 613000.0 |
| 2024-03-05 | ABNB | Stock | 157.2 | 159.98 | 156.14 | 159.33 | 4714300.0 |
| 2024-03-05 | ABOS | Stock | 4.45 | 4.561 | 4.32 | 4.35 | 521200.0 |
| 2024-03-05 | ABR | Stock | 12.42 | 12.8 | 12.35 | 12.75 | 3242900.0 |
| 2024-03-05 | ABR.D | Stock | 18.02 | 18.2 | 17.95 | 18.2 | 15021.0 |
| 2024-03-05 | ABR.E | Stock | 18.3 | 18.4 | 18.3 | 18.4 | 3634.0 |
| 2024-03-05 | ABR.F | Stock | 18.8 | 18.8 | 18.43 | 18.6 | 62398.0 |
| 2024-03-05 | ABSI | Stock | 5.69 | 5.73 | 5.15 | 5.26 | 1822100.0 |
| 2024-03-05 | ABT | Stock | 120.44 | 120.6 | 118.08 | 118.48 | 3502300.0 |
| 2024-03-05 | ABTC | Stock | 150.75 | 159.375 | 143.25 | 146.25 | 2384.0 |
> showing 50 of 7,286 rows — these rows as CSV