PREVIEW / futures_1hour / 2020-03-17

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-03-17.parquet
  size:    64 KB
  rows:    1,859

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-17 00:00:00	ES	Futures	2729.32	2740.58	2719.17	2740.3	7581.0
2020-03-17 01:00:00	ES	Futures	2740.58	2741.95	2705.73	2734.54	16796.0
2020-03-17 02:00:00	ES	Futures	2734.26	2741.95	2722.19	2741.95	8051.0
2020-03-17 03:00:00	ES	Futures	2741.95	2741.95	2741.95	2741.95	662.0
2020-03-17 04:00:00	ES	Futures	2741.95	2741.95	2664.56	2669.5	38156.0
2020-03-17 05:00:00	ES	Futures	2669.78	2687.61	2602.27	2631.08	62130.0
2020-03-17 06:00:00	ES	Futures	2631.36	2723.84	2622.58	2722.46	55479.0
2020-03-17 07:00:00	ES	Futures	2722.74	2723.84	2637.12	2640.96	55182.0
2020-03-17 08:00:00	ES	Futures	2641.51	2677.19	2629.44	2674.99	71277.0
2020-03-17 09:00:00	ES	Futures	2674.99	2695.02	2588.28	2594.31	280503.0
2020-03-17 10:00:00	ES	Futures	2594.31	2677.19	2581.69	2671.15	361349.0
2020-03-17 11:00:00	ES	Futures	2671.15	2739.2	2662.37	2736.19	323496.0
2020-03-17 12:00:00	ES	Futures	2735.91	2791.07	2695.85	2715.6	311744.0
2020-03-17 13:00:00	ES	Futures	2715.33	2732.62	2669.78	2722.19	241207.0
2020-03-17 14:00:00	ES	Futures	2721.92	2781.19	2706.55	2738.11	255518.0
2020-03-17 15:00:00	ES	Futures	2738.11	2778.72	2694.75	2778.72	491124.0
2020-03-17 16:00:00	ES	Futures	2778.44	2784.48	2714.78	2716.43	156242.0
2020-03-17 18:00:00	ES	Futures	2708.47	2729.05	2677.46	2688.99	40621.0
2020-03-17 19:00:00	ES	Futures	2689.26	2697.77	2632.18	2646.45	43634.0
2020-03-17 20:00:00	ES	Futures	2646.18	2676.09	2630.81	2644.81	50295.0
2020-03-17 21:00:00	ES	Futures	2643.98	2656.06	2629.16	2644.26	32094.0
2020-03-17 22:00:00	ES	Futures	2644.26	2687.34	2631.36	2679.38	28321.0
2020-03-17 23:00:00	ES	Futures	2679.11	2681.3	2635.48	2638.77	19199.0
2020-03-17 00:00:00	NQ	Futures	8314.71	8314.71	8314.71	8314.71	24.0
2020-03-17 01:00:00	NQ	Futures	8314.71	8314.71	8314.71	8314.71	836.0
2020-03-17 02:00:00	NQ	Futures	8314.71	8314.71	8314.71	8314.71	77.0
2020-03-17 03:00:00	NQ	Futures	8314.71	8314.71	8314.71	8314.71	8.0
2020-03-17 04:00:00	NQ	Futures	8314.71	8314.71	8154.18	8173.04	6310.0
2020-03-17 05:00:00	NQ	Futures	8175.61	8239.59	7976.23	8085.63	10834.0
2020-03-17 06:00:00	NQ	Futures	8091.91	8314.71	8066.78	8314.71	11138.0
2020-03-17 07:00:00	NQ	Futures	8314.71	8314.71	8089.34	8102.77	9560.0
2020-03-17 08:00:00	NQ	Futures	8103.34	8190.46	8062.78	8188.46	9797.0
2020-03-17 09:00:00	NQ	Futures	8184.75	8265.58	7940.81	7958.23	49227.0
2020-03-17 10:00:00	NQ	Futures	7960.8	8267.87	7919.39	8241.3	74914.0
2020-03-17 11:00:00	NQ	Futures	8241.3	8470.96	8218.74	8459.82	68952.0
2020-03-17 12:00:00	NQ	Futures	8456.39	8611.49	8316.43	8384.41	56695.0
2020-03-17 13:00:00	NQ	Futures	8384.98	8463.82	8243.87	8432.4	39476.0
2020-03-17 14:00:00	NQ	Futures	8431.25	8555.51	8370.13	8455.53	37234.0
2020-03-17 15:00:00	NQ	Futures	8456.11	8563.22	8310.43	8497.52	64505.0
2020-03-17 16:00:00	NQ	Futures	8497.52	8524.09	8393.55	8394.69	15652.0
2020-03-17 18:00:00	NQ	Futures	8390.12	8432.11	8281.86	8319.0	5100.0
2020-03-17 19:00:00	NQ	Futures	8322.43	8340.42	8158.47	8196.74	7790.0
2020-03-17 20:00:00	NQ	Futures	8196.46	8248.16	8113.91	8151.04	10692.0
2020-03-17 21:00:00	NQ	Futures	8151.33	8201.6	8101.63	8157.61	6827.0
2020-03-17 22:00:00	NQ	Futures	8156.75	8304.14	8128.19	8278.72	6036.0
2020-03-17 23:00:00	NQ	Futures	8281.29	8286.15	8148.18	8156.47	4327.0
2020-03-17 00:00:00	YM	Futures	22987.4	23068.5	22919.5	23068.5	1092.0
2020-03-17 01:00:00	YM	Futures	23068.5	23068.5	22796.8	23029.1	1468.0
2020-03-17 02:00:00	YM	Futures	23031.2	23068.5	22905.3	23068.5	1126.0
2020-03-17 03:00:00	YM	Futures	23068.5	23068.5	23068.5	23068.5	49.0

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

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