PREVIEW / futures_30min / 2011-07-17

all futures 30-min files

  file:    by_date/futures_30min/2011/2011-07-17.parquet
  size:    20 KB
  rows:    502

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-17 18:00:00	ES	Futures	1311.37	1311.62	1308.13	1309.63	10831.0
2011-07-17 18:30:00	ES	Futures	1309.63	1310.38	1309.38	1309.88	1228.0
2011-07-17 19:00:00	ES	Futures	1309.88	1310.13	1307.88	1308.38	2112.0
2011-07-17 19:30:00	ES	Futures	1308.38	1309.13	1307.88	1308.38	1912.0
2011-07-17 20:00:00	ES	Futures	1308.63	1308.63	1304.39	1305.39	9433.0
2011-07-17 20:30:00	ES	Futures	1305.14	1305.39	1301.9	1303.39	12819.0
2011-07-17 21:00:00	ES	Futures	1303.14	1303.39	1301.4	1302.89	7891.0
2011-07-17 21:30:00	ES	Futures	1302.65	1304.64	1302.65	1303.39	3833.0
2011-07-17 22:00:00	ES	Futures	1303.39	1305.39	1303.14	1303.89	2692.0
2011-07-17 22:30:00	ES	Futures	1303.89	1306.64	1303.64	1305.89	5088.0
2011-07-17 23:00:00	ES	Futures	1305.89	1306.39	1305.39	1305.89	1320.0
2011-07-17 23:30:00	ES	Futures	1305.64	1305.89	1304.64	1304.89	1233.0
2011-07-17 18:00:00	NQ	Futures	2710.17	2710.75	2705.28	2707.58	983.0
2011-07-17 18:30:00	NQ	Futures	2707.87	2708.73	2707.3	2708.16	80.0
2011-07-17 19:00:00	NQ	Futures	2708.16	2709.02	2704.71	2705.57	114.0
2011-07-17 19:30:00	NQ	Futures	2705.28	2707.3	2704.42	2705.86	143.0
2011-07-17 20:00:00	NQ	Futures	2706.43	2706.43	2697.51	2698.95	879.0
2011-07-17 20:30:00	NQ	Futures	2698.95	2698.95	2691.76	2694.92	753.0
2011-07-17 21:00:00	NQ	Futures	2694.92	2696.07	2690.03	2693.77	747.0
2011-07-17 21:30:00	NQ	Futures	2694.63	2697.8	2694.35	2695.21	358.0
2011-07-17 22:00:00	NQ	Futures	2695.5	2698.95	2694.63	2696.07	178.0
2011-07-17 22:30:00	NQ	Futures	2695.79	2702.69	2695.79	2699.53	453.0
2011-07-17 23:00:00	NQ	Futures	2699.53	2700.68	2698.66	2699.81	291.0
2011-07-17 23:30:00	NQ	Futures	2699.24	2700.39	2697.51	2697.51	99.0
2011-07-17 18:00:00	YM	Futures	12059.5	12059.5	12028.5	12040.1	294.0
2011-07-17 18:30:00	YM	Futures	12045.0	12045.0	12039.1	12043.0	29.0
2011-07-17 19:00:00	YM	Futures	12041.1	12043.0	12024.6	12029.5	72.0
2011-07-17 19:30:00	YM	Futures	12028.5	12033.3	12026.6	12030.4	34.0
2011-07-17 20:00:00	YM	Futures	12030.4	12030.4	11999.4	12002.3	406.0
2011-07-17 20:30:00	YM	Futures	12002.3	12003.3	11974.3	11983.0	399.0
2011-07-17 21:00:00	YM	Futures	11981.0	11986.8	11961.7	11979.1	503.0
2011-07-17 21:30:00	YM	Futures	11978.1	11993.6	11978.1	11983.9	258.0
2011-07-17 22:00:00	YM	Futures	11983.9	12002.3	11982.0	11996.5	341.0
2011-07-17 22:30:00	YM	Futures	11994.6	12015.9	11993.6	12005.2	381.0
2011-07-17 23:00:00	YM	Futures	12005.2	12010.1	12003.3	12006.2	67.0
2011-07-17 23:30:00	YM	Futures	12005.2	12007.2	11996.5	11997.5	35.0
2011-07-17 18:00:00	CL	Futures	166.92	167.12	166.61	167.1	351.0
2011-07-17 18:30:00	CL	Futures	167.14	167.29	167.02	167.07	255.0
2011-07-17 19:00:00	CL	Futures	167.07	167.17	167.02	167.17	78.0
2011-07-17 19:30:00	CL	Futures	167.14	167.17	166.95	167.09	132.0
2011-07-17 20:00:00	CL	Futures	166.98	167.04	166.85	166.93	273.0
2011-07-17 20:30:00	CL	Futures	166.93	166.95	166.39	166.56	644.0
2011-07-17 21:00:00	CL	Futures	166.56	166.59	166.17	166.52	370.0
2011-07-17 21:30:00	CL	Futures	166.49	166.54	166.1	166.13	276.0
2011-07-17 22:00:00	CL	Futures	166.13	166.63	166.06	166.29	284.0
2011-07-17 22:30:00	CL	Futures	166.3	166.47	166.29	166.46	176.0
2011-07-17 23:00:00	CL	Futures	166.46	166.56	166.35	166.37	61.0
2011-07-17 23:30:00	CL	Futures	166.37	166.37	166.1	166.11	63.0
2011-07-17 18:00:00	GC	Futures	2223.7	2229.8	2223.5	2229.7	3472.0
2011-07-17 18:30:00	GC	Futures	2229.8	2230.5	2226.9	2227.6	1138.0

> showing 50 of 502 rows — these rows as CSV

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