PREVIEW / etf_1hour / 2025-04-14
file: by_date/etf_1hour/2025/2025-04-14.parquet size: 657 KB rows: 25,665
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-14 04:00:00 | SPY | ETF | 540.0 | 542.04 | 540.0 | 541.59 | 70977.0 |
| 2025-04-14 05:00:00 | SPY | ETF | 541.57 | 542.2 | 539.26 | 540.16 | 52196.0 |
| 2025-04-14 06:00:00 | SPY | ETF | 540.47 | 541.42 | 539.78 | 541.34 | 52199.0 |
| 2025-04-14 07:00:00 | SPY | ETF | 541.36 | 542.99 | 540.0 | 540.03 | 453247.0 |
| 2025-04-14 08:00:00 | SPY | ETF | 541.75 | 542.9 | 538.59 | 542.73 | 529286.0 |
| 2025-04-14 09:00:00 | SPY | ETF | 542.69 | 544.48 | 539.21 | 540.47 | 7603731.0 |
| 2025-04-14 10:00:00 | SPY | ETF | 540.63 | 543.85 | 539.71 | 542.42 | 6192412.0 |
| 2025-04-14 11:00:00 | SPY | ETF | 542.435 | 543.09 | 535.23 | 535.74 | 7611005.0 |
| 2025-04-14 12:00:00 | SPY | ETF | 535.725 | 537.92 | 533.86 | 535.52 | 6779808.0 |
| 2025-04-14 13:00:00 | SPY | ETF | 535.6 | 539.45 | 535.29 | 538.97 | 4574809.0 |
| 2025-04-14 14:00:00 | SPY | ETF | 538.95 | 541.31 | 538.81 | 540.73 | 4207671.0 |
| 2025-04-14 15:00:00 | SPY | ETF | 540.77 | 542.58 | 538.36 | 538.97 | 11116788.0 |
| 2025-04-14 16:00:00 | SPY | ETF | 538.98 | 539.47 | 535.39 | 538.05 | 3238982.0 |
| 2025-04-14 17:00:00 | SPY | ETF | 538.06 | 538.45 | 537.53 | 538.2 | 145964.0 |
| 2025-04-14 18:00:00 | SPY | ETF | 538.15 | 538.21 | 536.22 | 536.3 | 247860.0 |
| 2025-04-14 19:00:00 | SPY | ETF | 536.34 | 537.5 | 536.29 | 536.9 | 72178.0 |
| 2025-04-14 04:00:00 | QQQ | ETF | 462.66 | 463.24 | 461.22 | 461.79 | 185404.0 |
| 2025-04-14 05:00:00 | QQQ | ETF | 461.77 | 462.34 | 459.5 | 460.44 | 88183.0 |
| 2025-04-14 06:00:00 | QQQ | ETF | 460.54 | 461.39 | 460.0 | 461.36 | 59450.0 |
| 2025-04-14 07:00:00 | QQQ | ETF | 461.42 | 463.09 | 460.6 | 460.68 | 374192.0 |
| 2025-04-14 08:00:00 | QQQ | ETF | 461.61 | 463.59 | 454.06 | 463.37 | 467468.0 |
| 2025-04-14 09:00:00 | QQQ | ETF | 463.13 | 465.06 | 458.6318 | 460.03 | 5259226.0 |
| 2025-04-14 10:00:00 | QQQ | ETF | 460.07 | 463.55 | 459.665 | 462.0236 | 4113363.0 |
| 2025-04-14 11:00:00 | QQQ | ETF | 461.99 | 462.56 | 454.17 | 454.7501 | 4861473.0 |
| 2025-04-14 12:00:00 | QQQ | ETF | 454.81 | 456.46 | 452.63 | 453.72 | 3708908.0 |
| 2025-04-14 13:00:00 | QQQ | ETF | 453.76 | 457.72 | 453.49 | 457.46 | 2873780.0 |
| 2025-04-14 14:00:00 | QQQ | ETF | 457.45 | 459.94 | 457.35 | 459.23 | 2671730.0 |
| 2025-04-14 15:00:00 | QQQ | ETF | 459.17 | 461.14 | 456.93 | 457.41 | 4446148.0 |
| 2025-04-14 16:00:00 | QQQ | ETF | 457.4 | 457.88 | 453.88 | 456.57 | 1833898.0 |
| 2025-04-14 17:00:00 | QQQ | ETF | 456.55 | 457.286 | 456.0 | 456.4194 | 369850.0 |
| 2025-04-14 18:00:00 | QQQ | ETF | 456.34 | 456.6 | 454.37 | 454.4599 | 83788.0 |
| 2025-04-14 19:00:00 | QQQ | ETF | 454.4001 | 455.93 | 454.4 | 455.2683 | 145974.0 |
| 2025-04-14 04:00:00 | IWM | ETF | 185.45 | 186.08 | 185.0 | 186.08 | 54522.0 |
| 2025-04-14 05:00:00 | IWM | ETF | 186.03 | 186.51 | 185.09 | 185.17 | 54599.0 |
| 2025-04-14 06:00:00 | IWM | ETF | 185.48 | 186.02 | 185.29 | 185.98 | 40969.0 |
| 2025-04-14 07:00:00 | IWM | ETF | 186.09 | 186.62 | 185.73 | 185.75 | 122693.0 |
| 2025-04-14 08:00:00 | IWM | ETF | 186.4 | 187.14 | 184.85 | 187.04 | 86204.0 |
| 2025-04-14 09:00:00 | IWM | ETF | 187.0 | 187.97 | 184.72 | 185.79 | 4601848.0 |
| 2025-04-14 10:00:00 | IWM | ETF | 185.83 | 187.28 | 185.35 | 186.74 | 3386131.0 |
| 2025-04-14 11:00:00 | IWM | ETF | 186.72 | 187.0 | 183.35 | 183.55 | 3917647.0 |
| 2025-04-14 12:00:00 | IWM | ETF | 183.54 | 185.055 | 183.05 | 184.215 | 2944809.0 |
| 2025-04-14 13:00:00 | IWM | ETF | 184.21 | 185.92 | 184.16 | 185.36 | 2237230.0 |
| 2025-04-14 14:00:00 | IWM | ETF | 185.36 | 186.76 | 185.29 | 186.56 | 1671366.0 |
| 2025-04-14 15:00:00 | IWM | ETF | 186.54 | 187.41 | 186.485 | 186.56 | 4693892.0 |
| 2025-04-14 16:00:00 | IWM | ETF | 186.53 | 186.81 | 185.13 | 186.34 | 1574048.0 |
| 2025-04-14 17:00:00 | IWM | ETF | 186.23 | 186.4893 | 186.19 | 186.32 | 20216.0 |
| 2025-04-14 18:00:00 | IWM | ETF | 186.32 | 186.33 | 185.6004 | 185.66 | 17766.0 |
| 2025-04-14 19:00:00 | IWM | ETF | 185.71 | 186.0104 | 185.6 | 185.81 | 7950.0 |
| 2025-04-14 04:00:00 | DIA | ETF | 405.48 | 406.2 | 405.31 | 406.17 | 4856.0 |
| 2025-04-14 05:00:00 | DIA | ETF | 405.89 | 405.89 | 405.37 | 405.37 | 1500.0 |
> showing 50 of 25,665 rows — these rows as CSV