PREVIEW / etf_30min / 2006-12-01
file: by_date/etf_30min/2006/2006-12-01.parquet size: 91 KB rows: 3,067
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-12-01 06:30:00 | SPY | ETF | 140.62 | 140.62 | 140.62 | 140.62 | 5000.0 |
| 2006-12-01 07:00:00 | SPY | ETF | 140.59 | 140.69 | 140.55 | 140.69 | 2700.0 |
| 2006-12-01 07:30:00 | SPY | ETF | 140.69 | 140.73 | 140.62 | 140.72 | 80300.0 |
| 2006-12-01 08:00:00 | SPY | ETF | 140.71 | 140.73 | 140.56 | 140.56 | 125900.0 |
| 2006-12-01 08:30:00 | SPY | ETF | 140.6 | 140.6 | 140.47 | 140.51 | 910600.0 |
| 2006-12-01 09:00:00 | SPY | ETF | 140.53 | 140.53 | 140.46 | 140.52 | 150100.0 |
| 2006-12-01 09:30:00 | SPY | ETF | 140.53 | 140.66 | 140.43 | 140.46 | 6427000.0 |
| 2006-12-01 10:00:00 | SPY | ETF | 140.47 | 140.48 | 139.68 | 139.74 | 16843100.0 |
| 2006-12-01 10:30:00 | SPY | ETF | 139.75 | 139.75 | 139.32 | 139.59 | 15149600.0 |
| 2006-12-01 11:00:00 | SPY | ETF | 139.59 | 139.87 | 139.58 | 139.76 | 5901100.0 |
| 2006-12-01 11:30:00 | SPY | ETF | 139.77 | 140.37 | 139.66 | 140.31 | 8952400.0 |
| 2006-12-01 12:00:00 | SPY | ETF | 140.3 | 140.35 | 139.87 | 139.99 | 4235100.0 |
| 2006-12-01 12:30:00 | SPY | ETF | 139.99 | 140.06 | 139.85 | 139.95 | 1733600.0 |
| 2006-12-01 13:00:00 | SPY | ETF | 139.95 | 139.95 | 139.54 | 139.65 | 6914300.0 |
| 2006-12-01 13:30:00 | SPY | ETF | 139.65 | 139.75 | 139.43 | 139.67 | 6382000.0 |
| 2006-12-01 14:00:00 | SPY | ETF | 139.66 | 139.71 | 139.29 | 139.42 | 10545700.0 |
| 2006-12-01 14:30:00 | SPY | ETF | 139.42 | 139.5 | 138.97 | 139.26 | 13377200.0 |
| 2006-12-01 15:00:00 | SPY | ETF | 139.27 | 139.68 | 139.2 | 139.63 | 5859900.0 |
| 2006-12-01 15:30:00 | SPY | ETF | 139.63 | 140.09 | 139.48 | 140.06 | 8548900.0 |
| 2006-12-01 16:00:00 | SPY | ETF | 140.05 | 140.4703 | 139.98 | 140.21 | 3273600.0 |
| 2006-12-01 16:30:00 | SPY | ETF | 140.21 | 140.25 | 139.92 | 140.25 | 200500.0 |
| 2006-12-01 17:00:00 | SPY | ETF | 140.25 | 140.35 | 140.21 | 140.34 | 162500.0 |
| 2006-12-01 17:30:00 | SPY | ETF | 140.34 | 140.39 | 140.27 | 140.39 | 44000.0 |
| 2006-12-01 18:00:00 | SPY | ETF | 140.34 | 140.41 | 140.28 | 140.35 | 14500.0 |
| 2006-12-01 18:30:00 | SPY | ETF | 140.33 | 140.35 | 140.28 | 140.35 | 1700.0 |
| 2006-12-01 19:00:00 | SPY | ETF | 140.35 | 140.35 | 140.35 | 140.35 | 200.0 |
| 2006-12-01 19:30:00 | SPY | ETF | 140.35 | 140.35 | 140.35 | 140.35 | 500.0 |
| 2006-12-01 09:30:00 | QQQ | ETF | 44.01 | 44.2 | 43.86 | 43.88 | 9539500.0 |
| 2006-12-01 10:00:00 | QQQ | ETF | 43.88 | 43.9 | 43.49 | 43.53 | 27457100.0 |
| 2006-12-01 10:30:00 | QQQ | ETF | 43.53 | 43.58 | 43.34 | 43.53 | 17572100.0 |
| 2006-12-01 11:00:00 | QQQ | ETF | 43.53 | 43.63 | 43.5 | 43.54 | 9446400.0 |
| 2006-12-01 11:30:00 | QQQ | ETF | 43.54 | 43.75 | 43.49 | 43.7 | 8669800.0 |
| 2006-12-01 12:00:00 | QQQ | ETF | 43.7 | 43.74 | 43.59 | 43.62 | 6324700.0 |
| 2006-12-01 12:30:00 | QQQ | ETF | 43.62 | 43.65 | 43.54 | 43.58 | 3569600.0 |
| 2006-12-01 13:00:00 | QQQ | ETF | 43.57 | 43.58 | 43.42 | 43.48 | 8287500.0 |
| 2006-12-01 13:30:00 | QQQ | ETF | 43.47 | 43.5 | 43.35 | 43.44 | 8184600.0 |
| 2006-12-01 14:00:00 | QQQ | ETF | 43.44 | 43.51 | 43.34 | 43.42 | 7713700.0 |
| 2006-12-01 14:30:00 | QQQ | ETF | 43.42 | 44.35 | 31.36 | 43.37 | 10808100.0 |
| 2006-12-01 15:00:00 | QQQ | ETF | 43.37 | 43.52 | 43.34 | 43.5 | 6721000.0 |
| 2006-12-01 15:30:00 | QQQ | ETF | 43.49 | 43.66 | 43.46 | 43.66 | 12436000.0 |
| 2006-12-01 07:30:00 | IWM | ETF | 78.1 | 78.2 | 78.1 | 78.16 | 22000.0 |
| 2006-12-01 08:00:00 | IWM | ETF | 78.16 | 78.2 | 76.32 | 78.18 | 70700.0 |
| 2006-12-01 08:30:00 | IWM | ETF | 78.16 | 78.19 | 78.1 | 78.15 | 58800.0 |
| 2006-12-01 09:00:00 | IWM | ETF | 78.12 | 78.21 | 78.12 | 78.17 | 95900.0 |
| 2006-12-01 09:30:00 | IWM | ETF | 78.15 | 78.37 | 77.95 | 77.96 | 3829200.0 |
| 2006-12-01 10:00:00 | IWM | ETF | 77.96 | 77.98 | 77.2 | 77.34 | 10299600.0 |
| 2006-12-01 10:30:00 | IWM | ETF | 77.3394 | 77.35 | 77.06 | 77.31 | 6973700.0 |
| 2006-12-01 11:00:00 | IWM | ETF | 77.31 | 77.39 | 77.09 | 77.13 | 5775900.0 |
| 2006-12-01 11:30:00 | IWM | ETF | 77.14 | 77.69 | 77.07 | 77.59 | 4051700.0 |
| 2006-12-01 12:00:00 | IWM | ETF | 77.6 | 77.68 | 77.46 | 77.51 | 2276500.0 |
> showing 50 of 3,067 rows — these rows as CSV