PREVIEW / futures_1hour / 2018-01-23

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-01-23.parquet
  size:    55 KB
  rows:    1,703

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-01-23 00:00:00	ES	Futures	3102.82	3104.73	3102.82	3103.91	5689.0
2018-01-23 01:00:00	ES	Futures	3103.91	3105.55	3103.64	3104.19	6314.0
2018-01-23 02:00:00	ES	Futures	3104.19	3107.19	3104.19	3105.28	10791.0
2018-01-23 03:00:00	ES	Futures	3105.55	3106.1	3103.91	3105.55	19772.0
2018-01-23 04:00:00	ES	Futures	3105.55	3106.1	3103.64	3105.01	17619.0
2018-01-23 05:00:00	ES	Futures	3105.28	3105.28	3102.0	3102.55	11579.0
2018-01-23 06:00:00	ES	Futures	3102.55	3102.55	3092.71	3097.35	47635.0
2018-01-23 07:00:00	ES	Futures	3097.35	3099.54	3096.26	3098.17	25698.0
2018-01-23 08:00:00	ES	Futures	3098.17	3098.72	3096.26	3096.26	26349.0
2018-01-23 09:00:00	ES	Futures	3096.26	3106.65	3095.99	3099.27	225888.0
2018-01-23 10:00:00	ES	Futures	3099.54	3109.11	3097.08	3108.29	189323.0
2018-01-23 11:00:00	ES	Futures	3108.29	3110.2	3102.27	3103.91	137316.0
2018-01-23 12:00:00	ES	Futures	3103.91	3105.55	3101.45	3104.19	60923.0
2018-01-23 13:00:00	ES	Futures	3104.19	3108.56	3102.82	3108.01	62709.0
2018-01-23 14:00:00	ES	Futures	3108.29	3108.83	3101.73	3106.92	86476.0
2018-01-23 15:00:00	ES	Futures	3107.19	3109.11	3103.09	3105.55	160191.0
2018-01-23 16:00:00	ES	Futures	3105.83	3106.1	3101.73	3103.09	61996.0
2018-01-23 18:00:00	ES	Futures	3101.73	3103.91	3101.45	3103.64	8215.0
2018-01-23 19:00:00	ES	Futures	3103.37	3106.1	3103.37	3105.01	6038.0
2018-01-23 20:00:00	ES	Futures	3105.01	3106.65	3104.19	3104.73	5837.0
2018-01-23 21:00:00	ES	Futures	3104.46	3105.01	3102.27	3102.82	5256.0
2018-01-23 22:00:00	ES	Futures	3103.09	3104.19	3102.55	3103.91	3417.0
2018-01-23 23:00:00	ES	Futures	3103.91	3104.73	3103.37	3103.91	3057.0
2018-01-23 00:00:00	NQ	Futures	8239.39	8242.06	8237.02	8238.5	1455.0
2018-01-23 01:00:00	NQ	Futures	8238.8	8245.02	8238.5	8243.54	1471.0
2018-01-23 02:00:00	NQ	Futures	8243.54	8254.81	8242.35	8248.29	2557.0
2018-01-23 03:00:00	NQ	Futures	8248.29	8250.07	8242.65	8246.21	3358.0
2018-01-23 04:00:00	NQ	Futures	8246.21	8248.58	8241.76	8244.73	2093.0
2018-01-23 05:00:00	NQ	Futures	8245.02	8245.32	8234.64	8236.42	2016.0
2018-01-23 06:00:00	NQ	Futures	8236.72	8236.72	8209.43	8222.78	8623.0
2018-01-23 07:00:00	NQ	Futures	8222.78	8233.16	8222.48	8229.01	5294.0
2018-01-23 08:00:00	NQ	Futures	8229.3	8231.38	8217.14	8217.44	7428.0
2018-01-23 09:00:00	NQ	Futures	8217.74	8261.93	8216.55	8241.46	65677.0
2018-01-23 10:00:00	NQ	Futures	8241.76	8275.87	8237.02	8272.61	62758.0
2018-01-23 11:00:00	NQ	Futures	8272.9	8279.43	8258.37	8261.34	33250.0
2018-01-23 12:00:00	NQ	Futures	8261.34	8273.5	8258.07	8261.34	20784.0
2018-01-23 13:00:00	NQ	Futures	8261.63	8278.54	8258.37	8277.35	18874.0
2018-01-23 14:00:00	NQ	Futures	8277.65	8277.95	8247.1	8267.27	38012.0
2018-01-23 15:00:00	NQ	Futures	8267.27	8282.39	8261.04	8273.5	35272.0
2018-01-23 16:00:00	NQ	Futures	8274.09	8275.57	8252.14	8257.18	10951.0
2018-01-23 18:00:00	NQ	Futures	8253.03	8260.45	8251.25	8256.89	2078.0
2018-01-23 19:00:00	NQ	Futures	8257.18	8267.56	8256.0	8263.41	2023.0
2018-01-23 20:00:00	NQ	Futures	8263.71	8268.16	8263.12	8264.3	1434.0
2018-01-23 21:00:00	NQ	Futures	8264.01	8264.3	8255.4	8256.59	1455.0
2018-01-23 22:00:00	NQ	Futures	8256.89	8262.82	8256.59	8262.52	1228.0
2018-01-23 23:00:00	NQ	Futures	8262.82	8265.79	8261.04	8263.41	899.0
2018-01-23 00:00:00	YM	Futures	28536.0	28566.5	28531.7	28541.5	3191.0
2018-01-23 01:00:00	YM	Futures	28541.5	28570.8	28540.4	28558.9	2879.0
2018-01-23 02:00:00	YM	Futures	28558.9	28601.3	28558.9	28582.8	2922.0
2018-01-23 03:00:00	YM	Futures	28582.8	28583.9	28561.0	28574.1	2717.0

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

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