PREVIEW / futures_1hour / 2020-04-19

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-04-19.parquet
  size:    17 KB
  rows:    345

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-19 18:00:00	ES	Futures	3140.95	3141.22	3119.54	3127.5	25582.0
2020-04-19 19:00:00	ES	Futures	3127.5	3132.16	3123.38	3126.4	14525.0
2020-04-19 20:00:00	ES	Futures	3126.68	3156.31	3126.68	3149.45	23251.0
2020-04-19 21:00:00	ES	Futures	3149.45	3149.73	3126.68	3137.38	25782.0
2020-04-19 22:00:00	ES	Futures	3137.38	3145.89	3132.44	3141.77	24741.0
2020-04-19 23:00:00	ES	Futures	3141.77	3152.75	3139.85	3151.92	17775.0
2020-04-19 18:00:00	NQ	Futures	10053.98	10053.98	9978.0	9999.14	6225.0
2020-04-19 19:00:00	NQ	Futures	10000.56	10013.13	9983.14	9994.28	3473.0
2020-04-19 20:00:00	NQ	Futures	9994.85	10097.11	9994.57	10081.12	7677.0
2020-04-19 21:00:00	NQ	Futures	10081.12	10081.4	10005.71	10042.27	6484.0
2020-04-19 22:00:00	NQ	Futures	10042.27	10071.97	10020.27	10047.41	5756.0
2020-04-19 23:00:00	NQ	Futures	10048.55	10080.54	10041.41	10074.26	3900.0
2020-04-19 18:00:00	YM	Futures	26384.0	26393.9	26179.2	26254.8	2853.0
2020-04-19 19:00:00	YM	Futures	26253.7	26318.3	26216.4	26266.8	2528.0
2020-04-19 20:00:00	YM	Futures	26270.1	26510.0	26265.7	26449.7	4989.0
2020-04-19 21:00:00	YM	Futures	26448.6	26449.7	26263.5	26347.9	4791.0
2020-04-19 22:00:00	YM	Futures	26349.0	26412.5	26298.6	26374.2	4018.0
2020-04-19 23:00:00	YM	Futures	26376.3	26457.4	26362.1	26446.4	2678.0
2020-04-19 18:00:00	CL	Futures	17.5	17.62	17.28	17.38	12418.0
2020-04-19 19:00:00	CL	Futures	17.38	17.4	17.12	17.24	9825.0
2020-04-19 20:00:00	CL	Futures	17.24	17.36	16.84	16.85	24970.0
2020-04-19 21:00:00	CL	Futures	16.85	17.02	16.06	16.8	66768.0
2020-04-19 22:00:00	CL	Futures	16.8	16.96	16.71	16.8	12181.0
2020-04-19 23:00:00	CL	Futures	16.8	16.88	16.65	16.78	9672.0
2020-04-19 18:00:00	GC	Futures	2112.5	2117.6	2106.2	2106.2	4260.0
2020-04-19 19:00:00	GC	Futures	2106.2	2109.7	2104.0	2108.1	2606.0
2020-04-19 20:00:00	GC	Futures	2108.3	2109.0	2102.5	2104.7	3031.0
2020-04-19 21:00:00	GC	Futures	2104.6	2114.7	2103.0	2112.5	4779.0
2020-04-19 22:00:00	GC	Futures	2112.3	2119.4	2112.3	2113.9	5005.0
2020-04-19 23:00:00	GC	Futures	2113.8	2118.8	2112.6	2116.9	3060.0
2020-04-19 18:00:00	ZN	Futures	138.208128	138.270265	138.130457	138.223662	9788.0
2020-04-19 19:00:00	ZN	Futures	138.223662	138.239197	138.161525	138.17706	6819.0
2020-04-19 20:00:00	ZN	Futures	138.192594	138.192594	138.114923	138.145991	7796.0
2020-04-19 21:00:00	ZN	Futures	138.145991	138.270265	138.114923	138.208128	13099.0
2020-04-19 22:00:00	ZN	Futures	138.192594	138.239197	138.17706	138.208128	1836.0
2020-04-19 23:00:00	ZN	Futures	138.208128	138.239197	138.192594	138.223662	3229.0

> showing 36 of 345 rows — these rows as CSV

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