PREVIEW / futures_1hour / 2019-06-06

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-06-06.parquet
  size:    58 KB
  rows:    1,795

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-06-06 00:00:00	ES	Futures	3065.62	3065.9	3064.0	3065.35	2551.0
2019-06-06 01:00:00	ES	Futures	3065.62	3065.62	3059.93	3061.02	7346.0
2019-06-06 02:00:00	ES	Futures	3061.02	3065.08	3059.93	3064.54	12450.0
2019-06-06 03:00:00	ES	Futures	3064.27	3075.38	3064.27	3074.3	42025.0
2019-06-06 04:00:00	ES	Futures	3074.3	3075.93	3073.22	3075.38	21649.0
2019-06-06 05:00:00	ES	Futures	3075.11	3077.55	3073.49	3074.57	22887.0
2019-06-06 06:00:00	ES	Futures	3074.57	3076.74	3073.22	3075.11	12623.0
2019-06-06 07:00:00	ES	Futures	3074.84	3077.01	3071.86	3076.2	35308.0
2019-06-06 08:00:00	ES	Futures	3076.47	3076.47	3065.9	3067.52	55457.0
2019-06-06 09:00:00	ES	Futures	3067.52	3074.03	3063.46	3064.54	205246.0
2019-06-06 10:00:00	ES	Futures	3064.81	3072.4	3061.56	3069.15	190880.0
2019-06-06 11:00:00	ES	Futures	3069.15	3075.93	3065.9	3068.34	192901.0
2019-06-06 12:00:00	ES	Futures	3068.34	3074.03	3067.25	3072.4	90367.0
2019-06-06 13:00:00	ES	Futures	3072.67	3074.57	3070.78	3074.03	54898.0
2019-06-06 14:00:00	ES	Futures	3074.3	3084.06	3071.59	3079.18	156726.0
2019-06-06 15:00:00	ES	Futures	3079.18	3093.82	3078.1	3085.14	281456.0
2019-06-06 16:00:00	ES	Futures	3085.41	3087.58	3077.01	3080.26	71750.0
2019-06-06 18:00:00	ES	Futures	3079.72	3081.35	3077.55	3079.18	6807.0
2019-06-06 19:00:00	ES	Futures	3079.18	3085.96	3078.64	3084.6	9282.0
2019-06-06 20:00:00	ES	Futures	3084.87	3087.04	3082.98	3083.52	12369.0
2019-06-06 21:00:00	ES	Futures	3083.79	3086.77	3081.89	3086.5	9930.0
2019-06-06 22:00:00	ES	Futures	3086.77	3091.11	3085.96	3090.02	11394.0
2019-06-06 23:00:00	ES	Futures	3090.02	3090.84	3089.21	3090.29	4330.0
2019-06-06 00:00:00	NQ	Futures	8421.69	8424.31	8416.45	8422.27	1570.0
2019-06-06 01:00:00	NQ	Futures	8421.98	8422.56	8398.11	8400.43	3272.0
2019-06-06 02:00:00	NQ	Futures	8401.02	8416.16	8396.07	8412.95	5260.0
2019-06-06 03:00:00	NQ	Futures	8412.95	8452.55	8410.62	8444.98	14265.0
2019-06-06 04:00:00	NQ	Futures	8444.98	8452.26	8440.61	8448.48	5956.0
2019-06-06 05:00:00	NQ	Futures	8448.18	8460.12	8442.36	8449.64	6434.0
2019-06-06 06:00:00	NQ	Futures	8449.64	8456.05	8445.56	8448.48	4590.0
2019-06-06 07:00:00	NQ	Futures	8448.18	8455.75	8435.96	8451.1	10569.0
2019-06-06 08:00:00	NQ	Futures	8451.39	8451.39	8411.79	8416.45	16739.0
2019-06-06 09:00:00	NQ	Futures	8416.74	8440.61	8397.23	8398.98	69144.0
2019-06-06 10:00:00	NQ	Futures	8398.98	8429.84	8389.95	8416.16	62218.0
2019-06-06 11:00:00	NQ	Futures	8416.45	8447.6	8410.33	8422.27	51374.0
2019-06-06 12:00:00	NQ	Futures	8422.56	8440.03	8416.74	8431.59	25450.0
2019-06-06 13:00:00	NQ	Futures	8431.88	8436.83	8419.65	8434.5	16038.0
2019-06-06 14:00:00	NQ	Futures	8434.79	8472.06	8426.35	8454.01	38433.0
2019-06-06 15:00:00	NQ	Futures	8454.01	8500.88	8451.39	8480.21	60823.0
2019-06-06 16:00:00	NQ	Futures	8480.21	8483.41	8450.51	8458.67	11640.0
2019-06-06 18:00:00	NQ	Futures	8462.74	8466.24	8452.55	8458.37	2245.0
2019-06-06 19:00:00	NQ	Futures	8458.08	8478.17	8456.34	8472.93	3140.0
2019-06-06 20:00:00	NQ	Futures	8473.81	8481.96	8467.98	8471.48	4397.0
2019-06-06 21:00:00	NQ	Futures	8471.48	8477.3	8460.41	8476.43	5327.0
2019-06-06 22:00:00	NQ	Futures	8476.43	8493.9	8473.81	8488.07	5319.0
2019-06-06 23:00:00	NQ	Futures	8488.07	8493.02	8484.87	8490.11	1962.0
2019-06-06 00:00:00	YM	Futures	27806.2	27807.3	27791.0	27802.9	930.0
2019-06-06 01:00:00	YM	Futures	27802.9	27806.2	27758.4	27764.9	1749.0
2019-06-06 02:00:00	YM	Futures	27764.9	27794.2	27748.6	27788.8	3420.0
2019-06-06 03:00:00	YM	Futures	27788.8	27879.1	27783.4	27868.2	7417.0

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

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