PREVIEW / futures_1hour / 2012-08-31

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-08-31.parquet
  size:    40 KB
  rows:    1,162

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-08-31 00:00:00	ES	Futures	1422.21	1422.72	1421.19	1421.44	2977.0
2012-08-31 01:00:00	ES	Futures	1421.19	1421.95	1420.43	1421.95	3665.0
2012-08-31 02:00:00	ES	Futures	1421.95	1423.22	1420.94	1422.72	6667.0
2012-08-31 03:00:00	ES	Futures	1422.46	1423.99	1421.19	1423.48	17121.0
2012-08-31 04:00:00	ES	Futures	1423.73	1425.51	1423.73	1425.51	21015.0
2012-08-31 05:00:00	ES	Futures	1425.26	1426.78	1425.0	1426.28	16077.0
2012-08-31 06:00:00	ES	Futures	1426.02	1430.34	1425.77	1429.07	36854.0
2012-08-31 07:00:00	ES	Futures	1429.33	1430.6	1428.82	1429.84	27041.0
2012-08-31 08:00:00	ES	Futures	1429.84	1436.45	1429.07	1433.14	80298.0
2012-08-31 09:00:00	ES	Futures	1433.4	1433.65	1429.84	1430.09	161782.0
2012-08-31 10:00:00	ES	Futures	1429.84	1434.41	1420.94	1433.65	680204.0
2012-08-31 11:00:00	ES	Futures	1433.65	1435.94	1432.12	1432.12	208362.0
2012-08-31 12:00:00	ES	Futures	1432.38	1432.89	1425.77	1428.31	176547.0
2012-08-31 13:00:00	ES	Futures	1428.31	1429.07	1424.5	1427.8	103987.0
2012-08-31 14:00:00	ES	Futures	1428.06	1432.12	1427.55	1430.6	101024.0
2012-08-31 15:00:00	ES	Futures	1430.6	1432.38	1426.78	1429.07	247604.0
2012-08-31 16:00:00	ES	Futures	1429.07	1430.6	1427.04	1428.82	123385.0
2012-08-31 00:00:00	NQ	Futures	3197.43	3198.01	3195.11	3195.11	475.0
2012-08-31 01:00:00	NQ	Futures	3195.4	3195.98	3193.08	3195.98	309.0
2012-08-31 02:00:00	NQ	Futures	3195.69	3198.59	3193.95	3197.43	529.0
2012-08-31 03:00:00	NQ	Futures	3197.14	3200.04	3194.24	3199.46	2170.0
2012-08-31 04:00:00	NQ	Futures	3199.46	3204.1	3199.46	3204.1	3258.0
2012-08-31 05:00:00	NQ	Futures	3204.39	3208.16	3203.81	3207.0	3189.0
2012-08-31 06:00:00	NQ	Futures	3206.71	3217.72	3206.13	3216.27	7122.0
2012-08-31 07:00:00	NQ	Futures	3216.27	3217.72	3213.37	3214.82	5652.0
2012-08-31 08:00:00	NQ	Futures	3214.82	3226.13	3214.24	3224.68	9847.0
2012-08-31 09:00:00	NQ	Futures	3224.68	3225.26	3206.42	3206.71	40619.0
2012-08-31 10:00:00	NQ	Futures	3206.71	3220.33	3183.23	3220.04	87778.0
2012-08-31 11:00:00	NQ	Futures	3220.04	3229.61	3215.98	3215.98	33068.0
2012-08-31 12:00:00	NQ	Futures	3216.27	3218.01	3203.81	3210.77	24613.0
2012-08-31 13:00:00	NQ	Futures	3210.77	3211.64	3200.91	3208.74	13701.0
2012-08-31 14:00:00	NQ	Futures	3209.03	3220.04	3207.87	3216.85	15469.0
2012-08-31 15:00:00	NQ	Futures	3216.85	3219.75	3206.42	3214.53	32535.0
2012-08-31 16:00:00	NQ	Futures	3214.24	3217.14	3206.13	3212.51	9952.0
2012-08-31 00:00:00	YM	Futures	12923.3	12929.2	12917.3	12918.3	224.0
2012-08-31 01:00:00	YM	Futures	12917.3	12921.3	12910.3	12920.3	258.0
2012-08-31 02:00:00	YM	Futures	12919.3	12931.2	12914.3	12927.2	346.0
2012-08-31 03:00:00	YM	Futures	12925.2	12937.2	12915.3	12934.2	1084.0
2012-08-31 04:00:00	YM	Futures	12934.2	12949.1	12934.2	12947.1	1217.0
2012-08-31 05:00:00	YM	Futures	12948.1	12955.1	12943.1	12950.1	964.0
2012-08-31 06:00:00	YM	Futures	12949.1	12992.9	12946.1	12982.9	3148.0
2012-08-31 07:00:00	YM	Futures	12983.9	12998.8	12981.9	12986.9	1671.0
2012-08-31 08:00:00	YM	Futures	12987.9	13027.7	12985.9	13021.7	4693.0
2012-08-31 09:00:00	YM	Futures	13021.7	13041.6	12989.9	13012.8	17116.0
2012-08-31 10:00:00	YM	Futures	13012.8	13059.5	12935.2	13056.5	55321.0
2012-08-31 11:00:00	YM	Futures	13056.5	13070.4	13035.6	13041.6	17881.0
2012-08-31 12:00:00	YM	Futures	13042.6	13046.6	12979.9	12997.8	13797.0
2012-08-31 13:00:00	YM	Futures	12997.8	13005.8	12965.0	12996.8	9087.0
2012-08-31 14:00:00	YM	Futures	12996.8	13039.6	12995.8	13021.7	9258.0
2012-08-31 15:00:00	YM	Futures	13021.7	13040.6	12981.9	13013.7	15855.0

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

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