PREVIEW / futures_30min / 2014-07-27

all futures 30-min files

  file:    by_date/futures_30min/2014/2014-07-27.parquet
  size:    18 KB
  rows:    489

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
2014-07-27 18:00:00	ES	Futures	2054.42	2056.24	2052.07	2052.34	4760.0
2014-07-27 18:30:00	ES	Futures	2052.07	2053.38	2050.77	2051.29	3605.0
2014-07-27 19:00:00	ES	Futures	2051.29	2052.34	2049.99	2051.81	1902.0
2014-07-27 19:30:00	ES	Futures	2052.07	2052.34	2051.29	2051.55	1122.0
2014-07-27 20:00:00	ES	Futures	2051.81	2052.6	2051.81	2052.6	1122.0
2014-07-27 20:30:00	ES	Futures	2052.34	2053.38	2051.55	2051.55	2922.0
2014-07-27 21:00:00	ES	Futures	2051.81	2052.6	2051.55	2052.6	1482.0
2014-07-27 21:30:00	ES	Futures	2052.34	2053.64	2052.07	2053.38	3343.0
2014-07-27 22:00:00	ES	Futures	2053.12	2053.64	2052.86	2053.12	1727.0
2014-07-27 22:30:00	ES	Futures	2053.12	2053.64	2052.86	2053.12	1037.0
2014-07-27 23:00:00	ES	Futures	2053.12	2053.64	2053.12	2053.38	1001.0
2014-07-27 23:30:00	ES	Futures	2053.38	2053.38	2052.07	2052.34	931.0
2014-07-27 18:00:00	NQ	Futures	4618.5	4624.64	4613.25	4614.42	410.0
2014-07-27 18:30:00	NQ	Futures	4614.42	4615.88	4611.5	4612.08	553.0
2014-07-27 19:00:00	NQ	Futures	4612.08	4613.83	4609.74	4613.25	190.0
2014-07-27 19:30:00	NQ	Futures	4612.96	4614.42	4612.66	4613.25	127.0
2014-07-27 20:00:00	NQ	Futures	4613.25	4615.0	4613.25	4614.71	140.0
2014-07-27 20:30:00	NQ	Futures	4615.0	4617.92	4614.42	4614.42	500.0
2014-07-27 21:00:00	NQ	Futures	4614.42	4617.04	4614.42	4616.75	250.0
2014-07-27 21:30:00	NQ	Futures	4616.46	4619.09	4615.88	4617.92	432.0
2014-07-27 22:00:00	NQ	Futures	4618.21	4619.38	4617.92	4618.8	242.0
2014-07-27 22:30:00	NQ	Futures	4618.8	4620.26	4618.5	4618.5	169.0
2014-07-27 23:00:00	NQ	Futures	4618.5	4619.67	4618.5	4619.09	116.0
2014-07-27 23:30:00	NQ	Futures	4618.8	4618.8	4616.17	4616.75	180.0
2014-07-27 18:00:00	YM	Futures	17475.9	17481.1	17449.0	17450.0	565.0
2014-07-27 18:30:00	YM	Futures	17451.1	17456.3	17440.7	17440.7	335.0
2014-07-27 19:00:00	YM	Futures	17442.8	17450.0	17433.5	17446.9	178.0
2014-07-27 19:30:00	YM	Futures	17445.9	17448.0	17442.8	17446.9	86.0
2014-07-27 20:00:00	YM	Futures	17445.9	17453.2	17445.9	17451.1	202.0
2014-07-27 20:30:00	YM	Futures	17451.1	17459.4	17445.9	17445.9	524.0
2014-07-27 21:00:00	YM	Futures	17446.9	17453.2	17446.9	17453.2	212.0
2014-07-27 21:30:00	YM	Futures	17453.2	17462.5	17450.0	17461.4	649.0
2014-07-27 22:00:00	YM	Futures	17461.4	17465.6	17459.4	17461.4	328.0
2014-07-27 22:30:00	YM	Futures	17461.4	17464.5	17458.3	17460.4	204.0
2014-07-27 23:00:00	YM	Futures	17460.4	17461.4	17459.4	17461.4	117.0
2014-07-27 23:30:00	YM	Futures	17460.4	17460.4	17453.2	17454.2	119.0
2014-07-27 18:00:00	CL	Futures	166.49	166.74	166.29	166.33	593.0
2014-07-27 18:30:00	CL	Futures	166.33	166.38	166.29	166.33	227.0
2014-07-27 19:00:00	CL	Futures	166.33	166.34	166.25	166.29	186.0
2014-07-27 19:30:00	CL	Futures	166.29	166.31	166.18	166.26	200.0
2014-07-27 20:00:00	CL	Futures	166.26	166.28	166.18	166.21	208.0
2014-07-27 20:30:00	CL	Futures	166.21	166.23	166.16	166.18	160.0
2014-07-27 21:00:00	CL	Futures	166.18	166.23	166.15	166.2	123.0
2014-07-27 21:30:00	CL	Futures	166.2	166.2	165.89	165.9	1043.0
2014-07-27 22:00:00	CL	Futures	165.9	166.07	165.89	165.95	288.0
2014-07-27 22:30:00	CL	Futures	165.95	166.16	165.9	166.07	446.0
2014-07-27 23:00:00	CL	Futures	166.05	166.12	165.95	165.98	595.0
2014-07-27 23:30:00	CL	Futures	165.98	166.03	165.89	165.92	245.0
2014-07-27 18:00:00	GC	Futures	1792.2	1793.5	1788.7	1791.0	198.0
2014-07-27 18:30:00	GC	Futures	1791.3	1792.8	1791.0	1792.8	24.0

> showing 50 of 489 rows — these rows as CSV

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