PREVIEW / etf_30min / 2014-03-26

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-03-26.parquet
  size:    345 KB
  rows:    11,588

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-03-26 04:00:00	SPY	ETF	186.4	186.55	186.4	186.48	1470.0
2014-03-26 04:30:00	SPY	ETF	186.53	186.55	186.5	186.54	7500.0
2014-03-26 05:00:00	SPY	ETF	186.58	186.77	186.52	186.73	24312.0
2014-03-26 05:30:00	SPY	ETF	186.73	186.82	186.68	186.68	8316.0
2014-03-26 06:00:00	SPY	ETF	186.73	186.83	186.67	186.81	5501.0
2014-03-26 06:30:00	SPY	ETF	186.82	187.0	186.82	187.0	15782.0
2014-03-26 07:00:00	SPY	ETF	186.99	187.08	186.96	187.04	74100.0
2014-03-26 07:30:00	SPY	ETF	187.03	187.07	186.94	187.04	34973.0
2014-03-26 08:00:00	SPY	ETF	187.02	187.21	186.95	187.12	227408.0
2014-03-26 08:30:00	SPY	ETF	187.14	187.19	186.94	187.11	569252.0
2014-03-26 09:00:00	SPY	ETF	187.1	187.2	186.99	187.03	524946.0
2014-03-26 09:30:00	SPY	ETF	187.03	187.34	186.8	186.9	13872086.0
2014-03-26 10:00:00	SPY	ETF	186.9	187.14	186.6	186.79	9555515.0
2014-03-26 10:30:00	SPY	ETF	186.787	186.95	186.48	186.54	5796326.0
2014-03-26 11:00:00	SPY	ETF	186.535	186.98	186.47	186.9199	4695985.0
2014-03-26 11:30:00	SPY	ETF	186.9101	186.92	186.42	186.7	4296778.0
2014-03-26 12:00:00	SPY	ETF	186.709	186.72	186.39	186.55	5308969.0
2014-03-26 12:30:00	SPY	ETF	186.55	186.81	186.45	186.76	4245353.0
2014-03-26 13:00:00	SPY	ETF	186.77	186.79	186.041	186.045	5656618.0
2014-03-26 13:30:00	SPY	ETF	186.06	186.07	185.54	185.88	11442444.0
2014-03-26 14:00:00	SPY	ETF	185.88	185.93	185.42	185.74	8923180.0
2014-03-26 14:30:00	SPY	ETF	185.74	186.07	185.52	186.02	6682404.0
2014-03-26 15:00:00	SPY	ETF	186.02	186.09	185.45	185.46	8603166.0
2014-03-26 15:30:00	SPY	ETF	185.47	185.67	184.95	184.96	14533100.0
2014-03-26 16:00:00	SPY	ETF	184.96	186.31	184.66	184.75	9683929.0
2014-03-26 16:30:00	SPY	ETF	184.75	186.2744	184.71	184.93	1407653.0
2014-03-26 17:00:00	SPY	ETF	184.92	185.02	184.88	184.99	737116.0
2014-03-26 17:30:00	SPY	ETF	185.0	185.07	184.95	184.97	1581884.0
2014-03-26 18:00:00	SPY	ETF	184.97	185.01	184.87	184.88	42593.0
2014-03-26 18:30:00	SPY	ETF	184.88	184.9	184.79	184.79	69405.0
2014-03-26 19:00:00	SPY	ETF	184.8	184.94	184.8	184.9	7960.0
2014-03-26 19:30:00	SPY	ETF	184.9	185.0	184.89	184.99	68948.0
2014-03-26 04:00:00	QQQ	ETF	88.61	88.61	88.61	88.61	3000.0
2014-03-26 04:30:00	QQQ	ETF	88.69	88.69	88.69	88.69	113.0
2014-03-26 05:00:00	QQQ	ETF	88.75	88.75	88.75	88.75	500.0
2014-03-26 06:00:00	QQQ	ETF	88.84	88.88	88.84	88.87	8500.0
2014-03-26 06:30:00	QQQ	ETF	88.91	88.96	88.89	88.96	6100.0
2014-03-26 07:00:00	QQQ	ETF	88.97	89.02	88.97	88.98	4790.0
2014-03-26 07:30:00	QQQ	ETF	88.98	88.98	88.89	88.97	49630.0
2014-03-26 08:00:00	QQQ	ETF	88.97	89.1	88.97	89.02	115355.0
2014-03-26 08:30:00	QQQ	ETF	89.02	89.06	88.94	89.03	65322.0
2014-03-26 09:00:00	QQQ	ETF	89.05	89.1	88.96	88.96	118226.0
2014-03-26 09:30:00	QQQ	ETF	88.96	89.15	88.67	88.89	5708547.0
2014-03-26 10:00:00	QQQ	ETF	88.88	89.03	88.59	88.7	2777164.0
2014-03-26 10:30:00	QQQ	ETF	88.69	88.84	88.425	88.44	2289026.0
2014-03-26 11:00:00	QQQ	ETF	88.44	88.769	88.38	88.74	1720516.0
2014-03-26 11:30:00	QQQ	ETF	88.73	88.73	88.33	88.49	2263610.0
2014-03-26 12:00:00	QQQ	ETF	88.49	88.4901	88.24	88.37	1751086.0
2014-03-26 12:30:00	QQQ	ETF	88.36	88.53	88.31	88.48	1374268.0
2014-03-26 13:00:00	QQQ	ETF	88.47	88.495	88.01	88.02	1592531.0

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

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