PREVIEW / futures_1hour / 2012-04-20

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-04-20.parquet
  size:    40 KB
  rows:    1,209

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
2012-04-20 00:00:00	ES	Futures	1390.66	1390.91	1389.9	1390.15	1792.0
2012-04-20 01:00:00	ES	Futures	1389.9	1391.41	1388.63	1390.15	4759.0
2012-04-20 02:00:00	ES	Futures	1390.4	1392.93	1389.9	1391.67	7577.0
2012-04-20 03:00:00	ES	Futures	1391.41	1393.44	1387.62	1391.67	41951.0
2012-04-20 04:00:00	ES	Futures	1391.41	1393.94	1388.38	1389.64	37085.0
2012-04-20 05:00:00	ES	Futures	1389.64	1393.69	1388.38	1393.18	27603.0
2012-04-20 06:00:00	ES	Futures	1392.93	1397.23	1392.93	1395.97	43505.0
2012-04-20 07:00:00	ES	Futures	1395.97	1396.22	1392.93	1394.7	40429.0
2012-04-20 08:00:00	ES	Futures	1394.45	1397.23	1394.2	1394.96	63067.0
2012-04-20 09:00:00	ES	Futures	1394.96	1396.73	1392.68	1396.73	357702.0
2012-04-20 10:00:00	ES	Futures	1396.47	1399.76	1393.18	1398.24	333770.0
2012-04-20 11:00:00	ES	Futures	1398.24	1398.5	1396.73	1398.24	196589.0
2012-04-20 12:00:00	ES	Futures	1398.24	1399.51	1397.49	1397.49	97483.0
2012-04-20 13:00:00	ES	Futures	1397.49	1398.24	1392.93	1393.94	105065.0
2012-04-20 14:00:00	ES	Futures	1394.2	1395.46	1391.67	1392.93	119201.0
2012-04-20 15:00:00	ES	Futures	1392.93	1393.18	1389.9	1390.66	209056.0
2012-04-20 16:00:00	ES	Futures	1390.4	1391.92	1389.9	1391.41	87973.0
2012-04-20 00:00:00	NQ	Futures	3108.33	3109.2	3106.88	3106.88	345.0
2012-04-20 01:00:00	NQ	Futures	3107.17	3109.48	3104.86	3107.46	332.0
2012-04-20 02:00:00	NQ	Futures	3107.46	3113.24	3106.3	3110.06	876.0
2012-04-20 03:00:00	NQ	Futures	3109.48	3114.69	3104.28	3110.64	4770.0
2012-04-20 04:00:00	NQ	Futures	3111.22	3115.56	3103.7	3106.01	4033.0
2012-04-20 05:00:00	NQ	Futures	3106.01	3115.27	3103.99	3114.11	2347.0
2012-04-20 06:00:00	NQ	Futures	3114.4	3121.63	3113.82	3119.9	3547.0
2012-04-20 07:00:00	NQ	Futures	3119.9	3119.9	3113.24	3117.0	5111.0
2012-04-20 08:00:00	NQ	Futures	3116.43	3122.21	3113.82	3115.85	8342.0
2012-04-20 09:00:00	NQ	Futures	3115.85	3128.57	3107.46	3128.57	73126.0
2012-04-20 10:00:00	NQ	Futures	3128.57	3132.62	3119.9	3125.39	44930.0
2012-04-20 11:00:00	NQ	Futures	3125.1	3125.97	3118.74	3123.94	22983.0
2012-04-20 12:00:00	NQ	Futures	3123.94	3128.57	3117.87	3118.45	14040.0
2012-04-20 13:00:00	NQ	Futures	3118.16	3120.76	3103.41	3106.59	20150.0
2012-04-20 14:00:00	NQ	Futures	3106.88	3108.62	3094.45	3095.6	27302.0
2012-04-20 15:00:00	NQ	Futures	3095.89	3100.23	3088.37	3092.13	44809.0
2012-04-20 16:00:00	NQ	Futures	3091.84	3095.6	3090.98	3093.29	10633.0
2012-04-20 00:00:00	YM	Futures	12869.2	12871.2	12863.2	12865.2	144.0
2012-04-20 01:00:00	YM	Futures	12865.2	12894.1	12855.3	12872.2	1547.0
2012-04-20 02:00:00	YM	Futures	12874.2	12894.1	12871.2	12884.1	691.0
2012-04-20 03:00:00	YM	Futures	12883.1	12901.1	12857.2	12886.1	3501.0
2012-04-20 04:00:00	YM	Futures	12886.1	12909.1	12862.2	12870.2	4316.0
2012-04-20 05:00:00	YM	Futures	12871.2	12902.1	12860.2	12897.1	2357.0
2012-04-20 06:00:00	YM	Futures	12897.1	12930.0	12896.1	12920.0	3231.0
2012-04-20 07:00:00	YM	Futures	12921.0	12922.0	12902.1	12917.0	2491.0
2012-04-20 08:00:00	YM	Futures	12916.0	12936.0	12915.0	12925.0	4761.0
2012-04-20 09:00:00	YM	Futures	12925.0	12947.9	12916.0	12945.9	21444.0
2012-04-20 10:00:00	YM	Futures	12944.9	12973.8	12924.0	12966.8	20188.0
2012-04-20 11:00:00	YM	Futures	12966.8	12970.8	12953.9	12968.8	10110.0
2012-04-20 12:00:00	YM	Futures	12968.8	12978.8	12966.8	12967.8	5820.0
2012-04-20 13:00:00	YM	Futures	12966.8	12968.8	12929.0	12935.0	5783.0
2012-04-20 14:00:00	YM	Futures	12935.0	12950.9	12918.0	12936.9	7733.0
2012-04-20 15:00:00	YM	Futures	12936.9	12941.9	12920.0	12924.0	10509.0

> showing 50 of 1,209 rows — these rows as CSV

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