PREVIEW / futures_1hour / 2020-11-01

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-11-01.parquet
  size:    18 KB
  rows:    390

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-01 18:00:00	ES	Futures	3652.43	3665.32	3633.67	3644.03	28749.0
2020-11-01 19:00:00	ES	Futures	3643.75	3650.75	3636.75	3643.75	21832.0
2020-11-01 20:00:00	ES	Futures	3643.47	3668.4	3640.39	3662.8	26149.0
2020-11-01 21:00:00	ES	Futures	3662.52	3670.92	3657.75	3668.12	12962.0
2020-11-01 22:00:00	ES	Futures	3668.12	3670.36	3660.84	3660.84	6076.0
2020-11-01 23:00:00	ES	Futures	3660.84	3665.6	3658.03	3661.68	8344.0
2020-11-01 18:00:00	NQ	Futures	12776.57	12816.52	12715.49	12736.04	9028.0
2020-11-01 19:00:00	NQ	Futures	12734.89	12764.7	12718.1	12742.12	9074.0
2020-11-01 20:00:00	NQ	Futures	12740.96	12822.88	12730.83	12804.65	11463.0
2020-11-01 21:00:00	NQ	Futures	12804.36	12825.78	12784.39	12811.6	6716.0
2020-11-01 22:00:00	NQ	Futures	12811.02	12819.41	12784.1	12784.96	3077.0
2020-11-01 23:00:00	NQ	Futures	12784.96	12810.44	12780.91	12797.99	4672.0
2020-11-01 18:00:00	YM	Futures	29157.4	29234.8	28936.3	29045.7	4415.0
2020-11-01 19:00:00	YM	Futures	29043.5	29097.7	28990.4	29043.5	4767.0
2020-11-01 20:00:00	YM	Futures	29040.2	29262.4	29013.7	29219.3	6262.0
2020-11-01 21:00:00	YM	Futures	29219.3	29282.3	29161.8	29265.7	3359.0
2020-11-01 22:00:00	YM	Futures	29265.7	29287.9	29206.0	29207.1	1864.0
2020-11-01 23:00:00	YM	Futures	29206.0	29248.1	29182.8	29213.8	2132.0
2020-11-01 18:00:00	CL	Futures	24.12	24.14	23.02	23.26	23170.0
2020-11-01 19:00:00	CL	Futures	23.27	23.49	23.15	23.47	9083.0
2020-11-01 20:00:00	CL	Futures	23.47	23.72	23.43	23.68	11752.0
2020-11-01 21:00:00	CL	Futures	23.68	23.79	23.55	23.55	7712.0
2020-11-01 22:00:00	CL	Futures	23.56	23.62	23.4	23.57	4659.0
2020-11-01 23:00:00	CL	Futures	23.58	23.63	23.52	23.56	2119.0
2020-11-01 18:00:00	GC	Futures	2282.7	2285.8	2280.6	2283.1	2915.0
2020-11-01 19:00:00	GC	Futures	2283.0	2284.0	2279.0	2280.7	2601.0
2020-11-01 20:00:00	GC	Futures	2280.6	2289.3	2278.2	2287.7	7263.0
2020-11-01 21:00:00	GC	Futures	2287.7	2293.8	2287.2	2291.5	5616.0
2020-11-01 22:00:00	GC	Futures	2291.6	2292.5	2288.9	2290.0	2780.0
2020-11-01 23:00:00	GC	Futures	2289.9	2290.0	2285.9	2286.5	2504.0
2020-11-01 18:00:00	ZN	Futures	137.993219	138.118057	137.977614	138.086847	41089.0
2020-11-01 19:00:00	ZN	Futures	138.086847	138.118057	138.071243	138.071243	18268.0
2020-11-01 20:00:00	ZN	Futures	138.086847	138.086847	138.040033	138.055638	17309.0
2020-11-01 21:00:00	ZN	Futures	138.071243	138.071243	138.024428	138.024428	11148.0
2020-11-01 22:00:00	ZN	Futures	138.024428	138.055638	138.024428	138.040033	11435.0
2020-11-01 23:00:00	ZN	Futures	138.040033	138.071243	138.024428	138.055638	8785.0

> showing 36 of 390 rows — these rows as CSV

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