PREVIEW / futures_1hour / 2020-11-02

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-11-02.parquet
  size:    63 KB
  rows:    1,940

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-02 00:00:00	ES	Futures	3661.68	3672.32	3659.99	3670.08	7378.0
2020-11-02 01:00:00	ES	Futures	3669.52	3672.88	3656.35	3661.12	11026.0
2020-11-02 02:00:00	ES	Futures	3660.84	3674.28	3655.51	3672.04	24972.0
2020-11-02 03:00:00	ES	Futures	3671.76	3681.84	3661.12	3681.0	46413.0
2020-11-02 04:00:00	ES	Futures	3681.0	3706.77	3678.76	3698.93	37345.0
2020-11-02 05:00:00	ES	Futures	3698.65	3722.46	3698.65	3715.73	27959.0
2020-11-02 06:00:00	ES	Futures	3715.73	3717.13	3708.17	3709.57	24483.0
2020-11-02 07:00:00	ES	Futures	3709.57	3710.97	3694.45	3698.93	28603.0
2020-11-02 08:00:00	ES	Futures	3698.93	3703.69	3696.13	3697.53	28922.0
2020-11-02 09:00:00	ES	Futures	3697.53	3708.17	3685.2	3705.37	191759.0
2020-11-02 10:00:00	ES	Futures	3705.37	3723.58	3697.25	3699.21	288695.0
2020-11-02 11:00:00	ES	Futures	3699.21	3709.01	3690.25	3702.85	175552.0
2020-11-02 12:00:00	ES	Futures	3702.85	3706.21	3682.12	3689.12	154318.0
2020-11-02 13:00:00	ES	Futures	3689.12	3691.09	3665.88	3667.56	154676.0
2020-11-02 14:00:00	ES	Futures	3667.56	3697.25	3665.88	3690.81	174900.0
2020-11-02 15:00:00	ES	Futures	3691.09	3701.73	3681.0	3699.21	281963.0
2020-11-02 16:00:00	ES	Futures	3699.21	3704.25	3694.17	3701.17	48285.0
2020-11-02 18:00:00	ES	Futures	3701.73	3712.37	3698.65	3707.33	8842.0
2020-11-02 19:00:00	ES	Futures	3707.33	3716.85	3701.73	3715.17	9128.0
2020-11-02 20:00:00	ES	Futures	3715.45	3721.62	3706.77	3719.65	11081.0
2020-11-02 21:00:00	ES	Futures	3719.65	3725.26	3717.69	3725.26	8578.0
2020-11-02 22:00:00	ES	Futures	3724.98	3725.26	3715.73	3717.97	7541.0
2020-11-02 23:00:00	ES	Futures	3717.69	3717.97	3709.57	3710.41	5378.0
2020-11-02 00:00:00	NQ	Futures	12799.44	12837.36	12792.49	12830.12	5216.0
2020-11-02 01:00:00	NQ	Futures	12829.25	12844.88	12787.28	12802.04	5761.0
2020-11-02 02:00:00	NQ	Futures	12801.46	12857.91	12789.89	12845.75	9006.0
2020-11-02 03:00:00	NQ	Futures	12844.31	12891.2	12811.6	12888.3	12039.0
2020-11-02 04:00:00	NQ	Futures	12887.73	12948.51	12877.02	12919.86	10173.0
2020-11-02 05:00:00	NQ	Futures	12919.86	12981.51	12919.28	12964.15	9344.0
2020-11-02 06:00:00	NQ	Futures	12964.72	12969.36	12932.3	12939.54	6359.0
2020-11-02 07:00:00	NQ	Futures	12937.8	12940.12	12877.02	12885.7	9806.0
2020-11-02 08:00:00	NQ	Futures	12885.99	12908.28	12877.88	12893.8	16148.0
2020-11-02 09:00:00	NQ	Futures	12894.09	12982.09	12862.25	12940.7	69985.0
2020-11-02 10:00:00	NQ	Futures	12940.99	12978.62	12860.52	12876.44	85676.0
2020-11-02 11:00:00	NQ	Futures	12876.15	12893.8	12795.67	12824.62	69449.0
2020-11-02 12:00:00	NQ	Futures	12824.62	12841.41	12742.41	12766.44	53403.0
2020-11-02 13:00:00	NQ	Futures	12766.44	12772.52	12669.76	12676.7	52769.0
2020-11-02 14:00:00	NQ	Futures	12676.7	12769.91	12670.62	12747.91	55702.0
2020-11-02 15:00:00	NQ	Futures	12747.91	12818.54	12732.86	12816.23	72347.0
2020-11-02 16:00:00	NQ	Futures	12816.52	12840.25	12805.23	12822.88	11607.0
2020-11-02 18:00:00	NQ	Futures	12823.17	12848.94	12811.31	12838.23	3347.0
2020-11-02 19:00:00	NQ	Futures	12839.09	12872.67	12819.7	12869.49	4731.0
2020-11-02 20:00:00	NQ	Futures	12870.36	12874.7	12822.6	12868.04	5433.0
2020-11-02 21:00:00	NQ	Futures	12868.04	12881.94	12850.96	12880.78	3590.0
2020-11-02 22:00:00	NQ	Futures	12880.2	12882.23	12838.81	12848.65	4056.0
2020-11-02 23:00:00	NQ	Futures	12848.36	12848.94	12813.62	12817.1	3298.0
2020-11-02 00:00:00	YM	Futures	29209.4	29295.6	29197.2	29271.3	2495.0
2020-11-02 01:00:00	YM	Futures	29269.1	29303.3	29158.5	29207.1	2466.0
2020-11-02 02:00:00	YM	Futures	29202.7	29298.9	29140.8	29284.5	4585.0
2020-11-02 03:00:00	YM	Futures	29282.3	29378.5	29181.7	29370.8	8874.0

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

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