PREVIEW / futures_1hour / 2013-01-27

all futures 1-hour files

  file:    by_date/futures_1hour/2013/2013-01-27.parquet
  size:    14 KB
  rows:    278

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
2013-01-27 18:00:00	ES	Futures	1535.18	1535.44	1533.9	1534.67	4164.0
2013-01-27 19:00:00	ES	Futures	1534.67	1536.72	1533.39	1536.72	6331.0
2013-01-27 20:00:00	ES	Futures	1536.47	1536.98	1535.44	1535.95	6641.0
2013-01-27 21:00:00	ES	Futures	1535.7	1536.47	1535.44	1536.21	1984.0
2013-01-27 22:00:00	ES	Futures	1536.21	1536.72	1535.95	1535.95	748.0
2013-01-27 23:00:00	ES	Futures	1536.21	1536.72	1535.7	1536.21	1129.0
2013-01-27 18:00:00	NQ	Futures	3177.89	3177.89	3174.69	3176.44	397.0
2013-01-27 19:00:00	NQ	Futures	3176.44	3179.93	3174.11	3179.93	439.0
2013-01-27 20:00:00	NQ	Futures	3179.93	3180.51	3177.89	3178.47	323.0
2013-01-27 21:00:00	NQ	Futures	3179.06	3181.09	3178.18	3180.8	366.0
2013-01-27 22:00:00	NQ	Futures	3180.8	3181.09	3179.35	3179.64	84.0
2013-01-27 23:00:00	NQ	Futures	3179.64	3181.09	3179.35	3180.8	97.0
2013-01-27 18:00:00	YM	Futures	13899.2	13910.3	13886.2	13900.2	693.0
2013-01-27 19:00:00	YM	Futures	13900.2	13916.3	13891.2	13916.3	408.0
2013-01-27 20:00:00	YM	Futures	13915.3	13917.3	13905.3	13908.3	715.0
2013-01-27 21:00:00	YM	Futures	13910.3	13915.3	13907.3	13913.3	299.0
2013-01-27 22:00:00	YM	Futures	13914.3	13914.3	13911.3	13911.3	120.0
2013-01-27 23:00:00	YM	Futures	13911.3	13915.3	13909.3	13912.3	109.0
2013-01-27 18:00:00	CL	Futures	153.49	153.57	153.25	153.33	710.0
2013-01-27 19:00:00	CL	Futures	153.31	153.42	153.25	153.41	603.0
2013-01-27 20:00:00	CL	Futures	153.37	153.5	153.34	153.41	702.0
2013-01-27 21:00:00	CL	Futures	153.37	153.41	153.29	153.36	269.0
2013-01-27 22:00:00	CL	Futures	153.36	153.37	153.29	153.29	257.0
2013-01-27 23:00:00	CL	Futures	153.29	153.49	153.28	153.37	333.0
2013-01-27 18:00:00	GC	Futures	2284.0	2285.6	2282.0	2284.2	499.0
2013-01-27 19:00:00	GC	Futures	2283.9	2284.3	2282.0	2283.9	205.0
2013-01-27 20:00:00	GC	Futures	2283.6	2286.7	2283.6	2285.3	636.0
2013-01-27 21:00:00	GC	Futures	2285.0	2286.2	2283.2	2284.3	891.0
2013-01-27 22:00:00	GC	Futures	2284.2	2285.6	2284.2	2284.9	350.0
2013-01-27 23:00:00	GC	Futures	2284.7	2285.3	2283.1	2284.9	131.0
2013-01-27 18:00:00	ZN	Futures	116.933122	116.947031	116.849668	116.919213	12435.0
2013-01-27 19:00:00	ZN	Futures	116.919213	116.947031	116.905304	116.933122	11768.0
2013-01-27 20:00:00	ZN	Futures	116.933122	116.974849	116.905304	116.96094	13100.0
2013-01-27 21:00:00	ZN	Futures	116.96094	117.002667	116.947031	116.96094	6923.0
2013-01-27 22:00:00	ZN	Futures	116.96094	116.974849	116.933122	116.933122	4323.0
2013-01-27 23:00:00	ZN	Futures	116.947031	116.947031	116.905304	116.919213	2854.0

> showing 36 of 278 rows — these rows as CSV

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