PREVIEW / futures_1hour / 2019-12-31

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-12-31.parquet
  size:    41 KB
  rows:    1,187

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
2019-12-31 00:00:00	ES	Futures	3498.2	3498.5	3497.4	3497.9	1941.0
2019-12-31 01:00:00	ES	Futures	3498.2	3498.8	3498.2	3498.2	947.0
2019-12-31 02:00:00	ES	Futures	3498.2	3498.5	3495.2	3495.5	4568.0
2019-12-31 03:00:00	ES	Futures	3495.8	3497.4	3493.6	3496.9	5477.0
2019-12-31 04:00:00	ES	Futures	3496.9	3497.4	3495.8	3496.6	3008.0
2019-12-31 05:00:00	ES	Futures	3496.3	3499.0	3496.0	3497.9	4379.0
2019-12-31 06:00:00	ES	Futures	3497.9	3499.0	3493.9	3494.4	4703.0
2019-12-31 07:00:00	ES	Futures	3494.7	3495.5	3490.1	3490.9	14555.0
2019-12-31 08:00:00	ES	Futures	3490.6	3495.2	3486.8	3487.9	30337.0
2019-12-31 09:00:00	ES	Futures	3487.6	3497.7	3482.8	3494.7	163047.0
2019-12-31 10:00:00	ES	Futures	3495.0	3495.8	3485.5	3485.7	146772.0
2019-12-31 11:00:00	ES	Futures	3485.7	3490.6	3484.1	3487.9	105328.0
2019-12-31 12:00:00	ES	Futures	3487.6	3489.5	3485.7	3488.5	64301.0
2019-12-31 13:00:00	ES	Futures	3488.2	3491.2	3488.2	3490.9	45612.0
2019-12-31 14:00:00	ES	Futures	3490.9	3493.1	3489.0	3491.2	49429.0
2019-12-31 15:00:00	ES	Futures	3491.2	3503.9	3490.6	3500.9	343246.0
2019-12-31 16:00:00	ES	Futures	3500.7	3508.0	3500.4	3507.7	95030.0
2019-12-31 00:00:00	NQ	Futures	10117.59	10117.88	10116.15	10117.59	661.0
2019-12-31 01:00:00	NQ	Futures	10117.88	10120.2	10117.59	10118.46	603.0
2019-12-31 02:00:00	NQ	Futures	10118.46	10118.75	10104.87	10108.05	3463.0
2019-12-31 03:00:00	NQ	Futures	10108.34	10113.55	10099.67	10111.81	3699.0
2019-12-31 04:00:00	NQ	Futures	10112.1	10112.97	10105.45	10108.05	1764.0
2019-12-31 05:00:00	NQ	Futures	10108.05	10114.99	10107.18	10112.97	2258.0
2019-12-31 06:00:00	NQ	Futures	10113.26	10118.17	10096.77	10101.69	3639.0
2019-12-31 07:00:00	NQ	Futures	10101.69	10104.58	10085.79	10087.52	7817.0
2019-12-31 08:00:00	NQ	Futures	10086.94	10101.11	10071.33	10075.09	13009.0
2019-12-31 09:00:00	NQ	Futures	10074.8	10117.31	10054.27	10105.45	55506.0
2019-12-31 10:00:00	NQ	Futures	10105.45	10110.08	10072.19	10075.38	47049.0
2019-12-31 11:00:00	NQ	Futures	10075.09	10095.04	10067.86	10086.36	32327.0
2019-12-31 12:00:00	NQ	Futures	10086.65	10092.73	10079.13	10088.39	17500.0
2019-12-31 13:00:00	NQ	Futures	10088.39	10097.64	10086.94	10096.2	10540.0
2019-12-31 14:00:00	NQ	Futures	10096.2	10103.71	10081.74	10099.67	15184.0
2019-12-31 15:00:00	NQ	Futures	10099.67	10127.43	10097.93	10118.17	41053.0
2019-12-31 16:00:00	NQ	Futures	10118.46	10146.8	10117.88	10146.51	14450.0
2019-12-31 00:00:00	YM	Futures	30995.4	30998.7	30992.1	30996.5	487.0
2019-12-31 01:00:00	YM	Futures	30996.5	31001.9	30996.5	30997.6	277.0
2019-12-31 02:00:00	YM	Futures	30997.6	30998.7	30969.3	30971.5	1398.0
2019-12-31 03:00:00	YM	Futures	30972.5	30988.9	30957.3	30982.3	1645.0
2019-12-31 04:00:00	YM	Futures	30983.4	30993.2	30979.1	30983.4	901.0
2019-12-31 05:00:00	YM	Futures	30983.4	31012.8	30982.3	31003.0	1399.0
2019-12-31 06:00:00	YM	Futures	31001.9	31011.7	30956.2	30962.7	1958.0
2019-12-31 07:00:00	YM	Futures	30961.7	30971.5	30926.8	30936.6	3982.0
2019-12-31 08:00:00	YM	Futures	30935.5	30973.6	30905.0	30909.4	5205.0
2019-12-31 09:00:00	YM	Futures	30909.4	30983.4	30856.0	30957.3	25173.0
2019-12-31 10:00:00	YM	Futures	30957.3	30963.8	30868.0	30873.5	19012.0
2019-12-31 11:00:00	YM	Futures	30871.3	30934.4	30869.1	30913.8	11671.0
2019-12-31 12:00:00	YM	Futures	30913.8	30921.4	30882.2	30902.9	6693.0
2019-12-31 13:00:00	YM	Futures	30901.8	30918.1	30897.4	30914.8	4251.0
2019-12-31 14:00:00	YM	Futures	30914.8	30935.5	30902.9	30919.2	7508.0
2019-12-31 15:00:00	YM	Futures	30918.1	31049.8	30913.8	31025.9	23168.0

> showing 50 of 1,187 rows — these rows as CSV

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