PREVIEW / futures_1hour / 2020-10-26

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-10-26.parquet
  size:    60 KB
  rows:    1,895

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-10-26 00:00:00	ES	Futures	3846.26	3846.54	3843.18	3844.3	3206.0
2020-10-26 01:00:00	ES	Futures	3844.3	3848.22	3839.26	3839.82	6697.0
2020-10-26 02:00:00	ES	Futures	3839.82	3842.34	3837.85	3838.98	5233.0
2020-10-26 03:00:00	ES	Futures	3838.98	3840.66	3822.73	3826.09	28236.0
2020-10-26 04:00:00	ES	Futures	3826.09	3834.77	3823.29	3832.53	40027.0
2020-10-26 05:00:00	ES	Futures	3832.81	3834.77	3826.65	3829.73	17595.0
2020-10-26 06:00:00	ES	Futures	3829.73	3832.81	3826.37	3832.53	13734.0
2020-10-26 07:00:00	ES	Futures	3832.81	3837.01	3828.33	3829.45	18818.0
2020-10-26 08:00:00	ES	Futures	3829.45	3831.13	3824.97	3827.77	26560.0
2020-10-26 09:00:00	ES	Futures	3827.77	3840.1	3826.93	3837.85	153686.0
2020-10-26 10:00:00	ES	Futures	3837.85	3842.9	3803.96	3805.08	282879.0
2020-10-26 11:00:00	ES	Futures	3805.08	3805.36	3786.32	3793.6	292774.0
2020-10-26 12:00:00	ES	Futures	3793.6	3796.68	3778.19	3781.0	203555.0
2020-10-26 13:00:00	ES	Futures	3781.0	3783.24	3759.99	3779.6	226074.0
2020-10-26 14:00:00	ES	Futures	3779.32	3794.44	3776.51	3788.28	176929.0
2020-10-26 15:00:00	ES	Futures	3788.56	3803.68	3779.03	3803.12	278815.0
2020-10-26 16:00:00	ES	Futures	3803.12	3807.6	3800.32	3803.4	69346.0
2020-10-26 18:00:00	ES	Futures	3802.84	3807.04	3801.44	3805.08	6309.0
2020-10-26 19:00:00	ES	Futures	3805.08	3808.73	3799.2	3800.88	9188.0
2020-10-26 20:00:00	ES	Futures	3800.88	3813.77	3798.08	3813.21	14627.0
2020-10-26 21:00:00	ES	Futures	3813.21	3813.77	3803.4	3805.08	9378.0
2020-10-26 22:00:00	ES	Futures	3805.08	3808.73	3803.96	3806.48	5623.0
2020-10-26 23:00:00	ES	Futures	3806.76	3808.73	3803.96	3805.64	4467.0
2020-10-26 00:00:00	NQ	Futures	13453.93	13455.66	13439.74	13447.27	2104.0
2020-10-26 01:00:00	NQ	Futures	13447.56	13458.85	13433.37	13435.11	4352.0
2020-10-26 02:00:00	NQ	Futures	13435.11	13444.95	13416.58	13431.06	3894.0
2020-10-26 03:00:00	NQ	Futures	13429.9	13431.93	13365.35	13382.43	9866.0
2020-10-26 04:00:00	NQ	Futures	13382.14	13402.11	13374.9	13386.19	9717.0
2020-10-26 05:00:00	NQ	Futures	13386.19	13401.53	13376.35	13388.51	4914.0
2020-10-26 06:00:00	NQ	Futures	13388.8	13405.87	13379.53	13398.06	4637.0
2020-10-26 07:00:00	NQ	Futures	13398.35	13423.24	13389.95	13398.35	6975.0
2020-10-26 08:00:00	NQ	Futures	13399.22	13403.85	13376.64	13386.48	13203.0
2020-10-26 09:00:00	NQ	Futures	13386.19	13522.82	13384.45	13509.5	61388.0
2020-10-26 10:00:00	NQ	Futures	13509.79	13541.92	13349.43	13357.53	97837.0
2020-10-26 11:00:00	NQ	Futures	13358.4	13358.98	13258.53	13291.24	109478.0
2020-10-26 12:00:00	NQ	Futures	13290.67	13315.56	13208.46	13218.59	74342.0
2020-10-26 13:00:00	NQ	Futures	13219.17	13227.56	13134.06	13211.06	86360.0
2020-10-26 14:00:00	NQ	Futures	13211.64	13268.67	13202.38	13252.75	52551.0
2020-10-26 15:00:00	NQ	Futures	13253.03	13314.98	13218.88	13308.9	78206.0
2020-10-26 16:00:00	NQ	Futures	13308.9	13330.9	13303.98	13311.8	13030.0
2020-10-26 18:00:00	NQ	Futures	13314.98	13325.98	13311.8	13312.95	1782.0
2020-10-26 19:00:00	NQ	Futures	13312.67	13339.88	13290.38	13303.11	4283.0
2020-10-26 20:00:00	NQ	Futures	13303.11	13352.61	13296.17	13343.93	5741.0
2020-10-26 21:00:00	NQ	Futures	13344.22	13346.53	13299.64	13306.3	5450.0
2020-10-26 22:00:00	NQ	Futures	13305.14	13321.64	13300.22	13313.82	2735.0
2020-10-26 23:00:00	NQ	Futures	13314.11	13329.17	13305.14	13307.17	2311.0
2020-10-26 00:00:00	YM	Futures	30998.3	30999.4	30965.1	30975.0	960.0
2020-10-26 01:00:00	YM	Futures	30976.1	31008.2	30933.0	30937.4	1711.0
2020-10-26 02:00:00	YM	Futures	30938.5	30956.2	30929.7	30936.3	1296.0
2020-10-26 03:00:00	YM	Futures	30937.4	30946.3	30784.9	30822.5	7835.0

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

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