PREVIEW / futures_1hour / 2017-12-07

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-12-07.parquet
  size:    53 KB
  rows:    1,625

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-12-07 00:00:00	ES	Futures	2883.03	2883.58	2882.49	2883.31	5369.0
2017-12-07 01:00:00	ES	Futures	2883.31	2884.4	2881.39	2881.94	4237.0
2017-12-07 02:00:00	ES	Futures	2881.67	2881.94	2879.2	2879.48	10442.0
2017-12-07 03:00:00	ES	Futures	2879.48	2880.85	2878.93	2880.3	13854.0
2017-12-07 04:00:00	ES	Futures	2880.3	2883.03	2880.3	2881.94	9284.0
2017-12-07 05:00:00	ES	Futures	2881.67	2883.03	2880.02	2880.3	9237.0
2017-12-07 06:00:00	ES	Futures	2880.57	2880.85	2877.56	2879.2	14766.0
2017-12-07 07:00:00	ES	Futures	2878.93	2879.48	2875.92	2875.92	22862.0
2017-12-07 08:00:00	ES	Futures	2876.2	2878.11	2875.1	2875.1	25344.0
2017-12-07 09:00:00	ES	Futures	2875.1	2880.3	2873.73	2880.3	132615.0
2017-12-07 10:00:00	ES	Futures	2880.3	2884.68	2877.29	2884.68	107890.0
2017-12-07 11:00:00	ES	Futures	2884.68	2888.78	2880.85	2887.96	109578.0
2017-12-07 12:00:00	ES	Futures	2887.96	2888.78	2886.04	2888.78	54329.0
2017-12-07 13:00:00	ES	Futures	2888.78	2890.15	2885.5	2887.14	64473.0
2017-12-07 14:00:00	ES	Futures	2887.41	2887.96	2880.85	2884.68	76095.0
2017-12-07 15:00:00	ES	Futures	2884.68	2886.59	2882.76	2886.04	114582.0
2017-12-07 16:00:00	ES	Futures	2886.04	2888.78	2885.5	2888.23	42436.0
2017-12-07 18:00:00	ES	Futures	2888.23	2890.15	2887.96	2890.15	6736.0
2017-12-07 19:00:00	ES	Futures	2889.87	2890.15	2886.32	2888.51	8372.0
2017-12-07 20:00:00	ES	Futures	2888.78	2889.33	2887.41	2888.78	3208.0
2017-12-07 21:00:00	ES	Futures	2888.78	2889.33	2887.41	2887.41	2837.0
2017-12-07 22:00:00	ES	Futures	2887.68	2888.51	2886.86	2888.23	2127.0
2017-12-07 23:00:00	ES	Futures	2888.23	2890.15	2887.68	2889.6	1524.0
2017-12-07 00:00:00	NQ	Futures	7516.61	7523.45	7513.93	7522.55	1722.0
2017-12-07 01:00:00	NQ	Futures	7522.26	7527.61	7514.52	7516.31	1785.0
2017-12-07 02:00:00	NQ	Futures	7516.61	7516.9	7510.66	7511.25	2112.0
2017-12-07 03:00:00	NQ	Futures	7511.55	7513.33	7506.49	7510.95	3116.0
2017-12-07 04:00:00	NQ	Futures	7510.95	7520.17	7510.95	7515.42	2398.0
2017-12-07 05:00:00	NQ	Futures	7515.71	7522.55	7513.93	7513.93	2308.0
2017-12-07 06:00:00	NQ	Futures	7513.63	7514.52	7501.44	7507.39	3231.0
2017-12-07 07:00:00	NQ	Futures	7507.68	7508.58	7494.89	7495.79	4614.0
2017-12-07 08:00:00	NQ	Futures	7496.08	7511.55	7495.49	7500.84	10057.0
2017-12-07 09:00:00	NQ	Futures	7500.55	7514.23	7481.51	7502.92	52302.0
2017-12-07 10:00:00	NQ	Futures	7502.63	7532.67	7483.3	7529.39	53454.0
2017-12-07 11:00:00	NQ	Futures	7529.39	7537.13	7512.74	7534.45	32635.0
2017-12-07 12:00:00	NQ	Futures	7534.75	7535.05	7521.66	7531.18	23817.0
2017-12-07 13:00:00	NQ	Futures	7531.48	7534.75	7509.47	7518.99	22704.0
2017-12-07 14:00:00	NQ	Futures	7519.58	7522.55	7494.0	7510.95	28815.0
2017-12-07 15:00:00	NQ	Futures	7510.95	7521.36	7505.6	7516.61	27284.0
2017-12-07 16:00:00	NQ	Futures	7516.61	7524.64	7514.23	7524.34	5936.0
2017-12-07 18:00:00	NQ	Futures	7521.36	7529.99	7521.36	7528.8	773.0
2017-12-07 19:00:00	NQ	Futures	7528.8	7532.37	7519.28	7528.8	1578.0
2017-12-07 20:00:00	NQ	Futures	7528.8	7533.86	7525.53	7532.07	988.0
2017-12-07 21:00:00	NQ	Futures	7532.67	7536.24	7530.29	7530.58	920.0
2017-12-07 22:00:00	NQ	Futures	7530.88	7533.86	7529.39	7533.86	291.0
2017-12-07 23:00:00	NQ	Futures	7533.56	7536.24	7532.67	7535.34	503.0
2017-12-07 00:00:00	YM	Futures	26322.0	26330.7	26314.3	26322.0	898.0
2017-12-07 01:00:00	YM	Futures	26320.9	26330.7	26302.4	26305.6	1027.0
2017-12-07 02:00:00	YM	Futures	26304.6	26306.7	26275.2	26277.4	1658.0
2017-12-07 03:00:00	YM	Futures	26278.5	26291.5	26273.0	26283.9	1679.0

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

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