PREVIEW / etf_30min / 2006-01-12
file: by_date/etf_30min/2006/2006-01-12.parquet size: 59 KB rows: 2,104
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-01-12 04:30:00 | SPY | ETF | 129.22 | 129.22 | 129.22 | 129.22 | 200.0 |
| 2006-01-12 06:00:00 | SPY | ETF | 129.25 | 129.25 | 129.25 | 129.25 | 100.0 |
| 2006-01-12 06:30:00 | SPY | ETF | 129.2 | 129.2 | 129.2 | 129.2 | 800.0 |
| 2006-01-12 07:00:00 | SPY | ETF | 129.19 | 129.19 | 129.17 | 129.19 | 8400.0 |
| 2006-01-12 07:30:00 | SPY | ETF | 129.12 | 129.15 | 129.1 | 129.11 | 58600.0 |
| 2006-01-12 08:00:00 | SPY | ETF | 129.13 | 129.19 | 129.1 | 129.14 | 716500.0 |
| 2006-01-12 08:30:00 | SPY | ETF | 129.14 | 129.24 | 129.11 | 129.17 | 85300.0 |
| 2006-01-12 09:00:00 | SPY | ETF | 129.15 | 129.2 | 129.09 | 129.1 | 88000.0 |
| 2006-01-12 09:30:00 | SPY | ETF | 129.08 | 129.2 | 129.05 | 129.13 | 3217300.0 |
| 2006-01-12 10:00:00 | SPY | ETF | 129.13 | 129.24 | 129.05 | 129.19 | 2754500.0 |
| 2006-01-12 10:30:00 | SPY | ETF | 129.1808 | 129.28 | 129.0 | 129.23 | 1960700.0 |
| 2006-01-12 11:00:00 | SPY | ETF | 129.23 | 129.25 | 129.01 | 129.08 | 1860900.0 |
| 2006-01-12 11:30:00 | SPY | ETF | 129.08 | 129.27 | 129.07 | 129.2 | 1222200.0 |
| 2006-01-12 12:00:00 | SPY | ETF | 129.19 | 129.24 | 129.06 | 129.12 | 1187100.0 |
| 2006-01-12 12:30:00 | SPY | ETF | 129.13 | 129.23 | 129.09 | 129.1 | 1596700.0 |
| 2006-01-12 13:00:00 | SPY | ETF | 129.1 | 129.2 | 129.07 | 129.12 | 1413400.0 |
| 2006-01-12 13:30:00 | SPY | ETF | 129.13 | 129.15 | 128.75 | 128.87 | 3268700.0 |
| 2006-01-12 14:00:00 | SPY | ETF | 128.87 | 128.88 | 128.58 | 128.67 | 4819600.0 |
| 2006-01-12 14:30:00 | SPY | ETF | 128.67 | 128.78 | 128.51 | 128.6 | 5095900.0 |
| 2006-01-12 15:00:00 | SPY | ETF | 128.6 | 128.71 | 128.5 | 128.56 | 3357200.0 |
| 2006-01-12 15:30:00 | SPY | ETF | 128.55 | 128.7 | 128.44 | 128.59 | 6267800.0 |
| 2006-01-12 16:00:00 | SPY | ETF | 128.6 | 128.81 | 128.6 | 128.76 | 475600.0 |
| 2006-01-12 16:30:00 | SPY | ETF | 128.75 | 128.75 | 128.56 | 128.71 | 43000.0 |
| 2006-01-12 17:00:00 | SPY | ETF | 128.74 | 128.79 | 128.74 | 128.77 | 6500.0 |
| 2006-01-12 17:30:00 | SPY | ETF | 128.75 | 128.78 | 128.75 | 128.78 | 1600.0 |
| 2006-01-12 18:00:00 | SPY | ETF | 128.76 | 128.77 | 128.75 | 128.77 | 2000.0 |
| 2006-01-12 19:00:00 | SPY | ETF | 128.75 | 128.75 | 128.75 | 128.75 | 1000.0 |
| 2006-01-12 19:30:00 | SPY | ETF | 128.77 | 128.77 | 128.77 | 128.77 | 15000.0 |
| 2006-01-12 09:30:00 | QQQ | ETF | 43.16 | 43.22 | 42.5 | 43.16 | 9926400.0 |
| 2006-01-12 10:00:00 | QQQ | ETF | 43.17 | 43.21 | 43.12 | 43.18 | 4514200.0 |
| 2006-01-12 10:30:00 | QQQ | ETF | 43.18 | 43.28 | 43.09 | 43.23 | 5524100.0 |
| 2006-01-12 11:00:00 | QQQ | ETF | 43.22 | 43.23 | 43.14 | 43.17 | 3471400.0 |
| 2006-01-12 11:30:00 | QQQ | ETF | 43.17 | 43.28 | 43.17 | 43.25 | 2469800.0 |
| 2006-01-12 12:00:00 | QQQ | ETF | 43.24 | 43.29 | 43.2 | 43.22 | 2100500.0 |
| 2006-01-12 12:30:00 | QQQ | ETF | 43.21 | 43.27 | 43.2 | 43.23 | 1775300.0 |
| 2006-01-12 13:00:00 | QQQ | ETF | 43.23 | 43.25 | 43.19 | 43.21 | 1888300.0 |
| 2006-01-12 13:30:00 | QQQ | ETF | 43.22 | 43.24 | 43.04 | 43.09 | 6962500.0 |
| 2006-01-12 14:00:00 | QQQ | ETF | 43.09 | 43.1 | 42.9 | 42.94 | 10532900.0 |
| 2006-01-12 14:30:00 | QQQ | ETF | 42.93 | 43.0 | 42.85 | 42.93 | 6210300.0 |
| 2006-01-12 15:00:00 | QQQ | ETF | 42.93 | 42.99 | 42.89 | 42.92 | 7533400.0 |
| 2006-01-12 15:30:00 | QQQ | ETF | 42.91 | 43.0 | 42.88 | 42.99 | 11143100.0 |
| 2006-01-12 08:00:00 | IWM | ETF | 70.51 | 70.53 | 70.43 | 70.43 | 2300.0 |
| 2006-01-12 08:30:00 | IWM | ETF | 70.43 | 70.48 | 70.43 | 70.48 | 5700.0 |
| 2006-01-12 09:00:00 | IWM | ETF | 70.48 | 70.48 | 70.44 | 70.48 | 143300.0 |
| 2006-01-12 09:30:00 | IWM | ETF | 70.45 | 70.69 | 70.45 | 70.55 | 2844100.0 |
| 2006-01-12 10:00:00 | IWM | ETF | 70.54 | 70.65 | 70.35 | 70.44 | 3994700.0 |
| 2006-01-12 10:30:00 | IWM | ETF | 70.45 | 70.54 | 70.32 | 70.51 | 1691300.0 |
| 2006-01-12 11:00:00 | IWM | ETF | 70.51 | 70.6 | 70.4 | 70.56 | 779500.0 |
| 2006-01-12 11:30:00 | IWM | ETF | 70.54 | 70.67 | 70.53 | 70.62 | 965600.0 |
| 2006-01-12 12:00:00 | IWM | ETF | 70.63 | 70.69 | 70.57 | 70.63 | 796500.0 |
> showing 50 of 2,104 rows — these rows as CSV