PREVIEW / etf_1hour / 2024-10-11
file: by_date/etf_1hour/2024/2024-10-11.parquet size: 557 KB rows: 20,554
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-11 04:00:00 | SPY | ETF | 575.68 | 576.1 | 575.27 | 575.28 | 14924.0 |
| 2024-10-11 05:00:00 | SPY | ETF | 575.37 | 575.74 | 575.28 | 575.3 | 21995.0 |
| 2024-10-11 06:00:00 | SPY | ETF | 575.35 | 576.28 | 575.35 | 576.25 | 18416.0 |
| 2024-10-11 07:00:00 | SPY | ETF | 576.18 | 576.33 | 575.86 | 575.88 | 49621.0 |
| 2024-10-11 08:00:00 | SPY | ETF | 576.0 | 577.0 | 575.38 | 576.19 | 306215.0 |
| 2024-10-11 09:00:00 | SPY | ETF | 576.3 | 577.52 | 575.91 | 577.39 | 2695182.0 |
| 2024-10-11 10:00:00 | SPY | ETF | 577.39 | 580.095 | 577.01 | 579.08 | 5601727.0 |
| 2024-10-11 11:00:00 | SPY | ETF | 579.07 | 579.77 | 579.0 | 579.64 | 2109451.0 |
| 2024-10-11 12:00:00 | SPY | ETF | 579.64 | 579.64 | 578.07 | 578.86 | 2758566.0 |
| 2024-10-11 13:00:00 | SPY | ETF | 578.87 | 579.37 | 578.385 | 579.14 | 1640971.0 |
| 2024-10-11 14:00:00 | SPY | ETF | 579.13 | 579.9 | 578.79 | 579.7 | 2323208.0 |
| 2024-10-11 15:00:00 | SPY | ETF | 579.705 | 580.33 | 579.46 | 579.55 | 6390681.0 |
| 2024-10-11 16:00:00 | SPY | ETF | 579.53 | 579.69 | 578.8715 | 578.99 | 4502633.0 |
| 2024-10-11 17:00:00 | SPY | ETF | 579.0 | 579.24 | 578.24 | 578.32 | 163725.0 |
| 2024-10-11 18:00:00 | SPY | ETF | 578.31 | 578.52 | 578.08 | 578.52 | 49655.0 |
| 2024-10-11 19:00:00 | SPY | ETF | 578.51 | 578.68 | 578.4 | 578.61 | 15436.0 |
| 2024-10-11 04:00:00 | QQQ | ETF | 492.43 | 492.48 | 491.17 | 491.17 | 44157.0 |
| 2024-10-11 05:00:00 | QQQ | ETF | 491.23 | 491.77 | 491.21 | 491.45 | 38400.0 |
| 2024-10-11 06:00:00 | QQQ | ETF | 491.45 | 491.84 | 491.22 | 491.73 | 39497.0 |
| 2024-10-11 07:00:00 | QQQ | ETF | 491.77 | 491.9 | 491.36 | 491.42 | 81627.0 |
| 2024-10-11 08:00:00 | QQQ | ETF | 491.5085 | 493.47 | 491.15 | 491.4101 | 290731.0 |
| 2024-10-11 09:00:00 | QQQ | ETF | 491.58 | 491.68 | 490.17 | 491.19 | 1963542.0 |
| 2024-10-11 10:00:00 | QQQ | ETF | 491.14 | 494.1 | 490.63 | 492.83 | 4144986.0 |
| 2024-10-11 11:00:00 | QQQ | ETF | 492.84 | 493.84 | 492.29 | 493.78 | 1976815.0 |
| 2024-10-11 12:00:00 | QQQ | ETF | 493.78 | 493.83 | 492.27 | 493.125 | 1481039.0 |
| 2024-10-11 13:00:00 | QQQ | ETF | 493.14 | 493.39 | 492.57 | 493.045 | 899631.0 |
| 2024-10-11 14:00:00 | QQQ | ETF | 493.03 | 493.95 | 492.77 | 493.75 | 1121942.0 |
| 2024-10-11 15:00:00 | QQQ | ETF | 493.75 | 494.39 | 493.27 | 493.34 | 2323846.0 |
| 2024-10-11 16:00:00 | QQQ | ETF | 493.32 | 493.5937 | 492.34 | 492.5 | 1105786.0 |
| 2024-10-11 17:00:00 | QQQ | ETF | 492.54 | 493.03 | 492.54 | 492.76 | 71031.0 |
| 2024-10-11 18:00:00 | QQQ | ETF | 492.56 | 492.69 | 492.48 | 492.68 | 11305.0 |
| 2024-10-11 19:00:00 | QQQ | ETF | 492.6858 | 492.73 | 492.5 | 492.5 | 7467.0 |
| 2024-10-11 04:00:00 | IWM | ETF | 216.63 | 216.78 | 216.0 | 216.02 | 12975.0 |
| 2024-10-11 05:00:00 | IWM | ETF | 216.13 | 216.41 | 215.98 | 216.03 | 6604.0 |
| 2024-10-11 06:00:00 | IWM | ETF | 216.1 | 216.63 | 215.96 | 216.62 | 20442.0 |
| 2024-10-11 07:00:00 | IWM | ETF | 216.62 | 216.7 | 216.32 | 216.67 | 60715.0 |
| 2024-10-11 08:00:00 | IWM | ETF | 216.5615 | 218.0 | 216.25 | 216.72 | 402151.0 |
| 2024-10-11 09:00:00 | IWM | ETF | 216.78 | 218.93 | 216.55 | 218.725 | 2333292.0 |
| 2024-10-11 10:00:00 | IWM | ETF | 218.73 | 220.3 | 218.43 | 220.08 | 2975839.0 |
| 2024-10-11 11:00:00 | IWM | ETF | 220.09 | 220.77 | 220.005 | 220.7 | 1428426.0 |
| 2024-10-11 12:00:00 | IWM | ETF | 220.7 | 220.7 | 220.2199 | 220.46 | 1348680.0 |
| 2024-10-11 13:00:00 | IWM | ETF | 220.46 | 220.98 | 220.2 | 220.89 | 1120361.0 |
| 2024-10-11 14:00:00 | IWM | ETF | 220.89 | 221.04 | 220.66 | 220.89 | 1072135.0 |
| 2024-10-11 15:00:00 | IWM | ETF | 220.87 | 221.61 | 220.8 | 221.3 | 3110605.0 |
| 2024-10-11 16:00:00 | IWM | ETF | 221.26 | 221.5 | 221.08 | 221.14 | 2183409.0 |
| 2024-10-11 17:00:00 | IWM | ETF | 221.07 | 221.41 | 221.0203 | 221.068 | 78075.0 |
| 2024-10-11 18:00:00 | IWM | ETF | 221.07 | 221.14 | 221.02 | 221.06 | 5069.0 |
| 2024-10-11 19:00:00 | IWM | ETF | 221.18 | 221.18 | 221.06 | 221.08 | 11440.0 |
| 2024-10-11 04:00:00 | DIA | ETF | 424.56 | 424.62 | 424.55 | 424.62 | 1120.0 |
| 2024-10-11 05:00:00 | DIA | ETF | 424.43 | 424.43 | 424.31 | 424.31 | 602.0 |
> showing 50 of 20,554 rows — these rows as CSV