PREVIEW / futures_1hour / 2017-05-09

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-05-09.parquet
  size:    53 KB
  rows:    1,658

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
2017-05-09 00:00:00	ES	Futures	2615.62	2616.16	2615.07	2615.62	2589.0
2017-05-09 01:00:00	ES	Futures	2615.62	2616.16	2615.07	2615.62	2001.0
2017-05-09 02:00:00	ES	Futures	2615.34	2616.98	2615.34	2616.16	7189.0
2017-05-09 03:00:00	ES	Futures	2616.16	2618.08	2614.52	2616.71	21480.0
2017-05-09 04:00:00	ES	Futures	2616.71	2617.53	2615.62	2616.98	10141.0
2017-05-09 05:00:00	ES	Futures	2617.26	2618.35	2616.98	2618.08	9844.0
2017-05-09 06:00:00	ES	Futures	2618.08	2619.71	2616.71	2618.62	11123.0
2017-05-09 07:00:00	ES	Futures	2618.35	2619.71	2618.35	2619.17	10714.0
2017-05-09 08:00:00	ES	Futures	2619.44	2621.08	2618.89	2619.71	17342.0
2017-05-09 09:00:00	ES	Futures	2619.44	2620.81	2617.8	2620.26	126769.0
2017-05-09 10:00:00	ES	Futures	2619.99	2622.17	2618.89	2619.71	177198.0
2017-05-09 11:00:00	ES	Futures	2619.71	2620.26	2616.71	2619.44	101280.0
2017-05-09 12:00:00	ES	Futures	2619.44	2620.26	2615.89	2616.16	74306.0
2017-05-09 13:00:00	ES	Futures	2616.44	2617.53	2613.43	2616.98	101747.0
2017-05-09 14:00:00	ES	Futures	2616.98	2617.26	2614.52	2615.89	63657.0
2017-05-09 15:00:00	ES	Futures	2615.89	2617.53	2609.88	2614.25	269090.0
2017-05-09 16:00:00	ES	Futures	2614.25	2615.07	2613.16	2614.25	71037.0
2017-05-09 18:00:00	ES	Futures	2613.16	2613.71	2610.43	2610.43	12114.0
2017-05-09 19:00:00	ES	Futures	2610.43	2610.97	2609.06	2609.33	7879.0
2017-05-09 20:00:00	ES	Futures	2609.06	2610.7	2608.52	2609.61	9817.0
2017-05-09 21:00:00	ES	Futures	2609.88	2611.79	2609.61	2610.43	9368.0
2017-05-09 22:00:00	ES	Futures	2610.7	2611.25	2610.15	2610.7	4471.0
2017-05-09 23:00:00	ES	Futures	2610.7	2611.52	2610.15	2611.25	3947.0
2017-05-09 00:00:00	NQ	Futures	6741.55	6743.04	6740.35	6741.84	639.0
2017-05-09 01:00:00	NQ	Futures	6741.84	6743.93	6741.84	6742.44	527.0
2017-05-09 02:00:00	NQ	Futures	6742.44	6746.32	6741.84	6743.93	1585.0
2017-05-09 03:00:00	NQ	Futures	6744.23	6748.11	6740.65	6745.42	2764.0
2017-05-09 04:00:00	NQ	Futures	6745.42	6747.21	6743.63	6745.42	1443.0
2017-05-09 05:00:00	NQ	Futures	6745.42	6748.4	6745.12	6748.11	1086.0
2017-05-09 06:00:00	NQ	Futures	6748.11	6749.6	6744.83	6747.21	1502.0
2017-05-09 07:00:00	NQ	Futures	6747.51	6751.38	6747.51	6751.38	1892.0
2017-05-09 08:00:00	NQ	Futures	6751.38	6755.26	6750.49	6752.88	4096.0
2017-05-09 09:00:00	NQ	Futures	6752.88	6771.06	6748.4	6771.06	31232.0
2017-05-09 10:00:00	NQ	Futures	6771.06	6782.99	6769.57	6771.06	38663.0
2017-05-09 11:00:00	NQ	Futures	6771.06	6775.83	6764.2	6767.19	20661.0
2017-05-09 12:00:00	NQ	Futures	6767.19	6773.45	6766.59	6768.08	13385.0
2017-05-09 13:00:00	NQ	Futures	6767.78	6771.06	6758.24	6764.8	16758.0
2017-05-09 14:00:00	NQ	Futures	6764.5	6766.59	6760.63	6763.91	11874.0
2017-05-09 15:00:00	NQ	Futures	6763.91	6770.76	6754.37	6767.48	32742.0
2017-05-09 16:00:00	NQ	Futures	6767.48	6776.43	6765.4	6774.34	5970.0
2017-05-09 18:00:00	NQ	Futures	6771.96	6772.85	6763.91	6763.91	1463.0
2017-05-09 19:00:00	NQ	Futures	6764.2	6765.1	6760.33	6760.93	1415.0
2017-05-09 20:00:00	NQ	Futures	6760.63	6765.7	6760.03	6762.71	1571.0
2017-05-09 21:00:00	NQ	Futures	6762.71	6768.38	6762.71	6764.2	1753.0
2017-05-09 22:00:00	NQ	Futures	6764.5	6767.19	6764.2	6765.7	772.0
2017-05-09 23:00:00	NQ	Futures	6765.7	6767.19	6763.01	6765.99	673.0
2017-05-09 00:00:00	YM	Futures	22754.1	22758.5	22746.5	22752.0	710.0
2017-05-09 01:00:00	YM	Futures	22753.1	22758.5	22748.7	22749.8	699.0
2017-05-09 02:00:00	YM	Futures	22749.8	22770.4	22744.4	22762.8	2756.0
2017-05-09 03:00:00	YM	Futures	22761.8	22778.1	22753.1	22768.3	2948.0

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

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