PREVIEW / futures_30min / 2011-09-18

all futures 30-min files

  file:    by_date/futures_30min/2011/2011-09-18.parquet
  size:    19 KB
  rows:    475

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-09-18 18:00:00	ES	Futures	1202.89	1203.14	1198.12	1199.38	17439.0
2011-09-18 18:30:00	ES	Futures	1199.38	1202.38	1199.12	1200.38	5672.0
2011-09-18 19:00:00	ES	Futures	1200.38	1200.88	1198.62	1199.38	4456.0
2011-09-18 19:30:00	ES	Futures	1199.38	1201.13	1198.62	1199.88	3422.0
2011-09-18 20:00:00	ES	Futures	1199.88	1201.63	1199.12	1200.13	6356.0
2011-09-18 20:30:00	ES	Futures	1200.13	1200.63	1198.87	1198.87	3821.0
2011-09-18 21:00:00	ES	Futures	1198.87	1200.13	1197.87	1198.87	5195.0
2011-09-18 21:30:00	ES	Futures	1198.87	1199.63	1195.87	1197.12	9018.0
2011-09-18 22:00:00	ES	Futures	1196.87	1197.12	1194.86	1195.61	6831.0
2011-09-18 22:30:00	ES	Futures	1195.61	1197.12	1195.36	1195.61	5957.0
2011-09-18 23:00:00	ES	Futures	1195.36	1197.62	1195.36	1196.12	3081.0
2011-09-18 23:30:00	ES	Futures	1196.12	1197.62	1195.61	1197.12	2192.0
2011-09-18 18:00:00	NQ	Futures	2638.73	2638.73	2624.89	2628.64	2053.0
2011-09-18 18:30:00	NQ	Futures	2629.79	2633.83	2629.21	2630.94	403.0
2011-09-18 19:00:00	NQ	Futures	2631.23	2631.81	2628.06	2629.5	341.0
2011-09-18 19:30:00	NQ	Futures	2629.5	2633.25	2628.35	2630.08	246.0
2011-09-18 20:00:00	NQ	Futures	2629.79	2633.83	2628.92	2630.94	549.0
2011-09-18 20:30:00	NQ	Futures	2630.94	2631.81	2628.92	2628.92	230.0
2011-09-18 21:00:00	NQ	Futures	2629.21	2630.37	2627.19	2628.64	528.0
2011-09-18 21:30:00	NQ	Futures	2628.92	2629.79	2622.58	2625.46	572.0
2011-09-18 22:00:00	NQ	Futures	2625.18	2625.18	2621.14	2622.0	522.0
2011-09-18 22:30:00	NQ	Futures	2622.0	2625.46	2622.0	2622.29	371.0
2011-09-18 23:00:00	NQ	Futures	2622.58	2626.33	2622.58	2622.58	157.0
2011-09-18 23:30:00	NQ	Futures	2624.89	2626.33	2622.0	2625.18	303.0
2011-09-18 18:00:00	YM	Futures	11175.7	11175.7	11127.5	11138.3	609.0
2011-09-18 18:30:00	YM	Futures	11138.3	11162.9	11138.3	11147.2	180.0
2011-09-18 19:00:00	YM	Futures	11148.2	11148.2	11133.4	11140.3	126.0
2011-09-18 19:30:00	YM	Futures	11138.3	11159.0	11137.3	11143.3	360.0
2011-09-18 20:00:00	YM	Futures	11149.2	11161.0	11144.2	11150.1	377.0
2011-09-18 20:30:00	YM	Futures	11149.2	11151.1	11140.3	11140.3	200.0
2011-09-18 21:00:00	YM	Futures	11140.3	11146.2	11129.5	11143.3	322.0
2011-09-18 21:30:00	YM	Futures	11142.3	11143.3	11114.7	11120.6	315.0
2011-09-18 22:00:00	YM	Futures	11117.7	11121.6	11107.8	11110.8	335.0
2011-09-18 22:30:00	YM	Futures	11110.8	11121.6	11110.8	11113.7	229.0
2011-09-18 23:00:00	YM	Futures	11110.8	11127.5	11110.8	11117.7	135.0
2011-09-18 23:30:00	YM	Futures	11118.6	11128.5	11115.7	11123.6	193.0
2011-09-18 18:00:00	CL	Futures	148.62	148.62	147.76	147.96	1159.0
2011-09-18 18:30:00	CL	Futures	147.98	148.15	147.71	148.03	677.0
2011-09-18 19:00:00	CL	Futures	148.06	148.08	147.78	147.86	225.0
2011-09-18 19:30:00	CL	Futures	147.86	148.06	147.76	147.93	354.0
2011-09-18 20:00:00	CL	Futures	148.05	148.2	147.86	148.03	247.0
2011-09-18 20:30:00	CL	Futures	148.0	148.1	147.95	148.03	199.0
2011-09-18 21:00:00	CL	Futures	148.06	148.06	147.47	147.52	757.0
2011-09-18 21:30:00	CL	Futures	147.59	147.61	147.24	147.25	733.0
2011-09-18 22:00:00	CL	Futures	147.25	147.27	147.08	147.13	653.0
2011-09-18 22:30:00	CL	Futures	147.13	147.42	147.12	147.39	405.0
2011-09-18 23:00:00	CL	Futures	147.32	147.49	147.18	147.24	275.0
2011-09-18 23:30:00	CL	Futures	147.25	147.42	147.0	147.22	362.0
2011-09-18 18:00:00	GC	Futures	2534.5	2552.5	2530.1	2544.6	3332.0
2011-09-18 18:30:00	GC	Futures	2544.6	2548.5	2542.5	2543.9	719.0

> showing 50 of 475 rows — these rows as CSV

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