PREVIEW / stock_daily / 2022-01-24
file: by_date/stock_daily/2022/2022-01-24.parquet size: 266 KB rows: 8,206 symbols: 2,697
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-01-24 | AAPL | Stock | 160.02 | 162.3 | 154.7 | 161.62 | 162294600.0 |
| 2022-01-24 | MSFT | Stock | 292.2 | 297.11 | 276.05 | 296.37 | 85731500.0 |
| 2022-01-24 | NVDA | Stock | 22.33 | 23.38 | 20.888 | 23.372 | 913982000.0 |
| 2022-01-24 | AMZN | Stock | 139.0 | 144.945 | 135.352 | 144.544 | 155624000.0 |
| 2022-01-24 | GOOGL | Stock | 125.978 | 131.203 | 124.5 | 130.804 | 76694240.0 |
| 2022-01-24 | META | Stock | 297.84 | 309.53 | 289.01 | 308.71 | 38878100.0 |
| 2022-01-24 | TSLA | Stock | 301.5867 | 311.17 | 283.8233 | 310.0 | 151565700.0 |
| 2022-01-24 | TLT | Stock | 144.3 | 144.365 | 142.43 | 142.45 | 25005719.0 |
| 2022-01-24 | ES | Stock | 87.46 | 88.08 | 84.05 | 86.15 | 2821200.0 |
| 2022-01-24 | CL | Stock | 84.18 | 84.75 | 82.24 | 83.67 | 7339800.0 |
| 2022-01-24 | A | Stock | 136.38 | 138.49 | 131.28 | 138.12 | 2155300.0 |
| 2022-01-24 | AA | Stock | 53.81 | 58.2 | 53.26 | 58.02 | 9203100.0 |
| 2022-01-24 | AAC-DELISTED | Stock | 9.72 | 9.74 | 9.7 | 9.7 | 138920.0 |
| 2022-01-24 | AACG | Stock | 1.71 | 1.72 | 1.55 | 1.7 | 131800.0 |
| 2022-01-24 | AACIW-DELISTED | Stock | 0.34 | 0.34 | 0.301 | 0.3343 | 39213.0 |
| 2022-01-24 | AAIC-DELISTED | Stock | 3.42 | 3.42 | 3.25 | 3.36 | 175835.0 |
| 2022-01-24 | AAIC.C-DELISTED | Stock | 24.9 | 24.9999 | 24.51 | 24.7 | 5480.0 |
| 2022-01-24 | AAL | Stock | 15.85 | 16.44 | 15.38 | 16.41 | 59941000.0 |
| 2022-01-24 | AAM.A-DELISTED | Stock | 25.35 | 25.45 | 25.28 | 25.42 | 144838.0 |
| 2022-01-24 | AAM.B-DELISTED | Stock | 26.19 | 26.38 | 25.98 | 26.255 | 31830.0 |
| 2022-01-24 | AAME | Stock | 2.2 | 2.34 | 2.12 | 2.31 | 25400.0 |
| 2022-01-24 | AAMI | Stock | 21.41 | 22.03 | 20.72 | 21.94 | 709000.0 |
| 2022-01-24 | AAN-DELISTED | Stock | 20.8 | 22.67 | 20.671 | 22.53 | 303400.0 |
| 2022-01-24 | AAOI | Stock | 3.77 | 4.03 | 3.63 | 4.02 | 802400.0 |
| 2022-01-24 | AAON | Stock | 43.6733 | 45.1933 | 43.2067 | 44.9933 | 522450.0 |
| 2022-01-24 | AAP | Stock | 221.48 | 233.24 | 221.48 | 232.81 | 767200.0 |
| 2022-01-24 | AAQC-DELISTED | Stock | 9.7 | 9.7 | 9.69 | 9.69 | 34165.0 |
| 2022-01-24 | AAT | Stock | 35.18 | 35.62 | 34.26 | 35.39 | 313200.0 |
| 2022-01-24 | AATC | Stock | 6.02 | 6.02 | 5.75 | 5.94 | 30593.0 |
| 2022-01-24 | AAU-DELISTED | Stock | 0.2764 | 0.2799 | 0.27 | 0.2704 | 558746.0 |
| 2022-01-24 | AAUAF-DELISTED | Stock | 0.2764 | 0.2799 | 0.27 | 0.2704 | 562929.0 |
| 2022-01-24 | AAWW-DELISTED | Stock | 76.93 | 79.4494 | 76.1 | 79.42 | 390951.0 |
| 2022-01-24 | AAXJ | Stock | 81.83 | 81.83 | 79.87 | 81.59 | 1840696.0 |
| 2022-01-24 | AB | Stock | 46.78 | 47.0 | 43.52 | 45.71 | 1112300.0 |
| 2022-01-24 | ABB-DELISTED | Stock | 35.17 | 35.74 | 34.505 | 35.71 | 2921328.0 |
| 2022-01-24 | ABBNY-DELISTED | Stock | 35.17 | 35.74 | 34.505 | 35.71 | 3225561.0 |
| 2022-01-24 | ABBV | Stock | 132.82 | 133.25 | 128.26 | 132.16 | 13733800.0 |
| 2022-01-24 | ABC-DELISTED | Stock | 130.08 | 132.0 | 127.94 | 131.54 | 892718.0 |
| 2022-01-24 | ABCB | Stock | 49.38 | 51.84 | 49.38 | 51.53 | 520700.0 |
| 2022-01-24 | ABCL | Stock | 8.46 | 8.61 | 7.42 | 8.57 | 4978900.0 |
| 2022-01-24 | ABCM-DELISTED | Stock | 16.68 | 16.68 | 15.83 | 16.53 | 222024.0 |
| 2022-01-24 | ABEO | Stock | 5.75 | 5.75 | 5.25 | 5.75 | 149816.0 |
| 2022-01-24 | ABEV | Stock | 2.68 | 2.7 | 2.64 | 2.69 | 27975000.0 |
| 2022-01-24 | ABG | Stock | 154.66 | 169.08 | 153.5 | 168.58 | 399600.0 |
| 2022-01-24 | ABM | Stock | 40.73 | 42.48 | 40.51 | 42.26 | 587000.0 |
| 2022-01-24 | ABMD-DELISTED | Stock | 300.03 | 312.57 | 291.81 | 311.87 | 487919.0 |
| 2022-01-24 | ABNB | Stock | 150.0 | 151.16 | 135.76 | 147.9 | 14606600.0 |
| 2022-01-24 | ABOS | Stock | 5.15 | 5.24 | 4.89 | 5.23 | 303800.0 |
| 2022-01-24 | ABR | Stock | 16.5 | 17.08 | 16.11 | 17.05 | 4377600.0 |
| 2022-01-24 | ABR.D | Stock | 25.08 | 25.16 | 25.045 | 25.1 | 23115.0 |
> showing 50 of 8,206 rows — these rows as CSV