PREVIEW / futures_1hour / 2018-02-05

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-02-05.parquet
  size:    60 KB
  rows:    1,729

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-05 00:00:00	ES	Futures	3006.61	3008.25	3006.61	3007.7	5826.0
2018-02-05 01:00:00	ES	Futures	3007.7	3008.25	3002.51	3006.61	12230.0
2018-02-05 02:00:00	ES	Futures	3006.61	3012.07	3006.61	3007.7	26251.0
2018-02-05 03:00:00	ES	Futures	3007.43	3007.97	3000.6	3006.61	36788.0
2018-02-05 04:00:00	ES	Futures	3006.61	3013.71	3005.79	3011.53	25221.0
2018-02-05 05:00:00	ES	Futures	3011.53	3012.07	3004.15	3005.79	20528.0
2018-02-05 06:00:00	ES	Futures	3005.79	3006.06	2997.59	2998.68	25109.0
2018-02-05 07:00:00	ES	Futures	2998.68	3000.05	2990.21	2999.23	57184.0
2018-02-05 08:00:00	ES	Futures	2999.23	3006.61	2997.32	3002.78	77506.0
2018-02-05 09:00:00	ES	Futures	3002.78	3003.33	2989.39	3000.6	300638.0
2018-02-05 10:00:00	ES	Futures	3000.32	3020.82	2996.22	3015.9	379058.0
2018-02-05 11:00:00	ES	Futures	3015.63	3019.73	3000.32	3005.79	211776.0
2018-02-05 12:00:00	ES	Futures	3005.79	3006.61	2987.48	2991.3	247143.0
2018-02-05 13:00:00	ES	Futures	2991.3	2991.58	2968.34	2985.02	419345.0
2018-02-05 14:00:00	ES	Futures	2985.02	2985.56	2937.73	2939.64	477255.0
2018-02-05 15:00:00	ES	Futures	2939.64	2948.66	2881.42	2892.08	1045416.0
2018-02-05 16:00:00	ES	Futures	2892.08	2892.63	2837.96	2865.02	369037.0
2018-02-05 18:00:00	ES	Futures	2868.85	2880.6	2849.17	2864.75	81605.0
2018-02-05 19:00:00	ES	Futures	2864.48	2877.05	2853.82	2858.74	49242.0
2018-02-05 20:00:00	ES	Futures	2858.74	2866.39	2779.2	2785.76	121253.0
2018-02-05 21:00:00	ES	Futures	2785.76	2815.28	2779.2	2799.15	93911.0
2018-02-05 22:00:00	ES	Futures	2799.15	2806.26	2790.13	2793.96	43705.0
2018-02-05 23:00:00	ES	Futures	2793.69	2795.33	2764.99	2788.49	73017.0
2018-02-05 00:00:00	NQ	Futures	8000.93	8006.86	8000.93	8006.56	1488.0
2018-02-05 01:00:00	NQ	Futures	8005.97	8006.86	7993.22	8004.49	2767.0
2018-02-05 02:00:00	NQ	Futures	8005.08	8023.76	8005.08	8013.98	5281.0
2018-02-05 03:00:00	NQ	Futures	8013.68	8014.87	7988.47	8004.49	6019.0
2018-02-05 04:00:00	NQ	Futures	8004.78	8018.13	8003.89	8015.46	4431.0
2018-02-05 05:00:00	NQ	Futures	8015.46	8018.13	8006.86	8009.53	4471.0
2018-02-05 06:00:00	NQ	Futures	8010.42	8010.42	7976.31	7979.57	6823.0
2018-02-05 07:00:00	NQ	Futures	7980.17	7980.17	7933.3	7955.25	18958.0
2018-02-05 08:00:00	NQ	Futures	7955.25	7991.73	7949.62	7980.17	28138.0
2018-02-05 09:00:00	NQ	Futures	7980.46	8003.6	7927.96	8003.6	84471.0
2018-02-05 10:00:00	NQ	Futures	8003.6	8083.38	7985.5	8048.97	117786.0
2018-02-05 11:00:00	NQ	Futures	8048.97	8064.99	7998.55	8020.21	70749.0
2018-02-05 12:00:00	NQ	Futures	8019.91	8022.58	7970.67	7994.4	65381.0
2018-02-05 13:00:00	NQ	Futures	7994.4	7996.18	7937.16	7991.44	100364.0
2018-02-05 14:00:00	NQ	Futures	7991.44	7994.1	7855.3	7866.57	119094.0
2018-02-05 15:00:00	NQ	Futures	7866.87	7883.77	7702.26	7710.86	200583.0
2018-02-05 16:00:00	NQ	Futures	7709.08	7712.64	7578.28	7672.6	54698.0
2018-02-05 18:00:00	NQ	Futures	7679.42	7706.11	7610.61	7653.02	15482.0
2018-02-05 19:00:00	NQ	Futures	7651.84	7680.01	7627.81	7637.9	10874.0
2018-02-05 20:00:00	NQ	Futures	7640.86	7662.22	7450.45	7484.56	16393.0
2018-02-05 21:00:00	NQ	Futures	7481.0	7562.26	7465.28	7517.18	16825.0
2018-02-05 22:00:00	NQ	Futures	7516.88	7544.47	7483.96	7496.72	7168.0
2018-02-05 23:00:00	NQ	Futures	7496.42	7504.43	7427.02	7489.6	11016.0
2018-02-05 00:00:00	YM	Futures	27506.8	27537.2	27505.7	27531.8	1754.0
2018-02-05 01:00:00	YM	Futures	27530.7	27533.9	27462.2	27512.2	4401.0
2018-02-05 02:00:00	YM	Futures	27514.4	27565.5	27502.4	27516.5	5113.0
2018-02-05 03:00:00	YM	Futures	27515.5	27522.0	27455.7	27505.7	5629.0

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

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