PREVIEW / futures_1hour / 2020-05-26

all futures 1-hour files

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

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-05-26 00:00:00	ES	Futures	3293.52	3306.69	3292.42	3299.01	18749.0
2020-05-26 01:00:00	ES	Futures	3299.01	3302.58	3295.72	3300.93	11844.0
2020-05-26 02:00:00	ES	Futures	3300.93	3308.61	3298.46	3303.95	26526.0
2020-05-26 03:00:00	ES	Futures	3303.95	3305.87	3296.54	3298.73	36454.0
2020-05-26 04:00:00	ES	Futures	3298.73	3305.59	3297.64	3304.77	25339.0
2020-05-26 05:00:00	ES	Futures	3304.77	3309.44	3302.3	3303.4	27387.0
2020-05-26 06:00:00	ES	Futures	3303.67	3306.42	3299.83	3301.75	19298.0
2020-05-26 07:00:00	ES	Futures	3301.48	3304.22	3297.64	3300.38	25736.0
2020-05-26 08:00:00	ES	Futures	3300.66	3309.44	3297.36	3309.16	43070.0
2020-05-26 09:00:00	ES	Futures	3309.16	3314.65	3296.81	3299.01	212467.0
2020-05-26 10:00:00	ES	Futures	3298.73	3306.69	3293.79	3304.22	206485.0
2020-05-26 11:00:00	ES	Futures	3303.95	3307.24	3288.58	3294.07	201849.0
2020-05-26 12:00:00	ES	Futures	3294.34	3301.75	3290.23	3300.93	97743.0
2020-05-26 13:00:00	ES	Futures	3301.2	3306.14	3299.28	3302.03	67961.0
2020-05-26 14:00:00	ES	Futures	3302.3	3305.59	3297.64	3301.2	76323.0
2020-05-26 15:00:00	ES	Futures	3301.2	3301.75	3274.86	3279.53	342429.0
2020-05-26 16:00:00	ES	Futures	3279.8	3288.86	3279.53	3287.48	59601.0
2020-05-26 18:00:00	ES	Futures	3286.39	3286.66	3280.07	3285.29	10085.0
2020-05-26 19:00:00	ES	Futures	3285.29	3286.11	3279.53	3282.0	6489.0
2020-05-26 20:00:00	ES	Futures	3282.27	3286.93	3274.59	3286.11	17307.0
2020-05-26 21:00:00	ES	Futures	3286.11	3298.19	3285.84	3293.25	22843.0
2020-05-26 22:00:00	ES	Futures	3293.52	3301.75	3287.76	3300.66	15249.0
2020-05-26 23:00:00	ES	Futures	3300.66	3311.36	3300.11	3308.61	17821.0
2020-05-26 00:00:00	NQ	Futures	10932.61	10962.89	10926.04	10948.32	6948.0
2020-05-26 01:00:00	NQ	Futures	10948.61	10957.17	10936.89	10948.89	4718.0
2020-05-26 02:00:00	NQ	Futures	10949.75	10973.17	10941.46	10957.75	7181.0
2020-05-26 03:00:00	NQ	Futures	10957.46	10964.32	10931.47	10942.32	10886.0
2020-05-26 04:00:00	NQ	Futures	10942.04	10956.03	10934.89	10953.46	10271.0
2020-05-26 05:00:00	NQ	Futures	10953.75	10970.89	10943.18	10947.46	8260.0
2020-05-26 06:00:00	NQ	Futures	10947.75	10954.89	10933.18	10936.32	7046.0
2020-05-26 07:00:00	NQ	Futures	10935.75	10936.61	10912.9	10914.33	9964.0
2020-05-26 08:00:00	NQ	Futures	10914.9	10922.04	10896.9	10912.04	15757.0
2020-05-26 09:00:00	NQ	Futures	10912.04	10934.04	10834.64	10852.34	57490.0
2020-05-26 10:00:00	NQ	Futures	10851.2	10884.05	10829.49	10856.63	49915.0
2020-05-26 11:00:00	NQ	Futures	10856.63	10868.91	10754.37	10790.93	51801.0
2020-05-26 12:00:00	NQ	Futures	10791.22	10828.64	10785.5	10820.64	34168.0
2020-05-26 13:00:00	NQ	Futures	10820.64	10838.92	10800.07	10816.35	19373.0
2020-05-26 14:00:00	NQ	Futures	10816.93	10822.35	10783.22	10795.5	21881.0
2020-05-26 15:00:00	NQ	Futures	10795.79	10796.64	10709.24	10726.09	52607.0
2020-05-26 16:00:00	NQ	Futures	10726.38	10756.37	10726.38	10754.94	8976.0
2020-05-26 18:00:00	NQ	Futures	10750.37	10760.37	10731.8	10750.94	3535.0
2020-05-26 19:00:00	NQ	Futures	10751.51	10753.23	10726.38	10733.52	2037.0
2020-05-26 20:00:00	NQ	Futures	10734.95	10751.23	10711.52	10749.23	6526.0
2020-05-26 21:00:00	NQ	Futures	10748.94	10801.22	10748.94	10782.36	10402.0
2020-05-26 22:00:00	NQ	Futures	10782.93	10809.21	10761.8	10804.36	6536.0
2020-05-26 23:00:00	NQ	Futures	10804.93	10842.92	10804.07	10833.21	7361.0
2020-05-26 00:00:00	YM	Futures	27205.5	27331.5	27203.3	27269.0	4281.0
2020-05-26 01:00:00	YM	Futures	27267.9	27305.2	27232.9	27286.5	2533.0
2020-05-26 02:00:00	YM	Futures	27286.5	27345.7	27270.1	27310.6	4556.0
2020-05-26 03:00:00	YM	Futures	27308.5	27321.6	27244.9	27264.6	6526.0

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

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