PREVIEW / etf_30min / 2005-04-25
file: by_date/etf_30min/2005/2005-04-25.parquet size: 42 KB rows: 1,487
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-04-25 07:00:00 | SPY | ETF | 115.57 | 115.57 | 115.57 | 115.57 | 4000.0 |
| 2005-04-25 07:30:00 | SPY | ETF | 115.46 | 115.51 | 115.46 | 115.5 | 28300.0 |
| 2005-04-25 08:00:00 | SPY | ETF | 115.47 | 115.78 | 115.47 | 115.75 | 148000.0 |
| 2005-04-25 08:30:00 | SPY | ETF | 115.79 | 115.87 | 115.77 | 115.79 | 174500.0 |
| 2005-04-25 09:00:00 | SPY | ETF | 115.8 | 115.91 | 115.8 | 115.85 | 153700.0 |
| 2005-04-25 09:30:00 | SPY | ETF | 115.86 | 115.99 | 115.72 | 115.87 | 5388000.0 |
| 2005-04-25 10:00:00 | SPY | ETF | 115.89 | 116.5 | 115.82 | 116.24 | 9955600.0 |
| 2005-04-25 10:30:00 | SPY | ETF | 116.24 | 116.32 | 116.01 | 116.16 | 3654500.0 |
| 2005-04-25 11:00:00 | SPY | ETF | 116.16 | 116.28 | 116.05 | 116.16 | 2660600.0 |
| 2005-04-25 11:30:00 | SPY | ETF | 116.17 | 116.42 | 116.11 | 116.35 | 3025200.0 |
| 2005-04-25 12:00:00 | SPY | ETF | 116.35 | 116.38 | 116.12 | 116.22 | 2403900.0 |
| 2005-04-25 12:30:00 | SPY | ETF | 116.23 | 116.4 | 116.07 | 116.09 | 1301400.0 |
| 2005-04-25 13:00:00 | SPY | ETF | 116.1 | 116.22 | 115.99 | 116.16 | 2303600.0 |
| 2005-04-25 13:30:00 | SPY | ETF | 116.16 | 116.39 | 116.02 | 116.03 | 2237200.0 |
| 2005-04-25 14:00:00 | SPY | ETF | 116.03 | 116.27 | 116.01 | 116.201 | 1991600.0 |
| 2005-04-25 14:30:00 | SPY | ETF | 116.21 | 116.3 | 115.98 | 116.0 | 3013200.0 |
| 2005-04-25 15:00:00 | SPY | ETF | 115.98 | 116.25 | 115.75 | 115.92 | 6142700.0 |
| 2005-04-25 15:30:00 | SPY | ETF | 115.93 | 116.3 | 115.91 | 116.27 | 5036500.0 |
| 2005-04-25 16:00:00 | SPY | ETF | 116.28 | 116.46 | 116.24 | 116.31 | 1186200.0 |
| 2005-04-25 16:30:00 | SPY | ETF | 116.33 | 116.39 | 116.32 | 116.38 | 281600.0 |
| 2005-04-25 17:00:00 | SPY | ETF | 116.38 | 116.38 | 116.33 | 116.33 | 27000.0 |
| 2005-04-25 17:30:00 | SPY | ETF | 116.37 | 116.37 | 116.35 | 116.37 | 600.0 |
| 2005-04-25 18:00:00 | SPY | ETF | 116.35 | 116.35 | 116.3 | 116.32 | 5800.0 |
| 2005-04-25 19:00:00 | SPY | ETF | 116.28 | 116.28 | 116.28 | 116.28 | 1800.0 |
| 2005-04-25 19:30:00 | SPY | ETF | 116.31 | 116.31 | 116.31 | 116.31 | 300.0 |
| 2005-04-25 09:30:00 | QQQ | ETF | 35.29 | 35.33 | 35.2 | 35.25 | 9269900.0 |
| 2005-04-25 10:00:00 | QQQ | ETF | 35.25 | 35.46 | 35.22 | 35.34 | 10500200.0 |
| 2005-04-25 10:30:00 | QQQ | ETF | 35.34 | 35.39 | 35.28 | 35.34 | 5439600.0 |
| 2005-04-25 11:00:00 | QQQ | ETF | 35.33 | 35.42 | 35.31 | 35.36 | 4503500.0 |
| 2005-04-25 11:30:00 | QQQ | ETF | 35.36 | 35.44 | 35.33 | 35.43 | 2742400.0 |
| 2005-04-25 12:00:00 | QQQ | ETF | 35.42 | 35.45 | 35.34 | 35.38 | 4176800.0 |
| 2005-04-25 12:30:00 | QQQ | ETF | 35.37 | 35.38 | 35.31 | 35.33 | 1895300.0 |
| 2005-04-25 13:00:00 | QQQ | ETF | 35.33 | 35.36 | 35.3 | 35.33 | 1726600.0 |
| 2005-04-25 13:30:00 | QQQ | ETF | 35.34 | 35.43 | 35.28 | 35.28 | 2998000.0 |
| 2005-04-25 14:00:00 | QQQ | ETF | 35.29 | 35.36 | 35.28 | 35.34 | 2936700.0 |
| 2005-04-25 14:30:00 | QQQ | ETF | 35.33 | 35.39 | 35.27 | 35.27 | 3382900.0 |
| 2005-04-25 15:00:00 | QQQ | ETF | 35.27 | 35.28 | 35.15 | 35.24 | 7588100.0 |
| 2005-04-25 15:30:00 | QQQ | ETF | 35.24 | 35.4 | 35.23 | 35.38 | 7977400.0 |
| 2005-04-25 08:00:00 | IWM | ETF | 58.825 | 58.83 | 58.825 | 58.83 | 400.0 |
| 2005-04-25 08:30:00 | IWM | ETF | 58.83 | 58.94 | 58.83 | 58.935 | 16200.0 |
| 2005-04-25 09:00:00 | IWM | ETF | 58.9 | 59.0 | 58.9 | 58.975 | 28800.0 |
| 2005-04-25 09:30:00 | IWM | ETF | 58.91 | 59.09 | 58.805 | 58.86 | 3076000.0 |
| 2005-04-25 10:00:00 | IWM | ETF | 58.87 | 59.3 | 58.815 | 59.01 | 3286800.0 |
| 2005-04-25 10:30:00 | IWM | ETF | 59.04 | 59.09 | 58.845 | 59.0 | 804000.0 |
| 2005-04-25 11:00:00 | IWM | ETF | 59.005 | 59.145 | 58.95 | 59.04 | 518000.0 |
| 2005-04-25 11:30:00 | IWM | ETF | 59.045 | 59.285 | 59.035 | 59.26 | 1587600.0 |
| 2005-04-25 12:00:00 | IWM | ETF | 59.255 | 59.315 | 59.08 | 59.16 | 1036200.0 |
| 2005-04-25 12:30:00 | IWM | ETF | 59.16 | 59.285 | 59.115 | 59.19 | 539600.0 |
| 2005-04-25 13:00:00 | IWM | ETF | 59.19 | 59.195 | 59.1 | 59.18 | 538200.0 |
| 2005-04-25 13:30:00 | IWM | ETF | 59.18 | 59.3 | 58.98 | 58.985 | 1106200.0 |
> showing 50 of 1,487 rows — these rows as CSV