PREVIEW / futures_1hour / 2018-01-16

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-01-16.parquet
  size:    56 KB
  rows:    1,704

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-16 00:00:00	ES	Futures	3057.45	3058.27	3056.9	3057.99	4534.0
2018-01-16 01:00:00	ES	Futures	3057.99	3059.36	3057.99	3058.54	4270.0
2018-01-16 02:00:00	ES	Futures	3058.54	3059.36	3057.72	3058.54	6351.0
2018-01-16 03:00:00	ES	Futures	3058.54	3062.91	3058.27	3059.63	27120.0
2018-01-16 04:00:00	ES	Futures	3059.63	3064.01	3059.09	3063.19	20913.0
2018-01-16 05:00:00	ES	Futures	3062.91	3065.1	3062.64	3064.55	16488.0
2018-01-16 06:00:00	ES	Futures	3064.83	3065.1	3061.82	3062.09	16633.0
2018-01-16 07:00:00	ES	Futures	3061.82	3062.09	3059.63	3061.55	18178.0
2018-01-16 08:00:00	ES	Futures	3061.55	3063.73	3060.45	3063.19	30456.0
2018-01-16 09:00:00	ES	Futures	3063.46	3070.57	3061.27	3069.47	214159.0
2018-01-16 10:00:00	ES	Futures	3069.47	3069.75	3054.71	3056.08	257333.0
2018-01-16 11:00:00	ES	Futures	3056.08	3059.09	3050.89	3053.07	230803.0
2018-01-16 12:00:00	ES	Futures	3053.07	3057.45	3050.34	3050.89	97637.0
2018-01-16 13:00:00	ES	Futures	3051.16	3053.62	3043.51	3044.33	144305.0
2018-01-16 14:00:00	ES	Futures	3044.6	3045.42	3027.65	3034.21	284708.0
2018-01-16 15:00:00	ES	Futures	3034.49	3043.78	3034.21	3036.95	272925.0
2018-01-16 16:00:00	ES	Futures	3036.67	3044.33	3036.13	3042.69	93016.0
2018-01-16 18:00:00	ES	Futures	3042.41	3042.96	3038.31	3040.5	14365.0
2018-01-16 19:00:00	ES	Futures	3040.77	3044.05	3039.95	3042.41	12224.0
2018-01-16 20:00:00	ES	Futures	3042.41	3045.69	3041.87	3042.41	15712.0
2018-01-16 21:00:00	ES	Futures	3042.41	3046.51	3041.05	3044.87	8303.0
2018-01-16 22:00:00	ES	Futures	3045.15	3045.15	3043.23	3043.78	4455.0
2018-01-16 23:00:00	ES	Futures	3043.78	3043.78	3041.05	3042.96	7538.0
2018-01-16 00:00:00	NQ	Futures	8057.87	8060.25	8053.42	8057.28	1330.0
2018-01-16 01:00:00	NQ	Futures	8057.28	8060.84	8056.09	8057.28	1227.0
2018-01-16 02:00:00	NQ	Futures	8057.58	8062.62	8056.98	8060.84	1413.0
2018-01-16 03:00:00	NQ	Futures	8060.84	8070.33	8059.65	8065.58	4043.0
2018-01-16 04:00:00	NQ	Futures	8065.58	8078.34	8065.29	8075.96	3977.0
2018-01-16 05:00:00	NQ	Futures	8075.67	8087.53	8075.37	8086.35	3366.0
2018-01-16 06:00:00	NQ	Futures	8086.35	8090.2	8080.71	8082.19	3916.0
2018-01-16 07:00:00	NQ	Futures	8082.19	8083.38	8075.67	8080.71	4072.0
2018-01-16 08:00:00	NQ	Futures	8080.71	8086.35	8077.45	8081.3	6190.0
2018-01-16 09:00:00	NQ	Futures	8081.3	8121.64	8074.19	8111.85	59854.0
2018-01-16 10:00:00	NQ	Futures	8111.85	8117.19	8075.96	8083.68	68455.0
2018-01-16 11:00:00	NQ	Futures	8083.38	8086.94	8051.05	8054.61	71149.0
2018-01-16 12:00:00	NQ	Futures	8054.91	8074.48	8040.37	8046.31	42568.0
2018-01-16 13:00:00	NQ	Futures	8046.31	8054.02	8025.25	8027.32	44488.0
2018-01-16 14:00:00	NQ	Futures	8027.62	8031.77	7983.43	8002.11	77439.0
2018-01-16 15:00:00	NQ	Futures	8002.41	8029.99	8000.93	8005.97	63960.0
2018-01-16 16:00:00	NQ	Futures	8005.97	8029.4	8004.78	8021.1	9692.0
2018-01-16 18:00:00	NQ	Futures	8023.17	8025.84	8001.82	8009.53	3666.0
2018-01-16 19:00:00	NQ	Futures	8009.82	8020.21	8007.16	8014.27	2763.0
2018-01-16 20:00:00	NQ	Futures	8014.57	8034.15	8014.27	8020.8	3928.0
2018-01-16 21:00:00	NQ	Futures	8019.91	8034.15	8016.35	8028.81	4785.0
2018-01-16 22:00:00	NQ	Futures	8028.81	8029.99	8022.58	8024.65	2203.0
2018-01-16 23:00:00	NQ	Futures	8024.36	8024.36	8011.01	8020.5	2097.0
2018-01-16 00:00:00	YM	Futures	28227.4	28243.7	28226.3	28239.3	1153.0
2018-01-16 01:00:00	YM	Futures	28240.4	28264.3	28237.1	28249.1	1858.0
2018-01-16 02:00:00	YM	Futures	28248.0	28266.5	28243.7	28261.1	1825.0
2018-01-16 03:00:00	YM	Futures	28261.1	28308.9	28256.7	28277.4	6192.0

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

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