PREVIEW / etf_30min / 2006-03-24
file: by_date/etf_30min/2006/2006-03-24.parquet size: 59 KB rows: 2,182
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 |
|---|---|---|---|---|---|---|---|
| 2006-03-24 06:00:00 | SPY | ETF | 129.99 | 129.99 | 129.99 | 129.99 | 2000.0 |
| 2006-03-24 06:30:00 | SPY | ETF | 129.97 | 129.97 | 129.97 | 129.97 | 6500.0 |
| 2006-03-24 07:00:00 | SPY | ETF | 129.89 | 129.97 | 129.89 | 129.97 | 14400.0 |
| 2006-03-24 07:30:00 | SPY | ETF | 129.94 | 130.02 | 129.94 | 129.95 | 36000.0 |
| 2006-03-24 08:00:00 | SPY | ETF | 130.0 | 130.02 | 129.91 | 129.99 | 613000.0 |
| 2006-03-24 08:30:00 | SPY | ETF | 129.94 | 130.0 | 129.91 | 129.99 | 570800.0 |
| 2006-03-24 09:00:00 | SPY | ETF | 129.97 | 130.0 | 129.93 | 129.99 | 68700.0 |
| 2006-03-24 09:30:00 | SPY | ETF | 129.99 | 130.1 | 129.74 | 129.82 | 4191400.0 |
| 2006-03-24 10:00:00 | SPY | ETF | 129.82 | 130.45 | 129.81 | 130.43 | 7488200.0 |
| 2006-03-24 10:30:00 | SPY | ETF | 130.42 | 130.57 | 130.15 | 130.47 | 4355200.0 |
| 2006-03-24 11:00:00 | SPY | ETF | 130.47 | 130.55 | 130.32 | 130.41 | 2373100.0 |
| 2006-03-24 11:30:00 | SPY | ETF | 130.39 | 130.47 | 130.25 | 130.31 | 2054200.0 |
| 2006-03-24 12:00:00 | SPY | ETF | 130.31 | 130.38 | 130.2 | 130.23 | 1231700.0 |
| 2006-03-24 12:30:00 | SPY | ETF | 130.24 | 130.32 | 130.06 | 130.17 | 2489400.0 |
| 2006-03-24 13:00:00 | SPY | ETF | 130.16 | 130.17 | 129.76 | 129.9 | 4145200.0 |
| 2006-03-24 13:30:00 | SPY | ETF | 129.92 | 130.12 | 129.86 | 130.03 | 2117400.0 |
| 2006-03-24 14:00:00 | SPY | ETF | 130.06 | 130.16 | 129.87 | 130.01 | 1606000.0 |
| 2006-03-24 14:30:00 | SPY | ETF | 130.01 | 130.23 | 129.96 | 130.1 | 2179400.0 |
| 2006-03-24 15:00:00 | SPY | ETF | 130.1 | 130.27 | 130.05 | 130.2 | 1859400.0 |
| 2006-03-24 15:30:00 | SPY | ETF | 130.2 | 130.34 | 130.14 | 130.15 | 3305200.0 |
| 2006-03-24 16:00:00 | SPY | ETF | 130.16 | 130.27 | 130.15 | 130.23 | 419200.0 |
| 2006-03-24 16:30:00 | SPY | ETF | 130.1025 | 130.27 | 130.1025 | 130.23 | 68000.0 |
| 2006-03-24 17:00:00 | SPY | ETF | 130.21 | 130.21 | 130.21 | 130.21 | 1300.0 |
| 2006-03-24 17:30:00 | SPY | ETF | 130.24 | 130.24 | 130.21 | 130.21 | 10100.0 |
| 2006-03-24 18:00:00 | SPY | ETF | 130.25 | 130.26 | 130.21 | 130.26 | 4500.0 |
| 2006-03-24 19:30:00 | SPY | ETF | 130.25 | 130.28 | 130.25 | 130.28 | 2000.0 |
| 2006-03-24 09:30:00 | QQQ | ETF | 41.23 | 41.26 | 41.1 | 41.19 | 12946200.0 |
| 2006-03-24 10:00:00 | QQQ | ETF | 41.19 | 41.46 | 41.15 | 41.44 | 15899100.0 |
| 2006-03-24 10:30:00 | QQQ | ETF | 41.44 | 41.5 | 41.4 | 41.47 | 6398400.0 |
| 2006-03-24 11:00:00 | QQQ | ETF | 41.47 | 41.48 | 41.34 | 41.39 | 5663700.0 |
| 2006-03-24 11:30:00 | QQQ | ETF | 41.38 | 41.41 | 41.25 | 41.34 | 5972300.0 |
| 2006-03-24 12:00:00 | QQQ | ETF | 41.33 | 41.36 | 41.25 | 41.28 | 2576700.0 |
| 2006-03-24 12:30:00 | QQQ | ETF | 41.28 | 41.3 | 41.19 | 41.26 | 4955700.0 |
| 2006-03-24 13:00:00 | QQQ | ETF | 41.26 | 41.26 | 41.02 | 41.07 | 6622300.0 |
| 2006-03-24 13:30:00 | QQQ | ETF | 41.07 | 41.18 | 41.06 | 41.15 | 3194100.0 |
| 2006-03-24 14:00:00 | QQQ | ETF | 41.15 | 41.19 | 41.08 | 41.15 | 2296000.0 |
| 2006-03-24 14:30:00 | QQQ | ETF | 41.16 | 41.25 | 41.11 | 41.18 | 4333600.0 |
| 2006-03-24 15:00:00 | QQQ | ETF | 41.18 | 41.27 | 41.16 | 41.25 | 2894700.0 |
| 2006-03-24 15:30:00 | QQQ | ETF | 41.26 | 41.32 | 41.24 | 41.29 | 4537300.0 |
| 2006-03-24 08:00:00 | IWM | ETF | 74.44 | 74.46 | 74.28 | 74.33 | 103900.0 |
| 2006-03-24 08:30:00 | IWM | ETF | 74.29 | 74.32 | 74.29 | 74.32 | 2200.0 |
| 2006-03-24 09:00:00 | IWM | ETF | 74.3 | 74.3 | 74.24 | 74.28 | 152600.0 |
| 2006-03-24 09:30:00 | IWM | ETF | 74.28 | 74.36 | 74.1 | 74.26 | 2186400.0 |
| 2006-03-24 10:00:00 | IWM | ETF | 74.27 | 74.5 | 74.2 | 74.5 | 3947400.0 |
| 2006-03-24 10:30:00 | IWM | ETF | 74.5 | 74.7 | 74.5 | 74.62 | 2585600.0 |
| 2006-03-24 11:00:00 | IWM | ETF | 74.62 | 74.73 | 74.52 | 74.56 | 915700.0 |
| 2006-03-24 11:30:00 | IWM | ETF | 74.56 | 74.61 | 74.47 | 74.55 | 1025100.0 |
| 2006-03-24 12:00:00 | IWM | ETF | 74.54 | 74.58 | 74.47 | 74.5 | 545200.0 |
| 2006-03-24 12:30:00 | IWM | ETF | 74.5 | 74.57 | 74.32 | 74.4 | 1844300.0 |
| 2006-03-24 13:00:00 | IWM | ETF | 74.4 | 74.41 | 74.24 | 74.34 | 1191000.0 |
> showing 50 of 2,182 rows — these rows as CSV