PREVIEW / etf_1hour / 2024-10-18
file: by_date/etf_1hour/2024/2024-10-18.parquet size: 561 KB rows: 21,091
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-10-18 04:00:00 | SPY | ETF | 583.0 | 583.96 | 583.0 | 583.76 | 14137.0 |
| 2024-10-18 05:00:00 | SPY | ETF | 583.76 | 583.98 | 583.36 | 583.36 | 18094.0 |
| 2024-10-18 06:00:00 | SPY | ETF | 583.32 | 583.67 | 583.24 | 583.65 | 16867.0 |
| 2024-10-18 07:00:00 | SPY | ETF | 583.64 | 584.0 | 583.28 | 583.82 | 310597.0 |
| 2024-10-18 08:00:00 | SPY | ETF | 583.85 | 584.11 | 582.48 | 583.93 | 127025.0 |
| 2024-10-18 09:00:00 | SPY | ETF | 584.0 | 584.5 | 582.58 | 583.28 | 3051937.0 |
| 2024-10-18 10:00:00 | SPY | ETF | 583.27 | 584.03 | 583.06 | 583.43 | 2444689.0 |
| 2024-10-18 11:00:00 | SPY | ETF | 583.4199 | 584.47 | 583.3701 | 583.885 | 1825130.0 |
| 2024-10-18 12:00:00 | SPY | ETF | 583.89 | 585.25 | 583.6901 | 584.675 | 1691279.0 |
| 2024-10-18 13:00:00 | SPY | ETF | 584.69 | 585.1198 | 584.4808 | 584.58 | 1659426.0 |
| 2024-10-18 14:00:00 | SPY | ETF | 584.565 | 585.39 | 583.84 | 584.8515 | 1806068.0 |
| 2024-10-18 15:00:00 | SPY | ETF | 584.85 | 584.85 | 584.06 | 584.57 | 4515230.0 |
| 2024-10-18 16:00:00 | SPY | ETF | 584.53 | 584.9 | 584.36 | 584.71 | 2427521.0 |
| 2024-10-18 17:00:00 | SPY | ETF | 584.65 | 584.75 | 584.5804 | 584.69 | 462856.0 |
| 2024-10-18 18:00:00 | SPY | ETF | 584.7 | 584.75 | 584.7 | 584.7 | 9146.0 |
| 2024-10-18 19:00:00 | SPY | ETF | 584.72 | 584.84 | 584.7 | 584.72 | 16037.0 |
| 2024-10-18 04:00:00 | QQQ | ETF | 493.81 | 494.06 | 493.41 | 493.62 | 51194.0 |
| 2024-10-18 05:00:00 | QQQ | ETF | 493.72 | 494.01 | 493.14 | 493.25 | 39702.0 |
| 2024-10-18 06:00:00 | QQQ | ETF | 493.32 | 493.76 | 493.01 | 493.72 | 79560.0 |
| 2024-10-18 07:00:00 | QQQ | ETF | 493.68 | 494.4 | 493.43 | 494.165 | 104983.0 |
| 2024-10-18 08:00:00 | QQQ | ETF | 494.2 | 494.53 | 490.882 | 494.39 | 140979.0 |
| 2024-10-18 09:00:00 | QQQ | ETF | 494.4 | 495.16 | 493.3 | 494.3293 | 2708644.0 |
| 2024-10-18 10:00:00 | QQQ | ETF | 494.4196 | 495.44 | 493.77 | 493.872 | 2230982.0 |
| 2024-10-18 11:00:00 | QQQ | ETF | 493.88 | 495.57 | 493.85 | 494.1875 | 2109773.0 |
| 2024-10-18 12:00:00 | QQQ | ETF | 494.18 | 495.4 | 493.55 | 494.83 | 1745695.0 |
| 2024-10-18 13:00:00 | QQQ | ETF | 494.82 | 495.445 | 494.42 | 494.57 | 1576437.0 |
| 2024-10-18 14:00:00 | QQQ | ETF | 494.55 | 495.08 | 493.72 | 494.72 | 1335748.0 |
| 2024-10-18 15:00:00 | QQQ | ETF | 494.71 | 494.81 | 493.88 | 494.51 | 3099414.0 |
| 2024-10-18 16:00:00 | QQQ | ETF | 494.5 | 494.98 | 494.31 | 494.52 | 781507.0 |
| 2024-10-18 17:00:00 | QQQ | ETF | 494.5 | 494.75 | 494.5 | 494.62 | 22455.0 |
| 2024-10-18 18:00:00 | QQQ | ETF | 494.5619 | 494.69 | 494.56 | 494.69 | 3962.0 |
| 2024-10-18 19:00:00 | QQQ | ETF | 494.6 | 494.69 | 494.56 | 494.58 | 3989.0 |
| 2024-10-18 04:00:00 | IWM | ETF | 226.14 | 226.6 | 226.09 | 226.56 | 21303.0 |
| 2024-10-18 05:00:00 | IWM | ETF | 226.54 | 227.19 | 226.52 | 226.96 | 23855.0 |
| 2024-10-18 06:00:00 | IWM | ETF | 227.01 | 227.28 | 226.77 | 227.09 | 13371.0 |
| 2024-10-18 07:00:00 | IWM | ETF | 227.15 | 227.18 | 226.83 | 227.0 | 48411.0 |
| 2024-10-18 08:00:00 | IWM | ETF | 226.85 | 227.23 | 225.55 | 227.11 | 192619.0 |
| 2024-10-18 09:00:00 | IWM | ETF | 227.11 | 227.4 | 226.0 | 226.26 | 1991519.0 |
| 2024-10-18 10:00:00 | IWM | ETF | 226.27 | 226.65 | 225.655 | 225.75 | 1490950.0 |
| 2024-10-18 11:00:00 | IWM | ETF | 225.75 | 226.04 | 225.4001 | 225.83 | 884203.0 |
| 2024-10-18 12:00:00 | IWM | ETF | 225.829 | 226.21 | 225.47 | 225.83 | 839013.0 |
| 2024-10-18 13:00:00 | IWM | ETF | 225.83 | 226.11 | 225.67 | 226.01 | 1115103.0 |
| 2024-10-18 14:00:00 | IWM | ETF | 225.99 | 226.3101 | 225.64 | 225.85 | 1180388.0 |
| 2024-10-18 15:00:00 | IWM | ETF | 225.86 | 225.91 | 225.39 | 225.65 | 3758277.0 |
| 2024-10-18 16:00:00 | IWM | ETF | 225.65 | 225.8 | 225.53 | 225.68 | 690860.0 |
| 2024-10-18 17:00:00 | IWM | ETF | 225.65 | 225.65 | 225.55 | 225.65 | 4778.0 |
| 2024-10-18 18:00:00 | IWM | ETF | 225.55 | 225.55 | 225.55 | 225.55 | 700.0 |
| 2024-10-18 19:00:00 | IWM | ETF | 225.61 | 225.65 | 225.56 | 225.59 | 4338.0 |
| 2024-10-18 04:00:00 | DIA | ETF | 430.0 | 432.66 | 430.0 | 432.62 | 2178.0 |
| 2024-10-18 05:00:00 | DIA | ETF | 432.84 | 432.84 | 432.84 | 432.84 | 500.0 |
> showing 50 of 21,091 rows — these rows as CSV