PREVIEW / etf_1hour / 2025-03-11
file: by_date/etf_1hour/2025/2025-03-11.parquet size: 655 KB rows: 25,348
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-11 04:00:00 | SPY | ETF | 561.79 | 562.85 | 561.31 | 562.81 | 66431.0 |
| 2025-03-11 05:00:00 | SPY | ETF | 562.78 | 563.11 | 562.2 | 562.53 | 86194.0 |
| 2025-03-11 06:00:00 | SPY | ETF | 562.59 | 562.89 | 561.7 | 562.4 | 111362.0 |
| 2025-03-11 07:00:00 | SPY | ETF | 562.37 | 563.75 | 561.2 | 563.58 | 244324.0 |
| 2025-03-11 08:00:00 | SPY | ETF | 562.32 | 563.6 | 560.1 | 560.5 | 648017.0 |
| 2025-03-11 09:00:00 | SPY | ETF | 560.37 | 561.74 | 558.3 | 559.79 | 5611310.0 |
| 2025-03-11 10:00:00 | SPY | ETF | 559.75 | 562.12 | 554.05 | 554.77 | 10560749.0 |
| 2025-03-11 11:00:00 | SPY | ETF | 554.74 | 559.98 | 554.17 | 557.17 | 6512666.0 |
| 2025-03-11 12:00:00 | SPY | ETF | 557.15 | 557.65 | 553.57 | 554.32 | 4912273.0 |
| 2025-03-11 13:00:00 | SPY | ETF | 554.3199 | 555.39 | 552.02 | 554.28 | 5805910.0 |
| 2025-03-11 14:00:00 | SPY | ETF | 554.26 | 562.87 | 554.14 | 561.546 | 9402616.0 |
| 2025-03-11 15:00:00 | SPY | ETF | 561.55 | 564.02 | 556.01 | 556.12 | 12970337.0 |
| 2025-03-11 16:00:00 | SPY | ETF | 556.1198 | 557.45 | 555.8 | 556.27 | 5295870.0 |
| 2025-03-11 17:00:00 | SPY | ETF | 556.22 | 556.53 | 556.0945 | 556.36 | 302627.0 |
| 2025-03-11 18:00:00 | SPY | ETF | 556.36 | 558.0 | 556.08 | 557.78 | 107332.0 |
| 2025-03-11 19:00:00 | SPY | ETF | 557.6 | 557.87 | 556.8 | 557.8 | 110191.0 |
| 2025-03-11 04:00:00 | QQQ | ETF | 474.48 | 475.89 | 473.48 | 475.85 | 218650.0 |
| 2025-03-11 05:00:00 | QQQ | ETF | 475.86 | 476.23 | 475.08 | 475.35 | 150494.0 |
| 2025-03-11 06:00:00 | QQQ | ETF | 475.29 | 475.71 | 474.49 | 475.18 | 101345.0 |
| 2025-03-11 07:00:00 | QQQ | ETF | 475.05 | 476.12 | 473.59 | 476.09 | 250644.0 |
| 2025-03-11 08:00:00 | QQQ | ETF | 476.04 | 476.2 | 472.0 | 473.1098 | 746596.0 |
| 2025-03-11 09:00:00 | QQQ | ETF | 473.11 | 476.69 | 471.4915 | 474.82 | 5852777.0 |
| 2025-03-11 10:00:00 | QQQ | ETF | 474.79 | 477.08 | 468.54 | 469.73 | 9644736.0 |
| 2025-03-11 11:00:00 | QQQ | ETF | 469.63 | 475.35 | 469.06 | 472.4 | 6314322.0 |
| 2025-03-11 12:00:00 | QQQ | ETF | 472.37 | 472.97 | 469.31 | 469.96 | 4224405.0 |
| 2025-03-11 13:00:00 | QQQ | ETF | 469.935 | 471.0543 | 467.01 | 469.99 | 5477042.0 |
| 2025-03-11 14:00:00 | QQQ | ETF | 470.01 | 478.805 | 469.86 | 477.64 | 7558533.0 |
| 2025-03-11 15:00:00 | QQQ | ETF | 477.65 | 478.585 | 471.61 | 471.67 | 8232312.0 |
| 2025-03-11 16:00:00 | QQQ | ETF | 471.62 | 474.3221 | 471.15 | 471.89 | 2848356.0 |
| 2025-03-11 17:00:00 | QQQ | ETF | 471.82 | 472.09 | 471.6 | 472.09 | 52036.0 |
| 2025-03-11 18:00:00 | QQQ | ETF | 472.11 | 473.68 | 471.93 | 473.48 | 178903.0 |
| 2025-03-11 19:00:00 | QQQ | ETF | 473.45 | 473.6999 | 472.49 | 473.6401 | 98157.0 |
| 2025-03-11 04:00:00 | IWM | ETF | 201.93 | 202.6 | 201.69 | 202.51 | 41664.0 |
| 2025-03-11 05:00:00 | IWM | ETF | 202.56 | 202.98 | 202.48 | 202.78 | 16586.0 |
| 2025-03-11 06:00:00 | IWM | ETF | 202.78 | 202.94 | 202.39 | 202.65 | 47654.0 |
| 2025-03-11 07:00:00 | IWM | ETF | 202.68 | 202.86 | 202.35 | 202.75 | 219048.0 |
| 2025-03-11 08:00:00 | IWM | ETF | 202.48 | 202.84 | 201.27 | 201.9 | 423822.0 |
| 2025-03-11 09:00:00 | IWM | ETF | 201.91 | 202.52 | 200.53 | 201.41 | 4013197.0 |
| 2025-03-11 10:00:00 | IWM | ETF | 201.43 | 202.66 | 198.7846 | 199.32 | 7034543.0 |
| 2025-03-11 11:00:00 | IWM | ETF | 199.27 | 201.61 | 199.08 | 200.46 | 3707697.0 |
| 2025-03-11 12:00:00 | IWM | ETF | 200.44 | 200.78 | 199.38 | 199.56 | 2515899.0 |
| 2025-03-11 13:00:00 | IWM | ETF | 199.54 | 200.08 | 198.53 | 199.43 | 3436871.0 |
| 2025-03-11 14:00:00 | IWM | ETF | 199.42 | 203.16 | 199.36 | 202.7 | 5199618.0 |
| 2025-03-11 15:00:00 | IWM | ETF | 202.73 | 203.22 | 200.78 | 200.79 | 7578460.0 |
| 2025-03-11 16:00:00 | IWM | ETF | 200.75 | 201.66 | 200.66 | 201.21 | 2125056.0 |
| 2025-03-11 17:00:00 | IWM | ETF | 201.12 | 201.34 | 200.92 | 201.14 | 23087.0 |
| 2025-03-11 18:00:00 | IWM | ETF | 201.1 | 201.76 | 200.479 | 201.62 | 217873.0 |
| 2025-03-11 19:00:00 | IWM | ETF | 201.57 | 201.74 | 201.27 | 201.68 | 61363.0 |
| 2025-03-11 04:00:00 | DIA | ETF | 420.75 | 420.8 | 420.49 | 420.75 | 1747.0 |
| 2025-03-11 05:00:00 | DIA | ETF | 421.01 | 421.01 | 420.6 | 420.69 | 1659.0 |
> showing 50 of 25,348 rows — these rows as CSV