PREVIEW / etf_30min / 2012-12-19

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-12-19.parquet
  size:    306 KB
  rows:    10,480

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-12-19 04:00:00	SPY	ETF	145.3	145.33	145.26	145.33	2248.0
2012-12-19 04:30:00	SPY	ETF	145.41	145.41	145.41	145.41	4000.0
2012-12-19 05:00:00	SPY	ETF	145.48	145.59	145.48	145.56	38900.0
2012-12-19 06:00:00	SPY	ETF	145.57	145.6	145.57	145.58	5840.0
2012-12-19 06:30:00	SPY	ETF	145.58	145.6	145.49	145.57	37850.0
2012-12-19 07:00:00	SPY	ETF	145.54	145.63	145.5	145.53	576163.0
2012-12-19 07:30:00	SPY	ETF	145.54	145.6	145.51	145.56	300762.0
2012-12-19 08:00:00	SPY	ETF	145.56	145.72	145.52	145.67	599606.0
2012-12-19 08:30:00	SPY	ETF	145.55	145.72	145.55	145.65	1009425.0
2012-12-19 09:00:00	SPY	ETF	145.64	145.75	145.41	145.54	666231.0
2012-12-19 09:30:00	SPY	ETF	145.53	145.58	145.07	145.08	12916299.0
2012-12-19 10:00:00	SPY	ETF	145.09	145.16	144.86	144.95	18612372.0
2012-12-19 10:30:00	SPY	ETF	144.96	145.2626	144.92	145.14	8779662.0
2012-12-19 11:00:00	SPY	ETF	145.14	145.34	145.07	145.15	10381235.0
2012-12-19 11:30:00	SPY	ETF	145.16	145.32	145.11	145.12	7432975.0
2012-12-19 12:00:00	SPY	ETF	145.12	145.21	144.97	145.16	6484743.0
2012-12-19 12:30:00	SPY	ETF	145.16	145.34	145.02	145.125	5272502.0
2012-12-19 13:00:00	SPY	ETF	145.12	145.19	144.96	145.11	5066914.0
2012-12-19 13:30:00	SPY	ETF	145.115	145.12	144.84	145.005	4715171.0
2012-12-19 14:00:00	SPY	ETF	145.0	145.0	144.65	144.81	12260335.0
2012-12-19 14:30:00	SPY	ETF	144.815	144.85	144.49	144.68	8340978.0
2012-12-19 15:00:00	SPY	ETF	144.68	144.73	144.56	144.7	6771659.0
2012-12-19 15:30:00	SPY	ETF	144.71	144.95	144.24	144.28	22446632.0
2012-12-19 16:00:00	SPY	ETF	144.3	144.9353	144.24	144.35	13731857.0
2012-12-19 16:30:00	SPY	ETF	144.35	144.39	144.16	144.18	407353.0
2012-12-19 17:00:00	SPY	ETF	144.16	144.2	143.96	144.05	543023.0
2012-12-19 17:30:00	SPY	ETF	144.05	144.07	143.99	144.03	87639.0
2012-12-19 18:00:00	SPY	ETF	144.03	144.05	143.91	143.93	107818.0
2012-12-19 18:30:00	SPY	ETF	143.95	144.05	143.93	144.03	48487.0
2012-12-19 19:00:00	SPY	ETF	144.02	144.09	143.97	143.97	62880.0
2012-12-19 19:30:00	SPY	ETF	143.98	144.09	143.98	144.09	19980.0
2012-12-19 04:30:00	QQQ	ETF	66.69	66.69	66.69	66.69	100.0
2012-12-19 05:00:00	QQQ	ETF	66.75	66.75	66.75	66.75	100.0
2012-12-19 05:30:00	QQQ	ETF	66.75	66.75	66.75	66.75	12488.0
2012-12-19 06:00:00	QQQ	ETF	66.73	66.73	66.73	66.73	3000.0
2012-12-19 06:30:00	QQQ	ETF	66.69	66.74	66.69	66.73	32700.0
2012-12-19 07:00:00	QQQ	ETF	66.71	66.77	66.71	66.77	4500.0
2012-12-19 07:30:00	QQQ	ETF	66.77	66.78	66.76	66.77	12500.0
2012-12-19 08:00:00	QQQ	ETF	66.76	66.78	66.7	66.76	53777.0
2012-12-19 08:30:00	QQQ	ETF	66.75	66.75	66.67	66.75	84626.0
2012-12-19 09:00:00	QQQ	ETF	66.74	66.78	66.66	66.71	215172.0
2012-12-19 09:30:00	QQQ	ETF	66.71	66.76	66.52	66.525	3310769.0
2012-12-19 10:00:00	QQQ	ETF	66.51	66.56	66.37	66.43	2612849.0
2012-12-19 10:30:00	QQQ	ETF	66.42	66.62	66.4	66.5462	2627690.0
2012-12-19 11:00:00	QQQ	ETF	66.54	66.7	66.53	66.61	2720331.0
2012-12-19 11:30:00	QQQ	ETF	66.61	66.73	66.53	66.539	2131138.0
2012-12-19 12:00:00	QQQ	ETF	66.535	66.59	66.47	66.59	2084570.0
2012-12-19 12:30:00	QQQ	ETF	66.58	66.64	66.49	66.53	1329029.0
2012-12-19 13:00:00	QQQ	ETF	66.54	66.57	66.42	66.51	1253286.0
2012-12-19 13:30:00	QQQ	ETF	66.5	66.5	66.34	66.45	1056963.0

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

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