PREVIEW / etf_30min / 2014-05-01

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-05-01.parquet
  size:    335 KB
  rows:    11,424

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-01 04:30:00	SPY	ETF	188.58	188.58	188.48	188.48	200.0
2014-05-01 05:00:00	SPY	ETF	188.55	188.55	188.52	188.52	200.0
2014-05-01 06:00:00	SPY	ETF	188.49	188.5	188.48	188.5	1750.0
2014-05-01 06:30:00	SPY	ETF	188.55	188.55	188.55	188.55	10100.0
2014-05-01 07:00:00	SPY	ETF	188.55	188.6	188.38	188.38	67545.0
2014-05-01 07:30:00	SPY	ETF	188.37	188.42	188.32	188.34	43587.0
2014-05-01 08:00:00	SPY	ETF	188.34	188.55	188.34	188.41	97196.0
2014-05-01 08:30:00	SPY	ETF	188.38	188.43	188.22	188.26	302215.0
2014-05-01 09:00:00	SPY	ETF	188.24	188.29	188.2	188.22	180810.0
2014-05-01 09:30:00	SPY	ETF	188.22	188.53	188.0	188.15	11583194.0
2014-05-01 10:00:00	SPY	ETF	188.16	188.32	187.73	188.05	10415717.0
2014-05-01 10:30:00	SPY	ETF	188.06	188.56	188.04	188.44	8285823.0
2014-05-01 11:00:00	SPY	ETF	188.45	188.55	188.32	188.51	3620069.0
2014-05-01 11:30:00	SPY	ETF	188.501	188.84	188.405	188.47	7183846.0
2014-05-01 12:00:00	SPY	ETF	188.47	188.69	188.42	188.62	2936192.0
2014-05-01 12:30:00	SPY	ETF	188.6257	188.66	188.405	188.53	3540458.0
2014-05-01 13:00:00	SPY	ETF	188.53	188.63	188.36	188.39	3610088.0
2014-05-01 13:30:00	SPY	ETF	188.39	188.47	188.0	188.08	6431163.0
2014-05-01 14:00:00	SPY	ETF	188.082	188.37	188.05	188.33	4400221.0
2014-05-01 14:30:00	SPY	ETF	188.33	188.39	187.92	188.13	5024612.0
2014-05-01 15:00:00	SPY	ETF	188.13	188.36	187.96	188.07	5315004.0
2014-05-01 15:30:00	SPY	ETF	188.065	188.33	187.99	188.32	11027870.0
2014-05-01 16:00:00	SPY	ETF	188.34	188.45	188.22	188.37	4312016.0
2014-05-01 16:30:00	SPY	ETF	188.37	188.44	188.35	188.44	2434753.0
2014-05-01 17:00:00	SPY	ETF	188.44	188.5	188.41	188.49	178379.0
2014-05-01 17:30:00	SPY	ETF	188.48	188.48	188.45	188.45	113367.0
2014-05-01 18:00:00	SPY	ETF	188.45	188.5	188.37	188.43	25637.0
2014-05-01 18:30:00	SPY	ETF	188.43	188.43	188.4	188.43	3360.0
2014-05-01 19:00:00	SPY	ETF	188.44	188.48	188.44	188.48	1960.0
2014-05-01 19:30:00	SPY	ETF	188.47	188.48	188.4	188.41	17594.0
2014-05-01 06:30:00	QQQ	ETF	87.65	87.65	87.63	87.63	1000.0
2014-05-01 07:00:00	QQQ	ETF	87.73	87.73	87.55	87.55	3000.0
2014-05-01 07:30:00	QQQ	ETF	87.55	87.56	87.53	87.56	69200.0
2014-05-01 08:00:00	QQQ	ETF	87.57	87.6	87.56	87.6	23000.0
2014-05-01 08:30:00	QQQ	ETF	87.58	87.6	87.5	87.51	47079.0
2014-05-01 09:00:00	QQQ	ETF	87.49	87.55	87.49	87.53	169738.0
2014-05-01 09:30:00	QQQ	ETF	87.53	87.74	87.31	87.58	4352024.0
2014-05-01 10:00:00	QQQ	ETF	87.59	87.73	87.37	87.66	3659752.0
2014-05-01 10:30:00	QQQ	ETF	87.66	87.96	87.63	87.893	3423815.0
2014-05-01 11:00:00	QQQ	ETF	87.89	88.0	87.79	87.95	2257743.0
2014-05-01 11:30:00	QQQ	ETF	87.95	88.15	87.82	87.84	3274712.0
2014-05-01 12:00:00	QQQ	ETF	87.84	88.0	87.82	87.91	1830421.0
2014-05-01 12:30:00	QQQ	ETF	87.91	87.96	87.77	87.86	900182.0
2014-05-01 13:00:00	QQQ	ETF	87.86	87.93	87.72	87.75	1237770.0
2014-05-01 13:30:00	QQQ	ETF	87.74	87.87	87.55	87.61	2194345.0
2014-05-01 14:00:00	QQQ	ETF	87.6101	87.77	87.59	87.69	1183571.0
2014-05-01 14:30:00	QQQ	ETF	87.69	87.72	87.47	87.6	1914576.0
2014-05-01 15:00:00	QQQ	ETF	87.59	87.72	87.48	87.57	1773203.0
2014-05-01 15:30:00	QQQ	ETF	87.56	87.68	87.51	87.66	2842918.0
2014-05-01 16:00:00	QQQ	ETF	87.67	87.7824	87.63	87.68	739004.0

> showing 50 of 11,424 rows — these rows as CSV

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