PREVIEW / stock_daily / 2022-06-24
file: by_date/stock_daily/2022/2022-06-24.parquet size: 255 KB rows: 7,866 symbols: 2,264
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 |
|---|---|---|---|---|---|---|---|
| 2022-06-24 | AAPL | Stock | 139.9 | 141.91 | 139.77 | 141.66 | 89116800.0 |
| 2022-06-24 | MSFT | Stock | 261.81 | 267.98 | 261.72 | 267.7 | 33923200.0 |
| 2022-06-24 | NVDA | Stock | 16.5 | 17.14 | 16.31 | 17.126 | 472153000.0 |
| 2022-06-24 | AMZN | Stock | 112.38 | 116.71 | 111.43 | 116.46 | 69867600.0 |
| 2022-06-24 | GOOGL | Stock | 112.995 | 118.079 | 112.9525 | 117.975 | 41163680.0 |
| 2022-06-24 | META | Stock | 161.73 | 170.25 | 161.3 | 170.16 | 68736000.0 |
| 2022-06-24 | TSLA | Stock | 237.47 | 246.0667 | 236.0867 | 245.7067 | 95770800.0 |
| 2022-06-24 | TLT | Stock | 113.46 | 114.17 | 112.5 | 112.56 | 18161250.0 |
| 2022-06-24 | ES | Stock | 82.36 | 83.62 | 81.86 | 83.35 | 1449500.0 |
| 2022-06-24 | CL | Stock | 79.38 | 80.52 | 79.17 | 80.38 | 5193400.0 |
| 2022-06-24 | A | Stock | 119.95 | 121.35 | 118.45 | 121.29 | 3780400.0 |
| 2022-06-24 | AA | Stock | 47.19 | 49.846 | 46.52 | 49.36 | 7387800.0 |
| 2022-06-24 | AAC-DELISTED | Stock | 9.81 | 9.825 | 9.81 | 9.825 | 2383.0 |
| 2022-06-24 | AACG | Stock | 1.04 | 1.11 | 1.04 | 1.08 | 4900.0 |
| 2022-06-24 | AACIW-DELISTED | Stock | 0.2 | 0.2 | 0.1602 | 0.2 | 29460.0 |
| 2022-06-24 | AAIC-DELISTED | Stock | 3.24 | 3.3219 | 3.24 | 3.26 | 57702.0 |
| 2022-06-24 | AAIC.C-DELISTED | Stock | 22.7499 | 22.7499 | 22.7499 | 22.7499 | 100.0 |
| 2022-06-24 | AAL | Stock | 12.97 | 13.96 | 12.89 | 13.9 | 41326600.0 |
| 2022-06-24 | AAM.A-DELISTED | Stock | 24.1275 | 24.16 | 24.0001 | 24.05 | 7155.0 |
| 2022-06-24 | AAM.B-DELISTED | Stock | 25.16 | 25.3052 | 24.77 | 25.01 | 5839.0 |
| 2022-06-24 | AAMC-DELISTED | Stock | 3.2588 | 3.2706 | 3.2235 | 3.2353 | 30348.0 |
| 2022-06-24 | AAME | Stock | 2.9 | 2.9 | 2.56 | 2.77 | 18500.0 |
| 2022-06-24 | AAMI | Stock | 19.11 | 19.6 | 19.04 | 19.28 | 1259800.0 |
| 2022-06-24 | AAN-DELISTED | Stock | 15.78 | 16.38 | 15.76 | 16.18 | 706100.0 |
| 2022-06-24 | AAOI | Stock | 1.97 | 2.005 | 1.83 | 1.86 | 478300.0 |
| 2022-06-24 | AAON | Stock | 35.2467 | 36.0667 | 35.0667 | 35.48 | 344250.0 |
| 2022-06-24 | AAP | Stock | 179.19 | 183.78 | 178.65 | 183.1 | 1014900.0 |
| 2022-06-24 | AAQC-DELISTED | Stock | 9.78 | 9.78 | 9.77 | 9.78 | 1540.0 |
| 2022-06-24 | AAT | Stock | 29.72 | 30.49 | 29.72 | 30.43 | 392400.0 |
| 2022-06-24 | AATC | Stock | 5.41 | 5.5 | 5.33 | 5.33 | 3723.0 |
| 2022-06-24 | AAU-DELISTED | Stock | 0.2333 | 0.25 | 0.2308 | 0.236 | 181667.0 |
| 2022-06-24 | AAUAF-DELISTED | Stock | 0.2333 | 0.25 | 0.2308 | 0.236 | 185170.0 |
| 2022-06-24 | AAWW-DELISTED | Stock | 63.86 | 65.76 | 63.15 | 63.92 | 370548.0 |
| 2022-06-24 | AAXJ | Stock | 69.2 | 70.1 | 69.18 | 70.1 | 1114481.0 |
| 2022-06-24 | AB | Stock | 42.33 | 43.44 | 42.33 | 43.15 | 262600.0 |
| 2022-06-24 | ABB-DELISTED | Stock | 26.68 | 26.925 | 26.59 | 26.78 | 2914320.0 |
| 2022-06-24 | ABBNY-DELISTED | Stock | 26.68 | 26.925 | 26.59 | 26.77 | 3293986.0 |
| 2022-06-24 | ABBV | Stock | 150.89 | 152.74 | 149.62 | 152.34 | 8527600.0 |
| 2022-06-24 | ABC-DELISTED | Stock | 145.57 | 149.01 | 143.2 | 148.5 | 2401167.0 |
| 2022-06-24 | ABCB | Stock | 40.47 | 41.48 | 40.42 | 41.23 | 812300.0 |
| 2022-06-24 | ABCL | Stock | 10.64 | 10.76 | 10.12 | 10.65 | 25520200.0 |
| 2022-06-24 | ABCM-DELISTED | Stock | 14.63 | 14.91 | 14.55 | 14.91 | 141119.0 |
| 2022-06-24 | ABEO | Stock | 4.75 | 5.0 | 4.25 | 4.25 | 68456.0 |
| 2022-06-24 | ABEV | Stock | 2.52 | 2.59 | 2.51 | 2.57 | 35700200.0 |
| 2022-06-24 | ABG | Stock | 167.13 | 180.05 | 167.13 | 177.3 | 705600.0 |
| 2022-06-24 | ABGI-DELISTED | Stock | 9.8 | 9.81 | 9.8 | 9.81 | 100173.0 |
| 2022-06-24 | ABM | Stock | 42.19 | 44.2 | 41.99 | 44.19 | 1047200.0 |
| 2022-06-24 | ABMD-DELISTED | Stock | 251.42 | 255.57 | 248.04 | 255.32 | 247864.0 |
| 2022-06-24 | ABNB | Stock | 97.52 | 104.18 | 96.33 | 103.51 | 28797400.0 |
| 2022-06-24 | ABOS | Stock | 3.71 | 3.92 | 3.44 | 3.75 | 3362100.0 |
> showing 50 of 7,866 rows — these rows as CSV