PREVIEW / etf_1hour / 2025-01-14
file: by_date/etf_1hour/2025/2025-01-14.parquet size: 614 KB rows: 23,323
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-01-14 04:00:00 | SPY | ETF | 583.98 | 585.0 | 583.98 | 584.61 | 17503.0 |
| 2025-01-14 05:00:00 | SPY | ETF | 584.31 | 584.71 | 584.07 | 584.53 | 9261.0 |
| 2025-01-14 06:00:00 | SPY | ETF | 584.25 | 584.27 | 583.48 | 583.68 | 61331.0 |
| 2025-01-14 07:00:00 | SPY | ETF | 583.63 | 583.81 | 582.23 | 582.95 | 214352.0 |
| 2025-01-14 08:00:00 | SPY | ETF | 583.55 | 585.99 | 581.5 | 583.74 | 1124986.0 |
| 2025-01-14 09:00:00 | SPY | ETF | 583.74 | 585.0 | 581.97 | 582.3 | 4392001.0 |
| 2025-01-14 10:00:00 | SPY | ETF | 582.3 | 584.64 | 581.79 | 581.79 | 4215090.0 |
| 2025-01-14 11:00:00 | SPY | ETF | 581.81 | 581.9599 | 578.77 | 578.77 | 3659756.0 |
| 2025-01-14 12:00:00 | SPY | ETF | 578.75 | 580.56 | 578.35 | 580.22 | 2695357.0 |
| 2025-01-14 13:00:00 | SPY | ETF | 580.21 | 583.755 | 580.1 | 583.49 | 3057908.0 |
| 2025-01-14 14:00:00 | SPY | ETF | 583.47 | 583.81 | 580.39 | 580.56 | 3417855.0 |
| 2025-01-14 15:00:00 | SPY | ETF | 580.55 | 582.29 | 578.9 | 582.19 | 8431909.0 |
| 2025-01-14 16:00:00 | SPY | ETF | 582.17 | 584.0 | 581.93 | 583.07 | 2807567.0 |
| 2025-01-14 17:00:00 | SPY | ETF | 583.04 | 583.05 | 582.77 | 582.95 | 130819.0 |
| 2025-01-14 18:00:00 | SPY | ETF | 582.95 | 582.96 | 582.44 | 582.5699 | 63625.0 |
| 2025-01-14 19:00:00 | SPY | ETF | 582.56 | 582.69 | 582.41 | 582.65 | 53650.0 |
| 2025-01-14 04:00:00 | QQQ | ETF | 509.22 | 510.07 | 509.03 | 509.35 | 55067.0 |
| 2025-01-14 05:00:00 | QQQ | ETF | 509.3 | 509.55 | 508.8 | 509.23 | 19061.0 |
| 2025-01-14 06:00:00 | QQQ | ETF | 509.11 | 509.17 | 507.84 | 508.03 | 66191.0 |
| 2025-01-14 07:00:00 | QQQ | ETF | 508.03 | 508.38 | 506.37 | 507.08 | 198819.0 |
| 2025-01-14 08:00:00 | QQQ | ETF | 508.03 | 510.36 | 505.66 | 508.5 | 951170.0 |
| 2025-01-14 09:00:00 | QQQ | ETF | 508.43 | 510.155 | 506.25 | 506.58 | 3247618.0 |
| 2025-01-14 10:00:00 | QQQ | ETF | 506.58 | 509.65 | 505.456 | 505.47 | 3313341.0 |
| 2025-01-14 11:00:00 | QQQ | ETF | 505.49 | 505.96 | 502.7 | 502.79 | 2662572.0 |
| 2025-01-14 12:00:00 | QQQ | ETF | 502.75 | 504.24 | 502.03 | 503.75 | 2234094.0 |
| 2025-01-14 13:00:00 | QQQ | ETF | 503.74 | 507.19 | 503.575 | 506.9304 | 2128949.0 |
| 2025-01-14 14:00:00 | QQQ | ETF | 506.92 | 507.28 | 503.5201 | 503.6465 | 2004842.0 |
| 2025-01-14 15:00:00 | QQQ | ETF | 503.66 | 505.16 | 501.59 | 505.1 | 5524976.0 |
| 2025-01-14 16:00:00 | QQQ | ETF | 505.09 | 506.8 | 505.0 | 506.39 | 1412190.0 |
| 2025-01-14 17:00:00 | QQQ | ETF | 506.4 | 506.43 | 505.85 | 506.1 | 55997.0 |
| 2025-01-14 18:00:00 | QQQ | ETF | 506.15 | 506.27 | 505.5 | 505.7 | 65221.0 |
| 2025-01-14 19:00:00 | QQQ | ETF | 505.69 | 505.96 | 505.5 | 505.9 | 30520.0 |
| 2025-01-14 04:00:00 | IWM | ETF | 218.91 | 218.99 | 218.63 | 218.74 | 39562.0 |
| 2025-01-14 05:00:00 | IWM | ETF | 218.71 | 218.93 | 218.63 | 218.69 | 25184.0 |
| 2025-01-14 06:00:00 | IWM | ETF | 218.64 | 218.87 | 218.35 | 218.68 | 49812.0 |
| 2025-01-14 07:00:00 | IWM | ETF | 218.52 | 218.59 | 218.01 | 218.25 | 69939.0 |
| 2025-01-14 08:00:00 | IWM | ETF | 218.39 | 220.81 | 217.69 | 218.93 | 799214.0 |
| 2025-01-14 09:00:00 | IWM | ETF | 219.01 | 220.1 | 218.54 | 218.7501 | 3612855.0 |
| 2025-01-14 10:00:00 | IWM | ETF | 218.77 | 220.205 | 218.56 | 219.61 | 2009840.0 |
| 2025-01-14 11:00:00 | IWM | ETF | 219.62 | 219.66 | 217.5 | 217.5 | 1556528.0 |
| 2025-01-14 12:00:00 | IWM | ETF | 217.49 | 218.365 | 217.22 | 218.28 | 1388595.0 |
| 2025-01-14 13:00:00 | IWM | ETF | 218.28 | 220.225 | 218.23 | 220.0599 | 1487074.0 |
| 2025-01-14 14:00:00 | IWM | ETF | 220.03 | 220.05 | 218.78 | 218.9144 | 1210488.0 |
| 2025-01-14 15:00:00 | IWM | ETF | 218.89 | 219.9 | 218.3 | 219.76 | 3420825.0 |
| 2025-01-14 16:00:00 | IWM | ETF | 219.72 | 220.42 | 219.2607 | 220.29 | 1426049.0 |
| 2025-01-14 17:00:00 | IWM | ETF | 220.25 | 220.39 | 220.04 | 220.25 | 30935.0 |
| 2025-01-14 18:00:00 | IWM | ETF | 220.2 | 220.3 | 220.1 | 220.3 | 118229.0 |
| 2025-01-14 19:00:00 | IWM | ETF | 220.3 | 220.34 | 220.15 | 220.34 | 37151.0 |
| 2025-01-14 04:00:00 | DIA | ETF | 424.64 | 424.64 | 424.41 | 424.41 | 308.0 |
| 2025-01-14 05:00:00 | DIA | ETF | 424.38 | 424.38 | 424.38 | 424.38 | 1289.0 |
> showing 50 of 23,323 rows — these rows as CSV