PREVIEW / futures_1hour / 2020-04-26

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-04-26.parquet
  size:    18 KB
  rows:    360

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-26 18:00:00	ES	Futures	3105.27	3125.03	3087.44	3090.18	23775.0
2020-04-26 19:00:00	ES	Futures	3090.45	3100.88	3090.45	3094.57	9513.0
2020-04-26 20:00:00	ES	Futures	3094.57	3105.0	3089.08	3103.63	12208.0
2020-04-26 21:00:00	ES	Futures	3103.9	3113.5	3097.31	3111.31	13614.0
2020-04-26 22:00:00	ES	Futures	3111.31	3119.82	3110.49	3113.5	10397.0
2020-04-26 23:00:00	ES	Futures	3113.5	3122.56	3113.5	3121.74	10181.0
2020-04-26 18:00:00	NQ	Futures	10015.7	10071.4	9974.57	9977.71	5859.0
2020-04-26 19:00:00	NQ	Futures	9978.28	10020.27	9978.28	10001.14	2880.0
2020-04-26 20:00:00	NQ	Futures	10001.99	10039.7	9984.0	10037.98	5074.0
2020-04-26 21:00:00	NQ	Futures	10038.55	10066.55	10019.99	10061.12	5487.0
2020-04-26 22:00:00	NQ	Futures	10062.26	10088.26	10057.98	10076.54	3957.0
2020-04-26 23:00:00	NQ	Futures	10076.26	10099.11	10075.69	10096.83	3511.0
2020-04-26 18:00:00	YM	Futures	25901.0	26013.8	25778.3	25817.7	3975.0
2020-04-26 19:00:00	YM	Futures	25821.0	25899.9	25819.9	25852.8	2172.0
2020-04-26 20:00:00	YM	Futures	25857.2	25933.8	25806.8	25926.2	2504.0
2020-04-26 21:00:00	YM	Futures	25930.5	26006.1	25868.1	25976.5	2714.0
2020-04-26 22:00:00	YM	Futures	25975.5	26057.6	25967.8	26001.7	2208.0
2020-04-26 23:00:00	YM	Futures	26002.8	26068.6	26000.6	26062.0	1433.0
2020-04-26 18:00:00	CL	Futures	11.91	12.0	11.45	11.74	8190.0
2020-04-26 19:00:00	CL	Futures	11.71	11.86	11.64	11.75	2555.0
2020-04-26 20:00:00	CL	Futures	11.75	11.79	11.22	11.48	9015.0
2020-04-26 21:00:00	CL	Futures	11.47	11.54	10.77	11.11	16621.0
2020-04-26 22:00:00	CL	Futures	11.11	11.31	11.02	11.21	6529.0
2020-04-26 23:00:00	CL	Futures	11.21	11.28	10.86	11.1	7288.0
2020-04-26 18:00:00	GC	Futures	2177.3	2178.3	2167.5	2171.5	2755.0
2020-04-26 19:00:00	GC	Futures	2171.6	2175.8	2171.2	2175.3	1870.0
2020-04-26 20:00:00	GC	Futures	2175.2	2176.1	2170.8	2173.7	2210.0
2020-04-26 21:00:00	GC	Futures	2174.0	2176.1	2168.9	2172.1	4606.0
2020-04-26 22:00:00	GC	Futures	2172.1	2173.3	2170.3	2172.3	2697.0
2020-04-26 23:00:00	GC	Futures	2172.3	2174.8	2171.0	2173.8	1646.0
2020-04-26 18:00:00	ZN	Futures	138.192594	138.239197	138.145991	138.223662	7210.0
2020-04-26 19:00:00	ZN	Futures	138.208128	138.223662	138.161525	138.192594	3030.0
2020-04-26 20:00:00	ZN	Futures	138.17706	138.208128	138.145991	138.161525	7884.0
2020-04-26 21:00:00	ZN	Futures	138.161525	138.161525	138.099389	138.114923	6597.0
2020-04-26 22:00:00	ZN	Futures	138.114923	138.114923	138.06832	138.099389	7738.0
2020-04-26 23:00:00	ZN	Futures	138.083854	138.083854	137.990649	137.990649	14315.0

> showing 36 of 360 rows — these rows as CSV

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