PREVIEW / futures_1hour / 2020-02-13

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-02-13.parquet
  size:    60 KB
  rows:    1,909

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-13 00:00:00	ES	Futures	3650.2	3652.7	3649.7	3651.9	8990.0
2020-02-13 01:00:00	ES	Futures	3651.9	3652.9	3648.9	3649.4	8714.0
2020-02-13 02:00:00	ES	Futures	3649.4	3650.0	3644.8	3646.2	20690.0
2020-02-13 03:00:00	ES	Futures	3646.4	3650.0	3645.4	3647.0	33653.0
2020-02-13 04:00:00	ES	Futures	3646.7	3647.0	3635.6	3638.6	39030.0
2020-02-13 05:00:00	ES	Futures	3638.3	3641.3	3629.6	3637.8	55244.0
2020-02-13 06:00:00	ES	Futures	3638.0	3641.3	3633.7	3638.9	43762.0
2020-02-13 07:00:00	ES	Futures	3638.9	3642.1	3635.9	3642.1	40798.0
2020-02-13 08:00:00	ES	Futures	3642.1	3648.3	3641.0	3646.7	61162.0
2020-02-13 09:00:00	ES	Futures	3646.7	3654.8	3641.0	3647.0	241086.0
2020-02-13 10:00:00	ES	Futures	3647.0	3658.1	3641.6	3657.6	254370.0
2020-02-13 11:00:00	ES	Futures	3657.6	3663.5	3655.7	3660.0	148664.0
2020-02-13 12:00:00	ES	Futures	3660.0	3664.6	3658.9	3658.9	94717.0
2020-02-13 13:00:00	ES	Futures	3658.9	3667.6	3657.0	3666.0	103996.0
2020-02-13 14:00:00	ES	Futures	3666.0	3668.9	3662.7	3666.2	109961.0
2020-02-13 15:00:00	ES	Futures	3666.2	3667.9	3654.3	3658.1	255746.0
2020-02-13 16:00:00	ES	Futures	3658.1	3662.7	3657.6	3662.4	74488.0
2020-02-13 18:00:00	ES	Futures	3663.2	3663.5	3655.1	3657.6	19838.0
2020-02-13 19:00:00	ES	Futures	3657.6	3660.8	3655.1	3660.3	15373.0
2020-02-13 20:00:00	ES	Futures	3660.3	3664.6	3657.6	3663.8	16291.0
2020-02-13 21:00:00	ES	Futures	3664.1	3668.4	3661.6	3668.1	12694.0
2020-02-13 22:00:00	ES	Futures	3668.4	3673.0	3667.9	3668.4	19885.0
2020-02-13 23:00:00	ES	Futures	3668.4	3670.0	3667.0	3668.4	5992.0
2020-02-13 00:00:00	NQ	Futures	11076.49	11088.06	11075.05	11085.75	4386.0
2020-02-13 01:00:00	NQ	Futures	11085.46	11088.06	11071.87	11076.78	4405.0
2020-02-13 02:00:00	NQ	Futures	11076.78	11078.52	11060.01	11063.77	7100.0
2020-02-13 03:00:00	NQ	Futures	11063.77	11076.49	11060.59	11067.53	9575.0
2020-02-13 04:00:00	NQ	Futures	11067.24	11067.82	11027.04	11037.17	13116.0
2020-02-13 05:00:00	NQ	Futures	11036.88	11045.55	11001.6	11036.01	22012.0
2020-02-13 06:00:00	NQ	Futures	11036.01	11054.52	11019.24	11046.71	15110.0
2020-02-13 07:00:00	NQ	Futures	11046.71	11055.38	11016.34	11041.79	18057.0
2020-02-13 08:00:00	NQ	Futures	11041.5	11066.66	11038.03	11060.01	21379.0
2020-02-13 09:00:00	NQ	Futures	11060.3	11095.87	11033.98	11071.0	85613.0
2020-02-13 10:00:00	NQ	Futures	11070.71	11115.53	11051.33	11113.51	88076.0
2020-02-13 11:00:00	NQ	Futures	11113.51	11139.53	11108.01	11121.89	60119.0
2020-02-13 12:00:00	NQ	Futures	11122.18	11140.69	11109.17	11110.04	39751.0
2020-02-13 13:00:00	NQ	Futures	11110.04	11154.28	11103.96	11149.08	43744.0
2020-02-13 14:00:00	NQ	Futures	11149.08	11156.02	11132.88	11143.87	39575.0
2020-02-13 15:00:00	NQ	Futures	11143.87	11149.94	11098.47	11109.75	63446.0
2020-02-13 16:00:00	NQ	Futures	11109.75	11135.77	11108.59	11133.46	12394.0
2020-02-13 18:00:00	NQ	Futures	11134.62	11134.91	11104.83	11115.53	7611.0
2020-02-13 19:00:00	NQ	Futures	11115.53	11128.54	11105.41	11125.07	8482.0
2020-02-13 20:00:00	NQ	Futures	11125.07	11145.03	11116.4	11142.71	10561.0
2020-02-13 21:00:00	NQ	Futures	11142.71	11156.3	11132.01	11155.73	8355.0
2020-02-13 22:00:00	NQ	Futures	11155.44	11172.79	11155.15	11158.33	9439.0
2020-02-13 23:00:00	NQ	Futures	11158.33	11161.22	11151.97	11157.17	3327.0
2020-02-13 00:00:00	YM	Futures	32023.2	32040.6	32016.6	32037.3	1732.0
2020-02-13 01:00:00	YM	Futures	32036.2	32046.0	32013.4	32016.6	2170.0
2020-02-13 02:00:00	YM	Futures	32017.7	32024.3	31974.2	31984.0	4173.0
2020-02-13 03:00:00	YM	Futures	31985.1	32024.3	31976.4	31991.6	4986.0

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

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