PREVIEW / etf_30min / 2013-05-07

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-05-07.parquet
  size:    318 KB
  rows:    10,822

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-05-07 04:00:00	SPY	ETF	161.78	161.78	161.78	161.78	200.0
2013-05-07 05:00:00	SPY	ETF	161.79	161.91	161.79	161.91	5200.0
2013-05-07 05:30:00	SPY	ETF	161.88	161.96	161.88	161.96	13100.0
2013-05-07 06:00:00	SPY	ETF	161.91	161.99	161.91	161.99	26900.0
2013-05-07 06:30:00	SPY	ETF	162.0	162.06	162.0	162.03	12944.0
2013-05-07 07:00:00	SPY	ETF	162.03	162.07	162.0	162.02	63186.0
2013-05-07 07:30:00	SPY	ETF	162.03	162.12	162.0	162.1	121667.0
2013-05-07 08:00:00	SPY	ETF	162.0	162.16	161.343	162.13	548333.0
2013-05-07 08:30:00	SPY	ETF	162.13	162.14	161.99	162.01	353814.0
2013-05-07 09:00:00	SPY	ETF	162.01	162.16	161.99	162.11	575327.0
2013-05-07 09:30:00	SPY	ETF	162.13	162.39	162.0	162.37	12365941.0
2013-05-07 10:00:00	SPY	ETF	162.37	162.43	161.67	161.955	14802351.0
2013-05-07 10:30:00	SPY	ETF	161.96	162.18	161.9	162.04	5704824.0
2013-05-07 11:00:00	SPY	ETF	162.04	162.25	162.02	162.17	5275929.0
2013-05-07 11:30:00	SPY	ETF	162.17	162.22	162.0	162.101	3912279.0
2013-05-07 12:00:00	SPY	ETF	162.1016	162.27	162.09	162.23	3268912.0
2013-05-07 12:30:00	SPY	ETF	162.232	162.47	162.21	162.45	5680748.0
2013-05-07 13:00:00	SPY	ETF	162.44	162.495	162.37	162.45	3406195.0
2013-05-07 13:30:00	SPY	ETF	162.45	162.625	162.43	162.56	3813504.0
2013-05-07 14:00:00	SPY	ETF	162.56	162.62	162.51	162.53	3559299.0
2013-05-07 14:30:00	SPY	ETF	162.53	162.63	162.42	162.61	4348925.0
2013-05-07 15:00:00	SPY	ETF	162.619	162.65	162.56	162.59	4138840.0
2013-05-07 15:30:00	SPY	ETF	162.59	162.63	162.5	162.59	10559739.0
2013-05-07 16:00:00	SPY	ETF	162.59	162.66	161.7775	162.6	5719902.0
2013-05-07 16:30:00	SPY	ETF	162.59	162.59	162.48	162.56	772861.0
2013-05-07 17:00:00	SPY	ETF	162.56	162.59	162.53	162.56	167299.0
2013-05-07 17:30:00	SPY	ETF	162.55	162.59	162.55	162.55	41252.0
2013-05-07 18:00:00	SPY	ETF	162.55	162.55	162.34	162.36	165575.0
2013-05-07 18:30:00	SPY	ETF	162.36	162.39	162.31	162.34	157580.0
2013-05-07 19:00:00	SPY	ETF	162.35	162.39	162.34	162.36	10669.0
2013-05-07 19:30:00	SPY	ETF	162.36	162.48	162.34	162.48	77151.0
2013-05-07 04:00:00	QQQ	ETF	72.41	72.41	72.41	72.41	9600.0
2013-05-07 06:30:00	QQQ	ETF	72.51	72.51	72.51	72.51	1600.0
2013-05-07 07:00:00	QQQ	ETF	72.49	72.5	72.49	72.49	12000.0
2013-05-07 07:30:00	QQQ	ETF	72.48	72.52	72.48	72.52	7600.0
2013-05-07 08:00:00	QQQ	ETF	72.51	72.53	72.49	72.51	54715.0
2013-05-07 08:30:00	QQQ	ETF	72.52	72.53	72.45	72.47	186251.0
2013-05-07 09:00:00	QQQ	ETF	72.47	72.55	72.46	72.5	100489.0
2013-05-07 09:30:00	QQQ	ETF	72.51	72.57	72.43	72.55	3496789.0
2013-05-07 10:00:00	QQQ	ETF	72.55	72.57	72.09	72.27	5470265.0
2013-05-07 10:30:00	QQQ	ETF	72.27	72.35	72.2	72.22	1837685.0
2013-05-07 11:00:00	QQQ	ETF	72.23	72.39	72.22	72.349	1084160.0
2013-05-07 11:30:00	QQQ	ETF	72.35	72.37	72.22	72.27	949722.0
2013-05-07 12:00:00	QQQ	ETF	72.2799	72.365	72.27	72.325	607797.0
2013-05-07 12:30:00	QQQ	ETF	72.3201	72.43	72.28	72.41	1666302.0
2013-05-07 13:00:00	QQQ	ETF	72.41	72.43	72.32	72.39	855326.0
2013-05-07 13:30:00	QQQ	ETF	72.3874	72.46	72.37	72.43	693460.0
2013-05-07 14:00:00	QQQ	ETF	72.425	72.47	72.4	72.43	1143992.0
2013-05-07 14:30:00	QQQ	ETF	72.42	72.43	72.33	72.425	1121711.0
2013-05-07 15:00:00	QQQ	ETF	72.42	72.44	72.36	72.3601	1147134.0

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

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