PREVIEW / stock_daily / 2022-06-03
file: by_date/stock_daily/2022/2022-06-03.parquet size: 256 KB rows: 7,919 symbols: 2,355
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-03 | AAPL | Stock | 146.9 | 147.97 | 144.46 | 145.38 | 88570300.0 |
| 2022-06-03 | MSFT | Stock | 270.31 | 273.45 | 268.41 | 270.02 | 28059000.0 |
| 2022-06-03 | NVDA | Stock | 19.082 | 19.332 | 18.522 | 18.72 | 598779000.0 |
| 2022-06-03 | AMZN | Stock | 124.2 | 124.4 | 121.0465 | 122.35 | 97604000.0 |
| 2022-06-03 | GOOGL | Stock | 116.0625 | 116.3216 | 113.5185 | 114.541 | 26135460.0 |
| 2022-06-03 | META | Stock | 195.98 | 196.61 | 189.78 | 190.78 | 19465000.0 |
| 2022-06-03 | TSLA | Stock | 243.2267 | 247.7967 | 233.4167 | 234.5167 | 112393800.0 |
| 2022-06-03 | TLT | Stock | 115.09 | 116.06 | 114.87 | 116.03 | 15330410.0 |
| 2022-06-03 | ES | Stock | 92.13 | 92.83 | 91.83 | 92.3 | 691500.0 |
| 2022-06-03 | CL | Stock | 79.02 | 79.56 | 78.76 | 78.93 | 3150100.0 |
| 2022-06-03 | A | Stock | 127.62 | 128.72 | 126.42 | 128.49 | 1722800.0 |
| 2022-06-03 | AA | Stock | 62.55 | 63.05 | 61.06 | 61.83 | 3182800.0 |
| 2022-06-03 | AAC-DELISTED | Stock | 9.81 | 9.82 | 9.81 | 9.81 | 14052.0 |
| 2022-06-03 | AACG | Stock | 1.03 | 1.05 | 0.97 | 1.02 | 9200.0 |
| 2022-06-03 | AAIC-DELISTED | Stock | 3.54 | 3.63 | 3.53 | 3.57 | 44997.0 |
| 2022-06-03 | AAIC.C-DELISTED | Stock | 23.59 | 23.59 | 23.59 | 23.59 | 840.0 |
| 2022-06-03 | AAL | Stock | 17.0 | 17.05 | 16.09 | 16.22 | 46267600.0 |
| 2022-06-03 | AAM.A-DELISTED | Stock | 24.76 | 24.7855 | 24.56 | 24.72 | 5147.0 |
| 2022-06-03 | AAM.B-DELISTED | Stock | 25.47 | 25.591 | 25.47 | 25.54 | 6115.0 |
| 2022-06-03 | AAMC-DELISTED | Stock | 3.1618 | 3.1765 | 3.1176 | 3.1176 | 13685.0 |
| 2022-06-03 | AAME | Stock | 3.01 | 3.01 | 2.8 | 2.99 | 1200.0 |
| 2022-06-03 | AAMI | Stock | 20.52 | 20.835 | 20.31 | 20.77 | 228100.0 |
| 2022-06-03 | AAN-DELISTED | Stock | 18.44 | 18.49 | 17.985 | 18.47 | 177500.0 |
| 2022-06-03 | AAOI | Stock | 2.31 | 2.32 | 2.22 | 2.25 | 197300.0 |
| 2022-06-03 | AAON | Stock | 36.7667 | 37.0933 | 36.4133 | 36.96 | 232200.0 |
| 2022-06-03 | AAP | Stock | 189.77 | 191.33 | 188.97 | 190.73 | 462900.0 |
| 2022-06-03 | AAQC-DELISTED | Stock | 9.76 | 9.76 | 9.76 | 9.76 | 1272.0 |
| 2022-06-03 | AAT | Stock | 33.28 | 33.38 | 32.77 | 32.94 | 139600.0 |
| 2022-06-03 | AATC | Stock | 6.0 | 6.0 | 5.8219 | 5.8219 | 1729.0 |
| 2022-06-03 | AAU-DELISTED | Stock | 0.2521 | 0.2691 | 0.245 | 0.2529 | 266205.0 |
| 2022-06-03 | AAUAF-DELISTED | Stock | 0.2521 | 0.2691 | 0.2401 | 0.2401 | 270816.0 |
| 2022-06-03 | AAWW-DELISTED | Stock | 70.24 | 71.1 | 69.705 | 70.17 | 181547.0 |
| 2022-06-03 | AAXJ | Stock | 71.58 | 71.72 | 71.03 | 71.14 | 1073017.0 |
| 2022-06-03 | AB | Stock | 43.2 | 43.37 | 42.6 | 42.7 | 243800.0 |
| 2022-06-03 | ABB-DELISTED | Stock | 31.61 | 31.8 | 31.44 | 31.57 | 1585349.0 |
| 2022-06-03 | ABBNY-DELISTED | Stock | 31.61 | 31.8 | 31.44 | 31.57 | 1795894.0 |
| 2022-06-03 | ABBV | Stock | 146.75 | 148.21 | 146.75 | 147.17 | 4891800.0 |
| 2022-06-03 | ABC-DELISTED | Stock | 147.65 | 148.905 | 146.8 | 147.09 | 574026.0 |
| 2022-06-03 | ABCB | Stock | 45.78 | 46.08 | 45.24 | 45.68 | 219400.0 |
| 2022-06-03 | ABCL | Stock | 7.6 | 7.68 | 7.41 | 7.54 | 1744500.0 |
| 2022-06-03 | ABCM-DELISTED | Stock | 15.03 | 15.12 | 14.81 | 14.86 | 94009.0 |
| 2022-06-03 | ABEO | Stock | 4.0 | 4.0 | 4.0 | 4.0 | 28288.0 |
| 2022-06-03 | ABEV | Stock | 2.92 | 2.95 | 2.89 | 2.89 | 23934800.0 |
| 2022-06-03 | ABG | Stock | 179.75 | 183.12 | 172.0 | 182.72 | 182500.0 |
| 2022-06-03 | ABGI-DELISTED | Stock | 9.79 | 9.795 | 9.79 | 9.79 | 3500.0 |
| 2022-06-03 | ABM | Stock | 48.92 | 49.66 | 48.53 | 49.62 | 316200.0 |
| 2022-06-03 | ABMD-DELISTED | Stock | 266.14 | 266.14 | 260.09 | 262.26 | 65376.0 |
| 2022-06-03 | ABNB | Stock | 118.071 | 121.5 | 117.56 | 119.83 | 4584600.0 |
| 2022-06-03 | ABOS | Stock | 3.55 | 3.815 | 3.49 | 3.68 | 138100.0 |
| 2022-06-03 | ABR | Stock | 16.46 | 16.49 | 16.27 | 16.37 | 1685800.0 |
> showing 50 of 7,919 rows — these rows as CSV