PREVIEW / etf_1hour / 2025-04-07
file: by_date/etf_1hour/2025/2025-04-07.parquet size: 727 KB rows: 28,979
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-04-07 04:00:00 | SPY | ETF | 486.9 | 491.09 | 482.96 | 487.87 | 690248.0 |
| 2025-04-07 05:00:00 | SPY | ETF | 487.77 | 490.62 | 484.83 | 488.8 | 390107.0 |
| 2025-04-07 06:00:00 | SPY | ETF | 488.83 | 498.9 | 487.69 | 494.81 | 1179788.0 |
| 2025-04-07 07:00:00 | SPY | ETF | 494.66 | 498.58 | 492.09 | 493.47 | 1387112.0 |
| 2025-04-07 08:00:00 | SPY | ETF | 493.41 | 498.78 | 480.0 | 496.11 | 5693335.0 |
| 2025-04-07 09:00:00 | SPY | ETF | 496.07 | 496.46 | 481.8 | 495.69 | 24758801.0 |
| 2025-04-07 10:00:00 | SPY | ETF | 495.67 | 523.17 | 493.37 | 505.91 | 61949890.0 |
| 2025-04-07 11:00:00 | SPY | ETF | 505.88 | 509.77 | 492.66 | 499.5 | 30041339.0 |
| 2025-04-07 12:00:00 | SPY | ETF | 499.5 | 501.77 | 494.7 | 495.68 | 10880440.0 |
| 2025-04-07 13:00:00 | SPY | ETF | 495.63 | 509.36 | 495.59 | 509.09 | 16857927.0 |
| 2025-04-07 14:00:00 | SPY | ETF | 509.07 | 510.47 | 502.28 | 503.21 | 11932923.0 |
| 2025-04-07 15:00:00 | SPY | ETF | 503.25 | 506.64 | 500.14 | 504.55 | 23779687.0 |
| 2025-04-07 16:00:00 | SPY | ETF | 504.55 | 509.14 | 503.83 | 506.45 | 9855358.0 |
| 2025-04-07 17:00:00 | SPY | ETF | 506.49 | 507.5 | 506.35 | 507.1101 | 442660.0 |
| 2025-04-07 18:00:00 | SPY | ETF | 507.17 | 509.1 | 506.66 | 509.1 | 404406.0 |
| 2025-04-07 19:00:00 | SPY | ETF | 509.1 | 510.24 | 508.95 | 509.53 | 270626.0 |
| 2025-04-07 04:00:00 | QQQ | ETF | 402.67 | 409.37 | 400.0 | 406.68 | 612796.0 |
| 2025-04-07 05:00:00 | QQQ | ETF | 406.61 | 409.26 | 404.36 | 407.64 | 382253.0 |
| 2025-04-07 06:00:00 | QQQ | ETF | 407.87 | 417.07 | 406.99 | 413.17 | 518099.0 |
| 2025-04-07 07:00:00 | QQQ | ETF | 413.4 | 415.99 | 410.5 | 411.89 | 724291.0 |
| 2025-04-07 08:00:00 | QQQ | ETF | 412.42 | 422.987 | 396.0 | 414.5 | 4056021.0 |
| 2025-04-07 09:00:00 | QQQ | ETF | 414.14 | 417.48 | 402.39 | 416.89 | 17975056.0 |
| 2025-04-07 10:00:00 | QQQ | ETF | 416.89 | 443.14 | 414.295 | 426.24 | 42465879.0 |
| 2025-04-07 11:00:00 | QQQ | ETF | 426.2 | 429.63 | 414.06 | 419.76 | 19126087.0 |
| 2025-04-07 12:00:00 | QQQ | ETF | 419.8 | 422.36 | 415.57 | 416.52 | 8122931.0 |
| 2025-04-07 13:00:00 | QQQ | ETF | 416.49 | 429.49 | 416.37 | 429.18 | 11281836.0 |
| 2025-04-07 14:00:00 | QQQ | ETF | 429.26 | 430.16 | 422.29 | 423.15 | 7821114.0 |
| 2025-04-07 15:00:00 | QQQ | ETF | 423.15 | 426.26 | 420.145 | 423.95 | 10754211.0 |
| 2025-04-07 16:00:00 | QQQ | ETF | 423.96 | 428.62 | 423.52 | 425.77 | 3131944.0 |
| 2025-04-07 17:00:00 | QQQ | ETF | 425.62 | 426.85 | 425.35 | 426.7 | 143637.0 |
| 2025-04-07 18:00:00 | QQQ | ETF | 426.7 | 428.58 | 426.01 | 428.58 | 263495.0 |
| 2025-04-07 19:00:00 | QQQ | ETF | 428.55 | 429.22 | 427.94 | 428.86 | 362357.0 |
| 2025-04-07 04:00:00 | IWM | ETF | 174.63 | 175.1 | 172.55 | 173.36 | 135081.0 |
| 2025-04-07 05:00:00 | IWM | ETF | 173.35 | 175.0 | 172.37 | 173.66 | 282853.0 |
| 2025-04-07 06:00:00 | IWM | ETF | 173.69 | 177.66 | 173.26 | 175.83 | 345068.0 |
| 2025-04-07 07:00:00 | IWM | ETF | 175.71 | 177.58 | 175.11 | 175.76 | 241809.0 |
| 2025-04-07 08:00:00 | IWM | ETF | 177.24 | 177.55 | 170.83 | 176.94 | 1086518.0 |
| 2025-04-07 09:00:00 | IWM | ETF | 177.13 | 177.32 | 171.73 | 177.03 | 9877514.0 |
| 2025-04-07 10:00:00 | IWM | ETF | 177.01 | 190.25 | 176.031 | 181.25 | 26082782.0 |
| 2025-04-07 11:00:00 | IWM | ETF | 181.28 | 183.08 | 175.66 | 178.79 | 13203473.0 |
| 2025-04-07 12:00:00 | IWM | ETF | 178.77 | 179.56 | 176.33 | 176.67 | 4625315.0 |
| 2025-04-07 13:00:00 | IWM | ETF | 176.65 | 182.34 | 176.64 | 181.93 | 7377856.0 |
| 2025-04-07 14:00:00 | IWM | ETF | 181.93 | 182.28 | 178.445 | 178.665 | 6206091.0 |
| 2025-04-07 15:00:00 | IWM | ETF | 178.67 | 181.0 | 178.44 | 179.59 | 9036968.0 |
| 2025-04-07 16:00:00 | IWM | ETF | 179.6 | 182.7971 | 179.42 | 180.5 | 1993507.0 |
| 2025-04-07 17:00:00 | IWM | ETF | 180.11 | 180.87 | 180.11 | 180.86 | 7042.0 |
| 2025-04-07 18:00:00 | IWM | ETF | 180.86 | 181.539 | 180.55 | 181.53 | 16641.0 |
| 2025-04-07 19:00:00 | IWM | ETF | 181.5597 | 182.02 | 181.33 | 181.5601 | 36732.0 |
| 2025-04-07 04:00:00 | DIA | ETF | 368.01 | 372.26 | 367.7 | 370.33 | 25138.0 |
| 2025-04-07 05:00:00 | DIA | ETF | 370.0 | 372.1 | 368.09 | 371.58 | 7755.0 |
> showing 50 of 28,979 rows — these rows as CSV