PREVIEW / etf_30min / 2005-07-11
file: by_date/etf_30min/2005/2005-07-11.parquet size: 45 KB rows: 1,617
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-07-11 06:30:00 | SPY | ETF | 121.44 | 121.44 | 121.44 | 121.44 | 20000.0 |
| 2005-07-11 07:00:00 | SPY | ETF | 121.43 | 121.57 | 121.43 | 121.57 | 94100.0 |
| 2005-07-11 07:30:00 | SPY | ETF | 121.55 | 121.6 | 121.52 | 121.54 | 56300.0 |
| 2005-07-11 08:00:00 | SPY | ETF | 121.5 | 121.55 | 121.41 | 121.55 | 45700.0 |
| 2005-07-11 08:30:00 | SPY | ETF | 121.41 | 121.42 | 121.32 | 121.39 | 93800.0 |
| 2005-07-11 09:00:00 | SPY | ETF | 121.35 | 121.41 | 121.31 | 121.31 | 283400.0 |
| 2005-07-11 09:30:00 | SPY | ETF | 121.33 | 121.63 | 121.31 | 121.5 | 7450300.0 |
| 2005-07-11 10:00:00 | SPY | ETF | 121.5 | 121.65 | 121.41 | 121.63 | 5110900.0 |
| 2005-07-11 10:30:00 | SPY | ETF | 121.62 | 121.88 | 121.53 | 121.81 | 6953700.0 |
| 2005-07-11 11:00:00 | SPY | ETF | 121.81 | 122.06 | 121.77 | 121.93 | 4005800.0 |
| 2005-07-11 11:30:00 | SPY | ETF | 121.93 | 121.98 | 121.86 | 121.93 | 3332700.0 |
| 2005-07-11 12:00:00 | SPY | ETF | 121.92 | 121.95 | 121.66 | 121.66 | 1951300.0 |
| 2005-07-11 12:30:00 | SPY | ETF | 121.67 | 121.77 | 121.58 | 121.61 | 3160800.0 |
| 2005-07-11 13:00:00 | SPY | ETF | 121.61 | 121.66 | 121.44 | 121.62 | 2119700.0 |
| 2005-07-11 13:30:00 | SPY | ETF | 121.61 | 121.75 | 121.5 | 121.55 | 2073800.0 |
| 2005-07-11 14:00:00 | SPY | ETF | 121.54 | 121.8 | 121.54 | 121.67 | 1403400.0 |
| 2005-07-11 14:30:00 | SPY | ETF | 121.67 | 121.91 | 121.65 | 121.86 | 2290800.0 |
| 2005-07-11 15:00:00 | SPY | ETF | 121.86 | 121.9 | 121.58 | 121.73 | 2748200.0 |
| 2005-07-11 15:30:00 | SPY | ETF | 121.73 | 122.04 | 121.71 | 122.01 | 4538600.0 |
| 2005-07-11 16:00:00 | SPY | ETF | 122.04 | 122.11 | 121.94 | 121.96 | 1047100.0 |
| 2005-07-11 16:30:00 | SPY | ETF | 121.96 | 122.01 | 121.95 | 121.95 | 26500.0 |
| 2005-07-11 17:00:00 | SPY | ETF | 121.96 | 122.0 | 121.96 | 121.99 | 33400.0 |
| 2005-07-11 17:30:00 | SPY | ETF | 121.96 | 121.96 | 121.93 | 121.93 | 8800.0 |
| 2005-07-11 18:00:00 | SPY | ETF | 121.94 | 121.94 | 121.93 | 121.93 | 20100.0 |
| 2005-07-11 18:30:00 | SPY | ETF | 121.95 | 121.95 | 121.95 | 121.95 | 3500.0 |
| 2005-07-11 19:00:00 | SPY | ETF | 121.95 | 121.95 | 121.95 | 121.95 | 6300.0 |
| 2005-07-11 19:30:00 | SPY | ETF | 121.95 | 121.95 | 121.95 | 121.95 | 100.0 |
| 2005-07-11 09:30:00 | QQQ | ETF | 37.87 | 37.96 | 37.8 | 37.88 | 19149700.0 |
| 2005-07-11 10:00:00 | QQQ | ETF | 37.88 | 37.95 | 37.85 | 37.94 | 10157600.0 |
| 2005-07-11 10:30:00 | QQQ | ETF | 37.94 | 38.07 | 37.92 | 38.02 | 9710300.0 |
| 2005-07-11 11:00:00 | QQQ | ETF | 38.02 | 38.16 | 37.99 | 38.11 | 10147800.0 |
| 2005-07-11 11:30:00 | QQQ | ETF | 38.12 | 38.15 | 38.07 | 38.08 | 6742500.0 |
| 2005-07-11 12:00:00 | QQQ | ETF | 38.08 | 38.09 | 37.99 | 37.99 | 4231500.0 |
| 2005-07-11 12:30:00 | QQQ | ETF | 37.99 | 38.03 | 37.95 | 37.96 | 3415000.0 |
| 2005-07-11 13:00:00 | QQQ | ETF | 37.96 | 38.0 | 37.91 | 37.99 | 3330600.0 |
| 2005-07-11 13:30:00 | QQQ | ETF | 38.0 | 38.06 | 37.96 | 37.98 | 3379300.0 |
| 2005-07-11 14:00:00 | QQQ | ETF | 37.98 | 38.06 | 37.95 | 38.0 | 4087600.0 |
| 2005-07-11 14:30:00 | QQQ | ETF | 37.99 | 38.08 | 37.99 | 38.04 | 4284500.0 |
| 2005-07-11 15:00:00 | QQQ | ETF | 38.04 | 38.05 | 37.92 | 37.96 | 5262400.0 |
| 2005-07-11 15:30:00 | QQQ | ETF | 37.96 | 38.12 | 37.96 | 38.12 | 7578000.0 |
| 2005-07-11 07:30:00 | IWM | ETF | 66.21 | 66.23 | 66.2 | 66.23 | 32200.0 |
| 2005-07-11 08:00:00 | IWM | ETF | 66.25 | 66.25 | 66.15 | 66.16 | 22200.0 |
| 2005-07-11 08:30:00 | IWM | ETF | 66.08 | 66.08 | 65.97 | 66.08 | 1537500.0 |
| 2005-07-11 09:00:00 | IWM | ETF | 66.09 | 66.09 | 66.0 | 66.0 | 70500.0 |
| 2005-07-11 09:30:00 | IWM | ETF | 66.01 | 66.49 | 65.98 | 66.35 | 6324200.0 |
| 2005-07-11 10:00:00 | IWM | ETF | 66.35 | 66.44 | 66.19 | 66.42 | 1832800.0 |
| 2005-07-11 10:30:00 | IWM | ETF | 66.42 | 66.68 | 66.41 | 66.61 | 3962300.0 |
| 2005-07-11 11:00:00 | IWM | ETF | 66.61 | 66.99 | 66.6 | 66.9 | 3655800.0 |
| 2005-07-11 11:30:00 | IWM | ETF | 66.9 | 66.95 | 66.8 | 66.89 | 1480600.0 |
| 2005-07-11 12:00:00 | IWM | ETF | 66.9 | 66.9 | 66.73 | 66.74 | 1273100.0 |
> showing 50 of 1,617 rows — these rows as CSV