PREVIEW / etf_30min / 2012-03-28

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-03-28.parquet
  size:    283 KB
  rows:    9,460

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-03-28 04:00:00	SPY	ETF	141.47	141.6	141.43	141.6	9105.0
2012-03-28 04:30:00	SPY	ETF	141.43	141.43	141.23	141.25	14158.0
2012-03-28 05:30:00	SPY	ETF	141.39	141.39	141.39	141.39	20000.0
2012-03-28 06:00:00	SPY	ETF	141.29	141.38	141.2	141.38	11480.0
2012-03-28 06:30:00	SPY	ETF	141.4	141.42	141.33	141.42	12120.0
2012-03-28 07:00:00	SPY	ETF	141.38	141.52	141.32	141.45	95762.0
2012-03-28 07:30:00	SPY	ETF	141.45	141.52	141.31	141.35	120450.0
2012-03-28 08:00:00	SPY	ETF	141.33	141.46	141.16	141.4	348645.0
2012-03-28 08:30:00	SPY	ETF	141.39	141.4	140.95	140.96	2012410.0
2012-03-28 09:00:00	SPY	ETF	140.95	141.15	140.94	141.1	979316.0
2012-03-28 09:30:00	SPY	ETF	141.1	141.32	140.83	141.02	15252606.0
2012-03-28 10:00:00	SPY	ETF	141.02	141.21	140.88	140.99	7902786.0
2012-03-28 10:30:00	SPY	ETF	140.99	140.99	140.51	140.71	12414599.0
2012-03-28 11:00:00	SPY	ETF	140.715	140.73	140.53	140.595	7109423.0
2012-03-28 11:30:00	SPY	ETF	140.59	140.6	139.72	140.01	15810524.0
2012-03-28 12:00:00	SPY	ETF	140.02	140.22	139.92	140.132	9557846.0
2012-03-28 12:30:00	SPY	ETF	140.13	140.2	139.93	140.03	5575599.0
2012-03-28 13:00:00	SPY	ETF	140.035	140.155	139.83	139.96	6289561.0
2012-03-28 13:30:00	SPY	ETF	139.97	140.1	139.84	139.99	7465902.0
2012-03-28 14:00:00	SPY	ETF	139.99	140.01	139.64	139.8	7466838.0
2012-03-28 14:30:00	SPY	ETF	139.81	140.18	139.8	140.15	7646714.0
2012-03-28 15:00:00	SPY	ETF	140.16	140.3	140.04	140.185	8813237.0
2012-03-28 15:30:00	SPY	ETF	140.175	140.52	140.07	140.47	19099938.0
2012-03-28 16:00:00	SPY	ETF	140.45	141.1	140.3613	140.42	6631923.0
2012-03-28 16:30:00	SPY	ETF	140.41	141.1866	140.37	140.38	1371989.0
2012-03-28 17:00:00	SPY	ETF	140.4	140.51	140.4	140.49	132297.0
2012-03-28 17:30:00	SPY	ETF	140.47	140.47	140.43	140.47	39883.0
2012-03-28 18:00:00	SPY	ETF	140.48	140.54	140.47	140.49	68799.0
2012-03-28 18:30:00	SPY	ETF	140.5	140.59	140.49	140.52	51479.0
2012-03-28 19:00:00	SPY	ETF	140.52	140.52	140.44	140.46	16106.0
2012-03-28 19:30:00	SPY	ETF	140.47	140.57	140.45	140.54	21646.0
2012-03-28 04:30:00	QQQ	ETF	68.34	68.34	68.34	68.34	100.0
2012-03-28 07:00:00	QQQ	ETF	68.3	68.38	68.28	68.38	6390.0
2012-03-28 07:30:00	QQQ	ETF	68.37	68.37	68.27	68.3	34610.0
2012-03-28 08:00:00	QQQ	ETF	68.27	68.47	68.25	68.34	51883.0
2012-03-28 08:30:00	QQQ	ETF	68.33	68.34	68.15	68.15	1800347.0
2012-03-28 09:00:00	QQQ	ETF	68.15	68.26	68.14	68.25	363970.0
2012-03-28 09:30:00	QQQ	ETF	68.25	68.51	68.25	68.37	4334500.0
2012-03-28 10:00:00	QQQ	ETF	68.36	68.44	68.23	68.3	2931033.0
2012-03-28 10:30:00	QQQ	ETF	68.3	68.3	68.052	68.13	4684071.0
2012-03-28 11:00:00	QQQ	ETF	68.14	68.18	68.06	68.08	1855323.0
2012-03-28 11:30:00	QQQ	ETF	68.08	68.09	67.6601	67.78	4612524.0
2012-03-28 12:00:00	QQQ	ETF	67.77	67.84	67.65	67.8	2555940.0
2012-03-28 12:30:00	QQQ	ETF	67.8022	67.84	67.68	67.76	2694974.0
2012-03-28 13:00:00	QQQ	ETF	67.7699	67.84	67.59	67.69	1686504.0
2012-03-28 13:30:00	QQQ	ETF	67.69	67.72	67.6	67.705	1473746.0
2012-03-28 14:00:00	QQQ	ETF	67.705	67.72	67.54	67.63	2779070.0
2012-03-28 14:30:00	QQQ	ETF	67.629	67.87	67.62	67.855	2578471.0
2012-03-28 15:00:00	QQQ	ETF	67.86	67.95	67.82	67.89	2526082.0
2012-03-28 15:30:00	QQQ	ETF	67.89	68.0	67.81	67.93	5308177.0

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

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