PREVIEW / futures_1hour / 2012-06-13

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-06-13.parquet
  size:    48 KB
  rows:    1,463

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-13 00:00:00	ES	Futures	1340.06	1340.06	1339.05	1339.81	569.0
2012-06-13 01:00:00	ES	Futures	1340.06	1340.56	1339.3	1339.55	478.0
2012-06-13 02:00:00	ES	Futures	1339.55	1341.58	1339.3	1339.81	1558.0
2012-06-13 03:00:00	ES	Futures	1339.55	1343.09	1338.29	1341.83	5009.0
2012-06-13 04:00:00	ES	Futures	1342.08	1342.33	1337.53	1338.54	4749.0
2012-06-13 05:00:00	ES	Futures	1338.54	1342.08	1337.53	1338.54	2855.0
2012-06-13 06:00:00	ES	Futures	1338.79	1341.32	1338.29	1338.79	2500.0
2012-06-13 07:00:00	ES	Futures	1338.79	1339.81	1336.77	1339.3	4686.0
2012-06-13 08:00:00	ES	Futures	1339.55	1339.81	1331.96	1335.5	12133.0
2012-06-13 09:00:00	ES	Futures	1335.76	1336.01	1330.7	1332.47	20853.0
2012-06-13 10:00:00	ES	Futures	1332.22	1343.09	1332.22	1341.83	30068.0
2012-06-13 11:00:00	ES	Futures	1342.08	1342.08	1337.53	1338.54	15487.0
2012-06-13 12:00:00	ES	Futures	1338.54	1343.6	1335.76	1341.32	17573.0
2012-06-13 13:00:00	ES	Futures	1341.07	1342.84	1337.53	1338.03	10509.0
2012-06-13 14:00:00	ES	Futures	1338.03	1338.79	1332.72	1333.48	12513.0
2012-06-13 15:00:00	ES	Futures	1332.97	1334.24	1325.89	1330.7	25694.0
2012-06-13 16:00:00	ES	Futures	1330.95	1332.47	1327.41	1328.93	9423.0
2012-06-13 17:00:00	ES	Futures	1328.93	1331.2	1328.93	1330.7	215.0
2012-06-13 18:00:00	ES	Futures	1330.7	1331.71	1329.69	1330.95	321.0
2012-06-13 19:00:00	ES	Futures	1330.95	1331.71	1329.69	1331.71	227.0
2012-06-13 20:00:00	ES	Futures	1331.71	1333.23	1330.44	1330.95	638.0
2012-06-13 21:00:00	ES	Futures	1330.95	1333.23	1330.44	1332.97	529.0
2012-06-13 22:00:00	ES	Futures	1332.97	1334.24	1332.22	1333.99	250.0
2012-06-13 23:00:00	ES	Futures	1334.24	1337.78	1333.48	1337.02	1119.0
2012-06-13 00:00:00	NQ	Futures	2946.38	2946.95	2945.8	2946.09	22.0
2012-06-13 01:00:00	NQ	Futures	2946.09	2947.82	2945.22	2945.22	37.0
2012-06-13 02:00:00	NQ	Futures	2945.51	2951.29	2944.64	2946.66	91.0
2012-06-13 03:00:00	NQ	Futures	2946.38	2953.32	2943.48	2952.45	292.0
2012-06-13 04:00:00	NQ	Futures	2951.0	2951.0	2939.15	2942.33	223.0
2012-06-13 05:00:00	NQ	Futures	2942.33	2948.98	2938.57	2942.9	134.0
2012-06-13 06:00:00	NQ	Futures	2942.33	2948.11	2942.33	2943.48	105.0
2012-06-13 07:00:00	NQ	Futures	2943.48	2945.22	2939.15	2945.22	262.0
2012-06-13 08:00:00	NQ	Futures	2945.22	2948.4	2932.78	2938.28	501.0
2012-06-13 09:00:00	NQ	Futures	2938.57	2945.8	2927.29	2932.2	2659.0
2012-06-13 10:00:00	NQ	Futures	2931.63	2958.81	2931.34	2957.08	2920.0
2012-06-13 11:00:00	NQ	Futures	2957.08	2958.52	2947.24	2948.69	1497.0
2012-06-13 12:00:00	NQ	Futures	2948.4	2955.63	2940.88	2951.0	1025.0
2012-06-13 13:00:00	NQ	Futures	2951.87	2955.05	2940.59	2942.33	1057.0
2012-06-13 14:00:00	NQ	Futures	2942.04	2944.06	2929.6	2931.34	1464.0
2012-06-13 15:00:00	NQ	Futures	2930.76	2933.36	2914.56	2924.4	3299.0
2012-06-13 16:00:00	NQ	Futures	2924.4	2929.02	2920.06	2922.08	476.0
2012-06-13 17:00:00	NQ	Futures	2924.4	2927.58	2924.4	2927.58	4.0
2012-06-13 18:00:00	NQ	Futures	2927.0	2928.44	2926.42	2926.71	14.0
2012-06-13 19:00:00	NQ	Futures	2927.0	2928.73	2925.55	2928.73	31.0
2012-06-13 20:00:00	NQ	Futures	2927.58	2931.34	2927.0	2929.02	61.0
2012-06-13 21:00:00	NQ	Futures	2929.02	2931.92	2927.0	2930.76	77.0
2012-06-13 22:00:00	NQ	Futures	2931.63	2933.07	2930.76	2933.07	19.0
2012-06-13 23:00:00	NQ	Futures	2933.07	2941.46	2933.07	2939.72	79.0
2012-06-13 00:00:00	YM	Futures	12429.0	12431.0	12425.1	12427.0	197.0
2012-06-13 01:00:00	YM	Futures	12428.0	12436.0	12425.1	12426.1	393.0

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

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