PREVIEW / etf_1hour / 2025-06-16
file: by_date/etf_1hour/2025/2025-06-16.parquet size: 645 KB rows: 25,078
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 |
|---|---|---|---|---|---|---|---|
| 2025-06-16 04:00:00 | SPY | ETF | 600.31 | 600.4 | 598.18 | 600.22 | 50284.0 |
| 2025-06-16 05:00:00 | SPY | ETF | 600.26 | 600.28 | 599.11 | 599.46 | 77525.0 |
| 2025-06-16 06:00:00 | SPY | ETF | 599.33 | 600.2 | 599.29 | 600.2 | 59265.0 |
| 2025-06-16 07:00:00 | SPY | ETF | 600.16 | 600.86 | 599.47 | 600.75 | 311492.0 |
| 2025-06-16 08:00:00 | SPY | ETF | 599.67 | 601.41 | 596.9301 | 600.74 | 497078.0 |
| 2025-06-16 09:00:00 | SPY | ETF | 600.77 | 603.41 | 600.22 | 603.05 | 8590664.0 |
| 2025-06-16 10:00:00 | SPY | ETF | 603.07 | 604.45 | 602.965 | 603.9188 | 8390113.0 |
| 2025-06-16 11:00:00 | SPY | ETF | 603.92 | 604.09 | 602.77 | 603.1399 | 6368109.0 |
| 2025-06-16 12:00:00 | SPY | ETF | 603.14 | 603.66 | 602.47 | 602.73 | 3985535.0 |
| 2025-06-16 13:00:00 | SPY | ETF | 602.73 | 603.71 | 602.13 | 602.3099 | 5174525.0 |
| 2025-06-16 14:00:00 | SPY | ETF | 602.31 | 602.87 | 601.85 | 602.5046 | 4736262.0 |
| 2025-06-16 15:00:00 | SPY | ETF | 602.5 | 602.8 | 601.64 | 602.71 | 13153976.0 |
| 2025-06-16 16:00:00 | SPY | ETF | 602.71 | 603.2 | 602.61 | 602.7 | 2648064.0 |
| 2025-06-16 17:00:00 | SPY | ETF | 602.7201 | 603.17 | 602.6 | 602.91 | 150060.0 |
| 2025-06-16 18:00:00 | SPY | ETF | 602.85 | 602.9 | 600.3 | 600.8 | 323908.0 |
| 2025-06-16 19:00:00 | SPY | ETF | 600.8383 | 601.5 | 598.92 | 598.94 | 488892.0 |
| 2025-06-16 04:00:00 | QQQ | ETF | 530.2 | 530.28 | 529.12 | 530.17 | 75962.0 |
| 2025-06-16 05:00:00 | QQQ | ETF | 530.17 | 530.29 | 528.97 | 529.46 | 48701.0 |
| 2025-06-16 06:00:00 | QQQ | ETF | 529.28 | 530.17 | 529.24 | 530.17 | 86185.0 |
| 2025-06-16 07:00:00 | QQQ | ETF | 530.17 | 530.879 | 529.5 | 530.879 | 135677.0 |
| 2025-06-16 08:00:00 | QQQ | ETF | 529.97 | 531.62 | 526.565 | 530.99 | 381264.0 |
| 2025-06-16 09:00:00 | QQQ | ETF | 531.04 | 534.12 | 530.39 | 533.73 | 4333860.0 |
| 2025-06-16 10:00:00 | QQQ | ETF | 533.74 | 535.06 | 533.55 | 534.47 | 4486690.0 |
| 2025-06-16 11:00:00 | QQQ | ETF | 534.48 | 535.37 | 533.81 | 534.16 | 2865926.0 |
| 2025-06-16 12:00:00 | QQQ | ETF | 534.18 | 534.74 | 533.5 | 533.99 | 1979380.0 |
| 2025-06-16 13:00:00 | QQQ | ETF | 533.97 | 535.06 | 533.62 | 533.97 | 2285730.0 |
| 2025-06-16 14:00:00 | QQQ | ETF | 533.98 | 534.42 | 533.32 | 534.05 | 1855603.0 |
| 2025-06-16 15:00:00 | QQQ | ETF | 534.05 | 534.6 | 533.44 | 534.27 | 5422329.0 |
| 2025-06-16 16:00:00 | QQQ | ETF | 534.27 | 534.51 | 533.88 | 534.0 | 1560222.0 |
| 2025-06-16 17:00:00 | QQQ | ETF | 534.07 | 534.45 | 534.03 | 534.35 | 65037.0 |
| 2025-06-16 18:00:00 | QQQ | ETF | 534.27 | 534.29 | 531.67 | 532.08 | 135078.0 |
| 2025-06-16 19:00:00 | QQQ | ETF | 532.0 | 532.85 | 530.46 | 530.46 | 287534.0 |
| 2025-06-16 04:00:00 | IWM | ETF | 210.15 | 210.47 | 209.91 | 210.36 | 39133.0 |
| 2025-06-16 05:00:00 | IWM | ETF | 210.38 | 210.38 | 209.98 | 210.12 | 50454.0 |
| 2025-06-16 06:00:00 | IWM | ETF | 210.08 | 210.66 | 210.08 | 210.66 | 29475.0 |
| 2025-06-16 07:00:00 | IWM | ETF | 210.63 | 210.9 | 210.17 | 210.76 | 98487.0 |
| 2025-06-16 08:00:00 | IWM | ETF | 210.23 | 211.13 | 208.94 | 210.65 | 240510.0 |
| 2025-06-16 09:00:00 | IWM | ETF | 210.65 | 211.035 | 209.64 | 210.65 | 3892166.0 |
| 2025-06-16 10:00:00 | IWM | ETF | 210.67 | 211.95 | 210.58 | 211.64 | 4177140.0 |
| 2025-06-16 11:00:00 | IWM | ETF | 211.63 | 211.67 | 210.4301 | 210.62 | 2537396.0 |
| 2025-06-16 12:00:00 | IWM | ETF | 210.62 | 211.2301 | 210.56 | 210.97 | 1854652.0 |
| 2025-06-16 13:00:00 | IWM | ETF | 210.9701 | 211.27 | 210.575 | 210.6499 | 1850676.0 |
| 2025-06-16 14:00:00 | IWM | ETF | 210.65 | 210.9 | 210.2 | 210.4699 | 1667904.0 |
| 2025-06-16 15:00:00 | IWM | ETF | 210.465 | 210.78 | 210.13 | 210.75 | 5611173.0 |
| 2025-06-16 16:00:00 | IWM | ETF | 210.77 | 211.01 | 210.71 | 210.98 | 899931.0 |
| 2025-06-16 17:00:00 | IWM | ETF | 210.98 | 211.0 | 210.8 | 210.83 | 21915.0 |
| 2025-06-16 18:00:00 | IWM | ETF | 210.98 | 210.98 | 209.69 | 210.02 | 72204.0 |
| 2025-06-16 19:00:00 | IWM | ETF | 210.01 | 210.4 | 209.01 | 209.01 | 111663.0 |
| 2025-06-16 04:00:00 | DIA | ETF | 424.87 | 424.92 | 424.38 | 424.78 | 5350.0 |
| 2025-06-16 05:00:00 | DIA | ETF | 424.79 | 424.79 | 424.79 | 424.79 | 100.0 |
> showing 50 of 25,078 rows — these rows as CSV