PREVIEW / stock_daily / 2022-04-12
file: by_date/stock_daily/2022/2022-04-12.parquet size: 261 KB rows: 8,032 symbols: 2,468
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-12 | AAPL | Stock | 168.02 | 169.87 | 166.64 | 167.66 | 79265200.0 |
| 2022-04-12 | MSFT | Stock | 289.24 | 290.74 | 280.49 | 282.06 | 30966700.0 |
| 2022-04-12 | NVDA | Stock | 22.537 | 22.725 | 21.282 | 21.504 | 662258000.0 |
| 2022-04-12 | AMZN | Stock | 153.6925 | 155.099 | 150.383 | 150.7875 | 55178000.0 |
| 2022-04-12 | GOOGL | Stock | 131.6 | 131.6 | 126.789 | 127.7145 | 32710700.0 |
| 2022-04-12 | META | Stock | 220.24 | 222.03 | 213.13 | 214.14 | 20128800.0 |
| 2022-04-12 | TSLA | Stock | 332.5467 | 340.3967 | 325.5333 | 328.9833 | 65976000.0 |
| 2022-04-12 | TLT | Stock | 124.05 | 124.16 | 122.67 | 122.97 | 23124178.0 |
| 2022-04-12 | ES | Stock | 91.51 | 93.03 | 90.78 | 92.84 | 1556500.0 |
| 2022-04-12 | CL | Stock | 80.19 | 81.22 | 80.09 | 81.0 | 6488300.0 |
| 2022-04-12 | A | Stock | 131.69 | 132.19 | 125.03 | 125.39 | 2657500.0 |
| 2022-04-12 | AA | Stock | 83.7 | 86.38 | 82.954 | 83.26 | 4274300.0 |
| 2022-04-12 | AAC-DELISTED | Stock | 9.87 | 9.87 | 9.81 | 9.81 | 16012.0 |
| 2022-04-12 | AACG | Stock | 1.23 | 1.27 | 1.18 | 1.21 | 32900.0 |
| 2022-04-12 | AAIC-DELISTED | Stock | 3.41 | 3.46 | 3.35 | 3.3536 | 62357.0 |
| 2022-04-12 | AAIC.C-DELISTED | Stock | 24.8 | 24.82 | 24.6303 | 24.6303 | 4584.0 |
| 2022-04-12 | AAL | Stock | 17.13 | 17.16 | 16.69 | 17.13 | 31461600.0 |
| 2022-04-12 | AAM.A-DELISTED | Stock | 25.0 | 25.05 | 24.98 | 25.025 | 12531.0 |
| 2022-04-12 | AAM.B-DELISTED | Stock | 25.17 | 25.36 | 25.1557 | 25.21 | 13402.0 |
| 2022-04-12 | AAMC-DELISTED | Stock | 3.2676 | 3.2882 | 3.2029 | 3.2059 | 35431.0 |
| 2022-04-12 | AAME | Stock | 3.7 | 3.7 | 3.45 | 3.58 | 10100.0 |
| 2022-04-12 | AAMI | Stock | 21.97 | 22.3 | 21.33 | 21.59 | 664100.0 |
| 2022-04-12 | AAN-DELISTED | Stock | 21.62 | 22.23 | 21.15 | 21.22 | 215000.0 |
| 2022-04-12 | AAOI | Stock | 3.1 | 3.14 | 3.02 | 3.03 | 192100.0 |
| 2022-04-12 | AAON | Stock | 35.1533 | 35.44 | 34.3867 | 34.6333 | 305400.0 |
| 2022-04-12 | AAP | Stock | 222.16 | 224.86 | 220.19 | 221.88 | 769800.0 |
| 2022-04-12 | AAQC-DELISTED | Stock | 9.77 | 9.775 | 9.76 | 9.775 | 205118.0 |
| 2022-04-12 | AAT | Stock | 35.51 | 35.98 | 35.28 | 35.37 | 313500.0 |
| 2022-04-12 | AATC | Stock | 6.33 | 6.3491 | 6.16 | 6.27 | 14022.0 |
| 2022-04-12 | AAU-DELISTED | Stock | 0.35 | 0.359 | 0.35 | 0.358 | 426389.0 |
| 2022-04-12 | AAUAF-DELISTED | Stock | 0.35 | 0.359 | 0.35 | 0.358 | 431791.0 |
| 2022-04-12 | AAWW-DELISTED | Stock | 66.0 | 68.88 | 65.95 | 66.85 | 389763.0 |
| 2022-04-12 | AAXJ | Stock | 73.92 | 74.06 | 73.08 | 73.14 | 2263179.0 |
| 2022-04-12 | AB | Stock | 47.27 | 47.61 | 45.85 | 46.28 | 262700.0 |
| 2022-04-12 | ABB-DELISTED | Stock | 31.21 | 31.39 | 30.615 | 30.705 | 2590499.0 |
| 2022-04-12 | ABBNY-DELISTED | Stock | 31.21 | 31.39 | 30.615 | 30.71 | 2857630.0 |
| 2022-04-12 | ABBV | Stock | 169.31 | 170.56 | 166.21 | 167.31 | 8279700.0 |
| 2022-04-12 | ABC-DELISTED | Stock | 161.19 | 163.145 | 159.51 | 162.6 | 711105.0 |
| 2022-04-12 | ABCB | Stock | 40.77 | 41.32 | 40.09 | 40.31 | 490500.0 |
| 2022-04-12 | ABCL | Stock | 8.95 | 9.1 | 8.47 | 8.66 | 1239900.0 |
| 2022-04-12 | ABCM-DELISTED | Stock | 18.95 | 19.155 | 18.75 | 18.91 | 85346.0 |
| 2022-04-12 | ABEO | Stock | 7.25 | 8.25 | 6.5 | 6.75 | 131536.0 |
| 2022-04-12 | ABEV | Stock | 3.31 | 3.32 | 3.17 | 3.21 | 28086400.0 |
| 2022-04-12 | ABG | Stock | 161.58 | 166.36 | 154.1 | 154.85 | 293900.0 |
| 2022-04-12 | ABGI-DELISTED | Stock | 9.8 | 9.82 | 9.8 | 9.82 | 1667.0 |
| 2022-04-12 | ABM | Stock | 47.31 | 48.07 | 47.27 | 47.5 | 280100.0 |
| 2022-04-12 | ABMD-DELISTED | Stock | 303.03 | 308.11 | 296.84 | 299.71 | 80806.0 |
| 2022-04-12 | ABNB | Stock | 163.7 | 166.11 | 157.28 | 160.11 | 4113000.0 |
| 2022-04-12 | ABOS | Stock | 3.88 | 3.99 | 3.67 | 3.7 | 271800.0 |
| 2022-04-12 | ABR | Stock | 17.02 | 17.17 | 16.98 | 17.07 | 1424600.0 |
> showing 50 of 8,032 rows — these rows as CSV