PREVIEW / etf_30min / 2011-06-20

all etf 30-min files

  file:    by_date/etf_30min/2011/2011-06-20.parquet
  size:    274 KB
  rows:    9,150

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-06-20 04:00:00	SPY	ETF	126.56	126.56	126.21	126.32	3366.0
2011-06-20 04:30:00	SPY	ETF	126.25	126.47	126.25	126.36	1700.0
2011-06-20 05:00:00	SPY	ETF	126.36	126.38	126.36	126.38	400.0
2011-06-20 05:30:00	SPY	ETF	126.39	126.45	126.29	126.45	2800.0
2011-06-20 06:00:00	SPY	ETF	126.43	126.6	126.43	126.54	19000.0
2011-06-20 06:30:00	SPY	ETF	126.54	127.3	126.35	126.43	187600.0
2011-06-20 07:00:00	SPY	ETF	126.43	126.47	126.34	126.4	260311.0
2011-06-20 07:30:00	SPY	ETF	126.42	126.44	126.18	126.32	542213.0
2011-06-20 08:00:00	SPY	ETF	126.35	126.6	126.25	126.47	1230797.0
2011-06-20 08:30:00	SPY	ETF	126.49	127.05	126.43	126.46	1296152.0
2011-06-20 09:00:00	SPY	ETF	126.47	126.83	126.47	126.62	1821743.0
2011-06-20 09:30:00	SPY	ETF	126.62	127.22	126.58	127.14	15562005.0
2011-06-20 10:00:00	SPY	ETF	127.14	127.28	126.859	127.19	13351416.0
2011-06-20 10:30:00	SPY	ETF	127.19	127.61	127.17	127.43	17330285.0
2011-06-20 11:00:00	SPY	ETF	127.43	127.67	127.3	127.64	10488282.0
2011-06-20 11:30:00	SPY	ETF	127.64	127.93	127.6	127.89	8560687.0
2011-06-20 12:00:00	SPY	ETF	127.89	127.97	127.72	127.94	5454370.0
2011-06-20 12:30:00	SPY	ETF	127.93	127.97	127.7	127.73	7084585.0
2011-06-20 13:00:00	SPY	ETF	127.73	127.79	127.6	127.74	6817772.0
2011-06-20 13:30:00	SPY	ETF	127.73	127.82	127.51	127.551	5365353.0
2011-06-20 14:00:00	SPY	ETF	127.55	127.69	127.51	127.59	5266481.0
2011-06-20 14:30:00	SPY	ETF	127.585	127.94	127.58	127.83	8146351.0
2011-06-20 15:00:00	SPY	ETF	127.83	127.83	127.41	127.49	10303300.0
2011-06-20 15:30:00	SPY	ETF	127.49	127.87	127.45	127.72	21209441.0
2011-06-20 16:00:00	SPY	ETF	127.72	127.9	127.66	127.81	14526663.0
2011-06-20 16:30:00	SPY	ETF	127.81	127.81	127.5	127.76	568332.0
2011-06-20 17:00:00	SPY	ETF	127.0555	127.82	127.0555	127.77	269421.0
2011-06-20 17:30:00	SPY	ETF	127.77	127.78	127.74	127.76	1085648.0
2011-06-20 18:00:00	SPY	ETF	127.75	127.82	127.7	127.79	51463.0
2011-06-20 18:30:00	SPY	ETF	127.77	127.79	127.75	127.79	4176.0
2011-06-20 19:00:00	SPY	ETF	127.76	127.89	127.76	127.88	33672.0
2011-06-20 19:30:00	SPY	ETF	127.88	128.04	127.88	127.96	84049.0
2011-06-20 04:00:00	QQQ	ETF	53.56	53.56	53.5	53.5	1200.0
2011-06-20 04:30:00	QQQ	ETF	53.51	53.52	53.51	53.52	400.0
2011-06-20 05:00:00	QQQ	ETF	53.59	53.59	53.59	53.59	3000.0
2011-06-20 05:30:00	QQQ	ETF	53.52	53.53	53.52	53.53	1033.0
2011-06-20 06:00:00	QQQ	ETF	53.67	53.67	53.67	53.67	2100.0
2011-06-20 06:30:00	QQQ	ETF	53.66	53.66	53.6	53.61	10800.0
2011-06-20 07:00:00	QQQ	ETF	53.58	53.6	53.55	53.55	31300.0
2011-06-20 07:30:00	QQQ	ETF	53.57	53.57	53.5	53.53	16119.0
2011-06-20 08:00:00	QQQ	ETF	53.56	53.62	53.52	53.6	139850.0
2011-06-20 08:30:00	QQQ	ETF	53.6	53.79	53.59	53.6	80638.0
2011-06-20 09:00:00	QQQ	ETF	53.61	53.72	53.61	53.65	415805.0
2011-06-20 09:30:00	QQQ	ETF	53.66	53.97	53.64	53.91	5305349.0
2011-06-20 10:00:00	QQQ	ETF	53.91	53.96	53.711	53.845	4748666.0
2011-06-20 10:30:00	QQQ	ETF	53.85	53.97	53.85	53.87	3339301.0
2011-06-20 11:00:00	QQQ	ETF	53.86	53.93	53.81	53.93	2343754.0
2011-06-20 11:30:00	QQQ	ETF	53.93	54.15	53.7904	54.13	4140465.0
2011-06-20 12:00:00	QQQ	ETF	54.13	54.23	54.09	54.22	1999813.0
2011-06-20 12:30:00	QQQ	ETF	54.22	54.23	54.12	54.145	971516.0

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

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