PREVIEW / etf_1hour / 2024-02-16
file: by_date/etf_1hour/2024/2024-02-16.parquet size: 530 KB rows: 19,656
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-02-16 04:00:00 | SPY | ETF | 502.41 | 503.04 | 502.41 | 502.8 | 29810.0 |
| 2024-02-16 05:00:00 | SPY | ETF | 503.0 | 503.3 | 503.0 | 503.12 | 5316.0 |
| 2024-02-16 06:00:00 | SPY | ETF | 503.06 | 503.28 | 502.96 | 503.11 | 29329.0 |
| 2024-02-16 07:00:00 | SPY | ETF | 503.1 | 503.1 | 502.54 | 502.65 | 93965.0 |
| 2024-02-16 08:00:00 | SPY | ETF | 503.1016 | 503.2896 | 500.46 | 501.55 | 1069212.0 |
| 2024-02-16 09:00:00 | SPY | ETF | 501.55 | 501.91 | 499.29 | 499.66 | 5091711.0 |
| 2024-02-16 10:00:00 | SPY | ETF | 499.65 | 501.16 | 498.75 | 500.92 | 7549856.0 |
| 2024-02-16 11:00:00 | SPY | ETF | 500.93 | 502.46 | 500.905 | 502.21 | 6221039.0 |
| 2024-02-16 12:00:00 | SPY | ETF | 502.215 | 502.36 | 501.66 | 501.83 | 4271377.0 |
| 2024-02-16 13:00:00 | SPY | ETF | 501.83 | 502.37 | 500.74 | 502.3601 | 5360189.0 |
| 2024-02-16 14:00:00 | SPY | ETF | 502.37 | 502.87 | 499.95 | 500.565 | 7987249.0 |
| 2024-02-16 15:00:00 | SPY | ETF | 500.57 | 500.75 | 498.98 | 499.49 | 10846198.0 |
| 2024-02-16 16:00:00 | SPY | ETF | 499.49 | 499.56 | 498.76 | 498.95 | 2794153.0 |
| 2024-02-16 17:00:00 | SPY | ETF | 498.95 | 499.52 | 498.5 | 498.5 | 290044.0 |
| 2024-02-16 18:00:00 | SPY | ETF | 498.51 | 498.85 | 498.51 | 498.74 | 21204.0 |
| 2024-02-16 19:00:00 | SPY | ETF | 498.72 | 498.79 | 498.29 | 498.35 | 42255.0 |
| 2024-02-16 04:00:00 | QQQ | ETF | 436.86 | 437.14 | 436.61 | 436.9 | 68221.0 |
| 2024-02-16 05:00:00 | QQQ | ETF | 436.96 | 437.33 | 436.95 | 437.12 | 48235.0 |
| 2024-02-16 06:00:00 | QQQ | ETF | 437.04 | 437.27 | 436.94 | 437.03 | 21185.0 |
| 2024-02-16 07:00:00 | QQQ | ETF | 437.05 | 437.09 | 436.55 | 436.57 | 107016.0 |
| 2024-02-16 08:00:00 | QQQ | ETF | 437.06 | 437.2504 | 434.32 | 435.22 | 989477.0 |
| 2024-02-16 09:00:00 | QQQ | ETF | 435.23 | 435.49 | 430.72 | 431.25 | 4802762.0 |
| 2024-02-16 10:00:00 | QQQ | ETF | 431.18 | 432.346 | 429.85 | 432.04 | 7091335.0 |
| 2024-02-16 11:00:00 | QQQ | ETF | 432.04 | 434.08 | 431.96 | 433.74 | 4382389.0 |
| 2024-02-16 12:00:00 | QQQ | ETF | 433.72 | 433.96 | 432.96 | 433.24 | 2798025.0 |
| 2024-02-16 13:00:00 | QQQ | ETF | 433.23 | 433.7 | 431.92 | 433.685 | 3344383.0 |
| 2024-02-16 14:00:00 | QQQ | ETF | 433.69 | 434.35 | 431.12 | 431.63 | 4345003.0 |
| 2024-02-16 15:00:00 | QQQ | ETF | 431.65 | 431.81 | 429.99 | 430.59 | 6497370.0 |
| 2024-02-16 16:00:00 | QQQ | ETF | 430.57 | 430.67 | 429.81 | 429.99 | 2485947.0 |
| 2024-02-16 17:00:00 | QQQ | ETF | 430.57 | 430.57 | 429.8217 | 429.8217 | 853928.0 |
| 2024-02-16 18:00:00 | QQQ | ETF | 429.85 | 429.99 | 429.75 | 429.9448 | 22665.0 |
| 2024-02-16 19:00:00 | QQQ | ETF | 429.91 | 429.94 | 429.6 | 429.62 | 12092.0 |
| 2024-02-16 04:00:00 | IWM | ETF | 204.18 | 204.65 | 204.11 | 204.42 | 37999.0 |
| 2024-02-16 05:00:00 | IWM | ETF | 204.42 | 204.67 | 204.31 | 204.64 | 12457.0 |
| 2024-02-16 06:00:00 | IWM | ETF | 204.56 | 204.63 | 204.15 | 204.22 | 85385.0 |
| 2024-02-16 07:00:00 | IWM | ETF | 204.26 | 204.29 | 203.9 | 203.95 | 54385.0 |
| 2024-02-16 08:00:00 | IWM | ETF | 204.2216 | 204.26 | 200.94 | 202.05 | 1334372.0 |
| 2024-02-16 09:00:00 | IWM | ETF | 202.05 | 202.83 | 201.09 | 201.8 | 7323162.0 |
| 2024-02-16 10:00:00 | IWM | ETF | 201.8 | 203.34 | 201.34 | 202.235 | 4820268.0 |
| 2024-02-16 11:00:00 | IWM | ETF | 202.24 | 203.33 | 202.06 | 202.975 | 3191230.0 |
| 2024-02-16 12:00:00 | IWM | ETF | 202.975 | 203.31 | 202.43 | 203.05 | 2602655.0 |
| 2024-02-16 13:00:00 | IWM | ETF | 203.05 | 203.24 | 202.4675 | 203.115 | 1928425.0 |
| 2024-02-16 14:00:00 | IWM | ETF | 203.12 | 203.7 | 202.0 | 202.52 | 3603077.0 |
| 2024-02-16 15:00:00 | IWM | ETF | 202.53 | 202.63 | 201.565 | 201.64 | 6033717.0 |
| 2024-02-16 16:00:00 | IWM | ETF | 201.66 | 201.66 | 201.4 | 201.52 | 1713813.0 |
| 2024-02-16 17:00:00 | IWM | ETF | 201.5 | 201.66 | 201.42 | 201.42 | 1030921.0 |
| 2024-02-16 18:00:00 | IWM | ETF | 201.4 | 201.53 | 201.3 | 201.4 | 12382.0 |
| 2024-02-16 19:00:00 | IWM | ETF | 201.35 | 201.49 | 201.15 | 201.15 | 11929.0 |
| 2024-02-16 04:00:00 | DIA | ETF | 387.23 | 387.31 | 387.22 | 387.31 | 1750.0 |
| 2024-02-16 05:00:00 | DIA | ETF | 387.28 | 387.28 | 387.28 | 387.28 | 300.0 |
> showing 50 of 19,656 rows — these rows as CSV