PREVIEW / stock_daily / 2022-08-03
file: by_date/stock_daily/2022/2022-08-03.parquet size: 255 KB rows: 7,963 symbols: 2,318
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-08-03 | AAPL | Stock | 160.84 | 166.59 | 160.75 | 166.13 | 82507500.0 |
| 2022-08-03 | MSFT | Stock | 276.76 | 283.5 | 276.61 | 282.47 | 23518900.0 |
| 2022-08-03 | NVDA | Stock | 18.184 | 18.968 | 18.137 | 18.893 | 418146000.0 |
| 2022-08-03 | AMZN | Stock | 136.21 | 140.49 | 136.05 | 139.52 | 71827800.0 |
| 2022-08-03 | GOOGL | Stock | 115.71 | 118.62 | 115.48 | 118.08 | 28499014.0 |
| 2022-08-03 | META | Stock | 162.69 | 169.54 | 161.57 | 168.8 | 31721900.0 |
| 2022-08-03 | TSLA | Stock | 305.0 | 309.55 | 301.15 | 307.3967 | 80091000.0 |
| 2022-08-03 | TLT | Stock | 117.17 | 119.49 | 116.3336 | 119.35 | 16731172.0 |
| 2022-08-03 | ES | Stock | 90.25 | 91.07 | 88.64 | 90.83 | 1433300.0 |
| 2022-08-03 | CL | Stock | 80.0 | 81.76 | 79.47 | 81.43 | 3587300.0 |
| 2022-08-03 | A | Stock | 133.45 | 135.26 | 133.02 | 134.56 | 2113200.0 |
| 2022-08-03 | AA | Stock | 48.67 | 48.854 | 47.515 | 48.49 | 4383100.0 |
| 2022-08-03 | AAC-DELISTED | Stock | 9.88 | 9.89 | 9.87 | 9.89 | 279089.0 |
| 2022-08-03 | AACG | Stock | 1.99 | 2.0 | 1.9 | 1.94 | 41200.0 |
| 2022-08-03 | AAIC-DELISTED | Stock | 3.2 | 3.2 | 3.04 | 3.09 | 137400.0 |
| 2022-08-03 | AAIC.C-DELISTED | Stock | 20.84 | 20.9599 | 20.75 | 20.85 | 7646.0 |
| 2022-08-03 | AAL | Stock | 14.2 | 14.7 | 14.15 | 14.63 | 28366500.0 |
| 2022-08-03 | AAM.A-DELISTED | Stock | 25.3232 | 25.45 | 25.25 | 25.45 | 14546.0 |
| 2022-08-03 | AAM.B-DELISTED | Stock | 26.8 | 26.8 | 26.25 | 26.6305 | 19727.0 |
| 2022-08-03 | AAMC-DELISTED | Stock | 4.8529 | 5.5147 | 4.8059 | 5.2941 | 89906.0 |
| 2022-08-03 | AAME | Stock | 2.97 | 2.99 | 2.81 | 2.93 | 3000.0 |
| 2022-08-03 | AAMI | Stock | 18.83 | 18.95 | 18.6 | 18.85 | 1811800.0 |
| 2022-08-03 | AAN-DELISTED | Stock | 13.06 | 13.3 | 12.9 | 13.16 | 385400.0 |
| 2022-08-03 | AAOI | Stock | 1.85 | 1.94 | 1.83 | 1.92 | 220900.0 |
| 2022-08-03 | AAON | Stock | 39.8667 | 41.28 | 39.5867 | 41.0533 | 167700.0 |
| 2022-08-03 | AAP | Stock | 196.36 | 197.26 | 192.83 | 195.27 | 495400.0 |
| 2022-08-03 | AAQC-DELISTED | Stock | 9.81 | 9.82 | 9.8 | 9.81 | 14177.0 |
| 2022-08-03 | AAT | Stock | 29.35 | 29.55 | 28.95 | 29.11 | 237100.0 |
| 2022-08-03 | AATC | Stock | 5.0 | 5.07 | 4.97 | 5.025 | 22036.0 |
| 2022-08-03 | AAU-DELISTED | Stock | 0.2389 | 0.2401 | 0.235 | 0.24 | 108301.0 |
| 2022-08-03 | AAUAF-DELISTED | Stock | 0.2389 | 0.2401 | 0.235 | 0.2401 | 114509.0 |
| 2022-08-03 | AAWW-DELISTED | Stock | 96.0 | 97.67 | 95.65 | 96.78 | 2616804.0 |
| 2022-08-03 | AAXJ | Stock | 67.2 | 67.78 | 66.96 | 67.66 | 1216494.0 |
| 2022-08-03 | AB | Stock | 44.56 | 45.69 | 44.21 | 45.27 | 378800.0 |
| 2022-08-03 | ABB-DELISTED | Stock | 29.65 | 29.805 | 29.46 | 29.75 | 1173428.0 |
| 2022-08-03 | ABBNY-DELISTED | Stock | 29.66 | 29.805 | 29.46 | 29.75 | 1316944.0 |
| 2022-08-03 | ABBV | Stock | 141.72 | 143.02 | 140.65 | 141.2 | 5474200.0 |
| 2022-08-03 | ABC-DELISTED | Stock | 143.04 | 144.63 | 137.09 | 139.0 | 1722118.0 |
| 2022-08-03 | ABCB | Stock | 46.51 | 47.47 | 46.09 | 47.26 | 258500.0 |
| 2022-08-03 | ABCL | Stock | 10.93 | 11.01 | 10.645 | 10.98 | 1084400.0 |
| 2022-08-03 | ABCM-DELISTED | Stock | 15.09 | 15.58 | 15.09 | 15.44 | 235223.0 |
| 2022-08-03 | ABEO | Stock | 3.95 | 4.2 | 3.95 | 4.01 | 429700.0 |
| 2022-08-03 | ABEV | Stock | 2.74 | 2.75 | 2.68 | 2.72 | 40360000.0 |
| 2022-08-03 | ABG | Stock | 175.37 | 181.21 | 174.3 | 178.5 | 170500.0 |
| 2022-08-03 | ABGI-DELISTED | Stock | 9.86 | 9.86 | 9.84 | 9.84 | 5400.0 |
| 2022-08-03 | ABM | Stock | 44.48 | 45.24 | 44.18 | 44.89 | 241200.0 |
| 2022-08-03 | ABMD-DELISTED | Stock | 294.88 | 303.37 | 294.105 | 301.38 | 166026.0 |
| 2022-08-03 | ABNB | Stock | 108.225 | 115.57 | 107.65 | 115.02 | 23354900.0 |
| 2022-08-03 | ABOS | Stock | 5.58 | 5.58 | 4.93 | 4.98 | 38000.0 |
| 2022-08-03 | ABR | Stock | 15.24 | 15.56 | 15.05 | 15.45 | 4770100.0 |
> showing 50 of 7,963 rows — these rows as CSV