PREVIEW / futures_1hour / 2011-10-28

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-10-28.parquet
  size:    41 KB
  rows:    1,201

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
2011-10-28 00:00:00	ES	Futures	1282.13	1283.63	1280.12	1280.37	5783.0
2011-10-28 01:00:00	ES	Futures	1280.62	1282.38	1280.12	1282.38	5768.0
2011-10-28 02:00:00	ES	Futures	1282.63	1283.38	1279.87	1280.12	11593.0
2011-10-28 03:00:00	ES	Futures	1280.12	1283.13	1278.11	1281.37	45615.0
2011-10-28 04:00:00	ES	Futures	1281.62	1286.14	1281.12	1283.63	35630.0
2011-10-28 05:00:00	ES	Futures	1283.63	1284.13	1279.87	1283.13	33066.0
2011-10-28 06:00:00	ES	Futures	1283.13	1283.13	1277.36	1279.87	36221.0
2011-10-28 07:00:00	ES	Futures	1279.87	1282.13	1277.61	1279.12	46768.0
2011-10-28 08:00:00	ES	Futures	1279.12	1281.12	1277.86	1279.37	42122.0
2011-10-28 09:00:00	ES	Futures	1279.37	1283.13	1276.61	1280.62	291170.0
2011-10-28 10:00:00	ES	Futures	1280.37	1284.38	1276.86	1283.38	301012.0
2011-10-28 11:00:00	ES	Futures	1283.63	1286.14	1279.62	1279.62	278402.0
2011-10-28 12:00:00	ES	Futures	1279.62	1282.63	1278.36	1282.13	145444.0
2011-10-28 13:00:00	ES	Futures	1282.13	1285.39	1281.12	1283.13	130319.0
2011-10-28 14:00:00	ES	Futures	1283.13	1284.13	1280.12	1281.88	110648.0
2011-10-28 15:00:00	ES	Futures	1282.13	1287.39	1281.12	1284.63	258975.0
2011-10-28 16:00:00	ES	Futures	1284.88	1287.39	1284.63	1286.14	76405.0
2011-10-28 00:00:00	NQ	Futures	2756.36	2758.96	2750.88	2751.75	419.0
2011-10-28 01:00:00	NQ	Futures	2752.04	2755.79	2751.46	2755.5	256.0
2011-10-28 02:00:00	NQ	Futures	2756.36	2758.09	2752.04	2752.04	632.0
2011-10-28 03:00:00	NQ	Futures	2752.04	2754.63	2747.42	2750.31	4750.0
2011-10-28 04:00:00	NQ	Futures	2750.6	2759.82	2749.44	2755.21	2126.0
2011-10-28 05:00:00	NQ	Futures	2754.92	2756.07	2747.71	2754.06	1850.0
2011-10-28 06:00:00	NQ	Futures	2754.34	2754.34	2743.68	2748.29	3093.0
2011-10-28 07:00:00	NQ	Futures	2748.0	2752.61	2743.1	2746.56	4439.0
2011-10-28 08:00:00	NQ	Futures	2746.56	2750.6	2745.12	2748.87	4374.0
2011-10-28 09:00:00	NQ	Futures	2748.87	2763.28	2743.96	2756.36	37685.0
2011-10-28 10:00:00	NQ	Futures	2756.07	2762.13	2749.15	2760.4	34552.0
2011-10-28 11:00:00	NQ	Futures	2760.4	2764.72	2750.6	2751.46	26246.0
2011-10-28 12:00:00	NQ	Futures	2751.46	2754.63	2747.14	2754.34	15509.0
2011-10-28 13:00:00	NQ	Futures	2754.06	2762.13	2752.9	2758.67	18604.0
2011-10-28 14:00:00	NQ	Futures	2758.67	2760.98	2753.77	2758.96	16775.0
2011-10-28 15:00:00	NQ	Futures	2758.96	2769.34	2756.65	2765.3	31595.0
2011-10-28 16:00:00	NQ	Futures	2765.01	2769.91	2763.86	2767.61	6082.0
2011-10-28 00:00:00	YM	Futures	11945.7	11956.5	11930.9	11933.9	356.0
2011-10-28 01:00:00	YM	Futures	11933.9	11947.6	11932.9	11947.6	489.0
2011-10-28 02:00:00	YM	Futures	11947.6	11954.5	11930.9	11930.9	671.0
2011-10-28 03:00:00	YM	Futures	11930.9	11948.6	11913.2	11935.8	2560.0
2011-10-28 04:00:00	YM	Futures	11936.8	11973.2	11931.9	11951.6	2038.0
2011-10-28 05:00:00	YM	Futures	11950.6	11956.5	11920.1	11947.6	1451.0
2011-10-28 06:00:00	YM	Futures	11948.6	11948.6	11905.3	11927.0	1325.0
2011-10-28 07:00:00	YM	Futures	11926.0	11942.7	11909.2	11925.0	2050.0
2011-10-28 08:00:00	YM	Futures	11923.0	11939.8	11916.1	11930.9	1495.0
2011-10-28 09:00:00	YM	Futures	11928.9	11982.1	11911.2	11958.5	14595.0
2011-10-28 10:00:00	YM	Futures	11957.5	11970.3	11919.1	11967.3	13509.0
2011-10-28 11:00:00	YM	Futures	11967.3	11991.0	11944.7	11948.6	10192.0
2011-10-28 12:00:00	YM	Futures	11948.6	11967.3	11937.8	11966.3	6040.0
2011-10-28 13:00:00	YM	Futures	11965.4	11992.9	11957.5	11973.2	5635.0
2011-10-28 14:00:00	YM	Futures	11972.3	11975.2	11946.7	11962.4	5226.0
2011-10-28 15:00:00	YM	Futures	11963.4	12005.7	11955.5	11983.1	10252.0

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

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