PREVIEW / futures_1hour / 2011-09-04

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-09-04.parquet
  size:    12 KB
  rows:    200

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-04 18:00:00	ES	Futures	1162.23	1163.23	1157.49	1160.48	17254.0
2011-09-04 19:00:00	ES	Futures	1160.48	1163.73	1158.99	1163.23	4860.0
2011-09-04 20:00:00	ES	Futures	1163.48	1163.98	1159.24	1159.49	7847.0
2011-09-04 21:00:00	ES	Futures	1159.74	1162.23	1157.99	1160.23	6883.0
2011-09-04 22:00:00	ES	Futures	1160.48	1161.48	1159.24	1160.23	2873.0
2011-09-04 23:00:00	ES	Futures	1160.48	1161.73	1159.99	1160.98	1973.0
2011-09-04 18:00:00	NQ	Futures	2485.72	2485.72	2474.78	2480.25	784.0
2011-09-04 19:00:00	NQ	Futures	2480.25	2484.57	2477.08	2483.41	150.0
2011-09-04 20:00:00	NQ	Futures	2484.57	2485.72	2477.37	2477.95	224.0
2011-09-04 21:00:00	NQ	Futures	2478.23	2482.55	2475.64	2480.82	187.0
2011-09-04 22:00:00	NQ	Futures	2480.54	2482.26	2477.66	2478.81	220.0
2011-09-04 23:00:00	NQ	Futures	2479.39	2482.26	2477.66	2480.54	166.0
2011-09-04 18:00:00	YM	Futures	10833.5	10843.2	10780.2	10802.5	315.0
2011-09-04 19:00:00	YM	Futures	10804.4	10825.7	10793.8	10820.9	75.0
2011-09-04 20:00:00	YM	Futures	10823.8	10830.6	10797.7	10798.6	228.0
2011-09-04 21:00:00	YM	Futures	10799.6	10817.0	10788.0	10803.5	275.0
2011-09-04 22:00:00	YM	Futures	10802.5	10812.2	10788.9	10801.5	229.0
2011-09-04 23:00:00	YM	Futures	10801.5	10810.2	10801.5	10808.3	116.0
2011-09-04 18:00:00	CL	Futures	146.49	146.55	145.62	145.62	979.0
2011-09-04 19:00:00	CL	Futures	145.64	145.71	145.45	145.66	450.0
2011-09-04 20:00:00	CL	Futures	145.69	145.69	145.17	145.27	569.0
2011-09-04 21:00:00	CL	Futures	145.27	145.66	145.25	145.49	619.0
2011-09-04 22:00:00	CL	Futures	145.52	145.67	145.25	145.44	341.0
2011-09-04 23:00:00	CL	Futures	145.45	145.45	145.25	145.37	433.0
2011-09-04 18:00:00	GC	Futures	2617.9	2636.6	2617.8	2631.9	4601.0
2011-09-04 19:00:00	GC	Futures	2631.9	2632.6	2628.7	2628.7	642.0
2011-09-04 20:00:00	GC	Futures	2628.7	2632.0	2621.8	2621.8	2520.0
2011-09-04 21:00:00	GC	Futures	2622.3	2625.6	2613.9	2621.0	5896.0
2011-09-04 22:00:00	GC	Futures	2621.1	2624.9	2620.2	2624.1	1744.0
2011-09-04 23:00:00	GC	Futures	2623.8	2623.8	2616.8	2620.4	2408.0
2011-09-04 18:00:00	ZN	Futures	113.020002	113.020002	113.020002	113.020002	57.0
2011-09-04 19:00:00	ZN	Futures	113.033455	113.046909	113.033455	113.046909	4.0
2011-09-04 20:00:00	ZN	Futures	113.033455	113.033455	112.979643	113.020002	87.0
2011-09-04 21:00:00	ZN	Futures	113.006549	113.006549	112.92583	112.92583	1174.0
2011-09-04 22:00:00	ZN	Futures	113.006549	113.006549	113.006549	113.006549	1.0

> showing 35 of 200 rows — these rows as CSV

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