PREVIEW / etf_30min / 2005-04-26
file: by_date/etf_30min/2005/2005-04-26.parquet size: 44 KB rows: 1,470
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-26 06:30:00 | SPY | ETF | 115.81 | 115.82 | 115.78 | 115.82 | 20200.0 |
| 2005-04-26 07:00:00 | SPY | ETF | 115.87 | 115.9 | 115.85 | 115.85 | 95600.0 |
| 2005-04-26 07:30:00 | SPY | ETF | 115.86 | 116.03 | 115.86 | 116.0 | 105400.0 |
| 2005-04-26 08:00:00 | SPY | ETF | 115.99 | 116.06 | 115.99 | 116.03 | 53800.0 |
| 2005-04-26 08:30:00 | SPY | ETF | 116.03 | 116.03 | 115.91 | 115.93 | 24100.0 |
| 2005-04-26 09:00:00 | SPY | ETF | 115.94 | 116.0 | 115.94 | 115.99 | 87900.0 |
| 2005-04-26 09:30:00 | SPY | ETF | 115.96 | 116.11 | 115.81 | 115.84 | 5336200.0 |
| 2005-04-26 10:00:00 | SPY | ETF | 115.85 | 116.2 | 115.7 | 115.94 | 8188700.0 |
| 2005-04-26 10:30:00 | SPY | ETF | 115.94 | 116.77 | 115.92 | 116.65 | 7489800.0 |
| 2005-04-26 11:00:00 | SPY | ETF | 116.65 | 116.65 | 116.11 | 116.35 | 3907000.0 |
| 2005-04-26 11:30:00 | SPY | ETF | 116.35 | 116.49 | 116.22 | 116.27 | 2372900.0 |
| 2005-04-26 12:00:00 | SPY | ETF | 116.27 | 116.28 | 116.15 | 116.19 | 1352100.0 |
| 2005-04-26 12:30:00 | SPY | ETF | 116.2 | 116.2 | 116.05 | 116.1 | 2192100.0 |
| 2005-04-26 13:00:00 | SPY | ETF | 116.1 | 116.1 | 115.75 | 115.76 | 3755700.0 |
| 2005-04-26 13:30:00 | SPY | ETF | 115.76 | 116.14 | 115.73 | 116.06 | 4989700.0 |
| 2005-04-26 14:00:00 | SPY | ETF | 116.05 | 116.09 | 115.57 | 115.67 | 6266400.0 |
| 2005-04-26 14:30:00 | SPY | ETF | 115.67 | 115.93 | 115.44 | 115.48 | 6899200.0 |
| 2005-04-26 15:00:00 | SPY | ETF | 115.47 | 115.87 | 115.45 | 115.77 | 7436800.0 |
| 2005-04-26 15:30:00 | SPY | ETF | 115.77 | 115.79 | 115.22 | 115.22 | 8307300.0 |
| 2005-04-26 16:00:00 | SPY | ETF | 115.21 | 115.64 | 115.14 | 115.2 | 2361700.0 |
| 2005-04-26 16:30:00 | SPY | ETF | 115.18 | 115.22 | 115.13 | 115.18 | 322300.0 |
| 2005-04-26 17:00:00 | SPY | ETF | 115.18 | 115.2 | 115.15 | 115.2 | 215000.0 |
| 2005-04-26 17:30:00 | SPY | ETF | 115.19 | 115.21 | 115.19 | 115.21 | 10800.0 |
| 2005-04-26 18:00:00 | SPY | ETF | 115.2 | 115.2 | 115.11 | 115.11 | 13100.0 |
| 2005-04-26 18:30:00 | SPY | ETF | 115.1 | 115.15 | 115.1 | 115.15 | 700.0 |
| 2005-04-26 19:30:00 | SPY | ETF | 115.15 | 115.15 | 115.15 | 115.15 | 100.0 |
| 2005-04-26 09:30:00 | QQQ | ETF | 35.29 | 35.36 | 35.25 | 35.29 | 9603600.0 |
| 2005-04-26 10:00:00 | QQQ | ETF | 35.3 | 35.38 | 35.18 | 35.29 | 10745100.0 |
| 2005-04-26 10:30:00 | QQQ | ETF | 35.29 | 35.67 | 35.28 | 35.65 | 12067300.0 |
| 2005-04-26 11:00:00 | QQQ | ETF | 35.66 | 35.7 | 35.46 | 35.53 | 6695300.0 |
| 2005-04-26 11:30:00 | QQQ | ETF | 35.53 | 35.57 | 35.49 | 35.5 | 2719000.0 |
| 2005-04-26 12:00:00 | QQQ | ETF | 35.51 | 35.52 | 35.44 | 35.46 | 3077200.0 |
| 2005-04-26 12:30:00 | QQQ | ETF | 35.46 | 35.47 | 35.37 | 35.42 | 2514500.0 |
| 2005-04-26 13:00:00 | QQQ | ETF | 35.42 | 35.42 | 35.18 | 35.21 | 6726400.0 |
| 2005-04-26 13:30:00 | QQQ | ETF | 35.21 | 35.4 | 35.19 | 35.29 | 5430600.0 |
| 2005-04-26 14:00:00 | QQQ | ETF | 35.29 | 35.3 | 35.1 | 35.13 | 8943400.0 |
| 2005-04-26 14:30:00 | QQQ | ETF | 35.14 | 35.21 | 35.06 | 35.08 | 8060100.0 |
| 2005-04-26 15:00:00 | QQQ | ETF | 35.08 | 35.22 | 35.07 | 35.19 | 6441400.0 |
| 2005-04-26 15:30:00 | QQQ | ETF | 35.19 | 35.2 | 35.04 | 35.05 | 9346200.0 |
| 2005-04-26 08:30:00 | IWM | ETF | 59.05 | 59.05 | 58.95 | 58.95 | 8200.0 |
| 2005-04-26 09:00:00 | IWM | ETF | 58.975 | 59.03 | 58.95 | 58.99 | 8600.0 |
| 2005-04-26 09:30:00 | IWM | ETF | 58.98 | 59.08 | 58.83 | 58.905 | 1396800.0 |
| 2005-04-26 10:00:00 | IWM | ETF | 58.9 | 59.26 | 58.69 | 59.07 | 3810000.0 |
| 2005-04-26 10:30:00 | IWM | ETF | 59.075 | 59.555 | 59.075 | 59.555 | 2809000.0 |
| 2005-04-26 11:00:00 | IWM | ETF | 59.55 | 59.565 | 59.12 | 59.24 | 2106400.0 |
| 2005-04-26 11:30:00 | IWM | ETF | 59.245 | 59.32 | 58.975 | 59.08 | 1477600.0 |
| 2005-04-26 12:00:00 | IWM | ETF | 59.07 | 59.145 | 59.02 | 59.08 | 851600.0 |
| 2005-04-26 12:30:00 | IWM | ETF | 59.06 | 59.065 | 58.025 | 58.9 | 1434800.0 |
| 2005-04-26 13:00:00 | IWM | ETF | 58.89 | 58.915 | 58.595 | 58.64 | 2048400.0 |
| 2005-04-26 13:30:00 | IWM | ETF | 58.625 | 58.885 | 58.615 | 58.87 | 2250800.0 |
> showing 50 of 1,470 rows — these rows as CSV