PREVIEW / futures_1hour / 2020-11-08

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-11-08.parquet
  size:    18 KB
  rows:    401

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
2020-11-08 18:00:00	ES	Futures	3946.53	3973.42	3938.97	3963.06	31729.0
2020-11-08 19:00:00	ES	Futures	3963.06	3977.62	3959.14	3974.54	17702.0
2020-11-08 20:00:00	ES	Futures	3974.26	3984.62	3973.42	3978.74	21710.0
2020-11-08 21:00:00	ES	Futures	3978.74	3982.38	3975.66	3980.98	10334.0
2020-11-08 22:00:00	ES	Futures	3980.98	3988.55	3977.9	3986.87	10126.0
2020-11-08 23:00:00	ES	Futures	3986.87	3993.87	3986.59	3989.95	15033.0
2020-11-08 18:00:00	NQ	Futures	14055.73	14192.94	14035.76	14164.86	13325.0
2020-11-08 19:00:00	NQ	Futures	14164.86	14255.75	14149.52	14229.7	8865.0
2020-11-08 20:00:00	NQ	Futures	14229.41	14306.7	14229.12	14267.33	11291.0
2020-11-08 21:00:00	NQ	Futures	14267.33	14293.96	14255.75	14275.44	6044.0
2020-11-08 22:00:00	NQ	Futures	14274.57	14328.7	14263.57	14313.07	4707.0
2020-11-08 23:00:00	NQ	Futures	14313.07	14367.78	14309.31	14350.7	8899.0
2020-11-08 18:00:00	YM	Futures	31384.1	31601.9	31320.0	31511.3	4192.0
2020-11-08 19:00:00	YM	Futures	31510.2	31567.6	31470.4	31548.9	3675.0
2020-11-08 20:00:00	YM	Futures	31547.7	31608.6	31532.3	31568.8	4445.0
2020-11-08 21:00:00	YM	Futures	31566.5	31586.4	31535.6	31582.0	2292.0
2020-11-08 22:00:00	YM	Futures	31583.1	31639.5	31557.7	31620.7	2348.0
2020-11-08 23:00:00	YM	Futures	31621.8	31646.1	31596.4	31606.3	2680.0
2020-11-08 18:00:00	CL	Futures	25.55	25.95	25.43	25.85	5360.0
2020-11-08 19:00:00	CL	Futures	25.86	25.98	25.79	25.95	4570.0
2020-11-08 20:00:00	CL	Futures	25.95	26.26	25.94	26.07	11272.0
2020-11-08 21:00:00	CL	Futures	26.07	26.18	26.06	26.16	3500.0
2020-11-08 22:00:00	CL	Futures	26.17	26.18	26.09	26.13	2327.0
2020-11-08 23:00:00	CL	Futures	26.13	26.18	26.09	26.11	1732.0
2020-11-08 18:00:00	GC	Futures	2378.8	2385.0	2377.0	2383.4	5258.0
2020-11-08 19:00:00	GC	Futures	2383.4	2383.4	2375.9	2378.1	4029.0
2020-11-08 20:00:00	GC	Futures	2378.1	2382.3	2376.7	2379.3	7211.0
2020-11-08 21:00:00	GC	Futures	2379.3	2380.9	2377.7	2380.8	2932.0
2020-11-08 22:00:00	GC	Futures	2380.8	2386.8	2379.2	2386.4	4653.0
2020-11-08 23:00:00	GC	Futures	2386.4	2390.6	2385.3	2388.1	5556.0
2020-11-08 18:00:00	ZN	Futures	138.320919	138.352129	138.274105	138.352129	17458.0
2020-11-08 19:00:00	ZN	Futures	138.352129	138.383338	138.336524	138.336524	13667.0
2020-11-08 20:00:00	ZN	Futures	138.336524	138.398943	138.336524	138.383338	9158.0
2020-11-08 21:00:00	ZN	Futures	138.383338	138.398943	138.336524	138.352129	10465.0
2020-11-08 22:00:00	ZN	Futures	138.336524	138.367734	138.320919	138.367734	7394.0
2020-11-08 23:00:00	ZN	Futures	138.352129	138.383338	138.336524	138.383338	8315.0

> showing 36 of 401 rows — these rows as CSV

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