PREVIEW / futures_1hour / 2018-01-25

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-01-25.parquet
  size:    57 KB
  rows:    1,713

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-25 00:00:00	ES	Futures	3103.37	3105.01	3102.55	3104.73	3655.0
2018-01-25 01:00:00	ES	Futures	3105.01	3105.01	3103.91	3104.19	2232.0
2018-01-25 02:00:00	ES	Futures	3104.19	3106.1	3100.91	3102.0	12119.0
2018-01-25 03:00:00	ES	Futures	3102.0	3107.47	3100.91	3106.65	16867.0
2018-01-25 04:00:00	ES	Futures	3106.37	3110.47	3105.83	3110.2	11940.0
2018-01-25 05:00:00	ES	Futures	3110.2	3112.66	3108.56	3111.84	12015.0
2018-01-25 06:00:00	ES	Futures	3111.84	3113.21	3111.29	3112.39	8293.0
2018-01-25 07:00:00	ES	Futures	3112.66	3116.21	3112.39	3113.75	18366.0
2018-01-25 08:00:00	ES	Futures	3113.75	3120.04	3113.21	3118.67	49292.0
2018-01-25 09:00:00	ES	Futures	3118.4	3119.22	3098.17	3101.18	254375.0
2018-01-25 10:00:00	ES	Futures	3101.18	3108.56	3098.45	3105.01	232569.0
2018-01-25 11:00:00	ES	Futures	3105.28	3112.93	3103.64	3109.65	127111.0
2018-01-25 12:00:00	ES	Futures	3109.93	3113.48	3107.74	3109.11	88857.0
2018-01-25 13:00:00	ES	Futures	3109.11	3111.84	3105.55	3110.2	81363.0
2018-01-25 14:00:00	ES	Futures	3110.2	3111.02	3097.63	3098.99	145251.0
2018-01-25 15:00:00	ES	Futures	3099.27	3105.83	3094.89	3104.73	176745.0
2018-01-25 16:00:00	ES	Futures	3105.01	3108.01	3104.46	3107.47	61180.0
2018-01-25 18:00:00	ES	Futures	3107.47	3109.38	3106.37	3108.56	7071.0
2018-01-25 19:00:00	ES	Futures	3108.83	3110.47	3108.29	3108.29	5528.0
2018-01-25 20:00:00	ES	Futures	3108.29	3111.57	3107.47	3111.02	8027.0
2018-01-25 21:00:00	ES	Futures	3111.02	3112.66	3109.93	3110.47	6294.0
2018-01-25 22:00:00	ES	Futures	3110.47	3112.39	3109.93	3111.02	4410.0
2018-01-25 23:00:00	ES	Futures	3111.29	3111.84	3110.75	3111.57	2338.0
2018-01-25 00:00:00	NQ	Futures	8221.0	8227.52	8218.63	8227.52	1439.0
2018-01-25 01:00:00	NQ	Futures	8227.23	8227.52	8221.89	8222.78	736.0
2018-01-25 02:00:00	NQ	Futures	8222.78	8229.9	8215.07	8218.33	1994.0
2018-01-25 03:00:00	NQ	Futures	8218.63	8243.54	8215.96	8239.39	4053.0
2018-01-25 04:00:00	NQ	Futures	8239.98	8256.29	8234.05	8255.4	4435.0
2018-01-25 05:00:00	NQ	Futures	8255.4	8265.49	8245.02	8258.67	4813.0
2018-01-25 06:00:00	NQ	Futures	8258.96	8263.12	8257.18	8259.56	2192.0
2018-01-25 07:00:00	NQ	Futures	8259.85	8272.01	8258.96	8266.68	4482.0
2018-01-25 08:00:00	NQ	Futures	8266.97	8289.51	8265.49	8283.88	13182.0
2018-01-25 09:00:00	NQ	Futures	8283.58	8286.25	8205.28	8215.36	79394.0
2018-01-25 10:00:00	NQ	Futures	8215.36	8241.76	8207.36	8234.94	82259.0
2018-01-25 11:00:00	NQ	Futures	8235.24	8262.52	8230.49	8260.15	38430.0
2018-01-25 12:00:00	NQ	Futures	8260.15	8267.56	8237.31	8238.8	30376.0
2018-01-25 13:00:00	NQ	Futures	8238.5	8252.74	8226.04	8247.99	26117.0
2018-01-25 14:00:00	NQ	Futures	8247.99	8249.47	8197.87	8204.39	49878.0
2018-01-25 15:00:00	NQ	Futures	8204.69	8220.11	8188.37	8214.47	47231.0
2018-01-25 16:00:00	NQ	Futures	8214.77	8232.27	8212.1	8231.68	10251.0
2018-01-25 18:00:00	NQ	Futures	8231.08	8237.61	8226.63	8235.83	1740.0
2018-01-25 19:00:00	NQ	Futures	8235.83	8241.46	8235.83	8236.42	1520.0
2018-01-25 20:00:00	NQ	Futures	8236.13	8250.07	8232.27	8246.8	2764.0
2018-01-25 21:00:00	NQ	Futures	8247.1	8252.14	8241.46	8245.32	1928.0
2018-01-25 22:00:00	NQ	Futures	8245.32	8253.03	8243.84	8248.58	1249.0
2018-01-25 23:00:00	NQ	Futures	8248.88	8253.03	8248.88	8251.85	1059.0
2018-01-25 00:00:00	YM	Futures	28541.5	28557.8	28533.9	28557.8	899.0
2018-01-25 01:00:00	YM	Futures	28557.8	28565.4	28548.0	28555.6	845.0
2018-01-25 02:00:00	YM	Futures	28554.5	28562.1	28504.5	28518.6	2242.0
2018-01-25 03:00:00	YM	Futures	28517.6	28565.4	28510.0	28555.6	2890.0

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

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