PREVIEW / etf_1hour / 2025-03-18
file: by_date/etf_1hour/2025/2025-03-18.parquet size: 631 KB rows: 24,158
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-03-18 04:00:00 | SPY | ETF | 565.93 | 567.3 | 565.72 | 566.89 | 10699.0 |
| 2025-03-18 05:00:00 | SPY | ETF | 567.13 | 567.27 | 566.18 | 566.18 | 8588.0 |
| 2025-03-18 06:00:00 | SPY | ETF | 566.21 | 566.24 | 564.48 | 565.87 | 32279.0 |
| 2025-03-18 07:00:00 | SPY | ETF | 565.9 | 566.36 | 564.85 | 566.2 | 182969.0 |
| 2025-03-18 08:00:00 | SPY | ETF | 565.98 | 566.8267 | 564.45 | 564.55 | 383767.0 |
| 2025-03-18 09:00:00 | SPY | ETF | 564.5 | 565.0598 | 560.635 | 560.77 | 5411813.0 |
| 2025-03-18 10:00:00 | SPY | ETF | 560.78 | 562.07 | 560.15 | 560.79 | 5255583.0 |
| 2025-03-18 11:00:00 | SPY | ETF | 560.79 | 560.93 | 559.06 | 559.61 | 3737890.0 |
| 2025-03-18 12:00:00 | SPY | ETF | 559.61 | 561.81 | 559.33 | 560.8509 | 3370688.0 |
| 2025-03-18 13:00:00 | SPY | ETF | 560.86 | 561.5587 | 559.22 | 560.82 | 3007356.0 |
| 2025-03-18 14:00:00 | SPY | ETF | 560.82 | 562.215 | 559.73 | 561.3991 | 2617793.0 |
| 2025-03-18 15:00:00 | SPY | ETF | 561.37 | 561.7113 | 559.84 | 561.05 | 6874090.0 |
| 2025-03-18 16:00:00 | SPY | ETF | 561.07 | 561.74 | 560.773 | 560.9 | 12585262.0 |
| 2025-03-18 17:00:00 | SPY | ETF | 560.9 | 561.04 | 560.78 | 561.04 | 75331.0 |
| 2025-03-18 18:00:00 | SPY | ETF | 561.02 | 561.2292 | 560.09 | 561.03 | 137066.0 |
| 2025-03-18 19:00:00 | SPY | ETF | 561.19 | 561.29 | 560.69 | 561.1999 | 51972.0 |
| 2025-03-18 04:00:00 | QQQ | ETF | 481.43 | 482.69 | 481.18 | 482.21 | 51916.0 |
| 2025-03-18 05:00:00 | QQQ | ETF | 482.54 | 482.72 | 481.35 | 481.35 | 47747.0 |
| 2025-03-18 06:00:00 | QQQ | ETF | 481.4 | 481.47 | 480.05 | 481.44 | 62584.0 |
| 2025-03-18 07:00:00 | QQQ | ETF | 481.37 | 482.2 | 480.16 | 481.12 | 143638.0 |
| 2025-03-18 08:00:00 | QQQ | ETF | 481.26 | 482.5104 | 479.53 | 479.6388 | 312987.0 |
| 2025-03-18 09:00:00 | QQQ | ETF | 479.55 | 480.14 | 473.63 | 474.02 | 4661276.0 |
| 2025-03-18 10:00:00 | QQQ | ETF | 474.02 | 475.4891 | 473.17 | 474.19 | 4176474.0 |
| 2025-03-18 11:00:00 | QQQ | ETF | 474.21 | 474.73 | 472.41 | 473.69 | 2483921.0 |
| 2025-03-18 12:00:00 | QQQ | ETF | 473.7 | 475.96 | 473.48 | 475.48 | 2484264.0 |
| 2025-03-18 13:00:00 | QQQ | ETF | 475.44 | 475.85 | 473.57 | 474.94 | 2277477.0 |
| 2025-03-18 14:00:00 | QQQ | ETF | 474.955 | 476.64 | 473.68 | 475.7593 | 2166061.0 |
| 2025-03-18 15:00:00 | QQQ | ETF | 475.74 | 475.92 | 473.71 | 474.73 | 3518617.0 |
| 2025-03-18 16:00:00 | QQQ | ETF | 474.54 | 475.45 | 474.54 | 474.66 | 2151198.0 |
| 2025-03-18 17:00:00 | QQQ | ETF | 474.66 | 474.75 | 474.5 | 474.66 | 29644.0 |
| 2025-03-18 18:00:00 | QQQ | ETF | 474.66 | 475.15 | 473.82 | 474.81 | 84078.0 |
| 2025-03-18 19:00:00 | QQQ | ETF | 474.99 | 475.0 | 474.32 | 474.78 | 87944.0 |
| 2025-03-18 04:00:00 | IWM | ETF | 203.91 | 204.65 | 203.87 | 204.43 | 18290.0 |
| 2025-03-18 05:00:00 | IWM | ETF | 204.49 | 204.66 | 204.39 | 204.39 | 5744.0 |
| 2025-03-18 06:00:00 | IWM | ETF | 204.31 | 204.31 | 203.79 | 204.26 | 19493.0 |
| 2025-03-18 07:00:00 | IWM | ETF | 204.2 | 204.3 | 203.64 | 204.03 | 55823.0 |
| 2025-03-18 08:00:00 | IWM | ETF | 203.94 | 204.2497 | 203.51 | 203.52 | 105186.0 |
| 2025-03-18 09:00:00 | IWM | ETF | 203.5 | 203.92 | 202.48 | 202.86 | 2330695.0 |
| 2025-03-18 10:00:00 | IWM | ETF | 202.79 | 203.73 | 202.62 | 202.92 | 2360862.0 |
| 2025-03-18 11:00:00 | IWM | ETF | 202.92 | 203.27 | 202.345 | 202.575 | 1377714.0 |
| 2025-03-18 12:00:00 | IWM | ETF | 202.575 | 203.53 | 202.48 | 203.12 | 1710145.0 |
| 2025-03-18 13:00:00 | IWM | ETF | 203.1 | 203.68 | 202.6 | 203.27 | 1550127.0 |
| 2025-03-18 14:00:00 | IWM | ETF | 203.28 | 203.61 | 202.74 | 203.23 | 1393642.0 |
| 2025-03-18 15:00:00 | IWM | ETF | 203.21 | 203.67 | 202.9713 | 203.25 | 2592866.0 |
| 2025-03-18 16:00:00 | IWM | ETF | 203.26 | 203.54 | 203.17 | 203.28 | 1288387.0 |
| 2025-03-18 17:00:00 | IWM | ETF | 203.29 | 203.48 | 203.25 | 203.46 | 69932.0 |
| 2025-03-18 18:00:00 | IWM | ETF | 203.46 | 203.47 | 202.97 | 203.43 | 63853.0 |
| 2025-03-18 19:00:00 | IWM | ETF | 203.46 | 203.6 | 203.33 | 203.51 | 14923.0 |
| 2025-03-18 04:00:00 | DIA | ETF | 418.68 | 418.76 | 418.68 | 418.7 | 514.0 |
| 2025-03-18 05:00:00 | DIA | ETF | 419.12 | 419.23 | 418.99 | 418.99 | 2018.0 |
> showing 50 of 24,158 rows — these rows as CSV