PREVIEW / etf_1hour / 2016-04-12

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-04-12.parquet
  size:    255 KB
  rows:    8,100

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-04-12 04:00:00	SPY	ETF	203.98	204.3	203.69	204.25	254300.0
2016-04-12 05:00:00	SPY	ETF	204.2	204.61	204.2	204.55	19597.0
2016-04-12 06:00:00	SPY	ETF	204.54	204.74	204.45	204.6	33155.0
2016-04-12 07:00:00	SPY	ETF	204.6	204.71	204.26	204.44	256266.0
2016-04-12 08:00:00	SPY	ETF	204.46	204.67	203.935	204.26	859208.0
2016-04-12 09:00:00	SPY	ETF	204.24	204.78	204.05	204.48	8132418.0
2016-04-12 10:00:00	SPY	ETF	204.5	205.08	203.7	205.0	21586559.0
2016-04-12 11:00:00	SPY	ETF	205.0	205.57	204.8799	205.29	15273444.0
2016-04-12 12:00:00	SPY	ETF	205.29	205.73	205.165	205.6	7179279.0
2016-04-12 13:00:00	SPY	ETF	205.61	205.7	205.3	205.67	9892903.0
2016-04-12 14:00:00	SPY	ETF	205.66	206.0	205.56	205.96	13840584.0
2016-04-12 15:00:00	SPY	ETF	205.96	206.25	205.64	205.94	23966786.0
2016-04-12 16:00:00	SPY	ETF	205.97	206.07	205.75	205.95	7652091.0
2016-04-12 17:00:00	SPY	ETF	205.97	206.04	203.8877	205.97	412382.0
2016-04-12 18:00:00	SPY	ETF	205.98	205.98	205.85	205.96	199443.0
2016-04-12 19:00:00	SPY	ETF	205.94	206.08	205.9	206.07	817090.0
2016-04-12 04:00:00	QQQ	ETF	108.65	108.71	108.45	108.71	3800.0
2016-04-12 05:00:00	QQQ	ETF	108.89	109.05	108.89	109.05	1600.0
2016-04-12 06:00:00	QQQ	ETF	109.09	109.1	108.98	108.99	2800.0
2016-04-12 07:00:00	QQQ	ETF	109.03	109.07	108.81	108.92	91467.0
2016-04-12 08:00:00	QQQ	ETF	109.05	109.05	108.72	108.76	211108.0
2016-04-12 09:00:00	QQQ	ETF	108.75	108.82	108.42	108.4862	3328836.0
2016-04-12 10:00:00	QQQ	ETF	108.49	108.93	108.015	108.9	5381102.0
2016-04-12 11:00:00	QQQ	ETF	108.9	109.27	108.81	108.95	3449068.0
2016-04-12 12:00:00	QQQ	ETF	108.96	109.3099	108.9364	109.19	1691180.0
2016-04-12 13:00:00	QQQ	ETF	109.19	109.3	108.95	109.28	1744237.0
2016-04-12 14:00:00	QQQ	ETF	109.29	109.53	109.195	109.471	2918652.0
2016-04-12 15:00:00	QQQ	ETF	109.47	109.72	109.34	109.51	5744672.0
2016-04-12 16:00:00	QQQ	ETF	109.5	109.55	109.42	109.5	455581.0
2016-04-12 17:00:00	QQQ	ETF	109.53	109.55	109.51	109.52	15000.0
2016-04-12 18:00:00	QQQ	ETF	109.52	109.54	109.46	109.54	17429.0
2016-04-12 19:00:00	QQQ	ETF	109.54	109.6	109.5	109.58	9838.0
2016-04-12 05:00:00	IWM	ETF	108.96	108.96	108.96	108.96	800.0
2016-04-12 06:00:00	IWM	ETF	108.99	108.99	108.95	108.95	400.0
2016-04-12 07:00:00	IWM	ETF	109.0	109.0	108.77	108.96	67446.0
2016-04-12 08:00:00	IWM	ETF	108.93	109.02	108.79	108.83	217047.0
2016-04-12 09:00:00	IWM	ETF	108.81	109.16	108.68	108.95	2227595.0
2016-04-12 10:00:00	IWM	ETF	108.96	109.89	108.43	109.85	5150253.0
2016-04-12 11:00:00	IWM	ETF	109.84	110.18	109.715	109.83	3758013.0
2016-04-12 12:00:00	IWM	ETF	109.83	109.99	109.615	109.795	1392089.0
2016-04-12 13:00:00	IWM	ETF	109.8	110.06	109.49	110.03	1474440.0
2016-04-12 14:00:00	IWM	ETF	110.04	110.12	109.765	109.95	1696871.0
2016-04-12 15:00:00	IWM	ETF	109.95	110.17	109.71	109.97	5503640.0
2016-04-12 16:00:00	IWM	ETF	109.97	110.1085	109.87	109.96	1600472.0
2016-04-12 17:00:00	IWM	ETF	109.94	109.94	109.91	109.91	871.0
2016-04-12 18:00:00	IWM	ETF	109.9	109.94	109.9	109.94	500.0
2016-04-12 19:00:00	IWM	ETF	109.9393	110.0	109.9393	110.0	248300.0
2016-04-12 08:00:00	DIA	ETF	175.79	175.79	175.79	175.79	1500.0
2016-04-12 09:00:00	DIA	ETF	175.62	176.3	175.55	176.1	426246.0
2016-04-12 10:00:00	DIA	ETF	176.11	176.58	175.36	176.46	707241.0

> showing 50 of 8,100 rows — these rows as CSV

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