PREVIEW / futures_1hour / 2020-08-05

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-08-05.parquet
  size:    60 KB
  rows:    1,828

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-05 00:00:00	ES	Futures	3688.25	3688.81	3685.46	3686.29	3914.0
2020-08-05 01:00:00	ES	Futures	3686.57	3693.27	3685.74	3691.32	7226.0
2020-08-05 02:00:00	ES	Futures	3691.6	3699.42	3690.2	3699.14	13085.0
2020-08-05 03:00:00	ES	Futures	3699.14	3707.52	3696.63	3706.4	28941.0
2020-08-05 04:00:00	ES	Futures	3706.12	3706.96	3696.07	3705.84	21134.0
2020-08-05 05:00:00	ES	Futures	3706.12	3708.07	3701.93	3706.96	17940.0
2020-08-05 06:00:00	ES	Futures	3706.96	3709.19	3703.89	3706.12	13769.0
2020-08-05 07:00:00	ES	Futures	3705.84	3710.31	3703.89	3710.31	19418.0
2020-08-05 08:00:00	ES	Futures	3710.03	3710.03	3697.46	3703.05	48542.0
2020-08-05 09:00:00	ES	Futures	3703.05	3706.96	3698.86	3705.84	117647.0
2020-08-05 10:00:00	ES	Futures	3706.4	3709.47	3703.33	3706.12	152637.0
2020-08-05 11:00:00	ES	Futures	3706.12	3711.98	3703.05	3703.89	160369.0
2020-08-05 12:00:00	ES	Futures	3703.61	3707.24	3701.37	3705.84	74020.0
2020-08-05 13:00:00	ES	Futures	3705.84	3707.8	3703.89	3706.4	54548.0
2020-08-05 14:00:00	ES	Futures	3706.68	3710.03	3704.44	3706.4	82605.0
2020-08-05 15:00:00	ES	Futures	3706.12	3711.43	3698.58	3708.35	165916.0
2020-08-05 16:00:00	ES	Futures	3708.07	3709.19	3702.77	3705.84	40495.0
2020-08-05 18:00:00	ES	Futures	3705.0	3708.35	3702.77	3707.8	4720.0
2020-08-05 19:00:00	ES	Futures	3708.07	3709.47	3705.84	3706.96	6094.0
2020-08-05 20:00:00	ES	Futures	3706.96	3716.73	3705.84	3715.89	14994.0
2020-08-05 21:00:00	ES	Futures	3715.89	3718.69	3713.1	3714.5	11729.0
2020-08-05 22:00:00	ES	Futures	3714.5	3715.06	3703.89	3703.89	14304.0
2020-08-05 23:00:00	ES	Futures	3703.89	3708.35	3703.61	3704.44	9560.0
2020-08-05 00:00:00	NQ	Futures	12836.92	12843.0	12829.41	12831.43	2822.0
2020-08-05 01:00:00	NQ	Futures	12832.01	12846.18	12826.51	12840.39	3323.0
2020-08-05 02:00:00	NQ	Futures	12839.53	12869.31	12832.3	12868.44	6253.0
2020-08-05 03:00:00	NQ	Futures	12869.02	12881.75	12858.03	12879.14	9745.0
2020-08-05 04:00:00	NQ	Futures	12878.57	12883.48	12842.42	12870.47	8647.0
2020-08-05 05:00:00	NQ	Futures	12870.18	12890.42	12863.53	12881.75	5427.0
2020-08-05 06:00:00	NQ	Futures	12881.75	12885.8	12851.09	12858.03	5240.0
2020-08-05 07:00:00	NQ	Futures	12857.46	12877.41	12852.54	12869.02	5890.0
2020-08-05 08:00:00	NQ	Futures	12868.44	12869.6	12819.86	12825.07	14164.0
2020-08-05 09:00:00	NQ	Futures	12824.78	12855.14	12798.46	12849.94	58910.0
2020-08-05 10:00:00	NQ	Futures	12850.23	12871.34	12825.65	12840.39	57248.0
2020-08-05 11:00:00	NQ	Futures	12840.39	12872.49	12821.89	12828.54	40818.0
2020-08-05 12:00:00	NQ	Futures	12828.54	12856.01	12828.54	12841.84	26677.0
2020-08-05 13:00:00	NQ	Futures	12842.13	12860.93	12838.08	12853.41	17101.0
2020-08-05 14:00:00	NQ	Futures	12853.41	12864.97	12836.06	12849.94	19885.0
2020-08-05 15:00:00	NQ	Futures	12850.23	12859.19	12804.83	12852.54	36034.0
2020-08-05 16:00:00	NQ	Futures	12852.54	12854.28	12823.62	12834.61	7406.0
2020-08-05 18:00:00	NQ	Futures	12832.59	12838.95	12822.18	12836.06	1787.0
2020-08-05 19:00:00	NQ	Futures	12836.64	12838.95	12824.78	12827.38	1486.0
2020-08-05 20:00:00	NQ	Futures	12826.22	12860.06	12823.33	12857.17	4264.0
2020-08-05 21:00:00	NQ	Futures	12857.17	12869.89	12847.33	12850.23	5925.0
2020-08-05 22:00:00	NQ	Futures	12850.23	12852.25	12816.97	12818.71	6901.0
2020-08-05 23:00:00	NQ	Futures	12817.84	12835.48	12815.24	12819.57	4133.0
2020-08-05 00:00:00	YM	Futures	29469.8	29470.9	29437.9	29445.6	1044.0
2020-08-05 01:00:00	YM	Futures	29446.7	29508.3	29440.1	29486.3	1640.0
2020-08-05 02:00:00	YM	Futures	29487.4	29560.1	29478.6	29554.6	2656.0
2020-08-05 03:00:00	YM	Futures	29554.6	29647.1	29540.3	29631.7	6121.0

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

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