PREVIEW / futures_1hour / 2019-07-23

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-07-23.parquet
  size:    57 KB
  rows:    1,817

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
2019-07-23 00:00:00	ES	Futures	3239.53	3240.34	3238.99	3239.53	3508.0
2019-07-23 01:00:00	ES	Futures	3239.53	3239.8	3236.55	3237.36	6206.0
2019-07-23 02:00:00	ES	Futures	3237.36	3240.34	3237.36	3240.34	8108.0
2019-07-23 03:00:00	ES	Futures	3240.34	3242.23	3238.72	3240.34	20160.0
2019-07-23 04:00:00	ES	Futures	3240.34	3244.67	3240.34	3243.86	18233.0
2019-07-23 05:00:00	ES	Futures	3244.13	3244.4	3242.78	3243.86	11175.0
2019-07-23 06:00:00	ES	Futures	3243.86	3246.84	3243.59	3245.48	19085.0
2019-07-23 07:00:00	ES	Futures	3245.48	3247.38	3244.94	3245.75	21082.0
2019-07-23 08:00:00	ES	Futures	3245.48	3249.54	3245.48	3248.46	25183.0
2019-07-23 09:00:00	ES	Futures	3248.73	3249.27	3241.15	3242.23	130606.0
2019-07-23 10:00:00	ES	Futures	3242.23	3246.3	3238.44	3244.4	134042.0
2019-07-23 11:00:00	ES	Futures	3244.4	3245.48	3238.72	3240.07	102450.0
2019-07-23 12:00:00	ES	Futures	3240.34	3245.21	3237.9	3244.67	68077.0
2019-07-23 13:00:00	ES	Futures	3244.94	3255.77	3243.32	3254.42	142188.0
2019-07-23 14:00:00	ES	Futures	3254.42	3255.77	3250.9	3254.96	84259.0
2019-07-23 15:00:00	ES	Futures	3254.96	3257.39	3252.25	3256.58	138638.0
2019-07-23 16:00:00	ES	Futures	3256.85	3257.66	3249.0	3251.71	58606.0
2019-07-23 18:00:00	ES	Futures	3251.71	3253.87	3251.17	3253.33	4891.0
2019-07-23 19:00:00	ES	Futures	3253.06	3254.69	3252.25	3254.42	3682.0
2019-07-23 20:00:00	ES	Futures	3254.42	3254.42	3251.17	3252.79	7544.0
2019-07-23 21:00:00	ES	Futures	3252.79	3256.85	3252.79	3255.77	11089.0
2019-07-23 22:00:00	ES	Futures	3256.04	3257.39	3255.23	3257.12	5175.0
2019-07-23 23:00:00	ES	Futures	3257.12	3257.39	3256.04	3256.58	3110.0
2019-07-23 00:00:00	NQ	Futures	9202.16	9207.09	9201.58	9203.61	1363.0
2019-07-23 01:00:00	NQ	Futures	9203.61	9204.77	9194.61	9197.81	2049.0
2019-07-23 02:00:00	NQ	Futures	9197.81	9210.86	9197.52	9210.28	3390.0
2019-07-23 03:00:00	NQ	Futures	9209.99	9216.95	9203.32	9211.73	5161.0
2019-07-23 04:00:00	NQ	Futures	9211.44	9223.92	9211.44	9221.89	5383.0
2019-07-23 05:00:00	NQ	Futures	9221.6	9225.95	9219.28	9223.92	3196.0
2019-07-23 06:00:00	NQ	Futures	9224.21	9236.1	9222.18	9229.43	5014.0
2019-07-23 07:00:00	NQ	Futures	9229.43	9237.26	9225.37	9226.82	4632.0
2019-07-23 08:00:00	NQ	Futures	9227.11	9243.07	9226.82	9236.97	7386.0
2019-07-23 09:00:00	NQ	Futures	9236.97	9241.62	9203.9	9206.22	45998.0
2019-07-23 10:00:00	NQ	Futures	9205.93	9221.02	9184.46	9213.18	57977.0
2019-07-23 11:00:00	NQ	Futures	9213.18	9218.99	9185.91	9192.29	43169.0
2019-07-23 12:00:00	NQ	Futures	9191.71	9207.38	9177.79	9205.64	30133.0
2019-07-23 13:00:00	NQ	Futures	9205.93	9239.88	9201.58	9236.1	39603.0
2019-07-23 14:00:00	NQ	Futures	9236.1	9240.17	9223.34	9237.26	24637.0
2019-07-23 15:00:00	NQ	Futures	9237.26	9250.61	9227.69	9249.74	32325.0
2019-07-23 16:00:00	NQ	Futures	9249.74	9268.02	9205.35	9216.66	23913.0
2019-07-23 18:00:00	NQ	Futures	9219.57	9231.17	9218.7	9227.69	3090.0
2019-07-23 19:00:00	NQ	Futures	9227.69	9232.04	9224.5	9230.88	1621.0
2019-07-23 20:00:00	NQ	Futures	9230.88	9230.88	9219.57	9224.5	3348.0
2019-07-23 21:00:00	NQ	Futures	9224.79	9241.91	9224.21	9240.46	5764.0
2019-07-23 22:00:00	NQ	Futures	9240.75	9248.87	9238.72	9247.71	3165.0
2019-07-23 23:00:00	NQ	Futures	9248.0	9250.03	9244.81	9247.71	2084.0
2019-07-23 00:00:00	YM	Futures	29589.8	29600.7	29589.8	29595.2	882.0
2019-07-23 01:00:00	YM	Futures	29595.2	29596.3	29565.9	29572.4	1246.0
2019-07-23 02:00:00	YM	Futures	29573.5	29594.1	29572.4	29589.8	1643.0
2019-07-23 03:00:00	YM	Futures	29590.9	29608.3	29581.1	29594.1	3341.0

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

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