PREVIEW / futures_1hour / 2020-02-09

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-02-09.parquet
  size:    18 KB
  rows:    388

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-02-09 18:00:00	ES	Futures	3601.2	3608.8	3580.9	3589.3	54264.0
2020-02-09 19:00:00	ES	Futures	3589.5	3595.2	3589.3	3593.6	22401.0
2020-02-09 20:00:00	ES	Futures	3593.6	3607.7	3590.9	3603.6	43881.0
2020-02-09 21:00:00	ES	Futures	3603.6	3614.5	3602.8	3611.2	25671.0
2020-02-09 22:00:00	ES	Futures	3610.9	3612.8	3606.3	3606.3	14290.0
2020-02-09 23:00:00	ES	Futures	3606.6	3609.3	3603.1	3604.2	10168.0
2020-02-09 18:00:00	NQ	Futures	10874.65	10900.68	10792.81	10822.89	21834.0
2020-02-09 19:00:00	NQ	Futures	10822.6	10847.47	10822.6	10840.82	12209.0
2020-02-09 20:00:00	NQ	Futures	10840.82	10896.05	10831.27	10879.86	18885.0
2020-02-09 21:00:00	NQ	Futures	10880.43	10919.18	10877.54	10906.46	11632.0
2020-02-09 22:00:00	NQ	Futures	10906.46	10913.11	10889.98	10891.71	7251.0
2020-02-09 23:00:00	NQ	Futures	10891.71	10906.46	10878.12	10882.75	6898.0
2020-02-09 18:00:00	YM	Futures	31596.4	31657.4	31410.2	31481.0	9280.0
2020-02-09 19:00:00	YM	Futures	31484.3	31539.8	31479.9	31523.4	4037.0
2020-02-09 20:00:00	YM	Futures	31524.5	31653.0	31496.2	31613.8	7987.0
2020-02-09 21:00:00	YM	Futures	31614.9	31711.8	31607.3	31680.2	5559.0
2020-02-09 22:00:00	YM	Futures	31679.1	31692.2	31630.1	31633.4	2991.0
2020-02-09 23:00:00	YM	Futures	31633.4	31656.3	31600.7	31609.5	2205.0
2020-02-09 18:00:00	CL	Futures	44.4	44.44	43.91	44.07	16136.0
2020-02-09 19:00:00	CL	Futures	44.08	44.24	44.07	44.2	7318.0
2020-02-09 20:00:00	CL	Futures	44.2	44.44	44.15	44.38	15501.0
2020-02-09 21:00:00	CL	Futures	44.39	44.73	44.39	44.62	10859.0
2020-02-09 22:00:00	CL	Futures	44.62	44.65	44.45	44.46	6617.0
2020-02-09 23:00:00	CL	Futures	44.46	44.55	44.45	44.47	3845.0
2020-02-09 18:00:00	GC	Futures	1968.3	1973.8	1964.3	1971.4	10584.0
2020-02-09 19:00:00	GC	Futures	1971.4	1971.8	1968.8	1969.3	6295.0
2020-02-09 20:00:00	GC	Futures	1969.1	1970.5	1965.5	1967.1	11222.0
2020-02-09 21:00:00	GC	Futures	1967.1	1967.6	1962.9	1965.1	8472.0
2020-02-09 22:00:00	GC	Futures	1965.0	1967.4	1964.3	1966.4	4394.0
2020-02-09 23:00:00	GC	Futures	1966.5	1968.4	1966.0	1968.1	2633.0
2020-02-09 18:00:00	ZN	Futures	131.250316	131.500615	131.156454	131.391109	69406.0
2020-02-09 19:00:00	ZN	Futures	131.391109	131.391109	131.297247	131.312891	29573.0
2020-02-09 20:00:00	ZN	Futures	131.312891	131.328535	131.156454	131.203385	49594.0
2020-02-09 21:00:00	ZN	Futures	131.203385	131.219029	131.046949	131.09388	43953.0
2020-02-09 22:00:00	ZN	Futures	131.078236	131.156454	131.062592	131.156454	14823.0
2020-02-09 23:00:00	ZN	Futures	131.156454	131.187742	131.109523	131.187742	14830.0

> showing 36 of 388 rows — these rows as CSV

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