PREVIEW / etf_1hour / 2024-11-05
file: by_date/etf_1hour/2024/2024-11-05.parquet size: 581 KB rows: 21,469
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-11-05 04:00:00 | SPY | ETF | 570.77 | 571.08 | 570.67 | 570.91 | 14749.0 |
| 2024-11-05 05:00:00 | SPY | ETF | 570.66 | 570.82 | 570.15 | 570.75 | 5108.0 |
| 2024-11-05 06:00:00 | SPY | ETF | 570.96 | 571.35 | 570.96 | 571.16 | 20014.0 |
| 2024-11-05 07:00:00 | SPY | ETF | 570.9 | 571.21 | 570.34 | 570.69 | 106951.0 |
| 2024-11-05 08:00:00 | SPY | ETF | 571.01 | 571.15 | 569.93 | 570.55 | 117429.0 |
| 2024-11-05 09:00:00 | SPY | ETF | 570.53 | 574.02 | 570.2701 | 573.98 | 2736664.0 |
| 2024-11-05 10:00:00 | SPY | ETF | 574.01 | 575.21 | 573.51 | 574.005 | 4182717.0 |
| 2024-11-05 11:00:00 | SPY | ETF | 573.98 | 575.6 | 573.5454 | 575.45 | 2377317.0 |
| 2024-11-05 12:00:00 | SPY | ETF | 575.46 | 576.43 | 575.15 | 576.03 | 2126605.0 |
| 2024-11-05 13:00:00 | SPY | ETF | 576.04 | 576.4 | 574.6 | 575.2348 | 2259851.0 |
| 2024-11-05 14:00:00 | SPY | ETF | 575.23 | 575.87 | 574.7 | 575.0 | 2523330.0 |
| 2024-11-05 15:00:00 | SPY | ETF | 575.0 | 576.71 | 574.7437 | 576.68 | 6864011.0 |
| 2024-11-05 16:00:00 | SPY | ETF | 576.68 | 577.63 | 576.55 | 577.56 | 2270955.0 |
| 2024-11-05 17:00:00 | SPY | ETF | 577.5 | 577.5 | 577.29 | 577.39 | 64632.0 |
| 2024-11-05 18:00:00 | SPY | ETF | 577.41 | 577.71 | 576.9 | 577.01 | 108105.0 |
| 2024-11-05 19:00:00 | SPY | ETF | 576.97 | 579.93 | 576.9412 | 579.0901 | 336346.0 |
| 2024-11-05 04:00:00 | QQQ | ETF | 487.49 | 488.0 | 487.28 | 487.62 | 34919.0 |
| 2024-11-05 05:00:00 | QQQ | ETF | 487.5 | 487.55 | 486.75 | 487.43 | 26362.0 |
| 2024-11-05 06:00:00 | QQQ | ETF | 487.54 | 488.09 | 487.54 | 487.7 | 35084.0 |
| 2024-11-05 07:00:00 | QQQ | ETF | 487.68 | 488.0 | 487.07 | 487.58 | 71460.0 |
| 2024-11-05 08:00:00 | QQQ | ETF | 488.01 | 488.01 | 485.646 | 487.03 | 89555.0 |
| 2024-11-05 09:00:00 | QQQ | ETF | 486.98 | 491.13 | 486.59 | 490.9451 | 2516262.0 |
| 2024-11-05 10:00:00 | QQQ | ETF | 490.88 | 491.61 | 489.77 | 490.15 | 2561507.0 |
| 2024-11-05 11:00:00 | QQQ | ETF | 490.1 | 492.29 | 489.56 | 492.14 | 1656512.0 |
| 2024-11-05 12:00:00 | QQQ | ETF | 492.15 | 492.88 | 491.83 | 492.4 | 1533744.0 |
| 2024-11-05 13:00:00 | QQQ | ETF | 492.4062 | 492.79 | 490.8601 | 491.385 | 1743257.0 |
| 2024-11-05 14:00:00 | QQQ | ETF | 491.44 | 492.0199 | 490.7316 | 491.08 | 1317323.0 |
| 2024-11-05 15:00:00 | QQQ | ETF | 491.01 | 492.4099 | 490.76 | 492.25 | 3005159.0 |
| 2024-11-05 16:00:00 | QQQ | ETF | 492.24 | 493.23 | 492.15 | 492.72 | 1247962.0 |
| 2024-11-05 17:00:00 | QQQ | ETF | 492.72 | 492.8 | 492.4 | 492.75 | 44438.0 |
| 2024-11-05 18:00:00 | QQQ | ETF | 492.67 | 492.76 | 492.14 | 492.35 | 63687.0 |
| 2024-11-05 19:00:00 | QQQ | ETF | 492.25 | 493.92 | 491.85 | 493.29 | 365297.0 |
| 2024-11-05 04:00:00 | IWM | ETF | 220.26 | 220.45 | 220.2 | 220.36 | 19645.0 |
| 2024-11-05 05:00:00 | IWM | ETF | 220.3 | 220.38 | 219.98 | 220.32 | 7445.0 |
| 2024-11-05 06:00:00 | IWM | ETF | 220.31 | 220.6 | 220.31 | 220.44 | 51405.0 |
| 2024-11-05 07:00:00 | IWM | ETF | 220.4 | 220.59 | 220.2 | 220.331 | 48892.0 |
| 2024-11-05 08:00:00 | IWM | ETF | 220.5501 | 220.6599 | 219.95 | 220.02 | 63291.0 |
| 2024-11-05 09:00:00 | IWM | ETF | 219.99 | 221.57 | 219.06 | 221.5 | 2149991.0 |
| 2024-11-05 10:00:00 | IWM | ETF | 221.51 | 222.14 | 220.94 | 221.47 | 2146156.0 |
| 2024-11-05 11:00:00 | IWM | ETF | 221.48 | 222.67 | 221.35 | 222.59 | 1545757.0 |
| 2024-11-05 12:00:00 | IWM | ETF | 222.6 | 222.62 | 222.22 | 222.351 | 1175841.0 |
| 2024-11-05 13:00:00 | IWM | ETF | 222.37 | 222.83 | 222.15 | 222.82 | 1332283.0 |
| 2024-11-05 14:00:00 | IWM | ETF | 222.81 | 223.67 | 222.795 | 223.03 | 1939052.0 |
| 2024-11-05 15:00:00 | IWM | ETF | 223.03 | 224.29 | 222.895 | 224.26 | 5824402.0 |
| 2024-11-05 16:00:00 | IWM | ETF | 224.23 | 225.01 | 223.9368 | 225.0 | 1563228.0 |
| 2024-11-05 17:00:00 | IWM | ETF | 225.0 | 225.01 | 224.8 | 225.01 | 31881.0 |
| 2024-11-05 18:00:00 | IWM | ETF | 224.98 | 225.05 | 224.1 | 224.31 | 253914.0 |
| 2024-11-05 19:00:00 | IWM | ETF | 224.26 | 227.81 | 224.24 | 226.73 | 336147.0 |
| 2024-11-05 04:00:00 | DIA | ETF | 418.68 | 418.68 | 418.68 | 418.68 | 100.0 |
| 2024-11-05 05:00:00 | DIA | ETF | 418.62 | 418.62 | 418.62 | 418.62 | 100.0 |
> showing 50 of 21,469 rows — these rows as CSV