PREVIEW / etf_30min / 2013-04-23

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-04-23.parquet
  size:    319 KB
  rows:    10,683

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-04-23 04:00:00	SPY	ETF	155.65	155.77	155.6	155.6	9800.0
2013-04-23 04:30:00	SPY	ETF	155.55	155.55	155.35	155.42	31695.0
2013-04-23 05:00:00	SPY	ETF	155.55	155.87	155.55	155.85	6600.0
2013-04-23 05:30:00	SPY	ETF	155.89	156.0	155.86	155.87	54198.0
2013-04-23 06:00:00	SPY	ETF	155.86	155.87	155.81	155.81	18300.0
2013-04-23 06:30:00	SPY	ETF	155.85	156.15	155.82	156.15	54112.0
2013-04-23 07:00:00	SPY	ETF	156.15	156.37	156.15	156.36	205800.0
2013-04-23 07:30:00	SPY	ETF	156.35	156.51	156.29	156.5	333190.0
2013-04-23 08:00:00	SPY	ETF	156.5	156.87	155.7	156.83	1104984.0
2013-04-23 08:30:00	SPY	ETF	156.84	156.85	156.5	156.62	797134.0
2013-04-23 09:00:00	SPY	ETF	156.62	157.0	156.57	156.94	999392.0
2013-04-23 09:30:00	SPY	ETF	156.95	157.48	156.89	157.231	19565746.0
2013-04-23 10:00:00	SPY	ETF	157.2335	157.6201	157.17	157.57	12513118.0
2013-04-23 10:30:00	SPY	ETF	157.57	157.72	157.5	157.52	9128080.0
2013-04-23 11:00:00	SPY	ETF	157.51	157.805	157.51	157.74	7424480.0
2013-04-23 11:30:00	SPY	ETF	157.73	157.88	157.7	157.85	4029134.0
2013-04-23 12:00:00	SPY	ETF	157.85	157.92	157.73	157.88	3594123.0
2013-04-23 12:30:00	SPY	ETF	157.89	157.93	157.67	157.78	3214946.0
2013-04-23 13:00:00	SPY	ETF	157.775	157.85	156.17	157.65	48361179.0
2013-04-23 13:30:00	SPY	ETF	157.65	157.82	157.5203	157.72	5984135.0
2013-04-23 14:00:00	SPY	ETF	157.71	157.74	157.35	157.355	6112925.0
2013-04-23 14:30:00	SPY	ETF	157.36	157.57	157.24	157.56	7559058.0
2013-04-23 15:00:00	SPY	ETF	157.565	157.79	157.52	157.755	5934014.0
2013-04-23 15:30:00	SPY	ETF	157.76	157.89	157.65	157.82	13225264.0
2013-04-23 16:00:00	SPY	ETF	157.82	157.87	156.2094	157.73	8768917.0
2013-04-23 16:30:00	SPY	ETF	157.73	158.09	157.6	157.98	2485452.0
2013-04-23 17:00:00	SPY	ETF	157.99	158.06	157.9	157.94	210154.0
2013-04-23 17:30:00	SPY	ETF	157.93	157.98	157.8	157.8	164964.0
2013-04-23 18:00:00	SPY	ETF	157.8	157.9	157.76	157.83	102164.0
2013-04-23 18:30:00	SPY	ETF	157.83	157.85	157.72	157.75	37395.0
2013-04-23 19:00:00	SPY	ETF	157.76	157.83	157.74	157.82	20760.0
2013-04-23 19:30:00	SPY	ETF	157.82	157.82	157.64	157.66	93666.0
2013-04-23 04:00:00	QQQ	ETF	68.49	68.49	68.49	68.49	800.0
2013-04-23 04:30:00	QQQ	ETF	68.45	68.45	68.43	68.43	200.0
2013-04-23 06:00:00	QQQ	ETF	68.72	68.72	68.72	68.72	500.0
2013-04-23 06:30:00	QQQ	ETF	68.71	68.76	68.71	68.75	1700.0
2013-04-23 07:00:00	QQQ	ETF	68.84	68.97	68.84	68.97	18200.0
2013-04-23 07:30:00	QQQ	ETF	68.93	69.04	68.93	69.03	63300.0
2013-04-23 08:00:00	QQQ	ETF	69.03	69.16	68.95	69.14	199093.0
2013-04-23 08:30:00	QQQ	ETF	69.13	69.17	69.02	69.08	136524.0
2013-04-23 09:00:00	QQQ	ETF	69.08	69.22	69.04	69.18	215411.0
2013-04-23 09:30:00	QQQ	ETF	69.2	69.46	69.155	69.38	6255044.0
2013-04-23 10:00:00	QQQ	ETF	69.39	69.509	69.34	69.4401	2736136.0
2013-04-23 10:30:00	QQQ	ETF	69.45	69.55	69.39	69.46	2013943.0
2013-04-23 11:00:00	QQQ	ETF	69.46	69.58	69.45	69.53	1504547.0
2013-04-23 11:30:00	QQQ	ETF	69.52	69.65	69.51	69.6301	1265708.0
2013-04-23 12:00:00	QQQ	ETF	69.6301	69.68	69.57	69.679	812474.0
2013-04-23 12:30:00	QQQ	ETF	69.67	69.7	69.53	69.579	1294838.0
2013-04-23 13:00:00	QQQ	ETF	69.5701	69.6199	68.82	69.47	13529678.0
2013-04-23 13:30:00	QQQ	ETF	69.479	69.53	69.43	69.49	922805.0

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

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