PREVIEW / etf_1hour / 2014-05-07

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-05-07.parquet
  size:    215 KB
  rows:    6,850

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-07 04:00:00	SPY	ETF	187.03	187.1	186.9	187.1	5525.0
2014-05-07 05:00:00	SPY	ETF	187.04	187.04	186.86	186.95	7728.0
2014-05-07 06:00:00	SPY	ETF	186.9	187.02	186.87	187.01	4442.0
2014-05-07 07:00:00	SPY	ETF	187.04	187.41	187.03	187.27	278716.0
2014-05-07 08:00:00	SPY	ETF	187.31	187.72	187.26	187.4	1279060.0
2014-05-07 09:00:00	SPY	ETF	187.4	187.69	186.915	186.96	13472950.0
2014-05-07 10:00:00	SPY	ETF	186.96	187.33	186.01	186.77	27541320.0
2014-05-07 11:00:00	SPY	ETF	186.77	187.75	186.57	187.53	16023658.0
2014-05-07 12:00:00	SPY	ETF	187.53	187.66	187.07	187.11	7110937.0
2014-05-07 13:00:00	SPY	ETF	187.11	187.48	186.92	186.94	7361806.0
2014-05-07 14:00:00	SPY	ETF	186.94	187.6201	186.88	187.5	7635236.0
2014-05-07 15:00:00	SPY	ETF	187.5	187.97	187.21	187.9	17960432.0
2014-05-07 16:00:00	SPY	ETF	187.9	188.13	186.5	188.05	5408580.0
2014-05-07 17:00:00	SPY	ETF	188.04	188.07	187.86	187.92	1669766.0
2014-05-07 18:00:00	SPY	ETF	187.94	188.03	187.91	187.95	84622.0
2014-05-07 19:00:00	SPY	ETF	187.96	187.99	187.84	187.88	45087.0
2014-05-07 04:00:00	QQQ	ETF	86.71	86.74	86.71	86.74	820.0
2014-05-07 05:00:00	QQQ	ETF	86.74	86.74	86.68	86.68	5400.0
2014-05-07 06:00:00	QQQ	ETF	86.71	86.71	86.71	86.71	1000.0
2014-05-07 07:00:00	QQQ	ETF	86.8	87.05	86.8	86.96	107600.0
2014-05-07 08:00:00	QQQ	ETF	86.78	87.21	86.78	87.08	478452.0
2014-05-07 09:00:00	QQQ	ETF	87.08	87.08	86.15	86.19	7244637.0
2014-05-07 10:00:00	QQQ	ETF	86.18	86.48	85.53	85.87	13463395.0
2014-05-07 11:00:00	QQQ	ETF	85.88	86.42	85.65	86.28	6798643.0
2014-05-07 12:00:00	QQQ	ETF	86.28	86.31	85.84	85.86	3468930.0
2014-05-07 13:00:00	QQQ	ETF	85.85	86.16	85.77	85.79	3942585.0
2014-05-07 14:00:00	QQQ	ETF	85.78	86.28	85.75	86.23	4401825.0
2014-05-07 15:00:00	QQQ	ETF	86.225	86.62	86.06	86.56	8545920.0
2014-05-07 16:00:00	QQQ	ETF	86.56	86.7883	86.02	86.6	10879838.0
2014-05-07 17:00:00	QQQ	ETF	86.59	86.6	86.51	86.55	3385542.0
2014-05-07 18:00:00	QQQ	ETF	86.56	86.56	86.51	86.53	6581.0
2014-05-07 19:00:00	QQQ	ETF	86.53	86.55	86.48	86.48	11190.0
2014-05-07 04:00:00	IWM	ETF	109.98	109.98	109.89	109.89	300.0
2014-05-07 05:00:00	IWM	ETF	110.0	110.0	109.89	109.94	10300.0
2014-05-07 06:00:00	IWM	ETF	109.94	109.94	109.94	109.94	5000.0
2014-05-07 07:00:00	IWM	ETF	110.0	110.33	110.0	110.22	155880.0
2014-05-07 08:00:00	IWM	ETF	110.0484	110.57	110.0484	110.36	979656.0
2014-05-07 09:00:00	IWM	ETF	110.3	110.45	109.41	109.42	7036068.0
2014-05-07 10:00:00	IWM	ETF	109.42	109.74	108.43	109.12	15187628.0
2014-05-07 11:00:00	IWM	ETF	109.13	109.93	108.78	109.6301	8383551.0
2014-05-07 12:00:00	IWM	ETF	109.64	109.76	109.04	109.075	4671761.0
2014-05-07 13:00:00	IWM	ETF	109.07	109.39	108.88	108.91	3734883.0
2014-05-07 14:00:00	IWM	ETF	108.9	109.8	108.83	109.66	5236147.0
2014-05-07 15:00:00	IWM	ETF	109.64	110.23	109.24	110.14	8155119.0
2014-05-07 16:00:00	IWM	ETF	110.13	110.31	109.66	110.21	1921243.0
2014-05-07 17:00:00	IWM	ETF	110.26	110.26	110.14	110.14	769285.0
2014-05-07 19:00:00	IWM	ETF	110.25	110.25	110.11	110.11	1216.0
2014-05-07 07:00:00	DIA	ETF	164.33	164.33	164.33	164.33	100.0
2014-05-07 08:00:00	DIA	ETF	164.5	164.5	164.46	164.46	2700.0
2014-05-07 09:00:00	DIA	ETF	164.49	164.7	164.19	164.25	552766.0

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

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