PREVIEW / etf_30min / 2016-01-26

all etf 30-min files

  file:    by_date/etf_30min/2016/2016-01-26.parquet
  size:    401 KB
  rows:    13,432

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
2016-01-26 04:00:00	SPY	ETF	186.52	186.66	186.25	186.36	27953.0
2016-01-26 04:30:00	SPY	ETF	186.3	186.95	186.26	186.95	22204.0
2016-01-26 05:00:00	SPY	ETF	186.93	187.25	186.81	187.22	44287.0
2016-01-26 05:30:00	SPY	ETF	187.29	187.54	187.14	187.41	38453.0
2016-01-26 06:00:00	SPY	ETF	187.44	187.67	187.23	187.29	48055.0
2016-01-26 06:30:00	SPY	ETF	187.32	188.29	187.32	188.11	148695.0
2016-01-26 07:00:00	SPY	ETF	188.08	188.53	188.06	188.2	328530.0
2016-01-26 07:30:00	SPY	ETF	188.25	188.29	187.74	187.9	325864.0
2016-01-26 08:00:00	SPY	ETF	187.87	188.5	186.43	188.13	743493.0
2016-01-26 08:30:00	SPY	ETF	188.16	188.5	188.1	188.3	723120.0
2016-01-26 09:00:00	SPY	ETF	188.32	188.61	188.14	188.42	891641.0
2016-01-26 09:30:00	SPY	ETF	188.42	189.17	188.02	188.26	14120847.0
2016-01-26 10:00:00	SPY	ETF	188.27	189.7511	188.26	189.43	11478616.0
2016-01-26 10:30:00	SPY	ETF	189.43	189.93	189.36	189.435	6789795.0
2016-01-26 11:00:00	SPY	ETF	189.43	189.95	189.37	189.68	13401913.0
2016-01-26 11:30:00	SPY	ETF	189.67	189.74	189.23	189.535	12760507.0
2016-01-26 12:00:00	SPY	ETF	189.54	190.38	189.53	190.3028	9358165.0
2016-01-26 12:30:00	SPY	ETF	190.3	190.49	190.02	190.109	6448118.0
2016-01-26 13:00:00	SPY	ETF	190.11	190.53	189.96	190.29	8276202.0
2016-01-26 13:30:00	SPY	ETF	190.28	190.36	190.02	190.07	7646899.0
2016-01-26 14:00:00	SPY	ETF	190.06	190.09	189.62	189.67	5622394.0
2016-01-26 14:30:00	SPY	ETF	189.66	190.03	189.48	189.74	6034878.0
2016-01-26 15:00:00	SPY	ETF	189.74	189.89	189.36	189.58	7946653.0
2016-01-26 15:30:00	SPY	ETF	189.585	190.28	189.42	190.18	16964275.0
2016-01-26 16:00:00	SPY	ETF	190.19	190.25	189.94	190.15	6315664.0
2016-01-26 16:30:00	SPY	ETF	190.15	190.25	189.37	189.4	1759120.0
2016-01-26 17:00:00	SPY	ETF	189.36	190.24	189.33	189.4	112062.0
2016-01-26 17:30:00	SPY	ETF	189.4	189.49	189.2	189.22	311043.0
2016-01-26 18:00:00	SPY	ETF	189.22	189.32	188.74	189.28	536868.0
2016-01-26 18:30:00	SPY	ETF	189.25	189.45	189.03	189.28	108646.0
2016-01-26 19:00:00	SPY	ETF	189.32	189.38	188.95	189.0	92200.0
2016-01-26 19:30:00	SPY	ETF	189.05	189.43	189.05	189.4	112487.0
2016-01-26 20:00:00	SPY	ETF	190.1922	190.1922	190.1922	190.1922	278500.0
2016-01-26 04:00:00	QQQ	ETF	101.42	101.47	101.23	101.35	31996.0
2016-01-26 04:30:00	QQQ	ETF	101.3	101.38	101.3	101.38	4900.0
2016-01-26 05:00:00	QQQ	ETF	101.91	101.91	101.78	101.81	600.0
2016-01-26 05:30:00	QQQ	ETF	101.95	102.06	101.91	102.03	4290.0
2016-01-26 06:00:00	QQQ	ETF	102.08	102.2	101.98	102.06	1800.0
2016-01-26 06:30:00	QQQ	ETF	102.23	102.48	102.23	102.43	29200.0
2016-01-26 07:00:00	QQQ	ETF	102.41	102.65	102.41	102.53	65090.0
2016-01-26 07:30:00	QQQ	ETF	102.52	102.54	102.22	102.32	102822.0
2016-01-26 08:00:00	QQQ	ETF	102.62	102.62	102.15	102.42	123820.0
2016-01-26 08:30:00	QQQ	ETF	102.47	102.69	102.44	102.55	111857.0
2016-01-26 09:00:00	QQQ	ETF	102.58	102.73	102.5	102.64	202725.0
2016-01-26 09:30:00	QQQ	ETF	102.64	102.81	101.76	101.89	5780066.0
2016-01-26 10:00:00	QQQ	ETF	101.9	102.82	101.89	102.57	3315332.0
2016-01-26 10:30:00	QQQ	ETF	102.58	102.99	102.53	102.68	2347809.0
2016-01-26 11:00:00	QQQ	ETF	102.67	103.11	102.66	102.96	2551783.0
2016-01-26 11:30:00	QQQ	ETF	102.96	103.025	102.71	102.89	1230418.0
2016-01-26 12:00:00	QQQ	ETF	102.895	103.4	102.89	103.32	1745340.0

> showing 50 of 13,432 rows — these rows as CSV

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