PREVIEW / futures_1hour / 2012-12-31

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-12-31.parquet
  size:    35 KB
  rows:    966

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-12-31 00:00:00	ES	Futures	1424.08	1424.59	1423.05	1424.08	1290.0
2012-12-31 01:00:00	ES	Futures	1424.08	1425.88	1423.57	1425.36	1573.0
2012-12-31 02:00:00	ES	Futures	1425.62	1426.13	1425.11	1425.62	1669.0
2012-12-31 03:00:00	ES	Futures	1425.62	1427.93	1425.62	1427.93	7093.0
2012-12-31 04:00:00	ES	Futures	1427.67	1427.93	1424.59	1424.85	4183.0
2012-12-31 05:00:00	ES	Futures	1424.59	1425.62	1423.82	1425.62	3152.0
2012-12-31 06:00:00	ES	Futures	1425.36	1426.9	1424.59	1426.39	4951.0
2012-12-31 07:00:00	ES	Futures	1426.39	1426.39	1421.0	1425.36	12608.0
2012-12-31 08:00:00	ES	Futures	1425.36	1434.34	1424.59	1432.55	47822.0
2012-12-31 09:00:00	ES	Futures	1432.29	1439.48	1428.96	1437.94	149556.0
2012-12-31 10:00:00	ES	Futures	1438.19	1441.27	1435.37	1436.4	163455.0
2012-12-31 11:00:00	ES	Futures	1436.65	1441.27	1436.14	1437.42	117189.0
2012-12-31 12:00:00	ES	Futures	1437.42	1448.71	1436.91	1443.58	142375.0
2012-12-31 13:00:00	ES	Futures	1443.58	1450.51	1440.25	1443.32	185972.0
2012-12-31 14:00:00	ES	Futures	1443.58	1455.9	1442.56	1454.61	138847.0
2012-12-31 15:00:00	ES	Futures	1454.87	1460.52	1448.2	1458.98	306654.0
2012-12-31 16:00:00	ES	Futures	1459.23	1463.34	1457.69	1460.52	130130.0
2012-12-31 17:00:00	ES	Futures	1460.77	1461.54	1459.75	1461.29	2343.0
2012-12-31 00:00:00	NQ	Futures	3011.11	3011.98	3009.65	3011.98	273.0
2012-12-31 01:00:00	NQ	Futures	3011.69	3014.02	3010.82	3012.27	153.0
2012-12-31 02:00:00	NQ	Futures	3012.56	3013.44	3011.11	3012.86	217.0
2012-12-31 03:00:00	NQ	Futures	3013.15	3016.64	3011.98	3016.35	917.0
2012-12-31 04:00:00	NQ	Futures	3016.06	3016.93	3010.53	3010.53	423.0
2012-12-31 05:00:00	NQ	Futures	3010.53	3014.6	3010.24	3014.02	425.0
2012-12-31 06:00:00	NQ	Futures	3014.02	3016.93	3010.82	3011.98	459.0
2012-12-31 07:00:00	NQ	Futures	3011.98	3012.27	3005.29	3010.82	1103.0
2012-12-31 08:00:00	NQ	Futures	3010.82	3031.48	3009.95	3028.28	5484.0
2012-12-31 09:00:00	NQ	Futures	3028.57	3055.35	3018.39	3051.86	26918.0
2012-12-31 10:00:00	NQ	Futures	3051.86	3059.72	3045.75	3047.49	21905.0
2012-12-31 11:00:00	NQ	Futures	3047.78	3057.1	3044.0	3049.24	14415.0
2012-12-31 12:00:00	NQ	Futures	3049.53	3074.56	3045.46	3063.21	20442.0
2012-12-31 13:00:00	NQ	Futures	3063.5	3078.35	3054.77	3062.34	24382.0
2012-12-31 14:00:00	NQ	Futures	3062.63	3096.98	3060.59	3092.9	23449.0
2012-12-31 15:00:00	NQ	Futures	3092.9	3099.01	3078.06	3092.32	41743.0
2012-12-31 16:00:00	NQ	Futures	3092.32	3102.8	3089.99	3095.81	11757.0
2012-12-31 17:00:00	NQ	Futures	3095.81	3097.85	3095.23	3096.1	156.0
2012-12-31 00:00:00	YM	Futures	12878.1	12878.1	12847.9	12867.1	693.0
2012-12-31 01:00:00	YM	Futures	12866.1	12881.1	12865.0	12876.1	253.0
2012-12-31 02:00:00	YM	Futures	12877.1	12879.1	12872.1	12878.1	190.0
2012-12-31 03:00:00	YM	Futures	12878.1	12893.2	12877.1	12893.2	402.0
2012-12-31 04:00:00	YM	Futures	12893.2	12896.2	12877.1	12877.1	409.0
2012-12-31 05:00:00	YM	Futures	12876.1	12879.1	12870.1	12879.1	143.0
2012-12-31 06:00:00	YM	Futures	12880.1	12889.2	12874.1	12883.2	322.0
2012-12-31 07:00:00	YM	Futures	12881.1	12883.2	12848.9	12881.1	917.0
2012-12-31 08:00:00	YM	Futures	12880.1	12952.6	12874.1	12934.5	3762.0
2012-12-31 09:00:00	YM	Futures	12934.5	12965.6	12890.2	12948.5	15702.0
2012-12-31 10:00:00	YM	Futures	12947.5	12972.7	12924.4	12935.5	13487.0
2012-12-31 11:00:00	YM	Futures	12934.5	12971.7	12934.5	12940.5	9371.0
2012-12-31 12:00:00	YM	Futures	12941.5	13044.1	12939.5	13000.9	12494.0
2012-12-31 13:00:00	YM	Futures	13000.9	13050.2	12958.6	12983.8	20092.0

> showing 50 of 966 rows — these rows as CSV

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