PREVIEW / futures_1hour / 2020-02-11

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-02-11.parquet
  size:    58 KB
  rows:    1,861

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-11 00:00:00	ES	Futures	3644.8	3647.3	3642.9	3645.9	5449.0
2020-02-11 01:00:00	ES	Futures	3646.2	3646.7	3643.7	3645.1	7084.0
2020-02-11 02:00:00	ES	Futures	3645.1	3645.1	3640.5	3642.7	12439.0
2020-02-11 03:00:00	ES	Futures	3642.4	3644.8	3639.4	3641.8	28472.0
2020-02-11 04:00:00	ES	Futures	3642.1	3642.4	3637.0	3641.3	22412.0
2020-02-11 05:00:00	ES	Futures	3641.3	3644.8	3640.8	3644.0	15960.0
2020-02-11 06:00:00	ES	Futures	3644.0	3645.6	3640.8	3641.0	15036.0
2020-02-11 07:00:00	ES	Futures	3641.3	3646.4	3641.0	3645.6	20272.0
2020-02-11 08:00:00	ES	Futures	3645.6	3648.1	3642.9	3647.0	33689.0
2020-02-11 09:00:00	ES	Futures	3646.7	3650.0	3641.3	3646.4	210340.0
2020-02-11 10:00:00	ES	Futures	3646.4	3657.8	3646.4	3652.9	211526.0
2020-02-11 11:00:00	ES	Futures	3652.9	3654.6	3642.7	3645.1	197529.0
2020-02-11 12:00:00	ES	Futures	3645.4	3650.0	3644.0	3650.0	78880.0
2020-02-11 13:00:00	ES	Futures	3650.0	3652.1	3642.7	3645.4	79778.0
2020-02-11 14:00:00	ES	Futures	3645.1	3646.2	3639.1	3641.3	144276.0
2020-02-11 15:00:00	ES	Futures	3641.3	3643.5	3633.2	3638.6	251326.0
2020-02-11 16:00:00	ES	Futures	3638.6	3641.8	3638.3	3641.3	44835.0
2020-02-11 18:00:00	ES	Futures	3642.7	3645.1	3641.0	3642.9	9648.0
2020-02-11 19:00:00	ES	Futures	3643.2	3644.8	3637.2	3640.5	15650.0
2020-02-11 20:00:00	ES	Futures	3640.2	3643.7	3638.9	3642.1	15363.0
2020-02-11 21:00:00	ES	Futures	3641.8	3643.5	3640.5	3641.6	7845.0
2020-02-11 22:00:00	ES	Futures	3641.8	3645.6	3641.6	3644.3	6731.0
2020-02-11 23:00:00	ES	Futures	3644.5	3647.0	3644.0	3646.7	5746.0
2020-02-11 00:00:00	NQ	Futures	11071.29	11079.67	11066.08	11075.63	3216.0
2020-02-11 01:00:00	NQ	Futures	11075.91	11079.38	11066.37	11069.55	4497.0
2020-02-11 02:00:00	NQ	Futures	11069.84	11069.84	11051.05	11058.56	7535.0
2020-02-11 03:00:00	NQ	Futures	11058.56	11066.95	11049.02	11056.83	11850.0
2020-02-11 04:00:00	NQ	Futures	11056.83	11060.01	11041.5	11056.54	9753.0
2020-02-11 05:00:00	NQ	Futures	11056.83	11069.55	11055.67	11067.53	6221.0
2020-02-11 06:00:00	NQ	Futures	11067.53	11072.44	11051.05	11052.78	6649.0
2020-02-11 07:00:00	NQ	Futures	11053.07	11075.05	11052.49	11069.55	7348.0
2020-02-11 08:00:00	NQ	Futures	11069.26	11077.07	11057.12	11076.78	12982.0
2020-02-11 09:00:00	NQ	Futures	11076.78	11084.3	11033.41	11054.81	83771.0
2020-02-11 10:00:00	NQ	Futures	11054.81	11115.24	11054.52	11102.52	80856.0
2020-02-11 11:00:00	NQ	Futures	11102.23	11113.51	11049.6	11057.7	75556.0
2020-02-11 12:00:00	NQ	Futures	11057.99	11080.83	11053.65	11080.54	42008.0
2020-02-11 13:00:00	NQ	Futures	11080.83	11095.0	11044.11	11050.47	37835.0
2020-02-11 14:00:00	NQ	Futures	11050.18	11053.65	11016.34	11029.07	59153.0
2020-02-11 15:00:00	NQ	Futures	11029.07	11039.48	10990.03	11017.5	83256.0
2020-02-11 16:00:00	NQ	Futures	11017.5	11028.49	11014.9	11026.47	6868.0
2020-02-11 18:00:00	NQ	Futures	11030.51	11043.24	11027.04	11036.01	4469.0
2020-02-11 19:00:00	NQ	Futures	11036.3	11043.82	11016.06	11028.78	8720.0
2020-02-11 20:00:00	NQ	Futures	11028.49	11039.77	11022.13	11032.25	9547.0
2020-02-11 21:00:00	NQ	Futures	11032.83	11038.03	11027.91	11032.83	4756.0
2020-02-11 22:00:00	NQ	Futures	11033.12	11051.05	11032.83	11047.0	4217.0
2020-02-11 23:00:00	NQ	Futures	11047.0	11055.96	11045.26	11054.81	2778.0
2020-02-11 00:00:00	YM	Futures	31926.3	31953.5	31907.8	31935.0	2178.0
2020-02-11 01:00:00	YM	Futures	31936.1	31947.0	31916.5	31936.1	2314.0
2020-02-11 02:00:00	YM	Futures	31936.1	31936.1	31890.4	31914.3	3294.0
2020-02-11 03:00:00	YM	Futures	31913.2	31941.5	31890.4	31911.0	6342.0

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

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