PREVIEW / etf_30min / 2006-10-17
file: by_date/etf_30min/2006/2006-10-17.parquet size: 86 KB rows: 3,019
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-10-17 06:30:00 | SPY | ETF | 136.54 | 136.54 | 136.52 | 136.52 | 3000.0 |
| 2006-10-17 07:00:00 | SPY | ETF | 136.54 | 136.55 | 136.49 | 136.53 | 10000.0 |
| 2006-10-17 07:30:00 | SPY | ETF | 136.6 | 136.6 | 136.5 | 136.53 | 31100.0 |
| 2006-10-17 08:00:00 | SPY | ETF | 136.57 | 136.6 | 136.47 | 136.52 | 1476600.0 |
| 2006-10-17 08:30:00 | SPY | ETF | 136.5 | 136.52 | 136.26 | 136.46 | 4257200.0 |
| 2006-10-17 09:00:00 | SPY | ETF | 136.46 | 136.51 | 136.43 | 136.45 | 416000.0 |
| 2006-10-17 09:30:00 | SPY | ETF | 136.47 | 136.47 | 136.04 | 136.15 | 13699900.0 |
| 2006-10-17 10:00:00 | SPY | ETF | 136.16 | 136.21 | 136.03 | 136.09 | 5082700.0 |
| 2006-10-17 10:30:00 | SPY | ETF | 136.09 | 136.12 | 135.94 | 136.07 | 4351100.0 |
| 2006-10-17 11:00:00 | SPY | ETF | 136.07 | 136.07 | 135.74 | 135.78 | 8760900.0 |
| 2006-10-17 11:30:00 | SPY | ETF | 135.78 | 135.84 | 135.67 | 135.73 | 4984700.0 |
| 2006-10-17 12:00:00 | SPY | ETF | 135.7 | 136.07 | 135.69 | 136.03 | 4418900.0 |
| 2006-10-17 12:30:00 | SPY | ETF | 136.0301 | 136.1 | 135.97 | 136.07 | 2052700.0 |
| 2006-10-17 13:00:00 | SPY | ETF | 136.06 | 136.24 | 136.02 | 136.06 | 5093300.0 |
| 2006-10-17 13:30:00 | SPY | ETF | 136.06 | 136.34 | 136.03 | 136.29 | 4120000.0 |
| 2006-10-17 14:00:00 | SPY | ETF | 136.29 | 136.31 | 136.06 | 136.1 | 4599700.0 |
| 2006-10-17 14:30:00 | SPY | ETF | 136.11 | 136.41 | 136.1 | 136.36 | 4644800.0 |
| 2006-10-17 15:00:00 | SPY | ETF | 136.36 | 136.62 | 136.36 | 136.59 | 7320900.0 |
| 2006-10-17 15:30:00 | SPY | ETF | 136.59 | 136.7 | 136.32 | 136.45 | 8329600.0 |
| 2006-10-17 16:00:00 | SPY | ETF | 136.45 | 136.58 | 136.35 | 136.58 | 1212800.0 |
| 2006-10-17 16:30:00 | SPY | ETF | 136.52 | 136.58 | 136.43 | 136.43 | 180400.0 |
| 2006-10-17 17:00:00 | SPY | ETF | 136.44 | 136.5 | 136.15 | 136.5 | 313400.0 |
| 2006-10-17 17:30:00 | SPY | ETF | 136.55 | 136.63 | 136.53 | 136.57 | 24700.0 |
| 2006-10-17 18:00:00 | SPY | ETF | 136.55 | 136.56 | 136.49 | 136.56 | 342900.0 |
| 2006-10-17 18:30:00 | SPY | ETF | 136.51 | 136.51 | 136.48 | 136.48 | 1100.0 |
| 2006-10-17 19:00:00 | SPY | ETF | 136.5 | 136.5 | 136.5 | 136.5 | 400.0 |
| 2006-10-17 19:30:00 | SPY | ETF | 136.5 | 136.5 | 136.49 | 136.49 | 400.0 |
| 2006-10-17 09:30:00 | QQQ | ETF | 42.17 | 42.2 | 41.89 | 41.97 | 28612600.0 |
| 2006-10-17 10:00:00 | QQQ | ETF | 41.97 | 42.0 | 41.86 | 41.91 | 11732300.0 |
| 2006-10-17 10:30:00 | QQQ | ETF | 41.92 | 41.92 | 41.81 | 41.9 | 7029700.0 |
| 2006-10-17 11:00:00 | QQQ | ETF | 41.9 | 41.91 | 41.78 | 41.79 | 6345900.0 |
| 2006-10-17 11:30:00 | QQQ | ETF | 41.79 | 41.84 | 41.76 | 41.78 | 6511300.0 |
| 2006-10-17 12:00:00 | QQQ | ETF | 41.78 | 41.96 | 41.77 | 41.93 | 11007200.0 |
| 2006-10-17 12:30:00 | QQQ | ETF | 41.93 | 42.0 | 41.9 | 41.97 | 3912500.0 |
| 2006-10-17 13:00:00 | QQQ | ETF | 41.98 | 42.06 | 41.9 | 41.94 | 6280700.0 |
| 2006-10-17 13:30:00 | QQQ | ETF | 41.93 | 42.08 | 41.93 | 42.06 | 6017500.0 |
| 2006-10-17 14:00:00 | QQQ | ETF | 42.06 | 42.07 | 41.94 | 41.95 | 6668100.0 |
| 2006-10-17 14:30:00 | QQQ | ETF | 41.96 | 42.07 | 41.93 | 42.04 | 8637900.0 |
| 2006-10-17 15:00:00 | QQQ | ETF | 42.04 | 42.15 | 42.03 | 42.15 | 12567000.0 |
| 2006-10-17 15:30:00 | QQQ | ETF | 42.15 | 42.19 | 41.99 | 42.01 | 13502000.0 |
| 2006-10-17 07:00:00 | IWM | ETF | 76.43 | 76.43 | 76.09 | 76.12 | 1900.0 |
| 2006-10-17 07:30:00 | IWM | ETF | 76.05 | 76.05 | 76.05 | 76.05 | 2000.0 |
| 2006-10-17 08:00:00 | IWM | ETF | 76.09 | 76.35 | 76.04 | 76.06 | 751700.0 |
| 2006-10-17 08:30:00 | IWM | ETF | 76.01 | 76.12 | 75.85 | 75.96 | 947300.0 |
| 2006-10-17 09:00:00 | IWM | ETF | 75.99 | 76.01 | 75.93 | 75.93 | 205900.0 |
| 2006-10-17 09:30:00 | IWM | ETF | 75.94 | 76.0 | 72.63 | 75.67 | 7967600.0 |
| 2006-10-17 10:00:00 | IWM | ETF | 75.67 | 75.75 | 75.57 | 75.63 | 4376700.0 |
| 2006-10-17 10:30:00 | IWM | ETF | 75.64 | 75.65 | 75.44 | 75.55 | 2895800.0 |
| 2006-10-17 11:00:00 | IWM | ETF | 75.54 | 75.55 | 75.35 | 75.39 | 4528200.0 |
| 2006-10-17 11:30:00 | IWM | ETF | 75.39 | 75.52 | 75.36 | 75.42 | 2706900.0 |
> showing 50 of 3,019 rows — these rows as CSV