PREVIEW / etf_30min / 2016-12-13

all etf 30-min files

  file:    by_date/etf_30min/2016/2016-12-13.parquet
  size:    447 KB
  rows:    15,132

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
2016-12-13 04:00:00	SPY	ETF	226.62	226.7	226.62	226.68	9320.0
2016-12-13 04:30:00	SPY	ETF	226.72	226.74	226.72	226.74	300.0
2016-12-13 05:00:00	SPY	ETF	226.75	226.75	226.75	226.75	200.0
2016-12-13 05:30:00	SPY	ETF	226.68	226.77	226.68	226.77	1003.0
2016-12-13 06:00:00	SPY	ETF	226.77	226.84	226.74	226.78	32811.0
2016-12-13 06:30:00	SPY	ETF	226.78	226.89	226.69	226.77	25635.0
2016-12-13 07:00:00	SPY	ETF	226.7	226.79	226.66	226.77	49324.0
2016-12-13 07:30:00	SPY	ETF	226.77	227.01	226.77	226.97	93002.0
2016-12-13 08:00:00	SPY	ETF	226.95	226.95	226.7	226.95	233669.0
2016-12-13 08:30:00	SPY	ETF	226.95	226.95	226.8	226.9	274925.0
2016-12-13 09:00:00	SPY	ETF	226.91	227.05	226.86	227.02	308604.0
2016-12-13 09:30:00	SPY	ETF	227.02	227.84	227.0	227.55	14243043.0
2016-12-13 10:00:00	SPY	ETF	227.56	227.6	227.22	227.33	10996955.0
2016-12-13 10:30:00	SPY	ETF	227.33	227.43	227.02	227.36	7687760.0
2016-12-13 11:00:00	SPY	ETF	227.36	227.63	227.21	227.5301	7874148.0
2016-12-13 11:30:00	SPY	ETF	227.535	227.7125	227.4	227.655	5056019.0
2016-12-13 12:00:00	SPY	ETF	227.655	227.95	227.64	227.71	5399289.0
2016-12-13 12:30:00	SPY	ETF	227.715	227.905	227.705	227.7838	3970557.0
2016-12-13 13:00:00	SPY	ETF	227.783	228.31	227.77	228.31	7301430.0
2016-12-13 13:30:00	SPY	ETF	228.31	228.34	227.96	228.05	4047182.0
2016-12-13 14:00:00	SPY	ETF	228.05	228.07	227.658	227.66	6263136.0
2016-12-13 14:30:00	SPY	ETF	227.6599	227.9511	227.62	227.78	4746039.0
2016-12-13 15:00:00	SPY	ETF	227.79	227.94	227.66	227.89	7706186.0
2016-12-13 15:30:00	SPY	ETF	227.89	228.06	227.61	227.71	11284504.0
2016-12-13 16:00:00	SPY	ETF	227.69	227.9232	227.64	227.83	5450741.0
2016-12-13 16:30:00	SPY	ETF	227.83	227.87	227.716	227.84	5528591.0
2016-12-13 17:00:00	SPY	ETF	227.85	227.88	227.76	227.81	155140.0
2016-12-13 17:30:00	SPY	ETF	227.81	227.83	227.76	227.83	80919.0
2016-12-13 18:00:00	SPY	ETF	227.83	227.83	227.75	227.78	83658.0
2016-12-13 18:30:00	SPY	ETF	227.77	227.8	227.76	227.76	6025.0
2016-12-13 19:00:00	SPY	ETF	227.76	227.77	227.68	227.7	35896.0
2016-12-13 19:30:00	SPY	ETF	227.72	227.74	227.68	227.68	24223.0
2016-12-13 04:00:00	QQQ	ETF	119.12	119.28	119.12	119.26	2062.0
2016-12-13 04:30:00	QQQ	ETF	119.2	119.23	119.2	119.23	2597.0
2016-12-13 05:00:00	QQQ	ETF	119.27	119.27	119.23	119.23	1297.0
2016-12-13 05:30:00	QQQ	ETF	119.24	119.29	119.24	119.27	16797.0
2016-12-13 06:00:00	QQQ	ETF	119.3	119.3	119.27	119.27	401.0
2016-12-13 06:30:00	QQQ	ETF	119.28	119.28	119.23	119.25	3472.0
2016-12-13 07:00:00	QQQ	ETF	119.21	119.25	119.2	119.25	5398.0
2016-12-13 07:30:00	QQQ	ETF	119.27	119.35	119.27	119.33	16127.0
2016-12-13 08:00:00	QQQ	ETF	119.34	119.35	119.21	119.32	11561.0
2016-12-13 08:30:00	QQQ	ETF	119.36	119.36	119.28	119.33	118558.0
2016-12-13 09:00:00	QQQ	ETF	119.32	119.36	119.26	119.33	45451.0
2016-12-13 09:30:00	QQQ	ETF	119.35	120.6	119.32	120.44	6517270.0
2016-12-13 10:00:00	QQQ	ETF	120.45	120.78	120.21	120.75	3907800.0
2016-12-13 10:30:00	QQQ	ETF	120.75	120.83	120.53	120.7148	3748266.0
2016-12-13 11:00:00	QQQ	ETF	120.72	120.9	120.61	120.88	3623854.0
2016-12-13 11:30:00	QQQ	ETF	120.87	121.07	120.84	121.019	2496546.0
2016-12-13 12:00:00	QQQ	ETF	121.015	121.11	120.8049	120.82	1829057.0
2016-12-13 12:30:00	QQQ	ETF	120.82	120.9	120.75	120.755	1771843.0

> showing 50 of 15,132 rows — these rows as CSV

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