PREVIEW / etf_30min / 2013-12-26

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-12-26.parquet
  size:    313 KB
  rows:    10,986

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
2013-12-26 04:00:00	SPY	ETF	183.3	183.3	183.3	183.3	200.0
2013-12-26 04:30:00	SPY	ETF	183.24	183.36	183.24	183.36	1000.0
2013-12-26 05:00:00	SPY	ETF	183.33	183.33	183.33	183.33	100.0
2013-12-26 06:00:00	SPY	ETF	183.33	183.49	183.28	183.44	5275.0
2013-12-26 06:30:00	SPY	ETF	183.44	183.45	183.39	183.39	3310.0
2013-12-26 07:00:00	SPY	ETF	183.37	183.44	183.36	183.43	32571.0
2013-12-26 07:30:00	SPY	ETF	183.43	183.43	183.28	183.36	19283.0
2013-12-26 08:00:00	SPY	ETF	183.37	183.49	183.32	183.38	119736.0
2013-12-26 08:30:00	SPY	ETF	183.37	183.51	183.31	183.5	238339.0
2013-12-26 09:00:00	SPY	ETF	183.48	183.53	183.32	183.32	445698.0
2013-12-26 09:30:00	SPY	ETF	183.34	183.49	183.32	183.37	7099972.0
2013-12-26 10:00:00	SPY	ETF	183.36	183.55	183.36	183.545	3571555.0
2013-12-26 10:30:00	SPY	ETF	183.54	183.6318	183.4	183.46	3016880.0
2013-12-26 11:00:00	SPY	ETF	183.455	183.54	183.39	183.525	2197833.0
2013-12-26 11:30:00	SPY	ETF	183.525	183.64	183.51	183.5597	3257643.0
2013-12-26 12:00:00	SPY	ETF	183.555	183.59	183.48	183.5899	2083363.0
2013-12-26 12:30:00	SPY	ETF	183.58	183.729	183.58	183.685	3859365.0
2013-12-26 13:00:00	SPY	ETF	183.69	183.77	183.67	183.755	1676786.0
2013-12-26 13:30:00	SPY	ETF	183.755	183.87	183.72	183.87	2012232.0
2013-12-26 14:00:00	SPY	ETF	183.87	183.9	183.78	183.86	4832447.0
2013-12-26 14:30:00	SPY	ETF	183.861	183.89	183.74	183.85	3879965.0
2013-12-26 15:00:00	SPY	ETF	183.84	183.94	183.83	183.921	5537313.0
2013-12-26 15:30:00	SPY	ETF	183.925	183.96	183.79	183.87	10333051.0
2013-12-26 16:00:00	SPY	ETF	183.86	183.87	183.78	183.82	5128430.0
2013-12-26 16:30:00	SPY	ETF	183.82	183.89	183.32	183.83	2288616.0
2013-12-26 17:00:00	SPY	ETF	183.85	183.88	183.81	183.82	48736.0
2013-12-26 17:30:00	SPY	ETF	183.83	183.83	183.82	183.82	11370.0
2013-12-26 18:00:00	SPY	ETF	183.82	183.83	183.75	183.81	66788.0
2013-12-26 18:30:00	SPY	ETF	183.8	183.8	183.76	183.76	9154.0
2013-12-26 19:00:00	SPY	ETF	183.75	183.78	183.73	183.78	13703.0
2013-12-26 19:30:00	SPY	ETF	183.78	183.78	183.66	183.66	67799.0
2013-12-26 05:30:00	QQQ	ETF	87.44	87.52	87.44	87.52	1700.0
2013-12-26 06:00:00	QQQ	ETF	87.56	87.68	87.56	87.66	2800.0
2013-12-26 06:30:00	QQQ	ETF	87.66	87.66	87.6	87.6	3100.0
2013-12-26 07:00:00	QQQ	ETF	87.61	87.62	87.58	87.62	829.0
2013-12-26 07:30:00	QQQ	ETF	87.6	87.62	87.6	87.62	1300.0
2013-12-26 08:00:00	QQQ	ETF	87.61	87.63	87.59	87.591	61983.0
2013-12-26 08:30:00	QQQ	ETF	87.62	87.67	87.61	87.66	27738.0
2013-12-26 09:00:00	QQQ	ETF	87.66	87.67	87.61	87.61	45813.0
2013-12-26 09:30:00	QQQ	ETF	87.6	87.68	87.44	87.45	2224332.0
2013-12-26 10:00:00	QQQ	ETF	87.45	87.668	87.45	87.6599	1472930.0
2013-12-26 10:30:00	QQQ	ETF	87.66	87.66	87.59	87.6253	597409.0
2013-12-26 11:00:00	QQQ	ETF	87.6299	87.71	87.61	87.7	517329.0
2013-12-26 11:30:00	QQQ	ETF	87.709	87.75	87.66	87.6875	824508.0
2013-12-26 12:00:00	QQQ	ETF	87.69	87.7	87.65	87.69	677223.0
2013-12-26 12:30:00	QQQ	ETF	87.695	87.74	87.67	87.74	864336.0
2013-12-26 13:00:00	QQQ	ETF	87.74	87.77	87.7	87.745	831754.0
2013-12-26 13:30:00	QQQ	ETF	87.75	87.79	87.72	87.7899	540995.0
2013-12-26 14:00:00	QQQ	ETF	87.785	87.79	87.74	87.7604	466885.0
2013-12-26 14:30:00	QQQ	ETF	87.77	87.77	87.68	87.74	537675.0

> showing 50 of 10,986 rows — these rows as CSV

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