PREVIEW / futures_1hour / 2017-06-08

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-06-08.parquet
  size:    54 KB
  rows:    1,639

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-06-08 00:00:00	ES	Futures	2659.32	2659.59	2658.23	2659.32	2119.0
2017-06-08 01:00:00	ES	Futures	2659.32	2659.32	2657.68	2657.68	4350.0
2017-06-08 02:00:00	ES	Futures	2657.95	2659.32	2657.41	2658.77	4449.0
2017-06-08 03:00:00	ES	Futures	2658.5	2660.69	2658.23	2659.32	13984.0
2017-06-08 04:00:00	ES	Futures	2659.59	2659.59	2657.68	2658.77	6960.0
2017-06-08 05:00:00	ES	Futures	2658.5	2660.69	2658.5	2659.59	9421.0
2017-06-08 06:00:00	ES	Futures	2659.59	2662.32	2659.05	2661.51	11981.0
2017-06-08 07:00:00	ES	Futures	2661.51	2662.05	2659.32	2659.87	15853.0
2017-06-08 08:00:00	ES	Futures	2659.59	2659.87	2657.95	2658.77	16296.0
2017-06-08 09:00:00	ES	Futures	2658.5	2661.51	2653.58	2656.59	161575.0
2017-06-08 10:00:00	ES	Futures	2656.59	2659.05	2651.95	2656.32	193040.0
2017-06-08 11:00:00	ES	Futures	2656.32	2660.14	2656.32	2659.59	106199.0
2017-06-08 12:00:00	ES	Futures	2659.32	2664.78	2659.32	2662.87	97993.0
2017-06-08 13:00:00	ES	Futures	2663.14	2663.14	2657.13	2661.23	75358.0
2017-06-08 14:00:00	ES	Futures	2660.96	2661.23	2652.49	2653.86	90198.0
2017-06-08 15:00:00	ES	Futures	2653.86	2659.87	2653.86	2658.5	148841.0
2017-06-08 16:00:00	ES	Futures	2658.5	2660.14	2656.86	2659.59	48712.0
2017-06-08 18:00:00	ES	Futures	2651.95	2655.77	2650.03	2654.4	14122.0
2017-06-08 19:00:00	ES	Futures	2654.4	2654.68	2652.22	2652.49	3671.0
2017-06-08 20:00:00	ES	Futures	2652.49	2656.59	2651.95	2654.95	7583.0
2017-06-08 21:00:00	ES	Futures	2654.95	2659.59	2654.95	2659.59	8004.0
2017-06-08 22:00:00	ES	Futures	2659.32	2662.05	2659.05	2661.23	4522.0
2017-06-08 23:00:00	ES	Futures	2660.96	2661.51	2659.87	2660.14	2338.0
2017-06-08 00:00:00	NQ	Futures	7020.31	7020.61	7017.03	7018.82	630.0
2017-06-08 01:00:00	NQ	Futures	7019.11	7019.41	7016.13	7017.92	1285.0
2017-06-08 02:00:00	NQ	Futures	7018.22	7021.2	7016.73	7019.11	1197.0
2017-06-08 03:00:00	NQ	Futures	7018.82	7023.59	7017.03	7018.82	2555.0
2017-06-08 04:00:00	NQ	Futures	7019.41	7019.41	7015.54	7017.62	1333.0
2017-06-08 05:00:00	NQ	Futures	7017.03	7021.5	7016.73	7019.41	1319.0
2017-06-08 06:00:00	NQ	Futures	7019.41	7028.66	7018.82	7027.46	2831.0
2017-06-08 07:00:00	NQ	Futures	7027.16	7033.13	7025.67	7027.16	4178.0
2017-06-08 08:00:00	NQ	Futures	7027.16	7031.93	7024.48	7028.06	5869.0
2017-06-08 09:00:00	NQ	Futures	7027.76	7033.43	6989.0	6997.95	49451.0
2017-06-08 10:00:00	NQ	Futures	6997.65	7005.7	6980.65	7001.82	47427.0
2017-06-08 11:00:00	NQ	Futures	7001.82	7014.94	7000.93	7009.87	25696.0
2017-06-08 12:00:00	NQ	Futures	7009.57	7017.33	7005.1	7010.17	14673.0
2017-06-08 13:00:00	NQ	Futures	7009.87	7011.36	6995.56	7007.49	12812.0
2017-06-08 14:00:00	NQ	Futures	7007.49	7008.38	6991.09	6995.56	17435.0
2017-06-08 15:00:00	NQ	Futures	6995.26	7022.69	6995.26	7018.22	21818.0
2017-06-08 16:00:00	NQ	Futures	7018.52	7026.87	7014.64	7025.38	4956.0
2017-06-08 18:00:00	NQ	Futures	7003.31	7014.64	6999.14	7009.28	2035.0
2017-06-08 19:00:00	NQ	Futures	7010.17	7010.47	7003.61	7003.61	683.0
2017-06-08 20:00:00	NQ	Futures	7003.91	7010.47	7001.23	7005.1	1711.0
2017-06-08 21:00:00	NQ	Futures	7005.1	7019.71	7005.1	7017.62	1811.0
2017-06-08 22:00:00	NQ	Futures	7017.33	7022.69	7015.84	7020.31	821.0
2017-06-08 23:00:00	NQ	Futures	7020.01	7021.8	7016.73	7017.62	435.0
2017-06-08 00:00:00	YM	Futures	23029.1	23029.1	23018.2	23025.8	490.0
2017-06-08 01:00:00	YM	Futures	23025.8	23025.8	23013.9	23015.0	734.0
2017-06-08 02:00:00	YM	Futures	23016.1	23026.9	23013.9	23022.6	847.0
2017-06-08 03:00:00	YM	Futures	23020.4	23036.7	23018.2	23028.0	2352.0

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

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