PREVIEW / futures_1hour / 2020-12-27

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-12-27.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-12-27 18:00:00	ES	Futures	4133.65	4162.84	4126.92	4156.67	20157.0
2020-12-27 19:00:00	ES	Futures	4156.95	4161.72	4150.78	4160.32	11891.0
2020-12-27 20:00:00	ES	Futures	4160.32	4167.33	4158.91	4167.05	14364.0
2020-12-27 21:00:00	ES	Futures	4166.77	4172.95	4165.65	4170.98	10784.0
2020-12-27 22:00:00	ES	Futures	4170.98	4176.04	4170.7	4173.79	8651.0
2020-12-27 23:00:00	ES	Futures	4174.07	4174.07	4170.98	4172.11	3687.0
2020-12-27 18:00:00	NQ	Futures	14675.74	14762.28	14651.43	14743.75	8663.0
2020-12-27 19:00:00	NQ	Futures	14744.04	14752.73	14732.76	14746.36	4302.0
2020-12-27 20:00:00	NQ	Futures	14746.94	14779.07	14743.75	14772.12	7522.0
2020-12-27 21:00:00	NQ	Futures	14772.41	14789.2	14769.8	14784.56	3824.0
2020-12-27 22:00:00	NQ	Futures	14784.85	14802.8	14783.12	14794.98	3795.0
2020-12-27 23:00:00	NQ	Futures	14794.98	14795.85	14785.72	14786.59	2108.0
2020-12-27 18:00:00	YM	Futures	33306.9	33484.4	33227.0	33444.5	3665.0
2020-12-27 19:00:00	YM	Futures	33445.6	33482.2	33404.5	33461.1	3330.0
2020-12-27 20:00:00	YM	Futures	33462.2	33515.4	33452.2	33509.9	3528.0
2020-12-27 21:00:00	YM	Futures	33509.9	33555.4	33499.9	33543.2	2930.0
2020-12-27 22:00:00	YM	Futures	33544.3	33574.2	33543.2	33555.4	2018.0
2020-12-27 23:00:00	YM	Futures	33557.6	33558.7	33531.0	33538.7	1086.0
2020-12-27 18:00:00	CL	Futures	32.67	32.67	32.17	32.44	8060.0
2020-12-27 19:00:00	CL	Futures	32.44	32.63	32.34	32.61	4239.0
2020-12-27 20:00:00	CL	Futures	32.61	32.7	32.48	32.65	6220.0
2020-12-27 21:00:00	CL	Futures	32.65	32.69	32.55	32.61	2927.0
2020-12-27 22:00:00	CL	Futures	32.61	32.63	32.55	32.59	1458.0
2020-12-27 23:00:00	CL	Futures	32.59	32.63	32.55	32.62	970.0
2020-12-27 18:00:00	GC	Futures	2287.0	2296.4	2285.3	2293.8	4440.0
2020-12-27 19:00:00	GC	Futures	2293.6	2295.0	2290.9	2292.8	3237.0
2020-12-27 20:00:00	GC	Futures	2292.8	2306.5	2292.8	2305.5	12636.0
2020-12-27 21:00:00	GC	Futures	2305.6	2307.8	2303.2	2303.6	4188.0
2020-12-27 22:00:00	GC	Futures	2303.6	2303.8	2299.5	2301.9	3306.0
2020-12-27 23:00:00	GC	Futures	2301.9	2302.4	2300.2	2301.7	1318.0
2020-12-27 18:00:00	ZN	Futures	138.181217	138.212526	138.087291	138.102945	14338.0
2020-12-27 19:00:00	ZN	Futures	138.102945	138.134254	138.055982	138.055982	14276.0
2020-12-27 20:00:00	ZN	Futures	138.071636	138.071636	137.993364	138.009019	13367.0
2020-12-27 21:00:00	ZN	Futures	138.009019	138.040328	137.993364	138.040328	3148.0
2020-12-27 22:00:00	ZN	Futures	138.040328	138.055982	138.024673	138.055982	5723.0
2020-12-27 23:00:00	ZN	Futures	138.040328	138.055982	138.024673	138.055982	4371.0

> showing 36 of 390 rows — these rows as CSV

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