PREVIEW / etf_30min / 2016-04-01

all etf 30-min files

  file:    by_date/etf_30min/2016/2016-04-01.parquet
  size:    400 KB
  rows:    13,363

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-04-01 04:00:00	SPY	ETF	205.04	205.07	204.75	204.97	13492.0
2016-04-01 04:30:00	SPY	ETF	204.98	205.37	204.95	205.17	12040.0
2016-04-01 05:00:00	SPY	ETF	205.27	205.35	205.18	205.19	17344.0
2016-04-01 05:30:00	SPY	ETF	205.17	205.19	204.82	204.91	57098.0
2016-04-01 06:00:00	SPY	ETF	204.89	205.08	204.83	204.98	32623.0
2016-04-01 06:30:00	SPY	ETF	204.92	204.97	204.57	204.8	41054.0
2016-04-01 07:00:00	SPY	ETF	204.84	204.97	204.7	204.82	114952.0
2016-04-01 07:30:00	SPY	ETF	204.84	204.84	204.61	204.75	295152.0
2016-04-01 08:00:00	SPY	ETF	204.75	204.91	204.51	204.84	603462.0
2016-04-01 08:30:00	SPY	ETF	204.75	205.56	204.29	204.4	1437804.0
2016-04-01 09:00:00	SPY	ETF	204.38	204.4	204.14	204.32	869074.0
2016-04-01 09:30:00	SPY	ETF	204.35	204.55	203.98	204.53	10535966.0
2016-04-01 10:00:00	SPY	ETF	204.53	205.38	204.43	205.17	11702219.0
2016-04-01 10:30:00	SPY	ETF	205.16	205.87	205.09	205.8508	7253057.0
2016-04-01 11:00:00	SPY	ETF	205.85	205.99	205.71	205.77	5365120.0
2016-04-01 11:30:00	SPY	ETF	205.77	206.16	205.68	205.81	5058840.0
2016-04-01 12:00:00	SPY	ETF	205.8162	205.94	205.5	205.645	3647405.0
2016-04-01 12:30:00	SPY	ETF	205.65	205.92	205.56	205.8	2928691.0
2016-04-01 13:00:00	SPY	ETF	205.809	206.28	205.75	206.205	4467832.0
2016-04-01 13:30:00	SPY	ETF	206.21	206.48	206.15	206.32	4109203.0
2016-04-01 14:00:00	SPY	ETF	206.32	206.54	206.24	206.31	4090461.0
2016-04-01 14:30:00	SPY	ETF	206.31	206.71	206.28	206.56	4927545.0
2016-04-01 15:00:00	SPY	ETF	206.56	206.78	206.54	206.69	6754174.0
2016-04-01 15:30:00	SPY	ETF	206.69	207.14	206.68	206.89	19289389.0
2016-04-01 16:00:00	SPY	ETF	206.88	207.0	206.4502	206.94	12885554.0
2016-04-01 16:30:00	SPY	ETF	206.95	206.95	206.85	206.87	434849.0
2016-04-01 17:00:00	SPY	ETF	206.87	206.88	206.81	206.82	108401.0
2016-04-01 17:30:00	SPY	ETF	206.82	206.82	206.75	206.8	1107234.0
2016-04-01 18:00:00	SPY	ETF	206.81	206.86	206.78	206.82	17859.0
2016-04-01 18:30:00	SPY	ETF	206.84	206.86	206.79	206.86	14091.0
2016-04-01 19:00:00	SPY	ETF	206.85	206.86	206.85	206.86	2230.0
2016-04-01 19:30:00	SPY	ETF	206.84	206.86	206.83	206.86	33029.0
2016-04-01 04:00:00	QQQ	ETF	108.81	108.81	108.7	108.7	10392.0
2016-04-01 04:30:00	QQQ	ETF	108.87	108.9	108.87	108.9	300.0
2016-04-01 05:30:00	QQQ	ETF	108.83	108.83	108.76	108.76	300.0
2016-04-01 06:00:00	QQQ	ETF	108.78	108.8	108.78	108.8	900.0
2016-04-01 06:30:00	QQQ	ETF	108.8	108.8	108.66	108.71	4255.0
2016-04-01 07:00:00	QQQ	ETF	108.69	108.81	108.68	108.78	12116.0
2016-04-01 07:30:00	QQQ	ETF	108.78	108.78	108.67	108.74	14950.0
2016-04-01 08:00:00	QQQ	ETF	108.78	108.84	108.68	108.8	67486.0
2016-04-01 08:30:00	QQQ	ETF	108.76	108.94	108.48	108.54	124149.0
2016-04-01 09:00:00	QQQ	ETF	108.5	108.59	108.4	108.59	133559.0
2016-04-01 09:30:00	QQQ	ETF	108.58	108.9	108.39	108.87	3601475.0
2016-04-01 10:00:00	QQQ	ETF	108.87	109.4	108.82	109.19	2344764.0
2016-04-01 10:30:00	QQQ	ETF	109.19	109.72	109.13	109.71	1897942.0
2016-04-01 11:00:00	QQQ	ETF	109.7	109.83	109.64	109.76	1747947.0
2016-04-01 11:30:00	QQQ	ETF	109.76	109.96	109.68	109.74	1511931.0
2016-04-01 12:00:00	QQQ	ETF	109.75	109.82	109.57	109.61	943145.0
2016-04-01 12:30:00	QQQ	ETF	109.611	109.83	109.53	109.7779	761660.0
2016-04-01 13:00:00	QQQ	ETF	109.77	109.99	109.75	109.935	923506.0

> showing 50 of 13,363 rows — these rows as CSV

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