PREVIEW / stock_daily / 2022-06-22
file: by_date/stock_daily/2022/2022-06-22.parquet size: 254 KB rows: 7,917 symbols: 2,336
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-22 | AAPL | Stock | 134.79 | 137.76 | 133.91 | 135.35 | 73409200.0 |
| 2022-06-22 | MSFT | Stock | 251.89 | 257.17 | 250.37 | 253.13 | 25939900.0 |
| 2022-06-22 | NVDA | Stock | 16.226 | 16.662 | 16.18 | 16.36 | 437135000.0 |
| 2022-06-22 | AMZN | Stock | 107.43 | 112.13 | 107.02 | 108.95 | 60040100.0 |
| 2022-06-22 | GOOGL | Stock | 110.5565 | 113.3465 | 110.3824 | 111.4875 | 30774140.0 |
| 2022-06-22 | META | Stock | 158.38 | 160.79 | 155.44 | 155.85 | 47267800.0 |
| 2022-06-22 | TSLA | Stock | 234.5033 | 246.8333 | 233.8267 | 236.0867 | 101107500.0 |
| 2022-06-22 | TLT | Stock | 112.69 | 113.31 | 112.38 | 113.21 | 23703814.0 |
| 2022-06-22 | ES | Stock | 79.19 | 81.08 | 79.19 | 80.58 | 1203100.0 |
| 2022-06-22 | CL | Stock | 76.53 | 78.15 | 76.36 | 77.91 | 4653700.0 |
| 2022-06-22 | A | Stock | 112.66 | 115.08 | 112.52 | 113.8 | 2585300.0 |
| 2022-06-22 | AA | Stock | 47.51 | 49.89 | 47.47 | 48.9 | 6422400.0 |
| 2022-06-22 | AAC-DELISTED | Stock | 9.81 | 9.825 | 9.81 | 9.825 | 50334.0 |
| 2022-06-22 | AACG | Stock | 1.05 | 1.06 | 1.05 | 1.05 | 5200.0 |
| 2022-06-22 | AACIW-DELISTED | Stock | 0.21 | 0.21 | 0.2 | 0.2 | 22890.0 |
| 2022-06-22 | AAIC-DELISTED | Stock | 3.02 | 3.05 | 2.96 | 3.04 | 53492.0 |
| 2022-06-22 | AAIC.C-DELISTED | Stock | 22.63 | 22.65 | 22.3001 | 22.43 | 2641.0 |
| 2022-06-22 | AAL | Stock | 12.82 | 13.43 | 12.76 | 13.1 | 34193500.0 |
| 2022-06-22 | AAM.A-DELISTED | Stock | 23.95 | 24.0 | 23.87 | 23.9 | 22941.0 |
| 2022-06-22 | AAM.B-DELISTED | Stock | 25.25 | 25.49 | 25.18 | 25.256 | 21379.0 |
| 2022-06-22 | AAMC-DELISTED | Stock | 3.2485 | 3.4136 | 3.2485 | 3.2529 | 6480.0 |
| 2022-06-22 | AAME | Stock | 3.2 | 3.2 | 2.92 | 3.04 | 2100.0 |
| 2022-06-22 | AAMI | Stock | 18.61 | 19.105 | 18.61 | 18.91 | 292300.0 |
| 2022-06-22 | AAN-DELISTED | Stock | 14.97 | 15.44 | 14.53 | 15.32 | 453800.0 |
| 2022-06-22 | AAOI | Stock | 1.9 | 2.06 | 1.9 | 1.98 | 163600.0 |
| 2022-06-22 | AAON | Stock | 32.9533 | 34.1467 | 32.6533 | 33.9533 | 298500.0 |
| 2022-06-22 | AAP | Stock | 170.75 | 175.61 | 170.12 | 174.66 | 887700.0 |
| 2022-06-22 | AAQC-DELISTED | Stock | 9.76 | 9.765 | 9.7575 | 9.765 | 5682.0 |
| 2022-06-22 | AAT | Stock | 28.79 | 29.76 | 28.79 | 29.24 | 200500.0 |
| 2022-06-22 | AATC | Stock | 5.37 | 5.5 | 5.37 | 5.4999 | 3231.0 |
| 2022-06-22 | AAU-DELISTED | Stock | 0.2303 | 0.25 | 0.2232 | 0.246 | 537128.0 |
| 2022-06-22 | AAUAF-DELISTED | Stock | 0.2303 | 0.25 | 0.2232 | 0.246 | 541446.0 |
| 2022-06-22 | AAWW-DELISTED | Stock | 62.35 | 63.1 | 61.9 | 62.45 | 199424.0 |
| 2022-06-22 | AAXJ | Stock | 67.93 | 68.4 | 67.69 | 67.94 | 788804.0 |
| 2022-06-22 | AB | Stock | 41.08 | 41.58 | 40.51 | 41.01 | 288100.0 |
| 2022-06-22 | ABB-DELISTED | Stock | 26.07 | 26.57 | 25.995 | 26.36 | 2371896.0 |
| 2022-06-22 | ABBNY-DELISTED | Stock | 26.07 | 26.57 | 25.995 | 26.37 | 2637807.0 |
| 2022-06-22 | ABBV | Stock | 143.72 | 150.1 | 143.61 | 147.56 | 7995700.0 |
| 2022-06-22 | ABC-DELISTED | Stock | 142.81 | 145.54 | 142.595 | 144.95 | 651043.0 |
| 2022-06-22 | ABCB | Stock | 41.74 | 41.74 | 40.24 | 40.99 | 263600.0 |
| 2022-06-22 | ABCL | Stock | 9.67 | 10.71 | 9.611 | 10.29 | 4343600.0 |
| 2022-06-22 | ABCM-DELISTED | Stock | 13.97 | 14.3169 | 13.93 | 14.16 | 104288.0 |
| 2022-06-22 | ABEO | Stock | 4.5 | 4.5 | 4.0 | 4.25 | 64544.0 |
| 2022-06-22 | ABEV | Stock | 2.49 | 2.56 | 2.49 | 2.53 | 22880600.0 |
| 2022-06-22 | ABG | Stock | 159.46 | 166.25 | 158.73 | 164.67 | 121000.0 |
| 2022-06-22 | ABGI-DELISTED | Stock | 9.79 | 9.8101 | 9.79 | 9.81 | 8230.0 |
| 2022-06-22 | ABM | Stock | 40.58 | 43.25 | 40.58 | 42.64 | 723600.0 |
| 2022-06-22 | ABMD-DELISTED | Stock | 230.17 | 237.22 | 227.02 | 236.15 | 247921.0 |
| 2022-06-22 | ABNB | Stock | 99.0 | 102.5 | 98.72 | 99.53 | 8986000.0 |
| 2022-06-22 | ABOS | Stock | 3.32 | 3.69 | 3.31 | 3.46 | 320100.0 |
> showing 50 of 7,917 rows — these rows as CSV