PREVIEW / futures_30min / 2011-07-31

all futures 30-min files

  file:    by_date/futures_30min/2011/2011-07-31.parquet
  size:    21 KB
  rows:    500

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
2011-07-31 18:00:00	ES	Futures	1302.89	1305.64	1299.9	1301.15	31821.0
2011-07-31 18:30:00	ES	Futures	1301.15	1302.65	1298.65	1301.9	13759.0
2011-07-31 19:00:00	ES	Futures	1302.15	1304.39	1301.9	1303.64	7358.0
2011-07-31 19:30:00	ES	Futures	1303.39	1303.89	1300.9	1301.65	7207.0
2011-07-31 20:00:00	ES	Futures	1301.9	1303.64	1301.65	1302.89	5861.0
2011-07-31 20:30:00	ES	Futures	1302.89	1306.39	1302.65	1305.14	21290.0
2011-07-31 21:00:00	ES	Futures	1304.89	1306.14	1303.89	1304.14	6863.0
2011-07-31 21:30:00	ES	Futures	1304.39	1305.89	1304.14	1305.14	3862.0
2011-07-31 22:00:00	ES	Futures	1305.14	1305.39	1303.14	1303.64	4175.0
2011-07-31 22:30:00	ES	Futures	1303.89	1304.14	1303.39	1303.64	5366.0
2011-07-31 23:00:00	ES	Futures	1303.64	1304.89	1303.39	1304.14	2553.0
2011-07-31 23:30:00	ES	Futures	1304.14	1305.39	1304.14	1305.14	2620.0
2011-07-31 18:00:00	NQ	Futures	2746.43	2755.06	2742.98	2748.73	2159.0
2011-07-31 18:30:00	NQ	Futures	2749.6	2750.75	2742.4	2749.6	442.0
2011-07-31 19:00:00	NQ	Futures	2749.31	2752.76	2749.02	2751.32	158.0
2011-07-31 19:30:00	NQ	Futures	2751.61	2751.61	2745.28	2745.86	276.0
2011-07-31 20:00:00	NQ	Futures	2746.72	2751.04	2746.72	2747.87	525.0
2011-07-31 20:30:00	NQ	Futures	2748.73	2754.2	2746.43	2752.47	696.0
2011-07-31 21:00:00	NQ	Futures	2752.19	2755.64	2751.9	2753.34	486.0
2011-07-31 21:30:00	NQ	Futures	2753.63	2753.91	2750.46	2751.04	521.0
2011-07-31 22:00:00	NQ	Futures	2750.75	2751.61	2747.3	2747.87	448.0
2011-07-31 22:30:00	NQ	Futures	2748.16	2749.02	2747.87	2748.45	97.0
2011-07-31 23:00:00	NQ	Futures	2748.45	2751.04	2748.16	2749.6	74.0
2011-07-31 23:30:00	NQ	Futures	2749.89	2752.19	2749.89	2751.61	103.0
2011-07-31 18:00:00	YM	Futures	11853.2	11874.5	11834.8	11847.4	1994.0
2011-07-31 18:30:00	YM	Futures	11844.5	11859.0	11825.1	11856.1	1043.0
2011-07-31 19:00:00	YM	Futures	11854.2	11872.6	11853.2	11865.8	418.0
2011-07-31 19:30:00	YM	Futures	11866.8	11867.7	11843.5	11848.4	726.0
2011-07-31 20:00:00	YM	Futures	11850.3	11864.8	11850.3	11859.0	340.0
2011-07-31 20:30:00	YM	Futures	11860.0	11891.9	11858.1	11877.4	1153.0
2011-07-31 21:00:00	YM	Futures	11878.4	11887.1	11871.6	11873.5	314.0
2011-07-31 21:30:00	YM	Futures	11873.5	11882.3	11868.7	11879.4	342.0
2011-07-31 22:00:00	YM	Futures	11880.3	11887.1	11856.1	11872.6	1158.0
2011-07-31 22:30:00	YM	Futures	11872.6	11882.3	11857.1	11874.5	556.0
2011-07-31 23:00:00	YM	Futures	11873.5	11880.3	11868.7	11875.5	159.0
2011-07-31 23:30:00	YM	Futures	11876.5	11881.3	11876.5	11881.3	77.0
2011-07-31 18:00:00	CL	Futures	164.14	165.67	164.1	164.99	2663.0
2011-07-31 18:30:00	CL	Futures	164.97	165.4	164.9	165.12	1027.0
2011-07-31 19:00:00	CL	Futures	165.11	165.33	165.09	165.3	351.0
2011-07-31 19:30:00	CL	Futures	165.3	165.53	165.26	165.48	532.0
2011-07-31 20:00:00	CL	Futures	165.47	165.52	165.26	165.33	332.0
2011-07-31 20:30:00	CL	Futures	165.35	165.89	165.35	165.65	1133.0
2011-07-31 21:00:00	CL	Futures	165.67	165.93	165.62	165.71	502.0
2011-07-31 21:30:00	CL	Futures	165.67	166.0	165.59	165.84	541.0
2011-07-31 22:00:00	CL	Futures	165.84	165.91	165.3	165.48	569.0
2011-07-31 22:30:00	CL	Futures	165.48	165.55	165.38	165.48	132.0
2011-07-31 23:00:00	CL	Futures	165.48	165.64	165.28	165.55	344.0
2011-07-31 23:30:00	CL	Futures	165.57	165.59	165.4	165.4	169.0
2011-07-31 18:00:00	GC	Futures	2259.1	2259.5	2239.6	2247.0	6008.0
2011-07-31 18:30:00	GC	Futures	2247.2	2253.9	2247.0	2252.5	1168.0

> showing 50 of 500 rows — these rows as CSV

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