PREVIEW / futures_1hour / 2011-07-11

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-07-11.parquet
  size:    50 KB
  rows:    1,469

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-07-11 00:00:00	ES	Futures	1331.33	1332.32	1330.33	1331.08	2188.0
2011-07-11 01:00:00	ES	Futures	1331.33	1331.58	1329.58	1330.08	5052.0
2011-07-11 02:00:00	ES	Futures	1330.08	1330.83	1327.34	1327.34	17184.0
2011-07-11 03:00:00	ES	Futures	1327.34	1329.83	1326.84	1328.08	38766.0
2011-07-11 04:00:00	ES	Futures	1328.08	1329.33	1326.09	1326.84	25434.0
2011-07-11 05:00:00	ES	Futures	1326.59	1327.34	1324.84	1326.09	26537.0
2011-07-11 06:00:00	ES	Futures	1326.09	1327.59	1324.84	1325.09	21320.0
2011-07-11 07:00:00	ES	Futures	1325.09	1325.34	1320.35	1321.35	66809.0
2011-07-11 08:00:00	ES	Futures	1321.35	1322.35	1318.86	1321.1	97044.0
2011-07-11 09:00:00	ES	Futures	1321.1	1323.84	1318.61	1321.6	284168.0
2011-07-11 10:00:00	ES	Futures	1321.35	1322.1	1312.12	1312.37	514757.0
2011-07-11 11:00:00	ES	Futures	1312.12	1317.11	1311.12	1314.87	359053.0
2011-07-11 12:00:00	ES	Futures	1315.12	1316.61	1313.12	1313.62	128167.0
2011-07-11 13:00:00	ES	Futures	1313.62	1314.37	1310.38	1314.12	135190.0
2011-07-11 14:00:00	ES	Futures	1313.87	1314.37	1309.63	1310.88	141677.0
2011-07-11 15:00:00	ES	Futures	1311.12	1312.87	1308.63	1311.87	373037.0
2011-07-11 16:00:00	ES	Futures	1312.12	1316.11	1311.87	1314.87	142044.0
2011-07-11 17:00:00	ES	Futures	1315.12	1315.12	1312.87	1313.12	5182.0
2011-07-11 18:00:00	ES	Futures	1313.12	1315.36	1313.12	1313.62	6138.0
2011-07-11 19:00:00	ES	Futures	1313.62	1314.62	1312.87	1314.12	4832.0
2011-07-11 20:00:00	ES	Futures	1314.12	1315.12	1312.12	1312.37	7478.0
2011-07-11 21:00:00	ES	Futures	1312.37	1313.87	1304.39	1307.38	26279.0
2011-07-11 22:00:00	ES	Futures	1307.38	1307.63	1303.64	1304.89	16015.0
2011-07-11 23:00:00	ES	Futures	1304.89	1306.39	1303.89	1305.89	8270.0
2011-07-11 00:00:00	NQ	Futures	2756.79	2757.65	2754.78	2756.22	152.0
2011-07-11 01:00:00	NQ	Futures	2755.93	2756.22	2753.05	2753.05	462.0
2011-07-11 02:00:00	NQ	Futures	2753.05	2754.49	2747.87	2748.16	2241.0
2011-07-11 03:00:00	NQ	Futures	2748.45	2753.05	2746.43	2748.45	2788.0
2011-07-11 04:00:00	NQ	Futures	2748.45	2751.32	2745.86	2747.3	1793.0
2011-07-11 05:00:00	NQ	Futures	2747.01	2747.58	2743.27	2745.28	1816.0
2011-07-11 06:00:00	NQ	Futures	2745.28	2747.3	2742.69	2742.98	2996.0
2011-07-11 07:00:00	NQ	Futures	2742.98	2744.42	2734.92	2736.07	5443.0
2011-07-11 08:00:00	NQ	Futures	2736.36	2741.25	2734.06	2738.37	11324.0
2011-07-11 09:00:00	NQ	Futures	2738.09	2750.46	2734.35	2744.71	47059.0
2011-07-11 10:00:00	NQ	Futures	2744.42	2746.43	2721.4	2721.68	57484.0
2011-07-11 11:00:00	NQ	Futures	2721.4	2726.58	2715.07	2722.84	40255.0
2011-07-11 12:00:00	NQ	Futures	2722.84	2723.41	2715.07	2717.37	17254.0
2011-07-11 13:00:00	NQ	Futures	2717.37	2718.52	2709.89	2717.66	14197.0
2011-07-11 14:00:00	NQ	Futures	2717.66	2719.09	2706.43	2710.75	18110.0
2011-07-11 15:00:00	NQ	Futures	2711.04	2716.79	2706.43	2716.22	39416.0
2011-07-11 16:00:00	NQ	Futures	2716.5	2726.0	2715.93	2720.82	13275.0
2011-07-11 17:00:00	NQ	Futures	2720.53	2720.82	2718.23	2718.23	570.0
2011-07-11 18:00:00	NQ	Futures	2718.52	2723.41	2718.52	2720.53	450.0
2011-07-11 19:00:00	NQ	Futures	2719.96	2721.4	2718.23	2719.38	245.0
2011-07-11 20:00:00	NQ	Futures	2719.96	2722.84	2717.66	2717.94	660.0
2011-07-11 21:00:00	NQ	Futures	2717.94	2720.25	2699.81	2706.72	2138.0
2011-07-11 22:00:00	NQ	Futures	2706.72	2706.72	2700.1	2702.69	1106.0
2011-07-11 23:00:00	NQ	Futures	2702.69	2706.14	2701.54	2705.28	436.0
2011-07-11 00:00:00	YM	Futures	12170.8	12172.8	12159.2	12166.0	74.0
2011-07-11 01:00:00	YM	Futures	12166.0	12166.0	12155.3	12158.3	390.0

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

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