PREVIEW / etf_1hour / 2024-12-24
file: by_date/etf_1hour/2024/2024-12-24.parquet size: 416 KB rows: 14,681
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-12-24 04:00:00 | SPY | ETF | 595.05 | 595.75 | 595.0 | 595.69 | 7827.0 |
| 2024-12-24 05:00:00 | SPY | ETF | 595.8 | 595.8 | 595.4 | 595.67 | 8413.0 |
| 2024-12-24 06:00:00 | SPY | ETF | 595.66 | 595.79 | 595.1 | 595.3 | 6763.0 |
| 2024-12-24 07:00:00 | SPY | ETF | 595.26 | 595.68 | 595.2 | 595.68 | 55759.0 |
| 2024-12-24 08:00:00 | SPY | ETF | 595.37 | 595.83 | 594.5 | 595.76 | 151213.0 |
| 2024-12-24 09:00:00 | SPY | ETF | 595.75 | 597.28 | 595.47 | 597.2 | 2510175.0 |
| 2024-12-24 10:00:00 | SPY | ETF | 597.2 | 599.3701 | 597.2 | 599.18 | 3593794.0 |
| 2024-12-24 11:00:00 | SPY | ETF | 599.17 | 599.81 | 598.8 | 599.0117 | 2535865.0 |
| 2024-12-24 12:00:00 | SPY | ETF | 599.04 | 601.34 | 598.9 | 601.26 | 7602206.0 |
| 2024-12-24 13:00:00 | SPY | ETF | 601.23 | 602.2 | 600.78 | 601.45 | 3078494.0 |
| 2024-12-24 14:00:00 | SPY | ETF | 601.46 | 601.54 | 601.15 | 601.5 | 78084.0 |
| 2024-12-24 15:00:00 | SPY | ETF | 601.55 | 601.55 | 601.01 | 601.06 | 33307.0 |
| 2024-12-24 16:00:00 | SPY | ETF | 601.08 | 601.2 | 601.07 | 601.1 | 40990.0 |
| 2024-12-24 04:00:00 | QQQ | ETF | 523.24 | 524.04 | 523.09 | 524.0 | 32905.0 |
| 2024-12-24 05:00:00 | QQQ | ETF | 524.14 | 524.27 | 523.65 | 524.1 | 9432.0 |
| 2024-12-24 06:00:00 | QQQ | ETF | 524.14 | 524.22 | 523.33 | 523.79 | 29050.0 |
| 2024-12-24 07:00:00 | QQQ | ETF | 523.77 | 524.2 | 523.67 | 524.13 | 55597.0 |
| 2024-12-24 08:00:00 | QQQ | ETF | 523.86 | 524.8 | 522.65 | 524.77 | 221158.0 |
| 2024-12-24 09:00:00 | QQQ | ETF | 524.75 | 526.74 | 524.19 | 526.66 | 1905524.0 |
| 2024-12-24 10:00:00 | QQQ | ETF | 526.67 | 528.23 | 526.54 | 528.08 | 2771322.0 |
| 2024-12-24 11:00:00 | QQQ | ETF | 528.0738 | 528.93 | 527.8542 | 528.1482 | 2131888.0 |
| 2024-12-24 12:00:00 | QQQ | ETF | 528.19 | 530.05 | 527.72 | 530.02 | 3485774.0 |
| 2024-12-24 13:00:00 | QQQ | ETF | 530.0 | 530.35 | 529.8 | 530.1 | 1178632.0 |
| 2024-12-24 14:00:00 | QQQ | ETF | 530.0 | 530.16 | 529.91 | 529.96 | 24327.0 |
| 2024-12-24 15:00:00 | QQQ | ETF | 529.9201 | 530.0331 | 529.71 | 529.88 | 17776.0 |
| 2024-12-24 16:00:00 | QQQ | ETF | 529.81 | 530.04 | 529.81 | 529.96 | 15266.0 |
| 2024-12-24 04:00:00 | IWM | ETF | 221.3 | 221.7 | 221.08 | 221.6 | 10368.0 |
| 2024-12-24 05:00:00 | IWM | ETF | 221.6 | 221.62 | 221.31 | 221.48 | 14382.0 |
| 2024-12-24 06:00:00 | IWM | ETF | 221.56 | 221.56 | 221.08 | 221.24 | 4871.0 |
| 2024-12-24 07:00:00 | IWM | ETF | 221.35 | 221.65 | 221.23 | 221.62 | 9383.0 |
| 2024-12-24 08:00:00 | IWM | ETF | 221.4 | 222.0 | 221.0796 | 221.8 | 139346.0 |
| 2024-12-24 09:00:00 | IWM | ETF | 221.77 | 222.25 | 220.48 | 221.22 | 1617810.0 |
| 2024-12-24 10:00:00 | IWM | ETF | 221.18 | 222.77 | 221.03 | 222.74 | 2294711.0 |
| 2024-12-24 11:00:00 | IWM | ETF | 222.74 | 222.85 | 222.18 | 222.51 | 1427604.0 |
| 2024-12-24 12:00:00 | IWM | ETF | 222.49 | 223.63 | 222.432 | 223.47 | 2594828.0 |
| 2024-12-24 13:00:00 | IWM | ETF | 223.39 | 224.0 | 223.1 | 223.27 | 1397059.0 |
| 2024-12-24 14:00:00 | IWM | ETF | 223.33 | 223.4 | 223.26 | 223.4 | 5133.0 |
| 2024-12-24 15:00:00 | IWM | ETF | 223.3 | 223.46 | 223.16 | 223.2 | 21796.0 |
| 2024-12-24 16:00:00 | IWM | ETF | 223.23 | 223.37 | 223.17 | 223.17 | 4647.0 |
| 2024-12-24 04:00:00 | DIA | ETF | 429.03 | 429.16 | 428.96 | 429.16 | 1624.0 |
| 2024-12-24 05:00:00 | DIA | ETF | 429.09 | 429.12 | 429.09 | 429.12 | 600.0 |
| 2024-12-24 06:00:00 | DIA | ETF | 429.06 | 429.06 | 428.67 | 428.67 | 785.0 |
| 2024-12-24 07:00:00 | DIA | ETF | 428.79 | 428.84 | 428.73 | 428.73 | 1805.0 |
| 2024-12-24 08:00:00 | DIA | ETF | 428.74 | 429.0 | 428.67 | 428.77 | 3934.0 |
| 2024-12-24 09:00:00 | DIA | ETF | 428.74 | 429.315 | 428.28 | 429.07 | 292609.0 |
| 2024-12-24 10:00:00 | DIA | ETF | 429.1 | 431.18 | 429.09 | 431.05 | 227337.0 |
| 2024-12-24 11:00:00 | DIA | ETF | 431.11 | 431.55 | 430.56 | 430.9401 | 149092.0 |
| 2024-12-24 12:00:00 | DIA | ETF | 430.9201 | 432.63 | 430.8601 | 432.46 | 265004.0 |
| 2024-12-24 13:00:00 | DIA | ETF | 432.5 | 432.5 | 432.2 | 432.49 | 219014.0 |
| 2024-12-24 14:00:00 | DIA | ETF | 432.1 | 432.6 | 432.1 | 432.6 | 730.0 |
> showing 50 of 14,681 rows — these rows as CSV