PREVIEW / futures_1hour / 2018-02-28

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-02-28.parquet
  size:    55 KB
  rows:    1,687

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
2018-02-28 00:00:00	ES	Futures	2999.5	3002.51	2998.96	3001.14	4810.0
2018-02-28 01:00:00	ES	Futures	3001.14	3003.33	2999.23	3001.42	5188.0
2018-02-28 02:00:00	ES	Futures	3001.42	3004.42	2998.96	3004.15	13975.0
2018-02-28 03:00:00	ES	Futures	3004.15	3010.98	3003.87	3007.15	20960.0
2018-02-28 04:00:00	ES	Futures	3006.88	3011.8	3006.61	3010.98	15750.0
2018-02-28 05:00:00	ES	Futures	3010.71	3011.8	3004.97	3006.33	16271.0
2018-02-28 06:00:00	ES	Futures	3006.06	3008.79	3002.24	3003.06	17692.0
2018-02-28 07:00:00	ES	Futures	3003.33	3006.61	3001.42	3006.33	13352.0
2018-02-28 08:00:00	ES	Futures	3006.06	3011.8	3004.42	3008.52	30234.0
2018-02-28 09:00:00	ES	Futures	3008.25	3019.45	3006.33	3019.18	146109.0
2018-02-28 10:00:00	ES	Futures	3019.45	3019.73	2999.5	3004.69	187231.0
2018-02-28 11:00:00	ES	Futures	3004.69	3006.06	2992.94	3002.24	227465.0
2018-02-28 12:00:00	ES	Futures	3002.24	3010.98	2997.59	3008.25	123016.0
2018-02-28 13:00:00	ES	Futures	3007.97	3012.89	3003.6	3012.62	93007.0
2018-02-28 14:00:00	ES	Futures	3012.62	3015.9	2992.94	2994.58	142393.0
2018-02-28 15:00:00	ES	Futures	2994.58	2996.22	2965.61	2966.7	484321.0
2018-02-28 16:00:00	ES	Futures	2966.7	2975.45	2965.06	2972.44	156228.0
2018-02-28 18:00:00	ES	Futures	2971.9	2975.18	2967.52	2972.99	14377.0
2018-02-28 19:00:00	ES	Futures	2972.99	2976.54	2970.53	2973.26	8736.0
2018-02-28 20:00:00	ES	Futures	2973.26	2974.08	2955.22	2964.24	34177.0
2018-02-28 21:00:00	ES	Futures	2963.97	2964.52	2957.68	2960.42	15153.0
2018-02-28 22:00:00	ES	Futures	2960.14	2964.52	2957.68	2963.7	11668.0
2018-02-28 23:00:00	ES	Futures	2963.42	2964.52	2960.14	2961.78	4452.0
2018-02-28 00:00:00	NQ	Futures	8194.01	8201.13	8188.37	8194.9	2721.0
2018-02-28 01:00:00	NQ	Futures	8195.2	8199.94	8189.56	8194.01	1632.0
2018-02-28 02:00:00	NQ	Futures	8194.6	8202.91	8186.89	8199.94	3921.0
2018-02-28 03:00:00	NQ	Futures	8199.94	8215.36	8199.64	8208.54	6044.0
2018-02-28 04:00:00	NQ	Futures	8207.65	8221.59	8207.36	8220.41	3233.0
2018-02-28 05:00:00	NQ	Futures	8220.41	8222.48	8207.65	8210.62	2705.0
2018-02-28 06:00:00	NQ	Futures	8211.51	8218.33	8203.8	8206.47	3174.0
2018-02-28 07:00:00	NQ	Futures	8206.47	8220.41	8203.2	8219.52	3558.0
2018-02-28 08:00:00	NQ	Futures	8219.81	8239.98	8218.63	8232.57	8744.0
2018-02-28 09:00:00	NQ	Futures	8232.57	8254.81	8217.44	8254.81	43846.0
2018-02-28 10:00:00	NQ	Futures	8254.81	8261.34	8201.13	8215.36	58488.0
2018-02-28 11:00:00	NQ	Futures	8215.36	8223.97	8177.7	8207.65	71208.0
2018-02-28 12:00:00	NQ	Futures	8207.36	8240.87	8195.49	8234.94	41595.0
2018-02-28 13:00:00	NQ	Futures	8234.94	8260.15	8227.23	8259.56	33230.0
2018-02-28 14:00:00	NQ	Futures	8259.26	8269.64	8207.36	8212.1	40813.0
2018-02-28 15:00:00	NQ	Futures	8212.1	8217.74	8138.55	8140.03	90204.0
2018-02-28 16:00:00	NQ	Futures	8139.73	8166.72	8135.88	8161.68	20534.0
2018-02-28 18:00:00	NQ	Futures	8161.68	8171.17	8151.0	8164.94	3291.0
2018-02-28 19:00:00	NQ	Futures	8164.65	8167.91	8152.78	8158.12	4789.0
2018-02-28 20:00:00	NQ	Futures	8158.12	8161.09	8116.01	8144.18	12109.0
2018-02-28 21:00:00	NQ	Futures	8143.89	8149.82	8126.09	8139.73	5757.0
2018-02-28 22:00:00	NQ	Futures	8140.03	8154.56	8131.72	8151.89	3777.0
2018-02-28 23:00:00	NQ	Futures	8151.89	8153.97	8142.11	8147.15	1728.0
2018-02-28 00:00:00	YM	Futures	27605.7	27632.8	27597.0	27612.2	2963.0
2018-02-28 01:00:00	YM	Futures	27613.3	27618.7	27587.2	27601.3	2049.0
2018-02-28 02:00:00	YM	Futures	27601.3	27644.8	27589.4	27633.9	4393.0
2018-02-28 03:00:00	YM	Futures	27633.9	27703.5	27631.8	27674.1	5958.0

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

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