PREVIEW / etf_1hour / 2014-05-20

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-05-20.parquet
  size:    213 KB
  rows:    6,729

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
2014-05-20 04:00:00	SPY	ETF	188.83	188.83	188.46	188.56	12671.0
2014-05-20 05:00:00	SPY	ETF	188.66	188.7	188.61	188.62	1961.0
2014-05-20 06:00:00	SPY	ETF	188.59	188.75	188.59	188.71	20368.0
2014-05-20 07:00:00	SPY	ETF	188.68	188.91	188.68	188.79	132518.0
2014-05-20 08:00:00	SPY	ETF	188.77	188.9	188.63	188.64	420922.0
2014-05-20 09:00:00	SPY	ETF	188.64	188.67	188.0	188.08	11706497.0
2014-05-20 10:00:00	SPY	ETF	188.09	188.58	188.0	188.545	15665767.0
2014-05-20 11:00:00	SPY	ETF	188.55	188.588	188.26	188.33	8958879.0
2014-05-20 12:00:00	SPY	ETF	188.33	188.34	187.61	187.8	13133224.0
2014-05-20 13:00:00	SPY	ETF	187.8	187.805	187.07	187.08	13361546.0
2014-05-20 14:00:00	SPY	ETF	187.08	187.53	187.075	187.28	11425534.0
2014-05-20 15:00:00	SPY	ETF	187.27	187.89	187.22	187.53	21223294.0
2014-05-20 16:00:00	SPY	ETF	187.51	188.7948	187.37	187.46	9423969.0
2014-05-20 17:00:00	SPY	ETF	187.46	187.47	187.41	187.43	1092439.0
2014-05-20 18:00:00	SPY	ETF	187.43	187.43	187.33	187.33	62865.0
2014-05-20 19:00:00	SPY	ETF	187.33	187.34	187.25	187.31	70172.0
2014-05-20 04:00:00	QQQ	ETF	88.28	88.42	88.28	88.29	5320.0
2014-05-20 06:00:00	QQQ	ETF	88.29	88.29	88.29	88.29	200.0
2014-05-20 07:00:00	QQQ	ETF	88.33	88.41	88.32	88.38	42900.0
2014-05-20 08:00:00	QQQ	ETF	88.37	88.47	88.3	88.33	101200.0
2014-05-20 09:00:00	QQQ	ETF	88.3	88.4	87.99	88.06	4156433.0
2014-05-20 10:00:00	QQQ	ETF	88.06	88.44	87.99	88.42	4468357.0
2014-05-20 11:00:00	QQQ	ETF	88.42	88.6	88.31	88.49	3293834.0
2014-05-20 12:00:00	QQQ	ETF	88.495	88.51	88.031	88.15	4301670.0
2014-05-20 13:00:00	QQQ	ETF	88.14	88.14	87.64	87.66	3973491.0
2014-05-20 14:00:00	QQQ	ETF	87.665	87.9349	87.645	87.735	3276600.0
2014-05-20 15:00:00	QQQ	ETF	87.745	88.14	87.71	88.01	5581361.0
2014-05-20 16:00:00	QQQ	ETF	88.0	88.1904	87.92	88.01	851447.0
2014-05-20 17:00:00	QQQ	ETF	88.0	88.0	87.98	88.0	15640.0
2014-05-20 18:00:00	QQQ	ETF	87.97	87.97	87.91	87.91	1755.0
2014-05-20 19:00:00	QQQ	ETF	87.9	87.9	87.88	87.89	10650.0
2014-05-20 04:00:00	IWM	ETF	110.7	110.7	110.7	110.7	1000.0
2014-05-20 07:00:00	IWM	ETF	110.76	110.76	110.72	110.72	25400.0
2014-05-20 08:00:00	IWM	ETF	110.72	110.95	110.7	110.7	190269.0
2014-05-20 09:00:00	IWM	ETF	110.62	110.63	109.19	109.31	8492425.0
2014-05-20 10:00:00	IWM	ETF	109.31	109.64	108.97	109.57	10884268.0
2014-05-20 11:00:00	IWM	ETF	109.575	109.85	109.24	109.415	5918657.0
2014-05-20 12:00:00	IWM	ETF	109.42	109.44	108.79	109.01	6938029.0
2014-05-20 13:00:00	IWM	ETF	109.01	109.1001	108.42	108.53	10223504.0
2014-05-20 14:00:00	IWM	ETF	108.51	108.93	108.51	108.86	7306701.0
2014-05-20 15:00:00	IWM	ETF	108.85	109.55	108.82	109.07	13679319.0
2014-05-20 16:00:00	IWM	ETF	109.07	109.15	108.9	108.98	6762586.0
2014-05-20 17:00:00	IWM	ETF	108.96	108.98	108.9	108.9	46664.0
2014-05-20 18:00:00	IWM	ETF	108.91	108.91	108.88	108.88	846.0
2014-05-20 19:00:00	IWM	ETF	108.88	108.88	108.84	108.84	2200.0
2014-05-20 07:00:00	DIA	ETF	164.74	164.74	164.74	164.74	100.0
2014-05-20 08:00:00	DIA	ETF	164.73	164.84	164.65	164.72	2500.0
2014-05-20 09:00:00	DIA	ETF	164.62	164.72	163.97	164.03	533024.0
2014-05-20 10:00:00	DIA	ETF	164.04	164.52	163.99	164.5	567864.0
2014-05-20 11:00:00	DIA	ETF	164.51	164.55	164.21	164.22	291683.0

> showing 50 of 6,729 rows — these rows as CSV

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