PREVIEW / etf_1hour / 2025-03-19
file: by_date/etf_1hour/2025/2025-03-19.parquet size: 622 KB rows: 23,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 |
|---|---|---|---|---|---|---|---|
| 2025-03-19 04:00:00 | SPY | ETF | 562.09 | 562.09 | 560.13 | 561.55 | 27368.0 |
| 2025-03-19 05:00:00 | SPY | ETF | 561.26 | 562.5 | 560.87 | 562.5 | 13654.0 |
| 2025-03-19 06:00:00 | SPY | ETF | 562.5 | 562.8 | 562.18 | 562.34 | 26113.0 |
| 2025-03-19 07:00:00 | SPY | ETF | 562.35 | 562.86 | 561.88 | 562.55 | 116324.0 |
| 2025-03-19 08:00:00 | SPY | ETF | 562.3255 | 562.8686 | 560.26 | 562.1 | 237067.0 |
| 2025-03-19 09:00:00 | SPY | ETF | 562.08 | 564.45 | 561.63 | 563.92 | 3012467.0 |
| 2025-03-19 10:00:00 | SPY | ETF | 563.94 | 565.38 | 563.3009 | 563.52 | 3612145.0 |
| 2025-03-19 11:00:00 | SPY | ETF | 563.4997 | 566.29 | 563.35 | 565.78 | 2803164.0 |
| 2025-03-19 12:00:00 | SPY | ETF | 565.77 | 566.21 | 564.67 | 564.955 | 2084193.0 |
| 2025-03-19 13:00:00 | SPY | ETF | 564.95 | 565.166 | 562.72 | 563.18 | 2490897.0 |
| 2025-03-19 14:00:00 | SPY | ETF | 563.18 | 568.53 | 562.0 | 568.25 | 7513993.0 |
| 2025-03-19 15:00:00 | SPY | ETF | 568.24 | 570.95 | 566.5749 | 567.01 | 14234011.0 |
| 2025-03-19 16:00:00 | SPY | ETF | 567.02 | 567.73 | 566.8495 | 566.99 | 10133037.0 |
| 2025-03-19 17:00:00 | SPY | ETF | 567.0999 | 567.31 | 567.04 | 567.31 | 75305.0 |
| 2025-03-19 18:00:00 | SPY | ETF | 567.21 | 568.68 | 567.04 | 568.3 | 115601.0 |
| 2025-03-19 19:00:00 | SPY | ETF | 568.35 | 568.77 | 568.17 | 568.7 | 73428.0 |
| 2025-03-19 04:00:00 | QQQ | ETF | 474.77 | 475.78 | 474.01 | 475.35 | 54786.0 |
| 2025-03-19 05:00:00 | QQQ | ETF | 475.23 | 476.23 | 474.82 | 476.14 | 47768.0 |
| 2025-03-19 06:00:00 | QQQ | ETF | 476.25 | 476.68 | 475.81 | 476.02 | 64417.0 |
| 2025-03-19 07:00:00 | QQQ | ETF | 475.96 | 476.83 | 475.88 | 476.46 | 151797.0 |
| 2025-03-19 08:00:00 | QQQ | ETF | 476.46 | 476.78 | 473.98 | 476.25 | 189219.0 |
| 2025-03-19 09:00:00 | QQQ | ETF | 476.22 | 478.13 | 474.87 | 477.62 | 2677628.0 |
| 2025-03-19 10:00:00 | QQQ | ETF | 477.62 | 479.5 | 476.88 | 477.0515 | 2592368.0 |
| 2025-03-19 11:00:00 | QQQ | ETF | 477.05 | 480.4 | 476.89 | 479.961 | 2031117.0 |
| 2025-03-19 12:00:00 | QQQ | ETF | 479.98 | 480.3026 | 478.46 | 478.9208 | 1596140.0 |
| 2025-03-19 13:00:00 | QQQ | ETF | 478.94 | 479.15 | 476.79 | 477.37 | 2249338.0 |
| 2025-03-19 14:00:00 | QQQ | ETF | 477.25 | 482.605 | 476.57 | 482.5398 | 6411464.0 |
| 2025-03-19 15:00:00 | QQQ | ETF | 482.49 | 485.33 | 480.38 | 480.79 | 8649183.0 |
| 2025-03-19 16:00:00 | QQQ | ETF | 480.79 | 481.44 | 480.53 | 480.71 | 2185634.0 |
| 2025-03-19 17:00:00 | QQQ | ETF | 480.8 | 481.1 | 480.8 | 481.1 | 80112.0 |
| 2025-03-19 18:00:00 | QQQ | ETF | 481.02 | 482.56 | 480.77 | 482.17 | 102603.0 |
| 2025-03-19 19:00:00 | QQQ | ETF | 482.26 | 482.7 | 482.03 | 482.7 | 44675.0 |
| 2025-03-19 04:00:00 | IWM | ETF | 203.21 | 203.76 | 203.21 | 203.58 | 22503.0 |
| 2025-03-19 05:00:00 | IWM | ETF | 203.42 | 203.8 | 203.37 | 203.8 | 6405.0 |
| 2025-03-19 06:00:00 | IWM | ETF | 203.86 | 204.02 | 203.78 | 203.78 | 8015.0 |
| 2025-03-19 07:00:00 | IWM | ETF | 203.88 | 204.03 | 203.56 | 203.72 | 37287.0 |
| 2025-03-19 08:00:00 | IWM | ETF | 203.67 | 203.9698 | 203.0 | 203.38 | 73505.0 |
| 2025-03-19 09:00:00 | IWM | ETF | 203.39 | 204.58 | 203.16 | 204.08 | 2301565.0 |
| 2025-03-19 10:00:00 | IWM | ETF | 204.11 | 204.99 | 204.03 | 204.6 | 2186552.0 |
| 2025-03-19 11:00:00 | IWM | ETF | 204.58 | 205.155 | 204.34 | 204.995 | 2230316.0 |
| 2025-03-19 12:00:00 | IWM | ETF | 204.99 | 205.2883 | 204.7727 | 204.8599 | 1417163.0 |
| 2025-03-19 13:00:00 | IWM | ETF | 204.84 | 204.98 | 203.8648 | 203.93 | 1589590.0 |
| 2025-03-19 14:00:00 | IWM | ETF | 203.9 | 207.03 | 202.9 | 206.91 | 5012568.0 |
| 2025-03-19 15:00:00 | IWM | ETF | 206.87 | 207.68 | 205.5919 | 206.39 | 6260926.0 |
| 2025-03-19 16:00:00 | IWM | ETF | 206.37 | 206.66 | 206.37 | 206.41 | 1393095.0 |
| 2025-03-19 17:00:00 | IWM | ETF | 206.39 | 206.75 | 206.39 | 206.67 | 42900.0 |
| 2025-03-19 18:00:00 | IWM | ETF | 206.59 | 207.19 | 206.5 | 207.07 | 32874.0 |
| 2025-03-19 19:00:00 | IWM | ETF | 207.08 | 207.279 | 206.95 | 207.279 | 19971.0 |
| 2025-03-19 04:00:00 | DIA | ETF | 416.36 | 416.81 | 416.25 | 416.81 | 1382.0 |
| 2025-03-19 05:00:00 | DIA | ETF | 416.31 | 417.29 | 416.31 | 417.29 | 900.0 |
> showing 50 of 23,681 rows — these rows as CSV