PREVIEW / etf_1hour / 2014-05-21

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-05-21.parquet
  size:    210 KB
  rows:    6,727

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-21 04:00:00	SPY	ETF	187.62	187.78	187.62	187.74	7595.0
2014-05-21 05:00:00	SPY	ETF	187.78	188.0	187.78	187.86	33920.0
2014-05-21 06:00:00	SPY	ETF	187.84	187.9	187.66	187.66	14177.0
2014-05-21 07:00:00	SPY	ETF	187.67	187.9	187.66	187.86	266940.0
2014-05-21 08:00:00	SPY	ETF	187.86	188.16	187.66	188.1	806861.0
2014-05-21 09:00:00	SPY	ETF	188.11	188.83	188.04	188.635	15194560.0
2014-05-21 10:00:00	SPY	ETF	188.64	188.94	188.59	188.72	11045757.0
2014-05-21 11:00:00	SPY	ETF	188.72	188.82	188.275	188.41	12715506.0
2014-05-21 12:00:00	SPY	ETF	188.4	188.78	188.33	188.73	6178703.0
2014-05-21 13:00:00	SPY	ETF	188.73	188.87	188.65	188.77	5611391.0
2014-05-21 14:00:00	SPY	ETF	188.77	189.08	188.49	188.95	13162237.0
2014-05-21 15:00:00	SPY	ETF	188.945	189.22	188.88	189.12	14975338.0
2014-05-21 16:00:00	SPY	ETF	189.11	189.16	187.5993	188.97	4801317.0
2014-05-21 17:00:00	SPY	ETF	188.96	189.13	188.91	188.98	806826.0
2014-05-21 18:00:00	SPY	ETF	188.99	189.0	188.95	188.97	50225.0
2014-05-21 19:00:00	SPY	ETF	188.99	189.06	188.97	189.06	44750.0
2014-05-21 05:00:00	QQQ	ETF	88.19	88.25	88.19	88.25	5700.0
2014-05-21 06:00:00	QQQ	ETF	88.18	88.18	88.18	88.18	200.0
2014-05-21 07:00:00	QQQ	ETF	88.12	88.21	88.12	88.18	104330.0
2014-05-21 08:00:00	QQQ	ETF	88.18	88.25	88.1	88.24	155652.0
2014-05-21 09:00:00	QQQ	ETF	88.23	88.65	88.11	88.525	5225335.0
2014-05-21 10:00:00	QQQ	ETF	88.51	88.685	88.39	88.54	4781479.0
2014-05-21 11:00:00	QQQ	ETF	88.535	88.59	88.2401	88.39	3556687.0
2014-05-21 12:00:00	QQQ	ETF	88.39	88.6	88.35	88.5501	2173689.0
2014-05-21 13:00:00	QQQ	ETF	88.56	88.67	88.54	88.61	2253405.0
2014-05-21 14:00:00	QQQ	ETF	88.61	88.79	88.48	88.73	5003879.0
2014-05-21 15:00:00	QQQ	ETF	88.74	88.89	88.6901	88.84	5477694.0
2014-05-21 16:00:00	QQQ	ETF	88.84	88.89	88.36	88.81	2592066.0
2014-05-21 17:00:00	QQQ	ETF	88.81	88.84	88.79	88.8	1657242.0
2014-05-21 18:00:00	QQQ	ETF	88.8	88.8	88.78	88.78	300.0
2014-05-21 19:00:00	QQQ	ETF	88.82	88.86	88.81	88.83	11300.0
2014-05-21 05:00:00	IWM	ETF	109.29	109.4	109.29	109.4	1550.0
2014-05-21 06:00:00	IWM	ETF	109.3	109.3	109.3	109.3	100.0
2014-05-21 07:00:00	IWM	ETF	109.3	109.44	109.3	109.43	61257.0
2014-05-21 08:00:00	IWM	ETF	109.32	109.72	109.3	109.67	219635.0
2014-05-21 09:00:00	IWM	ETF	109.7	110.13	109.54	109.84	5221959.0
2014-05-21 10:00:00	IWM	ETF	109.84	110.09	109.42	109.44	4937176.0
2014-05-21 11:00:00	IWM	ETF	109.43	109.58	108.55	108.87	9878408.0
2014-05-21 12:00:00	IWM	ETF	108.88	109.45	108.74	109.4	4835063.0
2014-05-21 13:00:00	IWM	ETF	109.4	109.75	109.4	109.63	4144236.0
2014-05-21 14:00:00	IWM	ETF	109.63	109.89	109.2	109.6	6057480.0
2014-05-21 15:00:00	IWM	ETF	109.59	109.93	109.53	109.63	5581800.0
2014-05-21 16:00:00	IWM	ETF	109.62	109.9196	109.0337	109.62	2492880.0
2014-05-21 17:00:00	IWM	ETF	109.59	109.62	109.59	109.62	2000200.0
2014-05-21 18:00:00	IWM	ETF	109.75	109.75	109.63	109.63	608.0
2014-05-21 04:00:00	DIA	ETF	163.39	163.39	163.39	163.39	201.0
2014-05-21 07:00:00	DIA	ETF	163.41	163.7	163.41	163.7	1598.0
2014-05-21 08:00:00	DIA	ETF	163.52	164.0	163.52	163.79	16250.0
2014-05-21 09:00:00	DIA	ETF	163.82	164.9	163.79	164.69	959080.0
2014-05-21 10:00:00	DIA	ETF	164.7	165.0	164.63	164.88	554507.0

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

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