PREVIEW / etf_1hour / 2024-07-10
file: by_date/etf_1hour/2024/2024-07-10.parquet size: 551 KB rows: 20,485
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-07-10 04:00:00 | SPY | ETF | 556.27 | 556.51 | 556.25 | 556.5 | 9420.0 |
| 2024-07-10 05:00:00 | SPY | ETF | 556.54 | 556.72 | 556.5 | 556.72 | 9408.0 |
| 2024-07-10 06:00:00 | SPY | ETF | 556.71 | 556.77 | 556.6 | 556.7 | 3710.0 |
| 2024-07-10 07:00:00 | SPY | ETF | 556.67 | 557.18 | 556.56 | 557.07 | 96723.0 |
| 2024-07-10 08:00:00 | SPY | ETF | 556.6604 | 557.38 | 555.95 | 557.13 | 165682.0 |
| 2024-07-10 09:00:00 | SPY | ETF | 557.11 | 557.37 | 556.79 | 557.28 | 2779548.0 |
| 2024-07-10 10:00:00 | SPY | ETF | 557.27 | 557.75 | 556.92 | 557.0203 | 2419662.0 |
| 2024-07-10 11:00:00 | SPY | ETF | 557.02 | 558.03 | 556.77 | 557.89 | 2086410.0 |
| 2024-07-10 12:00:00 | SPY | ETF | 557.895 | 559.36 | 557.865 | 559.335 | 3209243.0 |
| 2024-07-10 13:00:00 | SPY | ETF | 559.33 | 559.8499 | 559.125 | 559.8 | 2163325.0 |
| 2024-07-10 14:00:00 | SPY | ETF | 559.81 | 560.22 | 559.4251 | 560.09 | 2552297.0 |
| 2024-07-10 15:00:00 | SPY | ETF | 560.08 | 561.67 | 559.75 | 561.26 | 8739955.0 |
| 2024-07-10 16:00:00 | SPY | ETF | 561.26 | 561.45 | 560.96 | 561.04 | 2885135.0 |
| 2024-07-10 17:00:00 | SPY | ETF | 561.0 | 561.16 | 560.95 | 561.06 | 93087.0 |
| 2024-07-10 18:00:00 | SPY | ETF | 561.04 | 561.26 | 560.96 | 561.13 | 70427.0 |
| 2024-07-10 19:00:00 | SPY | ETF | 561.13 | 561.13 | 560.961 | 561.05 | 21586.0 |
| 2024-07-10 04:00:00 | QQQ | ETF | 498.62 | 499.12 | 498.62 | 499.12 | 32589.0 |
| 2024-07-10 05:00:00 | QQQ | ETF | 499.11 | 499.11 | 498.91 | 499.05 | 28643.0 |
| 2024-07-10 06:00:00 | QQQ | ETF | 499.06 | 499.33 | 499.04 | 499.19 | 20135.0 |
| 2024-07-10 07:00:00 | QQQ | ETF | 499.2 | 499.75 | 499.09 | 499.53 | 46660.0 |
| 2024-07-10 08:00:00 | QQQ | ETF | 499.17 | 499.96 | 498.47 | 499.66 | 170821.0 |
| 2024-07-10 09:00:00 | QQQ | ETF | 499.67 | 500.19 | 498.83 | 499.85 | 2372659.0 |
| 2024-07-10 10:00:00 | QQQ | ETF | 499.875 | 500.604 | 498.9037 | 499.0375 | 2834197.0 |
| 2024-07-10 11:00:00 | QQQ | ETF | 499.01 | 499.97 | 498.39 | 499.93 | 2064932.0 |
| 2024-07-10 12:00:00 | QQQ | ETF | 499.91 | 501.895 | 499.77 | 501.85 | 2712704.0 |
| 2024-07-10 13:00:00 | QQQ | ETF | 501.83 | 502.64 | 501.67 | 502.48 | 2168953.0 |
| 2024-07-10 14:00:00 | QQQ | ETF | 502.48 | 502.97 | 502.17 | 502.64 | 1637509.0 |
| 2024-07-10 15:00:00 | QQQ | ETF | 502.63 | 503.52 | 501.9999 | 502.96 | 4265517.0 |
| 2024-07-10 16:00:00 | QQQ | ETF | 502.96 | 503.01 | 502.5 | 503.01 | 1610547.0 |
| 2024-07-10 17:00:00 | QQQ | ETF | 503.01 | 503.01 | 502.82 | 502.95 | 156267.0 |
| 2024-07-10 18:00:00 | QQQ | ETF | 503.0 | 503.05 | 502.69 | 502.91 | 111880.0 |
| 2024-07-10 19:00:00 | QQQ | ETF | 502.84 | 502.85 | 502.61 | 502.69 | 42000.0 |
| 2024-07-10 04:00:00 | IWM | ETF | 201.59 | 201.76 | 201.58 | 201.64 | 2936.0 |
| 2024-07-10 05:00:00 | IWM | ETF | 201.8 | 202.0 | 201.69 | 201.98 | 7481.0 |
| 2024-07-10 06:00:00 | IWM | ETF | 201.92 | 202.11 | 201.92 | 202.05 | 30528.0 |
| 2024-07-10 07:00:00 | IWM | ETF | 201.99 | 202.28 | 201.9 | 202.2 | 32405.0 |
| 2024-07-10 08:00:00 | IWM | ETF | 202.1012 | 202.56 | 201.65 | 202.35 | 73852.0 |
| 2024-07-10 09:00:00 | IWM | ETF | 202.33 | 202.68 | 201.76 | 201.82 | 1638348.0 |
| 2024-07-10 10:00:00 | IWM | ETF | 201.82 | 202.385 | 201.49 | 201.82 | 2024146.0 |
| 2024-07-10 11:00:00 | IWM | ETF | 201.82 | 202.505 | 201.6 | 202.32 | 1620871.0 |
| 2024-07-10 12:00:00 | IWM | ETF | 202.33 | 202.8151 | 202.31 | 202.625 | 1680900.0 |
| 2024-07-10 13:00:00 | IWM | ETF | 202.61 | 202.86 | 202.27 | 202.605 | 1313329.0 |
| 2024-07-10 14:00:00 | IWM | ETF | 202.61 | 202.81 | 202.42 | 202.75 | 1495071.0 |
| 2024-07-10 15:00:00 | IWM | ETF | 202.74 | 203.59 | 202.5679 | 203.39 | 4380626.0 |
| 2024-07-10 16:00:00 | IWM | ETF | 203.37 | 203.6 | 203.28 | 203.33 | 751453.0 |
| 2024-07-10 17:00:00 | IWM | ETF | 203.33 | 203.45 | 203.32 | 203.38 | 40976.0 |
| 2024-07-10 18:00:00 | IWM | ETF | 203.37 | 203.4575 | 203.32 | 203.34 | 53798.0 |
| 2024-07-10 19:00:00 | IWM | ETF | 203.35 | 203.39 | 203.32 | 203.38 | 18052.0 |
| 2024-07-10 04:00:00 | DIA | ETF | 392.84 | 392.87 | 392.81 | 392.84 | 1000.0 |
| 2024-07-10 05:00:00 | DIA | ETF | 393.18 | 393.18 | 393.18 | 393.18 | 111.0 |
> showing 50 of 20,485 rows — these rows as CSV