PREVIEW / etf_30min / 2005-05-26
file: by_date/etf_30min/2005/2005-05-26.parquet size: 42 KB rows: 1,499
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-05-26 06:30:00 | SPY | ETF | 119.8 | 119.8 | 119.8 | 119.8 | 500.0 |
| 2005-05-26 07:00:00 | SPY | ETF | 119.72 | 119.78 | 119.72 | 119.77 | 10200.0 |
| 2005-05-26 07:30:00 | SPY | ETF | 119.78 | 119.78 | 119.78 | 119.78 | 500.0 |
| 2005-05-26 08:00:00 | SPY | ETF | 119.75 | 119.92 | 119.72 | 119.9 | 111600.0 |
| 2005-05-26 08:30:00 | SPY | ETF | 119.85 | 119.92 | 119.8 | 119.83 | 227300.0 |
| 2005-05-26 09:00:00 | SPY | ETF | 119.87 | 119.9 | 119.78 | 119.78 | 79800.0 |
| 2005-05-26 09:30:00 | SPY | ETF | 119.79 | 119.87 | 119.62 | 119.67 | 5554600.0 |
| 2005-05-26 10:00:00 | SPY | ETF | 119.67 | 120.06 | 119.62 | 120.01 | 6675300.0 |
| 2005-05-26 10:30:00 | SPY | ETF | 120.0 | 120.1 | 119.87 | 119.98 | 4677800.0 |
| 2005-05-26 11:00:00 | SPY | ETF | 119.98 | 120.04 | 119.85 | 120.0 | 2644800.0 |
| 2005-05-26 11:30:00 | SPY | ETF | 120.0 | 120.04 | 119.86 | 119.97 | 1491500.0 |
| 2005-05-26 12:00:00 | SPY | ETF | 119.97 | 120.02 | 119.91 | 119.97 | 1177600.0 |
| 2005-05-26 12:30:00 | SPY | ETF | 119.97 | 120.03 | 119.9 | 119.98 | 917000.0 |
| 2005-05-26 13:00:00 | SPY | ETF | 119.98 | 120.0 | 119.76 | 119.83 | 2790000.0 |
| 2005-05-26 13:30:00 | SPY | ETF | 119.82 | 119.95 | 119.79 | 119.92 | 1166100.0 |
| 2005-05-26 14:00:00 | SPY | ETF | 119.92 | 120.1 | 119.88 | 120.04 | 3125200.0 |
| 2005-05-26 14:30:00 | SPY | ETF | 120.05 | 120.06 | 119.85 | 119.9112 | 1751600.0 |
| 2005-05-26 15:00:00 | SPY | ETF | 119.92 | 120.07 | 119.91 | 120.02 | 2033300.0 |
| 2005-05-26 15:30:00 | SPY | ETF | 120.01 | 120.21 | 119.99 | 120.05 | 5241400.0 |
| 2005-05-26 16:00:00 | SPY | ETF | 120.05 | 120.08 | 119.955 | 120.06 | 1943600.0 |
| 2005-05-26 16:30:00 | SPY | ETF | 120.03 | 120.03 | 119.99 | 120.02 | 223100.0 |
| 2005-05-26 17:00:00 | SPY | ETF | 120.01 | 120.02 | 119.98 | 119.98 | 65900.0 |
| 2005-05-26 17:30:00 | SPY | ETF | 119.97 | 120.01 | 119.97 | 120.01 | 400.0 |
| 2005-05-26 18:00:00 | SPY | ETF | 120.03 | 120.03 | 120.0 | 120.0 | 1100.0 |
| 2005-05-26 18:30:00 | SPY | ETF | 119.98 | 119.98 | 119.95 | 119.95 | 5200.0 |
| 2005-05-26 19:00:00 | SPY | ETF | 119.95 | 120.0 | 119.95 | 120.0 | 3500.0 |
| 2005-05-26 09:30:00 | QQQ | ETF | 37.99 | 38.1 | 37.98 | 38.02 | 12076400.0 |
| 2005-05-26 10:00:00 | QQQ | ETF | 38.02 | 38.24 | 38.01 | 38.22 | 16535000.0 |
| 2005-05-26 10:30:00 | QQQ | ETF | 38.22 | 38.27 | 38.14 | 38.19 | 8521300.0 |
| 2005-05-26 11:00:00 | QQQ | ETF | 38.18 | 38.19 | 38.15 | 38.17 | 3406500.0 |
| 2005-05-26 11:30:00 | QQQ | ETF | 38.18 | 38.2 | 38.13 | 38.19 | 3333400.0 |
| 2005-05-26 12:00:00 | QQQ | ETF | 38.19 | 38.2 | 38.17 | 38.18 | 1523400.0 |
| 2005-05-26 12:30:00 | QQQ | ETF | 38.19 | 38.22 | 38.17 | 38.18 | 1834700.0 |
| 2005-05-26 13:00:00 | QQQ | ETF | 38.17 | 38.19 | 38.08 | 38.11 | 4805300.0 |
| 2005-05-26 13:30:00 | QQQ | ETF | 38.1 | 38.17 | 38.1 | 38.15 | 2315500.0 |
| 2005-05-26 14:00:00 | QQQ | ETF | 38.15 | 38.2 | 38.13 | 38.19 | 3673900.0 |
| 2005-05-26 14:30:00 | QQQ | ETF | 38.2 | 38.2 | 38.09 | 38.1 | 3541400.0 |
| 2005-05-26 15:00:00 | QQQ | ETF | 38.11 | 38.22 | 38.1 | 38.2 | 4908300.0 |
| 2005-05-26 15:30:00 | QQQ | ETF | 38.2 | 38.26 | 38.17 | 38.18 | 10123100.0 |
| 2005-05-26 08:00:00 | IWM | ETF | 60.55 | 60.61 | 60.55 | 60.61 | 6600.0 |
| 2005-05-26 08:30:00 | IWM | ETF | 60.595 | 60.63 | 60.575 | 60.625 | 5200.0 |
| 2005-05-26 09:00:00 | IWM | ETF | 60.58 | 60.58 | 60.57 | 60.57 | 1800.0 |
| 2005-05-26 09:30:00 | IWM | ETF | 60.545 | 60.84 | 60.545 | 60.71 | 2498800.0 |
| 2005-05-26 10:00:00 | IWM | ETF | 60.72 | 61.155 | 60.705 | 61.04 | 5236400.0 |
| 2005-05-26 10:30:00 | IWM | ETF | 61.04 | 61.115 | 60.935 | 61.01 | 1934800.0 |
| 2005-05-26 11:00:00 | IWM | ETF | 60.995 | 61.01 | 60.865 | 61.005 | 1200600.0 |
| 2005-05-26 11:30:00 | IWM | ETF | 61.01 | 61.01 | 60.885 | 60.965 | 974000.0 |
| 2005-05-26 12:00:00 | IWM | ETF | 60.97 | 60.99 | 60.915 | 60.965 | 297800.0 |
| 2005-05-26 12:30:00 | IWM | ETF | 60.965 | 61.06 | 60.925 | 61.0 | 308000.0 |
| 2005-05-26 13:00:00 | IWM | ETF | 61.005 | 61.035 | 60.9 | 60.94 | 705200.0 |
> showing 50 of 1,499 rows — these rows as CSV