PREVIEW / futures_1hour / 2020-09-21

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-09-21.parquet
  size:    63 KB
  rows:    1,874

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-09-21 00:00:00	ES	Futures	3707.61	3709.01	3700.61	3701.45	4830.0
2020-09-21 01:00:00	ES	Futures	3701.45	3704.53	3688.56	3695.57	11595.0
2020-09-21 02:00:00	ES	Futures	3695.29	3700.05	3689.96	3699.77	13176.0
2020-09-21 03:00:00	ES	Futures	3700.05	3703.97	3664.48	3676.8	59536.0
2020-09-21 04:00:00	ES	Futures	3676.8	3677.64	3638.15	3646.27	65761.0
2020-09-21 05:00:00	ES	Futures	3645.99	3663.92	3642.35	3649.07	53681.0
2020-09-21 06:00:00	ES	Futures	3648.79	3662.24	3645.99	3659.15	33395.0
2020-09-21 07:00:00	ES	Futures	3659.43	3662.24	3647.11	3661.4	30814.0
2020-09-21 08:00:00	ES	Futures	3661.4	3661.4	3639.83	3651.31	51420.0
2020-09-21 09:00:00	ES	Futures	3651.31	3659.43	3627.5	3644.87	278227.0
2020-09-21 10:00:00	ES	Futures	3644.87	3648.79	3605.1	3615.74	360620.0
2020-09-21 11:00:00	ES	Futures	3616.02	3628.9	3606.78	3626.1	232884.0
2020-09-21 12:00:00	ES	Futures	3626.1	3636.47	3619.1	3621.9	252813.0
2020-09-21 13:00:00	ES	Futures	3622.18	3639.27	3614.9	3626.38	316351.0
2020-09-21 14:00:00	ES	Futures	3626.38	3628.9	3609.58	3623.58	189953.0
2020-09-21 15:00:00	ES	Futures	3623.86	3665.32	3622.18	3664.2	322887.0
2020-09-21 16:00:00	ES	Futures	3664.48	3674.0	3663.92	3667.84	83151.0
2020-09-21 18:00:00	ES	Futures	3665.32	3670.92	3663.08	3669.8	7633.0
2020-09-21 19:00:00	ES	Futures	3669.8	3678.76	3667.0	3677.36	7448.0
2020-09-21 20:00:00	ES	Futures	3677.64	3685.48	3674.0	3678.2	14249.0
2020-09-21 21:00:00	ES	Futures	3678.2	3678.48	3660.56	3664.48	18975.0
2020-09-21 22:00:00	ES	Futures	3664.48	3668.96	3657.75	3663.64	13658.0
2020-09-21 23:00:00	ES	Futures	3663.92	3671.48	3661.96	3665.88	8227.0
2020-09-21 00:00:00	NQ	Futures	12631.55	12637.34	12597.97	12602.89	2750.0
2020-09-21 01:00:00	NQ	Futures	12602.02	12616.2	12538.05	12578.86	5975.0
2020-09-21 02:00:00	NQ	Futures	12578.57	12619.68	12564.68	12614.76	6941.0
2020-09-21 03:00:00	NQ	Futures	12615.34	12647.76	12505.05	12538.34	19573.0
2020-09-21 04:00:00	NQ	Futures	12539.78	12542.68	12413.58	12438.47	18671.0
2020-09-21 05:00:00	NQ	Futures	12437.6	12513.44	12399.1	12431.52	16474.0
2020-09-21 06:00:00	NQ	Futures	12430.94	12505.05	12424.29	12491.44	11337.0
2020-09-21 07:00:00	NQ	Futures	12492.31	12508.23	12408.37	12499.26	14397.0
2020-09-21 08:00:00	NQ	Futures	12498.97	12499.84	12423.42	12466.55	22060.0
2020-09-21 09:00:00	NQ	Futures	12465.97	12551.94	12394.18	12511.42	92670.0
2020-09-21 10:00:00	NQ	Futures	12511.13	12530.52	12338.89	12406.92	102038.0
2020-09-21 11:00:00	NQ	Futures	12407.21	12510.55	12381.73	12507.07	83988.0
2020-09-21 12:00:00	NQ	Futures	12507.07	12565.26	12501.0	12517.78	69209.0
2020-09-21 13:00:00	NQ	Futures	12518.36	12602.89	12488.84	12536.6	61905.0
2020-09-21 14:00:00	NQ	Futures	12537.47	12558.02	12452.08	12523.86	52594.0
2020-09-21 15:00:00	NQ	Futures	12523.57	12698.99	12516.92	12694.65	80629.0
2020-09-21 16:00:00	NQ	Futures	12694.36	12747.91	12693.49	12714.04	18595.0
2020-09-21 18:00:00	NQ	Futures	12697.54	12718.97	12685.68	12715.2	4615.0
2020-09-21 19:00:00	NQ	Futures	12716.94	12756.31	12703.04	12751.39	3874.0
2020-09-21 20:00:00	NQ	Futures	12750.81	12791.62	12743.57	12767.6	6286.0
2020-09-21 21:00:00	NQ	Futures	12768.17	12770.78	12685.97	12696.68	9771.0
2020-09-21 22:00:00	NQ	Futures	12696.68	12716.36	12667.15	12687.7	6012.0
2020-09-21 23:00:00	NQ	Futures	12689.73	12722.73	12677.86	12696.68	4696.0
2020-09-21 00:00:00	YM	Futures	30443.2	30456.5	30391.3	30401.2	1149.0
2020-09-21 01:00:00	YM	Futures	30400.1	30420.0	30300.6	30352.6	2698.0
2020-09-21 02:00:00	YM	Futures	30351.5	30369.2	30298.4	30366.9	2814.0
2020-09-21 03:00:00	YM	Futures	30368.0	30389.1	30029.7	30122.6	12603.0

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

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