PREVIEW / futures_1hour / 2012-04-06

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-04-06.parquet
  size:    14 KB
  rows:    275

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-04-06 00:00:00	ES	Futures	1408.87	1409.88	1408.62	1409.63	798.0
2012-04-06 01:00:00	ES	Futures	1409.63	1410.64	1409.38	1409.63	1023.0
2012-04-06 02:00:00	ES	Futures	1409.38	1409.63	1408.62	1408.87	1018.0
2012-04-06 03:00:00	ES	Futures	1408.87	1409.88	1408.87	1409.38	344.0
2012-04-06 04:00:00	ES	Futures	1409.12	1409.88	1409.12	1409.38	475.0
2012-04-06 05:00:00	ES	Futures	1409.12	1409.38	1408.87	1409.38	360.0
2012-04-06 06:00:00	ES	Futures	1409.38	1410.64	1408.87	1409.63	1247.0
2012-04-06 07:00:00	ES	Futures	1409.88	1411.4	1408.87	1410.39	5025.0
2012-04-06 08:00:00	ES	Futures	1410.39	1410.39	1389.14	1392.43	136450.0
2012-04-06 09:00:00	ES	Futures	1392.17	1392.93	1388.38	1391.41	33242.0
2012-04-06 00:00:00	NQ	Futures	3191.04	3191.91	3190.46	3191.62	82.0
2012-04-06 01:00:00	NQ	Futures	3191.33	3193.06	3191.04	3191.62	182.0
2012-04-06 02:00:00	NQ	Futures	3191.62	3191.62	3188.73	3189.59	165.0
2012-04-06 03:00:00	NQ	Futures	3189.59	3191.04	3189.59	3190.75	144.0
2012-04-06 04:00:00	NQ	Futures	3191.33	3191.91	3190.75	3191.62	88.0
2012-04-06 05:00:00	NQ	Futures	3191.33	3191.62	3191.33	3191.33	31.0
2012-04-06 06:00:00	NQ	Futures	3191.33	3193.06	3191.04	3191.04	116.0
2012-04-06 07:00:00	NQ	Futures	3191.62	3191.62	3189.01	3189.88	450.0
2012-04-06 08:00:00	NQ	Futures	3190.17	3191.33	3146.5	3154.02	8677.0
2012-04-06 09:00:00	NQ	Futures	3154.31	3154.6	3145.35	3152.58	2905.0
2012-04-06 00:00:00	YM	Futures	12945.9	12950.9	12941.9	12949.9	31.0
2012-04-06 01:00:00	YM	Futures	12950.9	12956.9	12950.9	12951.9	87.0
2012-04-06 02:00:00	YM	Futures	12949.9	12951.9	12945.9	12949.9	163.0
2012-04-06 03:00:00	YM	Futures	12949.9	12955.9	12948.9	12948.9	116.0
2012-04-06 04:00:00	YM	Futures	12950.9	12953.9	12950.9	12952.9	65.0
2012-04-06 05:00:00	YM	Futures	12951.9	12951.9	12948.9	12951.9	58.0
2012-04-06 06:00:00	YM	Futures	12951.9	12958.9	12949.9	12951.9	84.0
2012-04-06 07:00:00	YM	Futures	12952.9	12963.9	12949.9	12959.9	234.0
2012-04-06 08:00:00	YM	Futures	12960.9	12960.9	12788.5	12812.4	5527.0
2012-04-06 09:00:00	YM	Futures	12812.4	12817.4	12783.5	12810.4	1675.0
2012-04-06 00:00:00	ZN	Futures	113.671676	113.699018	113.658006	113.658006	958.0
2012-04-06 01:00:00	ZN	Futures	113.658006	113.658006	113.603323	113.616994	2324.0
2012-04-06 02:00:00	ZN	Futures	113.630664	113.658006	113.616991	113.616991	1884.0
2012-04-06 03:00:00	ZN	Futures	113.630664	113.644335	113.603323	113.603323	1271.0
2012-04-06 04:00:00	ZN	Futures	113.616994	113.644335	113.575982	113.644335	1673.0
2012-04-06 05:00:00	ZN	Futures	113.644335	113.644335	113.603323	113.616994	862.0
2012-04-06 06:00:00	ZN	Futures	113.630664	113.630664	113.575982	113.589652	3671.0
2012-04-06 07:00:00	ZN	Futures	113.603323	113.671676	113.589652	113.630664	10712.0
2012-04-06 08:00:00	ZN	Futures	113.616994	114.614953	113.534969	114.491917	274924.0
2012-04-06 09:00:00	ZN	Futures	114.491917	114.56027	114.409893	114.519258	72784.0
2012-04-06 10:00:00	ZN	Futures	114.532929	114.669636	114.519258	114.655965	48786.0
2012-04-06 11:00:00	ZN	Futures	114.655965	114.696977	114.655965	114.669636	12024.0

> showing 42 of 275 rows — these rows as CSV

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