PREVIEW / futures_1hour / 2020-04-05

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-04-05.parquet
  size:    18 KB
  rows:    362

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-04-05 18:00:00	ES	Futures	2727.68	2766.1	2727.4	2759.78	40825.0
2020-04-05 19:00:00	ES	Futures	2759.78	2770.49	2756.22	2764.72	15943.0
2020-04-05 20:00:00	ES	Futures	2764.72	2816.04	2763.35	2801.5	56748.0
2020-04-05 21:00:00	ES	Futures	2801.5	2807.81	2789.7	2806.16	26549.0
2020-04-05 22:00:00	ES	Futures	2806.44	2816.04	2800.12	2811.65	18954.0
2020-04-05 23:00:00	ES	Futures	2811.92	2824.27	2806.44	2817.14	17861.0
2020-04-05 18:00:00	NQ	Futures	8610.07	8740.6	8609.78	8715.18	8422.0
2020-04-05 19:00:00	NQ	Futures	8713.75	8748.6	8711.47	8744.6	4205.0
2020-04-05 20:00:00	NQ	Futures	8746.32	8930.84	8741.75	8891.42	20294.0
2020-04-05 21:00:00	NQ	Futures	8891.42	8917.99	8870.0	8901.13	10274.0
2020-04-05 22:00:00	NQ	Futures	8901.42	8913.99	8851.43	8884.85	9491.0
2020-04-05 23:00:00	NQ	Futures	8885.99	8915.99	8869.71	8898.85	4927.0
2020-04-05 18:00:00	YM	Futures	22940.3	23297.4	22940.3	23196.6	4797.0
2020-04-05 19:00:00	YM	Futures	23206.5	23287.5	23185.7	23259.1	2682.0
2020-04-05 20:00:00	YM	Futures	23261.3	23719.1	23248.1	23590.9	10210.0
2020-04-05 21:00:00	YM	Futures	23587.7	23649.0	23468.3	23600.8	6139.0
2020-04-05 22:00:00	YM	Futures	23603.0	23699.4	23572.3	23662.1	4396.0
2020-04-05 23:00:00	YM	Futures	23663.2	23759.6	23618.3	23704.9	3550.0
2020-04-05 18:00:00	CL	Futures	23.17	23.67	22.45	23.24	33919.0
2020-04-05 19:00:00	CL	Futures	23.24	23.43	23.09	23.43	9486.0
2020-04-05 20:00:00	CL	Futures	23.43	23.78	22.95	23.62	26823.0
2020-04-05 21:00:00	CL	Futures	23.61	23.73	23.48	23.69	10716.0
2020-04-05 22:00:00	CL	Futures	23.68	24.12	23.61	24.08	14825.0
2020-04-05 23:00:00	CL	Futures	24.08	24.35	24.01	24.28	13772.0
2020-04-05 18:00:00	GC	Futures	2055.9	2059.5	2045.4	2052.6	4130.0
2020-04-05 19:00:00	GC	Futures	2052.6	2060.8	2048.8	2060.0	2405.0
2020-04-05 20:00:00	GC	Futures	2060.2	2063.9	2049.2	2053.1	4549.0
2020-04-05 21:00:00	GC	Futures	2052.9	2057.1	2050.7	2054.9	3921.0
2020-04-05 22:00:00	GC	Futures	2055.1	2056.4	2051.9	2053.9	1417.0
2020-04-05 23:00:00	GC	Futures	2054.1	2055.1	2047.6	2048.3	2072.0
2020-04-05 18:00:00	ZN	Futures	138.17706	138.223662	138.06832	138.208128	8393.0
2020-04-05 19:00:00	ZN	Futures	138.208128	138.208128	138.099389	138.114923	3560.0
2020-04-05 20:00:00	ZN	Futures	138.114923	138.114923	137.95958	138.037252	20594.0
2020-04-05 21:00:00	ZN	Futures	138.037252	138.052786	137.990649	138.006183	10591.0
2020-04-05 22:00:00	ZN	Futures	138.006183	138.006183	137.944046	137.990649	6869.0
2020-04-05 23:00:00	ZN	Futures	138.006183	138.006183	137.95958	138.006183	3051.0

> showing 36 of 362 rows — these rows as CSV

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