PREVIEW / etf_1hour / 2024-04-11
file: by_date/etf_1hour/2024/2024-04-11.parquet size: 536 KB rows: 19,884
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-11 04:00:00 | SPY | ETF | 514.2 | 514.63 | 513.4 | 513.4 | 24873.0 |
| 2024-04-11 05:00:00 | SPY | ETF | 513.29 | 513.75 | 513.0 | 513.3 | 21495.0 |
| 2024-04-11 06:00:00 | SPY | ETF | 513.18 | 513.38 | 512.88 | 513.21 | 32203.0 |
| 2024-04-11 07:00:00 | SPY | ETF | 513.24 | 513.44 | 511.7 | 512.1 | 285600.0 |
| 2024-04-11 08:00:00 | SPY | ETF | 512.62 | 515.45 | 511.48 | 515.06 | 1121820.0 |
| 2024-04-11 09:00:00 | SPY | ETF | 515.15 | 516.03 | 514.09 | 514.61 | 5135694.0 |
| 2024-04-11 10:00:00 | SPY | ETF | 514.62 | 514.69 | 512.08 | 513.22 | 7833444.0 |
| 2024-04-11 11:00:00 | SPY | ETF | 513.23 | 515.45 | 513.15 | 515.34 | 5752479.0 |
| 2024-04-11 12:00:00 | SPY | ETF | 515.33 | 515.65 | 514.73 | 515.29 | 5647007.0 |
| 2024-04-11 13:00:00 | SPY | ETF | 515.3 | 518.13 | 514.88 | 518.0 | 8377458.0 |
| 2024-04-11 14:00:00 | SPY | ETF | 518.005 | 519.48 | 517.92 | 518.689 | 5984347.0 |
| 2024-04-11 15:00:00 | SPY | ETF | 518.69 | 519.39 | 517.97 | 518.05 | 11611968.0 |
| 2024-04-11 16:00:00 | SPY | ETF | 518.05 | 518.31 | 517.81 | 518.15 | 4176611.0 |
| 2024-04-11 17:00:00 | SPY | ETF | 518.14 | 518.2 | 518.0 | 518.07 | 66113.0 |
| 2024-04-11 18:00:00 | SPY | ETF | 518.05 | 518.49 | 518.03 | 518.29 | 60678.0 |
| 2024-04-11 19:00:00 | SPY | ETF | 518.35 | 518.44 | 517.86 | 518.25 | 54128.0 |
| 2024-04-11 04:00:00 | QQQ | ETF | 438.65 | 438.9 | 437.72 | 437.73 | 53083.0 |
| 2024-04-11 05:00:00 | QQQ | ETF | 437.65 | 437.99 | 437.46 | 437.68 | 24016.0 |
| 2024-04-11 06:00:00 | QQQ | ETF | 437.78 | 437.96 | 437.38 | 437.83 | 55518.0 |
| 2024-04-11 07:00:00 | QQQ | ETF | 437.85 | 438.0 | 436.61 | 436.9 | 96393.0 |
| 2024-04-11 08:00:00 | QQQ | ETF | 437.8297 | 440.19 | 436.07 | 439.79 | 1476088.0 |
| 2024-04-11 09:00:00 | QQQ | ETF | 439.83 | 440.75 | 439.26 | 440.17 | 4389499.0 |
| 2024-04-11 10:00:00 | QQQ | ETF | 440.17 | 440.24 | 437.96 | 439.57 | 4961887.0 |
| 2024-04-11 11:00:00 | QQQ | ETF | 439.6 | 441.61 | 439.56 | 441.49 | 3597203.0 |
| 2024-04-11 12:00:00 | QQQ | ETF | 441.5 | 441.7 | 440.79 | 441.245 | 2375785.0 |
| 2024-04-11 13:00:00 | QQQ | ETF | 441.29 | 444.49 | 440.87 | 444.32 | 6116757.0 |
| 2024-04-11 14:00:00 | QQQ | ETF | 444.33 | 446.14 | 444.24 | 445.33 | 4582889.0 |
| 2024-04-11 15:00:00 | QQQ | ETF | 445.34 | 446.33 | 445.34 | 445.46 | 5824798.0 |
| 2024-04-11 16:00:00 | QQQ | ETF | 445.46 | 445.74 | 445.37 | 445.49 | 1285736.0 |
| 2024-04-11 17:00:00 | QQQ | ETF | 445.47 | 445.47 | 445.24 | 445.34 | 48401.0 |
| 2024-04-11 18:00:00 | QQQ | ETF | 445.3 | 445.8 | 445.29 | 445.68 | 61679.0 |
| 2024-04-11 19:00:00 | QQQ | ETF | 445.72 | 445.8 | 445.25 | 445.6 | 66337.0 |
| 2024-04-11 04:00:00 | IWM | ETF | 200.65 | 200.77 | 200.14 | 200.14 | 27750.0 |
| 2024-04-11 05:00:00 | IWM | ETF | 200.08 | 200.24 | 199.9 | 199.9 | 42145.0 |
| 2024-04-11 06:00:00 | IWM | ETF | 199.95 | 200.01 | 199.5 | 199.51 | 74625.0 |
| 2024-04-11 07:00:00 | IWM | ETF | 199.55 | 199.68 | 199.041 | 199.2 | 128021.0 |
| 2024-04-11 08:00:00 | IWM | ETF | 199.18 | 202.33 | 198.15 | 201.49 | 1512865.0 |
| 2024-04-11 09:00:00 | IWM | ETF | 201.54 | 202.44 | 200.89 | 201.4 | 3736266.0 |
| 2024-04-11 10:00:00 | IWM | ETF | 201.4 | 201.44 | 200.1 | 200.46 | 3828494.0 |
| 2024-04-11 11:00:00 | IWM | ETF | 200.47 | 202.06 | 200.2597 | 201.99 | 2340872.0 |
| 2024-04-11 12:00:00 | IWM | ETF | 202.0 | 202.12 | 201.31 | 201.76 | 2458559.0 |
| 2024-04-11 13:00:00 | IWM | ETF | 201.77 | 202.63 | 201.5 | 202.45 | 3441850.0 |
| 2024-04-11 14:00:00 | IWM | ETF | 202.47 | 202.91 | 202.21 | 202.23 | 2887367.0 |
| 2024-04-11 15:00:00 | IWM | ETF | 202.22 | 202.52 | 202.01 | 202.33 | 5102412.0 |
| 2024-04-11 16:00:00 | IWM | ETF | 202.29 | 202.45 | 202.18 | 202.29 | 1528130.0 |
| 2024-04-11 17:00:00 | IWM | ETF | 202.29 | 202.29 | 201.98 | 202.1 | 73230.0 |
| 2024-04-11 18:00:00 | IWM | ETF | 202.15 | 202.49 | 202.14 | 202.32 | 42550.0 |
| 2024-04-11 19:00:00 | IWM | ETF | 202.32 | 202.4 | 202.19 | 202.28 | 17294.0 |
| 2024-04-11 04:00:00 | DIA | ETF | 384.28 | 384.28 | 384.28 | 384.28 | 100.0 |
| 2024-04-11 05:00:00 | DIA | ETF | 384.0 | 384.07 | 383.73 | 383.73 | 2074.0 |
> showing 50 of 19,884 rows — these rows as CSV