PREVIEW / etf_1hour / 2024-07-03
file: by_date/etf_1hour/2024/2024-07-03.parquet size: 382 KB rows: 13,394
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-07-03 04:00:00 | SPY | ETF | 548.71 | 549.41 | 548.66 | 549.29 | 13918.0 |
| 2024-07-03 05:00:00 | SPY | ETF | 549.19 | 549.32 | 549.14 | 549.26 | 10459.0 |
| 2024-07-03 06:00:00 | SPY | ETF | 549.23 | 549.36 | 549.09 | 549.24 | 31156.0 |
| 2024-07-03 07:00:00 | SPY | ETF | 549.17 | 549.3 | 548.91 | 549.1 | 91081.0 |
| 2024-07-03 08:00:00 | SPY | ETF | 549.24 | 549.3 | 548.27 | 548.44 | 239394.0 |
| 2024-07-03 09:00:00 | SPY | ETF | 548.43 | 549.63 | 548.39 | 549.58 | 2851527.0 |
| 2024-07-03 10:00:00 | SPY | ETF | 549.58 | 550.11 | 548.88 | 549.8105 | 4245431.0 |
| 2024-07-03 11:00:00 | SPY | ETF | 549.81 | 550.49 | 549.48 | 550.385 | 3021680.0 |
| 2024-07-03 12:00:00 | SPY | ETF | 550.39 | 551.83 | 550.32 | 551.38 | 8275970.0 |
| 2024-07-03 13:00:00 | SPY | ETF | 551.38 | 551.6224 | 550.85 | 550.91 | 2290794.0 |
| 2024-07-03 14:00:00 | SPY | ETF | 550.87 | 551.25 | 550.51 | 551.16 | 172628.0 |
| 2024-07-03 15:00:00 | SPY | ETF | 551.16 | 551.16 | 550.86 | 550.86 | 29997.0 |
| 2024-07-03 16:00:00 | SPY | ETF | 550.86 | 551.31 | 550.5 | 551.14 | 43282.0 |
| 2024-07-03 04:00:00 | QQQ | ETF | 486.75 | 487.74 | 486.6 | 487.55 | 57099.0 |
| 2024-07-03 05:00:00 | QQQ | ETF | 487.4 | 487.62 | 487.2 | 487.46 | 28831.0 |
| 2024-07-03 06:00:00 | QQQ | ETF | 487.36 | 487.51 | 487.18 | 487.18 | 33002.0 |
| 2024-07-03 07:00:00 | QQQ | ETF | 487.15 | 487.33 | 486.75 | 487.06 | 84914.0 |
| 2024-07-03 08:00:00 | QQQ | ETF | 487.07 | 487.6596 | 485.96 | 486.25 | 231033.0 |
| 2024-07-03 09:00:00 | QQQ | ETF | 486.27 | 487.86 | 486.02 | 487.69 | 2299099.0 |
| 2024-07-03 10:00:00 | QQQ | ETF | 487.69 | 488.75 | 486.7 | 488.555 | 3176904.0 |
| 2024-07-03 11:00:00 | QQQ | ETF | 488.57 | 490.19 | 488.0701 | 490.13 | 2472297.0 |
| 2024-07-03 12:00:00 | QQQ | ETF | 490.11 | 491.17 | 489.89 | 491.01 | 4963107.0 |
| 2024-07-03 13:00:00 | QQQ | ETF | 491.01 | 491.45 | 490.58 | 490.98 | 861257.0 |
| 2024-07-03 14:00:00 | QQQ | ETF | 490.98 | 491.1 | 490.78 | 490.9001 | 62362.0 |
| 2024-07-03 15:00:00 | QQQ | ETF | 490.9601 | 491.09 | 490.47 | 490.47 | 33137.0 |
| 2024-07-03 16:00:00 | QQQ | ETF | 490.43 | 490.98 | 490.43 | 490.8261 | 21620.0 |
| 2024-07-03 04:00:00 | IWM | ETF | 201.97 | 202.17 | 201.9 | 202.04 | 5851.0 |
| 2024-07-03 05:00:00 | IWM | ETF | 201.98 | 202.09 | 201.98 | 202.09 | 3100.0 |
| 2024-07-03 06:00:00 | IWM | ETF | 202.27 | 202.57 | 202.21 | 202.4 | 38094.0 |
| 2024-07-03 07:00:00 | IWM | ETF | 202.4 | 202.66 | 202.29 | 202.65 | 50117.0 |
| 2024-07-03 08:00:00 | IWM | ETF | 202.3611 | 202.7 | 201.62 | 202.39 | 110051.0 |
| 2024-07-03 09:00:00 | IWM | ETF | 202.38 | 202.61 | 201.63 | 202.14 | 1757017.0 |
| 2024-07-03 10:00:00 | IWM | ETF | 202.16 | 203.28 | 201.98 | 202.02 | 3377871.0 |
| 2024-07-03 11:00:00 | IWM | ETF | 202.01 | 202.26 | 201.74 | 201.9751 | 1854925.0 |
| 2024-07-03 12:00:00 | IWM | ETF | 201.965 | 202.22 | 201.69 | 201.8 | 3157046.0 |
| 2024-07-03 13:00:00 | IWM | ETF | 201.78 | 202.29 | 201.62 | 202.05 | 2052014.0 |
| 2024-07-03 14:00:00 | IWM | ETF | 202.04 | 202.26 | 202.0 | 202.15 | 48608.0 |
| 2024-07-03 15:00:00 | IWM | ETF | 202.13 | 202.13 | 201.9 | 201.95 | 37822.0 |
| 2024-07-03 16:00:00 | IWM | ETF | 202.05 | 202.09 | 201.88 | 202.04 | 11387.0 |
| 2024-07-03 04:00:00 | DIA | ETF | 393.71 | 393.72 | 393.68 | 393.72 | 2200.0 |
| 2024-07-03 05:00:00 | DIA | ETF | 393.75 | 393.75 | 393.7 | 393.74 | 2279.0 |
| 2024-07-03 07:00:00 | DIA | ETF | 393.84 | 393.84 | 393.68 | 393.68 | 1919.0 |
| 2024-07-03 08:00:00 | DIA | ETF | 393.86 | 393.8896 | 392.98 | 393.23 | 3890.0 |
| 2024-07-03 09:00:00 | DIA | ETF | 393.4183 | 394.055 | 392.78 | 393.38 | 502671.0 |
| 2024-07-03 10:00:00 | DIA | ETF | 393.46 | 393.89 | 392.27 | 392.49 | 309118.0 |
| 2024-07-03 11:00:00 | DIA | ETF | 392.462 | 392.9099 | 392.22 | 392.31 | 200469.0 |
| 2024-07-03 12:00:00 | DIA | ETF | 392.28 | 393.23 | 392.1401 | 392.86 | 637812.0 |
| 2024-07-03 13:00:00 | DIA | ETF | 392.87 | 393.4994 | 392.75 | 392.75 | 15952.0 |
| 2024-07-03 14:00:00 | DIA | ETF | 392.83 | 392.83 | 392.83 | 392.83 | 100.0 |
| 2024-07-03 15:00:00 | DIA | ETF | 392.83 | 392.83 | 392.5018 | 392.5018 | 337.0 |
> showing 50 of 13,394 rows — these rows as CSV