PREVIEW / stock_daily / 2024-05-02
file: by_date/stock_daily/2024/2024-05-02.parquet size: 230 KB rows: 7,138 symbols: 965
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 |
|---|---|---|---|---|---|---|---|
| 2024-05-02 | AAPL | Stock | 172.51 | 173.42 | 170.89 | 173.03 | 94214900.0 |
| 2024-05-02 | MSFT | Stock | 397.66 | 399.93 | 394.65 | 397.84 | 17709400.0 |
| 2024-05-02 | NVDA | Stock | 84.449 | 86.237 | 83.2 | 85.817 | 377898000.0 |
| 2024-05-02 | AMZN | Stock | 180.85 | 185.1 | 179.91 | 184.72 | 54303500.0 |
| 2024-05-02 | GOOGL | Stock | 164.785 | 166.73 | 163.89 | 166.62 | 24294549.0 |
| 2024-05-02 | META | Stock | 438.84 | 443.96 | 432.28 | 441.68 | 15221300.0 |
| 2024-05-02 | TSLA | Stock | 182.86 | 184.6 | 176.02 | 180.01 | 89148000.0 |
| 2024-05-02 | TLT | Stock | 88.21 | 89.01 | 88.025 | 88.94 | 58925388.0 |
| 2024-05-02 | ES | Stock | 62.62 | 63.24 | 60.32 | 60.75 | 3164800.0 |
| 2024-05-02 | CL | Stock | 91.84 | 93.25 | 91.36 | 92.91 | 9506000.0 |
| 2024-05-02 | A | Stock | 139.23 | 139.89 | 136.71 | 137.52 | 1146800.0 |
| 2024-05-02 | AA | Stock | 34.11 | 35.975 | 34.025 | 35.94 | 5784400.0 |
| 2024-05-02 | AACG | Stock | 0.9 | 0.92 | 0.9 | 0.9 | 10500.0 |
| 2024-05-02 | AACIW-DELISTED | Stock | 0.14 | 0.1401 | 0.14 | 0.14 | 25736.0 |
| 2024-05-02 | AACT | Stock | 10.62 | 10.64 | 10.62 | 10.63 | 2952200.0 |
| 2024-05-02 | AAGR-DELISTED | Stock | 0.3781 | 0.4001 | 0.3553 | 0.373 | 108865.0 |
| 2024-05-02 | AAGRW-DELISTED | Stock | 0.014 | 0.014 | 0.0127 | 0.0139 | 6475.0 |
| 2024-05-02 | AAL | Stock | 13.78 | 13.9 | 13.69 | 13.86 | 24191500.0 |
| 2024-05-02 | AAMC-DELISTED | Stock | 2.91 | 3.26 | 2.62 | 3.22 | 13500.0 |
| 2024-05-02 | AAME | Stock | 1.87 | 1.9 | 1.87 | 1.88 | 1300.0 |
| 2024-05-02 | AAMI | Stock | 22.76 | 22.77 | 22.285 | 22.62 | 241200.0 |
| 2024-05-02 | AAN-DELISTED | Stock | 6.84 | 6.865 | 6.75 | 6.79 | 164300.0 |
| 2024-05-02 | AAOI | Stock | 10.25 | 10.55 | 9.85 | 10.35 | 892400.0 |
| 2024-05-02 | AAON | Stock | 94.47 | 94.56 | 90.66 | 90.89 | 1014900.0 |
| 2024-05-02 | AAP | Stock | 73.95 | 75.01 | 73.0 | 74.92 | 610400.0 |
| 2024-05-02 | AAT | Stock | 21.72 | 21.77 | 21.23 | 21.56 | 314000.0 |
| 2024-05-02 | AATC | Stock | 6.54 | 6.73 | 6.54 | 6.57 | 4211.0 |
| 2024-05-02 | AAUAF-DELISTED | Stock | 0.118 | 0.124 | 0.118 | 0.1216 | 22073.0 |
| 2024-05-02 | AAXJ | Stock | 69.09 | 70.33 | 69.0 | 70.2 | 390795.0 |
| 2024-05-02 | AB | Stock | 33.4 | 33.49 | 32.56 | 33.28 | 320700.0 |
| 2024-05-02 | ABAT | Stock | 1.33 | 1.37 | 1.3 | 1.36 | 319840.0 |
| 2024-05-02 | ABBV | Stock | 162.17 | 162.44 | 158.12 | 160.81 | 5904300.0 |
| 2024-05-02 | ABCB | Stock | 48.5 | 48.96 | 48.03 | 48.68 | 400900.0 |
| 2024-05-02 | ABCL | Stock | 3.89 | 3.89 | 3.68 | 3.85 | 1237900.0 |
| 2024-05-02 | ABEO | Stock | 3.95 | 4.28 | 3.84 | 4.07 | 756500.0 |
| 2024-05-02 | ABEV | Stock | 2.39 | 2.44 | 2.38 | 2.41 | 15458900.0 |
| 2024-05-02 | ABG | Stock | 212.18 | 213.45 | 208.41 | 208.45 | 218500.0 |
| 2024-05-02 | ABLLW | Stock | 0.5495 | 0.5799 | 0.53 | 0.5799 | 3717.0 |
| 2024-05-02 | ABLV | Stock | 1.36 | 1.6 | 1.35 | 1.52 | 4700.0 |
| 2024-05-02 | ABM | Stock | 45.02 | 45.07 | 44.52 | 44.84 | 502000.0 |
| 2024-05-02 | ABNB | Stock | 157.21 | 158.4 | 153.2 | 158.33 | 4778400.0 |
| 2024-05-02 | ABOS | Stock | 3.31 | 3.48 | 3.24 | 3.48 | 235400.0 |
| 2024-05-02 | ABR | Stock | 13.16 | 13.33 | 13.0 | 13.08 | 4023700.0 |
| 2024-05-02 | ABR.D | Stock | 18.15 | 18.27 | 18.15 | 18.26 | 9452.0 |
| 2024-05-02 | ABR.E | Stock | 17.8033 | 18.2088 | 17.8033 | 17.94 | 10095.0 |
| 2024-05-02 | ABR.F | Stock | 19.0645 | 19.35 | 19.0645 | 19.15 | 12701.0 |
| 2024-05-02 | ABSI | Stock | 5.23 | 5.31 | 4.9 | 4.98 | 660700.0 |
| 2024-05-02 | ABT | Stock | 106.66 | 106.66 | 105.15 | 105.92 | 3708500.0 |
| 2024-05-02 | ABTC | Stock | 116.25 | 119.25 | 108.75 | 116.25 | 1612.0 |
| 2024-05-02 | ABTS | Stock | 12.0 | 12.0 | 11.175 | 11.385 | 420.0 |
> showing 50 of 7,138 rows — these rows as CSV