PREVIEW / etf_30min / 2013-07-16

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-07-16.parquet
  size:    313 KB
  rows:    10,712

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-07-16 04:00:00	SPY	ETF	167.95	168.04	167.94	168.04	1300.0
2013-07-16 04:30:00	SPY	ETF	168.06	168.1	168.04	168.1	9800.0
2013-07-16 05:00:00	SPY	ETF	168.06	168.25	168.06	168.22	56600.0
2013-07-16 05:30:00	SPY	ETF	168.2	168.2	168.2	168.2	200.0
2013-07-16 06:00:00	SPY	ETF	168.22	168.22	168.19	168.21	9400.0
2013-07-16 06:30:00	SPY	ETF	168.25	168.27	168.2	168.21	20800.0
2013-07-16 07:00:00	SPY	ETF	168.21	168.28	168.2	168.2	17500.0
2013-07-16 07:30:00	SPY	ETF	168.2	168.28	168.08	168.08	418264.0
2013-07-16 08:00:00	SPY	ETF	168.21	168.21	166.75	168.15	128341.0
2013-07-16 08:30:00	SPY	ETF	168.15	168.23	167.85	168.21	445671.0
2013-07-16 09:00:00	SPY	ETF	168.21	168.35	168.15	168.25	585517.0
2013-07-16 09:30:00	SPY	ETF	168.26	168.36	167.87	167.9	9681900.0
2013-07-16 10:00:00	SPY	ETF	167.92	168.18	167.905	167.98	7331837.0
2013-07-16 10:30:00	SPY	ETF	167.97	168.06	167.72	167.73	4707118.0
2013-07-16 11:00:00	SPY	ETF	167.73	167.76	167.49	167.53	7480346.0
2013-07-16 11:30:00	SPY	ETF	167.525	167.55	167.2	167.38	8562076.0
2013-07-16 12:00:00	SPY	ETF	167.38	167.555	167.32	167.5277	3580723.0
2013-07-16 12:30:00	SPY	ETF	167.52	167.53	167.35	167.352	2320162.0
2013-07-16 13:00:00	SPY	ETF	167.355	167.37	167.07	167.14	4097329.0
2013-07-16 13:30:00	SPY	ETF	167.13	167.42	167.08	167.4199	5697024.0
2013-07-16 14:00:00	SPY	ETF	167.41	167.665	167.4	167.5199	5800045.0
2013-07-16 14:30:00	SPY	ETF	167.52	167.59	167.42	167.44	2816841.0
2013-07-16 15:00:00	SPY	ETF	167.44	167.45	167.19	167.44	4930684.0
2013-07-16 15:30:00	SPY	ETF	167.44	167.57	167.4	167.52	9792174.0
2013-07-16 16:00:00	SPY	ETF	167.52	168.1556	167.4	167.59	5883614.0
2013-07-16 16:30:00	SPY	ETF	167.6	167.65	167.59	167.63	199558.0
2013-07-16 17:00:00	SPY	ETF	167.61	167.63	167.52	167.57	74347.0
2013-07-16 17:30:00	SPY	ETF	167.57	167.57	167.53	167.57	85733.0
2013-07-16 18:00:00	SPY	ETF	167.58	167.67	167.57	167.61	84023.0
2013-07-16 18:30:00	SPY	ETF	167.61	167.66	167.6	167.61	11600.0
2013-07-16 19:00:00	SPY	ETF	167.62	167.62	167.56	167.58	8697.0
2013-07-16 19:30:00	SPY	ETF	167.57	167.61	167.57	167.61	8778.0
2013-07-16 04:00:00	QQQ	ETF	75.43	75.46	75.42	75.42	4150.0
2013-07-16 04:30:00	QQQ	ETF	75.45	75.46	75.45	75.46	1800.0
2013-07-16 05:00:00	QQQ	ETF	75.48	75.5	75.48	75.5	1800.0
2013-07-16 06:30:00	QQQ	ETF	75.47	75.47	75.47	75.47	2600.0
2013-07-16 07:00:00	QQQ	ETF	75.47	75.49	75.46	75.47	3500.0
2013-07-16 07:30:00	QQQ	ETF	75.47	75.5	75.46	75.46	11438.0
2013-07-16 08:00:00	QQQ	ETF	75.47	75.49	75.46	75.49	3369.0
2013-07-16 08:30:00	QQQ	ETF	75.45	75.52	75.43	75.51	27737.0
2013-07-16 09:00:00	QQQ	ETF	75.5	75.54	75.5	75.52	43684.0
2013-07-16 09:30:00	QQQ	ETF	75.54	75.57	75.43	75.44	2398472.0
2013-07-16 10:00:00	QQQ	ETF	75.45	75.59	75.45	75.49	1835969.0
2013-07-16 10:30:00	QQQ	ETF	75.48	75.55	75.39	75.39	1030870.0
2013-07-16 11:00:00	QQQ	ETF	75.39	75.41	75.27	75.3241	1811748.0
2013-07-16 11:30:00	QQQ	ETF	75.32	75.34	75.2	75.245	1205883.0
2013-07-16 12:00:00	QQQ	ETF	75.2471	75.38	75.23	75.355	1112821.0
2013-07-16 12:30:00	QQQ	ETF	75.355	75.36	75.275	75.3	526047.0
2013-07-16 13:00:00	QQQ	ETF	75.3	75.315	75.18	75.23	1568192.0
2013-07-16 13:30:00	QQQ	ETF	75.23	75.38	75.2	75.38	1159977.0

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

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