PREVIEW / futures_1hour / 2020-08-11

all futures 1-hour files

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

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-08-11 00:00:00	ES	Futures	3754.71	3756.94	3752.2	3752.47	5472.0
2020-08-11 01:00:00	ES	Futures	3752.2	3757.22	3752.2	3756.38	7324.0
2020-08-11 02:00:00	ES	Futures	3756.38	3762.25	3749.68	3751.92	17476.0
2020-08-11 03:00:00	ES	Futures	3751.92	3763.92	3751.92	3763.09	30967.0
2020-08-11 04:00:00	ES	Futures	3763.09	3773.14	3760.85	3772.58	25524.0
2020-08-11 05:00:00	ES	Futures	3772.58	3774.26	3768.95	3770.63	20617.0
2020-08-11 06:00:00	ES	Futures	3770.35	3772.86	3767.0	3767.83	18319.0
2020-08-11 07:00:00	ES	Futures	3767.83	3771.46	3761.97	3763.36	25515.0
2020-08-11 08:00:00	ES	Futures	3763.36	3768.67	3762.25	3765.04	36598.0
2020-08-11 09:00:00	ES	Futures	3765.04	3766.72	3754.99	3756.66	196106.0
2020-08-11 10:00:00	ES	Futures	3756.66	3761.69	3746.89	3759.46	211305.0
2020-08-11 11:00:00	ES	Futures	3759.73	3765.88	3756.94	3759.18	137711.0
2020-08-11 12:00:00	ES	Futures	3759.46	3765.6	3754.99	3763.36	124401.0
2020-08-11 13:00:00	ES	Futures	3763.36	3769.51	3761.41	3766.16	116793.0
2020-08-11 14:00:00	ES	Futures	3766.44	3768.11	3749.68	3755.55	179130.0
2020-08-11 15:00:00	ES	Futures	3755.55	3756.66	3707.8	3717.29	429930.0
2020-08-11 16:00:00	ES	Futures	3717.29	3729.02	3709.75	3726.5	65853.0
2020-08-11 18:00:00	ES	Futures	3730.13	3731.53	3722.87	3725.67	9834.0
2020-08-11 19:00:00	ES	Futures	3725.95	3728.18	3721.2	3724.27	6006.0
2020-08-11 20:00:00	ES	Futures	3723.99	3733.21	3716.45	3719.52	18735.0
2020-08-11 21:00:00	ES	Futures	3719.8	3728.18	3717.85	3725.67	13344.0
2020-08-11 22:00:00	ES	Futures	3725.67	3727.06	3715.33	3721.48	12506.0
2020-08-11 23:00:00	ES	Futures	3721.48	3724.83	3718.69	3723.43	7798.0
2020-08-11 00:00:00	NQ	Futures	12862.08	12868.44	12845.89	12849.65	2063.0
2020-08-11 01:00:00	NQ	Futures	12849.36	12871.63	12848.2	12865.55	2311.0
2020-08-11 02:00:00	NQ	Futures	12865.55	12882.9	12841.26	12841.84	5650.0
2020-08-11 03:00:00	NQ	Futures	12842.13	12876.54	12825.65	12875.67	8378.0
2020-08-11 04:00:00	NQ	Futures	12874.52	12896.78	12861.79	12896.5	5919.0
2020-08-11 05:00:00	NQ	Futures	12895.63	12906.33	12877.7	12880.3	4881.0
2020-08-11 06:00:00	NQ	Futures	12879.43	12885.22	12865.84	12867.87	5446.0
2020-08-11 07:00:00	NQ	Futures	12867.58	12872.49	12789.79	12797.02	11598.0
2020-08-11 08:00:00	NQ	Futures	12797.31	12821.02	12708.24	12749.01	25281.0
2020-08-11 09:00:00	NQ	Futures	12748.72	12772.73	12672.96	12732.24	81504.0
2020-08-11 10:00:00	NQ	Futures	12732.24	12750.17	12656.48	12732.82	78830.0
2020-08-11 11:00:00	NQ	Futures	12733.11	12808.01	12731.37	12753.64	54343.0
2020-08-11 12:00:00	NQ	Futures	12753.64	12821.31	12738.31	12795.28	44133.0
2020-08-11 13:00:00	NQ	Futures	12794.99	12808.3	12748.72	12774.17	36550.0
2020-08-11 14:00:00	NQ	Futures	12774.46	12784.0	12692.62	12729.06	49636.0
2020-08-11 15:00:00	NQ	Futures	12728.77	12737.74	12545.14	12572.33	106001.0
2020-08-11 16:00:00	NQ	Futures	12571.75	12625.82	12551.51	12622.06	14349.0
2020-08-11 18:00:00	NQ	Futures	12641.15	12661.39	12630.74	12640.28	3822.0
2020-08-11 19:00:00	NQ	Futures	12640.86	12649.83	12626.69	12634.5	1949.0
2020-08-11 20:00:00	NQ	Futures	12634.21	12665.15	12591.12	12605.29	6062.0
2020-08-11 21:00:00	NQ	Futures	12603.85	12639.7	12599.8	12624.38	4961.0
2020-08-11 22:00:00	NQ	Futures	12625.25	12634.21	12583.31	12614.84	5031.0
2020-08-11 23:00:00	NQ	Futures	12616.28	12629.58	12602.98	12622.06	2612.0
2020-08-11 00:00:00	YM	Futures	30587.5	30604.0	30567.6	30568.7	1043.0
2020-08-11 01:00:00	YM	Futures	30567.6	30604.0	30566.5	30593.0	1401.0
2020-08-11 02:00:00	YM	Futures	30594.1	30663.4	30557.7	30577.6	4285.0
2020-08-11 03:00:00	YM	Futures	30576.5	30696.5	30574.3	30694.3	6087.0

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

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