PREVIEW / etf_30min / 2005-02-23
file: by_date/etf_30min/2005/2005-02-23.parquet size: 42 KB rows: 1,438
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 |
|---|---|---|---|---|---|---|---|
| 2005-02-23 08:00:00 | SPY | ETF | 118.76 | 118.81 | 118.74 | 118.78 | 343600.0 |
| 2005-02-23 08:30:00 | SPY | ETF | 118.82 | 119.12 | 118.82 | 119.05 | 943400.0 |
| 2005-02-23 09:00:00 | SPY | ETF | 119.05 | 119.13 | 118.98 | 118.98 | 177100.0 |
| 2005-02-23 09:30:00 | SPY | ETF | 118.97 | 119.18 | 118.93 | 118.97 | 10655200.0 |
| 2005-02-23 10:00:00 | SPY | ETF | 118.97 | 119.1 | 118.75 | 119.01 | 8049200.0 |
| 2005-02-23 10:30:00 | SPY | ETF | 119.02 | 119.09 | 118.71 | 118.85 | 3605400.0 |
| 2005-02-23 11:00:00 | SPY | ETF | 118.86 | 119.17 | 118.79 | 119.11 | 4755800.0 |
| 2005-02-23 11:30:00 | SPY | ETF | 119.1 | 119.28 | 119.09 | 119.19 | 3954300.0 |
| 2005-02-23 12:00:00 | SPY | ETF | 119.2 | 119.23 | 119.12 | 119.16 | 3854900.0 |
| 2005-02-23 12:30:00 | SPY | ETF | 119.16 | 119.18 | 119.05 | 119.14 | 1516900.0 |
| 2005-02-23 13:00:00 | SPY | ETF | 119.14 | 119.19 | 118.93 | 118.99 | 2807200.0 |
| 2005-02-23 13:30:00 | SPY | ETF | 118.98 | 119.15 | 118.89 | 119.11 | 3180100.0 |
| 2005-02-23 14:00:00 | SPY | ETF | 119.11 | 119.24 | 118.92 | 119.21 | 4638800.0 |
| 2005-02-23 14:30:00 | SPY | ETF | 119.2 | 119.38 | 119.18 | 119.3 | 5352200.0 |
| 2005-02-23 15:00:00 | SPY | ETF | 119.31 | 119.57 | 118.6247 | 119.49 | 7325900.0 |
| 2005-02-23 15:30:00 | SPY | ETF | 119.49 | 119.54 | 119.27 | 119.33 | 4898800.0 |
| 2005-02-23 16:00:00 | SPY | ETF | 119.35 | 119.48 | 119.28 | 119.43 | 735300.0 |
| 2005-02-23 16:30:00 | SPY | ETF | 119.44 | 119.52 | 119.43 | 119.49 | 131500.0 |
| 2005-02-23 17:00:00 | SPY | ETF | 119.5 | 119.52 | 119.5 | 119.5 | 2900.0 |
| 2005-02-23 17:30:00 | SPY | ETF | 119.52 | 119.54 | 119.5 | 119.51 | 6100.0 |
| 2005-02-23 18:00:00 | SPY | ETF | 119.5 | 119.5 | 119.45 | 119.47 | 7200.0 |
| 2005-02-23 19:00:00 | SPY | ETF | 119.45 | 119.45 | 119.45 | 119.45 | 2000.0 |
| 2005-02-23 09:30:00 | QQQ | ETF | 37.03 | 37.07 | 36.87 | 36.91 | 11846000.0 |
| 2005-02-23 10:00:00 | QQQ | ETF | 36.91 | 37.76 | 36.72 | 36.9 | 12515400.0 |
| 2005-02-23 10:30:00 | QQQ | ETF | 36.9 | 36.96 | 36.72 | 36.8 | 6310800.0 |
| 2005-02-23 11:00:00 | QQQ | ETF | 36.79 | 37.03 | 36.77 | 36.99 | 9159600.0 |
| 2005-02-23 11:30:00 | QQQ | ETF | 36.99 | 37.03 | 36.83 | 36.94 | 5564800.0 |
| 2005-02-23 12:00:00 | QQQ | ETF | 36.95 | 36.96 | 36.87 | 36.91 | 2942400.0 |
| 2005-02-23 12:30:00 | QQQ | ETF | 36.92 | 36.92 | 36.85 | 36.88 | 2592700.0 |
| 2005-02-23 13:00:00 | QQQ | ETF | 36.87 | 36.95 | 36.81 | 36.82 | 4621300.0 |
| 2005-02-23 13:30:00 | QQQ | ETF | 36.82 | 36.85 | 36.71 | 36.83 | 4965800.0 |
| 2005-02-23 14:00:00 | QQQ | ETF | 36.83 | 36.9 | 36.7 | 36.86 | 8400000.0 |
| 2005-02-23 14:30:00 | QQQ | ETF | 36.86 | 36.93 | 36.82 | 36.91 | 5512200.0 |
| 2005-02-23 15:00:00 | QQQ | ETF | 36.9 | 37.05 | 36.87 | 37.01 | 6717000.0 |
| 2005-02-23 15:30:00 | QQQ | ETF | 37.0 | 37.03 | 36.91 | 36.92 | 6560000.0 |
| 2005-02-23 08:00:00 | IWM | ETF | 61.595 | 61.595 | 61.59 | 61.59 | 18000.0 |
| 2005-02-23 08:30:00 | IWM | ETF | 61.77 | 61.87 | 61.75 | 61.845 | 30600.0 |
| 2005-02-23 09:00:00 | IWM | ETF | 61.835 | 61.865 | 61.78 | 61.78 | 11600.0 |
| 2005-02-23 09:30:00 | IWM | ETF | 61.74 | 62.1 | 61.715 | 61.895 | 2410200.0 |
| 2005-02-23 10:00:00 | IWM | ETF | 61.88 | 61.975 | 61.66 | 61.96 | 2578600.0 |
| 2005-02-23 10:30:00 | IWM | ETF | 61.955 | 61.98 | 61.755 | 61.825 | 1334200.0 |
| 2005-02-23 11:00:00 | IWM | ETF | 61.815 | 62.225 | 61.775 | 62.2 | 1149000.0 |
| 2005-02-23 11:30:00 | IWM | ETF | 62.2 | 62.285 | 62.07 | 62.15 | 898400.0 |
| 2005-02-23 12:00:00 | IWM | ETF | 62.12 | 62.16 | 62.065 | 62.09 | 837000.0 |
| 2005-02-23 12:30:00 | IWM | ETF | 62.1 | 62.105 | 61.99 | 62.075 | 587600.0 |
| 2005-02-23 13:00:00 | IWM | ETF | 62.08 | 62.1 | 61.915 | 61.93 | 757400.0 |
| 2005-02-23 13:30:00 | IWM | ETF | 61.935 | 61.99 | 61.865 | 61.96 | 804600.0 |
| 2005-02-23 14:00:00 | IWM | ETF | 61.955 | 62.04 | 61.685 | 61.95 | 2067200.0 |
| 2005-02-23 14:30:00 | IWM | ETF | 61.935 | 62.055 | 61.87 | 61.91 | 935600.0 |
| 2005-02-23 15:00:00 | IWM | ETF | 61.935 | 62.04 | 61.86 | 61.945 | 1091200.0 |
> showing 50 of 1,438 rows — these rows as CSV