PREVIEW / futures_1hour / 2020-09-06

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-09-06.parquet
  size:    15 KB
  rows:    307

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-09-06 18:00:00	ES	Futures	3820.61	3823.12	3775.65	3801.62	23491.0
2020-09-06 19:00:00	ES	Futures	3801.62	3815.58	3797.99	3803.02	10910.0
2020-09-06 20:00:00	ES	Futures	3803.02	3820.89	3793.52	3813.07	17247.0
2020-09-06 21:00:00	ES	Futures	3813.35	3819.77	3807.21	3814.19	10779.0
2020-09-06 22:00:00	ES	Futures	3814.47	3816.14	3800.23	3811.12	8867.0
2020-09-06 23:00:00	ES	Futures	3811.39	3815.02	3809.16	3813.63	4302.0
2020-09-06 18:00:00	NQ	Futures	13338.07	13358.02	13079.26	13205.63	14217.0
2020-09-06 19:00:00	NQ	Futures	13208.23	13275.61	13190.88	13205.63	7441.0
2020-09-06 20:00:00	NQ	Futures	13207.65	13279.08	13154.73	13244.67	7553.0
2020-09-06 21:00:00	NQ	Futures	13245.53	13277.34	13213.15	13243.22	5797.0
2020-09-06 22:00:00	NQ	Futures	13245.53	13264.91	13192.9	13257.97	5642.0
2020-09-06 23:00:00	NQ	Futures	13259.13	13263.17	13237.73	13256.23	3265.0
2020-09-06 18:00:00	YM	Futures	30981.7	30986.1	30706.4	30887.0	3875.0
2020-09-06 19:00:00	YM	Futures	30890.3	30988.3	30865.0	30899.1	2224.0
2020-09-06 20:00:00	YM	Futures	30899.1	31037.8	30822.0	30988.3	4118.0
2020-09-06 21:00:00	YM	Futures	30992.7	31044.4	30953.0	31000.4	2452.0
2020-09-06 22:00:00	YM	Futures	31004.8	31020.2	30878.2	30951.9	1977.0
2020-09-06 23:00:00	YM	Futures	30951.9	30983.9	30938.7	30974.0	813.0
2020-09-06 18:00:00	CL	Futures	27.37	27.37	26.72	26.97	10094.0
2020-09-06 19:00:00	CL	Futures	26.96	26.99	26.83	26.86	3283.0
2020-09-06 20:00:00	CL	Futures	26.87	27.16	26.87	27.11	5228.0
2020-09-06 21:00:00	CL	Futures	27.12	27.44	27.1	27.25	5946.0
2020-09-06 22:00:00	CL	Futures	27.25	27.28	27.15	27.24	3496.0
2020-09-06 23:00:00	CL	Futures	27.23	27.31	27.21	27.27	1488.0
2020-09-06 18:00:00	GC	Futures	2356.9	2364.8	2356.4	2363.5	2783.0
2020-09-06 19:00:00	GC	Futures	2363.4	2364.1	2359.6	2360.1	1887.0
2020-09-06 20:00:00	GC	Futures	2360.2	2362.5	2358.1	2358.3	2129.0
2020-09-06 21:00:00	GC	Futures	2358.3	2368.1	2356.4	2366.2	8951.0
2020-09-06 22:00:00	GC	Futures	2366.3	2368.5	2363.9	2365.1	5991.0
2020-09-06 23:00:00	GC	Futures	2365.2	2366.0	2360.9	2361.1	4336.0
2020-09-06 18:00:00	ZN	Futures	138.914012	138.94518	138.898429	138.929596	149.0
2020-09-06 19:00:00	ZN	Futures	138.914012	138.914012	138.914012	138.914012	2.0
2020-09-06 20:00:00	ZN	Futures	138.929596	138.929596	138.929596	138.929596	1.0
2020-09-06 23:00:00	ZN	Futures	138.882845	138.898429	138.882845	138.898429	50.0

> showing 34 of 307 rows — these rows as CSV

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