PREVIEW / etf_1hour / 2024-10-10
file: by_date/etf_1hour/2024/2024-10-10.parquet size: 556 KB rows: 20,793
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-10 04:00:00 | SPY | ETF | 576.37 | 576.6 | 576.1 | 576.33 | 21893.0 |
| 2024-10-10 05:00:00 | SPY | ETF | 576.23 | 576.6 | 576.06 | 576.54 | 12753.0 |
| 2024-10-10 06:00:00 | SPY | ETF | 576.6 | 576.65 | 576.21 | 576.25 | 10806.0 |
| 2024-10-10 07:00:00 | SPY | ETF | 576.24 | 576.71 | 576.09 | 576.71 | 133545.0 |
| 2024-10-10 08:00:00 | SPY | ETF | 576.52 | 577.48 | 574.6 | 575.29 | 1735484.0 |
| 2024-10-10 09:00:00 | SPY | ETF | 575.25 | 576.3199 | 574.56 | 575.39 | 4183638.0 |
| 2024-10-10 10:00:00 | SPY | ETF | 575.41 | 576.6495 | 575.13 | 575.44 | 2796264.0 |
| 2024-10-10 11:00:00 | SPY | ETF | 575.44 | 577.0 | 575.14 | 576.96 | 2085773.0 |
| 2024-10-10 12:00:00 | SPY | ETF | 576.952 | 577.58 | 575.79 | 576.22 | 3605017.0 |
| 2024-10-10 13:00:00 | SPY | ETF | 576.2105 | 576.675 | 574.77 | 576.22 | 2920957.0 |
| 2024-10-10 14:00:00 | SPY | ETF | 576.23 | 576.23 | 574.49 | 575.3 | 2996942.0 |
| 2024-10-10 15:00:00 | SPY | ETF | 575.3 | 576.54 | 574.84 | 576.1 | 5188746.0 |
| 2024-10-10 16:00:00 | SPY | ETF | 576.1 | 576.48 | 575.89 | 576.31 | 2959056.0 |
| 2024-10-10 17:00:00 | SPY | ETF | 576.35 | 576.42 | 576.13 | 576.13 | 25184.0 |
| 2024-10-10 18:00:00 | SPY | ETF | 576.27 | 576.4 | 576.18 | 576.32 | 24919.0 |
| 2024-10-10 19:00:00 | SPY | ETF | 576.41 | 576.87 | 576.41 | 576.77 | 54797.0 |
| 2024-10-10 04:00:00 | QQQ | ETF | 492.35 | 492.61 | 492.08 | 492.32 | 27325.0 |
| 2024-10-10 05:00:00 | QQQ | ETF | 492.29 | 492.68 | 492.07 | 492.59 | 21317.0 |
| 2024-10-10 06:00:00 | QQQ | ETF | 492.63 | 492.68 | 492.03 | 492.08 | 21873.0 |
| 2024-10-10 07:00:00 | QQQ | ETF | 492.12 | 492.8 | 491.94 | 492.79 | 94423.0 |
| 2024-10-10 08:00:00 | QQQ | ETF | 492.13 | 493.57 | 490.01 | 490.92 | 746833.0 |
| 2024-10-10 09:00:00 | QQQ | ETF | 490.91 | 491.6 | 489.53 | 490.88 | 2587633.0 |
| 2024-10-10 10:00:00 | QQQ | ETF | 490.91 | 492.38 | 490.81 | 491.4701 | 2520168.0 |
| 2024-10-10 11:00:00 | QQQ | ETF | 491.51 | 493.74 | 491.03 | 493.7 | 1731916.0 |
| 2024-10-10 12:00:00 | QQQ | ETF | 493.685 | 494.47 | 492.32 | 492.84 | 2713704.0 |
| 2024-10-10 13:00:00 | QQQ | ETF | 492.85 | 493.64 | 491.39 | 492.9876 | 1765950.0 |
| 2024-10-10 14:00:00 | QQQ | ETF | 492.97 | 492.98 | 491.23 | 492.37 | 1186930.0 |
| 2024-10-10 15:00:00 | QQQ | ETF | 492.32 | 492.98 | 491.65 | 492.6 | 2681638.0 |
| 2024-10-10 16:00:00 | QQQ | ETF | 492.61 | 492.9 | 492.35 | 492.78 | 875308.0 |
| 2024-10-10 17:00:00 | QQQ | ETF | 492.81 | 492.8385 | 492.71 | 492.71 | 13422.0 |
| 2024-10-10 18:00:00 | QQQ | ETF | 492.76 | 492.88 | 492.59 | 492.73 | 25207.0 |
| 2024-10-10 19:00:00 | QQQ | ETF | 492.8 | 493.42 | 492.8 | 493.19 | 43305.0 |
| 2024-10-10 04:00:00 | IWM | ETF | 217.28 | 217.4 | 217.15 | 217.34 | 16712.0 |
| 2024-10-10 05:00:00 | IWM | ETF | 217.28 | 217.6 | 217.21 | 217.6 | 11687.0 |
| 2024-10-10 06:00:00 | IWM | ETF | 217.61 | 217.71 | 217.31 | 217.31 | 9570.0 |
| 2024-10-10 07:00:00 | IWM | ETF | 217.27 | 217.87 | 217.27 | 217.61 | 53142.0 |
| 2024-10-10 08:00:00 | IWM | ETF | 217.29 | 218.61 | 214.76 | 216.43 | 1302333.0 |
| 2024-10-10 09:00:00 | IWM | ETF | 216.4 | 216.5 | 214.6 | 215.66 | 4610837.0 |
| 2024-10-10 10:00:00 | IWM | ETF | 215.68 | 216.56 | 215.55 | 215.74 | 2574267.0 |
| 2024-10-10 11:00:00 | IWM | ETF | 215.74 | 216.5099 | 215.47 | 216.37 | 1393493.0 |
| 2024-10-10 12:00:00 | IWM | ETF | 216.36 | 216.755 | 216.05 | 216.16 | 1718773.0 |
| 2024-10-10 13:00:00 | IWM | ETF | 216.17 | 216.46 | 215.67 | 216.24 | 1507193.0 |
| 2024-10-10 14:00:00 | IWM | ETF | 216.22 | 216.22 | 215.64 | 215.98 | 1044814.0 |
| 2024-10-10 15:00:00 | IWM | ETF | 215.97 | 216.88 | 215.91 | 216.8 | 3432104.0 |
| 2024-10-10 16:00:00 | IWM | ETF | 216.85 | 217.0 | 216.2538 | 216.98 | 1298190.0 |
| 2024-10-10 17:00:00 | IWM | ETF | 216.96 | 216.97 | 216.81 | 216.92 | 3507.0 |
| 2024-10-10 18:00:00 | IWM | ETF | 216.94 | 217.02 | 216.88 | 216.9337 | 18795.0 |
| 2024-10-10 19:00:00 | IWM | ETF | 216.99 | 217.18 | 216.96 | 217.0815 | 8342.0 |
| 2024-10-10 04:00:00 | DIA | ETF | 424.56 | 424.63 | 424.56 | 424.63 | 785.0 |
| 2024-10-10 05:00:00 | DIA | ETF | 424.71 | 424.71 | 424.71 | 424.71 | 100.0 |
> showing 50 of 20,793 rows — these rows as CSV