PREVIEW / etf_1hour / 2025-11-18
file: by_date/etf_1hour/2025/2025-11-18.parquet size: 729 KB rows: 27,834
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-11-18 04:00:00 | SPY | ETF | 663.96 | 664.85 | 663.2 | 664.61 | 49695.0 |
| 2025-11-18 05:00:00 | SPY | ETF | 664.45 | 664.63 | 663.48 | 664.37 | 19526.0 |
| 2025-11-18 06:00:00 | SPY | ETF | 664.4 | 664.59 | 662.99 | 663.85 | 44113.0 |
| 2025-11-18 07:00:00 | SPY | ETF | 663.88 | 663.92 | 660.5 | 661.4 | 572517.0 |
| 2025-11-18 08:00:00 | SPY | ETF | 665.5674 | 665.5674 | 660.05 | 662.55 | 622887.0 |
| 2025-11-18 09:00:00 | SPY | ETF | 662.5 | 664.26 | 658.61 | 658.65 | 15246416.0 |
| 2025-11-18 10:00:00 | SPY | ETF | 658.64 | 660.31 | 656.8 | 657.22 | 17777171.0 |
| 2025-11-18 11:00:00 | SPY | ETF | 657.23 | 662.37 | 655.86 | 661.17 | 12534707.0 |
| 2025-11-18 12:00:00 | SPY | ETF | 661.14 | 664.375 | 657.91 | 663.67 | 9582287.0 |
| 2025-11-18 13:00:00 | SPY | ETF | 663.72 | 665.12 | 662.7 | 663.01 | 8496304.0 |
| 2025-11-18 14:00:00 | SPY | ETF | 663.05 | 664.96 | 662.434 | 664.42 | 8214947.0 |
| 2025-11-18 15:00:00 | SPY | ETF | 664.43 | 664.94 | 660.0 | 660.14 | 17826176.0 |
| 2025-11-18 16:00:00 | SPY | ETF | 660.16 | 660.24 | 658.93 | 659.2 | 3053668.0 |
| 2025-11-18 17:00:00 | SPY | ETF | 659.2 | 659.4 | 659.07 | 659.28 | 73200.0 |
| 2025-11-18 18:00:00 | SPY | ETF | 659.28 | 661.0733 | 659.28 | 660.59 | 119372.0 |
| 2025-11-18 19:00:00 | SPY | ETF | 660.47 | 660.685 | 658.75 | 659.95 | 112995.0 |
| 2025-11-18 04:00:00 | QQQ | ETF | 601.74 | 602.94 | 598.3 | 602.49 | 268059.0 |
| 2025-11-18 05:00:00 | QQQ | ETF | 602.52 | 602.66 | 601.3 | 602.31 | 115667.0 |
| 2025-11-18 06:00:00 | QQQ | ETF | 602.16 | 602.43 | 600.63 | 601.55 | 251945.0 |
| 2025-11-18 07:00:00 | QQQ | ETF | 601.58 | 601.58 | 598.2 | 598.99 | 593078.0 |
| 2025-11-18 08:00:00 | QQQ | ETF | 603.5854 | 603.5854 | 596.9 | 599.95 | 836192.0 |
| 2025-11-18 09:00:00 | QQQ | ETF | 599.88 | 602.31 | 594.8 | 594.86 | 11921293.0 |
| 2025-11-18 10:00:00 | QQQ | ETF | 594.83 | 596.92 | 592.59 | 593.28 | 14334607.0 |
| 2025-11-18 11:00:00 | QQQ | ETF | 593.29 | 599.15 | 591.34 | 597.98 | 9974507.0 |
| 2025-11-18 12:00:00 | QQQ | ETF | 597.96 | 601.13 | 594.1 | 600.4 | 7591430.0 |
| 2025-11-18 13:00:00 | QQQ | ETF | 600.415 | 601.63 | 598.94 | 599.3501 | 5024806.0 |
| 2025-11-18 14:00:00 | QQQ | ETF | 599.35 | 601.79 | 598.79 | 600.96 | 4732452.0 |
| 2025-11-18 15:00:00 | QQQ | ETF | 600.97 | 601.44 | 596.19 | 596.33 | 8421590.0 |
| 2025-11-18 16:00:00 | QQQ | ETF | 596.34 | 596.51 | 594.89 | 595.0 | 1714613.0 |
| 2025-11-18 17:00:00 | QQQ | ETF | 595.04 | 596.37 | 595.0 | 595.25 | 474010.0 |
| 2025-11-18 18:00:00 | QQQ | ETF | 595.36 | 597.36 | 595.3 | 596.44 | 293970.0 |
| 2025-11-18 19:00:00 | QQQ | ETF | 596.56 | 596.665 | 594.3 | 595.63 | 150141.0 |
| 2025-11-18 04:00:00 | IWM | ETF | 231.85 | 232.17 | 231.53 | 232.05 | 40032.0 |
| 2025-11-18 05:00:00 | IWM | ETF | 232.03 | 232.21 | 231.69 | 232.15 | 15890.0 |
| 2025-11-18 06:00:00 | IWM | ETF | 232.14 | 232.21 | 231.75 | 232.02 | 25906.0 |
| 2025-11-18 07:00:00 | IWM | ETF | 232.09 | 232.09 | 230.62 | 230.79 | 107838.0 |
| 2025-11-18 08:00:00 | IWM | ETF | 232.0 | 232.26 | 230.28 | 231.68 | 179995.0 |
| 2025-11-18 09:00:00 | IWM | ETF | 231.64 | 233.01 | 231.17 | 231.7 | 6145307.0 |
| 2025-11-18 10:00:00 | IWM | ETF | 231.691 | 232.8 | 230.955 | 231.4 | 8596068.0 |
| 2025-11-18 11:00:00 | IWM | ETF | 231.38 | 233.66 | 230.985 | 233.12 | 8537794.0 |
| 2025-11-18 12:00:00 | IWM | ETF | 233.11 | 234.58 | 231.97 | 234.31 | 6359804.0 |
| 2025-11-18 13:00:00 | IWM | ETF | 234.32 | 235.08 | 234.06 | 234.26 | 6792239.0 |
| 2025-11-18 14:00:00 | IWM | ETF | 234.27 | 234.72 | 233.88 | 234.52 | 4894654.0 |
| 2025-11-18 15:00:00 | IWM | ETF | 234.53 | 234.735 | 233.375 | 233.46 | 7086120.0 |
| 2025-11-18 16:00:00 | IWM | ETF | 233.47 | 233.47 | 232.75 | 232.86 | 1056440.0 |
| 2025-11-18 17:00:00 | IWM | ETF | 232.65 | 233.17 | 232.61 | 232.95 | 27347.0 |
| 2025-11-18 18:00:00 | IWM | ETF | 232.95 | 233.67 | 232.95 | 233.59 | 39028.0 |
| 2025-11-18 19:00:00 | IWM | ETF | 233.54 | 233.6 | 232.88 | 233.47 | 84471.0 |
| 2025-11-18 04:00:00 | DIA | ETF | 464.95 | 465.18 | 464.59 | 464.76 | 2694.0 |
| 2025-11-18 05:00:00 | DIA | ETF | 464.62 | 464.64 | 464.62 | 464.64 | 149.0 |
> showing 50 of 27,834 rows — these rows as CSV