PREVIEW / futures_1hour / 2017-11-17

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-11-17.parquet
  size:    46 KB
  rows:    1,350

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-11-17 00:00:00	ES	Futures	2826.41	2826.41	2824.22	2825.31	5692.0
2017-11-17 01:00:00	ES	Futures	2825.59	2826.41	2825.04	2825.31	3597.0
2017-11-17 02:00:00	ES	Futures	2825.31	2826.68	2824.77	2826.41	10524.0
2017-11-17 03:00:00	ES	Futures	2826.68	2828.05	2823.95	2823.95	35975.0
2017-11-17 04:00:00	ES	Futures	2824.22	2825.04	2822.58	2823.67	18053.0
2017-11-17 05:00:00	ES	Futures	2823.67	2825.31	2822.85	2825.04	14036.0
2017-11-17 06:00:00	ES	Futures	2824.77	2826.95	2824.22	2826.95	13962.0
2017-11-17 07:00:00	ES	Futures	2826.68	2829.14	2826.68	2828.6	15431.0
2017-11-17 08:00:00	ES	Futures	2828.6	2828.87	2825.31	2826.68	24046.0
2017-11-17 09:00:00	ES	Futures	2826.41	2826.95	2821.48	2825.04	199644.0
2017-11-17 10:00:00	ES	Futures	2824.77	2826.68	2822.03	2824.77	153517.0
2017-11-17 11:00:00	ES	Futures	2824.49	2825.04	2820.66	2824.49	131695.0
2017-11-17 12:00:00	ES	Futures	2824.49	2825.59	2822.58	2825.04	65826.0
2017-11-17 13:00:00	ES	Futures	2824.77	2825.59	2822.58	2823.95	59068.0
2017-11-17 14:00:00	ES	Futures	2823.95	2824.77	2822.03	2823.95	60276.0
2017-11-17 15:00:00	ES	Futures	2823.67	2823.95	2819.02	2820.66	200279.0
2017-11-17 16:00:00	ES	Futures	2820.39	2822.03	2817.38	2818.47	97864.0
2017-11-17 00:00:00	NQ	Futures	7548.43	7548.43	7543.97	7545.16	1206.0
2017-11-17 01:00:00	NQ	Futures	7545.46	7547.83	7544.56	7545.46	895.0
2017-11-17 02:00:00	NQ	Futures	7545.16	7549.02	7543.67	7549.02	1808.0
2017-11-17 03:00:00	NQ	Futures	7549.32	7556.46	7544.86	7545.16	4243.0
2017-11-17 04:00:00	NQ	Futures	7544.86	7547.54	7539.21	7543.67	2251.0
2017-11-17 05:00:00	NQ	Futures	7543.97	7548.13	7540.4	7546.94	2464.0
2017-11-17 06:00:00	NQ	Futures	7546.94	7551.11	7545.16	7549.92	2239.0
2017-11-17 07:00:00	NQ	Futures	7549.62	7555.27	7549.32	7553.19	3012.0
2017-11-17 08:00:00	NQ	Futures	7553.49	7553.49	7541.89	7548.43	6752.0
2017-11-17 09:00:00	NQ	Futures	7548.13	7553.49	7536.24	7540.99	47640.0
2017-11-17 10:00:00	NQ	Futures	7541.29	7544.56	7531.77	7542.78	43493.0
2017-11-17 11:00:00	NQ	Futures	7542.48	7545.16	7524.34	7537.13	35960.0
2017-11-17 12:00:00	NQ	Futures	7537.42	7541.29	7530.58	7534.75	24027.0
2017-11-17 13:00:00	NQ	Futures	7534.75	7536.53	7529.69	7532.37	13286.0
2017-11-17 14:00:00	NQ	Futures	7532.37	7533.56	7521.36	7524.64	19845.0
2017-11-17 15:00:00	NQ	Futures	7524.93	7524.93	7510.36	7517.2	38038.0
2017-11-17 16:00:00	NQ	Futures	7516.9	7519.28	7505.01	7506.49	11215.0
2017-11-17 00:00:00	YM	Futures	25470.3	25470.3	25452.9	25460.5	1043.0
2017-11-17 01:00:00	YM	Futures	25461.6	25468.1	25459.4	25459.4	558.0
2017-11-17 02:00:00	YM	Futures	25459.4	25474.7	25457.3	25474.7	1733.0
2017-11-17 03:00:00	YM	Futures	25474.7	25482.3	25448.5	25449.6	3049.0
2017-11-17 04:00:00	YM	Futures	25449.6	25459.4	25436.6	25443.1	1735.0
2017-11-17 05:00:00	YM	Futures	25442.0	25449.6	25432.2	25446.4	1442.0
2017-11-17 06:00:00	YM	Futures	25446.4	25460.5	25443.1	25458.3	1466.0
2017-11-17 07:00:00	YM	Futures	25458.3	25469.2	25456.2	25466.0	1975.0
2017-11-17 08:00:00	YM	Futures	25466.0	25466.0	25413.7	25429.0	5995.0
2017-11-17 09:00:00	YM	Futures	25430.1	25430.1	25377.8	25410.5	22428.0
2017-11-17 10:00:00	YM	Futures	25410.5	25437.7	25387.6	25405.0	20936.0
2017-11-17 11:00:00	YM	Futures	25404.0	25408.3	25370.2	25389.8	13079.0
2017-11-17 12:00:00	YM	Futures	25390.9	25396.3	25376.8	25392.0	6926.0
2017-11-17 13:00:00	YM	Futures	25390.9	25392.0	25376.8	25385.5	6396.0
2017-11-17 14:00:00	YM	Futures	25385.5	25390.9	25371.3	25385.5	6170.0
2017-11-17 15:00:00	YM	Futures	25385.5	25401.8	25372.4	25373.5	13949.0

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

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