PREVIEW / futures_1hour / 2020-11-16

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-11-16.parquet
  size:    62 KB
  rows:    1,917

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-11-16 00:00:00	ES	Futures	4045.12	4050.17	4043.16	4048.49	6857.0
2020-11-16 01:00:00	ES	Futures	4048.49	4053.25	4044.56	4047.37	8135.0
2020-11-16 02:00:00	ES	Futures	4047.65	4050.17	4043.16	4047.65	8049.0
2020-11-16 03:00:00	ES	Futures	4047.65	4050.17	4036.72	4040.36	29063.0
2020-11-16 04:00:00	ES	Futures	4040.64	4049.61	4040.08	4048.77	11483.0
2020-11-16 05:00:00	ES	Futures	4048.77	4049.05	4042.32	4045.97	11327.0
2020-11-16 06:00:00	ES	Futures	4045.97	4074.81	4042.04	4055.21	48526.0
2020-11-16 07:00:00	ES	Futures	4055.49	4067.25	4050.17	4056.61	55427.0
2020-11-16 08:00:00	ES	Futures	4056.33	4057.73	4045.68	4048.77	32907.0
2020-11-16 09:00:00	ES	Futures	4048.77	4054.37	4029.72	4039.24	174466.0
2020-11-16 10:00:00	ES	Futures	4038.96	4056.33	4036.44	4056.33	151385.0
2020-11-16 11:00:00	ES	Futures	4056.05	4059.69	4052.97	4054.09	93664.0
2020-11-16 12:00:00	ES	Futures	4054.37	4056.61	4043.44	4046.81	70422.0
2020-11-16 13:00:00	ES	Futures	4047.09	4047.09	4030.28	4040.64	103919.0
2020-11-16 14:00:00	ES	Futures	4040.64	4048.21	4036.44	4044.56	83944.0
2020-11-16 15:00:00	ES	Futures	4044.56	4063.05	4036.72	4062.77	232637.0
2020-11-16 16:00:00	ES	Futures	4062.49	4068.09	4060.81	4065.01	70203.0
2020-11-16 18:00:00	ES	Futures	4061.93	4066.97	4059.69	4060.53	9496.0
2020-11-16 19:00:00	ES	Futures	4060.81	4060.81	4051.85	4054.09	13558.0
2020-11-16 20:00:00	ES	Futures	4053.81	4056.33	4041.76	4043.44	12508.0
2020-11-16 21:00:00	ES	Futures	4043.72	4048.49	4042.88	4044.0	9101.0
2020-11-16 22:00:00	ES	Futures	4044.0	4047.93	4043.44	4045.4	5724.0
2020-11-16 23:00:00	ES	Futures	4045.4	4045.4	4039.8	4042.32	6539.0
2020-11-16 00:00:00	NQ	Futures	13947.47	13963.68	13937.63	13945.73	3206.0
2020-11-16 01:00:00	NQ	Futures	13946.31	13949.5	13909.55	13919.68	4943.0
2020-11-16 02:00:00	NQ	Futures	13919.39	13927.21	13898.26	13911.58	5443.0
2020-11-16 03:00:00	NQ	Futures	13910.13	13916.79	13869.89	13887.26	11013.0
2020-11-16 04:00:00	NQ	Futures	13887.26	13910.42	13878.0	13898.26	5452.0
2020-11-16 05:00:00	NQ	Futures	13899.42	13903.76	13873.95	13886.1	4187.0
2020-11-16 06:00:00	NQ	Futures	13885.81	13916.21	13804.76	13810.84	11173.0
2020-11-16 07:00:00	NQ	Futures	13812.29	13841.81	13722.84	13803.31	24322.0
2020-11-16 08:00:00	NQ	Futures	13802.45	13811.13	13758.16	13778.42	20541.0
2020-11-16 09:00:00	NQ	Futures	13779.29	13881.76	13764.53	13855.71	76303.0
2020-11-16 10:00:00	NQ	Futures	13854.84	13912.16	13840.08	13912.16	64478.0
2020-11-16 11:00:00	NQ	Futures	13912.16	13933.58	13863.52	13888.42	39783.0
2020-11-16 12:00:00	NQ	Futures	13888.71	13901.73	13838.34	13853.1	32736.0
2020-11-16 13:00:00	NQ	Futures	13853.1	13865.55	13813.74	13860.05	46680.0
2020-11-16 14:00:00	NQ	Futures	13860.63	13880.02	13840.37	13848.18	33370.0
2020-11-16 15:00:00	NQ	Futures	13848.76	13914.18	13829.37	13910.42	43403.0
2020-11-16 16:00:00	NQ	Futures	13910.71	13944.0	13907.52	13942.55	10042.0
2020-11-16 18:00:00	NQ	Futures	13965.42	14005.94	13948.63	13952.1	4971.0
2020-11-16 19:00:00	NQ	Futures	13951.81	13961.94	13935.6	13948.92	3774.0
2020-11-16 20:00:00	NQ	Futures	13950.08	13959.34	13910.71	13921.42	4548.0
2020-11-16 21:00:00	NQ	Futures	13921.42	13930.1	13898.84	13902.31	3387.0
2020-11-16 22:00:00	NQ	Futures	13901.73	13928.08	13901.44	13922.58	2407.0
2020-11-16 23:00:00	NQ	Futures	13921.42	13924.6	13899.71	13903.47	2326.0
2020-11-16 00:00:00	YM	Futures	32780.5	32824.7	32769.5	32823.6	2023.0
2020-11-16 01:00:00	YM	Futures	32822.5	32862.3	32797.1	32823.6	4142.0
2020-11-16 02:00:00	YM	Futures	32821.4	32851.3	32784.9	32835.8	4161.0
2020-11-16 03:00:00	YM	Futures	32833.6	32853.5	32735.2	32756.2	6780.0

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

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