PREVIEW / etf_30min / 2005-01-11
file: by_date/etf_30min/2005/2005-01-11.parquet size: 43 KB rows: 1,472
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-01-11 08:00:00 | SPY | ETF | 118.72 | 118.75 | 118.67 | 118.68 | 83700.0 |
| 2005-01-11 08:30:00 | SPY | ETF | 118.67 | 118.67 | 118.56 | 118.65 | 71700.0 |
| 2005-01-11 09:00:00 | SPY | ETF | 118.66 | 118.7 | 118.63 | 118.64 | 150000.0 |
| 2005-01-11 09:30:00 | SPY | ETF | 118.64 | 118.65 | 118.23 | 118.41 | 9565200.0 |
| 2005-01-11 10:00:00 | SPY | ETF | 118.41 | 118.55 | 118.13 | 118.44 | 5437700.0 |
| 2005-01-11 10:30:00 | SPY | ETF | 118.44 | 118.47 | 118.24 | 118.38 | 3897300.0 |
| 2005-01-11 11:00:00 | SPY | ETF | 118.38 | 118.52 | 118.3 | 118.47 | 3046500.0 |
| 2005-01-11 11:30:00 | SPY | ETF | 118.45 | 118.55 | 118.37 | 118.46 | 2202300.0 |
| 2005-01-11 12:00:00 | SPY | ETF | 118.49 | 118.49 | 118.16 | 118.16 | 5122100.0 |
| 2005-01-11 12:30:00 | SPY | ETF | 118.16 | 118.32 | 118.12 | 118.14 | 4205800.0 |
| 2005-01-11 13:00:00 | SPY | ETF | 118.13 | 118.27 | 117.99 | 118.25 | 6150000.0 |
| 2005-01-11 13:30:00 | SPY | ETF | 118.25 | 118.52 | 118.17 | 118.44 | 3397100.0 |
| 2005-01-11 14:00:00 | SPY | ETF | 118.44 | 118.74 | 118.42 | 118.54 | 4696800.0 |
| 2005-01-11 14:30:00 | SPY | ETF | 118.57 | 118.61 | 118.34 | 118.41 | 2768000.0 |
| 2005-01-11 15:00:00 | SPY | ETF | 118.41 | 118.57 | 118.34 | 118.44 | 3022800.0 |
| 2005-01-11 15:30:00 | SPY | ETF | 118.44 | 118.57 | 118.21 | 118.28 | 4709800.0 |
| 2005-01-11 16:00:00 | SPY | ETF | 118.31 | 118.48 | 118.14 | 118.39 | 1504200.0 |
| 2005-01-11 16:30:00 | SPY | ETF | 118.4 | 118.53 | 118.36 | 118.51 | 1585000.0 |
| 2005-01-11 17:00:00 | SPY | ETF | 118.5 | 118.55 | 118.42 | 118.44 | 190000.0 |
| 2005-01-11 17:30:00 | SPY | ETF | 118.45 | 118.45 | 118.4 | 118.45 | 4400.0 |
| 2005-01-11 18:00:00 | SPY | ETF | 118.41 | 118.49 | 118.38 | 118.49 | 60300.0 |
| 2005-01-11 18:30:00 | SPY | ETF | 118.48 | 118.6 | 118.48 | 118.6 | 5900.0 |
| 2005-01-11 19:00:00 | SPY | ETF | 118.6 | 118.6 | 118.6 | 118.6 | 700.0 |
| 2005-01-11 19:30:00 | SPY | ETF | 118.58 | 118.58 | 118.58 | 118.58 | 1000.0 |
| 2005-01-11 09:30:00 | QQQ | ETF | 38.38 | 38.45 | 38.31 | 38.45 | 10838800.0 |
| 2005-01-11 10:00:00 | QQQ | ETF | 38.45 | 38.5 | 38.31 | 38.44 | 9472900.0 |
| 2005-01-11 10:30:00 | QQQ | ETF | 38.44 | 38.47 | 38.32 | 38.45 | 10483400.0 |
| 2005-01-11 11:00:00 | QQQ | ETF | 38.45 | 38.49 | 38.41 | 38.45 | 3945200.0 |
| 2005-01-11 11:30:00 | QQQ | ETF | 38.45 | 38.49 | 38.36 | 38.41 | 3716700.0 |
| 2005-01-11 12:00:00 | QQQ | ETF | 38.41 | 38.42 | 38.18 | 38.21 | 8914000.0 |
| 2005-01-11 12:30:00 | QQQ | ETF | 38.21 | 38.32 | 38.12 | 38.13 | 6420600.0 |
| 2005-01-11 13:00:00 | QQQ | ETF | 38.13 | 38.28 | 38.07 | 38.24 | 8191700.0 |
| 2005-01-11 13:30:00 | QQQ | ETF | 38.25 | 38.36 | 38.19 | 38.29 | 6289200.0 |
| 2005-01-11 14:00:00 | QQQ | ETF | 38.29 | 38.46 | 38.29 | 38.36 | 6596100.0 |
| 2005-01-11 14:30:00 | QQQ | ETF | 38.36 | 38.39 | 38.23 | 38.28 | 3944000.0 |
| 2005-01-11 15:00:00 | QQQ | ETF | 38.28 | 38.39 | 38.26 | 38.3 | 5489600.0 |
| 2005-01-11 15:30:00 | QQQ | ETF | 38.31 | 38.38 | 38.17 | 38.25 | 10436300.0 |
| 2005-01-11 08:30:00 | IWM | ETF | 61.4 | 61.4 | 61.3 | 61.3 | 3800.0 |
| 2005-01-11 09:00:00 | IWM | ETF | 61.365 | 61.365 | 61.315 | 61.315 | 600.0 |
| 2005-01-11 09:30:00 | IWM | ETF | 61.245 | 61.285 | 60.88 | 60.99 | 3405000.0 |
| 2005-01-11 10:00:00 | IWM | ETF | 60.95 | 61.03 | 60.6455 | 60.95 | 3545000.0 |
| 2005-01-11 10:30:00 | IWM | ETF | 60.97 | 60.97 | 60.735 | 60.89 | 1067800.0 |
| 2005-01-11 11:00:00 | IWM | ETF | 60.885 | 61.03 | 60.87 | 60.945 | 1012200.0 |
| 2005-01-11 11:30:00 | IWM | ETF | 60.945 | 61.0 | 60.88 | 60.99 | 758600.0 |
| 2005-01-11 12:00:00 | IWM | ETF | 61.01 | 61.01 | 60.765 | 60.79 | 987200.0 |
| 2005-01-11 12:30:00 | IWM | ETF | 60.82 | 60.9 | 60.78 | 60.8 | 1470600.0 |
| 2005-01-11 13:00:00 | IWM | ETF | 60.795 | 60.89 | 60.625 | 60.84 | 1815800.0 |
| 2005-01-11 13:30:00 | IWM | ETF | 60.85 | 60.965 | 60.795 | 60.945 | 1805000.0 |
| 2005-01-11 14:00:00 | IWM | ETF | 60.945 | 61.25 | 60.91 | 61.095 | 2330000.0 |
| 2005-01-11 14:30:00 | IWM | ETF | 61.09 | 61.15 | 61.015 | 61.045 | 921200.0 |
> showing 50 of 1,472 rows — these rows as CSV