PREVIEW / etf_1hour / 2016-05-05

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-05-05.parquet
  size:    247 KB
  rows:    7,952

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
2016-05-05 04:00:00	SPY	ETF	205.71	206.46	205.66	206.34	14520.0
2016-05-05 05:00:00	SPY	ETF	206.34	206.35	205.86	205.88	12290.0
2016-05-05 06:00:00	SPY	ETF	205.9	205.93	205.64	205.93	133992.0
2016-05-05 07:00:00	SPY	ETF	205.94	206.04	205.68	205.9	330869.0
2016-05-05 08:00:00	SPY	ETF	205.87	205.97	205.68	205.8	626186.0
2016-05-05 09:00:00	SPY	ETF	205.81	205.81	205.24	205.43	7886897.0
2016-05-05 10:00:00	SPY	ETF	205.44	205.98	205.19	205.48	10418926.0
2016-05-05 11:00:00	SPY	ETF	205.49	205.73	205.05	205.615	7135821.0
2016-05-05 12:00:00	SPY	ETF	205.62	205.74	205.22	205.37	4470796.0
2016-05-05 13:00:00	SPY	ETF	205.37	205.395	204.47	204.68	8683159.0
2016-05-05 14:00:00	SPY	ETF	204.68	205.09	204.55	204.73	8698444.0
2016-05-05 15:00:00	SPY	ETF	204.73	205.0	204.54	204.98	13975932.0
2016-05-05 16:00:00	SPY	ETF	204.98	205.1429	204.8	204.88	3821019.0
2016-05-05 17:00:00	SPY	ETF	204.88	204.88	204.82	204.88	595838.0
2016-05-05 18:00:00	SPY	ETF	204.86	204.86	204.43	204.52	131021.0
2016-05-05 19:00:00	SPY	ETF	204.54	204.89	204.54	204.89	79472.0
2016-05-05 04:00:00	QQQ	ETF	105.7	105.97	105.7	105.9	16598.0
2016-05-05 05:00:00	QQQ	ETF	105.87	105.9	105.6	105.6	7502.0
2016-05-05 06:00:00	QQQ	ETF	105.62	105.63	105.48	105.52	5419.0
2016-05-05 07:00:00	QQQ	ETF	105.62	105.64	105.49	105.59	33893.0
2016-05-05 08:00:00	QQQ	ETF	105.6	105.61	105.5	105.55	85954.0
2016-05-05 09:00:00	QQQ	ETF	105.55	105.55	105.05	105.14	3402747.0
2016-05-05 10:00:00	QQQ	ETF	105.13	105.59	105.05	105.36	3510123.0
2016-05-05 11:00:00	QQQ	ETF	105.37	105.66	105.16	105.51	2309395.0
2016-05-05 12:00:00	QQQ	ETF	105.51	105.5865	105.29	105.34	1386921.0
2016-05-05 13:00:00	QQQ	ETF	105.335	105.36	104.81	104.9642	2645143.0
2016-05-05 14:00:00	QQQ	ETF	104.96	105.24	104.86	104.98	1552179.0
2016-05-05 15:00:00	QQQ	ETF	104.98	105.13	104.885	105.03	2913808.0
2016-05-05 16:00:00	QQQ	ETF	105.03	105.05	104.93	104.95	532687.0
2016-05-05 17:00:00	QQQ	ETF	104.93	105.0	104.93	105.0	8329.0
2016-05-05 18:00:00	QQQ	ETF	104.95	104.95	104.7	104.73	25853.0
2016-05-05 19:00:00	QQQ	ETF	104.76	104.92	104.73	104.92	21447.0
2016-05-05 04:00:00	IWM	ETF	111.28	111.54	111.27	111.54	7300.0
2016-05-05 05:00:00	IWM	ETF	111.53	111.53	111.52	111.52	1100.0
2016-05-05 06:00:00	IWM	ETF	111.23	111.3	111.23	111.3	28997.0
2016-05-05 07:00:00	IWM	ETF	111.3	111.32	111.16	111.32	16417.0
2016-05-05 08:00:00	IWM	ETF	111.24	111.34	111.19	111.3	64072.0
2016-05-05 09:00:00	IWM	ETF	111.31	111.33	110.66	111.13	4142850.0
2016-05-05 10:00:00	IWM	ETF	111.12	111.32	110.52	110.935	3936029.0
2016-05-05 11:00:00	IWM	ETF	110.96	111.02	110.55	110.81	1939312.0
2016-05-05 12:00:00	IWM	ETF	110.8	110.94	110.48	110.69	3148616.0
2016-05-05 13:00:00	IWM	ETF	110.68	110.69	110.1	110.32	2678093.0
2016-05-05 14:00:00	IWM	ETF	110.33	110.68	110.25	110.39	1665767.0
2016-05-05 15:00:00	IWM	ETF	110.395	110.63	110.16	110.26	4050175.0
2016-05-05 16:00:00	IWM	ETF	110.26	110.26	110.1	110.13	448611.0
2016-05-05 17:00:00	IWM	ETF	110.13	110.16	110.11	110.13	20019.0
2016-05-05 18:00:00	IWM	ETF	110.16	110.21	110.1	110.1	30678.0
2016-05-05 19:00:00	IWM	ETF	110.13	110.21	110.1	110.21	12711.0
2016-05-05 04:00:00	DIA	ETF	177.35	177.35	177.35	177.35	200.0
2016-05-05 07:00:00	DIA	ETF	176.87	176.87	176.87	176.87	2500.0

> showing 50 of 7,952 rows — these rows as CSV

> unlock the full archive -- $79 one-time