PREVIEW / futures_1hour / 2012-06-14

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-06-14.parquet
  size:    49 KB
  rows:    1,491

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
2012-06-14 00:00:00	ES	Futures	1337.02	1337.79	1336.51	1337.02	2346.0
2012-06-14 01:00:00	ES	Futures	1337.28	1337.53	1335.24	1336.77	3443.0
2012-06-14 02:00:00	ES	Futures	1336.51	1337.28	1333.97	1334.73	9340.0
2012-06-14 03:00:00	ES	Futures	1334.99	1337.53	1332.7	1334.48	39974.0
2012-06-14 04:00:00	ES	Futures	1334.73	1334.99	1329.9	1331.43	48135.0
2012-06-14 05:00:00	ES	Futures	1331.43	1332.7	1329.39	1330.92	35928.0
2012-06-14 06:00:00	ES	Futures	1330.92	1335.75	1330.16	1333.97	35201.0
2012-06-14 07:00:00	ES	Futures	1333.97	1334.73	1329.39	1331.17	40866.0
2012-06-14 08:00:00	ES	Futures	1331.17	1336.01	1327.87	1333.72	122205.0
2012-06-14 09:00:00	ES	Futures	1333.97	1337.53	1329.65	1337.28	315092.0
2012-06-14 10:00:00	ES	Futures	1337.28	1341.09	1335.75	1340.33	357101.0
2012-06-14 11:00:00	ES	Futures	1340.33	1342.87	1339.31	1340.33	293384.0
2012-06-14 12:00:00	ES	Futures	1340.33	1343.13	1339.57	1342.11	169562.0
2012-06-14 13:00:00	ES	Futures	1342.36	1343.89	1340.07	1341.35	148217.0
2012-06-14 14:00:00	ES	Futures	1341.35	1342.87	1336.77	1337.02	133722.0
2012-06-14 15:00:00	ES	Futures	1336.77	1350.5	1336.51	1345.41	601129.0
2012-06-14 16:00:00	ES	Futures	1345.41	1350.5	1344.91	1349.99	119414.0
2012-06-14 17:00:00	ES	Futures	1349.99	1350.25	1348.72	1348.97	3589.0
2012-06-14 18:00:00	ES	Futures	1348.72	1349.23	1347.7	1348.72	5211.0
2012-06-14 19:00:00	ES	Futures	1348.72	1348.72	1347.96	1348.21	2084.0
2012-06-14 20:00:00	ES	Futures	1348.21	1348.72	1347.19	1347.96	7017.0
2012-06-14 21:00:00	ES	Futures	1347.96	1350.25	1347.45	1349.99	3723.0
2012-06-14 22:00:00	ES	Futures	1349.74	1351.77	1349.48	1349.99	4815.0
2012-06-14 23:00:00	ES	Futures	1349.74	1351.01	1349.23	1350.25	1880.0
2012-06-14 00:00:00	NQ	Futures	2939.72	2942.33	2939.43	2940.88	363.0
2012-06-14 01:00:00	NQ	Futures	2941.17	2941.17	2937.4	2940.01	419.0
2012-06-14 02:00:00	NQ	Futures	2939.72	2942.04	2934.51	2936.53	1055.0
2012-06-14 03:00:00	NQ	Futures	2936.24	2942.04	2931.9	2936.24	6295.0
2012-06-14 04:00:00	NQ	Futures	2935.95	2937.11	2925.81	2929.0	5206.0
2012-06-14 05:00:00	NQ	Futures	2928.71	2930.45	2921.17	2924.36	5682.0
2012-06-14 06:00:00	NQ	Futures	2924.36	2933.93	2922.33	2928.42	5144.0
2012-06-14 07:00:00	NQ	Futures	2928.13	2931.32	2922.33	2925.52	5608.0
2012-06-14 08:00:00	NQ	Futures	2925.23	2934.22	2918.56	2931.32	16476.0
2012-06-14 09:00:00	NQ	Futures	2931.03	2933.06	2909.29	2930.45	40581.0
2012-06-14 10:00:00	NQ	Futures	2930.45	2941.17	2926.97	2939.14	49818.0
2012-06-14 11:00:00	NQ	Futures	2939.43	2946.39	2935.66	2940.59	30084.0
2012-06-14 12:00:00	NQ	Futures	2940.59	2944.65	2938.85	2942.91	16086.0
2012-06-14 13:00:00	NQ	Futures	2942.62	2944.36	2933.06	2935.38	17704.0
2012-06-14 14:00:00	NQ	Futures	2935.38	2937.4	2917.98	2918.27	19546.0
2012-06-14 15:00:00	NQ	Futures	2918.27	2948.42	2917.4	2937.98	70907.0
2012-06-14 16:00:00	NQ	Futures	2937.69	2944.65	2935.09	2943.49	9694.0
2012-06-14 17:00:00	NQ	Futures	2944.07	2944.36	2941.46	2941.75	139.0
2012-06-14 18:00:00	NQ	Futures	2942.04	2942.33	2940.01	2941.46	254.0
2012-06-14 19:00:00	NQ	Futures	2941.46	2942.33	2940.3	2940.88	169.0
2012-06-14 20:00:00	NQ	Futures	2940.59	2941.17	2937.69	2938.56	556.0
2012-06-14 21:00:00	NQ	Futures	2939.43	2943.49	2937.98	2942.91	496.0
2012-06-14 22:00:00	NQ	Futures	2943.2	2946.97	2942.33	2942.91	512.0
2012-06-14 23:00:00	NQ	Futures	2942.62	2945.52	2941.46	2944.07	355.0
2012-06-14 00:00:00	YM	Futures	12406.2	12414.1	12406.2	12410.1	127.0
2012-06-14 01:00:00	YM	Futures	12409.2	12409.2	12392.2	12402.2	337.0

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

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