PREVIEW / etf_30min / 2012-07-16

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-07-16.parquet
  size:    272 KB
  rows:    9,139

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-16 04:00:00	SPY	ETF	135.53	135.53	135.47	135.47	300.0
2012-07-16 04:30:00	SPY	ETF	135.55	135.55	135.37	135.37	6450.0
2012-07-16 05:00:00	SPY	ETF	135.45	135.5	135.35	135.42	13400.0
2012-07-16 05:30:00	SPY	ETF	135.4	135.4	135.29	135.35	6100.0
2012-07-16 06:00:00	SPY	ETF	135.35	135.47	135.34	135.47	5500.0
2012-07-16 06:30:00	SPY	ETF	135.52	135.55	135.41	135.41	9750.0
2012-07-16 07:00:00	SPY	ETF	135.38	135.48	135.36	135.4	67484.0
2012-07-16 07:30:00	SPY	ETF	135.4	135.47	135.38	135.43	68282.0
2012-07-16 08:00:00	SPY	ETF	135.42	135.47	135.26	135.37	974868.0
2012-07-16 08:30:00	SPY	ETF	135.36	135.43	135.2	135.38	696369.0
2012-07-16 09:00:00	SPY	ETF	135.4	135.53	135.36	135.44	1081425.0
2012-07-16 09:30:00	SPY	ETF	135.44	135.54	135.0	135.02	11227686.0
2012-07-16 10:00:00	SPY	ETF	135.02	135.32	134.9	135.31	6815745.0
2012-07-16 10:30:00	SPY	ETF	135.31	135.6	135.29	135.39	7605752.0
2012-07-16 11:00:00	SPY	ETF	135.39	135.83	135.32	135.68	7262060.0
2012-07-16 11:30:00	SPY	ETF	135.68	135.71	135.47	135.54	4392816.0
2012-07-16 12:00:00	SPY	ETF	135.54	135.66	135.28	135.33	5122610.0
2012-07-16 12:30:00	SPY	ETF	135.35	135.45	135.18	135.38	5106087.0
2012-07-16 13:00:00	SPY	ETF	135.39	135.5	135.26	135.44	4260261.0
2012-07-16 13:30:00	SPY	ETF	135.436	135.6	135.37	135.49	3936040.0
2012-07-16 14:00:00	SPY	ETF	135.49	135.76	135.49	135.71	5009572.0
2012-07-16 14:30:00	SPY	ETF	135.71	135.74	135.47	135.56	5165467.0
2012-07-16 15:00:00	SPY	ETF	135.565	135.66	135.49	135.54	4234978.0
2012-07-16 15:30:00	SPY	ETF	135.54	135.56	135.245	135.42	12173528.0
2012-07-16 16:00:00	SPY	ETF	135.41	135.6	135.32	135.33	4430056.0
2012-07-16 16:30:00	SPY	ETF	135.33	135.34	135.26	135.32	1490333.0
2012-07-16 17:00:00	SPY	ETF	135.34	135.36	135.27	135.28	5020538.0
2012-07-16 17:30:00	SPY	ETF	135.29	135.32	135.29	135.31	3178.0
2012-07-16 18:00:00	SPY	ETF	135.3	135.34	135.28	135.32	22244.0
2012-07-16 18:30:00	SPY	ETF	135.31	135.33	135.24	135.25	25900.0
2012-07-16 19:00:00	SPY	ETF	135.27	135.28	135.24	135.28	36830.0
2012-07-16 19:30:00	SPY	ETF	135.29	135.31	135.25	135.25	31250.0
2012-07-16 07:00:00	QQQ	ETF	63.19	63.24	63.19	63.21	40700.0
2012-07-16 07:30:00	QQQ	ETF	63.2	63.22	63.2	63.22	500.0
2012-07-16 08:00:00	QQQ	ETF	63.19	63.23	63.15	63.22	58910.0
2012-07-16 08:30:00	QQQ	ETF	63.13	63.24	63.13	63.19	215456.0
2012-07-16 09:00:00	QQQ	ETF	63.21	63.32	63.21	63.26	159610.0
2012-07-16 09:30:00	QQQ	ETF	63.26	63.37	62.96	63.01	3853485.0
2012-07-16 10:00:00	QQQ	ETF	63.01	63.2	62.95	63.2	2140351.0
2012-07-16 10:30:00	QQQ	ETF	63.19	63.32	63.19	63.22	1513232.0
2012-07-16 11:00:00	QQQ	ETF	63.23	63.52	63.18	63.445	3058667.0
2012-07-16 11:30:00	QQQ	ETF	63.44	63.45	63.32	63.37	2002823.0
2012-07-16 12:00:00	QQQ	ETF	63.37	63.43	63.18	63.23	1603679.0
2012-07-16 12:30:00	QQQ	ETF	63.23	63.28	63.08	63.19	1798868.0
2012-07-16 13:00:00	QQQ	ETF	63.19	63.271	63.141	63.2692	1064134.0
2012-07-16 13:30:00	QQQ	ETF	63.2655	63.4	63.26	63.3	1071526.0
2012-07-16 14:00:00	QQQ	ETF	63.31	63.41	63.31	63.35	893554.0
2012-07-16 14:30:00	QQQ	ETF	63.36	63.37	63.18	63.24	1891169.0
2012-07-16 15:00:00	QQQ	ETF	63.25	63.32	63.2	63.26	1131800.0
2012-07-16 15:30:00	QQQ	ETF	63.26	63.27	63.06	63.2	2751393.0

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

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