PREVIEW / futures_1hour / 2012-07-06

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-07-06.parquet
  size:    41 KB
  rows:    1,196

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-07-06 00:00:00	ES	Futures	1382.54	1383.05	1380.76	1381.78	3686.0
2012-07-06 01:00:00	ES	Futures	1381.78	1384.06	1381.27	1382.54	4012.0
2012-07-06 02:00:00	ES	Futures	1382.54	1384.32	1382.28	1382.54	5834.0
2012-07-06 03:00:00	ES	Futures	1382.28	1383.81	1381.52	1383.3	23843.0
2012-07-06 04:00:00	ES	Futures	1383.56	1384.32	1382.28	1382.79	13856.0
2012-07-06 05:00:00	ES	Futures	1383.05	1383.3	1381.27	1382.03	16086.0
2012-07-06 06:00:00	ES	Futures	1382.03	1383.81	1381.78	1382.54	11970.0
2012-07-06 07:00:00	ES	Futures	1382.54	1384.06	1380.76	1382.28	21663.0
2012-07-06 08:00:00	ES	Futures	1382.03	1382.79	1372.62	1373.89	183120.0
2012-07-06 09:00:00	ES	Futures	1373.89	1375.93	1370.59	1373.13	292802.0
2012-07-06 10:00:00	ES	Futures	1372.88	1373.64	1369.32	1369.57	309883.0
2012-07-06 11:00:00	ES	Futures	1369.57	1371.35	1367.03	1367.54	242235.0
2012-07-06 12:00:00	ES	Futures	1367.79	1370.33	1366.26	1370.33	154930.0
2012-07-06 13:00:00	ES	Futures	1370.08	1371.1	1366.77	1367.79	87747.0
2012-07-06 14:00:00	ES	Futures	1367.54	1368.81	1365.25	1368.04	98766.0
2012-07-06 15:00:00	ES	Futures	1368.04	1374.15	1367.54	1372.37	359174.0
2012-07-06 16:00:00	ES	Futures	1372.37	1375.67	1371.86	1375.67	92062.0
2012-07-06 00:00:00	NQ	Futures	3057.71	3058.58	3055.39	3055.97	337.0
2012-07-06 01:00:00	NQ	Futures	3056.26	3060.61	3055.39	3057.13	422.0
2012-07-06 02:00:00	NQ	Futures	3057.71	3060.61	3056.84	3057.42	419.0
2012-07-06 03:00:00	NQ	Futures	3057.13	3060.9	3055.68	3060.32	2809.0
2012-07-06 04:00:00	NQ	Futures	3060.03	3063.21	3058.0	3059.45	2041.0
2012-07-06 05:00:00	NQ	Futures	3059.74	3060.32	3056.55	3058.87	1956.0
2012-07-06 06:00:00	NQ	Futures	3058.87	3062.05	3058.0	3059.45	1870.0
2012-07-06 07:00:00	NQ	Futures	3059.45	3062.92	3058.29	3060.9	2421.0
2012-07-06 08:00:00	NQ	Futures	3060.61	3061.76	3044.95	3047.27	14958.0
2012-07-06 09:00:00	NQ	Futures	3047.27	3055.1	3027.85	3034.52	51760.0
2012-07-06 10:00:00	NQ	Futures	3034.52	3035.39	3015.96	3018.86	45114.0
2012-07-06 11:00:00	NQ	Futures	3018.86	3021.18	3010.75	3011.9	27389.0
2012-07-06 12:00:00	NQ	Futures	3011.9	3014.51	3006.69	3014.51	21567.0
2012-07-06 13:00:00	NQ	Futures	3014.22	3017.7	3007.56	3009.01	12351.0
2012-07-06 14:00:00	NQ	Futures	3009.01	3012.77	3003.79	3011.9	12694.0
2012-07-06 15:00:00	NQ	Futures	3011.61	3024.66	3009.01	3024.08	44972.0
2012-07-06 16:00:00	NQ	Futures	3024.08	3026.98	3023.21	3026.69	6952.0
2012-07-06 00:00:00	YM	Futures	12738.3	12741.3	12731.3	12737.3	644.0
2012-07-06 01:00:00	YM	Futures	12737.3	12755.2	12734.3	12743.3	451.0
2012-07-06 02:00:00	YM	Futures	12744.3	12755.2	12742.3	12742.3	386.0
2012-07-06 03:00:00	YM	Futures	12741.3	12751.2	12736.3	12748.2	2286.0
2012-07-06 04:00:00	YM	Futures	12747.2	12755.2	12740.3	12744.3	1461.0
2012-07-06 05:00:00	YM	Futures	12745.3	12746.3	12735.3	12739.3	1418.0
2012-07-06 06:00:00	YM	Futures	12740.3	12750.2	12737.3	12743.3	1186.0
2012-07-06 07:00:00	YM	Futures	12744.3	12759.2	12739.3	12749.2	4076.0
2012-07-06 08:00:00	YM	Futures	12748.2	12751.2	12669.7	12677.6	12392.0
2012-07-06 09:00:00	YM	Futures	12677.6	12693.5	12626.9	12643.8	27242.0
2012-07-06 10:00:00	YM	Futures	12643.8	12650.8	12601.1	12604.1	22571.0
2012-07-06 11:00:00	YM	Futures	12605.0	12617.0	12580.2	12585.2	14734.0
2012-07-06 12:00:00	YM	Futures	12584.2	12609.0	12569.2	12605.0	12142.0
2012-07-06 13:00:00	YM	Futures	12605.0	12615.0	12586.2	12592.1	5949.0
2012-07-06 14:00:00	YM	Futures	12592.1	12606.0	12576.2	12600.1	5885.0
2012-07-06 15:00:00	YM	Futures	12599.1	12652.8	12595.1	12634.9	24734.0

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

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