PREVIEW / futures_1hour / 2020-03-16

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-03-16.parquet
  size:    63 KB
  rows:    1,831

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-03-16 00:00:00	ES	Futures	2805.06	2805.06	2805.06	2805.06	47.0
2020-03-16 01:00:00	ES	Futures	2805.06	2805.06	2805.06	2805.06	33.0
2020-03-16 02:00:00	ES	Futures	2805.06	2805.06	2805.06	2805.06	81.0
2020-03-16 03:00:00	ES	Futures	2805.06	2805.06	2805.06	2805.06	14.0
2020-03-16 04:00:00	ES	Futures	2805.06	2805.06	2805.06	2805.06	36.0
2020-03-16 05:00:00	ES	Futures	2805.06	2805.06	2805.06	2805.06	54.0
2020-03-16 06:00:00	ES	Futures	2805.06	2805.06	2805.06	2805.06	90.0
2020-03-16 07:00:00	ES	Futures	2805.06	2805.06	2805.06	2805.06	39.0
2020-03-16 08:00:00	ES	Futures	2805.06	2805.06	2805.06	2805.06	96.0
2020-03-16 09:00:00	ES	Futures	2805.06	2805.06	2579.49	2673.34	183058.0
2020-03-16 10:00:00	ES	Futures	2673.07	2753.75	2639.87	2728.78	371455.0
2020-03-16 11:00:00	ES	Futures	2728.5	2797.38	2721.92	2767.47	279816.0
2020-03-16 12:00:00	ES	Futures	2767.19	2774.6	2697.22	2710.12	201301.0
2020-03-16 13:00:00	ES	Futures	2710.39	2740.3	2678.83	2690.08	188484.0
2020-03-16 14:00:00	ES	Futures	2690.08	2732.89	2662.09	2712.04	241134.0
2020-03-16 15:00:00	ES	Futures	2712.31	2731.25	2602.0	2609.41	560392.0
2020-03-16 16:00:00	ES	Futures	2609.41	2669.5	2606.94	2633.83	238883.0
2020-03-16 18:00:00	ES	Futures	2642.06	2677.73	2623.4	2651.12	38869.0
2020-03-16 19:00:00	ES	Futures	2651.39	2681.03	2650.29	2669.78	18203.0
2020-03-16 20:00:00	ES	Futures	2669.78	2706.82	2635.75	2697.22	29318.0
2020-03-16 21:00:00	ES	Futures	2697.77	2741.95	2692.0	2726.85	30074.0
2020-03-16 22:00:00	ES	Futures	2726.31	2741.67	2692.28	2731.79	26863.0
2020-03-16 23:00:00	ES	Futures	2731.52	2734.81	2709.29	2729.05	9871.0
2020-03-16 00:00:00	NQ	Futures	8616.06	8616.06	8616.06	8616.06	16.0
2020-03-16 01:00:00	NQ	Futures	8616.06	8616.06	8616.06	8616.06	2.0
2020-03-16 02:00:00	NQ	Futures	8616.06	8616.06	8616.06	8616.06	4.0
2020-03-16 03:00:00	NQ	Futures	8616.06	8616.06	8616.06	8616.06	7.0
2020-03-16 04:00:00	NQ	Futures	8616.06	8616.06	8616.06	8616.06	6.0
2020-03-16 05:00:00	NQ	Futures	8616.06	8616.06	8616.06	8616.06	9.0
2020-03-16 06:00:00	NQ	Futures	8616.06	8616.06	8616.06	8616.06	25.0
2020-03-16 07:00:00	NQ	Futures	8616.06	8616.06	8616.06	8616.06	4.0
2020-03-16 08:00:00	NQ	Futures	8616.06	8616.06	8616.06	8616.06	8.0
2020-03-16 09:00:00	NQ	Futures	8616.06	8616.06	8049.07	8250.16	23230.0
2020-03-16 10:00:00	NQ	Futures	8249.59	8486.67	8173.32	8431.83	63158.0
2020-03-16 11:00:00	NQ	Futures	8428.68	8616.06	8408.97	8560.36	44514.0
2020-03-16 12:00:00	NQ	Futures	8558.36	8579.79	8350.99	8383.27	26308.0
2020-03-16 13:00:00	NQ	Futures	8383.27	8458.39	8297.57	8312.43	38777.0
2020-03-16 14:00:00	NQ	Futures	8312.14	8442.11	8229.88	8362.13	44324.0
2020-03-16 15:00:00	NQ	Futures	8362.42	8428.4	7890.54	7922.24	67212.0
2020-03-16 16:00:00	NQ	Futures	7921.96	8132.76	7917.39	8034.5	27647.0
2020-03-16 18:00:00	NQ	Futures	8039.36	8151.04	7956.81	8085.06	10606.0
2020-03-16 19:00:00	NQ	Futures	8083.34	8186.46	8080.2	8155.61	4725.0
2020-03-16 20:00:00	NQ	Futures	8153.33	8308.43	8077.35	8285.58	5627.0
2020-03-16 21:00:00	NQ	Futures	8283.58	8314.71	8273.87	8314.71	1117.0
2020-03-16 22:00:00	NQ	Futures	8314.71	8314.71	8244.45	8314.71	3199.0
2020-03-16 23:00:00	NQ	Futures	8314.71	8314.71	8306.43	8314.71	348.0
2020-03-16 00:00:00	YM	Futures	23875.7	23875.7	23875.7	23875.7	3.0
2020-03-16 01:00:00	YM	Futures	23875.7	23875.7	23875.7	23875.7	4.0
2020-03-16 05:00:00	YM	Futures	23875.7	23875.7	23875.7	23875.7	3.0
2020-03-16 06:00:00	YM	Futures	23875.7	23875.7	23875.7	23875.7	34.0

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

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