PREVIEW / etf_30min / 2013-03-28

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-03-28.parquet
  size:    304 KB
  rows:    10,445

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
2013-03-28 04:00:00	SPY	ETF	155.95	156.04	155.92	156.0	1330.0
2013-03-28 04:30:00	SPY	ETF	155.98	156.01	155.68	155.68	8500.0
2013-03-28 05:00:00	SPY	ETF	155.68	155.71	155.56	155.56	21130.0
2013-03-28 05:30:00	SPY	ETF	155.58	155.85	155.58	155.85	14547.0
2013-03-28 06:00:00	SPY	ETF	155.8	156.03	155.75	155.95	35199.0
2013-03-28 06:30:00	SPY	ETF	155.95	156.26	155.95	156.26	54123.0
2013-03-28 07:00:00	SPY	ETF	156.27	156.31	156.14	156.27	85659.0
2013-03-28 07:30:00	SPY	ETF	156.28	156.3	156.21	156.21	144474.0
2013-03-28 08:00:00	SPY	ETF	156.25	156.31	156.18	156.24	1003552.0
2013-03-28 08:30:00	SPY	ETF	156.24	156.25	155.97	155.98	643258.0
2013-03-28 09:00:00	SPY	ETF	155.98	156.16	155.96	156.08	451063.0
2013-03-28 09:30:00	SPY	ETF	156.09	156.37	155.75	156.15	14662968.0
2013-03-28 10:00:00	SPY	ETF	156.15	156.35	156.07	156.24	5889534.0
2013-03-28 10:30:00	SPY	ETF	156.25	156.68	156.245	156.56	7661045.0
2013-03-28 11:00:00	SPY	ETF	156.56	156.62	156.44	156.61	5849377.0
2013-03-28 11:30:00	SPY	ETF	156.61	156.69	156.47	156.52	4642838.0
2013-03-28 12:00:00	SPY	ETF	156.525	156.55	156.24	156.28	5952378.0
2013-03-28 12:30:00	SPY	ETF	156.285	156.49	156.27	156.45	3112828.0
2013-03-28 13:00:00	SPY	ETF	156.445	156.47	156.33	156.45	2584258.0
2013-03-28 13:30:00	SPY	ETF	156.45	156.48	156.37	156.44	2249649.0
2013-03-28 14:00:00	SPY	ETF	156.44	156.59	156.44	156.569	3534709.0
2013-03-28 14:30:00	SPY	ETF	156.57	156.64	156.51	156.63	2869637.0
2013-03-28 15:00:00	SPY	ETF	156.63	156.75	156.44	156.6899	6261168.0
2013-03-28 15:30:00	SPY	ETF	156.68	156.85	156.56	156.58	20203958.0
2013-03-28 16:00:00	SPY	ETF	156.6	156.75	156.1107	156.69	7234287.0
2013-03-28 16:30:00	SPY	ETF	156.71	156.77	156.1107	156.75	5041886.0
2013-03-28 17:00:00	SPY	ETF	156.75	156.78	156.73	156.75	80645.0
2013-03-28 17:30:00	SPY	ETF	156.75	156.83	156.75	156.83	83775.0
2013-03-28 18:00:00	SPY	ETF	156.82	156.85	156.66	156.71	79442.0
2013-03-28 18:30:00	SPY	ETF	156.73	156.8	156.72	156.8	10525.0
2013-03-28 19:00:00	SPY	ETF	156.8	156.8	156.75	156.77	9700.0
2013-03-28 19:30:00	SPY	ETF	156.78	156.82	156.75	156.8	13601.0
2013-03-28 04:00:00	QQQ	ETF	68.74	68.79	68.74	68.79	2500.0
2013-03-28 05:00:00	QQQ	ETF	68.62	68.63	68.6	68.6	8100.0
2013-03-28 05:30:00	QQQ	ETF	68.7	68.7	68.7	68.7	195.0
2013-03-28 06:30:00	QQQ	ETF	68.75	68.86	68.75	68.86	9100.0
2013-03-28 07:00:00	QQQ	ETF	68.89	68.9	68.83	68.9	3457.0
2013-03-28 07:30:00	QQQ	ETF	68.9	68.93	68.88	68.88	43800.0
2013-03-28 08:00:00	QQQ	ETF	68.91	68.92	68.87	68.91	1063485.0
2013-03-28 08:30:00	QQQ	ETF	68.87	68.92	68.79	68.8	273195.0
2013-03-28 09:00:00	QQQ	ETF	68.79	68.84	68.79	68.82	125029.0
2013-03-28 09:30:00	QQQ	ETF	68.81	68.86	68.64	68.79	4638685.0
2013-03-28 10:00:00	QQQ	ETF	68.79	68.85	68.71	68.8	1271428.0
2013-03-28 10:30:00	QQQ	ETF	68.81	68.94	68.81	68.89	1790120.0
2013-03-28 11:00:00	QQQ	ETF	68.89	68.93	68.83	68.89	1024235.0
2013-03-28 11:30:00	QQQ	ETF	68.88	68.91	68.82	68.86	826007.0
2013-03-28 12:00:00	QQQ	ETF	68.85	68.87	68.75	68.77	967215.0
2013-03-28 12:30:00	QQQ	ETF	68.77	68.86	68.761	68.84	805953.0
2013-03-28 13:00:00	QQQ	ETF	68.84	68.86	68.785	68.85	292247.0
2013-03-28 13:30:00	QQQ	ETF	68.86	68.88	68.81	68.85	339377.0

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

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