PREVIEW / etf_1hour / 2024-05-15
file: by_date/etf_1hour/2024/2024-05-15.parquet size: 554 KB rows: 20,379
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-05-15 04:00:00 | SPY | ETF | 523.5 | 523.75 | 523.45 | 523.75 | 21804.0 |
| 2024-05-15 05:00:00 | SPY | ETF | 523.77 | 523.82 | 523.65 | 523.78 | 25947.0 |
| 2024-05-15 06:00:00 | SPY | ETF | 523.71 | 523.71 | 523.57 | 523.57 | 6708.0 |
| 2024-05-15 07:00:00 | SPY | ETF | 523.6 | 523.78 | 523.46 | 523.61 | 117787.0 |
| 2024-05-15 08:00:00 | SPY | ETF | 523.6098 | 527.0 | 523.12 | 526.08 | 1920212.0 |
| 2024-05-15 09:00:00 | SPY | ETF | 526.08 | 526.8 | 525.18 | 525.67 | 6313279.0 |
| 2024-05-15 10:00:00 | SPY | ETF | 525.67 | 527.25 | 525.635 | 527.15 | 5831910.0 |
| 2024-05-15 11:00:00 | SPY | ETF | 527.16 | 528.17 | 527.142 | 527.8812 | 4349851.0 |
| 2024-05-15 12:00:00 | SPY | ETF | 527.89 | 528.59 | 527.415 | 528.5353 | 3278445.0 |
| 2024-05-15 13:00:00 | SPY | ETF | 528.56 | 528.99 | 528.34 | 528.96 | 3359903.0 |
| 2024-05-15 14:00:00 | SPY | ETF | 528.96 | 529.43 | 528.6 | 528.995 | 4231015.0 |
| 2024-05-15 15:00:00 | SPY | ETF | 528.995 | 530.08 | 528.7 | 529.76 | 13352949.0 |
| 2024-05-15 16:00:00 | SPY | ETF | 529.76 | 529.84 | 528.93 | 529.39 | 3847545.0 |
| 2024-05-15 17:00:00 | SPY | ETF | 529.36 | 529.78 | 529.35 | 529.5 | 38189.0 |
| 2024-05-15 18:00:00 | SPY | ETF | 529.5 | 529.83 | 529.32 | 529.7 | 37754.0 |
| 2024-05-15 19:00:00 | SPY | ETF | 529.79 | 530.31 | 529.78 | 530.18 | 85313.0 |
| 2024-05-15 04:00:00 | QQQ | ETF | 445.85 | 446.17 | 445.76 | 446.17 | 19818.0 |
| 2024-05-15 05:00:00 | QQQ | ETF | 446.18 | 446.26 | 446.0 | 446.11 | 10844.0 |
| 2024-05-15 06:00:00 | QQQ | ETF | 446.1 | 446.12 | 445.86 | 445.86 | 33617.0 |
| 2024-05-15 07:00:00 | QQQ | ETF | 445.92 | 446.18 | 445.9 | 446.04 | 50943.0 |
| 2024-05-15 08:00:00 | QQQ | ETF | 445.94 | 449.35 | 445.59 | 448.4 | 1250828.0 |
| 2024-05-15 09:00:00 | QQQ | ETF | 448.44 | 449.0 | 446.264 | 447.78 | 4504638.0 |
| 2024-05-15 10:00:00 | QQQ | ETF | 447.78 | 449.93 | 447.76 | 449.91 | 4280362.0 |
| 2024-05-15 11:00:00 | QQQ | ETF | 449.91 | 450.79 | 449.87 | 450.45 | 3183669.0 |
| 2024-05-15 12:00:00 | QQQ | ETF | 450.47 | 451.34 | 450.055 | 451.2901 | 2451924.0 |
| 2024-05-15 13:00:00 | QQQ | ETF | 451.32 | 452.585 | 451.28 | 452.54 | 3193845.0 |
| 2024-05-15 14:00:00 | QQQ | ETF | 452.54 | 453.04 | 452.3 | 452.63 | 3393922.0 |
| 2024-05-15 15:00:00 | QQQ | ETF | 452.6213 | 453.15 | 452.415 | 452.84 | 6520403.0 |
| 2024-05-15 16:00:00 | QQQ | ETF | 452.85 | 452.9 | 452.2 | 452.8309 | 1624958.0 |
| 2024-05-15 17:00:00 | QQQ | ETF | 452.83 | 452.85 | 452.68 | 452.8 | 26548.0 |
| 2024-05-15 18:00:00 | QQQ | ETF | 452.82 | 453.27 | 452.67 | 453.0 | 117139.0 |
| 2024-05-15 19:00:00 | QQQ | ETF | 453.04 | 453.61 | 453.04 | 453.4601 | 116646.0 |
| 2024-05-15 04:00:00 | IWM | ETF | 207.67 | 207.8 | 207.44 | 207.8 | 38931.0 |
| 2024-05-15 05:00:00 | IWM | ETF | 207.71 | 207.71 | 207.45 | 207.64 | 35567.0 |
| 2024-05-15 06:00:00 | IWM | ETF | 207.74 | 207.74 | 207.53 | 207.58 | 19049.0 |
| 2024-05-15 07:00:00 | IWM | ETF | 207.6 | 207.71 | 207.3 | 207.33 | 135593.0 |
| 2024-05-15 08:00:00 | IWM | ETF | 207.5793 | 210.67 | 206.87 | 209.48 | 1983246.0 |
| 2024-05-15 09:00:00 | IWM | ETF | 209.55 | 209.77 | 208.01 | 208.02 | 3939048.0 |
| 2024-05-15 10:00:00 | IWM | ETF | 208.02 | 208.665 | 207.72 | 208.49 | 4643155.0 |
| 2024-05-15 11:00:00 | IWM | ETF | 208.5 | 209.2 | 208.45 | 208.82 | 2535684.0 |
| 2024-05-15 12:00:00 | IWM | ETF | 208.82 | 209.29 | 208.52 | 209.23 | 1493045.0 |
| 2024-05-15 13:00:00 | IWM | ETF | 209.25 | 209.34 | 208.64 | 208.86 | 1980087.0 |
| 2024-05-15 14:00:00 | IWM | ETF | 208.86 | 209.04 | 208.77 | 208.92 | 1485236.0 |
| 2024-05-15 15:00:00 | IWM | ETF | 208.915 | 209.42 | 208.795 | 209.34 | 5317728.0 |
| 2024-05-15 16:00:00 | IWM | ETF | 209.345 | 209.44 | 208.89 | 209.04 | 1783498.0 |
| 2024-05-15 17:00:00 | IWM | ETF | 209.04 | 209.19 | 209.04 | 209.17 | 6754.0 |
| 2024-05-15 18:00:00 | IWM | ETF | 209.09 | 209.4 | 209.02 | 209.32 | 17099.0 |
| 2024-05-15 19:00:00 | IWM | ETF | 209.34 | 209.58 | 209.34 | 209.4 | 65506.0 |
| 2024-05-15 04:00:00 | DIA | ETF | 395.7 | 395.7 | 395.7 | 395.7 | 100.0 |
| 2024-05-15 05:00:00 | DIA | ETF | 395.89 | 395.89 | 395.89 | 395.89 | 100.0 |
> showing 50 of 20,379 rows — these rows as CSV