PREVIEW / futures_1hour / 2011-03-31

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-03-31.parquet
  size:    48 KB
  rows:    1,468

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-03-31 00:00:00	ES	Futures	1313.7	1315.94	1313.45	1315.69	3169.0
2011-03-31 01:00:00	ES	Futures	1315.69	1316.18	1314.94	1316.18	2223.0
2011-03-31 02:00:00	ES	Futures	1316.18	1316.43	1315.19	1316.43	5963.0
2011-03-31 03:00:00	ES	Futures	1316.43	1317.43	1315.44	1316.93	22923.0
2011-03-31 04:00:00	ES	Futures	1316.68	1317.18	1315.94	1317.18	11047.0
2011-03-31 05:00:00	ES	Futures	1316.93	1317.43	1315.94	1316.43	10113.0
2011-03-31 06:00:00	ES	Futures	1316.43	1316.43	1314.45	1315.44	18023.0
2011-03-31 07:00:00	ES	Futures	1315.19	1316.68	1313.7	1314.94	28312.0
2011-03-31 08:00:00	ES	Futures	1314.94	1315.69	1312.71	1314.2	44184.0
2011-03-31 09:00:00	ES	Futures	1313.95	1316.93	1312.46	1314.45	202448.0
2011-03-31 10:00:00	ES	Futures	1314.69	1317.43	1312.46	1316.68	223426.0
2011-03-31 11:00:00	ES	Futures	1316.43	1316.93	1312.21	1313.95	205953.0
2011-03-31 12:00:00	ES	Futures	1313.7	1316.93	1313.7	1316.68	105532.0
2011-03-31 13:00:00	ES	Futures	1316.43	1317.43	1315.94	1315.94	50905.0
2011-03-31 14:00:00	ES	Futures	1315.94	1317.43	1314.94	1316.43	70720.0
2011-03-31 15:00:00	ES	Futures	1316.43	1316.43	1312.96	1313.45	332882.0
2011-03-31 16:00:00	ES	Futures	1313.2	1315.19	1312.21	1313.45	161073.0
2011-03-31 17:00:00	ES	Futures	1313.45	1313.7	1312.46	1312.96	2667.0
2011-03-31 18:00:00	ES	Futures	1313.2	1314.2	1312.71	1313.7	5804.0
2011-03-31 19:00:00	ES	Futures	1313.95	1315.94	1313.7	1314.94	5682.0
2011-03-31 20:00:00	ES	Futures	1314.69	1316.18	1314.69	1314.94	5246.0
2011-03-31 21:00:00	ES	Futures	1314.94	1316.18	1314.2	1314.45	5731.0
2011-03-31 22:00:00	ES	Futures	1314.2	1314.69	1313.7	1313.95	2695.0
2011-03-31 23:00:00	ES	Futures	1313.95	1315.69	1313.2	1313.95	4586.0
2011-03-31 00:00:00	NQ	Futures	2677.2	2681.51	2676.62	2680.65	163.0
2011-03-31 01:00:00	NQ	Futures	2680.36	2683.23	2680.36	2683.23	320.0
2011-03-31 02:00:00	NQ	Futures	2682.66	2686.39	2681.22	2685.82	693.0
2011-03-31 03:00:00	NQ	Futures	2686.11	2687.83	2685.24	2687.54	2247.0
2011-03-31 04:00:00	NQ	Futures	2687.54	2687.83	2686.68	2687.83	2217.0
2011-03-31 05:00:00	NQ	Futures	2687.54	2687.83	2683.81	2685.82	1538.0
2011-03-31 06:00:00	NQ	Futures	2685.82	2686.11	2679.21	2681.8	2117.0
2011-03-31 07:00:00	NQ	Futures	2681.8	2686.68	2680.07	2682.95	4671.0
2011-03-31 08:00:00	NQ	Futures	2682.95	2683.81	2677.49	2680.65	4937.0
2011-03-31 09:00:00	NQ	Futures	2680.36	2688.12	2676.62	2680.65	29912.0
2011-03-31 10:00:00	NQ	Futures	2680.93	2687.83	2674.9	2686.68	26496.0
2011-03-31 11:00:00	NQ	Futures	2686.68	2687.54	2675.19	2677.49	22250.0
2011-03-31 12:00:00	NQ	Futures	2677.49	2684.67	2676.91	2683.23	12394.0
2011-03-31 13:00:00	NQ	Futures	2683.23	2687.26	2683.23	2683.81	10118.0
2011-03-31 14:00:00	NQ	Futures	2684.09	2688.98	2683.23	2687.26	12633.0
2011-03-31 15:00:00	NQ	Futures	2687.26	2690.13	2684.09	2687.83	32183.0
2011-03-31 16:00:00	NQ	Futures	2687.54	2690.99	2684.09	2686.97	9757.0
2011-03-31 17:00:00	NQ	Futures	2686.97	2686.97	2684.38	2685.82	169.0
2011-03-31 18:00:00	NQ	Futures	2686.39	2687.83	2686.11	2686.68	269.0
2011-03-31 19:00:00	NQ	Futures	2686.97	2698.17	2686.68	2691.85	1690.0
2011-03-31 20:00:00	NQ	Futures	2691.56	2694.73	2691.28	2692.43	532.0
2011-03-31 21:00:00	NQ	Futures	2692.71	2694.44	2690.13	2690.42	311.0
2011-03-31 22:00:00	NQ	Futures	2690.13	2691.56	2689.55	2690.99	280.0
2011-03-31 23:00:00	NQ	Futures	2690.42	2695.01	2688.69	2690.7	495.0
2011-03-31 00:00:00	YM	Futures	11826.0	11840.5	11823.1	11840.5	141.0
2011-03-31 01:00:00	YM	Futures	11837.6	11841.4	11834.7	11840.5	152.0

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

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