PREVIEW / etf_30min / 2013-11-29

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-11-29.parquet
  size:    199 KB
  rows:    6,449

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-11-29 04:00:00	SPY	ETF	181.25	181.25	181.25	181.25	100.0
2013-11-29 04:30:00	SPY	ETF	180.94	181.33	180.92	181.33	1840.0
2013-11-29 05:00:00	SPY	ETF	181.28	181.3	181.28	181.3	600.0
2013-11-29 05:30:00	SPY	ETF	181.28	181.3	181.28	181.28	500.0
2013-11-29 06:00:00	SPY	ETF	181.28	181.28	181.25	181.25	937.0
2013-11-29 06:30:00	SPY	ETF	181.27	181.35	181.22	181.35	2412.0
2013-11-29 07:00:00	SPY	ETF	181.33	181.42	181.3	181.33	82033.0
2013-11-29 07:30:00	SPY	ETF	181.34	181.41	181.34	181.38	33408.0
2013-11-29 08:00:00	SPY	ETF	181.37	181.38	181.1217	181.32	608120.0
2013-11-29 08:30:00	SPY	ETF	181.34	181.34	181.27	181.3	90765.0
2013-11-29 09:00:00	SPY	ETF	181.29	181.36	181.25	181.32	192276.0
2013-11-29 09:30:00	SPY	ETF	181.32	181.59	181.21	181.56	6889528.0
2013-11-29 10:00:00	SPY	ETF	181.56	181.69	181.5	181.6601	4382901.0
2013-11-29 10:30:00	SPY	ETF	181.67	181.75	181.54	181.63	3148642.0
2013-11-29 11:00:00	SPY	ETF	181.63	181.71	181.54	181.56	2465462.0
2013-11-29 11:30:00	SPY	ETF	181.56	181.65	181.51	181.6	4829074.0
2013-11-29 12:00:00	SPY	ETF	181.595	181.66	181.54	181.595	3023222.0
2013-11-29 12:30:00	SPY	ETF	181.59	181.6	180.8	180.91	17188555.0
2013-11-29 13:00:00	SPY	ETF	180.91	181.4292	180.83	180.99	9093886.0
2013-11-29 13:30:00	SPY	ETF	181.0	181.05	180.93	180.95	734006.0
2013-11-29 14:00:00	SPY	ETF	180.95	180.97	180.92	180.95	57061.0
2013-11-29 14:30:00	SPY	ETF	180.95	180.95	180.92	180.92	40370.0
2013-11-29 15:00:00	SPY	ETF	180.9499	180.95	180.94	180.95	20144.0
2013-11-29 15:30:00	SPY	ETF	180.95	180.95	180.93	180.95	14750.0
2013-11-29 16:00:00	SPY	ETF	180.95	180.98	180.94	180.96	5170.0
2013-11-29 16:30:00	SPY	ETF	180.96	181.0	180.95	181.0	4444.0
2013-11-29 05:30:00	QQQ	ETF	85.5	85.5	85.48	85.5	12200.0
2013-11-29 06:30:00	QQQ	ETF	85.53	85.53	85.52	85.52	1300.0
2013-11-29 07:00:00	QQQ	ETF	85.56	85.59	85.56	85.56	3898.0
2013-11-29 07:30:00	QQQ	ETF	85.55	85.57	85.55	85.55	31500.0
2013-11-29 08:00:00	QQQ	ETF	85.53	85.56	85.52	85.53	18300.0
2013-11-29 08:30:00	QQQ	ETF	85.52	85.53	85.47	85.47	33285.0
2013-11-29 09:00:00	QQQ	ETF	85.47	85.57	85.45	85.55	549136.0
2013-11-29 09:30:00	QQQ	ETF	85.55	85.6403	85.4737	85.61	3841602.0
2013-11-29 10:00:00	QQQ	ETF	85.61	85.72	85.55	85.7	1365154.0
2013-11-29 10:30:00	QQQ	ETF	85.705	85.7456	85.64	85.7	1469879.0
2013-11-29 11:00:00	QQQ	ETF	85.7099	85.8	85.66	85.75	1357067.0
2013-11-29 11:30:00	QQQ	ETF	85.75	85.84	85.73	85.76	1058727.0
2013-11-29 12:00:00	QQQ	ETF	85.76	85.82	85.755	85.8	675524.0
2013-11-29 12:30:00	QQQ	ETF	85.805	85.82	85.56	85.66	3959092.0
2013-11-29 13:00:00	QQQ	ETF	85.66	85.76	85.2131	85.69	1067161.0
2013-11-29 13:30:00	QQQ	ETF	85.66	85.69	85.6401	85.68	91834.0
2013-11-29 14:00:00	QQQ	ETF	85.68	85.68	85.62	85.62	7359.0
2013-11-29 14:30:00	QQQ	ETF	85.63	85.63	85.63	85.63	1500.0
2013-11-29 15:00:00	QQQ	ETF	85.72	85.72	85.68	85.68	900.0
2013-11-29 15:30:00	QQQ	ETF	85.66	85.66	85.66	85.66	635.0
2013-11-29 16:00:00	QQQ	ETF	85.72	85.72	85.72	85.72	100.0
2013-11-29 16:30:00	QQQ	ETF	85.72	85.72	85.72	85.72	100.0
2013-11-29 06:30:00	IWM	ETF	113.42	113.93	113.42	113.9	7300.0
2013-11-29 07:00:00	IWM	ETF	113.9	114.0	113.84	114.0	10084.0

> showing 50 of 6,449 rows — these rows as CSV

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