PREVIEW / futures_30min / 2017-06-11

all futures 30-min files

  file:    by_date/futures_30min/2017/2017-06-11.parquet
  size:    18 KB
  rows:    492

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-11 18:00:00	ES	Futures	2654.95	2656.04	2653.86	2654.4	1945.0
2017-06-11 18:30:00	ES	Futures	2654.68	2655.22	2652.76	2653.31	1241.0
2017-06-11 19:00:00	ES	Futures	2653.58	2653.86	2651.67	2651.95	733.0
2017-06-11 19:30:00	ES	Futures	2651.95	2652.76	2651.13	2652.49	1349.0
2017-06-11 20:00:00	ES	Futures	2652.49	2654.95	2652.22	2653.86	1766.0
2017-06-11 20:30:00	ES	Futures	2653.86	2654.13	2653.04	2653.31	849.0
2017-06-11 21:00:00	ES	Futures	2653.31	2654.13	2652.76	2652.76	1175.0
2017-06-11 21:30:00	ES	Futures	2652.76	2654.68	2652.76	2654.68	950.0
2017-06-11 22:00:00	ES	Futures	2654.68	2655.22	2654.13	2654.95	1037.0
2017-06-11 22:30:00	ES	Futures	2654.68	2655.22	2652.49	2652.76	1820.0
2017-06-11 23:00:00	ES	Futures	2652.76	2652.76	2651.13	2651.4	1435.0
2017-06-11 23:30:00	ES	Futures	2651.4	2652.49	2650.85	2652.22	885.0
2017-06-11 18:00:00	NQ	Futures	6845.9	6853.05	6835.76	6836.95	801.0
2017-06-11 18:30:00	NQ	Futures	6837.25	6839.93	6832.48	6836.35	424.0
2017-06-11 19:00:00	NQ	Futures	6836.35	6837.55	6833.37	6834.27	197.0
2017-06-11 19:30:00	NQ	Futures	6833.97	6837.85	6830.99	6837.85	604.0
2017-06-11 20:00:00	NQ	Futures	6837.85	6842.02	6836.65	6839.93	452.0
2017-06-11 20:30:00	NQ	Futures	6839.93	6839.93	6834.86	6835.16	315.0
2017-06-11 21:00:00	NQ	Futures	6835.46	6838.14	6833.08	6835.76	486.0
2017-06-11 21:30:00	NQ	Futures	6835.76	6839.34	6835.16	6838.44	165.0
2017-06-11 22:00:00	NQ	Futures	6838.44	6843.81	6837.85	6841.42	237.0
2017-06-11 22:30:00	NQ	Futures	6841.72	6841.72	6833.37	6834.27	224.0
2017-06-11 23:00:00	NQ	Futures	6833.37	6833.97	6828.3	6828.6	333.0
2017-06-11 23:30:00	NQ	Futures	6828.9	6831.29	6827.41	6830.09	337.0
2017-06-11 18:00:00	YM	Futures	23088.9	23088.9	23067.1	23068.2	1397.0
2017-06-11 18:30:00	YM	Futures	23070.4	23074.7	23059.5	23064.9	593.0
2017-06-11 19:00:00	YM	Futures	23066.0	23070.4	23057.3	23057.3	544.0
2017-06-11 19:30:00	YM	Futures	23057.3	23064.9	23050.8	23064.9	445.0
2017-06-11 20:00:00	YM	Futures	23064.9	23080.2	23061.7	23071.5	862.0
2017-06-11 20:30:00	YM	Futures	23071.5	23071.5	23062.8	23064.9	375.0
2017-06-11 21:00:00	YM	Futures	23062.8	23071.5	23058.4	23062.8	326.0
2017-06-11 21:30:00	YM	Futures	23062.8	23074.7	23062.8	23074.7	451.0
2017-06-11 22:00:00	YM	Futures	23072.6	23081.3	23071.5	23076.9	539.0
2017-06-11 22:30:00	YM	Futures	23078.0	23081.3	23057.3	23058.4	840.0
2017-06-11 23:00:00	YM	Futures	23059.5	23060.6	23048.6	23048.6	373.0
2017-06-11 23:30:00	YM	Futures	23048.6	23058.4	23046.4	23058.4	595.0
2017-06-11 18:00:00	CL	Futures	41.9	41.97	41.83	41.96	1662.0
2017-06-11 18:30:00	CL	Futures	41.97	42.11	41.96	42.05	2327.0
2017-06-11 19:00:00	CL	Futures	42.05	42.07	42.02	42.06	851.0
2017-06-11 19:30:00	CL	Futures	42.06	42.16	42.02	42.15	1456.0
2017-06-11 20:00:00	CL	Futures	42.14	42.16	42.09	42.1	1777.0
2017-06-11 20:30:00	CL	Futures	42.1	42.19	42.1	42.18	1524.0
2017-06-11 21:00:00	CL	Futures	42.19	42.19	42.12	42.13	1449.0
2017-06-11 21:30:00	CL	Futures	42.12	42.15	42.1	42.14	1516.0
2017-06-11 22:00:00	CL	Futures	42.14	42.16	42.12	42.14	1204.0
2017-06-11 22:30:00	CL	Futures	42.14	42.16	42.09	42.09	962.0
2017-06-11 23:00:00	CL	Futures	42.09	42.14	42.07	42.13	1690.0
2017-06-11 23:30:00	CL	Futures	42.13	42.22	42.13	42.17	2917.0
2017-06-11 18:00:00	GC	Futures	1699.8	1700.5	1698.2	1698.8	1615.0
2017-06-11 18:30:00	GC	Futures	1698.8	1699.8	1698.5	1699.0	614.0

> showing 50 of 492 rows — these rows as CSV

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