PREVIEW / etf_1hour / 2024-11-25
file: by_date/etf_1hour/2024/2024-11-25.parquet size: 630 KB rows: 23,655
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-11-25 04:00:00 | SPY | ETF | 598.01 | 598.64 | 598.01 | 598.57 | 29187.0 |
| 2024-11-25 05:00:00 | SPY | ETF | 598.52 | 598.79 | 598.43 | 598.77 | 12421.0 |
| 2024-11-25 06:00:00 | SPY | ETF | 598.79 | 598.79 | 598.45 | 598.62 | 114463.0 |
| 2024-11-25 07:00:00 | SPY | ETF | 598.61 | 598.69 | 598.03 | 598.56 | 329375.0 |
| 2024-11-25 08:00:00 | SPY | ETF | 598.625 | 600.045 | 597.88 | 599.65 | 533265.0 |
| 2024-11-25 09:00:00 | SPY | ETF | 599.63 | 600.86 | 598.67 | 599.26 | 5943311.0 |
| 2024-11-25 10:00:00 | SPY | ETF | 599.25 | 599.295 | 597.55 | 597.98 | 4527651.0 |
| 2024-11-25 11:00:00 | SPY | ETF | 597.96 | 598.43 | 597.14 | 597.27 | 2579916.0 |
| 2024-11-25 12:00:00 | SPY | ETF | 597.255 | 597.6 | 595.2 | 596.4565 | 3099224.0 |
| 2024-11-25 13:00:00 | SPY | ETF | 596.4601 | 597.61 | 596.421 | 597.32 | 2101124.0 |
| 2024-11-25 14:00:00 | SPY | ETF | 597.31 | 597.45 | 596.49 | 597.09 | 1760062.0 |
| 2024-11-25 15:00:00 | SPY | ETF | 597.085 | 597.745 | 596.67 | 597.45 | 5845433.0 |
| 2024-11-25 16:00:00 | SPY | ETF | 597.45 | 598.39 | 597.08 | 598.1 | 3525690.0 |
| 2024-11-25 17:00:00 | SPY | ETF | 598.09 | 598.11 | 597.95 | 598.04 | 47450.0 |
| 2024-11-25 18:00:00 | SPY | ETF | 598.1 | 598.65 | 595.63 | 596.31 | 316811.0 |
| 2024-11-25 19:00:00 | SPY | ETF | 596.2 | 596.24 | 595.24 | 595.27 | 194299.0 |
| 2024-11-25 04:00:00 | QQQ | ETF | 508.57 | 508.85 | 508.26 | 508.75 | 98448.0 |
| 2024-11-25 05:00:00 | QQQ | ETF | 508.79 | 509.09 | 508.66 | 509.09 | 68868.0 |
| 2024-11-25 06:00:00 | QQQ | ETF | 509.04 | 509.09 | 508.7 | 508.72 | 23148.0 |
| 2024-11-25 07:00:00 | QQQ | ETF | 508.69 | 508.84 | 508.221 | 508.44 | 146932.0 |
| 2024-11-25 08:00:00 | QQQ | ETF | 508.65 | 510.16 | 505.411 | 509.53 | 419276.0 |
| 2024-11-25 09:00:00 | QQQ | ETF | 509.54 | 511.4525 | 507.58 | 508.22 | 4051059.0 |
| 2024-11-25 10:00:00 | QQQ | ETF | 508.2201 | 508.52 | 506.44 | 507.0713 | 3584234.0 |
| 2024-11-25 11:00:00 | QQQ | ETF | 507.05 | 508.61 | 506.89 | 507.3 | 1749434.0 |
| 2024-11-25 12:00:00 | QQQ | ETF | 507.3 | 507.39 | 504.2625 | 505.95 | 2701113.0 |
| 2024-11-25 13:00:00 | QQQ | ETF | 505.97 | 506.88 | 505.74 | 505.9675 | 1614397.0 |
| 2024-11-25 14:00:00 | QQQ | ETF | 505.98 | 506.62 | 505.34 | 506.21 | 1121926.0 |
| 2024-11-25 15:00:00 | QQQ | ETF | 506.21 | 506.765 | 505.6 | 506.57 | 2980406.0 |
| 2024-11-25 16:00:00 | QQQ | ETF | 506.59 | 507.49 | 506.23 | 507.09 | 944104.0 |
| 2024-11-25 17:00:00 | QQQ | ETF | 507.04 | 507.14 | 506.92 | 506.95 | 35324.0 |
| 2024-11-25 18:00:00 | QQQ | ETF | 507.13 | 507.9 | 504.68 | 505.49 | 255015.0 |
| 2024-11-25 19:00:00 | QQQ | ETF | 505.3 | 505.6399 | 504.44 | 504.61 | 140416.0 |
| 2024-11-25 04:00:00 | IWM | ETF | 241.0 | 241.99 | 240.94 | 241.99 | 66233.0 |
| 2024-11-25 05:00:00 | IWM | ETF | 241.8 | 241.8 | 241.43 | 241.47 | 60553.0 |
| 2024-11-25 06:00:00 | IWM | ETF | 241.43 | 241.54 | 241.18 | 241.35 | 70403.0 |
| 2024-11-25 07:00:00 | IWM | ETF | 241.32 | 241.36 | 240.5 | 241.18 | 160866.0 |
| 2024-11-25 08:00:00 | IWM | ETF | 241.35 | 242.31 | 240.5 | 242.17 | 402760.0 |
| 2024-11-25 09:00:00 | IWM | ETF | 242.07 | 243.16 | 241.38 | 242.18 | 3510116.0 |
| 2024-11-25 10:00:00 | IWM | ETF | 242.18 | 244.98 | 241.62 | 244.905 | 4138424.0 |
| 2024-11-25 11:00:00 | IWM | ETF | 244.9 | 244.9101 | 242.97 | 243.64 | 2856054.0 |
| 2024-11-25 12:00:00 | IWM | ETF | 243.6365 | 243.9 | 242.18 | 243.01 | 2660801.0 |
| 2024-11-25 13:00:00 | IWM | ETF | 243.0199 | 243.92 | 242.99 | 243.765 | 1631006.0 |
| 2024-11-25 14:00:00 | IWM | ETF | 243.765 | 244.22 | 243.48 | 243.584 | 1601324.0 |
| 2024-11-25 15:00:00 | IWM | ETF | 243.58 | 243.6699 | 242.36 | 242.36 | 4148945.0 |
| 2024-11-25 16:00:00 | IWM | ETF | 242.4 | 242.75 | 242.25 | 242.6401 | 3248929.0 |
| 2024-11-25 17:00:00 | IWM | ETF | 242.65 | 242.73 | 242.43 | 242.62 | 40389.0 |
| 2024-11-25 18:00:00 | IWM | ETF | 242.65 | 243.0 | 239.66 | 239.89 | 181231.0 |
| 2024-11-25 19:00:00 | IWM | ETF | 239.9 | 240.62 | 239.33 | 240.1 | 241488.0 |
| 2024-11-25 04:00:00 | DIA | ETF | 445.64 | 446.25 | 445.64 | 446.24 | 1496.0 |
| 2024-11-25 05:00:00 | DIA | ETF | 446.22 | 446.31 | 446.22 | 446.26 | 978.0 |
> showing 50 of 23,655 rows — these rows as CSV