PREVIEW / etf_1hour / 2024-07-01
file: by_date/etf_1hour/2024/2024-07-01.parquet size: 557 KB rows: 20,844
schema
timestamp TIMESTAMP symbol VARCHAR asset_type VARCHAR open DOUBLE high DOUBLE low DOUBLE close DOUBLE volume DOUBLE
sample rows
| timestamp | symbol | asset_type | open | high | low | close | volume |
|---|---|---|---|---|---|---|---|
| 2024-07-01 04:00:00 | SPY | ETF | 544.85 | 545.48 | 544.45 | 544.63 | 36845.0 |
| 2024-07-01 05:00:00 | SPY | ETF | 544.52 | 544.8 | 544.18 | 544.8 | 104053.0 |
| 2024-07-01 06:00:00 | SPY | ETF | 545.0 | 545.2 | 544.64 | 545.15 | 34270.0 |
| 2024-07-01 07:00:00 | SPY | ETF | 545.11 | 545.57 | 544.76 | 545.46 | 265193.0 |
| 2024-07-01 08:00:00 | SPY | ETF | 545.1295 | 546.02 | 544.2304 | 545.37 | 241176.0 |
| 2024-07-01 09:00:00 | SPY | ETF | 545.4 | 545.8599 | 544.095 | 544.77 | 4321012.0 |
| 2024-07-01 10:00:00 | SPY | ETF | 544.77 | 545.47 | 542.52 | 543.35 | 5306384.0 |
| 2024-07-01 11:00:00 | SPY | ETF | 543.34 | 544.5 | 542.88 | 544.475 | 2526485.0 |
| 2024-07-01 12:00:00 | SPY | ETF | 544.47 | 545.37 | 543.96 | 545.0295 | 2811262.0 |
| 2024-07-01 13:00:00 | SPY | ETF | 545.02 | 545.25 | 544.6 | 544.92 | 1355229.0 |
| 2024-07-01 14:00:00 | SPY | ETF | 544.92 | 545.67 | 544.45 | 544.755 | 2249995.0 |
| 2024-07-01 15:00:00 | SPY | ETF | 544.75 | 545.88 | 543.82 | 545.37 | 6844524.0 |
| 2024-07-01 16:00:00 | SPY | ETF | 545.37 | 545.47 | 544.7126 | 545.19 | 3030988.0 |
| 2024-07-01 17:00:00 | SPY | ETF | 545.15 | 545.43 | 545.03 | 545.3 | 594749.0 |
| 2024-07-01 18:00:00 | SPY | ETF | 545.23 | 545.44 | 544.99 | 544.99 | 39056.0 |
| 2024-07-01 19:00:00 | SPY | ETF | 545.03 | 545.05 | 544.73 | 544.9 | 29739.0 |
| 2024-07-01 04:00:00 | QQQ | ETF | 479.46 | 480.3 | 478.87 | 479.1 | 71773.0 |
| 2024-07-01 05:00:00 | QQQ | ETF | 479.03 | 479.3 | 478.4 | 479.28 | 38646.0 |
| 2024-07-01 06:00:00 | QQQ | ETF | 479.27 | 479.79 | 479.1 | 479.71 | 53462.0 |
| 2024-07-01 07:00:00 | QQQ | ETF | 479.69 | 480.37 | 479.63 | 480.28 | 148440.0 |
| 2024-07-01 08:00:00 | QQQ | ETF | 479.79 | 481.14 | 478.5504 | 480.26 | 238955.0 |
| 2024-07-01 09:00:00 | QQQ | ETF | 480.34 | 480.55 | 476.945 | 478.09 | 3255081.0 |
| 2024-07-01 10:00:00 | QQQ | ETF | 478.12 | 479.55 | 476.255 | 478.545 | 4134548.0 |
| 2024-07-01 11:00:00 | QQQ | ETF | 478.52 | 480.21 | 478.03 | 480.18 | 1870957.0 |
| 2024-07-01 12:00:00 | QQQ | ETF | 480.18 | 481.41 | 479.76 | 481.0856 | 2198642.0 |
| 2024-07-01 13:00:00 | QQQ | ETF | 481.08 | 481.2399 | 480.2 | 480.75 | 1069153.0 |
| 2024-07-01 14:00:00 | QQQ | ETF | 480.76 | 481.96 | 480.33 | 481.095 | 1570310.0 |
| 2024-07-01 15:00:00 | QQQ | ETF | 481.085 | 482.49 | 480.36 | 481.94 | 3099959.0 |
| 2024-07-01 16:00:00 | QQQ | ETF | 481.92 | 482.17 | 481.312 | 481.8 | 1056020.0 |
| 2024-07-01 17:00:00 | QQQ | ETF | 481.81 | 481.8974 | 481.6601 | 481.88 | 12074.0 |
| 2024-07-01 18:00:00 | QQQ | ETF | 481.86 | 482.02 | 481.4999 | 481.53 | 72767.0 |
| 2024-07-01 19:00:00 | QQQ | ETF | 481.56 | 481.56 | 481.1 | 481.27 | 41254.0 |
| 2024-07-01 04:00:00 | IWM | ETF | 203.59 | 203.9 | 203.41 | 203.63 | 57899.0 |
| 2024-07-01 05:00:00 | IWM | ETF | 203.51 | 203.69 | 203.15 | 203.69 | 157846.0 |
| 2024-07-01 06:00:00 | IWM | ETF | 203.71 | 203.73 | 203.11 | 203.6 | 65543.0 |
| 2024-07-01 07:00:00 | IWM | ETF | 203.56 | 203.73 | 203.5 | 203.73 | 140333.0 |
| 2024-07-01 08:00:00 | IWM | ETF | 203.57 | 204.04 | 202.89 | 203.25 | 113205.0 |
| 2024-07-01 09:00:00 | IWM | ETF | 203.2 | 203.82 | 202.61 | 203.06 | 2252760.0 |
| 2024-07-01 10:00:00 | IWM | ETF | 203.07 | 203.6 | 200.85 | 201.361 | 3985787.0 |
| 2024-07-01 11:00:00 | IWM | ETF | 201.36 | 201.6425 | 200.48 | 201.05 | 2616693.0 |
| 2024-07-01 12:00:00 | IWM | ETF | 201.05 | 201.4 | 200.84 | 201.0963 | 1249199.0 |
| 2024-07-01 13:00:00 | IWM | ETF | 201.1 | 201.42 | 200.955 | 201.16 | 1047135.0 |
| 2024-07-01 14:00:00 | IWM | ETF | 201.15 | 201.595 | 200.96 | 201.24 | 1512536.0 |
| 2024-07-01 15:00:00 | IWM | ETF | 201.23 | 201.39 | 200.91 | 201.23 | 2775301.0 |
| 2024-07-01 16:00:00 | IWM | ETF | 201.19 | 201.33 | 201.11 | 201.21 | 893643.0 |
| 2024-07-01 17:00:00 | IWM | ETF | 201.25 | 201.29 | 201.19 | 201.29 | 4289.0 |
| 2024-07-01 18:00:00 | IWM | ETF | 201.23 | 201.3 | 201.11 | 201.11 | 10412.0 |
| 2024-07-01 19:00:00 | IWM | ETF | 201.11 | 201.19 | 201.04 | 201.1305 | 31927.0 |
| 2024-07-01 04:00:00 | DIA | ETF | 391.33 | 391.87 | 391.33 | 391.75 | 1012.0 |
| 2024-07-01 05:00:00 | DIA | ETF | 391.6 | 391.6 | 391.6 | 391.6 | 100.0 |
> showing 50 of 20,844 rows — these rows as CSV