PREVIEW / etf_30min / 2014-08-26

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-08-26.parquet
  size:    337 KB
  rows:    11,587

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
2014-08-26 04:00:00	SPY	ETF	200.02	200.03	199.94	199.94	3984.0
2014-08-26 05:00:00	SPY	ETF	200.03	200.1	199.97	199.98	11734.0
2014-08-26 05:30:00	SPY	ETF	200.02	200.02	199.83	199.88	5893.0
2014-08-26 06:00:00	SPY	ETF	199.93	200.19	199.93	200.1	5139.0
2014-08-26 06:30:00	SPY	ETF	200.26	200.31	200.23	200.28	55040.0
2014-08-26 07:00:00	SPY	ETF	200.23	200.42	200.23	200.39	61209.0
2014-08-26 07:30:00	SPY	ETF	200.4	200.44	200.3	200.36	56654.0
2014-08-26 08:00:00	SPY	ETF	200.23	200.36	200.23	200.29	189072.0
2014-08-26 08:30:00	SPY	ETF	200.3	200.36	200.15	200.26	218766.0
2014-08-26 09:00:00	SPY	ETF	200.28	200.34	200.25	200.33	182543.0
2014-08-26 09:30:00	SPY	ETF	200.33	200.56	200.28	200.48	5865175.0
2014-08-26 10:00:00	SPY	ETF	200.485	200.62	200.3	200.52	4564940.0
2014-08-26 10:30:00	SPY	ETF	200.53	200.76	200.45	200.749	3161460.0
2014-08-26 11:00:00	SPY	ETF	200.75	200.82	200.74	200.81	3273253.0
2014-08-26 11:30:00	SPY	ETF	200.81	200.82	200.53	200.57	3082972.0
2014-08-26 12:00:00	SPY	ETF	200.57	200.64	200.51	200.56	2510233.0
2014-08-26 12:30:00	SPY	ETF	200.55	200.61	200.41	200.44	2652559.0
2014-08-26 13:00:00	SPY	ETF	200.435	200.56	200.31	200.515	2347009.0
2014-08-26 13:30:00	SPY	ETF	200.51	200.55	200.4	200.51	1722394.0
2014-08-26 14:00:00	SPY	ETF	200.505	200.57	200.495	200.515	1317519.0
2014-08-26 14:30:00	SPY	ETF	200.51	200.56	200.43	200.535	1652129.0
2014-08-26 15:00:00	SPY	ETF	200.535	200.54	200.34	200.37	2629995.0
2014-08-26 15:30:00	SPY	ETF	200.36	200.46	200.28	200.34	5463819.0
2014-08-26 16:00:00	SPY	ETF	200.35	200.45	200.3	200.42	1573899.0
2014-08-26 16:30:00	SPY	ETF	200.41	200.45	200.33	200.44	4069504.0
2014-08-26 17:00:00	SPY	ETF	200.44	200.45	200.4	200.43	90518.0
2014-08-26 17:30:00	SPY	ETF	200.43	200.46	200.43	200.46	11280.0
2014-08-26 18:00:00	SPY	ETF	200.48	200.48	200.43	200.47	9995.0
2014-08-26 18:30:00	SPY	ETF	200.44	200.44	200.44	200.44	740.0
2014-08-26 19:00:00	SPY	ETF	200.46	200.47	200.45	200.45	9914.0
2014-08-26 19:30:00	SPY	ETF	200.45	200.46	200.41	200.43	23098.0
2014-08-26 04:00:00	QQQ	ETF	99.3	99.3	99.3	99.3	234.0
2014-08-26 06:30:00	QQQ	ETF	99.46	99.49	99.44	99.46	39100.0
2014-08-26 07:00:00	QQQ	ETF	99.45	99.54	99.45	99.52	26520.0
2014-08-26 07:30:00	QQQ	ETF	99.49	99.54	99.49	99.49	7900.0
2014-08-26 08:00:00	QQQ	ETF	99.51	99.52	99.49	99.52	14430.0
2014-08-26 08:30:00	QQQ	ETF	99.51	99.51	99.4	99.47	51672.0
2014-08-26 09:00:00	QQQ	ETF	99.48	99.54	99.48	99.53	105047.0
2014-08-26 09:30:00	QQQ	ETF	99.53	99.56	99.3	99.46	3283466.0
2014-08-26 10:00:00	QQQ	ETF	99.45	99.49	99.27	99.43	2152817.0
2014-08-26 10:30:00	QQQ	ETF	99.42	99.5	99.37	99.4872	1200566.0
2014-08-26 11:00:00	QQQ	ETF	99.49	99.57	99.47	99.5501	1137137.0
2014-08-26 11:30:00	QQQ	ETF	99.56	99.57	99.47	99.49	731489.0
2014-08-26 12:00:00	QQQ	ETF	99.49	99.5573	99.46	99.5038	670547.0
2014-08-26 12:30:00	QQQ	ETF	99.5	99.53	99.43	99.44	810352.0
2014-08-26 13:00:00	QQQ	ETF	99.45	99.51	99.405	99.485	761568.0
2014-08-26 13:30:00	QQQ	ETF	99.49	99.52	99.46	99.52	617414.0
2014-08-26 14:00:00	QQQ	ETF	99.52	99.6	99.51	99.57	983766.0
2014-08-26 14:30:00	QQQ	ETF	99.58	99.61	99.52	99.6	692496.0
2014-08-26 15:00:00	QQQ	ETF	99.594	99.61	99.502	99.5201	750431.0

> showing 50 of 11,587 rows — these rows as CSV

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