PREVIEW / etf_1hour / 2024-04-12
file: by_date/etf_1hour/2024/2024-04-12.parquet size: 543 KB rows: 20,059
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-04-12 04:00:00 | SPY | ETF | 518.51 | 518.59 | 517.89 | 517.89 | 25286.0 |
| 2024-04-12 05:00:00 | SPY | ETF | 517.79 | 517.9 | 517.3 | 517.58 | 14141.0 |
| 2024-04-12 06:00:00 | SPY | ETF | 517.46 | 517.51 | 515.44 | 515.82 | 117282.0 |
| 2024-04-12 07:00:00 | SPY | ETF | 515.93 | 517.13 | 515.68 | 516.82 | 246972.0 |
| 2024-04-12 08:00:00 | SPY | ETF | 515.91 | 518.62 | 514.21 | 514.28 | 666967.0 |
| 2024-04-12 09:00:00 | SPY | ETF | 514.22 | 515.815 | 513.45 | 515.34 | 7611589.0 |
| 2024-04-12 10:00:00 | SPY | ETF | 515.37 | 515.44 | 512.02 | 512.3101 | 10787888.0 |
| 2024-04-12 11:00:00 | SPY | ETF | 512.31 | 514.03 | 512.2 | 513.4 | 6321254.0 |
| 2024-04-12 12:00:00 | SPY | ETF | 513.43 | 513.53 | 510.48 | 510.57 | 8758779.0 |
| 2024-04-12 13:00:00 | SPY | ETF | 510.58 | 511.25 | 509.32 | 510.49 | 9143870.0 |
| 2024-04-12 14:00:00 | SPY | ETF | 510.49 | 511.415 | 509.56 | 509.625 | 7527743.0 |
| 2024-04-12 15:00:00 | SPY | ETF | 509.62 | 510.93 | 509.08 | 510.82 | 16251260.0 |
| 2024-04-12 16:00:00 | SPY | ETF | 510.82 | 511.09 | 510.65 | 510.69 | 3733598.0 |
| 2024-04-12 17:00:00 | SPY | ETF | 510.739 | 510.85 | 510.4 | 510.47 | 90626.0 |
| 2024-04-12 18:00:00 | SPY | ETF | 510.45 | 510.5 | 510.3 | 510.38 | 13950.0 |
| 2024-04-12 19:00:00 | SPY | ETF | 510.3 | 510.39 | 509.92 | 509.98 | 61664.0 |
| 2024-04-12 04:00:00 | QQQ | ETF | 445.21 | 445.5 | 444.56 | 444.56 | 46619.0 |
| 2024-04-12 05:00:00 | QQQ | ETF | 444.55 | 444.64 | 443.9 | 444.1 | 41740.0 |
| 2024-04-12 06:00:00 | QQQ | ETF | 444.1 | 444.11 | 442.61 | 443.16 | 91239.0 |
| 2024-04-12 07:00:00 | QQQ | ETF | 443.18 | 444.2 | 443.0 | 443.8 | 298220.0 |
| 2024-04-12 08:00:00 | QQQ | ETF | 443.1792 | 446.0 | 441.5 | 441.61 | 621996.0 |
| 2024-04-12 09:00:00 | QQQ | ETF | 441.61 | 442.24 | 440.6 | 442.16 | 5093225.0 |
| 2024-04-12 10:00:00 | QQQ | ETF | 442.16 | 442.23 | 438.661 | 438.775 | 6764061.0 |
| 2024-04-12 11:00:00 | QQQ | ETF | 438.79 | 441.01 | 438.68 | 440.16 | 4589496.0 |
| 2024-04-12 12:00:00 | QQQ | ETF | 440.18 | 440.4266 | 437.535 | 437.8007 | 4758989.0 |
| 2024-04-12 13:00:00 | QQQ | ETF | 437.81 | 438.64 | 436.96 | 437.8788 | 4576927.0 |
| 2024-04-12 14:00:00 | QQQ | ETF | 437.88 | 438.5195 | 437.15 | 437.1999 | 3580718.0 |
| 2024-04-12 15:00:00 | QQQ | ETF | 437.2 | 438.71 | 436.88 | 438.29 | 8928844.0 |
| 2024-04-12 16:00:00 | QQQ | ETF | 438.29 | 438.63 | 438.03 | 438.14 | 1873864.0 |
| 2024-04-12 17:00:00 | QQQ | ETF | 438.139 | 438.27 | 437.6 | 437.63 | 78675.0 |
| 2024-04-12 18:00:00 | QQQ | ETF | 437.68 | 437.68 | 437.52 | 437.59 | 17666.0 |
| 2024-04-12 19:00:00 | QQQ | ETF | 437.59 | 437.62 | 437.1 | 437.2 | 41645.0 |
| 2024-04-12 04:00:00 | IWM | ETF | 202.7 | 202.74 | 202.18 | 202.22 | 21510.0 |
| 2024-04-12 05:00:00 | IWM | ETF | 202.16 | 202.4 | 201.98 | 202.3 | 27816.0 |
| 2024-04-12 06:00:00 | IWM | ETF | 202.14 | 202.19 | 200.95 | 201.29 | 44752.0 |
| 2024-04-12 07:00:00 | IWM | ETF | 201.33 | 202.08 | 201.28 | 201.94 | 121950.0 |
| 2024-04-12 08:00:00 | IWM | ETF | 201.3511 | 202.25 | 200.79 | 200.88 | 246536.0 |
| 2024-04-12 09:00:00 | IWM | ETF | 200.83 | 201.91 | 200.49 | 201.03 | 3449777.0 |
| 2024-04-12 10:00:00 | IWM | ETF | 201.05 | 201.07 | 199.6 | 199.7999 | 3896772.0 |
| 2024-04-12 11:00:00 | IWM | ETF | 199.8 | 200.24 | 199.555 | 200.055 | 2700232.0 |
| 2024-04-12 12:00:00 | IWM | ETF | 200.05 | 200.14 | 199.04 | 199.11 | 2167467.0 |
| 2024-04-12 13:00:00 | IWM | ETF | 199.11 | 199.32 | 198.32 | 198.85 | 3292924.0 |
| 2024-04-12 14:00:00 | IWM | ETF | 198.84 | 199.185 | 197.99 | 198.105 | 3173904.0 |
| 2024-04-12 15:00:00 | IWM | ETF | 198.11 | 198.7 | 197.68 | 198.7 | 7260144.0 |
| 2024-04-12 16:00:00 | IWM | ETF | 198.69 | 198.87 | 198.66 | 198.7 | 948904.0 |
| 2024-04-12 17:00:00 | IWM | ETF | 198.71 | 198.75 | 198.53 | 198.69 | 58582.0 |
| 2024-04-12 18:00:00 | IWM | ETF | 198.6 | 198.6 | 198.41 | 198.41 | 2261.0 |
| 2024-04-12 19:00:00 | IWM | ETF | 198.58 | 198.58 | 198.12 | 198.12 | 8416.0 |
| 2024-04-12 04:00:00 | DIA | ETF | 385.31 | 385.34 | 385.31 | 385.34 | 300.0 |
| 2024-04-12 05:00:00 | DIA | ETF | 385.25 | 385.25 | 385.18 | 385.18 | 1209.0 |
> showing 50 of 20,059 rows — these rows as CSV