PREVIEW / etf_30min / 2006-06-28
file: by_date/etf_30min/2006/2006-06-28.parquet size: 70 KB rows: 2,470
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-06-28 06:00:00 | SPY | ETF | 124.22 | 124.22 | 124.22 | 124.22 | 25000.0 |
| 2006-06-28 06:30:00 | SPY | ETF | 124.13 | 124.13 | 124.13 | 124.13 | 100.0 |
| 2006-06-28 07:00:00 | SPY | ETF | 124.13 | 124.14 | 124.12 | 124.14 | 51200.0 |
| 2006-06-28 07:30:00 | SPY | ETF | 124.12 | 124.2 | 124.12 | 124.2 | 15500.0 |
| 2006-06-28 08:00:00 | SPY | ETF | 124.2 | 124.31 | 124.15 | 124.26 | 728800.0 |
| 2006-06-28 08:30:00 | SPY | ETF | 124.25 | 124.37 | 124.24 | 124.28 | 628200.0 |
| 2006-06-28 09:00:00 | SPY | ETF | 124.28 | 124.32 | 124.15 | 124.17 | 245900.0 |
| 2006-06-28 09:30:00 | SPY | ETF | 124.19 | 124.35 | 124.02 | 124.1 | 7502200.0 |
| 2006-06-28 10:00:00 | SPY | ETF | 124.1 | 124.33 | 124.08 | 124.16 | 3579600.0 |
| 2006-06-28 10:30:00 | SPY | ETF | 124.16 | 124.27 | 123.87 | 123.97 | 5719200.0 |
| 2006-06-28 11:00:00 | SPY | ETF | 123.98 | 124.06 | 123.69 | 123.77 | 4126900.0 |
| 2006-06-28 11:30:00 | SPY | ETF | 123.77 | 124.0 | 123.65 | 123.95 | 3595500.0 |
| 2006-06-28 12:00:00 | SPY | ETF | 123.95 | 124.28 | 123.9 | 124.18 | 3347600.0 |
| 2006-06-28 12:30:00 | SPY | ETF | 124.19 | 124.2 | 123.94 | 124.07 | 2120800.0 |
| 2006-06-28 13:00:00 | SPY | ETF | 124.07 | 124.19 | 123.98 | 124.06 | 1671600.0 |
| 2006-06-28 13:30:00 | SPY | ETF | 124.06 | 124.18 | 123.9 | 124.05 | 2258200.0 |
| 2006-06-28 14:00:00 | SPY | ETF | 124.05 | 124.33 | 123.97 | 124.33 | 4877500.0 |
| 2006-06-28 14:30:00 | SPY | ETF | 124.32 | 124.71 | 124.28 | 124.45 | 9413100.0 |
| 2006-06-28 15:00:00 | SPY | ETF | 124.44 | 124.55 | 124.34 | 124.46 | 5187000.0 |
| 2006-06-28 15:30:00 | SPY | ETF | 124.46 | 124.62 | 124.34 | 124.58 | 4231800.0 |
| 2006-06-28 16:00:00 | SPY | ETF | 124.59 | 124.81 | 124.59 | 124.8 | 716500.0 |
| 2006-06-28 16:30:00 | SPY | ETF | 124.79 | 124.83 | 124.59 | 124.75 | 122100.0 |
| 2006-06-28 17:00:00 | SPY | ETF | 124.75 | 124.76 | 124.71 | 124.74 | 161500.0 |
| 2006-06-28 17:30:00 | SPY | ETF | 124.75 | 124.78 | 124.75 | 124.78 | 900.0 |
| 2006-06-28 19:30:00 | SPY | ETF | 124.76 | 124.78 | 124.72 | 124.78 | 3100.0 |
| 2006-06-28 09:30:00 | QQQ | ETF | 37.64 | 37.65 | 37.46 | 37.54 | 13919100.0 |
| 2006-06-28 10:00:00 | QQQ | ETF | 37.55 | 37.65 | 37.54 | 37.57 | 8539700.0 |
| 2006-06-28 10:30:00 | QQQ | ETF | 37.58 | 37.59 | 37.44 | 37.52 | 7479500.0 |
| 2006-06-28 11:00:00 | QQQ | ETF | 37.52 | 37.55 | 37.4 | 37.43 | 5550000.0 |
| 2006-06-28 11:30:00 | QQQ | ETF | 37.43 | 37.5 | 37.38 | 37.48 | 4684100.0 |
| 2006-06-28 12:00:00 | QQQ | ETF | 37.47 | 37.62 | 37.45 | 37.59 | 4873800.0 |
| 2006-06-28 12:30:00 | QQQ | ETF | 37.59 | 37.59 | 37.48 | 37.53 | 2356600.0 |
| 2006-06-28 13:00:00 | QQQ | ETF | 37.53 | 37.58 | 37.5 | 37.54 | 2101400.0 |
| 2006-06-28 13:30:00 | QQQ | ETF | 37.54 | 37.56 | 37.49 | 37.56 | 2022600.0 |
| 2006-06-28 14:00:00 | QQQ | ETF | 37.55 | 37.67 | 37.53 | 37.67 | 6773100.0 |
| 2006-06-28 14:30:00 | QQQ | ETF | 37.67 | 37.84 | 37.66 | 37.72 | 10010900.0 |
| 2006-06-28 15:00:00 | QQQ | ETF | 37.73 | 37.79 | 37.71 | 37.75 | 7808500.0 |
| 2006-06-28 15:30:00 | QQQ | ETF | 37.75 | 37.81 | 37.72 | 37.8 | 9335400.0 |
| 2006-06-28 07:30:00 | IWM | ETF | 68.45 | 68.45 | 68.45 | 68.45 | 100.0 |
| 2006-06-28 08:00:00 | IWM | ETF | 68.42 | 68.47 | 68.42 | 68.47 | 56500.0 |
| 2006-06-28 08:30:00 | IWM | ETF | 68.47 | 68.58 | 68.47 | 68.5 | 94000.0 |
| 2006-06-28 09:00:00 | IWM | ETF | 68.5 | 68.55 | 68.36 | 68.37 | 97700.0 |
| 2006-06-28 09:30:00 | IWM | ETF | 68.35 | 68.44 | 67.96 | 68.23 | 4848200.0 |
| 2006-06-28 10:00:00 | IWM | ETF | 68.23 | 68.42 | 68.14 | 68.2 | 2631000.0 |
| 2006-06-28 10:30:00 | IWM | ETF | 68.2 | 68.36 | 67.88 | 67.93 | 3389200.0 |
| 2006-06-28 11:00:00 | IWM | ETF | 67.92 | 67.94 | 67.53 | 67.57 | 6784600.0 |
| 2006-06-28 11:30:00 | IWM | ETF | 67.57 | 67.8 | 67.5 | 67.77 | 4946000.0 |
| 2006-06-28 12:00:00 | IWM | ETF | 67.78 | 68.01 | 67.72 | 67.99 | 1886100.0 |
| 2006-06-28 12:30:00 | IWM | ETF | 67.97 | 68.02 | 67.77 | 67.83 | 1591400.0 |
| 2006-06-28 13:00:00 | IWM | ETF | 67.83 | 67.97 | 67.78 | 67.88 | 848900.0 |
> showing 50 of 2,470 rows — these rows as CSV