PREVIEW / etf_1hour / 2024-10-15
file: by_date/etf_1hour/2024/2024-10-15.parquet size: 571 KB rows: 21,459
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-15 04:00:00 | SPY | ETF | 584.4 | 584.48 | 583.81 | 584.02 | 25091.0 |
| 2024-10-15 05:00:00 | SPY | ETF | 584.09 | 584.15 | 583.8 | 583.9 | 63837.0 |
| 2024-10-15 06:00:00 | SPY | ETF | 583.97 | 584.56 | 583.7 | 584.55 | 25724.0 |
| 2024-10-15 07:00:00 | SPY | ETF | 584.35 | 584.5 | 584.09 | 584.33 | 95497.0 |
| 2024-10-15 08:00:00 | SPY | ETF | 584.51 | 584.93 | 584.14 | 584.54 | 74437.0 |
| 2024-10-15 09:00:00 | SPY | ETF | 584.6 | 584.9 | 584.11 | 584.215 | 2933708.0 |
| 2024-10-15 10:00:00 | SPY | ETF | 584.21 | 584.63 | 581.29 | 581.95 | 6529822.0 |
| 2024-10-15 11:00:00 | SPY | ETF | 581.97 | 582.8 | 581.25 | 581.3994 | 2651158.0 |
| 2024-10-15 12:00:00 | SPY | ETF | 581.405 | 582.55 | 581.34 | 581.8 | 2000159.0 |
| 2024-10-15 13:00:00 | SPY | ETF | 581.79 | 581.96 | 580.82 | 580.98 | 2448046.0 |
| 2024-10-15 14:00:00 | SPY | ETF | 581.0 | 581.42 | 580.0 | 580.11 | 2950980.0 |
| 2024-10-15 15:00:00 | SPY | ETF | 580.12 | 580.195 | 578.545 | 579.79 | 10332981.0 |
| 2024-10-15 16:00:00 | SPY | ETF | 579.76 | 579.97 | 579.35 | 579.57 | 2544336.0 |
| 2024-10-15 17:00:00 | SPY | ETF | 579.6 | 579.78 | 579.52 | 579.6997 | 60635.0 |
| 2024-10-15 18:00:00 | SPY | ETF | 579.67 | 579.84 | 578.99 | 579.84 | 35495.0 |
| 2024-10-15 19:00:00 | SPY | ETF | 579.79 | 580.05 | 579.79 | 579.86 | 60772.0 |
| 2024-10-15 04:00:00 | QQQ | ETF | 497.08 | 497.17 | 496.18 | 496.53 | 39287.0 |
| 2024-10-15 05:00:00 | QQQ | ETF | 496.64 | 496.8 | 496.4 | 496.58 | 13724.0 |
| 2024-10-15 06:00:00 | QQQ | ETF | 496.79 | 497.59 | 496.53 | 497.4 | 57625.0 |
| 2024-10-15 07:00:00 | QQQ | ETF | 497.28 | 497.57 | 496.96 | 497.4 | 92040.0 |
| 2024-10-15 08:00:00 | QQQ | ETF | 497.35 | 497.79 | 496.684 | 497.65 | 92725.0 |
| 2024-10-15 09:00:00 | QQQ | ETF | 497.71 | 498.5 | 497.191 | 497.74 | 1992019.0 |
| 2024-10-15 10:00:00 | QQQ | ETF | 497.77 | 498.18 | 490.56 | 492.23 | 7103259.0 |
| 2024-10-15 11:00:00 | QQQ | ETF | 492.23 | 493.38 | 490.95 | 491.065 | 3435113.0 |
| 2024-10-15 12:00:00 | QQQ | ETF | 491.09 | 492.58 | 490.751 | 491.65 | 2126522.0 |
| 2024-10-15 13:00:00 | QQQ | ETF | 491.63 | 491.96 | 490.65 | 491.2211 | 1836411.0 |
| 2024-10-15 14:00:00 | QQQ | ETF | 491.24 | 491.92 | 490.38 | 490.51 | 1670122.0 |
| 2024-10-15 15:00:00 | QQQ | ETF | 490.58 | 490.92 | 488.68 | 490.78 | 6594646.0 |
| 2024-10-15 16:00:00 | QQQ | ETF | 490.79 | 491.04 | 490.26 | 490.57 | 1259195.0 |
| 2024-10-15 17:00:00 | QQQ | ETF | 490.511 | 490.73 | 490.3599 | 490.64 | 40319.0 |
| 2024-10-15 18:00:00 | QQQ | ETF | 490.51 | 490.99 | 490.0 | 490.95 | 63331.0 |
| 2024-10-15 19:00:00 | QQQ | ETF | 490.98 | 491.31 | 490.9701 | 491.03 | 48193.0 |
| 2024-10-15 04:00:00 | IWM | ETF | 222.96 | 222.96 | 222.46 | 222.59 | 14216.0 |
| 2024-10-15 05:00:00 | IWM | ETF | 222.61 | 222.91 | 222.46 | 222.7 | 5882.0 |
| 2024-10-15 06:00:00 | IWM | ETF | 222.68 | 222.91 | 222.62 | 222.68 | 8702.0 |
| 2024-10-15 07:00:00 | IWM | ETF | 222.65 | 222.95 | 222.51 | 222.66 | 92757.0 |
| 2024-10-15 08:00:00 | IWM | ETF | 222.6997 | 222.94 | 222.17 | 222.38 | 156295.0 |
| 2024-10-15 09:00:00 | IWM | ETF | 222.33 | 223.37 | 221.98 | 222.945 | 2342958.0 |
| 2024-10-15 10:00:00 | IWM | ETF | 222.955 | 224.26 | 222.49 | 223.71 | 3903402.0 |
| 2024-10-15 11:00:00 | IWM | ETF | 223.72 | 224.67 | 223.6 | 224.0287 | 1943686.0 |
| 2024-10-15 12:00:00 | IWM | ETF | 224.035 | 225.5 | 223.98 | 224.97 | 1947826.0 |
| 2024-10-15 13:00:00 | IWM | ETF | 224.98 | 225.18 | 224.4 | 224.64 | 1663874.0 |
| 2024-10-15 14:00:00 | IWM | ETF | 224.65 | 224.885 | 224.1 | 224.1699 | 1754239.0 |
| 2024-10-15 15:00:00 | IWM | ETF | 224.19 | 224.395 | 223.045 | 223.07 | 4603568.0 |
| 2024-10-15 16:00:00 | IWM | ETF | 223.07 | 223.25 | 222.9 | 223.21 | 893266.0 |
| 2024-10-15 17:00:00 | IWM | ETF | 223.151 | 223.28 | 223.1 | 223.15 | 20150.0 |
| 2024-10-15 18:00:00 | IWM | ETF | 223.2 | 223.33 | 222.9 | 223.25 | 36450.0 |
| 2024-10-15 19:00:00 | IWM | ETF | 223.23 | 223.39 | 223.19 | 223.29 | 13683.0 |
| 2024-10-15 04:00:00 | DIA | ETF | 431.62 | 431.77 | 431.52 | 431.62 | 2616.0 |
| 2024-10-15 05:00:00 | DIA | ETF | 431.59 | 431.61 | 430.94 | 431.04 | 32016.0 |
> showing 50 of 21,459 rows — these rows as CSV