PREVIEW / etf_1hour / 2024-02-27
file: by_date/etf_1hour/2024/2024-02-27.parquet size: 532 KB rows: 19,610
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-27 04:00:00 | SPY | ETF | 506.0 | 506.69 | 506.0 | 506.58 | 16189.0 |
| 2024-02-27 05:00:00 | SPY | ETF | 506.62 | 506.73 | 506.38 | 506.64 | 14413.0 |
| 2024-02-27 06:00:00 | SPY | ETF | 506.69 | 506.69 | 506.31 | 506.49 | 19170.0 |
| 2024-02-27 07:00:00 | SPY | ETF | 506.44 | 507.01 | 506.44 | 506.88 | 104405.0 |
| 2024-02-27 08:00:00 | SPY | ETF | 506.48 | 507.0101 | 505.55 | 506.77 | 291335.0 |
| 2024-02-27 09:00:00 | SPY | ETF | 506.75 | 506.92 | 505.53 | 506.12 | 3484555.0 |
| 2024-02-27 10:00:00 | SPY | ETF | 506.1 | 506.58 | 505.59 | 506.1303 | 4795790.0 |
| 2024-02-27 11:00:00 | SPY | ETF | 506.14 | 506.165 | 505.46 | 505.9 | 3028343.0 |
| 2024-02-27 12:00:00 | SPY | ETF | 505.92 | 506.0 | 504.99 | 505.0597 | 3575820.0 |
| 2024-02-27 13:00:00 | SPY | ETF | 505.05 | 505.89 | 504.75 | 505.7726 | 4095591.0 |
| 2024-02-27 14:00:00 | SPY | ETF | 505.79 | 506.71 | 505.74 | 506.66 | 4605169.0 |
| 2024-02-27 15:00:00 | SPY | ETF | 506.66 | 507.16 | 506.2201 | 506.87 | 9206746.0 |
| 2024-02-27 16:00:00 | SPY | ETF | 506.87 | 507.31 | 506.81 | 507.08 | 3086673.0 |
| 2024-02-27 17:00:00 | SPY | ETF | 507.06 | 507.1 | 506.94 | 507.1 | 68842.0 |
| 2024-02-27 18:00:00 | SPY | ETF | 507.0 | 507.11 | 506.76 | 506.78 | 80585.0 |
| 2024-02-27 19:00:00 | SPY | ETF | 506.77 | 506.88 | 506.7 | 506.7 | 37069.0 |
| 2024-02-27 04:00:00 | QQQ | ETF | 436.49 | 437.56 | 436.49 | 437.53 | 82338.0 |
| 2024-02-27 05:00:00 | QQQ | ETF | 437.64 | 437.8 | 437.26 | 437.57 | 36105.0 |
| 2024-02-27 06:00:00 | QQQ | ETF | 437.6 | 437.63 | 437.23 | 437.4 | 27920.0 |
| 2024-02-27 07:00:00 | QQQ | ETF | 437.33 | 438.19 | 437.33 | 437.95 | 78852.0 |
| 2024-02-27 08:00:00 | QQQ | ETF | 437.37 | 438.16 | 435.58 | 437.8907 | 307969.0 |
| 2024-02-27 09:00:00 | QQQ | ETF | 437.84 | 437.89 | 435.81 | 436.97 | 3903734.0 |
| 2024-02-27 10:00:00 | QQQ | ETF | 436.97 | 437.99 | 436.69 | 437.5399 | 4567673.0 |
| 2024-02-27 11:00:00 | QQQ | ETF | 437.54 | 437.6 | 436.39 | 437.24 | 3013839.0 |
| 2024-02-27 12:00:00 | QQQ | ETF | 437.25 | 437.47 | 435.34 | 435.4961 | 2997997.0 |
| 2024-02-27 13:00:00 | QQQ | ETF | 435.48 | 436.54 | 435.025 | 436.5 | 3050012.0 |
| 2024-02-27 14:00:00 | QQQ | ETF | 436.51 | 437.9399 | 436.485 | 437.8699 | 3034272.0 |
| 2024-02-27 15:00:00 | QQQ | ETF | 437.865 | 437.96 | 437.26 | 437.62 | 4466510.0 |
| 2024-02-27 16:00:00 | QQQ | ETF | 437.61 | 437.8 | 437.38 | 437.55 | 1015631.0 |
| 2024-02-27 17:00:00 | QQQ | ETF | 437.51 | 437.7 | 437.47 | 437.68 | 112603.0 |
| 2024-02-27 18:00:00 | QQQ | ETF | 437.6 | 437.69 | 437.3204 | 437.35 | 129430.0 |
| 2024-02-27 19:00:00 | QQQ | ETF | 437.33 | 437.45 | 437.27 | 437.29 | 42825.0 |
| 2024-02-27 04:00:00 | IWM | ETF | 201.24 | 201.96 | 201.24 | 201.86 | 18565.0 |
| 2024-02-27 05:00:00 | IWM | ETF | 201.79 | 202.04 | 201.69 | 202.04 | 17283.0 |
| 2024-02-27 06:00:00 | IWM | ETF | 202.03 | 202.13 | 201.88 | 202.07 | 15910.0 |
| 2024-02-27 07:00:00 | IWM | ETF | 202.03 | 203.01 | 202.02 | 202.97 | 181356.0 |
| 2024-02-27 08:00:00 | IWM | ETF | 202.0309 | 203.35 | 200.82 | 203.2 | 258709.0 |
| 2024-02-27 09:00:00 | IWM | ETF | 203.21 | 203.77 | 202.535 | 203.16 | 3780722.0 |
| 2024-02-27 10:00:00 | IWM | ETF | 203.14 | 203.72 | 202.83 | 203.49 | 3696911.0 |
| 2024-02-27 11:00:00 | IWM | ETF | 203.49 | 204.13 | 203.43 | 204.0525 | 2907387.0 |
| 2024-02-27 12:00:00 | IWM | ETF | 204.06 | 204.14 | 203.27 | 203.3204 | 3020880.0 |
| 2024-02-27 13:00:00 | IWM | ETF | 203.3 | 203.8 | 203.135 | 203.59 | 2863545.0 |
| 2024-02-27 14:00:00 | IWM | ETF | 203.59 | 203.745 | 203.24 | 203.64 | 2043100.0 |
| 2024-02-27 15:00:00 | IWM | ETF | 203.65 | 204.215 | 203.494 | 203.94 | 5618272.0 |
| 2024-02-27 16:00:00 | IWM | ETF | 203.9625 | 204.08 | 203.78 | 203.78 | 1505701.0 |
| 2024-02-27 17:00:00 | IWM | ETF | 203.98 | 203.99 | 203.86 | 203.98 | 22953.0 |
| 2024-02-27 18:00:00 | IWM | ETF | 203.89 | 203.99 | 203.74 | 203.74 | 254128.0 |
| 2024-02-27 19:00:00 | IWM | ETF | 203.74 | 203.8 | 203.65 | 203.65 | 42726.0 |
| 2024-02-27 04:00:00 | DIA | ETF | 390.7 | 390.91 | 390.7 | 390.91 | 350.0 |
| 2024-02-27 05:00:00 | DIA | ETF | 390.92 | 390.92 | 390.92 | 390.92 | 165.0 |
> showing 50 of 19,610 rows — these rows as CSV