PREVIEW / futures_1hour / 2011-01-21

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-01-21.parquet
  size:    40 KB
  rows:    1,187

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-21 00:00:00	ES	Futures	1262.37	1262.37	1260.15	1260.64	7290.0
2011-01-21 01:00:00	ES	Futures	1260.64	1262.37	1260.39	1261.88	4244.0
2011-01-21 02:00:00	ES	Futures	1261.88	1262.13	1260.15	1260.89	8306.0
2011-01-21 03:00:00	ES	Futures	1260.64	1262.62	1260.39	1261.88	23484.0
2011-01-21 04:00:00	ES	Futures	1261.88	1263.86	1260.89	1263.61	20626.0
2011-01-21 05:00:00	ES	Futures	1263.61	1266.08	1262.37	1265.09	28377.0
2011-01-21 06:00:00	ES	Futures	1265.34	1268.06	1264.35	1267.07	29594.0
2011-01-21 07:00:00	ES	Futures	1266.83	1270.29	1266.08	1269.05	54737.0
2011-01-21 08:00:00	ES	Futures	1269.3	1270.54	1267.82	1270.04	72209.0
2011-01-21 09:00:00	ES	Futures	1270.04	1274.25	1270.04	1273.75	330771.0
2011-01-21 10:00:00	ES	Futures	1274.0	1274.74	1268.56	1269.55	347190.0
2011-01-21 11:00:00	ES	Futures	1269.55	1270.79	1265.84	1267.07	280527.0
2011-01-21 12:00:00	ES	Futures	1267.32	1269.8	1265.59	1267.82	193903.0
2011-01-21 13:00:00	ES	Futures	1267.82	1269.3	1266.58	1268.56	88461.0
2011-01-21 14:00:00	ES	Futures	1268.56	1270.04	1267.57	1268.31	110247.0
2011-01-21 15:00:00	ES	Futures	1268.31	1269.55	1265.34	1267.07	263088.0
2011-01-21 16:00:00	ES	Futures	1267.07	1267.57	1265.84	1267.07	94977.0
2011-01-21 00:00:00	NQ	Futures	2619.46	2619.46	2614.87	2615.73	331.0
2011-01-21 01:00:00	NQ	Futures	2615.73	2618.88	2615.44	2617.74	230.0
2011-01-21 02:00:00	NQ	Futures	2618.31	2618.6	2615.44	2616.59	572.0
2011-01-21 03:00:00	NQ	Futures	2616.87	2618.6	2615.15	2617.16	2238.0
2011-01-21 04:00:00	NQ	Futures	2617.16	2620.61	2615.73	2620.03	1584.0
2011-01-21 05:00:00	NQ	Futures	2620.03	2625.2	2618.31	2623.48	1942.0
2011-01-21 06:00:00	NQ	Futures	2623.19	2628.07	2622.9	2627.5	2185.0
2011-01-21 07:00:00	NQ	Futures	2627.78	2634.96	2625.77	2633.81	4108.0
2011-01-21 08:00:00	NQ	Futures	2633.52	2638.4	2630.94	2637.54	6829.0
2011-01-21 09:00:00	NQ	Futures	2637.25	2640.99	2632.37	2638.69	47322.0
2011-01-21 10:00:00	NQ	Futures	2638.69	2640.41	2624.62	2624.62	38388.0
2011-01-21 11:00:00	NQ	Futures	2624.62	2628.36	2615.15	2617.16	30709.0
2011-01-21 12:00:00	NQ	Futures	2617.16	2621.47	2609.41	2613.72	23676.0
2011-01-21 13:00:00	NQ	Futures	2613.72	2615.73	2609.41	2612.28	14421.0
2011-01-21 14:00:00	NQ	Futures	2612.57	2616.3	2610.56	2613.14	16203.0
2011-01-21 15:00:00	NQ	Futures	2613.14	2615.15	2601.38	2602.81	44995.0
2011-01-21 16:00:00	NQ	Futures	2602.81	2604.82	2602.24	2604.82	8963.0
2011-01-21 00:00:00	YM	Futures	11269.3	11269.3	11249.2	11254.9	442.0
2011-01-21 01:00:00	YM	Futures	11253.9	11265.4	11253.0	11261.6	185.0
2011-01-21 02:00:00	YM	Futures	11263.5	11268.3	11252.0	11257.8	432.0
2011-01-21 03:00:00	YM	Futures	11258.7	11268.3	11254.9	11264.5	1198.0
2011-01-21 04:00:00	YM	Futures	11264.5	11282.7	11258.7	11279.8	969.0
2011-01-21 05:00:00	YM	Futures	11280.8	11297.0	11274.1	11286.5	1104.0
2011-01-21 06:00:00	YM	Futures	11285.5	11307.6	11283.6	11299.0	1368.0
2011-01-21 07:00:00	YM	Futures	11299.9	11321.9	11293.2	11316.2	1520.0
2011-01-21 08:00:00	YM	Futures	11315.2	11324.8	11303.7	11317.2	3335.0
2011-01-21 09:00:00	YM	Futures	11317.2	11351.6	11317.2	11349.7	17116.0
2011-01-21 10:00:00	YM	Futures	11349.7	11356.4	11318.1	11326.7	14852.0
2011-01-21 11:00:00	YM	Futures	11326.7	11335.4	11302.8	11319.1	14656.0
2011-01-21 12:00:00	YM	Futures	11319.1	11335.4	11307.6	11312.4	9450.0
2011-01-21 13:00:00	YM	Futures	11312.4	11332.5	11302.8	11328.6	5204.0
2011-01-21 14:00:00	YM	Futures	11329.6	11338.2	11321.9	11325.8	5810.0
2011-01-21 15:00:00	YM	Futures	11327.7	11339.2	11311.4	11323.9	12729.0

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

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