PREVIEW / futures_1hour / 2011-06-08

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-06-08.parquet
  size:    48 KB
  rows:    1,448

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-08 00:00:00	ES	Futures	1274.45	1275.94	1274.2	1275.94	4100.0
2011-06-08 01:00:00	ES	Futures	1275.69	1276.93	1275.19	1276.19	7275.0
2011-06-08 02:00:00	ES	Futures	1276.19	1277.68	1275.94	1277.68	12661.0
2011-06-08 03:00:00	ES	Futures	1277.43	1278.18	1273.21	1273.95	40011.0
2011-06-08 04:00:00	ES	Futures	1273.95	1274.7	1270.23	1272.46	44649.0
2011-06-08 05:00:00	ES	Futures	1272.21	1273.7	1270.97	1272.71	20071.0
2011-06-08 06:00:00	ES	Futures	1272.96	1272.96	1268.24	1269.98	49649.0
2011-06-08 07:00:00	ES	Futures	1269.98	1271.47	1269.48	1270.97	36535.0
2011-06-08 08:00:00	ES	Futures	1271.22	1273.7	1269.98	1272.96	55479.0
2011-06-08 09:00:00	ES	Futures	1272.96	1277.18	1270.97	1271.72	344661.0
2011-06-08 10:00:00	ES	Futures	1271.72	1277.18	1271.22	1275.69	363180.0
2011-06-08 11:00:00	ES	Futures	1275.69	1278.42	1272.71	1277.18	339802.0
2011-06-08 12:00:00	ES	Futures	1277.18	1277.93	1273.45	1276.93	176407.0
2011-06-08 13:00:00	ES	Futures	1276.93	1277.93	1268.98	1270.72	230906.0
2011-06-08 14:00:00	ES	Futures	1270.72	1275.44	1268.73	1273.45	263937.0
2011-06-08 15:00:00	ES	Futures	1273.45	1273.7	1268.24	1270.72	321765.0
2011-06-08 16:00:00	ES	Futures	1270.72	1270.97	1267.24	1267.49	114904.0
2011-06-08 17:00:00	ES	Futures	1267.49	1269.23	1267.49	1268.98	4163.0
2011-06-08 18:00:00	ES	Futures	1269.98	1271.22	1269.73	1270.97	7119.0
2011-06-08 19:00:00	ES	Futures	1270.97	1271.96	1270.47	1271.72	4052.0
2011-06-08 20:00:00	ES	Futures	1271.96	1271.96	1270.72	1271.72	4120.0
2011-06-08 21:00:00	ES	Futures	1271.96	1273.7	1271.72	1272.96	8544.0
2011-06-08 22:00:00	ES	Futures	1273.21	1273.45	1271.96	1272.96	3607.0
2011-06-08 23:00:00	ES	Futures	1273.21	1273.7	1271.22	1271.47	5781.0
2011-06-08 00:00:00	NQ	Futures	2605.37	2605.95	2603.93	2605.37	766.0
2011-06-08 01:00:00	NQ	Futures	2605.66	2607.67	2605.37	2606.23	373.0
2011-06-08 02:00:00	NQ	Futures	2605.95	2609.68	2605.08	2608.24	1191.0
2011-06-08 03:00:00	NQ	Futures	2608.24	2609.68	2599.91	2601.35	3506.0
2011-06-08 04:00:00	NQ	Futures	2601.35	2602.78	2594.74	2599.05	3631.0
2011-06-08 05:00:00	NQ	Futures	2598.76	2601.06	2596.75	2600.2	1216.0
2011-06-08 06:00:00	NQ	Futures	2599.62	2599.91	2592.15	2594.17	2620.0
2011-06-08 07:00:00	NQ	Futures	2593.59	2596.46	2593.02	2596.18	2030.0
2011-06-08 08:00:00	NQ	Futures	2596.18	2602.21	2593.3	2600.49	5066.0
2011-06-08 09:00:00	NQ	Futures	2600.2	2606.81	2592.15	2594.45	43924.0
2011-06-08 10:00:00	NQ	Futures	2594.17	2605.37	2593.3	2600.77	34292.0
2011-06-08 11:00:00	NQ	Futures	2601.06	2605.95	2593.02	2601.92	27322.0
2011-06-08 12:00:00	NQ	Futures	2601.92	2602.78	2594.17	2601.35	22612.0
2011-06-08 13:00:00	NQ	Futures	2601.35	2602.78	2582.1	2584.68	31842.0
2011-06-08 14:00:00	NQ	Futures	2584.97	2596.18	2583.82	2591.87	30244.0
2011-06-08 15:00:00	NQ	Futures	2591.87	2594.45	2583.25	2588.71	35413.0
2011-06-08 16:00:00	NQ	Futures	2588.71	2589.57	2580.66	2581.24	12090.0
2011-06-08 17:00:00	NQ	Futures	2581.24	2585.55	2581.24	2584.11	543.0
2011-06-08 18:00:00	NQ	Futures	2585.26	2587.56	2585.26	2587.27	380.0
2011-06-08 19:00:00	NQ	Futures	2587.27	2589.28	2586.12	2588.13	448.0
2011-06-08 20:00:00	NQ	Futures	2587.84	2589.28	2586.7	2588.99	283.0
2011-06-08 21:00:00	NQ	Futures	2588.71	2592.44	2588.71	2590.72	758.0
2011-06-08 22:00:00	NQ	Futures	2591.0	2591.29	2589.28	2591.29	265.0
2011-06-08 23:00:00	NQ	Futures	2590.72	2591.58	2587.27	2587.56	323.0
2011-06-08 00:00:00	YM	Futures	11609.3	11619.9	11608.3	11618.9	203.0
2011-06-08 01:00:00	YM	Futures	11619.9	11629.5	11617.0	11623.7	517.0

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

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