PREVIEW / futures_1hour / 2012-09-03

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-09-03.parquet
  size:    32 KB
  rows:    969

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-09-03 00:00:00	ES	Futures	1427.04	1428.31	1426.53	1428.06	2171.0
2012-09-03 01:00:00	ES	Futures	1428.06	1428.56	1425.26	1425.77	3165.0
2012-09-03 02:00:00	ES	Futures	1426.02	1426.78	1425.51	1426.02	5281.0
2012-09-03 03:00:00	ES	Futures	1426.02	1432.12	1425.26	1430.34	26281.0
2012-09-03 04:00:00	ES	Futures	1430.34	1431.11	1428.56	1429.33	16530.0
2012-09-03 05:00:00	ES	Futures	1429.33	1430.34	1428.06	1429.58	10433.0
2012-09-03 06:00:00	ES	Futures	1429.58	1431.11	1429.07	1429.84	8907.0
2012-09-03 07:00:00	ES	Futures	1429.84	1430.09	1428.56	1429.84	5582.0
2012-09-03 08:00:00	ES	Futures	1429.58	1431.62	1429.07	1431.11	8276.0
2012-09-03 09:00:00	ES	Futures	1431.11	1431.87	1429.33	1429.58	12888.0
2012-09-03 10:00:00	ES	Futures	1429.58	1430.85	1429.58	1430.09	8010.0
2012-09-03 11:00:00	ES	Futures	1430.09	1433.65	1430.09	1432.63	12104.0
2012-09-03 18:00:00	ES	Futures	1432.89	1432.89	1430.6	1430.6	3777.0
2012-09-03 19:00:00	ES	Futures	1430.6	1431.36	1430.34	1430.34	2022.0
2012-09-03 20:00:00	ES	Futures	1430.34	1430.6	1428.82	1430.6	6516.0
2012-09-03 21:00:00	ES	Futures	1430.6	1432.89	1430.34	1431.87	6144.0
2012-09-03 22:00:00	ES	Futures	1431.87	1433.4	1431.36	1431.87	4027.0
2012-09-03 23:00:00	ES	Futures	1431.62	1432.12	1430.6	1431.11	1996.0
2012-09-03 00:00:00	NQ	Futures	3212.51	3215.4	3212.51	3215.11	345.0
2012-09-03 01:00:00	NQ	Futures	3215.11	3215.4	3210.48	3210.77	286.0
2012-09-03 02:00:00	NQ	Futures	3211.06	3212.51	3209.61	3209.9	362.0
2012-09-03 03:00:00	NQ	Futures	3209.9	3222.36	3208.74	3219.17	3489.0
2012-09-03 04:00:00	NQ	Futures	3219.17	3220.91	3215.69	3217.72	1479.0
2012-09-03 05:00:00	NQ	Futures	3217.43	3219.17	3215.98	3218.59	634.0
2012-09-03 06:00:00	NQ	Futures	3218.59	3220.04	3217.14	3218.01	655.0
2012-09-03 07:00:00	NQ	Futures	3218.01	3218.88	3216.27	3218.01	491.0
2012-09-03 08:00:00	NQ	Futures	3218.01	3221.49	3216.85	3220.91	452.0
2012-09-03 09:00:00	NQ	Futures	3220.91	3222.94	3217.72	3218.59	1924.0
2012-09-03 10:00:00	NQ	Futures	3218.3	3220.91	3218.01	3218.88	780.0
2012-09-03 11:00:00	NQ	Futures	3218.88	3225.26	3218.88	3223.23	979.0
2012-09-03 18:00:00	NQ	Futures	3224.97	3225.26	3220.04	3220.04	260.0
2012-09-03 19:00:00	NQ	Futures	3220.04	3221.49	3219.75	3220.04	112.0
2012-09-03 20:00:00	NQ	Futures	3220.04	3220.04	3216.56	3220.04	684.0
2012-09-03 21:00:00	NQ	Futures	3220.04	3225.26	3219.46	3223.52	867.0
2012-09-03 22:00:00	NQ	Futures	3223.23	3226.71	3222.36	3223.23	560.0
2012-09-03 23:00:00	NQ	Futures	3223.52	3224.39	3221.78	3222.36	228.0
2012-09-03 00:00:00	YM	Futures	12986.9	12997.8	12980.9	12995.8	353.0
2012-09-03 01:00:00	YM	Futures	12994.9	12999.8	12976.0	12977.9	391.0
2012-09-03 02:00:00	YM	Futures	12977.9	12984.9	12974.0	12977.0	564.0
2012-09-03 03:00:00	YM	Futures	12977.0	13024.7	12972.0	13013.7	2303.0
2012-09-03 04:00:00	YM	Futures	13011.8	13017.7	12998.8	13003.8	881.0
2012-09-03 05:00:00	YM	Futures	13001.8	13014.7	12998.8	13012.8	628.0
2012-09-03 06:00:00	YM	Futures	13009.8	13016.7	13006.8	13011.8	669.0
2012-09-03 07:00:00	YM	Futures	13011.8	13012.8	13003.8	13006.8	325.0
2012-09-03 08:00:00	YM	Futures	13008.8	13021.7	13004.8	13017.7	428.0
2012-09-03 09:00:00	YM	Futures	13017.7	13019.7	13003.8	13004.8	1149.0
2012-09-03 10:00:00	YM	Futures	13005.8	13014.7	13003.8	13009.8	587.0
2012-09-03 11:00:00	YM	Futures	13010.8	13033.6	13009.8	13027.7	680.0
2012-09-03 18:00:00	YM	Futures	13029.7	13030.7	13016.7	13016.7	270.0
2012-09-03 19:00:00	YM	Futures	13016.7	13022.7	13013.7	13013.7	114.0

> showing 50 of 969 rows — these rows as CSV

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