PREVIEW / etf_30min / 2005-02-18
file: by_date/etf_30min/2005/2005-02-18.parquet size: 41 KB rows: 1,441
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-02-18 08:00:00 | SPY | ETF | 120.41 | 120.45 | 120.41 | 120.43 | 7000.0 |
| 2005-02-18 08:30:00 | SPY | ETF | 120.32 | 120.32 | 119.96 | 120.12 | 808000.0 |
| 2005-02-18 09:00:00 | SPY | ETF | 120.12 | 120.25 | 120.1 | 120.17 | 641600.0 |
| 2005-02-18 09:30:00 | SPY | ETF | 120.17 | 120.31 | 120.07 | 120.23 | 8644900.0 |
| 2005-02-18 10:00:00 | SPY | ETF | 120.23 | 120.44 | 120.2 | 120.28 | 3284800.0 |
| 2005-02-18 10:30:00 | SPY | ETF | 120.28 | 120.44 | 120.09 | 120.25 | 2492200.0 |
| 2005-02-18 11:00:00 | SPY | ETF | 120.25 | 120.36 | 120.21 | 120.26 | 3875800.0 |
| 2005-02-18 11:30:00 | SPY | ETF | 120.26 | 120.3 | 119.9 | 120.01 | 5424000.0 |
| 2005-02-18 12:00:00 | SPY | ETF | 120.03 | 120.31 | 120.01 | 120.18 | 3123600.0 |
| 2005-02-18 12:30:00 | SPY | ETF | 120.18 | 120.35 | 120.17 | 120.32 | 1679800.0 |
| 2005-02-18 13:00:00 | SPY | ETF | 120.32 | 120.35 | 120.14 | 120.27 | 1484000.0 |
| 2005-02-18 13:30:00 | SPY | ETF | 120.27 | 120.31 | 120.19 | 120.28 | 862600.0 |
| 2005-02-18 14:00:00 | SPY | ETF | 120.28 | 120.37 | 120.23 | 120.32 | 2674800.0 |
| 2005-02-18 14:30:00 | SPY | ETF | 120.31 | 120.42 | 120.28 | 120.3 | 1740300.0 |
| 2005-02-18 15:00:00 | SPY | ETF | 120.3 | 120.47 | 120.24 | 120.45 | 3423200.0 |
| 2005-02-18 15:30:00 | SPY | ETF | 120.46 | 120.48 | 120.29 | 120.34 | 4387500.0 |
| 2005-02-18 16:00:00 | SPY | ETF | 120.36 | 120.4 | 120.32 | 120.36 | 637000.0 |
| 2005-02-18 16:30:00 | SPY | ETF | 120.36 | 120.4 | 120.35 | 120.4 | 1019000.0 |
| 2005-02-18 17:00:00 | SPY | ETF | 120.4 | 120.4 | 120.2359 | 120.36 | 785400.0 |
| 2005-02-18 18:00:00 | SPY | ETF | 120.39 | 120.39 | 120.39 | 120.39 | 400.0 |
| 2005-02-18 19:00:00 | SPY | ETF | 120.35 | 120.35 | 120.35 | 120.35 | 100.0 |
| 2005-02-18 09:30:00 | QQQ | ETF | 37.5 | 37.52 | 37.39 | 37.42 | 15606400.0 |
| 2005-02-18 10:00:00 | QQQ | ETF | 37.42 | 37.57 | 37.42 | 37.52 | 6014400.0 |
| 2005-02-18 10:30:00 | QQQ | ETF | 37.52 | 37.55 | 37.39 | 37.49 | 3144900.0 |
| 2005-02-18 11:00:00 | QQQ | ETF | 37.49 | 37.52 | 37.41 | 37.46 | 2821200.0 |
| 2005-02-18 11:30:00 | QQQ | ETF | 37.46 | 37.49 | 37.26 | 37.34 | 7606400.0 |
| 2005-02-18 12:00:00 | QQQ | ETF | 37.34 | 37.44 | 37.33 | 37.37 | 4815200.0 |
| 2005-02-18 12:30:00 | QQQ | ETF | 37.37 | 37.47 | 37.36 | 37.44 | 2418600.0 |
| 2005-02-18 13:00:00 | QQQ | ETF | 37.44 | 37.46 | 37.37 | 37.42 | 1465800.0 |
| 2005-02-18 13:30:00 | QQQ | ETF | 37.42 | 37.42 | 37.36 | 37.41 | 1507000.0 |
| 2005-02-18 14:00:00 | QQQ | ETF | 37.41 | 37.45 | 37.38 | 37.41 | 1671300.0 |
| 2005-02-18 14:30:00 | QQQ | ETF | 37.41 | 37.44 | 37.39 | 37.39 | 1670300.0 |
| 2005-02-18 15:00:00 | QQQ | ETF | 37.39 | 37.42 | 37.35 | 37.39 | 2860100.0 |
| 2005-02-18 15:30:00 | QQQ | ETF | 37.39 | 37.42 | 37.31 | 37.35 | 6986000.0 |
| 2005-02-18 08:30:00 | IWM | ETF | 62.805 | 62.805 | 62.745 | 62.755 | 24800.0 |
| 2005-02-18 09:00:00 | IWM | ETF | 62.8 | 62.8 | 62.77 | 62.8 | 81200.0 |
| 2005-02-18 09:30:00 | IWM | ETF | 62.86 | 63.11 | 62.825 | 63.055 | 2507200.0 |
| 2005-02-18 10:00:00 | IWM | ETF | 63.05 | 63.205 | 63.025 | 63.06 | 1390800.0 |
| 2005-02-18 10:30:00 | IWM | ETF | 63.06 | 63.2 | 62.87 | 62.995 | 1349400.0 |
| 2005-02-18 11:00:00 | IWM | ETF | 62.99 | 63.145 | 62.95 | 62.9805 | 1023600.0 |
| 2005-02-18 11:30:00 | IWM | ETF | 62.98 | 63.015 | 62.69 | 62.78 | 1682800.0 |
| 2005-02-18 12:00:00 | IWM | ETF | 62.78 | 62.935 | 62.665 | 62.695 | 1059000.0 |
| 2005-02-18 12:30:00 | IWM | ETF | 62.695 | 62.755 | 62.615 | 62.69 | 681200.0 |
| 2005-02-18 13:00:00 | IWM | ETF | 62.685 | 62.725 | 62.5 | 62.64 | 983000.0 |
| 2005-02-18 13:30:00 | IWM | ETF | 62.64 | 62.65 | 62.57 | 62.63 | 389400.0 |
| 2005-02-18 14:00:00 | IWM | ETF | 62.625 | 62.76 | 62.585 | 62.685 | 515400.0 |
| 2005-02-18 14:30:00 | IWM | ETF | 62.685 | 62.845 | 62.67 | 62.755 | 556000.0 |
| 2005-02-18 15:00:00 | IWM | ETF | 62.745 | 62.905 | 62.685 | 62.905 | 947800.0 |
| 2005-02-18 15:30:00 | IWM | ETF | 62.895 | 62.93 | 62.72 | 62.755 | 1642600.0 |
| 2005-02-18 16:00:00 | IWM | ETF | 62.75 | 62.815 | 62.715 | 62.79 | 339200.0 |
> showing 50 of 1,441 rows — these rows as CSV