PREVIEW / futures_1hour / 2012-06-01

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-06-01.parquet
  size:    44 KB
  rows:    1,229

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-01 00:00:00	ES	Futures	1317.8	1319.06	1316.78	1319.06	2735.0
2012-06-01 01:00:00	ES	Futures	1318.81	1319.57	1318.3	1319.06	5554.0
2012-06-01 02:00:00	ES	Futures	1319.06	1320.07	1317.8	1319.31	10641.0
2012-06-01 03:00:00	ES	Futures	1319.57	1320.58	1316.28	1317.8	45260.0
2012-06-01 04:00:00	ES	Futures	1317.8	1317.8	1310.96	1311.22	55525.0
2012-06-01 05:00:00	ES	Futures	1311.22	1311.22	1307.68	1309.19	74305.0
2012-06-01 06:00:00	ES	Futures	1309.19	1310.21	1306.92	1309.95	46183.0
2012-06-01 07:00:00	ES	Futures	1309.7	1311.98	1308.44	1309.45	55712.0
2012-06-01 08:00:00	ES	Futures	1309.45	1310.71	1295.28	1301.1	311652.0
2012-06-01 09:00:00	ES	Futures	1301.1	1308.18	1298.82	1302.36	484327.0
2012-06-01 10:00:00	ES	Futures	1302.62	1307.17	1298.82	1299.33	536410.0
2012-06-01 11:00:00	ES	Futures	1299.58	1301.35	1296.54	1300.85	326844.0
2012-06-01 12:00:00	ES	Futures	1300.85	1302.62	1296.8	1297.81	183867.0
2012-06-01 13:00:00	ES	Futures	1297.81	1299.07	1293.26	1294.77	203598.0
2012-06-01 14:00:00	ES	Futures	1294.52	1297.56	1291.23	1293.26	233321.0
2012-06-01 15:00:00	ES	Futures	1293.51	1295.79	1290.73	1291.23	407988.0
2012-06-01 16:00:00	ES	Futures	1291.23	1291.99	1288.7	1288.96	186983.0
2012-06-01 00:00:00	NQ	Futures	2907.62	2909.94	2906.18	2909.94	333.0
2012-06-01 01:00:00	NQ	Futures	2909.94	2911.96	2908.2	2910.8	322.0
2012-06-01 02:00:00	NQ	Futures	2911.09	2912.83	2906.75	2909.65	1049.0
2012-06-01 03:00:00	NQ	Futures	2909.94	2912.83	2903.57	2908.78	4756.0
2012-06-01 04:00:00	NQ	Futures	2908.78	2908.78	2893.74	2894.61	6092.0
2012-06-01 05:00:00	NQ	Futures	2894.61	2894.61	2888.25	2890.85	7618.0
2012-06-01 06:00:00	NQ	Futures	2890.85	2891.14	2884.78	2889.98	5393.0
2012-06-01 07:00:00	NQ	Futures	2889.69	2893.16	2885.64	2889.4	6403.0
2012-06-01 08:00:00	NQ	Futures	2889.69	2893.16	2858.17	2869.74	26503.0
2012-06-01 09:00:00	NQ	Futures	2869.74	2886.8	2864.82	2875.81	59759.0
2012-06-01 10:00:00	NQ	Futures	2875.81	2884.78	2863.37	2867.42	67507.0
2012-06-01 11:00:00	NQ	Futures	2867.42	2868.29	2859.61	2863.37	36879.0
2012-06-01 12:00:00	NQ	Futures	2863.66	2867.71	2859.04	2859.61	18615.0
2012-06-01 13:00:00	NQ	Futures	2859.33	2861.35	2848.05	2851.23	25168.0
2012-06-01 14:00:00	NQ	Futures	2851.23	2856.43	2842.84	2848.63	34188.0
2012-06-01 15:00:00	NQ	Futures	2848.91	2857.01	2841.97	2842.84	43788.0
2012-06-01 16:00:00	NQ	Futures	2842.55	2846.6	2838.79	2839.66	12290.0
2012-06-01 00:00:00	YM	Futures	12295.3	12303.3	12289.4	12300.3	355.0
2012-06-01 01:00:00	YM	Futures	12301.3	12309.3	12297.3	12306.3	376.0
2012-06-01 02:00:00	YM	Futures	12306.3	12311.3	12296.3	12306.3	1156.0
2012-06-01 03:00:00	YM	Futures	12306.3	12314.3	12280.4	12292.3	4369.0
2012-06-01 04:00:00	YM	Futures	12291.3	12294.3	12240.5	12243.5	5681.0
2012-06-01 05:00:00	YM	Futures	12243.5	12245.5	12217.6	12234.6	6217.0
2012-06-01 06:00:00	YM	Futures	12233.6	12238.5	12216.6	12233.6	4439.0
2012-06-01 07:00:00	YM	Futures	12233.6	12249.5	12223.6	12231.6	4746.0
2012-06-01 08:00:00	YM	Futures	12231.6	12243.5	12116.0	12164.8	22838.0
2012-06-01 09:00:00	YM	Futures	12164.8	12201.7	12133.9	12149.9	40815.0
2012-06-01 10:00:00	YM	Futures	12152.9	12196.7	12112.0	12119.0	41069.0
2012-06-01 11:00:00	YM	Futures	12119.0	12138.9	12101.1	12134.9	24954.0
2012-06-01 12:00:00	YM	Futures	12133.9	12153.9	12106.0	12113.0	13875.0
2012-06-01 13:00:00	YM	Futures	12113.0	12127.0	12078.1	12088.1	13634.0
2012-06-01 14:00:00	YM	Futures	12089.1	12113.0	12055.2	12070.2	23026.0
2012-06-01 15:00:00	YM	Futures	12071.2	12091.1	12050.2	12060.2	26555.0

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

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