PREVIEW / futures_1hour / 2020-01-20

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-01-20.parquet
  size:    43 KB
  rows:    1,402

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-01-20 00:00:00	ES	Futures	3605.5	3606.1	3604.2	3604.4	2995.0
2020-01-20 01:00:00	ES	Futures	3604.7	3606.3	3604.4	3605.5	3009.0
2020-01-20 02:00:00	ES	Futures	3605.5	3605.8	3600.9	3601.5	8107.0
2020-01-20 03:00:00	ES	Futures	3601.7	3601.7	3597.7	3598.2	12717.0
2020-01-20 04:00:00	ES	Futures	3598.2	3600.4	3597.1	3599.6	8845.0
2020-01-20 05:00:00	ES	Futures	3599.8	3599.8	3597.9	3598.8	4875.0
2020-01-20 06:00:00	ES	Futures	3598.5	3602.0	3598.5	3602.0	6486.0
2020-01-20 07:00:00	ES	Futures	3602.0	3602.5	3600.9	3601.5	5099.0
2020-01-20 08:00:00	ES	Futures	3601.5	3601.5	3599.6	3599.8	4358.0
2020-01-20 09:00:00	ES	Futures	3599.6	3602.0	3599.0	3601.7	9666.0
2020-01-20 10:00:00	ES	Futures	3602.0	3602.0	3600.1	3602.0	10156.0
2020-01-20 11:00:00	ES	Futures	3601.7	3603.9	3600.6	3603.6	9965.0
2020-01-20 12:00:00	ES	Futures	3603.4	3605.0	3603.4	3604.4	5035.0
2020-01-20 18:00:00	ES	Futures	3604.7	3605.3	3601.7	3602.0	4775.0
2020-01-20 19:00:00	ES	Futures	3602.0	3602.8	3601.5	3602.3	3490.0
2020-01-20 20:00:00	ES	Futures	3602.3	3602.3	3589.3	3590.9	37588.0
2020-01-20 21:00:00	ES	Futures	3590.6	3592.8	3586.6	3588.5	20442.0
2020-01-20 22:00:00	ES	Futures	3588.7	3590.9	3588.5	3588.7	9872.0
2020-01-20 23:00:00	ES	Futures	3588.7	3590.3	3587.9	3589.8	4442.0
2020-01-20 00:00:00	NQ	Futures	10617.58	10619.02	10613.82	10615.26	1496.0
2020-01-20 01:00:00	NQ	Futures	10615.26	10619.89	10614.1	10618.15	1879.0
2020-01-20 02:00:00	NQ	Futures	10617.58	10618.73	10602.83	10605.43	3938.0
2020-01-20 03:00:00	NQ	Futures	10605.72	10607.16	10596.47	10597.62	6201.0
2020-01-20 04:00:00	NQ	Futures	10597.62	10606.3	10595.31	10602.25	4745.0
2020-01-20 05:00:00	NQ	Futures	10601.96	10602.54	10596.47	10597.62	2141.0
2020-01-20 06:00:00	NQ	Futures	10597.62	10609.19	10597.33	10608.61	3011.0
2020-01-20 07:00:00	NQ	Futures	10608.61	10610.06	10601.96	10602.83	2895.0
2020-01-20 08:00:00	NQ	Futures	10603.12	10604.56	10598.49	10601.09	3025.0
2020-01-20 09:00:00	NQ	Futures	10601.09	10610.06	10598.78	10608.61	6379.0
2020-01-20 10:00:00	NQ	Futures	10608.61	10609.19	10596.75	10605.43	6722.0
2020-01-20 11:00:00	NQ	Futures	10605.72	10611.5	10601.09	10610.63	4638.0
2020-01-20 12:00:00	NQ	Futures	10610.35	10614.97	10610.06	10613.53	2742.0
2020-01-20 18:00:00	NQ	Futures	10614.1	10617.0	10605.14	10606.88	2715.0
2020-01-20 19:00:00	NQ	Futures	10607.16	10610.35	10604.27	10606.88	2082.0
2020-01-20 20:00:00	NQ	Futures	10606.59	10606.88	10560.9	10566.39	16239.0
2020-01-20 21:00:00	NQ	Futures	10566.39	10572.75	10550.2	10559.74	8452.0
2020-01-20 22:00:00	NQ	Futures	10559.16	10565.52	10555.69	10555.98	5105.0
2020-01-20 23:00:00	NQ	Futures	10556.27	10562.63	10553.38	10558.87	2367.0
2020-01-20 00:00:00	YM	Futures	31899.1	31903.4	31887.1	31891.4	654.0
2020-01-20 01:00:00	YM	Futures	31890.4	31904.5	31887.1	31898.0	762.0
2020-01-20 02:00:00	YM	Futures	31896.9	31899.1	31854.4	31863.1	1973.0
2020-01-20 03:00:00	YM	Futures	31864.2	31866.4	31829.4	31833.7	4081.0
2020-01-20 04:00:00	YM	Futures	31834.8	31862.0	31822.9	31856.6	2728.0
2020-01-20 05:00:00	YM	Futures	31855.5	31856.6	31840.3	31846.8	1794.0
2020-01-20 06:00:00	YM	Futures	31846.8	31874.0	31845.7	31874.0	1560.0
2020-01-20 07:00:00	YM	Futures	31875.1	31880.6	31862.0	31868.6	1160.0
2020-01-20 08:00:00	YM	Futures	31868.6	31871.8	31855.5	31859.9	1311.0
2020-01-20 09:00:00	YM	Futures	31859.9	31875.1	31849.0	31866.4	2567.0
2020-01-20 10:00:00	YM	Futures	31866.4	31876.2	31857.7	31872.9	1946.0
2020-01-20 11:00:00	YM	Futures	31871.8	31893.6	31864.2	31889.3	2435.0

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

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