PREVIEW / etf_1hour / 2024-01-09
file: by_date/etf_1hour/2024/2024-01-09.parquet size: 522 KB rows: 19,141
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-01-09 04:00:00 | SPY | ETF | 473.88 | 473.91 | 472.89 | 473.35 | 17546.0 |
| 2024-01-09 05:00:00 | SPY | ETF | 473.26 | 473.39 | 473.04 | 473.14 | 19138.0 |
| 2024-01-09 06:00:00 | SPY | ETF | 473.22 | 473.26 | 472.31 | 472.42 | 47827.0 |
| 2024-01-09 07:00:00 | SPY | ETF | 472.44 | 473.06 | 472.24 | 472.98 | 282944.0 |
| 2024-01-09 08:00:00 | SPY | ETF | 472.54 | 474.21 | 471.93 | 471.99 | 528500.0 |
| 2024-01-09 09:00:00 | SPY | ETF | 471.98 | 472.2 | 471.35 | 472.1625 | 5490879.0 |
| 2024-01-09 10:00:00 | SPY | ETF | 472.16 | 472.9501 | 471.57 | 472.23 | 7073695.0 |
| 2024-01-09 11:00:00 | SPY | ETF | 472.22 | 474.23 | 472.21 | 474.22 | 5307880.0 |
| 2024-01-09 12:00:00 | SPY | ETF | 474.225 | 474.47 | 473.83 | 474.34 | 3700476.0 |
| 2024-01-09 13:00:00 | SPY | ETF | 474.35 | 474.93 | 473.15 | 474.28 | 5803981.0 |
| 2024-01-09 14:00:00 | SPY | ETF | 474.295 | 474.545 | 473.35 | 473.79 | 4941836.0 |
| 2024-01-09 15:00:00 | SPY | ETF | 473.79 | 474.25 | 472.93 | 473.84 | 12592564.0 |
| 2024-01-09 16:00:00 | SPY | ETF | 473.84 | 474.0384 | 471.5521 | 473.67 | 2581026.0 |
| 2024-01-09 17:00:00 | SPY | ETF | 473.66 | 473.7 | 473.53 | 473.67 | 35484.0 |
| 2024-01-09 18:00:00 | SPY | ETF | 473.6 | 473.77 | 473.36 | 473.76 | 44805.0 |
| 2024-01-09 19:00:00 | SPY | ETF | 473.79 | 474.01 | 473.77 | 473.79 | 42806.0 |
| 2024-01-09 04:00:00 | QQQ | ETF | 403.97 | 403.97 | 403.1 | 403.6 | 83221.0 |
| 2024-01-09 05:00:00 | QQQ | ETF | 403.52 | 403.63 | 403.2 | 403.34 | 34178.0 |
| 2024-01-09 06:00:00 | QQQ | ETF | 403.38 | 403.41 | 402.31 | 402.46 | 112200.0 |
| 2024-01-09 07:00:00 | QQQ | ETF | 402.49 | 403.22 | 402.35 | 403.2 | 270223.0 |
| 2024-01-09 08:00:00 | QQQ | ETF | 402.87 | 405.253 | 401.63 | 401.8 | 580796.0 |
| 2024-01-09 09:00:00 | QQQ | ETF | 401.82 | 403.0 | 401.71 | 402.78 | 6776145.0 |
| 2024-01-09 10:00:00 | QQQ | ETF | 402.78 | 403.88 | 402.24 | 403.46 | 5291420.0 |
| 2024-01-09 11:00:00 | QQQ | ETF | 403.455 | 405.83 | 403.43 | 405.829 | 3937406.0 |
| 2024-01-09 12:00:00 | QQQ | ETF | 405.82 | 406.18 | 405.39 | 406.1313 | 2521112.0 |
| 2024-01-09 13:00:00 | QQQ | ETF | 406.1399 | 406.69 | 405.01 | 406.01 | 3239618.0 |
| 2024-01-09 14:00:00 | QQQ | ETF | 406.03 | 406.39 | 405.1816 | 405.69 | 2241464.0 |
| 2024-01-09 15:00:00 | QQQ | ETF | 405.71 | 406.05 | 404.53 | 405.79 | 5558288.0 |
| 2024-01-09 16:00:00 | QQQ | ETF | 405.79 | 405.93 | 405.66 | 405.74 | 871621.0 |
| 2024-01-09 17:00:00 | QQQ | ETF | 405.79 | 405.79 | 405.5 | 405.64 | 51372.0 |
| 2024-01-09 18:00:00 | QQQ | ETF | 405.62 | 405.94 | 405.45 | 405.94 | 54412.0 |
| 2024-01-09 19:00:00 | QQQ | ETF | 405.93 | 406.22 | 405.84 | 405.9001 | 69654.0 |
| 2024-01-09 04:00:00 | IWM | ETF | 196.49 | 196.49 | 195.02 | 195.18 | 29902.0 |
| 2024-01-09 05:00:00 | IWM | ETF | 195.11 | 195.32 | 194.86 | 194.86 | 12169.0 |
| 2024-01-09 06:00:00 | IWM | ETF | 194.94 | 194.94 | 194.44 | 194.45 | 34848.0 |
| 2024-01-09 07:00:00 | IWM | ETF | 194.44 | 195.06 | 194.3 | 194.9 | 130717.0 |
| 2024-01-09 08:00:00 | IWM | ETF | 194.45 | 196.41 | 194.35 | 194.46 | 235885.0 |
| 2024-01-09 09:00:00 | IWM | ETF | 194.49 | 194.61 | 193.32 | 194.16 | 5204018.0 |
| 2024-01-09 10:00:00 | IWM | ETF | 194.165 | 194.75 | 193.73 | 194.2599 | 3413683.0 |
| 2024-01-09 11:00:00 | IWM | ETF | 194.25 | 195.285 | 194.23 | 195.275 | 2016162.0 |
| 2024-01-09 12:00:00 | IWM | ETF | 195.28 | 195.45 | 195.07 | 195.44 | 1541128.0 |
| 2024-01-09 13:00:00 | IWM | ETF | 195.44 | 195.769 | 194.55 | 195.5 | 2835820.0 |
| 2024-01-09 14:00:00 | IWM | ETF | 195.5 | 195.57 | 194.865 | 195.24 | 1464329.0 |
| 2024-01-09 15:00:00 | IWM | ETF | 195.25 | 195.5 | 194.69 | 194.97 | 4869230.0 |
| 2024-01-09 16:00:00 | IWM | ETF | 194.98 | 195.01 | 194.65 | 194.76 | 647666.0 |
| 2024-01-09 17:00:00 | IWM | ETF | 194.73 | 194.82 | 194.73 | 194.79 | 3753.0 |
| 2024-01-09 18:00:00 | IWM | ETF | 194.74 | 194.9 | 194.7 | 194.9 | 32244.0 |
| 2024-01-09 19:00:00 | IWM | ETF | 194.95 | 195.06 | 194.73 | 194.8 | 30464.0 |
| 2024-01-09 04:00:00 | DIA | ETF | 375.76 | 375.76 | 375.44 | 375.44 | 400.0 |
| 2024-01-09 05:00:00 | DIA | ETF | 375.82 | 375.82 | 375.66 | 375.66 | 200.0 |
> showing 50 of 19,141 rows — these rows as CSV