PREVIEW / stock_daily / 2024-07-02
file: by_date/stock_daily/2024/2024-07-02.parquet size: 230 KB rows: 7,215 symbols: 930
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-07-02 | AAPL | Stock | 216.15 | 220.38 | 215.1 | 220.27 | 57960500.0 |
| 2024-07-02 | MSFT | Stock | 453.2 | 459.59 | 453.11 | 459.28 | 13979800.0 |
| 2024-07-02 | NVDA | Stock | 121.13 | 123.41 | 121.03 | 122.67 | 218374000.0 |
| 2024-07-02 | AMZN | Stock | 197.28 | 200.43 | 195.93 | 200.0 | 45526900.0 |
| 2024-07-02 | GOOGL | Stock | 182.05 | 185.57 | 181.56 | 185.24 | 17372485.0 |
| 2024-07-02 | META | Stock | 500.76 | 510.5 | 499.45 | 509.5 | 7739500.0 |
| 2024-07-02 | TSLA | Stock | 218.89 | 231.3 | 218.06 | 231.26 | 205047900.0 |
| 2024-07-02 | TLT | Stock | 90.68 | 90.805 | 90.08 | 90.61 | 34204719.0 |
| 2024-07-02 | ES | Stock | 56.73 | 57.27 | 56.27 | 56.52 | 1987100.0 |
| 2024-07-02 | CL | Stock | 95.5 | 96.25 | 95.02 | 96.12 | 4205800.0 |
| 2024-07-02 | A | Stock | 127.43 | 128.57 | 125.44 | 125.78 | 1981100.0 |
| 2024-07-02 | AA | Stock | 39.89 | 41.15 | 39.854 | 40.83 | 4039200.0 |
| 2024-07-02 | AACG | Stock | 0.79 | 0.83 | 0.79 | 0.82 | 10800.0 |
| 2024-07-02 | AACT | Stock | 10.7 | 10.7 | 10.67 | 10.68 | 176210.0 |
| 2024-07-02 | AAGR-DELISTED | Stock | 0.2279 | 0.2279 | 0.201 | 0.201 | 1758581.0 |
| 2024-07-02 | AAGRW-DELISTED | Stock | 0.0171 | 0.0171 | 0.0171 | 0.0171 | 1818.0 |
| 2024-07-02 | AAL | Stock | 11.06 | 11.11 | 10.95 | 11.05 | 22450100.0 |
| 2024-07-02 | AAMC-DELISTED | Stock | 2.22 | 2.22 | 1.76 | 2.11 | 10567.0 |
| 2024-07-02 | AAME | Stock | 1.64 | 1.64 | 1.58 | 1.58 | 202.0 |
| 2024-07-02 | AAMI | Stock | 22.06 | 22.82 | 21.965 | 22.8 | 227600.0 |
| 2024-07-02 | AAN-DELISTED | Stock | 9.96 | 9.97 | 9.93 | 9.96 | 827400.0 |
| 2024-07-02 | AAOI | Stock | 8.08 | 8.19 | 7.55 | 7.9 | 2393500.0 |
| 2024-07-02 | AAON | Stock | 83.63 | 85.92 | 83.1 | 85.8 | 701000.0 |
| 2024-07-02 | AAP | Stock | 59.26 | 60.73 | 58.98 | 60.6 | 1650800.0 |
| 2024-07-02 | AAT | Stock | 22.47 | 22.69 | 22.21 | 22.22 | 281500.0 |
| 2024-07-02 | AATC | Stock | 6.7 | 6.7 | 6.391 | 6.391 | 6522.0 |
| 2024-07-02 | AAUAF-DELISTED | Stock | 0.0602 | 0.0602 | 0.0544 | 0.0577 | 51132.0 |
| 2024-07-02 | AAXJ | Stock | 72.01 | 72.5551 | 71.97 | 72.55 | 437042.0 |
| 2024-07-02 | AB | Stock | 33.45 | 34.0 | 33.31 | 33.53 | 158000.0 |
| 2024-07-02 | ABAT | Stock | 1.16 | 1.16 | 1.05 | 1.1 | 684268.0 |
| 2024-07-02 | ABBV | Stock | 168.63 | 168.63 | 165.45 | 165.96 | 5964600.0 |
| 2024-07-02 | ABCB | Stock | 50.28 | 51.06 | 50.26 | 50.61 | 476900.0 |
| 2024-07-02 | ABCL | Stock | 2.8 | 2.8 | 2.7 | 2.77 | 2136500.0 |
| 2024-07-02 | ABEO | Stock | 4.15 | 4.22 | 4.11 | 4.12 | 160000.0 |
| 2024-07-02 | ABEV | Stock | 2.04 | 2.06 | 2.02 | 2.06 | 20111000.0 |
| 2024-07-02 | ABG | Stock | 229.09 | 230.65 | 227.14 | 227.31 | 179600.0 |
| 2024-07-02 | ABLLW | Stock | 0.65 | 0.65 | 0.625 | 0.625 | 1959.0 |
| 2024-07-02 | ABLV | Stock | 1.05 | 1.13 | 1.13 | 1.13 | 9.0 |
| 2024-07-02 | ABM | Stock | 50.3 | 50.59 | 49.83 | 50.25 | 441400.0 |
| 2024-07-02 | ABNB | Stock | 151.29 | 155.21 | 151.29 | 154.34 | 3525200.0 |
| 2024-07-02 | ABOS | Stock | 2.38 | 2.4 | 2.23 | 2.27 | 276600.0 |
| 2024-07-02 | ABR | Stock | 14.19 | 14.62 | 14.17 | 14.55 | 2795500.0 |
| 2024-07-02 | ABR.D | Stock | 18.6 | 18.8242 | 18.6 | 18.7614 | 9412.0 |
| 2024-07-02 | ABR.E | Stock | 18.35 | 18.36 | 18.0501 | 18.3172 | 5623.0 |
| 2024-07-02 | ABR.F | Stock | 19.99 | 20.1099 | 19.86 | 19.86 | 8293.0 |
| 2024-07-02 | ABSI | Stock | 2.97 | 3.03 | 2.915 | 2.97 | 840100.0 |
| 2024-07-02 | ABT | Stock | 102.7 | 103.39 | 102.7 | 103.2 | 3650200.0 |
| 2024-07-02 | ABTC | Stock | 90.75 | 95.25 | 90.75 | 93.75 | 3076.0 |
| 2024-07-02 | ABTS | Stock | 8.85 | 9.15 | 8.4 | 8.4 | 420.0 |
| 2024-07-02 | ABUS | Stock | 3.12 | 3.14 | 3.09 | 3.13 | 856600.0 |
> showing 50 of 7,215 rows — these rows as CSV