PREVIEW / etf_1hour / 2014-04-30

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-04-30.parquet
  size:    214 KB
  rows:    6,794

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-04-30 04:00:00	SPY	ETF	187.35	187.38	187.27	187.38	1619.0
2014-04-30 05:00:00	SPY	ETF	187.41	187.54	187.29	187.5	11335.0
2014-04-30 06:00:00	SPY	ETF	187.49	187.52	187.44	187.51	5200.0
2014-04-30 07:00:00	SPY	ETF	187.45	187.66	187.45	187.59	144066.0
2014-04-30 08:00:00	SPY	ETF	187.56	187.89	187.38	187.59	1971201.0
2014-04-30 09:00:00	SPY	ETF	187.55	187.71	187.22	187.39	15464446.0
2014-04-30 10:00:00	SPY	ETF	187.39	188.1	187.18	187.9	13754258.0
2014-04-30 11:00:00	SPY	ETF	187.9	187.95	187.58	187.81	7667368.0
2014-04-30 12:00:00	SPY	ETF	187.81	188.03	187.8	188.01	3880509.0
2014-04-30 13:00:00	SPY	ETF	188.01	188.1	187.875	187.9	4618658.0
2014-04-30 14:00:00	SPY	ETF	187.91	188.5	187.63	188.32	20520107.0
2014-04-30 15:00:00	SPY	ETF	188.32	188.45	187.85	188.39	21124877.0
2014-04-30 16:00:00	SPY	ETF	188.39	188.58	187.4596	188.49	8392676.0
2014-04-30 17:00:00	SPY	ETF	188.49	188.6	188.31	188.5	372285.0
2014-04-30 18:00:00	SPY	ETF	188.5	188.55	188.38	188.51	179819.0
2014-04-30 19:00:00	SPY	ETF	188.49	188.53	188.44	188.52	20010.0
2014-04-30 04:00:00	QQQ	ETF	86.75	86.75	86.75	86.75	100.0
2014-04-30 05:00:00	QQQ	ETF	86.79	86.88	86.78	86.88	5200.0
2014-04-30 07:00:00	QQQ	ETF	86.85	86.97	86.85	86.94	37500.0
2014-04-30 08:00:00	QQQ	ETF	86.91	87.06	86.79	86.94	362507.0
2014-04-30 09:00:00	QQQ	ETF	86.92	87.02	86.54	86.73	8072998.0
2014-04-30 10:00:00	QQQ	ETF	86.72	87.29	86.54	87.1699	6094755.0
2014-04-30 11:00:00	QQQ	ETF	87.16	87.225	86.95	87.07	3357693.0
2014-04-30 12:00:00	QQQ	ETF	87.07	87.22	87.0525	87.21	1451563.0
2014-04-30 13:00:00	QQQ	ETF	87.21	87.29	87.11	87.14	1746859.0
2014-04-30 14:00:00	QQQ	ETF	87.14	87.48	87.0	87.35	7684476.0
2014-04-30 15:00:00	QQQ	ETF	87.36	87.45	87.095	87.4	6431837.0
2014-04-30 16:00:00	QQQ	ETF	87.4	87.49	86.9012	87.46	760995.0
2014-04-30 17:00:00	QQQ	ETF	87.48	87.6	87.39	87.54	458863.0
2014-04-30 18:00:00	QQQ	ETF	87.52	87.52	87.43	87.49	20417.0
2014-04-30 19:00:00	QQQ	ETF	87.48	87.53	87.48	87.51	10440.0
2014-04-30 07:00:00	IWM	ETF	111.06	111.06	111.03	111.06	22000.0
2014-04-30 08:00:00	IWM	ETF	111.03	111.29	110.87	111.01	302295.0
2014-04-30 09:00:00	IWM	ETF	111.02	111.03	109.95	110.26	7446324.0
2014-04-30 10:00:00	IWM	ETF	110.26	111.34	110.02	111.11	6241959.0
2014-04-30 11:00:00	IWM	ETF	111.11	111.17	110.52	110.71	3644305.0
2014-04-30 12:00:00	IWM	ETF	110.71	111.0	110.63	110.95	1446272.0
2014-04-30 13:00:00	IWM	ETF	110.94	111.09	110.8	110.88	2034027.0
2014-04-30 14:00:00	IWM	ETF	110.87	111.95	110.58	111.75	8241982.0
2014-04-30 15:00:00	IWM	ETF	111.76	112.01	111.37	111.96	8317121.0
2014-04-30 16:00:00	IWM	ETF	111.97	112.23	110.1713	112.02	1735539.0
2014-04-30 17:00:00	IWM	ETF	111.98	112.05	110.9	110.9	698871.0
2014-04-30 18:00:00	IWM	ETF	111.99	112.15	111.98	112.15	3575.0
2014-04-30 19:00:00	IWM	ETF	112.07	112.08	112.07	112.08	3320.0
2014-04-30 08:00:00	DIA	ETF	164.88	165.0	164.88	165.0	2000.0
2014-04-30 09:00:00	DIA	ETF	165.06	165.18	164.83	164.94	541164.0
2014-04-30 10:00:00	DIA	ETF	164.92	165.38	164.83	165.23	703600.0
2014-04-30 11:00:00	DIA	ETF	165.23	165.28	164.95	165.12	413482.0
2014-04-30 12:00:00	DIA	ETF	165.13	165.27	165.11	165.24	218815.0
2014-04-30 13:00:00	DIA	ETF	165.23	165.3	165.13	165.1763	324601.0

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

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