PREVIEW / etf_1hour / 2014-05-08

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-05-08.parquet
  size:    217 KB
  rows:    6,847

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-08 04:00:00	SPY	ETF	188.13	188.13	187.99	188.09	2363.0
2014-05-08 05:00:00	SPY	ETF	188.05	188.15	187.98	188.03	8998.0
2014-05-08 06:00:00	SPY	ETF	187.99	188.06	187.94	188.0	7489.0
2014-05-08 07:00:00	SPY	ETF	188.03	188.2	187.71	187.8	196280.0
2014-05-08 08:00:00	SPY	ETF	187.75	188.14	187.39	187.64	1323829.0
2014-05-08 09:00:00	SPY	ETF	187.65	188.65	187.48	188.55	13174895.0
2014-05-08 10:00:00	SPY	ETF	188.55	188.84	188.38	188.5464	14890938.0
2014-05-08 11:00:00	SPY	ETF	188.55	189.05	188.48	188.9299	8445767.0
2014-05-08 12:00:00	SPY	ETF	188.921	188.96	188.54	188.62	6044575.0
2014-05-08 13:00:00	SPY	ETF	188.62	188.73	188.12	188.27	10329971.0
2014-05-08 14:00:00	SPY	ETF	188.27	188.28	187.4	187.471	15575466.0
2014-05-08 15:00:00	SPY	ETF	187.48	187.79	187.08	187.69	20572135.0
2014-05-08 16:00:00	SPY	ETF	187.69	188.7067	187.59	187.6	2548201.0
2014-05-08 17:00:00	SPY	ETF	187.61	187.63	187.56	187.6	45978.0
2014-05-08 18:00:00	SPY	ETF	187.58	187.58	187.41	187.52	77332.0
2014-05-08 19:00:00	SPY	ETF	187.53	187.56	187.47	187.53	52279.0
2014-05-08 05:00:00	QQQ	ETF	86.61	86.61	86.61	86.61	200.0
2014-05-08 06:00:00	QQQ	ETF	86.56	86.6	86.56	86.6	5400.0
2014-05-08 07:00:00	QQQ	ETF	86.57	86.66	86.42	86.48	18050.0
2014-05-08 08:00:00	QQQ	ETF	86.48	86.48	86.16	86.21	393182.0
2014-05-08 09:00:00	QQQ	ETF	86.25	86.93	86.05	86.87	7688373.0
2014-05-08 10:00:00	QQQ	ETF	86.87	87.41	86.87	87.18	8414056.0
2014-05-08 11:00:00	QQQ	ETF	87.19	87.53	87.15	87.43	4630399.0
2014-05-08 12:00:00	QQQ	ETF	87.43	87.5	87.11	87.17	4022612.0
2014-05-08 13:00:00	QQQ	ETF	87.175	87.3	86.82	86.86	4452921.0
2014-05-08 14:00:00	QQQ	ETF	86.87	86.88	86.25	86.36	6914461.0
2014-05-08 15:00:00	QQQ	ETF	86.36	86.52	86.15	86.48	7235181.0
2014-05-08 16:00:00	QQQ	ETF	86.47	86.8448	86.4	86.4	1736180.0
2014-05-08 17:00:00	QQQ	ETF	86.4	86.46	86.4	86.44	8550.0
2014-05-08 18:00:00	QQQ	ETF	86.41	86.41	86.26	86.34	16180.0
2014-05-08 19:00:00	QQQ	ETF	86.35	86.39	86.32	86.37	22400.0
2014-05-08 04:00:00	IWM	ETF	110.32	110.32	110.32	110.32	27100.0
2014-05-08 07:00:00	IWM	ETF	110.26	110.4	110.07	110.15	106140.0
2014-05-08 08:00:00	IWM	ETF	110.11	110.2	109.79	109.97	290195.0
2014-05-08 09:00:00	IWM	ETF	109.99	110.68	109.5	110.59	6484024.0
2014-05-08 10:00:00	IWM	ETF	110.59	111.24	110.55	110.73	7368523.0
2014-05-08 11:00:00	IWM	ETF	110.74	111.14	110.592	110.93	3582483.0
2014-05-08 12:00:00	IWM	ETF	110.94	111.0	110.03	110.29	4369005.0
2014-05-08 13:00:00	IWM	ETF	110.3	110.43	109.67	109.81	5614979.0
2014-05-08 14:00:00	IWM	ETF	109.83	109.86	109.0	109.165	7771267.0
2014-05-08 15:00:00	IWM	ETF	109.17	109.34	108.69	109.02	12122088.0
2014-05-08 16:00:00	IWM	ETF	109.02	110.1241	108.89	108.89	3989716.0
2014-05-08 17:00:00	IWM	ETF	108.9	108.92	108.9	108.91	3850.0
2014-05-08 18:00:00	IWM	ETF	108.83	108.85	108.79	108.85	4630.0
2014-05-08 19:00:00	IWM	ETF	108.86	108.86	108.86	108.86	332.0
2014-05-08 07:00:00	DIA	ETF	165.26	165.26	165.1	165.1	200.0
2014-05-08 08:00:00	DIA	ETF	164.97	165.02	164.76	165.02	16000.0
2014-05-08 09:00:00	DIA	ETF	164.95	165.66	164.88	165.56	944782.0
2014-05-08 10:00:00	DIA	ETF	165.56	165.72	165.39	165.55	821360.0
2014-05-08 11:00:00	DIA	ETF	165.56	166.02	165.52	165.97	613214.0

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

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