PREVIEW / etf_30min / 2016-05-18

all etf 30-min files

  file:    by_date/etf_30min/2016/2016-05-18.parquet
  size:    402 KB
  rows:    13,730

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-05-18 04:00:00	SPY	ETF	204.87	204.94	204.69	204.88	18803.0
2016-05-18 04:30:00	SPY	ETF	204.81	205.01	204.81	205.01	7627.0
2016-05-18 05:00:00	SPY	ETF	204.98	205.01	204.83	204.83	2966.0
2016-05-18 05:30:00	SPY	ETF	204.86	204.93	204.86	204.9	6810.0
2016-05-18 06:00:00	SPY	ETF	205.01	205.08	204.83	204.83	16767.0
2016-05-18 06:30:00	SPY	ETF	204.75	204.77	204.68	204.69	15515.0
2016-05-18 07:00:00	SPY	ETF	204.76	205.0	204.76	205.0	58330.0
2016-05-18 07:30:00	SPY	ETF	204.99	205.0	204.57	204.58	257842.0
2016-05-18 08:00:00	SPY	ETF	204.61	205.103	204.41	204.41	568239.0
2016-05-18 08:30:00	SPY	ETF	204.44	204.47	204.15	204.33	576534.0
2016-05-18 09:00:00	SPY	ETF	204.32	204.48	204.07	204.45	833963.0
2016-05-18 09:30:00	SPY	ETF	204.44	204.84	204.16	204.84	9411042.0
2016-05-18 10:00:00	SPY	ETF	204.84	205.71	204.69	205.65	9132248.0
2016-05-18 10:30:00	SPY	ETF	205.64	205.64	204.98	205.0	6495565.0
2016-05-18 11:00:00	SPY	ETF	205.01	205.5699	205.0	205.53	4983595.0
2016-05-18 11:30:00	SPY	ETF	205.525	205.76	205.28	205.34	6722199.0
2016-05-18 12:00:00	SPY	ETF	205.34	205.52	205.22	205.28	3007516.0
2016-05-18 12:30:00	SPY	ETF	205.28	205.8	205.28	205.7957	2442070.0
2016-05-18 13:00:00	SPY	ETF	205.8	206.22	205.7992	206.1	4905844.0
2016-05-18 13:30:00	SPY	ETF	206.11	206.3	205.9	205.9	4557657.0
2016-05-18 14:00:00	SPY	ETF	205.92	205.92	203.86	203.96	23147557.0
2016-05-18 14:30:00	SPY	ETF	203.95	204.88	203.63	204.68	15863331.0
2016-05-18 15:00:00	SPY	ETF	204.69	205.14	204.07	204.09	10002832.0
2016-05-18 15:30:00	SPY	ETF	204.09	204.98	204.04	204.96	14155247.0
2016-05-18 16:00:00	SPY	ETF	204.96	204.96	204.69	204.77	3133548.0
2016-05-18 16:30:00	SPY	ETF	204.77	204.92	204.77	204.86	896356.0
2016-05-18 17:00:00	SPY	ETF	204.86	204.94	204.86	204.9	103953.0
2016-05-18 17:30:00	SPY	ETF	204.9	204.94	204.89	204.9	548446.0
2016-05-18 18:00:00	SPY	ETF	204.9	205.0	204.76	204.77	149743.0
2016-05-18 18:30:00	SPY	ETF	204.75	204.78	204.68	204.78	33665.0
2016-05-18 19:00:00	SPY	ETF	204.77	204.88	204.77	204.83	33284.0
2016-05-18 19:30:00	SPY	ETF	204.82	204.9	204.75	204.89	37459.0
2016-05-18 04:00:00	QQQ	ETF	105.51	105.51	105.44	105.44	200.0
2016-05-18 04:30:00	QQQ	ETF	105.41	105.44	105.41	105.44	3500.0
2016-05-18 06:00:00	QQQ	ETF	105.53	105.53	105.51	105.51	500.0
2016-05-18 06:30:00	QQQ	ETF	105.4	105.4	105.39	105.39	699.0
2016-05-18 07:00:00	QQQ	ETF	105.49	105.5	105.42	105.48	6200.0
2016-05-18 07:30:00	QQQ	ETF	105.48	105.48	105.32	105.32	11846.0
2016-05-18 08:00:00	QQQ	ETF	105.35	105.36	105.3	105.32	34141.0
2016-05-18 08:30:00	QQQ	ETF	105.29	105.29	105.15	105.26	62263.0
2016-05-18 09:00:00	QQQ	ETF	105.23	105.32	105.1	105.3	82559.0
2016-05-18 09:30:00	QQQ	ETF	105.29	105.73	105.24	105.71	2905274.0
2016-05-18 10:00:00	QQQ	ETF	105.7	106.23	105.65	106.2095	1840504.0
2016-05-18 10:30:00	QQQ	ETF	106.2	106.2	105.85	105.86	1296899.0
2016-05-18 11:00:00	QQQ	ETF	105.87	106.15	105.86	106.11	2616823.0
2016-05-18 11:30:00	QQQ	ETF	106.11	106.2765	106.0	106.0399	1892567.0
2016-05-18 12:00:00	QQQ	ETF	106.04	106.06	105.873	105.88	738654.0
2016-05-18 12:30:00	QQQ	ETF	105.88	106.17	105.88	106.168	825076.0
2016-05-18 13:00:00	QQQ	ETF	106.17	106.41	106.17	106.34	1236805.0
2016-05-18 13:30:00	QQQ	ETF	106.35	106.43	106.23	106.24	926096.0

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

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