PREVIEW / etf_30min / 2011-12-09

all etf 30-min files

  file:    by_date/etf_30min/2011/2011-12-09.parquet
  size:    282 KB
  rows:    9,347

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
2011-12-09 04:00:00	SPY	ETF	124.55	124.55	124.4	124.4	6200.0
2011-12-09 04:30:00	SPY	ETF	124.35	124.4	124.17	124.32	14524.0
2011-12-09 05:00:00	SPY	ETF	124.32	124.77	124.27	124.77	9601.0
2011-12-09 05:30:00	SPY	ETF	124.72	125.22	124.6	125.22	26991.0
2011-12-09 06:00:00	SPY	ETF	125.22	125.35	125.0	125.14	45268.0
2011-12-09 06:30:00	SPY	ETF	125.1	125.51	125.1	125.39	67700.0
2011-12-09 07:00:00	SPY	ETF	125.38	125.51	125.16	125.34	373001.0
2011-12-09 07:30:00	SPY	ETF	125.32	125.4	125.08	125.14	402917.0
2011-12-09 08:00:00	SPY	ETF	125.12	125.24	124.7	124.87	1917529.0
2011-12-09 08:30:00	SPY	ETF	124.84	124.94	124.48	124.59	3127918.0
2011-12-09 09:00:00	SPY	ETF	124.59	124.69	124.4	124.5	2608950.0
2011-12-09 09:30:00	SPY	ETF	124.51	125.34	124.4	125.1	29010790.0
2011-12-09 10:00:00	SPY	ETF	125.1	125.55	125.07	125.25	16272104.0
2011-12-09 10:30:00	SPY	ETF	125.24	125.49	124.96	125.47	19643852.0
2011-12-09 11:00:00	SPY	ETF	125.46	125.86	125.43	125.83	15453319.0
2011-12-09 11:30:00	SPY	ETF	125.82	126.08	125.69	125.71	16731899.0
2011-12-09 12:00:00	SPY	ETF	125.71	125.95	125.58	125.76	8525536.0
2011-12-09 12:30:00	SPY	ETF	125.77	126.0	125.72	125.83	7749279.0
2011-12-09 13:00:00	SPY	ETF	125.83	126.11	125.7304	126.02	5810654.0
2011-12-09 13:30:00	SPY	ETF	126.02	126.07	125.87	125.89	5138193.0
2011-12-09 14:00:00	SPY	ETF	125.9	126.14	125.8	126.08	7790520.0
2011-12-09 14:30:00	SPY	ETF	126.08	126.37	126.08	126.181	11418955.0
2011-12-09 15:00:00	SPY	ETF	126.18	126.21	125.92	126.2	10037926.0
2011-12-09 15:30:00	SPY	ETF	126.21	126.36	125.95	126.03	27278492.0
2011-12-09 16:00:00	SPY	ETF	126.04	126.61	126.04	126.46	6364225.0
2011-12-09 16:30:00	SPY	ETF	126.45	126.58	126.04	126.52	11395480.0
2011-12-09 17:00:00	SPY	ETF	126.53	126.57	126.42	126.54	301710.0
2011-12-09 17:30:00	SPY	ETF	126.54	126.54	126.47	126.5	94545.0
2011-12-09 18:00:00	SPY	ETF	126.48	126.6	126.03	126.56	145687.0
2011-12-09 18:30:00	SPY	ETF	126.55	126.59	126.48	126.56	39467.0
2011-12-09 19:00:00	SPY	ETF	126.56	126.59	126.5	126.55	56638.0
2011-12-09 19:30:00	SPY	ETF	126.55	126.6	126.53	126.6	40263.0
2011-12-09 04:00:00	QQQ	ETF	56.3	56.37	56.3	56.37	1300.0
2011-12-09 05:00:00	QQQ	ETF	56.34	56.41	56.34	56.41	600.0
2011-12-09 05:30:00	QQQ	ETF	56.36	56.52	56.36	56.52	500.0
2011-12-09 06:00:00	QQQ	ETF	56.5	56.5	56.5	56.5	3000.0
2011-12-09 06:30:00	QQQ	ETF	56.56	56.72	56.54	56.67	69100.0
2011-12-09 07:00:00	QQQ	ETF	56.7	56.75	56.62	56.68	210735.0
2011-12-09 07:30:00	QQQ	ETF	56.63	56.69	56.51	56.54	189720.0
2011-12-09 08:00:00	QQQ	ETF	56.51	56.72	56.25	56.39	1003396.0
2011-12-09 08:30:00	QQQ	ETF	56.25	56.48	56.23	56.3	891547.0
2011-12-09 09:00:00	QQQ	ETF	56.29	56.34	56.23	56.26	323075.0
2011-12-09 09:30:00	QQQ	ETF	56.26	56.63	56.24	56.49	6263979.0
2011-12-09 10:00:00	QQQ	ETF	56.49	56.79	56.46	56.57	4737331.0
2011-12-09 10:30:00	QQQ	ETF	56.57	56.78	56.44	56.7699	5957326.0
2011-12-09 11:00:00	QQQ	ETF	56.77	56.9	56.74	56.88	3256361.0
2011-12-09 11:30:00	QQQ	ETF	56.88	56.97	56.83	56.84	2175449.0
2011-12-09 12:00:00	QQQ	ETF	56.8332	56.929	56.76	56.87	1340657.0
2011-12-09 12:30:00	QQQ	ETF	56.86	56.98	56.85	56.93	3061464.0
2011-12-09 13:00:00	QQQ	ETF	56.9399	57.07	56.89	57.06	1672582.0

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

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