PREVIEW / futures_1hour / 2012-06-28

all futures 1-hour files

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

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-28 00:00:00	ES	Futures	1349.23	1349.48	1348.21	1349.23	2025.0
2012-06-28 01:00:00	ES	Futures	1349.23	1349.74	1348.47	1349.48	3227.0
2012-06-28 02:00:00	ES	Futures	1349.48	1350.25	1348.47	1348.97	7549.0
2012-06-28 03:00:00	ES	Futures	1348.97	1349.74	1341.85	1343.13	52224.0
2012-06-28 04:00:00	ES	Futures	1342.87	1343.13	1338.29	1340.84	50842.0
2012-06-28 05:00:00	ES	Futures	1341.09	1342.87	1338.29	1339.31	33944.0
2012-06-28 06:00:00	ES	Futures	1339.31	1342.62	1337.79	1341.6	33718.0
2012-06-28 07:00:00	ES	Futures	1341.85	1347.7	1340.07	1341.09	93413.0
2012-06-28 08:00:00	ES	Futures	1341.09	1342.36	1339.31	1340.33	53825.0
2012-06-28 09:00:00	ES	Futures	1340.33	1342.11	1336.77	1339.57	245334.0
2012-06-28 10:00:00	ES	Futures	1339.57	1341.35	1330.41	1332.19	528872.0
2012-06-28 11:00:00	ES	Futures	1332.19	1336.51	1330.41	1334.73	221455.0
2012-06-28 12:00:00	ES	Futures	1334.99	1336.26	1332.7	1334.73	110685.0
2012-06-28 13:00:00	ES	Futures	1334.73	1335.75	1330.92	1333.72	138216.0
2012-06-28 14:00:00	ES	Futures	1333.72	1334.23	1329.14	1332.45	126756.0
2012-06-28 15:00:00	ES	Futures	1332.45	1346.94	1332.19	1344.65	465986.0
2012-06-28 16:00:00	ES	Futures	1344.91	1346.69	1342.36	1342.62	101908.0
2012-06-28 17:00:00	ES	Futures	1342.87	1343.63	1341.85	1343.63	3621.0
2012-06-28 18:00:00	ES	Futures	1343.63	1343.63	1340.58	1341.6	6647.0
2012-06-28 19:00:00	ES	Futures	1341.35	1341.35	1338.55	1340.33	9445.0
2012-06-28 20:00:00	ES	Futures	1340.33	1341.6	1338.8	1340.84	6323.0
2012-06-28 21:00:00	ES	Futures	1341.09	1343.63	1340.33	1343.13	6383.0
2012-06-28 22:00:00	ES	Futures	1343.13	1359.4	1342.62	1357.62	31442.0
2012-06-28 23:00:00	ES	Futures	1357.87	1364.99	1354.82	1360.42	44334.0
2012-06-28 00:00:00	NQ	Futures	2969.58	2970.74	2967.26	2969.87	346.0
2012-06-28 01:00:00	NQ	Futures	2970.74	2972.19	2970.16	2971.9	258.0
2012-06-28 02:00:00	NQ	Futures	2972.19	2973.93	2971.32	2971.9	702.0
2012-06-28 03:00:00	NQ	Futures	2971.9	2972.77	2953.64	2957.41	5477.0
2012-06-28 04:00:00	NQ	Futures	2957.41	2957.41	2945.81	2951.03	5025.0
2012-06-28 05:00:00	NQ	Futures	2951.32	2955.09	2946.68	2948.71	2330.0
2012-06-28 06:00:00	NQ	Futures	2948.42	2954.51	2944.94	2952.48	2509.0
2012-06-28 07:00:00	NQ	Futures	2952.48	2964.07	2949.58	2951.9	8502.0
2012-06-28 08:00:00	NQ	Futures	2951.9	2953.93	2947.26	2949.0	4909.0
2012-06-28 09:00:00	NQ	Futures	2949.0	2949.58	2925.81	2940.88	43549.0
2012-06-28 10:00:00	NQ	Futures	2941.17	2942.04	2913.92	2918.56	52995.0
2012-06-28 11:00:00	NQ	Futures	2918.27	2926.1	2914.5	2921.17	24223.0
2012-06-28 12:00:00	NQ	Futures	2920.88	2924.94	2915.08	2918.85	17384.0
2012-06-28 13:00:00	NQ	Futures	2918.85	2920.88	2906.97	2914.5	18691.0
2012-06-28 14:00:00	NQ	Futures	2914.5	2915.37	2902.91	2908.13	16518.0
2012-06-28 15:00:00	NQ	Futures	2908.42	2937.69	2907.55	2934.22	51983.0
2012-06-28 16:00:00	NQ	Futures	2934.51	2936.53	2928.42	2928.71	6874.0
2012-06-28 17:00:00	NQ	Futures	2928.71	2930.16	2927.26	2930.16	158.0
2012-06-28 18:00:00	NQ	Futures	2930.45	2931.9	2924.94	2927.26	409.0
2012-06-28 19:00:00	NQ	Futures	2926.97	2926.97	2921.46	2924.07	567.0
2012-06-28 20:00:00	NQ	Futures	2924.07	2927.26	2920.59	2925.52	1022.0
2012-06-28 21:00:00	NQ	Futures	2925.81	2930.74	2924.07	2930.16	525.0
2012-06-28 22:00:00	NQ	Futures	2930.16	2962.62	2928.71	2958.57	3204.0
2012-06-28 23:00:00	NQ	Futures	2958.28	2972.19	2954.51	2965.23	6859.0
2012-06-28 00:00:00	YM	Futures	12487.7	12493.7	12481.7	12489.7	354.0
2012-06-28 01:00:00	YM	Futures	12490.7	12491.7	12482.7	12490.7	172.0

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

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