PREVIEW / futures_1hour / 2020-11-22

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-11-22.parquet
  size:    17 KB
  rows:    353

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-22 18:00:00	ES	Futures	3973.42	3986.02	3972.3	3985.74	16665.0
2020-11-22 19:00:00	ES	Futures	3985.46	3994.71	3983.5	3994.71	10270.0
2020-11-22 20:00:00	ES	Futures	3994.43	3995.83	3990.23	3991.91	10549.0
2020-11-22 21:00:00	ES	Futures	3991.91	3994.71	3991.07	3993.59	4086.0
2020-11-22 22:00:00	ES	Futures	3993.31	3996.11	3992.47	3994.71	3135.0
2020-11-22 23:00:00	ES	Futures	3994.43	3995.27	3991.63	3992.75	2981.0
2020-11-22 18:00:00	NQ	Futures	13771.76	13820.39	13768.87	13816.05	5130.0
2020-11-22 19:00:00	NQ	Futures	13815.47	13835.16	13809.39	13833.71	2846.0
2020-11-22 20:00:00	NQ	Futures	13833.71	13839.21	13818.37	13825.31	3542.0
2020-11-22 21:00:00	NQ	Futures	13823.87	13835.74	13821.26	13827.34	1974.0
2020-11-22 22:00:00	NQ	Futures	13827.92	13842.68	13824.45	13838.34	2177.0
2020-11-22 23:00:00	NQ	Futures	13838.34	13841.81	13827.92	13834.87	1840.0
2020-11-22 18:00:00	YM	Futures	32210.0	32320.6	32191.2	32318.4	2908.0
2020-11-22 19:00:00	YM	Futures	32317.3	32394.6	32304.0	32393.5	2303.0
2020-11-22 20:00:00	YM	Futures	32392.4	32425.6	32365.9	32381.4	2880.0
2020-11-22 21:00:00	YM	Futures	32379.2	32400.2	32369.2	32393.5	938.0
2020-11-22 22:00:00	YM	Futures	32391.3	32420.1	32385.8	32410.1	1000.0
2020-11-22 23:00:00	YM	Futures	32409.0	32414.6	32384.7	32395.8	865.0
2020-11-22 18:00:00	CL	Futures	28.86	28.93	28.78	28.86	3342.0
2020-11-22 19:00:00	CL	Futures	28.86	28.87	28.82	28.86	1668.0
2020-11-22 20:00:00	CL	Futures	28.85	28.89	28.74	28.82	3807.0
2020-11-22 21:00:00	CL	Futures	28.82	28.84	28.74	28.82	2230.0
2020-11-22 22:00:00	CL	Futures	28.82	28.9	28.81	28.89	2152.0
2020-11-22 23:00:00	CL	Futures	28.88	28.92	28.87	28.91	1236.0
2020-11-22 18:00:00	GC	Futures	2274.0	2275.8	2270.9	2275.3	1583.0
2020-11-22 19:00:00	GC	Futures	2275.3	2277.4	2274.6	2277.0	1924.0
2020-11-22 20:00:00	GC	Futures	2277.0	2280.3	2275.0	2276.9	4286.0
2020-11-22 21:00:00	GC	Futures	2276.8	2277.3	2272.9	2275.6	3977.0
2020-11-22 22:00:00	GC	Futures	2275.8	2276.9	2275.2	2275.9	1322.0
2020-11-22 23:00:00	GC	Futures	2275.9	2276.4	2275.0	2276.3	1099.0
2020-11-22 18:00:00	ZN	Futures	138.352129	138.367734	138.320919	138.336524	7109.0
2020-11-22 19:00:00	ZN	Futures	138.336524	138.336524	138.28971	138.305314	4902.0
2020-11-22 20:00:00	ZN	Futures	138.305314	138.320919	138.28971	138.28971	3545.0
2020-11-22 21:00:00	ZN	Futures	138.28971	138.320919	138.28971	138.320919	2467.0
2020-11-22 22:00:00	ZN	Futures	138.320919	138.336524	138.305314	138.320919	2221.0
2020-11-22 23:00:00	ZN	Futures	138.320919	138.352129	138.320919	138.320919	3534.0

> showing 36 of 353 rows — these rows as CSV

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