PREVIEW / etf_30min / 2005-04-04
file: by_date/etf_30min/2005/2005-04-04.parquet size: 44 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-04-04 08:00:00 | SPY | ETF | 117.11 | 117.21 | 117.1 | 117.14 | 82600.0 |
| 2005-04-04 08:30:00 | SPY | ETF | 117.15 | 117.31 | 117.15 | 117.28 | 154700.0 |
| 2005-04-04 09:00:00 | SPY | ETF | 117.3 | 117.36 | 117.26 | 117.35 | 158900.0 |
| 2005-04-04 09:30:00 | SPY | ETF | 117.36 | 117.43 | 117.0 | 117.05 | 8383500.0 |
| 2005-04-04 10:00:00 | SPY | ETF | 117.06 | 117.13 | 116.74 | 116.84 | 7145400.0 |
| 2005-04-04 10:30:00 | SPY | ETF | 116.84 | 117.15 | 116.77 | 117.09 | 7720900.0 |
| 2005-04-04 11:00:00 | SPY | ETF | 117.07 | 117.37 | 117.04 | 117.05 | 5993800.0 |
| 2005-04-04 11:30:00 | SPY | ETF | 117.07 | 117.17 | 117.0 | 117.11 | 2132900.0 |
| 2005-04-04 12:00:00 | SPY | ETF | 117.1 | 117.12 | 116.85 | 116.95 | 2443900.0 |
| 2005-04-04 12:30:00 | SPY | ETF | 116.95 | 117.17 | 116.93 | 117.05 | 2522100.0 |
| 2005-04-04 13:00:00 | SPY | ETF | 117.06 | 117.09 | 116.79 | 116.91 | 3613900.0 |
| 2005-04-04 13:30:00 | SPY | ETF | 116.9 | 117.44 | 116.87 | 117.42 | 6358800.0 |
| 2005-04-04 14:00:00 | SPY | ETF | 117.42 | 117.6 | 117.35 | 117.55 | 5066400.0 |
| 2005-04-04 14:30:00 | SPY | ETF | 117.55 | 117.75 | 117.45 | 117.67 | 3730200.0 |
| 2005-04-04 15:00:00 | SPY | ETF | 117.66 | 117.81 | 117.59 | 117.71 | 6242700.0 |
| 2005-04-04 15:30:00 | SPY | ETF | 117.71 | 117.86 | 117.5 | 117.59 | 6448800.0 |
| 2005-04-04 16:00:00 | SPY | ETF | 117.58 | 117.67 | 117.54 | 117.65 | 157900.0 |
| 2005-04-04 16:30:00 | SPY | ETF | 117.67 | 117.77 | 117.63 | 117.77 | 1256800.0 |
| 2005-04-04 17:00:00 | SPY | ETF | 117.76 | 117.78 | 117.74 | 117.74 | 24300.0 |
| 2005-04-04 18:00:00 | SPY | ETF | 117.74 | 117.75 | 117.73 | 117.73 | 5500.0 |
| 2005-04-04 19:00:00 | SPY | ETF | 117.74 | 117.74 | 117.7 | 117.7 | 600.0 |
| 2005-04-04 09:30:00 | QQQ | ETF | 36.26 | 36.27 | 36.1 | 36.11 | 13620700.0 |
| 2005-04-04 10:00:00 | QQQ | ETF | 36.12 | 36.17 | 36.03 | 36.08 | 11992300.0 |
| 2005-04-04 10:30:00 | QQQ | ETF | 36.08 | 36.23 | 36.06 | 36.23 | 7547200.0 |
| 2005-04-04 11:00:00 | QQQ | ETF | 36.22 | 36.31 | 36.18 | 36.2 | 7245200.0 |
| 2005-04-04 11:30:00 | QQQ | ETF | 36.2 | 36.22 | 36.14 | 36.17 | 3602800.0 |
| 2005-04-04 12:00:00 | QQQ | ETF | 36.16 | 36.18 | 36.08 | 36.14 | 2998100.0 |
| 2005-04-04 12:30:00 | QQQ | ETF | 36.14 | 36.21 | 36.13 | 36.18 | 3072300.0 |
| 2005-04-04 13:00:00 | QQQ | ETF | 36.18 | 36.19 | 36.07 | 36.11 | 3271400.0 |
| 2005-04-04 13:30:00 | QQQ | ETF | 36.11 | 36.3 | 36.09 | 36.3 | 5628200.0 |
| 2005-04-04 14:00:00 | QQQ | ETF | 36.29 | 36.45 | 36.29 | 36.43 | 9263400.0 |
| 2005-04-04 14:30:00 | QQQ | ETF | 36.43 | 36.52 | 36.37 | 36.47 | 8155500.0 |
| 2005-04-04 15:00:00 | QQQ | ETF | 36.47 | 36.51 | 36.42 | 36.48 | 5824800.0 |
| 2005-04-04 15:30:00 | QQQ | ETF | 36.48 | 36.6 | 36.44 | 36.45 | 8854300.0 |
| 2005-04-04 08:00:00 | IWM | ETF | 60.665 | 60.735 | 60.665 | 60.735 | 25400.0 |
| 2005-04-04 08:30:00 | IWM | ETF | 60.685 | 60.735 | 60.675 | 60.675 | 10800.0 |
| 2005-04-04 09:00:00 | IWM | ETF | 60.725 | 60.825 | 60.725 | 60.795 | 46800.0 |
| 2005-04-04 09:30:00 | IWM | ETF | 60.72 | 60.755 | 60.55 | 60.583 | 3280400.0 |
| 2005-04-04 10:00:00 | IWM | ETF | 60.575 | 60.605 | 60.2 | 60.275 | 3084600.0 |
| 2005-04-04 10:30:00 | IWM | ETF | 60.28 | 60.515 | 60.245 | 60.44 | 2196000.0 |
| 2005-04-04 11:00:00 | IWM | ETF | 60.44 | 60.585 | 60.405 | 60.41 | 1492800.0 |
| 2005-04-04 11:30:00 | IWM | ETF | 60.405 | 60.465 | 60.355 | 60.4 | 1182800.0 |
| 2005-04-04 12:00:00 | IWM | ETF | 60.4 | 60.425 | 60.285 | 60.365 | 1543600.0 |
| 2005-04-04 12:30:00 | IWM | ETF | 60.365 | 60.42 | 60.325 | 60.39 | 695800.0 |
| 2005-04-04 13:00:00 | IWM | ETF | 60.39 | 60.4 | 60.265 | 60.335 | 286000.0 |
| 2005-04-04 13:30:00 | IWM | ETF | 60.33 | 60.63 | 60.29 | 60.625 | 1734000.0 |
| 2005-04-04 14:00:00 | IWM | ETF | 60.625 | 60.795 | 60.62 | 60.745 | 3989400.0 |
| 2005-04-04 14:30:00 | IWM | ETF | 60.755 | 60.915 | 60.73 | 60.86 | 2215400.0 |
| 2005-04-04 15:00:00 | IWM | ETF | 60.86 | 61.09 | 60.825 | 61.055 | 3558600.0 |
| 2005-04-04 15:30:00 | IWM | ETF | 61.055 | 61.19 | 61.01 | 61.02 | 3690000.0 |
> showing 50 of 1,472 rows — these rows as CSV