PREVIEW / etf_1hour / 2024-02-12
file: by_date/etf_1hour/2024/2024-02-12.parquet size: 548 KB rows: 19,981
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-12 04:00:00 | SPY | ETF | 500.98 | 501.34 | 500.94 | 501.23 | 11859.0 |
| 2024-02-12 05:00:00 | SPY | ETF | 501.14 | 501.32 | 501.14 | 501.29 | 4204.0 |
| 2024-02-12 06:00:00 | SPY | ETF | 501.29 | 501.49 | 501.2 | 501.33 | 20318.0 |
| 2024-02-12 07:00:00 | SPY | ETF | 501.37 | 501.44 | 501.2 | 501.28 | 14688.0 |
| 2024-02-12 08:00:00 | SPY | ETF | 501.27 | 501.43 | 501.0 | 501.03 | 114993.0 |
| 2024-02-12 09:00:00 | SPY | ETF | 501.04 | 501.47 | 500.83 | 501.43 | 3343342.0 |
| 2024-02-12 10:00:00 | SPY | ETF | 501.42 | 502.13 | 501.02 | 502.07 | 4129000.0 |
| 2024-02-12 11:00:00 | SPY | ETF | 502.08 | 503.5 | 501.86 | 503.295 | 4611962.0 |
| 2024-02-12 12:00:00 | SPY | ETF | 503.29 | 503.445 | 502.65 | 503.195 | 3965744.0 |
| 2024-02-12 13:00:00 | SPY | ETF | 503.2 | 503.44 | 501.68 | 502.08 | 5243819.0 |
| 2024-02-12 14:00:00 | SPY | ETF | 502.08 | 502.1696 | 500.24 | 500.59 | 6800752.0 |
| 2024-02-12 15:00:00 | SPY | ETF | 500.58 | 501.24 | 500.52 | 500.94 | 9292008.0 |
| 2024-02-12 16:00:00 | SPY | ETF | 500.94 | 501.05 | 500.02 | 500.44 | 3388812.0 |
| 2024-02-12 17:00:00 | SPY | ETF | 500.43 | 500.48 | 500.28 | 500.28 | 47445.0 |
| 2024-02-12 18:00:00 | SPY | ETF | 500.27 | 500.57 | 500.03 | 500.42 | 110189.0 |
| 2024-02-12 19:00:00 | SPY | ETF | 500.42 | 500.42 | 500.06 | 500.2 | 41806.0 |
| 2024-02-12 04:00:00 | QQQ | ETF | 437.27 | 437.66 | 437.27 | 437.45 | 60480.0 |
| 2024-02-12 05:00:00 | QQQ | ETF | 437.52 | 437.65 | 437.3 | 437.48 | 28945.0 |
| 2024-02-12 06:00:00 | QQQ | ETF | 437.44 | 437.6 | 437.27 | 437.29 | 14298.0 |
| 2024-02-12 07:00:00 | QQQ | ETF | 437.33 | 437.44 | 437.01 | 437.17 | 61077.0 |
| 2024-02-12 08:00:00 | QQQ | ETF | 437.2917 | 437.5696 | 436.7 | 436.95 | 118388.0 |
| 2024-02-12 09:00:00 | QQQ | ETF | 436.94 | 437.45 | 436.3806 | 437.175 | 2947781.0 |
| 2024-02-12 10:00:00 | QQQ | ETF | 437.2 | 438.235 | 436.57 | 438.13 | 3387903.0 |
| 2024-02-12 11:00:00 | QQQ | ETF | 438.135 | 439.14 | 437.76 | 438.64 | 2807948.0 |
| 2024-02-12 12:00:00 | QQQ | ETF | 438.67 | 438.84 | 437.85 | 438.73 | 2489730.0 |
| 2024-02-12 13:00:00 | QQQ | ETF | 438.72 | 438.859 | 436.02 | 436.72 | 3756761.0 |
| 2024-02-12 14:00:00 | QQQ | ETF | 436.71 | 436.81 | 434.65 | 435.01 | 4523713.0 |
| 2024-02-12 15:00:00 | QQQ | ETF | 435.01 | 435.8526 | 434.95 | 435.31 | 4763188.0 |
| 2024-02-12 16:00:00 | QQQ | ETF | 435.305 | 435.43 | 434.05 | 434.5 | 1221247.0 |
| 2024-02-12 17:00:00 | QQQ | ETF | 434.5 | 434.64 | 434.32 | 434.36 | 32305.0 |
| 2024-02-12 18:00:00 | QQQ | ETF | 434.35 | 434.75 | 434.21 | 434.7 | 74117.0 |
| 2024-02-12 19:00:00 | QQQ | ETF | 434.7 | 434.7 | 434.29 | 434.5 | 47957.0 |
| 2024-02-12 04:00:00 | IWM | ETF | 199.34 | 200.01 | 199.29 | 199.99 | 21894.0 |
| 2024-02-12 05:00:00 | IWM | ETF | 200.02 | 200.25 | 199.71 | 199.8 | 19150.0 |
| 2024-02-12 06:00:00 | IWM | ETF | 199.79 | 200.06 | 199.56 | 200.06 | 6286.0 |
| 2024-02-12 07:00:00 | IWM | ETF | 200.1 | 200.15 | 199.95 | 200.13 | 140706.0 |
| 2024-02-12 08:00:00 | IWM | ETF | 200.13 | 200.18 | 199.2 | 199.81 | 90024.0 |
| 2024-02-12 09:00:00 | IWM | ETF | 199.84 | 201.93 | 199.67 | 201.89 | 4912325.0 |
| 2024-02-12 10:00:00 | IWM | ETF | 201.9 | 202.58 | 200.9 | 202.3 | 5639119.0 |
| 2024-02-12 11:00:00 | IWM | ETF | 202.31 | 203.375 | 202.22 | 203.16 | 4059565.0 |
| 2024-02-12 12:00:00 | IWM | ETF | 203.16 | 203.338 | 202.68 | 203.31 | 2784393.0 |
| 2024-02-12 13:00:00 | IWM | ETF | 203.305 | 203.5 | 202.69 | 203.072 | 3432582.0 |
| 2024-02-12 14:00:00 | IWM | ETF | 203.08 | 203.3199 | 202.165 | 202.95 | 3343066.0 |
| 2024-02-12 15:00:00 | IWM | ETF | 202.95 | 203.55 | 202.89 | 202.93 | 7841707.0 |
| 2024-02-12 16:00:00 | IWM | ETF | 202.93 | 203.1578 | 202.73 | 202.92 | 2408639.0 |
| 2024-02-12 17:00:00 | IWM | ETF | 202.92 | 202.96 | 202.75 | 202.83 | 27071.0 |
| 2024-02-12 18:00:00 | IWM | ETF | 202.83 | 203.05 | 202.67 | 202.88 | 57665.0 |
| 2024-02-12 19:00:00 | IWM | ETF | 202.8796 | 202.88 | 202.62 | 202.86 | 75312.0 |
| 2024-02-12 04:00:00 | DIA | ETF | 386.12 | 386.4 | 386.12 | 386.4 | 1100.0 |
| 2024-02-12 06:00:00 | DIA | ETF | 386.5 | 386.5 | 386.5 | 386.5 | 295.0 |
> showing 50 of 19,981 rows — these rows as CSV