PREVIEW / stock_daily / 2022-04-28
file: by_date/stock_daily/2022/2022-04-28.parquet size: 260 KB rows: 8,096 symbols: 2,492
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-04-28 | AAPL | Stock | 159.25 | 164.52 | 158.93 | 163.64 | 130216800.0 |
| 2022-04-28 | MSFT | Stock | 285.19 | 290.98 | 281.46 | 289.63 | 33646600.0 |
| 2022-04-28 | NVDA | Stock | 18.967 | 20.037 | 18.49 | 19.782 | 570327000.0 |
| 2022-04-28 | AMZN | Stock | 142.178 | 145.9375 | 140.3 | 144.5965 | 117316000.0 |
| 2022-04-28 | GOOGL | Stock | 116.415 | 119.6495 | 114.115 | 118.5225 | 48884640.0 |
| 2022-04-28 | META | Stock | 202.92 | 208.53 | 192.9 | 205.73 | 100890600.0 |
| 2022-04-28 | TSLA | Stock | 299.9933 | 300.0 | 273.9 | 292.5033 | 124948500.0 |
| 2022-04-28 | TLT | Stock | 120.39 | 121.07 | 120.01 | 121.02 | 16892495.0 |
| 2022-04-28 | ES | Stock | 89.92 | 90.61 | 89.12 | 90.2 | 1291400.0 |
| 2022-04-28 | CL | Stock | 80.87 | 81.53 | 80.26 | 81.22 | 5400200.0 |
| 2022-04-28 | A | Stock | 119.52 | 121.56 | 117.93 | 121.06 | 3152200.0 |
| 2022-04-28 | AA | Stock | 69.78 | 70.998 | 67.081 | 70.52 | 5639700.0 |
| 2022-04-28 | AAC-DELISTED | Stock | 9.84 | 9.855 | 9.84 | 9.845 | 800.0 |
| 2022-04-28 | AACG | Stock | 1.16 | 1.16 | 1.13 | 1.15 | 10400.0 |
| 2022-04-28 | AACIW-DELISTED | Stock | 0.35 | 0.35 | 0.31 | 0.3145 | 15350.0 |
| 2022-04-28 | AAIC-DELISTED | Stock | 3.19 | 3.27 | 3.16 | 3.22 | 126514.0 |
| 2022-04-28 | AAIC.C-DELISTED | Stock | 24.578 | 24.58 | 24.53 | 24.54 | 12980.0 |
| 2022-04-28 | AAL | Stock | 19.13 | 19.56 | 18.64 | 19.43 | 27601000.0 |
| 2022-04-28 | AAM.A-DELISTED | Stock | 24.46 | 24.89 | 24.2576 | 24.7 | 25557.0 |
| 2022-04-28 | AAM.B-DELISTED | Stock | 24.9 | 25.3 | 24.8 | 25.29 | 51434.0 |
| 2022-04-28 | AAMC-DELISTED | Stock | 2.8824 | 2.9992 | 2.8824 | 2.9118 | 12026.0 |
| 2022-04-28 | AAME | Stock | 3.09 | 3.14 | 3.0 | 3.0 | 11400.0 |
| 2022-04-28 | AAMI | Stock | 20.62 | 20.89 | 19.99 | 20.64 | 237400.0 |
| 2022-04-28 | AAN-DELISTED | Stock | 19.57 | 20.84 | 19.3 | 20.66 | 289400.0 |
| 2022-04-28 | AAOI | Stock | 2.56 | 2.66 | 2.45 | 2.58 | 364700.0 |
| 2022-04-28 | AAON | Stock | 32.98 | 33.7267 | 32.0267 | 33.3933 | 293250.0 |
| 2022-04-28 | AAP | Stock | 218.49 | 218.49 | 204.08 | 209.39 | 2010900.0 |
| 2022-04-28 | AAQC-DELISTED | Stock | 9.78 | 9.78 | 9.78 | 9.78 | 903.0 |
| 2022-04-28 | AAT | Stock | 37.53 | 38.11 | 36.93 | 37.94 | 290900.0 |
| 2022-04-28 | AATC | Stock | 6.5983 | 6.74 | 6.5352 | 6.61 | 11272.0 |
| 2022-04-28 | AAU-DELISTED | Stock | 0.3199 | 0.3199 | 0.3001 | 0.3093 | 289951.0 |
| 2022-04-28 | AAUAF-DELISTED | Stock | 0.3199 | 0.3199 | 0.3001 | 0.3093 | 297721.0 |
| 2022-04-28 | AAWW-DELISTED | Stock | 68.77 | 69.89 | 67.61 | 69.78 | 272231.0 |
| 2022-04-28 | AAXJ | Stock | 70.01 | 70.52 | 69.36 | 70.41 | 1764448.0 |
| 2022-04-28 | AB | Stock | 40.08 | 40.52 | 38.86 | 40.01 | 507000.0 |
| 2022-04-28 | ABB-DELISTED | Stock | 29.88 | 30.345 | 29.445 | 30.23 | 2832755.0 |
| 2022-04-28 | ABBNY-DELISTED | Stock | 29.88 | 30.345 | 29.445 | 30.23 | 3109256.0 |
| 2022-04-28 | ABBV | Stock | 158.36 | 158.44 | 154.34 | 156.31 | 7465000.0 |
| 2022-04-28 | ABC-DELISTED | Stock | 157.82 | 158.92 | 157.04 | 157.74 | 740611.0 |
| 2022-04-28 | ABCB | Stock | 42.48 | 42.78 | 41.44 | 42.32 | 374500.0 |
| 2022-04-28 | ABCL | Stock | 7.85 | 7.89 | 7.292 | 7.88 | 1215100.0 |
| 2022-04-28 | ABCM-DELISTED | Stock | 15.39 | 15.545 | 15.12 | 15.49 | 106678.0 |
| 2022-04-28 | ABEO | Stock | 5.5 | 5.75 | 5.25 | 5.5 | 41560.0 |
| 2022-04-28 | ABEV | Stock | 2.9 | 2.97 | 2.87 | 2.95 | 27522000.0 |
| 2022-04-28 | ABG | Stock | 167.26 | 176.8 | 162.6 | 173.77 | 348700.0 |
| 2022-04-28 | ABGI-DELISTED | Stock | 9.81 | 9.81 | 9.8 | 9.8 | 50000.0 |
| 2022-04-28 | ABM | Stock | 48.65 | 48.69 | 47.29 | 48.17 | 596500.0 |
| 2022-04-28 | ABMD-DELISTED | Stock | 283.77 | 291.28 | 274.665 | 287.0 | 280738.0 |
| 2022-04-28 | ABNB | Stock | 154.01 | 161.255 | 153.66 | 159.74 | 4854500.0 |
| 2022-04-28 | ABOS | Stock | 4.02 | 4.135 | 3.71 | 3.92 | 156300.0 |
> showing 50 of 8,096 rows — these rows as CSV