PREVIEW / etf_1hour / 2024-08-16
file: by_date/etf_1hour/2024/2024-08-16.parquet size: 547 KB rows: 20,376
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-08-16 04:00:00 | SPY | ETF | 553.87 | 554.23 | 553.54 | 553.83 | 12947.0 |
| 2024-08-16 05:00:00 | SPY | ETF | 553.84 | 554.06 | 553.52 | 553.52 | 5535.0 |
| 2024-08-16 06:00:00 | SPY | ETF | 553.5 | 553.5 | 552.4 | 552.89 | 105940.0 |
| 2024-08-16 07:00:00 | SPY | ETF | 552.92 | 552.95 | 552.22 | 552.22 | 193053.0 |
| 2024-08-16 08:00:00 | SPY | ETF | 552.8 | 554.59 | 550.13 | 550.77 | 607120.0 |
| 2024-08-16 09:00:00 | SPY | ETF | 550.74 | 552.63 | 550.65 | 552.27 | 3439479.0 |
| 2024-08-16 10:00:00 | SPY | ETF | 552.21 | 553.62 | 551.645 | 552.18 | 3390418.0 |
| 2024-08-16 11:00:00 | SPY | ETF | 552.16 | 553.52 | 551.98 | 553.35 | 2320978.0 |
| 2024-08-16 12:00:00 | SPY | ETF | 553.34 | 555.02 | 553.06 | 554.81 | 2235683.0 |
| 2024-08-16 13:00:00 | SPY | ETF | 554.82 | 554.91 | 553.96 | 554.55 | 2028469.0 |
| 2024-08-16 14:00:00 | SPY | ETF | 554.56 | 554.73 | 553.81 | 554.585 | 2094440.0 |
| 2024-08-16 15:00:00 | SPY | ETF | 554.57 | 554.71 | 553.55 | 554.21 | 6536557.0 |
| 2024-08-16 16:00:00 | SPY | ETF | 554.23 | 554.65 | 554.11 | 554.5 | 2494133.0 |
| 2024-08-16 17:00:00 | SPY | ETF | 554.47 | 554.77 | 554.31 | 554.35 | 233683.0 |
| 2024-08-16 18:00:00 | SPY | ETF | 554.57 | 554.57 | 553.95 | 554.0 | 62647.0 |
| 2024-08-16 19:00:00 | SPY | ETF | 554.0 | 554.04 | 553.87 | 553.9 | 32496.0 |
| 2024-08-16 04:00:00 | QQQ | ETF | 475.45 | 476.2 | 475.09 | 475.57 | 78062.0 |
| 2024-08-16 05:00:00 | QQQ | ETF | 475.51 | 475.95 | 475.3 | 475.42 | 32627.0 |
| 2024-08-16 06:00:00 | QQQ | ETF | 475.34 | 475.35 | 474.36 | 474.79 | 51995.0 |
| 2024-08-16 07:00:00 | QQQ | ETF | 474.89 | 474.98 | 473.75 | 473.796 | 202025.0 |
| 2024-08-16 08:00:00 | QQQ | ETF | 474.63 | 476.75 | 471.35 | 472.05 | 820763.0 |
| 2024-08-16 09:00:00 | QQQ | ETF | 472.05 | 473.4 | 471.65 | 472.49 | 3722095.0 |
| 2024-08-16 10:00:00 | QQQ | ETF | 472.38 | 474.8 | 472.33 | 473.05 | 3754261.0 |
| 2024-08-16 11:00:00 | QQQ | ETF | 473.04 | 474.59 | 472.48 | 474.39 | 2145454.0 |
| 2024-08-16 12:00:00 | QQQ | ETF | 474.4 | 476.41 | 474.1 | 476.19 | 1805662.0 |
| 2024-08-16 13:00:00 | QQQ | ETF | 476.265 | 476.2701 | 475.04 | 475.63 | 1570776.0 |
| 2024-08-16 14:00:00 | QQQ | ETF | 475.64 | 475.65 | 474.7399 | 475.48 | 1425681.0 |
| 2024-08-16 15:00:00 | QQQ | ETF | 475.5 | 475.54 | 474.27 | 475.02 | 3223606.0 |
| 2024-08-16 16:00:00 | QQQ | ETF | 475.03 | 475.46 | 474.94 | 475.1 | 4115858.0 |
| 2024-08-16 17:00:00 | QQQ | ETF | 475.1 | 475.149 | 475.0 | 475.14 | 24351.0 |
| 2024-08-16 18:00:00 | QQQ | ETF | 475.0832 | 475.1001 | 474.55 | 474.6 | 35484.0 |
| 2024-08-16 19:00:00 | QQQ | ETF | 474.6 | 474.6 | 474.24 | 474.28 | 38058.0 |
| 2024-08-16 04:00:00 | IWM | ETF | 212.83 | 213.04 | 212.66 | 213.04 | 13760.0 |
| 2024-08-16 05:00:00 | IWM | ETF | 212.92 | 213.14 | 212.71 | 213.09 | 4350.0 |
| 2024-08-16 06:00:00 | IWM | ETF | 213.0 | 213.02 | 212.59 | 212.74 | 14631.0 |
| 2024-08-16 07:00:00 | IWM | ETF | 212.8 | 212.87 | 211.74 | 212.14 | 74100.0 |
| 2024-08-16 08:00:00 | IWM | ETF | 212.79 | 213.16 | 210.85 | 211.27 | 245579.0 |
| 2024-08-16 09:00:00 | IWM | ETF | 211.2 | 213.69 | 210.94 | 213.35 | 2909242.0 |
| 2024-08-16 10:00:00 | IWM | ETF | 213.34 | 213.98 | 211.45 | 211.6552 | 3826880.0 |
| 2024-08-16 11:00:00 | IWM | ETF | 211.65 | 212.23 | 211.28 | 212.08 | 1850620.0 |
| 2024-08-16 12:00:00 | IWM | ETF | 212.07 | 213.04 | 212.02 | 212.87 | 1285232.0 |
| 2024-08-16 13:00:00 | IWM | ETF | 212.87 | 212.92 | 212.41 | 212.77 | 1315270.0 |
| 2024-08-16 14:00:00 | IWM | ETF | 212.77 | 213.01 | 212.19 | 212.96 | 1586903.0 |
| 2024-08-16 15:00:00 | IWM | ETF | 212.95 | 213.04 | 212.31 | 212.6 | 4423425.0 |
| 2024-08-16 16:00:00 | IWM | ETF | 212.6 | 212.86 | 212.56 | 212.73 | 1262647.0 |
| 2024-08-16 17:00:00 | IWM | ETF | 212.75 | 212.81 | 212.7 | 212.71 | 6629.0 |
| 2024-08-16 18:00:00 | IWM | ETF | 212.75 | 212.75 | 212.42 | 212.5 | 4744.0 |
| 2024-08-16 19:00:00 | IWM | ETF | 212.53 | 212.59 | 212.5 | 212.5 | 5976.0 |
| 2024-08-16 04:00:00 | DIA | ETF | 406.0 | 406.31 | 406.0 | 406.24 | 1493.0 |
| 2024-08-16 06:00:00 | DIA | ETF | 405.98 | 405.98 | 405.53 | 405.68 | 1027.0 |
> showing 50 of 20,376 rows — these rows as CSV