PREVIEW / etf_30min / 2006-03-17
file: by_date/etf_30min/2006/2006-03-17.parquet size: 58 KB rows: 2,165
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-17 06:30:00 | SPY | ETF | 130.57 | 130.58 | 130.57 | 130.58 | 50000.0 |
| 2006-03-17 07:00:00 | SPY | ETF | 130.59 | 130.62 | 130.59 | 130.62 | 26700.0 |
| 2006-03-17 07:30:00 | SPY | ETF | 130.62 | 130.64 | 130.58 | 130.64 | 22300.0 |
| 2006-03-17 08:00:00 | SPY | ETF | 130.62 | 130.64 | 130.37 | 130.4 | 205000.0 |
| 2006-03-17 08:30:00 | SPY | ETF | 130.4 | 130.47 | 130.32 | 130.38 | 188100.0 |
| 2006-03-17 09:00:00 | SPY | ETF | 130.38 | 130.74 | 130.37 | 130.68 | 441200.0 |
| 2006-03-17 09:30:00 | SPY | ETF | 130.68 | 130.73 | 130.44 | 130.6 | 6747900.0 |
| 2006-03-17 10:00:00 | SPY | ETF | 130.6 | 130.74 | 130.51 | 130.65 | 3992800.0 |
| 2006-03-17 10:30:00 | SPY | ETF | 130.65 | 130.7 | 130.38 | 130.45 | 3120600.0 |
| 2006-03-17 11:00:00 | SPY | ETF | 130.45 | 130.62 | 130.42 | 130.5 | 1909400.0 |
| 2006-03-17 11:30:00 | SPY | ETF | 130.5 | 130.6 | 130.49 | 130.59 | 1728100.0 |
| 2006-03-17 12:00:00 | SPY | ETF | 130.59 | 130.76 | 130.54 | 130.75 | 1995100.0 |
| 2006-03-17 12:30:00 | SPY | ETF | 130.78 | 130.9 | 130.7 | 130.76 | 1995600.0 |
| 2006-03-17 13:00:00 | SPY | ETF | 130.76 | 130.8 | 130.56 | 130.6 | 2037000.0 |
| 2006-03-17 13:30:00 | SPY | ETF | 130.59 | 130.61 | 130.42 | 130.54 | 4457000.0 |
| 2006-03-17 14:00:00 | SPY | ETF | 130.55 | 130.68 | 130.5 | 130.61 | 1478300.0 |
| 2006-03-17 14:30:00 | SPY | ETF | 130.61 | 130.64 | 130.42 | 130.51 | 2289000.0 |
| 2006-03-17 15:00:00 | SPY | ETF | 130.5 | 130.6 | 130.43 | 130.46 | 3512900.0 |
| 2006-03-17 15:30:00 | SPY | ETF | 130.48 | 130.61 | 130.44 | 130.58 | 4394600.0 |
| 2006-03-17 16:00:00 | SPY | ETF | 130.58 | 130.69 | 130.55 | 130.62 | 2842800.0 |
| 2006-03-17 16:30:00 | SPY | ETF | 130.61 | 130.67 | 130.59 | 130.67 | 1223200.0 |
| 2006-03-17 17:00:00 | SPY | ETF | 130.65 | 130.7 | 130.6 | 130.6 | 15600.0 |
| 2006-03-17 19:00:00 | SPY | ETF | 130.7 | 130.7 | 130.7 | 130.7 | 1500.0 |
| 2006-03-17 09:30:00 | QQQ | ETF | 41.33 | 41.37 | 41.23 | 41.32 | 9750300.0 |
| 2006-03-17 10:00:00 | QQQ | ETF | 41.32 | 41.41 | 41.31 | 41.35 | 7100200.0 |
| 2006-03-17 10:30:00 | QQQ | ETF | 41.35 | 41.35 | 41.24 | 41.25 | 4610200.0 |
| 2006-03-17 11:00:00 | QQQ | ETF | 41.26 | 41.36 | 41.25 | 41.32 | 4021700.0 |
| 2006-03-17 11:30:00 | QQQ | ETF | 41.32 | 41.45 | 41.32 | 41.44 | 5449500.0 |
| 2006-03-17 12:00:00 | QQQ | ETF | 41.45 | 41.53 | 41.44 | 41.52 | 7237400.0 |
| 2006-03-17 12:30:00 | QQQ | ETF | 41.53 | 41.59 | 41.49 | 41.5 | 5242700.0 |
| 2006-03-17 13:00:00 | QQQ | ETF | 41.5 | 41.54 | 41.41 | 41.44 | 5126900.0 |
| 2006-03-17 13:30:00 | QQQ | ETF | 41.45 | 41.46 | 41.37 | 41.42 | 2825800.0 |
| 2006-03-17 14:00:00 | QQQ | ETF | 41.41 | 41.47 | 41.41 | 41.46 | 2211300.0 |
| 2006-03-17 14:30:00 | QQQ | ETF | 41.46 | 41.48 | 41.35 | 41.39 | 3213700.0 |
| 2006-03-17 15:00:00 | QQQ | ETF | 41.39 | 41.42 | 41.32 | 41.33 | 4653400.0 |
| 2006-03-17 15:30:00 | QQQ | ETF | 41.32 | 41.43 | 41.32 | 41.42 | 7626100.0 |
| 2006-03-17 08:00:00 | IWM | ETF | 73.94 | 73.98 | 73.9 | 73.95 | 51000.0 |
| 2006-03-17 08:30:00 | IWM | ETF | 73.81 | 73.84 | 73.7 | 73.75 | 54200.0 |
| 2006-03-17 09:00:00 | IWM | ETF | 73.8 | 74.18 | 73.8 | 74.14 | 453600.0 |
| 2006-03-17 09:30:00 | IWM | ETF | 74.13 | 74.2 | 73.7 | 73.85 | 4236400.0 |
| 2006-03-17 10:00:00 | IWM | ETF | 73.87 | 74.08 | 73.78 | 73.98 | 2458300.0 |
| 2006-03-17 10:30:00 | IWM | ETF | 73.98 | 74.02 | 73.8 | 73.85 | 2756500.0 |
| 2006-03-17 11:00:00 | IWM | ETF | 73.85 | 74.03 | 73.85 | 73.92 | 1048100.0 |
| 2006-03-17 11:30:00 | IWM | ETF | 73.92 | 74.11 | 73.91 | 74.07 | 716300.0 |
| 2006-03-17 12:00:00 | IWM | ETF | 74.1 | 74.26 | 74.07 | 74.24 | 2005600.0 |
| 2006-03-17 12:30:00 | IWM | ETF | 74.24 | 74.3 | 74.18 | 74.19 | 715300.0 |
| 2006-03-17 13:00:00 | IWM | ETF | 74.18 | 74.25 | 74.09 | 74.18 | 1231900.0 |
| 2006-03-17 13:30:00 | IWM | ETF | 74.18 | 74.3 | 74.15 | 74.2 | 2975600.0 |
| 2006-03-17 14:00:00 | IWM | ETF | 74.2 | 74.3 | 74.17 | 74.22 | 1431200.0 |
| 2006-03-17 14:30:00 | IWM | ETF | 74.22 | 74.27 | 74.06 | 74.18 | 1895200.0 |
> showing 50 of 2,165 rows — these rows as CSV