PREVIEW / etf_1hour / 2024-10-17
file: by_date/etf_1hour/2024/2024-10-17.parquet size: 571 KB rows: 21,186
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-17 04:00:00 | SPY | ETF | 583.0 | 584.52 | 583.0 | 584.52 | 40098.0 |
| 2024-10-17 05:00:00 | SPY | ETF | 584.5 | 584.9 | 584.33 | 584.79 | 41248.0 |
| 2024-10-17 06:00:00 | SPY | ETF | 584.72 | 585.05 | 584.52 | 584.95 | 54481.0 |
| 2024-10-17 07:00:00 | SPY | ETF | 584.95 | 585.0 | 584.4 | 584.64 | 304041.0 |
| 2024-10-17 08:00:00 | SPY | ETF | 584.84 | 585.5565 | 581.07 | 585.46 | 352821.0 |
| 2024-10-17 09:00:00 | SPY | ETF | 585.51 | 586.3 | 583.2 | 584.06 | 4486946.0 |
| 2024-10-17 10:00:00 | SPY | ETF | 584.1 | 584.4286 | 582.845 | 583.0974 | 3032663.0 |
| 2024-10-17 11:00:00 | SPY | ETF | 583.1 | 584.75 | 582.37 | 584.72 | 2019067.0 |
| 2024-10-17 12:00:00 | SPY | ETF | 584.705 | 585.0 | 583.73 | 584.3703 | 1502433.0 |
| 2024-10-17 13:00:00 | SPY | ETF | 584.39 | 584.72 | 584.08 | 584.35 | 1310448.0 |
| 2024-10-17 14:00:00 | SPY | ETF | 584.37 | 584.42 | 582.42 | 583.32 | 2860963.0 |
| 2024-10-17 15:00:00 | SPY | ETF | 583.32 | 583.4 | 582.16 | 582.28 | 5505775.0 |
| 2024-10-17 16:00:00 | SPY | ETF | 582.28 | 583.4983 | 582.18 | 582.42 | 3043251.0 |
| 2024-10-17 17:00:00 | SPY | ETF | 582.49 | 582.6 | 582.42 | 582.55 | 41912.0 |
| 2024-10-17 18:00:00 | SPY | ETF | 582.43 | 582.99 | 582.35 | 582.85 | 36606.0 |
| 2024-10-17 19:00:00 | SPY | ETF | 582.801 | 582.94 | 582.8 | 582.9 | 23638.0 |
| 2024-10-17 04:00:00 | QQQ | ETF | 492.12 | 494.56 | 492.12 | 494.43 | 69276.0 |
| 2024-10-17 05:00:00 | QQQ | ETF | 494.56 | 494.82 | 493.98 | 494.44 | 49201.0 |
| 2024-10-17 06:00:00 | QQQ | ETF | 494.43 | 495.53 | 494.43 | 495.44 | 80590.0 |
| 2024-10-17 07:00:00 | QQQ | ETF | 495.37 | 495.37 | 494.8 | 495.11 | 264193.0 |
| 2024-10-17 08:00:00 | QQQ | ETF | 495.1 | 496.11 | 489.7 | 496.11 | 551727.0 |
| 2024-10-17 09:00:00 | QQQ | ETF | 496.12 | 496.93 | 492.34 | 493.07 | 4773022.0 |
| 2024-10-17 10:00:00 | QQQ | ETF | 493.13 | 493.83 | 491.5401 | 492.32 | 3359830.0 |
| 2024-10-17 11:00:00 | QQQ | ETF | 492.34 | 494.93 | 491.57 | 494.88 | 2204923.0 |
| 2024-10-17 12:00:00 | QQQ | ETF | 494.87 | 495.35 | 493.45 | 493.89 | 1977715.0 |
| 2024-10-17 13:00:00 | QQQ | ETF | 493.89 | 494.7 | 493.7101 | 494.1699 | 1160860.0 |
| 2024-10-17 14:00:00 | QQQ | ETF | 494.13 | 494.29 | 491.47 | 493.025 | 2443723.0 |
| 2024-10-17 15:00:00 | QQQ | ETF | 493.04 | 493.25 | 491.1901 | 491.35 | 3310248.0 |
| 2024-10-17 16:00:00 | QQQ | ETF | 491.37 | 492.55 | 491.22 | 491.88 | 1240975.0 |
| 2024-10-17 17:00:00 | QQQ | ETF | 491.89 | 492.008 | 491.77 | 491.94 | 29716.0 |
| 2024-10-17 18:00:00 | QQQ | ETF | 491.99 | 492.55 | 491.74 | 492.41 | 68148.0 |
| 2024-10-17 19:00:00 | QQQ | ETF | 492.363 | 492.56 | 492.3 | 492.45 | 21426.0 |
| 2024-10-17 04:00:00 | IWM | ETF | 227.11 | 227.44 | 226.91 | 227.36 | 29793.0 |
| 2024-10-17 05:00:00 | IWM | ETF | 227.41 | 227.41 | 226.94 | 227.02 | 15567.0 |
| 2024-10-17 06:00:00 | IWM | ETF | 227.02 | 227.03 | 226.4 | 226.55 | 36573.0 |
| 2024-10-17 07:00:00 | IWM | ETF | 226.57 | 226.65 | 226.23 | 226.3 | 112216.0 |
| 2024-10-17 08:00:00 | IWM | ETF | 226.51 | 227.52 | 226.13 | 226.97 | 445843.0 |
| 2024-10-17 09:00:00 | IWM | ETF | 227.12 | 227.24 | 225.65 | 226.4 | 2459236.0 |
| 2024-10-17 10:00:00 | IWM | ETF | 226.43 | 226.72 | 224.95 | 225.36 | 2433834.0 |
| 2024-10-17 11:00:00 | IWM | ETF | 225.38 | 225.73 | 224.91 | 225.73 | 1177636.0 |
| 2024-10-17 12:00:00 | IWM | ETF | 225.73 | 226.12 | 225.44 | 226.06 | 993047.0 |
| 2024-10-17 13:00:00 | IWM | ETF | 226.045 | 226.3 | 225.721 | 226.16 | 973481.0 |
| 2024-10-17 14:00:00 | IWM | ETF | 226.165 | 226.245 | 225.52 | 225.86 | 933378.0 |
| 2024-10-17 15:00:00 | IWM | ETF | 225.86 | 226.27 | 225.86 | 226.08 | 2298767.0 |
| 2024-10-17 16:00:00 | IWM | ETF | 226.12 | 226.32 | 225.87 | 225.95 | 896558.0 |
| 2024-10-17 17:00:00 | IWM | ETF | 225.93 | 226.12 | 225.8206 | 225.97 | 45215.0 |
| 2024-10-17 18:00:00 | IWM | ETF | 225.9 | 226.12 | 225.88 | 225.96 | 8250.0 |
| 2024-10-17 19:00:00 | IWM | ETF | 226.04 | 226.05 | 225.8 | 225.91 | 28220.0 |
| 2024-10-17 06:00:00 | DIA | ETF | 430.6 | 431.03 | 430.59 | 431.03 | 2848.0 |
| 2024-10-17 07:00:00 | DIA | ETF | 431.4 | 431.61 | 431.08 | 431.08 | 5092.0 |
> showing 50 of 21,186 rows — these rows as CSV