PREVIEW / etf_30min / 2012-07-11

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-07-11.parquet
  size:    271 KB
  rows:    9,112

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
2012-07-11 04:00:00	SPY	ETF	134.16	134.29	134.16	134.2	13500.0
2012-07-11 04:30:00	SPY	ETF	134.3	134.58	134.28	134.58	11365.0
2012-07-11 05:00:00	SPY	ETF	134.58	134.6	134.46	134.5	6322.0
2012-07-11 05:30:00	SPY	ETF	134.46	134.46	134.46	134.46	100.0
2012-07-11 06:00:00	SPY	ETF	134.48	134.48	134.35	134.45	25660.0
2012-07-11 06:30:00	SPY	ETF	134.45	134.76	134.45	134.7	62370.0
2012-07-11 07:00:00	SPY	ETF	134.71	134.84	134.62	134.62	126053.0
2012-07-11 07:30:00	SPY	ETF	134.61	134.67	134.44	134.47	60113.0
2012-07-11 08:00:00	SPY	ETF	134.51	134.64	134.27	134.29	1301188.0
2012-07-11 08:30:00	SPY	ETF	134.31	134.48	134.27	134.3	597861.0
2012-07-11 09:00:00	SPY	ETF	134.31	134.41	134.14	134.21	958725.0
2012-07-11 09:30:00	SPY	ETF	134.21	134.52	133.99	134.3301	13861388.0
2012-07-11 10:00:00	SPY	ETF	134.34	134.6	134.2	134.26	10614856.0
2012-07-11 10:30:00	SPY	ETF	134.26	134.34	133.93	133.93	8019967.0
2012-07-11 11:00:00	SPY	ETF	133.94	134.3	133.9	134.07	7808765.0
2012-07-11 11:30:00	SPY	ETF	134.07	134.32	134.05	134.26	5204910.0
2012-07-11 12:00:00	SPY	ETF	134.26	134.48	134.21	134.25	6030248.0
2012-07-11 12:30:00	SPY	ETF	134.25	134.46	134.25	134.43	4576762.0
2012-07-11 13:00:00	SPY	ETF	134.42	134.43	134.09	134.24	5058100.0
2012-07-11 13:30:00	SPY	ETF	134.24	134.39	134.14	134.34	3419902.0
2012-07-11 14:00:00	SPY	ETF	134.34	134.48	133.47	133.6	21859108.0
2012-07-11 14:30:00	SPY	ETF	133.59	133.85	133.38	133.631	10124076.0
2012-07-11 15:00:00	SPY	ETF	133.63	133.98	133.63	133.76	9580105.0
2012-07-11 15:30:00	SPY	ETF	133.75	134.54	133.68	134.18	22818531.0
2012-07-11 16:00:00	SPY	ETF	134.16	134.27	134.0411	134.25	3442666.0
2012-07-11 16:30:00	SPY	ETF	134.26	134.42	134.26	134.38	3733362.0
2012-07-11 17:00:00	SPY	ETF	134.38	134.53	134.36	134.51	314560.0
2012-07-11 17:30:00	SPY	ETF	134.49	134.49	134.44	134.45	45356.0
2012-07-11 18:00:00	SPY	ETF	134.47	134.5	134.35	134.35	145668.0
2012-07-11 18:30:00	SPY	ETF	134.36	134.4	134.36	134.39	6097.0
2012-07-11 19:00:00	SPY	ETF	134.41	134.46	134.4	134.43	5145.0
2012-07-11 19:30:00	SPY	ETF	134.44	134.47	134.38	134.42	128131.0
2012-07-11 06:30:00	QQQ	ETF	63.57	63.58	63.56	63.58	400.0
2012-07-11 07:00:00	QQQ	ETF	63.56	63.61	63.56	63.59	33470.0
2012-07-11 07:30:00	QQQ	ETF	63.54	63.56	63.46	63.46	16190.0
2012-07-11 08:00:00	QQQ	ETF	63.46	63.46	63.32	63.32	858124.0
2012-07-11 08:30:00	QQQ	ETF	63.32	63.42	63.31	63.34	184517.0
2012-07-11 09:00:00	QQQ	ETF	63.32	63.39	63.26	63.29	129167.0
2012-07-11 09:30:00	QQQ	ETF	63.29	63.34	63.06	63.22	6991553.0
2012-07-11 10:00:00	QQQ	ETF	63.21	63.46	63.2	63.27	2247251.0
2012-07-11 10:30:00	QQQ	ETF	63.27	63.3	63.0	63.01	2027234.0
2012-07-11 11:00:00	QQQ	ETF	63.01	63.16	62.95	62.96	3172330.0
2012-07-11 11:30:00	QQQ	ETF	62.96	63.14	62.95	63.1	1233755.0
2012-07-11 12:00:00	QQQ	ETF	63.1	63.18	62.99	63.0082	1429425.0
2012-07-11 12:30:00	QQQ	ETF	63.0	63.11	63.0	63.09	974308.0
2012-07-11 13:00:00	QQQ	ETF	63.09	63.09	62.84	62.92	1969749.0
2012-07-11 13:30:00	QQQ	ETF	62.92	63.03	62.8405	63.0	1327383.0
2012-07-11 14:00:00	QQQ	ETF	63.01	63.07	62.56	62.62	5788971.0
2012-07-11 14:30:00	QQQ	ETF	62.62	62.76	62.5	62.67	2630340.0
2012-07-11 15:00:00	QQQ	ETF	62.67	62.89	62.67	62.79	3278189.0

> showing 50 of 9,112 rows — these rows as CSV

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