PREVIEW / futures_1hour / 2017-10-03

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-10-03.parquet
  size:    50 KB
  rows:    1,586

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-10-03 00:00:00	ES	Futures	2767.32	2767.87	2766.5	2767.05	2728.0
2017-10-03 01:00:00	ES	Futures	2767.05	2767.59	2766.5	2767.32	5368.0
2017-10-03 02:00:00	ES	Futures	2767.32	2767.59	2766.5	2766.77	4003.0
2017-10-03 03:00:00	ES	Futures	2766.77	2767.32	2765.95	2766.5	8440.0
2017-10-03 04:00:00	ES	Futures	2766.5	2766.77	2765.4	2765.95	6179.0
2017-10-03 05:00:00	ES	Futures	2765.95	2766.77	2765.4	2765.95	5203.0
2017-10-03 06:00:00	ES	Futures	2765.95	2766.77	2765.4	2766.5	7792.0
2017-10-03 07:00:00	ES	Futures	2766.22	2766.5	2765.4	2766.5	3954.0
2017-10-03 08:00:00	ES	Futures	2766.5	2767.32	2766.22	2766.77	11566.0
2017-10-03 09:00:00	ES	Futures	2766.77	2767.59	2764.04	2767.05	137930.0
2017-10-03 10:00:00	ES	Futures	2767.05	2767.05	2764.04	2765.4	103122.0
2017-10-03 11:00:00	ES	Futures	2765.4	2766.77	2763.76	2766.22	85886.0
2017-10-03 12:00:00	ES	Futures	2766.5	2767.59	2766.22	2767.59	42579.0
2017-10-03 13:00:00	ES	Futures	2767.59	2767.87	2766.77	2767.59	39046.0
2017-10-03 14:00:00	ES	Futures	2767.59	2769.23	2767.32	2769.23	62699.0
2017-10-03 15:00:00	ES	Futures	2769.23	2771.15	2768.14	2770.6	189448.0
2017-10-03 16:00:00	ES	Futures	2770.33	2772.24	2769.51	2771.7	82656.0
2017-10-03 18:00:00	ES	Futures	2771.7	2771.97	2769.78	2770.05	4542.0
2017-10-03 19:00:00	ES	Futures	2770.33	2770.6	2769.78	2769.78	2634.0
2017-10-03 20:00:00	ES	Futures	2770.05	2770.6	2769.23	2769.51	7904.0
2017-10-03 21:00:00	ES	Futures	2769.78	2770.6	2769.23	2770.33	4417.0
2017-10-03 22:00:00	ES	Futures	2770.33	2770.88	2770.05	2770.6	2763.0
2017-10-03 23:00:00	ES	Futures	2770.6	2771.42	2770.33	2770.88	3119.0
2017-10-03 00:00:00	NQ	Futures	7130.56	7132.64	7127.59	7129.07	1272.0
2017-10-03 01:00:00	NQ	Futures	7129.37	7132.05	7128.77	7129.96	796.0
2017-10-03 02:00:00	NQ	Futures	7129.96	7131.15	7125.21	7126.1	1116.0
2017-10-03 03:00:00	NQ	Futures	7125.5	7130.56	7122.83	7125.21	2286.0
2017-10-03 04:00:00	NQ	Futures	7125.5	7127.29	7121.93	7124.31	2265.0
2017-10-03 05:00:00	NQ	Futures	7124.02	7125.5	7121.34	7122.83	1175.0
2017-10-03 06:00:00	NQ	Futures	7122.53	7123.72	7117.77	7122.23	1625.0
2017-10-03 07:00:00	NQ	Futures	7121.93	7122.83	7117.47	7122.83	1327.0
2017-10-03 08:00:00	NQ	Futures	7122.83	7128.77	7122.23	7126.69	4044.0
2017-10-03 09:00:00	NQ	Futures	7126.69	7143.65	7122.53	7137.4	47526.0
2017-10-03 10:00:00	NQ	Futures	7137.7	7138.89	7113.61	7130.56	50364.0
2017-10-03 11:00:00	NQ	Futures	7130.26	7133.83	7122.23	7127.88	21035.0
2017-10-03 12:00:00	NQ	Futures	7127.88	7137.1	7127.88	7132.34	12897.0
2017-10-03 13:00:00	NQ	Futures	7132.34	7135.32	7129.07	7132.64	10490.0
2017-10-03 14:00:00	NQ	Futures	7132.94	7135.62	7130.86	7134.43	10298.0
2017-10-03 15:00:00	NQ	Futures	7134.43	7138.89	7129.37	7136.21	24574.0
2017-10-03 16:00:00	NQ	Futures	7135.91	7137.4	7132.05	7136.21	5930.0
2017-10-03 18:00:00	NQ	Futures	7136.8	7137.1	7130.56	7131.45	1364.0
2017-10-03 19:00:00	NQ	Futures	7131.75	7132.05	7130.26	7130.56	608.0
2017-10-03 20:00:00	NQ	Futures	7130.56	7132.64	7127.88	7129.67	1326.0
2017-10-03 21:00:00	NQ	Futures	7129.37	7133.53	7128.77	7132.05	835.0
2017-10-03 22:00:00	NQ	Futures	7131.75	7133.83	7130.56	7133.53	697.0
2017-10-03 23:00:00	NQ	Futures	7133.53	7135.02	7131.75	7133.83	523.0
2017-10-03 00:00:00	YM	Futures	24526.2	24527.3	24515.3	24521.8	1410.0
2017-10-03 01:00:00	YM	Futures	24521.8	24529.5	24519.7	24526.2	1304.0
2017-10-03 02:00:00	YM	Futures	24525.1	24527.3	24514.2	24515.3	905.0
2017-10-03 03:00:00	YM	Futures	24516.4	24525.1	24514.2	24519.7	1099.0

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

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