PREVIEW / etf_1hour / 2025-07-15
file: by_date/etf_1hour/2025/2025-07-15.parquet size: 619 KB rows: 23,253
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 |
|---|---|---|---|---|---|---|---|
| 2025-07-15 04:00:00 | SPY | ETF | 626.65 | 626.97 | 626.4 | 626.62 | 39708.0 |
| 2025-07-15 05:00:00 | SPY | ETF | 626.62 | 627.28 | 626.54 | 627.21 | 51376.0 |
| 2025-07-15 06:00:00 | SPY | ETF | 627.2 | 627.86 | 627.0 | 627.21 | 72658.0 |
| 2025-07-15 07:00:00 | SPY | ETF | 627.2 | 627.9 | 625.91 | 627.11 | 221931.0 |
| 2025-07-15 08:00:00 | SPY | ETF | 627.2 | 627.97 | 625.4 | 627.24 | 874072.0 |
| 2025-07-15 09:00:00 | SPY | ETF | 627.25 | 627.91 | 625.585 | 625.65 | 6102450.0 |
| 2025-07-15 10:00:00 | SPY | ETF | 625.67 | 626.3953 | 623.8 | 623.889 | 8651494.0 |
| 2025-07-15 11:00:00 | SPY | ETF | 623.89 | 625.39 | 623.88 | 624.8348 | 6719699.0 |
| 2025-07-15 12:00:00 | SPY | ETF | 624.85 | 624.99 | 623.01 | 623.22 | 6044830.0 |
| 2025-07-15 13:00:00 | SPY | ETF | 623.22 | 624.62 | 622.95 | 624.5835 | 5668710.0 |
| 2025-07-15 14:00:00 | SPY | ETF | 624.59 | 624.87 | 623.255 | 623.28 | 6216871.0 |
| 2025-07-15 15:00:00 | SPY | ETF | 623.27 | 623.8 | 622.075 | 622.12 | 12850383.0 |
| 2025-07-15 16:00:00 | SPY | ETF | 622.11 | 622.3 | 621.11 | 621.26 | 3572733.0 |
| 2025-07-15 17:00:00 | SPY | ETF | 621.39 | 621.41 | 621.21 | 621.22 | 79594.0 |
| 2025-07-15 18:00:00 | SPY | ETF | 621.23 | 621.55 | 620.33 | 620.88 | 185543.0 |
| 2025-07-15 19:00:00 | SPY | ETF | 620.8607 | 621.18 | 620.4 | 621.04 | 74756.0 |
| 2025-07-15 04:00:00 | QQQ | ETF | 558.62 | 559.75 | 558.12 | 559.21 | 63190.0 |
| 2025-07-15 05:00:00 | QQQ | ETF | 559.2 | 559.81 | 559.12 | 559.58 | 57130.0 |
| 2025-07-15 06:00:00 | QQQ | ETF | 559.68 | 560.0 | 559.41 | 559.59 | 110409.0 |
| 2025-07-15 07:00:00 | QQQ | ETF | 559.56 | 560.05 | 559.2 | 559.48 | 121355.0 |
| 2025-07-15 08:00:00 | QQQ | ETF | 559.87 | 560.44 | 555.793 | 560.15 | 561329.0 |
| 2025-07-15 09:00:00 | QQQ | ETF | 560.19 | 560.8 | 558.4201 | 558.7812 | 4602490.0 |
| 2025-07-15 10:00:00 | QQQ | ETF | 558.8 | 560.2104 | 557.76 | 557.845 | 5711585.0 |
| 2025-07-15 11:00:00 | QQQ | ETF | 557.86 | 559.78 | 557.86 | 559.25 | 3588590.0 |
| 2025-07-15 12:00:00 | QQQ | ETF | 559.25 | 559.48 | 557.46 | 557.84 | 2744980.0 |
| 2025-07-15 13:00:00 | QQQ | ETF | 557.83 | 559.5401 | 557.54 | 559.51 | 2808135.0 |
| 2025-07-15 14:00:00 | QQQ | ETF | 559.53 | 559.75 | 557.72 | 557.73 | 3311321.0 |
| 2025-07-15 15:00:00 | QQQ | ETF | 557.71 | 558.38 | 556.66 | 556.7 | 6039258.0 |
| 2025-07-15 16:00:00 | QQQ | ETF | 556.68 | 556.85 | 555.72 | 555.91 | 1711292.0 |
| 2025-07-15 17:00:00 | QQQ | ETF | 555.89 | 555.95 | 555.74 | 555.85 | 51426.0 |
| 2025-07-15 18:00:00 | QQQ | ETF | 555.99 | 556.2 | 554.85 | 555.68 | 101303.0 |
| 2025-07-15 19:00:00 | QQQ | ETF | 555.609 | 555.8988 | 555.15 | 555.78 | 74444.0 |
| 2025-07-15 04:00:00 | IWM | ETF | 223.41 | 223.6 | 223.22 | 223.35 | 14420.0 |
| 2025-07-15 05:00:00 | IWM | ETF | 223.36 | 223.6 | 223.36 | 223.46 | 10032.0 |
| 2025-07-15 06:00:00 | IWM | ETF | 223.54 | 223.74 | 223.44 | 223.48 | 27277.0 |
| 2025-07-15 07:00:00 | IWM | ETF | 223.52 | 223.8 | 223.27 | 223.4 | 74158.0 |
| 2025-07-15 08:00:00 | IWM | ETF | 223.25 | 224.23 | 222.81 | 223.6 | 550708.0 |
| 2025-07-15 09:00:00 | IWM | ETF | 223.56 | 224.28 | 222.0819 | 222.145 | 4891462.0 |
| 2025-07-15 10:00:00 | IWM | ETF | 222.15 | 222.64 | 220.88 | 221.01 | 5780141.0 |
| 2025-07-15 11:00:00 | IWM | ETF | 221.02 | 221.73 | 220.69 | 220.98 | 3877284.0 |
| 2025-07-15 12:00:00 | IWM | ETF | 220.98 | 221.37 | 219.88 | 219.9 | 3967905.0 |
| 2025-07-15 13:00:00 | IWM | ETF | 219.89 | 220.645 | 219.69 | 220.405 | 3632377.0 |
| 2025-07-15 14:00:00 | IWM | ETF | 220.405 | 220.74 | 219.68 | 219.69 | 3343454.0 |
| 2025-07-15 15:00:00 | IWM | ETF | 219.67 | 220.11 | 218.8 | 218.87 | 7561267.0 |
| 2025-07-15 16:00:00 | IWM | ETF | 218.87 | 218.9301 | 218.28 | 218.39 | 1907039.0 |
| 2025-07-15 17:00:00 | IWM | ETF | 218.43 | 218.67 | 218.33 | 218.5 | 20942.0 |
| 2025-07-15 18:00:00 | IWM | ETF | 218.44 | 218.61 | 218.05 | 218.29 | 40263.0 |
| 2025-07-15 19:00:00 | IWM | ETF | 218.17 | 218.4 | 218.02 | 218.24 | 25962.0 |
| 2025-07-15 04:00:00 | DIA | ETF | 444.6 | 444.6 | 443.99 | 444.07 | 4526.0 |
| 2025-07-15 05:00:00 | DIA | ETF | 444.05 | 444.43 | 444.03 | 444.43 | 3250.0 |
> showing 50 of 23,253 rows — these rows as CSV