PREVIEW / stock_daily / 2022-05-05
file: by_date/stock_daily/2022/2022-05-05.parquet size: 258 KB rows: 7,976 symbols: 2,408
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-05-05 | AAPL | Stock | 163.85 | 164.08 | 154.95 | 156.77 | 130525300.0 |
| 2022-05-05 | MSFT | Stock | 285.54 | 286.35 | 274.34 | 277.35 | 43260400.0 |
| 2022-05-05 | NVDA | Stock | 19.867 | 19.925 | 18.5 | 18.844 | 626331000.0 |
| 2022-05-05 | AMZN | Stock | 123.0 | 123.499 | 115.0725 | 116.407 | 144392000.0 |
| 2022-05-05 | GOOGL | Stock | 120.204 | 121.039 | 115.0058 | 116.5055 | 45840580.0 |
| 2022-05-05 | META | Stock | 218.74 | 220.17 | 206.16 | 208.28 | 41129200.0 |
| 2022-05-05 | TSLA | Stock | 313.0067 | 315.2 | 285.9 | 291.0933 | 92519100.0 |
| 2022-05-05 | TLT | Stock | 116.35 | 116.47 | 114.015 | 115.37 | 48384528.0 |
| 2022-05-05 | ES | Stock | 88.27 | 91.99 | 88.17 | 89.82 | 2401800.0 |
| 2022-05-05 | CL | Stock | 76.49 | 76.87 | 75.56 | 76.09 | 5056300.0 |
| 2022-05-05 | A | Stock | 124.62 | 125.21 | 120.8 | 122.15 | 2123600.0 |
| 2022-05-05 | AA | Stock | 67.77 | 68.17 | 61.94 | 63.46 | 6049300.0 |
| 2022-05-05 | AAC-DELISTED | Stock | 9.83 | 9.84 | 9.83 | 9.83 | 170731.0 |
| 2022-05-05 | AACG | Stock | 1.16 | 1.17 | 1.14 | 1.17 | 13700.0 |
| 2022-05-05 | AACIU | Stock | 9.98 | 9.98 | 9.98 | 9.98 | 558.0 |
| 2022-05-05 | AACIW-DELISTED | Stock | 0.28 | 0.28 | 0.2709 | 0.2709 | 9000.0 |
| 2022-05-05 | AAIC-DELISTED | Stock | 3.24 | 3.29 | 3.17 | 3.19 | 74863.0 |
| 2022-05-05 | AAIC.C-DELISTED | Stock | 24.75 | 24.75 | 24.5 | 24.5 | 3092.0 |
| 2022-05-05 | AAL | Stock | 19.25 | 19.52 | 18.38 | 18.54 | 32054500.0 |
| 2022-05-05 | AAM.A-DELISTED | Stock | 24.91 | 24.91 | 24.55 | 24.7786 | 7677.0 |
| 2022-05-05 | AAM.B-DELISTED | Stock | 25.09 | 25.4 | 25.07 | 25.1 | 90600.0 |
| 2022-05-05 | AAMC-DELISTED | Stock | 3.2 | 3.4618 | 3.1176 | 3.1176 | 80158.0 |
| 2022-05-05 | AAME | Stock | 3.05 | 3.05 | 2.93 | 3.0 | 4100.0 |
| 2022-05-05 | AAMI | Stock | 20.56 | 21.31 | 20.25 | 21.21 | 532400.0 |
| 2022-05-05 | AAN-DELISTED | Stock | 21.39 | 21.5 | 20.505 | 21.08 | 178200.0 |
| 2022-05-05 | AAOI | Stock | 2.79 | 2.85 | 2.61 | 2.61 | 220100.0 |
| 2022-05-05 | AAON | Stock | 32.9133 | 33.1267 | 31.6667 | 31.9533 | 246600.0 |
| 2022-05-05 | AAP | Stock | 206.84 | 207.49 | 198.62 | 201.33 | 754900.0 |
| 2022-05-05 | AAT | Stock | 35.6 | 35.87 | 34.5 | 34.84 | 264000.0 |
| 2022-05-05 | AATC | Stock | 6.5 | 6.5 | 6.35 | 6.4 | 8656.0 |
| 2022-05-05 | AAU-DELISTED | Stock | 0.32 | 0.32 | 0.2937 | 0.2976 | 161519.0 |
| 2022-05-05 | AAUAF-DELISTED | Stock | 0.32 | 0.32 | 0.2937 | 0.2976 | 163919.0 |
| 2022-05-05 | AAWW-DELISTED | Stock | 73.07 | 73.07 | 69.67 | 71.86 | 481829.0 |
| 2022-05-05 | AAXJ | Stock | 70.9 | 70.9 | 69.01 | 69.57 | 3226950.0 |
| 2022-05-05 | AB | Stock | 41.79 | 41.79 | 40.3 | 41.26 | 577300.0 |
| 2022-05-05 | ABB-DELISTED | Stock | 30.3 | 30.31 | 29.265 | 29.57 | 4650914.0 |
| 2022-05-05 | ABBNY-DELISTED | Stock | 30.3 | 30.3 | 29.265 | 29.56 | 4961668.0 |
| 2022-05-05 | ABBV | Stock | 152.77 | 153.32 | 150.04 | 152.18 | 6869300.0 |
| 2022-05-05 | ABC-DELISTED | Stock | 154.87 | 156.56 | 153.42 | 155.46 | 1008812.0 |
| 2022-05-05 | ABCB | Stock | 43.99 | 44.11 | 42.67 | 43.44 | 282500.0 |
| 2022-05-05 | ABCL | Stock | 8.13 | 8.13 | 7.53 | 7.76 | 1195700.0 |
| 2022-05-05 | ABCM-DELISTED | Stock | 14.92 | 14.97 | 14.29 | 14.43 | 92291.0 |
| 2022-05-05 | ABEO | Stock | 4.75 | 5.0 | 4.5 | 4.5 | 76752.0 |
| 2022-05-05 | ABEV | Stock | 2.77 | 2.79 | 2.67 | 2.71 | 36920400.0 |
| 2022-05-05 | ABG | Stock | 196.16 | 197.7 | 186.24 | 190.02 | 208400.0 |
| 2022-05-05 | ABM | Stock | 48.0 | 48.27 | 46.07 | 46.62 | 392000.0 |
| 2022-05-05 | ABMD-DELISTED | Stock | 291.48 | 298.5 | 269.06 | 272.25 | 174253.0 |
| 2022-05-05 | ABNB | Stock | 152.19 | 153.88 | 140.858 | 143.09 | 11367200.0 |
| 2022-05-05 | ABOS | Stock | 3.93 | 3.98 | 3.73 | 3.77 | 216100.0 |
| 2022-05-05 | ABR | Stock | 17.51 | 17.62 | 17.16 | 17.27 | 2105400.0 |
> showing 50 of 7,976 rows — these rows as CSV