PREVIEW / etf_30min / 2013-08-16

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-08-16.parquet
  size:    333 KB
  rows:    11,076

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-08-16 04:00:00	SPY	ETF	166.24	166.45	166.21	166.21	845.0
2013-08-16 04:30:00	SPY	ETF	166.31	166.33	166.31	166.33	200.0
2013-08-16 05:00:00	SPY	ETF	166.4	166.42	166.27	166.27	1401.0
2013-08-16 05:30:00	SPY	ETF	166.36	166.36	166.34	166.34	2000.0
2013-08-16 06:00:00	SPY	ETF	166.48	166.54	166.48	166.48	4655.0
2013-08-16 06:30:00	SPY	ETF	166.45	166.62	166.45	166.45	33443.0
2013-08-16 07:00:00	SPY	ETF	166.53	166.67	166.49	166.59	290875.0
2013-08-16 07:30:00	SPY	ETF	166.62	166.64	166.47	166.47	117943.0
2013-08-16 08:00:00	SPY	ETF	166.48	166.64	166.38	166.4	167488.0
2013-08-16 08:30:00	SPY	ETF	166.36	166.45	166.26	166.28	332795.0
2013-08-16 09:00:00	SPY	ETF	166.29	166.34	166.03	166.06	1066336.0
2013-08-16 09:30:00	SPY	ETF	166.06	166.38	165.87	166.31	18150479.0
2013-08-16 10:00:00	SPY	ETF	166.32	166.52	166.07	166.34	8829754.0
2013-08-16 10:30:00	SPY	ETF	166.35	166.63	166.19	166.55	6145754.0
2013-08-16 11:00:00	SPY	ETF	166.55	166.63	166.19	166.279	6210596.0
2013-08-16 11:30:00	SPY	ETF	166.28	166.55	166.24	166.46	5229840.0
2013-08-16 12:00:00	SPY	ETF	166.45	166.49	166.18	166.22	6033145.0
2013-08-16 12:30:00	SPY	ETF	166.22	166.24	166.0	166.06	5530365.0
2013-08-16 13:00:00	SPY	ETF	166.06	166.11	165.68	165.76	7924219.0
2013-08-16 13:30:00	SPY	ETF	165.75	165.82	165.56	165.7901	5640956.0
2013-08-16 14:00:00	SPY	ETF	165.7985	165.87	165.5	165.6901	5898274.0
2013-08-16 14:30:00	SPY	ETF	165.69	166.12	165.56	166.1	9412251.0
2013-08-16 15:00:00	SPY	ETF	166.09	166.18	165.93	166.03	7867459.0
2013-08-16 15:30:00	SPY	ETF	166.035	166.29	165.82	165.88	14102737.0
2013-08-16 16:00:00	SPY	ETF	165.87	166.4028	165.555	165.6	16454122.0
2013-08-16 16:30:00	SPY	ETF	165.6	166.4028	165.53	165.56	936015.0
2013-08-16 17:00:00	SPY	ETF	165.56	166.194	165.52	165.52	841042.0
2013-08-16 17:30:00	SPY	ETF	165.53	165.54	165.5	165.54	108361.0
2013-08-16 18:00:00	SPY	ETF	165.53	165.59	165.52	165.56	152121.0
2013-08-16 18:30:00	SPY	ETF	165.55	165.59	165.54	165.56	26380.0
2013-08-16 19:00:00	SPY	ETF	165.56	165.57	165.55	165.55	10994.0
2013-08-16 19:30:00	SPY	ETF	165.55	165.61	165.53	165.55	42534.0
2013-08-16 04:30:00	QQQ	ETF	75.53	75.53	75.53	75.53	1600.0
2013-08-16 06:00:00	QQQ	ETF	75.59	75.59	75.58	75.58	200.0
2013-08-16 07:00:00	QQQ	ETF	75.59	75.62	75.58	75.62	3536.0
2013-08-16 07:30:00	QQQ	ETF	75.61	75.61	75.58	75.59	17536.0
2013-08-16 08:00:00	QQQ	ETF	75.6	75.6	75.45	75.58	71520.0
2013-08-16 08:30:00	QQQ	ETF	75.6	75.6	75.52	75.55	147682.0
2013-08-16 09:00:00	QQQ	ETF	75.52	75.57	75.45	75.53	143423.0
2013-08-16 09:30:00	QQQ	ETF	75.54	75.68	75.35	75.64	3964904.0
2013-08-16 10:00:00	QQQ	ETF	75.64	75.76	75.51	75.74	3130518.0
2013-08-16 10:30:00	QQQ	ETF	75.73	75.84	75.67	75.82	951079.0
2013-08-16 11:00:00	QQQ	ETF	75.8122	75.87	75.65	75.69	1210656.0
2013-08-16 11:30:00	QQQ	ETF	75.68	75.8	75.67	75.76	614789.0
2013-08-16 12:00:00	QQQ	ETF	75.75	75.8	75.68	75.69	814486.0
2013-08-16 12:30:00	QQQ	ETF	75.6941	75.6941	75.57	75.63	1185828.0
2013-08-16 13:00:00	QQQ	ETF	75.64	75.66	75.461	75.53	1035294.0
2013-08-16 13:30:00	QQQ	ETF	75.52	75.56	75.43	75.531	994690.0
2013-08-16 14:00:00	QQQ	ETF	75.54	75.57	75.4	75.4701	805063.0
2013-08-16 14:30:00	QQQ	ETF	75.48	75.6202	75.43	75.6195	829066.0

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

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