PREVIEW / etf_1hour / 2024-06-03
file: by_date/etf_1hour/2024/2024-06-03.parquet size: 521 KB rows: 19,830
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-06-03 04:00:00 | SPY | ETF | 527.42 | 528.64 | 527.0 | 528.44 | 139143.0 |
| 2024-06-03 05:00:00 | SPY | ETF | 528.4 | 528.4 | 527.78 | 528.08 | 62311.0 |
| 2024-06-03 06:00:00 | SPY | ETF | 528.13 | 528.25 | 527.89 | 527.97 | 69127.0 |
| 2024-06-03 07:00:00 | SPY | ETF | 528.02 | 528.66 | 527.89 | 528.6 | 312396.0 |
| 2024-06-03 08:00:00 | SPY | ETF | 527.98 | 528.96 | 527.73 | 528.4 | 291166.0 |
| 2024-06-03 09:00:00 | SPY | ETF | 528.46 | 529.16 | 527.345 | 527.92 | 6041502.0 |
| 2024-06-03 10:00:00 | SPY | ETF | 527.92 | 529.31 | 527.4305 | 528.17 | 2566852.0 |
| 2024-06-03 11:00:00 | SPY | ETF | 526.3072 | 526.415 | 525.72 | 526.09 | 783146.0 |
| 2024-06-03 12:00:00 | SPY | ETF | 526.09 | 526.4 | 523.21 | 523.79 | 3793196.0 |
| 2024-06-03 13:00:00 | SPY | ETF | 523.77 | 525.58 | 522.6 | 525.19 | 3219150.0 |
| 2024-06-03 14:00:00 | SPY | ETF | 525.22 | 526.14 | 524.67 | 525.75 | 2392374.0 |
| 2024-06-03 15:00:00 | SPY | ETF | 525.75 | 527.83 | 525.56 | 527.77 | 7091616.0 |
| 2024-06-03 16:00:00 | SPY | ETF | 527.76 | 528.24 | 527.5502 | 527.89 | 3483388.0 |
| 2024-06-03 17:00:00 | SPY | ETF | 527.85 | 527.95 | 527.7 | 527.75 | 30068.0 |
| 2024-06-03 18:00:00 | SPY | ETF | 527.85 | 528.0 | 527.72 | 527.86 | 11722.0 |
| 2024-06-03 19:00:00 | SPY | ETF | 527.85 | 527.95 | 527.53 | 527.53 | 14048.0 |
| 2024-06-03 04:00:00 | QQQ | ETF | 452.88 | 453.67 | 452.46 | 453.45 | 194789.0 |
| 2024-06-03 05:00:00 | QQQ | ETF | 453.43 | 453.59 | 453.0 | 453.4 | 59816.0 |
| 2024-06-03 06:00:00 | QQQ | ETF | 453.48 | 453.77 | 453.21 | 453.35 | 50926.0 |
| 2024-06-03 07:00:00 | QQQ | ETF | 453.25 | 453.98 | 453.25 | 453.94 | 108779.0 |
| 2024-06-03 08:00:00 | QQQ | ETF | 453.25 | 454.25 | 452.38 | 453.87 | 311835.0 |
| 2024-06-03 09:00:00 | QQQ | ETF | 453.86 | 455.58 | 453.09 | 453.73 | 4630720.0 |
| 2024-06-03 10:00:00 | QQQ | ETF | 453.78 | 454.94 | 451.13 | 451.5999 | 4155580.0 |
| 2024-06-03 11:00:00 | QQQ | ETF | 451.6201 | 452.75 | 450.98 | 451.97 | 2538897.0 |
| 2024-06-03 12:00:00 | QQQ | ETF | 451.97 | 452.295 | 448.67 | 449.06 | 3682084.0 |
| 2024-06-03 13:00:00 | QQQ | ETF | 449.04 | 451.35 | 447.9 | 450.83 | 3088481.0 |
| 2024-06-03 14:00:00 | QQQ | ETF | 450.83 | 451.48 | 450.1 | 450.9299 | 1758947.0 |
| 2024-06-03 15:00:00 | QQQ | ETF | 450.88 | 453.19 | 450.74 | 453.15 | 3431773.0 |
| 2024-06-03 16:00:00 | QQQ | ETF | 453.15 | 453.63 | 452.8914 | 453.36 | 911306.0 |
| 2024-06-03 17:00:00 | QQQ | ETF | 453.38 | 453.48 | 453.2 | 453.28 | 36424.0 |
| 2024-06-03 18:00:00 | QQQ | ETF | 453.28 | 453.52 | 453.1503 | 453.28 | 34863.0 |
| 2024-06-03 19:00:00 | QQQ | ETF | 453.24 | 453.41 | 453.06 | 453.11 | 39013.0 |
| 2024-06-03 04:00:00 | IWM | ETF | 206.5 | 207.84 | 206.47 | 207.47 | 77968.0 |
| 2024-06-03 05:00:00 | IWM | ETF | 207.4 | 207.72 | 207.29 | 207.48 | 15205.0 |
| 2024-06-03 06:00:00 | IWM | ETF | 207.37 | 207.79 | 207.36 | 207.72 | 31483.0 |
| 2024-06-03 07:00:00 | IWM | ETF | 207.75 | 208.55 | 207.75 | 208.2 | 176123.0 |
| 2024-06-03 08:00:00 | IWM | ETF | 208.01 | 208.48 | 206.67 | 208.06 | 248341.0 |
| 2024-06-03 09:00:00 | IWM | ETF | 208.08 | 208.2 | 205.6801 | 205.79 | 3128153.0 |
| 2024-06-03 10:00:00 | IWM | ETF | 205.79 | 206.63 | 205.5715 | 205.66 | 1986365.0 |
| 2024-06-03 11:00:00 | IWM | ETF | 205.05 | 205.15 | 204.79 | 204.81 | 553726.0 |
| 2024-06-03 12:00:00 | IWM | ETF | 204.81 | 204.975 | 203.63 | 203.905 | 2337028.0 |
| 2024-06-03 13:00:00 | IWM | ETF | 203.89 | 204.02 | 203.145 | 203.95 | 2018817.0 |
| 2024-06-03 14:00:00 | IWM | ETF | 203.96 | 204.51 | 203.92 | 204.165 | 1815851.0 |
| 2024-06-03 15:00:00 | IWM | ETF | 204.16 | 204.67 | 204.07 | 204.66 | 3000294.0 |
| 2024-06-03 16:00:00 | IWM | ETF | 204.67 | 204.79 | 204.49 | 204.66 | 674440.0 |
| 2024-06-03 17:00:00 | IWM | ETF | 204.64 | 204.8 | 204.53 | 204.71 | 15047.0 |
| 2024-06-03 18:00:00 | IWM | ETF | 204.66 | 204.82 | 204.61 | 204.65 | 36270.0 |
| 2024-06-03 19:00:00 | IWM | ETF | 204.61 | 204.68 | 204.34 | 204.38 | 42145.0 |
| 2024-06-03 04:00:00 | DIA | ETF | 387.98 | 387.98 | 386.91 | 387.23 | 13601.0 |
| 2024-06-03 05:00:00 | DIA | ETF | 387.11 | 387.16 | 386.92 | 387.0 | 1358.0 |
> showing 50 of 19,830 rows — these rows as CSV