PREVIEW / futures_1hour / 2017-07-03

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-07-03.parquet
  size:    51 KB
  rows:    1,519

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-07-03 00:00:00	ES	Futures	2653.58	2653.85	2652.21	2652.76	1960.0
2017-07-03 01:00:00	ES	Futures	2653.03	2653.58	2652.48	2653.58	1778.0
2017-07-03 02:00:00	ES	Futures	2653.58	2653.85	2651.94	2652.21	5879.0
2017-07-03 03:00:00	ES	Futures	2652.21	2656.58	2652.21	2655.49	22364.0
2017-07-03 04:00:00	ES	Futures	2655.76	2657.13	2654.12	2656.04	14547.0
2017-07-03 05:00:00	ES	Futures	2656.04	2656.31	2654.12	2654.67	8488.0
2017-07-03 06:00:00	ES	Futures	2654.67	2655.22	2653.85	2655.22	8194.0
2017-07-03 07:00:00	ES	Futures	2654.94	2656.58	2654.4	2656.04	11932.0
2017-07-03 08:00:00	ES	Futures	2656.04	2658.22	2654.94	2658.22	17667.0
2017-07-03 09:00:00	ES	Futures	2658.22	2661.78	2657.68	2660.41	126334.0
2017-07-03 10:00:00	ES	Futures	2660.41	2663.96	2659.04	2662.32	156371.0
2017-07-03 11:00:00	ES	Futures	2662.32	2662.6	2659.86	2661.23	114667.0
2017-07-03 12:00:00	ES	Futures	2661.23	2661.23	2651.39	2651.39	169255.0
2017-07-03 13:00:00	ES	Futures	2651.39	2652.48	2648.11	2650.02	62526.0
2017-07-03 18:00:00	ES	Futures	2650.02	2651.39	2647.56	2650.02	3642.0
2017-07-03 19:00:00	ES	Futures	2650.02	2654.12	2649.2	2653.85	3090.0
2017-07-03 20:00:00	ES	Futures	2654.12	2654.12	2650.84	2650.84	4291.0
2017-07-03 21:00:00	ES	Futures	2651.12	2653.03	2650.02	2652.48	3662.0
2017-07-03 22:00:00	ES	Futures	2652.76	2653.58	2650.57	2650.57	2521.0
2017-07-03 23:00:00	ES	Futures	2650.84	2651.94	2650.02	2651.39	3844.0
2017-07-03 00:00:00	NQ	Futures	6750.02	6752.1	6747.94	6750.02	479.0
2017-07-03 01:00:00	NQ	Futures	6750.02	6752.7	6748.53	6751.81	449.0
2017-07-03 02:00:00	NQ	Futures	6752.7	6755.08	6749.72	6752.7	1009.0
2017-07-03 03:00:00	NQ	Futures	6752.7	6762.53	6752.4	6757.76	2607.0
2017-07-03 04:00:00	NQ	Futures	6757.76	6758.66	6753.0	6755.38	1501.0
2017-07-03 05:00:00	NQ	Futures	6755.38	6756.87	6749.13	6751.51	1639.0
2017-07-03 06:00:00	NQ	Futures	6751.81	6752.1	6744.07	6747.04	2096.0
2017-07-03 07:00:00	NQ	Futures	6747.04	6756.57	6745.26	6753.0	3568.0
2017-07-03 08:00:00	NQ	Futures	6753.0	6769.97	6751.21	6769.37	4146.0
2017-07-03 09:00:00	NQ	Futures	6769.67	6777.71	6747.04	6752.7	38904.0
2017-07-03 10:00:00	NQ	Futures	6753.0	6760.74	6702.68	6703.57	58409.0
2017-07-03 11:00:00	NQ	Futures	6703.27	6706.55	6677.96	6700.3	48591.0
2017-07-03 12:00:00	NQ	Futures	6700.3	6700.89	6661.59	6665.46	45146.0
2017-07-03 13:00:00	NQ	Futures	6665.46	6669.63	6647.3	6656.53	10008.0
2017-07-03 18:00:00	NQ	Futures	6659.21	6663.38	6650.87	6650.87	1292.0
2017-07-03 19:00:00	NQ	Futures	6650.87	6656.82	6643.43	6656.53	1058.0
2017-07-03 20:00:00	NQ	Futures	6656.82	6657.12	6641.04	6641.34	1765.0
2017-07-03 21:00:00	NQ	Futures	6641.94	6644.02	6632.41	6642.53	2622.0
2017-07-03 22:00:00	NQ	Futures	6642.53	6650.27	6640.45	6641.34	1201.0
2017-07-03 23:00:00	NQ	Futures	6641.64	6649.68	6639.85	6647.59	1636.0
2017-07-03 00:00:00	YM	Futures	23233.6	23233.6	23220.6	23224.9	378.0
2017-07-03 01:00:00	YM	Futures	23223.8	23228.2	23221.7	23228.2	373.0
2017-07-03 02:00:00	YM	Futures	23228.2	23235.8	23221.7	23229.3	1054.0
2017-07-03 03:00:00	YM	Futures	23229.3	23263.0	23227.1	23247.8	3261.0
2017-07-03 04:00:00	YM	Futures	23247.8	23261.9	23239.1	23254.3	2056.0
2017-07-03 05:00:00	YM	Futures	23254.3	23258.7	23242.4	23251.1	1534.0
2017-07-03 06:00:00	YM	Futures	23251.1	23269.6	23243.4	23269.6	1740.0
2017-07-03 07:00:00	YM	Futures	23269.6	23273.9	23261.9	23267.4	2007.0
2017-07-03 08:00:00	YM	Futures	23266.3	23267.4	23255.4	23259.8	2507.0
2017-07-03 09:00:00	YM	Futures	23260.9	23330.5	23253.2	23321.8	15420.0

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

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