PREVIEW / futures_1hour / 2011-06-01

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-06-01.parquet
  size:    50 KB
  rows:    1,485

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-06-01 00:00:00	ES	Futures	1338.54	1339.04	1338.3	1338.79	1023.0
2011-06-01 01:00:00	ES	Futures	1338.79	1338.79	1337.8	1338.79	4180.0
2011-06-01 02:00:00	ES	Futures	1338.79	1338.79	1335.56	1336.8	23324.0
2011-06-01 03:00:00	ES	Futures	1336.56	1337.55	1334.57	1334.82	36454.0
2011-06-01 04:00:00	ES	Futures	1334.82	1336.8	1333.33	1334.07	24399.0
2011-06-01 05:00:00	ES	Futures	1334.07	1336.06	1334.07	1334.82	19118.0
2011-06-01 06:00:00	ES	Futures	1334.82	1335.07	1332.83	1334.07	22995.0
2011-06-01 07:00:00	ES	Futures	1334.07	1335.07	1333.08	1334.82	20793.0
2011-06-01 08:00:00	ES	Futures	1335.07	1335.31	1329.1	1330.59	106931.0
2011-06-01 09:00:00	ES	Futures	1330.59	1332.58	1329.1	1329.1	207574.0
2011-06-01 10:00:00	ES	Futures	1329.1	1329.35	1318.42	1321.15	576155.0
2011-06-01 11:00:00	ES	Futures	1321.4	1323.39	1319.91	1320.16	234895.0
2011-06-01 12:00:00	ES	Futures	1320.16	1321.15	1314.69	1316.43	245764.0
2011-06-01 13:00:00	ES	Futures	1316.18	1317.43	1311.46	1314.69	227977.0
2011-06-01 14:00:00	ES	Futures	1314.69	1314.69	1308.98	1311.71	248832.0
2011-06-01 15:00:00	ES	Futures	1311.71	1312.96	1304.01	1305.01	442386.0
2011-06-01 16:00:00	ES	Futures	1305.01	1305.5	1303.02	1304.76	177072.0
2011-06-01 17:00:00	ES	Futures	1304.51	1304.76	1302.27	1302.52	5033.0
2011-06-01 18:00:00	ES	Futures	1302.77	1304.01	1301.28	1303.76	11441.0
2011-06-01 19:00:00	ES	Futures	1303.52	1305.75	1303.52	1303.76	10717.0
2011-06-01 20:00:00	ES	Futures	1303.76	1305.5	1302.02	1305.01	15535.0
2011-06-01 21:00:00	ES	Futures	1305.25	1307.24	1304.76	1306.5	12805.0
2011-06-01 22:00:00	ES	Futures	1306.5	1306.74	1304.01	1304.76	4373.0
2011-06-01 23:00:00	ES	Futures	1305.01	1306.0	1303.02	1304.01	3376.0
2011-06-01 00:00:00	NQ	Futures	2734.95	2735.52	2733.8	2734.95	187.0
2011-06-01 01:00:00	NQ	Futures	2734.66	2734.95	2732.36	2734.37	530.0
2011-06-01 02:00:00	NQ	Futures	2733.8	2733.8	2727.48	2731.21	1406.0
2011-06-01 03:00:00	NQ	Futures	2730.64	2730.64	2722.02	2723.74	4409.0
2011-06-01 04:00:00	NQ	Futures	2724.03	2726.9	2719.15	2720.01	1898.0
2011-06-01 05:00:00	NQ	Futures	2719.72	2723.17	2719.72	2721.16	2835.0
2011-06-01 06:00:00	NQ	Futures	2721.16	2721.45	2718.29	2721.16	1958.0
2011-06-01 07:00:00	NQ	Futures	2721.16	2724.89	2719.72	2724.03	2411.0
2011-06-01 08:00:00	NQ	Futures	2724.32	2724.61	2713.98	2715.7	9255.0
2011-06-01 09:00:00	NQ	Futures	2715.99	2728.63	2714.26	2722.31	33966.0
2011-06-01 10:00:00	NQ	Futures	2722.31	2722.31	2706.22	2709.67	60662.0
2011-06-01 11:00:00	NQ	Futures	2709.95	2710.53	2701.05	2702.48	27039.0
2011-06-01 12:00:00	NQ	Futures	2702.2	2704.21	2690.42	2697.6	38506.0
2011-06-01 13:00:00	NQ	Futures	2697.6	2700.76	2684.96	2691.56	32824.0
2011-06-01 14:00:00	NQ	Futures	2691.28	2691.28	2676.05	2680.93	37340.0
2011-06-01 15:00:00	NQ	Futures	2680.65	2682.37	2666.86	2668.58	50080.0
2011-06-01 16:00:00	NQ	Futures	2668.58	2668.87	2663.98	2666.28	15490.0
2011-06-01 17:00:00	NQ	Futures	2666.28	2666.57	2661.97	2662.26	328.0
2011-06-01 18:00:00	NQ	Futures	2663.41	2664.56	2659.1	2663.41	972.0
2011-06-01 19:00:00	NQ	Futures	2663.7	2666.86	2663.7	2664.27	1082.0
2011-06-01 20:00:00	NQ	Futures	2663.98	2665.71	2659.96	2665.13	1790.0
2011-06-01 21:00:00	NQ	Futures	2665.13	2669.15	2664.56	2668.58	1028.0
2011-06-01 22:00:00	NQ	Futures	2668.29	2668.87	2663.98	2665.13	382.0
2011-06-01 23:00:00	NQ	Futures	2665.71	2666.86	2661.97	2663.41	286.0
2011-06-01 00:00:00	YM	Futures	12122.7	12127.5	12122.7	12124.6	79.0
2011-06-01 01:00:00	YM	Futures	12125.6	12125.6	12116.9	12122.7	204.0

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

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