PREVIEW / futures_1hour / 2018-08-20

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-08-20.parquet
  size:    54 KB
  rows:    1,657

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-08-20 00:00:00	ES	Futures	3109.11	3109.66	3107.48	3107.75	2704.0
2018-08-20 01:00:00	ES	Futures	3108.02	3108.3	3106.66	3107.75	4759.0
2018-08-20 02:00:00	ES	Futures	3108.02	3114.02	3107.75	3112.93	10082.0
2018-08-20 03:00:00	ES	Futures	3112.93	3116.2	3112.65	3115.92	15880.0
2018-08-20 04:00:00	ES	Futures	3116.2	3117.01	3114.02	3114.56	10739.0
2018-08-20 05:00:00	ES	Futures	3114.56	3115.65	3113.74	3115.11	8855.0
2018-08-20 06:00:00	ES	Futures	3115.11	3115.38	3112.65	3113.47	6609.0
2018-08-20 07:00:00	ES	Futures	3113.74	3116.2	3111.29	3112.11	10454.0
2018-08-20 08:00:00	ES	Futures	3112.38	3114.02	3111.29	3111.84	13649.0
2018-08-20 09:00:00	ES	Futures	3111.84	3115.38	3109.93	3111.02	131704.0
2018-08-20 10:00:00	ES	Futures	3111.29	3114.83	3107.75	3109.11	136653.0
2018-08-20 11:00:00	ES	Futures	3109.11	3115.11	3108.3	3112.93	82303.0
2018-08-20 12:00:00	ES	Futures	3112.93	3116.2	3112.11	3115.65	53686.0
2018-08-20 13:00:00	ES	Futures	3115.65	3116.47	3114.02	3116.47	32364.0
2018-08-20 14:00:00	ES	Futures	3116.47	3117.29	3114.29	3115.38	54497.0
2018-08-20 15:00:00	ES	Futures	3115.65	3117.83	3114.02	3114.83	117103.0
2018-08-20 16:00:00	ES	Futures	3114.83	3116.47	3113.47	3114.02	52236.0
2018-08-20 18:00:00	ES	Futures	3113.47	3114.29	3112.65	3113.74	3797.0
2018-08-20 19:00:00	ES	Futures	3113.74	3114.02	3112.11	3112.65	1977.0
2018-08-20 20:00:00	ES	Futures	3112.65	3112.93	3110.2	3112.11	8549.0
2018-08-20 21:00:00	ES	Futures	3112.11	3114.56	3111.84	3113.47	7015.0
2018-08-20 22:00:00	ES	Futures	3113.47	3115.38	3112.65	3115.11	5391.0
2018-08-20 23:00:00	ES	Futures	3114.83	3115.92	3114.29	3115.38	3543.0
2018-08-20 00:00:00	NQ	Futures	8712.42	8714.48	8708.59	8709.18	830.0
2018-08-20 01:00:00	NQ	Futures	8709.18	8710.95	8704.47	8709.48	1138.0
2018-08-20 02:00:00	NQ	Futures	8709.77	8729.79	8709.48	8726.55	3261.0
2018-08-20 03:00:00	NQ	Futures	8726.26	8738.33	8725.67	8737.15	5123.0
2018-08-20 04:00:00	NQ	Futures	8736.86	8739.21	8729.2	8731.26	3149.0
2018-08-20 05:00:00	NQ	Futures	8730.68	8735.09	8727.44	8731.85	2273.0
2018-08-20 06:00:00	NQ	Futures	8731.85	8731.85	8723.32	8726.26	2402.0
2018-08-20 07:00:00	NQ	Futures	8726.55	8736.27	8716.84	8720.08	3908.0
2018-08-20 08:00:00	NQ	Futures	8720.37	8723.61	8713.31	8714.78	4025.0
2018-08-20 09:00:00	NQ	Futures	8714.78	8724.79	8668.26	8672.97	55618.0
2018-08-20 10:00:00	NQ	Futures	8672.97	8690.05	8657.66	8664.14	64792.0
2018-08-20 11:00:00	NQ	Futures	8663.84	8687.1	8658.84	8673.56	36759.0
2018-08-20 12:00:00	NQ	Futures	8673.56	8695.35	8668.85	8692.4	23228.0
2018-08-20 13:00:00	NQ	Futures	8692.4	8705.94	8685.34	8705.65	17849.0
2018-08-20 14:00:00	NQ	Futures	8705.65	8711.54	8692.11	8697.41	18838.0
2018-08-20 15:00:00	NQ	Futures	8697.41	8703.88	8689.75	8692.11	21368.0
2018-08-20 16:00:00	NQ	Futures	8692.11	8702.12	8690.63	8691.52	7059.0
2018-08-20 18:00:00	NQ	Futures	8692.7	8695.35	8689.16	8692.4	956.0
2018-08-20 19:00:00	NQ	Futures	8692.11	8693.58	8687.4	8689.16	562.0
2018-08-20 20:00:00	NQ	Futures	8689.46	8689.46	8678.27	8683.86	3281.0
2018-08-20 21:00:00	NQ	Futures	8683.86	8694.17	8681.8	8689.46	2121.0
2018-08-20 22:00:00	NQ	Futures	8690.05	8700.65	8687.4	8698.88	2058.0
2018-08-20 23:00:00	NQ	Futures	8698.88	8706.24	8696.23	8702.12	1470.0
2018-08-20 00:00:00	YM	Futures	27930.8	27937.3	27921.0	27925.3	527.0
2018-08-20 01:00:00	YM	Futures	27925.3	27930.8	27913.4	27927.5	818.0
2018-08-20 02:00:00	YM	Futures	27927.5	27990.6	27924.3	27981.9	2725.0
2018-08-20 03:00:00	YM	Futures	27981.9	28008.0	27976.4	28004.7	3138.0

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

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