PREVIEW / futures_1hour / 2011-01-31

all futures 1-hour files

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

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-01-31 00:00:00	ES	Futures	1261.38	1261.88	1259.65	1261.63	5014.0
2011-01-31 01:00:00	ES	Futures	1261.38	1261.38	1259.9	1260.64	2683.0
2011-01-31 02:00:00	ES	Futures	1260.39	1261.88	1259.4	1260.64	13107.0
2011-01-31 03:00:00	ES	Futures	1260.64	1261.38	1254.46	1255.69	42150.0
2011-01-31 04:00:00	ES	Futures	1255.94	1258.17	1255.69	1257.92	22902.0
2011-01-31 05:00:00	ES	Futures	1257.92	1261.38	1257.67	1260.64	21048.0
2011-01-31 06:00:00	ES	Futures	1260.89	1262.13	1259.9	1259.9	17362.0
2011-01-31 07:00:00	ES	Futures	1260.15	1263.86	1259.65	1262.87	30885.0
2011-01-31 08:00:00	ES	Futures	1262.87	1264.6	1262.87	1264.1	62144.0
2011-01-31 09:00:00	ES	Futures	1264.1	1264.85	1260.39	1261.14	310314.0
2011-01-31 10:00:00	ES	Futures	1261.14	1265.84	1260.15	1265.09	299870.0
2011-01-31 11:00:00	ES	Futures	1265.09	1266.83	1264.6	1265.84	196266.0
2011-01-31 12:00:00	ES	Futures	1266.08	1270.54	1265.84	1268.56	308555.0
2011-01-31 13:00:00	ES	Futures	1268.31	1269.8	1267.07	1268.06	146781.0
2011-01-31 14:00:00	ES	Futures	1268.31	1269.05	1264.35	1266.83	244002.0
2011-01-31 15:00:00	ES	Futures	1266.83	1269.8	1266.58	1269.55	353483.0
2011-01-31 16:00:00	ES	Futures	1269.55	1270.54	1268.81	1269.3	137086.0
2011-01-31 17:00:00	ES	Futures	1269.3	1269.55	1268.56	1268.81	1836.0
2011-01-31 18:00:00	ES	Futures	1268.81	1269.8	1268.06	1269.8	5520.0
2011-01-31 19:00:00	ES	Futures	1269.8	1271.28	1269.55	1271.03	7778.0
2011-01-31 20:00:00	ES	Futures	1271.28	1271.78	1270.54	1271.28	7603.0
2011-01-31 21:00:00	ES	Futures	1271.53	1275.24	1270.79	1273.01	13677.0
2011-01-31 22:00:00	ES	Futures	1273.26	1274.0	1272.02	1273.26	5407.0
2011-01-31 23:00:00	ES	Futures	1273.01	1273.75	1272.27	1273.01	3132.0
2011-01-31 00:00:00	NQ	Futures	2606.83	2611.13	2605.39	2608.84	698.0
2011-01-31 01:00:00	NQ	Futures	2608.55	2609.12	2604.53	2607.4	609.0
2011-01-31 02:00:00	NQ	Futures	2607.12	2610.85	2605.39	2609.12	857.0
2011-01-31 03:00:00	NQ	Futures	2608.84	2609.41	2595.06	2597.07	3800.0
2011-01-31 04:00:00	NQ	Futures	2597.07	2603.1	2596.78	2602.81	1322.0
2011-01-31 05:00:00	NQ	Futures	2603.1	2609.12	2603.1	2608.26	1813.0
2011-01-31 06:00:00	NQ	Futures	2608.26	2611.13	2607.4	2607.4	1088.0
2011-01-31 07:00:00	NQ	Futures	2607.12	2613.14	2606.54	2611.71	1267.0
2011-01-31 08:00:00	NQ	Futures	2611.71	2613.14	2610.27	2612.86	4642.0
2011-01-31 09:00:00	NQ	Futures	2612.86	2614.29	2588.75	2592.19	65537.0
2011-01-31 10:00:00	NQ	Futures	2592.19	2606.25	2590.75	2604.82	66177.0
2011-01-31 11:00:00	NQ	Futures	2605.11	2611.71	2603.96	2610.27	31734.0
2011-01-31 12:00:00	NQ	Futures	2609.99	2624.62	2609.99	2616.01	32335.0
2011-01-31 13:00:00	NQ	Futures	2616.01	2620.03	2612.86	2617.16	17416.0
2011-01-31 14:00:00	NQ	Futures	2617.16	2619.17	2604.82	2610.27	40832.0
2011-01-31 15:00:00	NQ	Futures	2609.99	2618.02	2608.84	2617.74	27437.0
2011-01-31 16:00:00	NQ	Futures	2617.74	2624.05	2617.16	2620.32	12378.0
2011-01-31 17:00:00	NQ	Futures	2620.32	2620.61	2619.17	2619.75	110.0
2011-01-31 18:00:00	NQ	Futures	2620.03	2623.48	2619.17	2623.19	521.0
2011-01-31 19:00:00	NQ	Futures	2623.19	2627.78	2623.19	2626.35	960.0
2011-01-31 20:00:00	NQ	Futures	2626.06	2626.92	2624.62	2626.35	424.0
2011-01-31 21:00:00	NQ	Futures	2626.35	2630.37	2625.2	2629.79	1649.0
2011-01-31 22:00:00	NQ	Futures	2630.08	2630.37	2628.64	2629.79	1010.0
2011-01-31 23:00:00	NQ	Futures	2629.79	2630.08	2628.93	2629.22	155.0
2011-01-31 00:00:00	YM	Futures	11282.7	11289.4	11273.1	11285.5	367.0
2011-01-31 01:00:00	YM	Futures	11286.5	11286.5	11272.1	11278.8	264.0

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

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