PREVIEW / futures_30min / 2017-06-26

all futures 30-min files

  file:    by_date/futures_30min/2017/2017-06-26.parquet
  size:    77 KB
  rows:    2,993

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
2017-06-26 00:00:00	ES	Futures	2663.69	2664.24	2663.42	2663.69	507.0
2017-06-26 00:30:00	ES	Futures	2663.69	2663.69	2662.87	2663.14	749.0
2017-06-26 01:00:00	ES	Futures	2663.14	2663.42	2662.6	2662.6	638.0
2017-06-26 01:30:00	ES	Futures	2662.6	2664.51	2662.6	2663.96	2018.0
2017-06-26 02:00:00	ES	Futures	2663.69	2665.6	2663.69	2665.06	4534.0
2017-06-26 02:30:00	ES	Futures	2665.06	2665.6	2664.51	2665.33	4084.0
2017-06-26 03:00:00	ES	Futures	2665.06	2669.16	2665.06	2668.06	19030.0
2017-06-26 03:30:00	ES	Futures	2668.06	2668.88	2667.24	2667.52	5710.0
2017-06-26 04:00:00	ES	Futures	2667.52	2668.34	2666.7	2667.79	7558.0
2017-06-26 04:30:00	ES	Futures	2668.06	2669.16	2668.06	2668.34	5912.0
2017-06-26 05:00:00	ES	Futures	2668.34	2668.88	2667.24	2667.52	5472.0
2017-06-26 05:30:00	ES	Futures	2667.52	2668.34	2667.24	2668.06	3158.0
2017-06-26 06:00:00	ES	Futures	2668.06	2668.88	2667.79	2667.79	2925.0
2017-06-26 06:30:00	ES	Futures	2668.06	2668.61	2667.79	2668.61	3277.0
2017-06-26 07:00:00	ES	Futures	2668.34	2669.7	2668.34	2668.88	4965.0
2017-06-26 07:30:00	ES	Futures	2668.88	2669.7	2668.61	2669.43	6710.0
2017-06-26 08:00:00	ES	Futures	2669.43	2670.52	2669.43	2669.98	8578.0
2017-06-26 08:30:00	ES	Futures	2670.25	2670.25	2668.88	2669.43	11168.0
2017-06-26 09:00:00	ES	Futures	2669.7	2670.8	2668.88	2670.52	13354.0
2017-06-26 09:30:00	ES	Futures	2670.25	2675.99	2669.98	2675.44	166668.0
2017-06-26 10:00:00	ES	Futures	2675.72	2675.72	2671.62	2673.8	106543.0
2017-06-26 10:30:00	ES	Futures	2673.8	2673.8	2663.14	2665.6	193437.0
2017-06-26 11:00:00	ES	Futures	2665.88	2666.15	2661.23	2665.33	142129.0
2017-06-26 11:30:00	ES	Futures	2665.33	2668.34	2662.6	2667.79	73006.0
2017-06-26 12:00:00	ES	Futures	2668.06	2668.61	2665.88	2666.15	36959.0
2017-06-26 12:30:00	ES	Futures	2666.15	2669.43	2665.88	2668.34	31606.0
2017-06-26 13:00:00	ES	Futures	2668.61	2668.88	2666.15	2667.24	32737.0
2017-06-26 13:30:00	ES	Futures	2667.24	2667.79	2665.88	2666.7	20775.0
2017-06-26 14:00:00	ES	Futures	2666.97	2667.52	2664.78	2666.42	36479.0
2017-06-26 14:30:00	ES	Futures	2666.42	2667.79	2665.33	2667.24	36893.0
2017-06-26 15:00:00	ES	Futures	2667.52	2668.34	2665.06	2666.42	44002.0
2017-06-26 15:30:00	ES	Futures	2666.42	2667.24	2662.6	2663.69	139460.0
2017-06-26 16:00:00	ES	Futures	2663.69	2663.96	2662.32	2663.14	52469.0
2017-06-26 16:30:00	ES	Futures	2663.14	2663.96	2662.87	2663.14	4711.0
2017-06-26 18:00:00	ES	Futures	2663.14	2663.14	2661.5	2662.87	2839.0
2017-06-26 18:30:00	ES	Futures	2663.14	2664.78	2662.87	2663.69	1317.0
2017-06-26 19:00:00	ES	Futures	2663.69	2664.51	2663.42	2663.96	744.0
2017-06-26 19:30:00	ES	Futures	2663.96	2664.78	2663.69	2663.69	1036.0
2017-06-26 20:00:00	ES	Futures	2663.96	2664.51	2662.87	2663.96	2665.0
2017-06-26 20:30:00	ES	Futures	2663.69	2664.24	2662.32	2663.14	1804.0
2017-06-26 21:00:00	ES	Futures	2662.87	2663.96	2662.6	2663.96	1440.0
2017-06-26 21:30:00	ES	Futures	2663.69	2664.24	2663.14	2663.69	1513.0
2017-06-26 22:00:00	ES	Futures	2663.69	2664.51	2663.42	2664.51	1496.0
2017-06-26 22:30:00	ES	Futures	2664.51	2664.78	2663.69	2663.69	969.0
2017-06-26 23:00:00	ES	Futures	2663.69	2664.24	2662.87	2663.69	1581.0
2017-06-26 23:30:00	ES	Futures	2663.69	2664.24	2663.69	2664.24	740.0
2017-06-26 00:00:00	NQ	Futures	6928.08	6929.56	6928.08	6928.37	143.0
2017-06-26 00:30:00	NQ	Futures	6928.37	6929.27	6926.88	6928.08	210.0
2017-06-26 01:00:00	NQ	Futures	6928.37	6928.97	6926.88	6927.18	148.0
2017-06-26 01:30:00	NQ	Futures	6927.18	6933.73	6927.18	6932.24	671.0

> showing 50 of 2,993 rows — these rows as CSV

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