PREVIEW / futures_1hour / 2012-06-12

all futures 1-hour files

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

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-12 00:00:00	ES	Futures	1328.67	1329.69	1327.91	1328.42	1810.0
2012-06-12 01:00:00	ES	Futures	1328.67	1328.67	1326.65	1327.91	1493.0
2012-06-12 02:00:00	ES	Futures	1328.17	1329.43	1327.16	1327.91	3573.0
2012-06-12 03:00:00	ES	Futures	1327.91	1331.2	1326.9	1328.17	10888.0
2012-06-12 04:00:00	ES	Futures	1327.91	1331.2	1323.87	1330.95	10448.0
2012-06-12 05:00:00	ES	Futures	1330.95	1331.46	1326.14	1328.93	5743.0
2012-06-12 06:00:00	ES	Futures	1329.18	1331.46	1328.42	1328.67	5316.0
2012-06-12 07:00:00	ES	Futures	1328.93	1329.18	1325.89	1326.4	5444.0
2012-06-12 08:00:00	ES	Futures	1326.65	1328.93	1324.37	1326.65	10846.0
2012-06-12 09:00:00	ES	Futures	1326.65	1330.95	1324.63	1327.41	38056.0
2012-06-12 10:00:00	ES	Futures	1327.66	1331.2	1321.34	1326.14	47820.0
2012-06-12 11:00:00	ES	Futures	1326.4	1336.26	1326.14	1332.22	29689.0
2012-06-12 12:00:00	ES	Futures	1331.96	1333.73	1329.69	1330.19	12942.0
2012-06-12 13:00:00	ES	Futures	1330.44	1334.49	1329.69	1331.96	13947.0
2012-06-12 14:00:00	ES	Futures	1331.96	1336.01	1330.7	1334.24	9868.0
2012-06-12 15:00:00	ES	Futures	1334.24	1340.06	1332.97	1339.3	25388.0
2012-06-12 16:00:00	ES	Futures	1339.55	1343.09	1339.05	1340.82	15732.0
2012-06-12 17:00:00	ES	Futures	1341.07	1341.58	1340.56	1341.07	583.0
2012-06-12 18:00:00	ES	Futures	1340.56	1341.07	1340.06	1340.82	777.0
2012-06-12 19:00:00	ES	Futures	1340.82	1341.58	1340.06	1340.31	298.0
2012-06-12 20:00:00	ES	Futures	1340.31	1340.82	1338.29	1338.79	1305.0
2012-06-12 21:00:00	ES	Futures	1338.54	1339.81	1337.02	1338.29	1252.0
2012-06-12 22:00:00	ES	Futures	1338.29	1338.79	1337.02	1338.79	1018.0
2012-06-12 23:00:00	ES	Futures	1338.79	1340.31	1338.79	1340.31	533.0
2012-06-12 00:00:00	NQ	Futures	2922.95	2924.69	2921.5	2922.37	40.0
2012-06-12 01:00:00	NQ	Futures	2922.08	2922.08	2918.9	2920.93	121.0
2012-06-12 02:00:00	NQ	Futures	2920.93	2924.97	2920.35	2922.95	347.0
2012-06-12 03:00:00	NQ	Futures	2924.11	2931.05	2922.08	2923.82	573.0
2012-06-12 04:00:00	NQ	Futures	2924.11	2930.47	2915.14	2929.02	524.0
2012-06-12 05:00:00	NQ	Futures	2929.31	2930.76	2919.19	2926.13	473.0
2012-06-12 06:00:00	NQ	Futures	2927.29	2930.47	2923.53	2924.97	338.0
2012-06-12 07:00:00	NQ	Futures	2925.55	2925.55	2918.61	2918.61	471.0
2012-06-12 08:00:00	NQ	Futures	2918.61	2924.4	2914.85	2920.64	532.0
2012-06-12 09:00:00	NQ	Futures	2921.21	2931.34	2917.46	2922.37	6069.0
2012-06-12 10:00:00	NQ	Futures	2922.66	2927.29	2903.86	2915.43	7517.0
2012-06-12 11:00:00	NQ	Futures	2915.14	2941.75	2915.14	2934.23	4805.0
2012-06-12 12:00:00	NQ	Futures	2934.52	2939.72	2923.53	2925.26	1811.0
2012-06-12 13:00:00	NQ	Futures	2925.26	2934.23	2924.11	2927.58	1655.0
2012-06-12 14:00:00	NQ	Futures	2928.16	2937.41	2925.55	2932.49	1689.0
2012-06-12 15:00:00	NQ	Futures	2932.78	2946.38	2929.89	2944.93	2696.0
2012-06-12 16:00:00	NQ	Futures	2944.06	2951.87	2943.77	2946.95	1112.0
2012-06-12 17:00:00	NQ	Futures	2946.95	2946.95	2946.95	2946.95	3.0
2012-06-12 18:00:00	NQ	Futures	2937.41	2947.82	2937.41	2947.24	45.0
2012-06-12 19:00:00	NQ	Futures	2947.24	2948.11	2945.51	2948.11	15.0
2012-06-12 20:00:00	NQ	Futures	2946.09	2946.66	2943.19	2944.93	103.0
2012-06-12 21:00:00	NQ	Futures	2944.35	2945.51	2941.17	2941.75	55.0
2012-06-12 22:00:00	NQ	Futures	2942.9	2944.64	2940.88	2944.64	42.0
2012-06-12 23:00:00	NQ	Futures	2944.06	2947.24	2943.77	2947.24	42.0
2012-06-12 00:00:00	YM	Futures	12293.8	12300.8	12288.8	12295.8	631.0
2012-06-12 01:00:00	YM	Futures	12295.8	12295.8	12280.9	12290.8	383.0

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

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