PREVIEW / futures_1hour / 2020-06-28

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-06-28.parquet
  size:    18 KB
  rows:    361

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-06-28 18:00:00	ES	Futures	3335.56	3350.92	3332.49	3347.01	34329.0
2020-06-28 19:00:00	ES	Futures	3347.29	3356.23	3340.31	3351.2	21041.0
2020-06-28 20:00:00	ES	Futures	3351.2	3357.62	3343.1	3357.07	24212.0
2020-06-28 21:00:00	ES	Futures	3356.79	3371.31	3356.23	3370.19	28771.0
2020-06-28 22:00:00	ES	Futures	3369.91	3374.38	3358.18	3362.65	20334.0
2020-06-28 23:00:00	ES	Futures	3362.65	3364.88	3351.76	3355.11	14510.0
2020-06-28 18:00:00	NQ	Futures	11319.03	11377.44	11312.95	11366.45	7367.0
2020-06-28 19:00:00	NQ	Futures	11366.45	11382.07	11340.14	11366.74	4866.0
2020-06-28 20:00:00	NQ	Futures	11367.9	11388.14	11349.97	11386.4	4915.0
2020-06-28 21:00:00	NQ	Futures	11385.25	11430.65	11381.2	11427.76	9247.0
2020-06-28 22:00:00	NQ	Futures	11427.76	11429.78	11382.65	11388.72	7218.0
2020-06-28 23:00:00	NQ	Futures	11390.16	11399.13	11366.45	11374.55	6003.0
2020-06-28 18:00:00	YM	Futures	27282.9	27383.1	27245.5	27352.3	7047.0
2020-06-28 19:00:00	YM	Futures	27352.3	27447.0	27291.8	27398.6	3010.0
2020-06-28 20:00:00	YM	Futures	27400.8	27470.1	27336.9	27453.6	3195.0
2020-06-28 21:00:00	YM	Futures	27453.6	27595.7	27448.1	27581.4	5000.0
2020-06-28 22:00:00	YM	Futures	27579.2	27616.6	27464.6	27505.4	3836.0
2020-06-28 23:00:00	YM	Futures	27505.4	27529.6	27394.2	27426.1	3555.0
2020-06-28 18:00:00	CL	Futures	26.63	26.74	26.49	26.59	4965.0
2020-06-28 19:00:00	CL	Futures	26.59	26.61	26.43	26.57	2629.0
2020-06-28 20:00:00	CL	Futures	26.57	26.59	26.43	26.54	3654.0
2020-06-28 21:00:00	CL	Futures	26.53	26.79	26.53	26.63	8230.0
2020-06-28 22:00:00	CL	Futures	26.63	26.64	26.45	26.45	3532.0
2020-06-28 23:00:00	CL	Futures	26.45	26.52	26.36	26.48	4164.0
2020-06-28 18:00:00	GC	Futures	2208.8	2210.3	2205.1	2207.0	5018.0
2020-06-28 19:00:00	GC	Futures	2206.7	2208.0	2202.5	2203.4	1794.0
2020-06-28 20:00:00	GC	Futures	2203.5	2208.1	2201.9	2207.2	2614.0
2020-06-28 21:00:00	GC	Futures	2207.3	2208.5	2199.2	2200.6	6029.0
2020-06-28 22:00:00	GC	Futures	2200.4	2205.5	2199.2	2203.6	3871.0
2020-06-28 23:00:00	GC	Futures	2203.5	2205.9	2202.8	2204.1	2410.0
2020-06-28 18:00:00	ZN	Futures	138.867261	138.929596	138.836093	138.867261	14340.0
2020-06-28 19:00:00	ZN	Futures	138.867261	138.898429	138.867261	138.898429	7071.0
2020-06-28 20:00:00	ZN	Futures	138.882845	138.914012	138.82051	138.82051	18379.0
2020-06-28 21:00:00	ZN	Futures	138.836093	138.851677	138.758174	138.82051	19400.0
2020-06-28 22:00:00	ZN	Futures	138.82051	138.867261	138.789342	138.851677	17723.0
2020-06-28 23:00:00	ZN	Futures	138.836093	138.851677	138.804926	138.851677	15114.0

> showing 36 of 361 rows — these rows as CSV

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