PREVIEW / etf_1hour / 2014-04-23

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-04-23.parquet
  size:    211 KB
  rows:    6,799

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-23 04:00:00	SPY	ETF	188.0	188.1	188.0	188.1	4100.0
2014-04-23 05:00:00	SPY	ETF	187.97	187.97	187.72	187.72	14254.0
2014-04-23 06:00:00	SPY	ETF	187.72	187.78	187.7	187.74	4929.0
2014-04-23 07:00:00	SPY	ETF	187.75	187.83	187.68	187.7	182309.0
2014-04-23 08:00:00	SPY	ETF	187.7	187.83	187.55	187.77	519749.0
2014-04-23 09:00:00	SPY	ETF	187.78	187.92	187.49	187.64	8645702.0
2014-04-23 10:00:00	SPY	ETF	187.6401	187.9	187.3	187.73	14661727.0
2014-04-23 11:00:00	SPY	ETF	187.72	187.82	187.41	187.761	8265944.0
2014-04-23 12:00:00	SPY	ETF	187.77	187.79	187.51	187.715	4876988.0
2014-04-23 13:00:00	SPY	ETF	187.71	187.78	187.46	187.57	5534070.0
2014-04-23 14:00:00	SPY	ETF	187.57	187.8	187.37	187.53	8829852.0
2014-04-23 15:00:00	SPY	ETF	187.53	187.67	187.44	187.46	14187828.0
2014-04-23 16:00:00	SPY	ETF	187.47	188.47	187.44	188.36	5671194.0
2014-04-23 17:00:00	SPY	ETF	188.34	188.6	188.34	188.49	578233.0
2014-04-23 18:00:00	SPY	ETF	188.45	188.49	188.31	188.39	196631.0
2014-04-23 19:00:00	SPY	ETF	188.39	188.44	188.38	188.43	46655.0
2014-04-23 05:00:00	QQQ	ETF	87.56	87.65	87.55	87.55	7150.0
2014-04-23 06:00:00	QQQ	ETF	87.5	87.5	87.5	87.5	200.0
2014-04-23 07:00:00	QQQ	ETF	87.5	87.57	87.45	87.45	72606.0
2014-04-23 08:00:00	QQQ	ETF	87.45	87.56	87.41	87.52	106124.0
2014-04-23 09:00:00	QQQ	ETF	87.53	87.56	87.0398	87.11	5744360.0
2014-04-23 10:00:00	QQQ	ETF	87.11	87.17	86.85	87.07	6844905.0
2014-04-23 11:00:00	QQQ	ETF	87.07	87.14	86.891	87.109	3106108.0
2014-04-23 12:00:00	QQQ	ETF	87.1	87.11	86.87	86.99	1634976.0
2014-04-23 13:00:00	QQQ	ETF	87.0	87.02	86.7701	86.82	1822365.0
2014-04-23 14:00:00	QQQ	ETF	86.83	86.86	86.72	86.81	3186056.0
2014-04-23 15:00:00	QQQ	ETF	86.81	86.96	86.71	86.75	4445509.0
2014-04-23 16:00:00	QQQ	ETF	86.75	87.84	86.66	87.77	4520145.0
2014-04-23 17:00:00	QQQ	ETF	87.76	88.02	87.76	87.87	612981.0
2014-04-23 18:00:00	QQQ	ETF	87.91	87.91	87.81	87.87	135770.0
2014-04-23 19:00:00	QQQ	ETF	87.87	87.92	87.87	87.9	116401.0
2014-04-23 06:00:00	IWM	ETF	114.33	114.33	114.33	114.33	300.0
2014-04-23 07:00:00	IWM	ETF	114.36	114.48	114.34	114.34	35400.0
2014-04-23 08:00:00	IWM	ETF	114.34	114.48	114.24	114.43	108160.0
2014-04-23 09:00:00	IWM	ETF	114.42	114.62	114.13	114.31	4727974.0
2014-04-23 10:00:00	IWM	ETF	114.33	114.77	113.79	114.49	6299052.0
2014-04-23 11:00:00	IWM	ETF	114.49	114.64	114.05	114.528	3652571.0
2014-04-23 12:00:00	IWM	ETF	114.52	114.535	114.17	114.32	2270413.0
2014-04-23 13:00:00	IWM	ETF	114.32	114.43	114.05	114.13	3085690.0
2014-04-23 14:00:00	IWM	ETF	114.13	114.15	113.77	113.93	4450767.0
2014-04-23 15:00:00	IWM	ETF	113.93	114.18	113.82	113.91	3960367.0
2014-04-23 16:00:00	IWM	ETF	113.91	114.7	113.87	114.6	2091581.0
2014-04-23 17:00:00	IWM	ETF	114.6	114.78	114.58	114.65	102585.0
2014-04-23 18:00:00	IWM	ETF	114.65	114.7	114.52	114.52	2360.0
2014-04-23 19:00:00	IWM	ETF	114.58	114.64	114.58	114.64	2700.0
2014-04-23 08:00:00	DIA	ETF	165.0	165.09	164.91	164.91	3105.0
2014-04-23 09:00:00	DIA	ETF	164.92	164.99	164.58	164.67	666073.0
2014-04-23 10:00:00	DIA	ETF	164.65	164.86	164.45	164.72	705731.0
2014-04-23 11:00:00	DIA	ETF	164.71	164.78	164.46	164.64	442740.0
2014-04-23 12:00:00	DIA	ETF	164.64	164.8	164.53	164.73	279296.0

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

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