PREVIEW / stock_daily / 2024-03-12
file: by_date/stock_daily/2024/2024-03-12.parquet size: 234 KB rows: 7,266 symbols: 1,092
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-12 | AAPL | Stock | 173.15 | 174.03 | 171.01 | 173.23 | 59825400.0 |
| 2024-03-12 | MSFT | Stock | 407.62 | 415.57 | 406.79 | 415.28 | 22457000.0 |
| 2024-03-12 | NVDA | Stock | 88.049 | 91.96 | 86.15 | 91.913 | 668075000.0 |
| 2024-03-12 | AMZN | Stock | 173.5 | 176.76 | 171.98 | 175.39 | 36610600.0 |
| 2024-03-12 | GOOGL | Stock | 137.03 | 139.375 | 137.03 | 138.5 | 27563354.0 |
| 2024-03-12 | META | Stock | 493.26 | 502.31 | 484.73 | 499.75 | 15448200.0 |
| 2024-03-12 | TSLA | Stock | 177.77 | 179.43 | 172.41 | 177.54 | 87391700.0 |
| 2024-03-12 | TLT | Stock | 95.04 | 95.21 | 94.69 | 94.88 | 29566000.0 |
| 2024-03-12 | ES | Stock | 60.41 | 60.68 | 59.26 | 59.81 | 2028700.0 |
| 2024-03-12 | CL | Stock | 88.15 | 89.19 | 88.01 | 88.76 | 4251800.0 |
| 2024-03-12 | A | Stock | 147.61 | 149.48 | 147.24 | 147.84 | 1192300.0 |
| 2024-03-12 | AA | Stock | 30.6 | 30.75 | 29.21 | 29.79 | 6140100.0 |
| 2024-03-12 | AACG | Stock | 1.63 | 1.63 | 1.53 | 1.59 | 15800.0 |
| 2024-03-12 | AACIW-DELISTED | Stock | 0.0278 | 0.0278 | 0.0251 | 0.0251 | 12864.0 |
| 2024-03-12 | AACT | Stock | 10.54 | 10.56 | 10.54 | 10.55 | 968900.0 |
| 2024-03-12 | AAGR-DELISTED | Stock | 0.337 | 0.51 | 0.3219 | 0.4077 | 2688343.0 |
| 2024-03-12 | AAGRW-DELISTED | Stock | 0.0108 | 0.016 | 0.0106 | 0.0151 | 60693.0 |
| 2024-03-12 | AAL | Stock | 14.19 | 14.38 | 13.8 | 13.96 | 48594900.0 |
| 2024-03-12 | AAMC-DELISTED | Stock | 3.61 | 3.74 | 3.45 | 3.45 | 2800.0 |
| 2024-03-12 | AAME | Stock | 2.88 | 2.88 | 2.72 | 2.76 | 2100.0 |
| 2024-03-12 | AAMI | Stock | 22.85 | 23.0 | 22.7 | 22.74 | 131400.0 |
| 2024-03-12 | AAN-DELISTED | Stock | 7.05 | 7.09 | 6.9 | 6.98 | 349100.0 |
| 2024-03-12 | AAOI | Stock | 14.41 | 14.65 | 14.17 | 14.26 | 1275900.0 |
| 2024-03-12 | AAON | Stock | 79.71 | 80.54 | 79.32 | 79.99 | 339000.0 |
| 2024-03-12 | AAP | Stock | 77.5 | 80.25 | 77.0 | 78.48 | 4521700.0 |
| 2024-03-12 | AAT | Stock | 21.13 | 21.34 | 21.02 | 21.3 | 266200.0 |
| 2024-03-12 | AATC | Stock | 7.52 | 7.87 | 7.48 | 7.55 | 7585.0 |
| 2024-03-12 | AAU-DELISTED | Stock | 0.1376 | 0.139 | 0.137 | 0.1371 | 286890.0 |
| 2024-03-12 | AAUAF-DELISTED | Stock | 0.1376 | 0.139 | 0.137 | 0.137 | 285666.0 |
| 2024-03-12 | AAXJ | Stock | 68.44 | 68.735 | 68.21 | 68.66 | 1757535.0 |
| 2024-03-12 | AB | Stock | 33.8 | 34.15 | 33.68 | 33.92 | 431400.0 |
| 2024-03-12 | ABAT | Stock | 2.05 | 2.0603 | 1.86 | 1.96 | 996855.0 |
| 2024-03-12 | ABBV | Stock | 179.72 | 182.89 | 179.69 | 180.92 | 5391100.0 |
| 2024-03-12 | ABCB | Stock | 47.11 | 47.15 | 46.18 | 46.48 | 285200.0 |
| 2024-03-12 | ABCL | Stock | 4.97 | 4.98 | 4.8 | 4.88 | 1561100.0 |
| 2024-03-12 | ABEO | Stock | 7.72 | 8.48 | 7.4 | 8.18 | 478900.0 |
| 2024-03-12 | ABEV | Stock | 2.56 | 2.57 | 2.53 | 2.56 | 14797900.0 |
| 2024-03-12 | ABG | Stock | 210.03 | 211.61 | 207.9 | 210.87 | 106100.0 |
| 2024-03-12 | ABLLW | Stock | 0.46795 | 0.66 | 0.46795 | 0.6 | 79408.0 |
| 2024-03-12 | ABLV | Stock | 3.01 | 3.05 | 3.0 | 3.02 | 5000.0 |
| 2024-03-12 | ABM | Stock | 41.8 | 42.13 | 41.65 | 41.79 | 558700.0 |
| 2024-03-12 | ABNB | Stock | 163.0 | 167.0 | 162.73 | 166.67 | 3945900.0 |
| 2024-03-12 | ABOS | Stock | 4.25 | 4.31 | 4.1 | 4.12 | 244400.0 |
| 2024-03-12 | ABR | Stock | 12.92 | 13.06 | 12.74 | 13.02 | 2762200.0 |
| 2024-03-12 | ABR.D | Stock | 18.18 | 18.49 | 18.14 | 18.255 | 17188.0 |
| 2024-03-12 | ABR.E | Stock | 18.5765 | 18.58 | 18.57 | 18.58 | 1623.0 |
| 2024-03-12 | ABR.F | Stock | 19.0995 | 19.16 | 19.0172 | 19.16 | 10917.0 |
| 2024-03-12 | ABSI | Stock | 4.73 | 5.03 | 4.64 | 4.94 | 1273700.0 |
| 2024-03-12 | ABT | Stock | 119.95 | 121.08 | 119.06 | 120.76 | 3079700.0 |
| 2024-03-12 | ABTC | Stock | 122.25 | 141.0 | 116.25 | 133.5 | 11950.666666666666 |
> showing 50 of 7,266 rows — these rows as CSV