PREVIEW / futures_1hour / 2019-01-11

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-01-11.parquet
  size:    47 KB
  rows:    1,393

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
2019-01-11 00:00:00	ES	Futures	2814.43	2815.25	2813.34	2813.62	4281.0
2019-01-11 01:00:00	ES	Futures	2813.62	2817.42	2813.34	2817.15	4451.0
2019-01-11 02:00:00	ES	Futures	2816.88	2819.32	2814.97	2817.15	9423.0
2019-01-11 03:00:00	ES	Futures	2817.15	2822.04	2813.89	2820.13	18451.0
2019-01-11 04:00:00	ES	Futures	2820.13	2821.49	2816.6	2818.23	14096.0
2019-01-11 05:00:00	ES	Futures	2818.5	2819.05	2811.72	2815.25	17683.0
2019-01-11 06:00:00	ES	Futures	2815.25	2817.15	2811.44	2813.34	13308.0
2019-01-11 07:00:00	ES	Futures	2813.07	2814.43	2809.81	2810.9	15050.0
2019-01-11 08:00:00	ES	Futures	2810.63	2811.99	2805.47	2808.73	37913.0
2019-01-11 09:00:00	ES	Futures	2808.46	2810.36	2799.49	2804.93	163769.0
2019-01-11 10:00:00	ES	Futures	2804.93	2812.26	2800.04	2811.99	186875.0
2019-01-11 11:00:00	ES	Futures	2811.72	2815.52	2805.47	2814.7	138723.0
2019-01-11 12:00:00	ES	Futures	2814.97	2820.13	2812.8	2818.5	98290.0
2019-01-11 13:00:00	ES	Futures	2818.5	2818.5	2808.73	2813.62	87065.0
2019-01-11 14:00:00	ES	Futures	2813.62	2817.69	2811.44	2813.07	81480.0
2019-01-11 15:00:00	ES	Futures	2813.34	2820.95	2812.53	2820.41	153738.0
2019-01-11 16:00:00	ES	Futures	2820.41	2820.95	2818.5	2819.59	52417.0
2019-01-11 00:00:00	NQ	Futures	7730.45	7733.67	7727.82	7730.45	1869.0
2019-01-11 01:00:00	NQ	Futures	7731.04	7738.63	7729.58	7738.34	1675.0
2019-01-11 02:00:00	NQ	Futures	7738.05	7745.94	7731.91	7740.1	3330.0
2019-01-11 03:00:00	NQ	Futures	7739.22	7751.78	7726.95	7745.65	6103.0
2019-01-11 04:00:00	NQ	Futures	7745.94	7749.15	7735.13	7740.1	4074.0
2019-01-11 05:00:00	NQ	Futures	7740.39	7742.73	7721.1	7731.91	6297.0
2019-01-11 06:00:00	NQ	Futures	7731.91	7735.71	7717.89	7723.44	4164.0
2019-01-11 07:00:00	NQ	Futures	7723.73	7727.24	7712.63	7712.63	5677.0
2019-01-11 08:00:00	NQ	Futures	7712.92	7720.23	7700.36	7711.75	13729.0
2019-01-11 09:00:00	NQ	Futures	7712.05	7716.72	7681.07	7700.07	49443.0
2019-01-11 10:00:00	NQ	Futures	7699.48	7720.81	7681.37	7715.84	63539.0
2019-01-11 11:00:00	NQ	Futures	7715.84	7720.23	7690.13	7713.21	47878.0
2019-01-11 12:00:00	NQ	Futures	7713.21	7731.91	7708.83	7724.9	27646.0
2019-01-11 13:00:00	NQ	Futures	7724.32	7725.78	7692.47	7702.11	29943.0
2019-01-11 14:00:00	NQ	Futures	7702.4	7720.81	7695.1	7711.46	32916.0
2019-01-11 15:00:00	NQ	Futures	7711.46	7733.08	7710.29	7728.99	30635.0
2019-01-11 16:00:00	NQ	Futures	7728.99	7731.91	7724.61	7731.91	7919.0
2019-01-11 00:00:00	YM	Futures	25987.5	25998.3	25972.3	25979.9	1354.0
2019-01-11 01:00:00	YM	Futures	25981.0	26005.9	25977.7	26004.8	1088.0
2019-01-11 02:00:00	YM	Futures	26003.8	26027.6	25989.6	26009.2	2609.0
2019-01-11 03:00:00	YM	Futures	26008.1	26050.4	25983.1	26038.5	4644.0
2019-01-11 04:00:00	YM	Futures	26037.4	26049.4	26009.2	26023.3	3083.0
2019-01-11 05:00:00	YM	Futures	26023.3	26029.8	25967.9	26004.8	4697.0
2019-01-11 06:00:00	YM	Futures	26005.9	26020.0	25963.6	25977.7	3606.0
2019-01-11 07:00:00	YM	Futures	25978.8	25992.9	25947.3	25960.3	3896.0
2019-01-11 08:00:00	YM	Futures	25960.3	25964.7	25905.0	25933.2	7606.0
2019-01-11 09:00:00	YM	Futures	25933.2	25948.4	25808.3	25860.4	23875.0
2019-01-11 10:00:00	YM	Futures	25860.4	25932.1	25801.8	25928.8	25732.0
2019-01-11 11:00:00	YM	Futures	25928.8	25962.5	25863.7	25956.0	18428.0
2019-01-11 12:00:00	YM	Futures	25957.1	26005.9	25945.1	25979.9	13128.0
2019-01-11 13:00:00	YM	Futures	25979.9	25982.0	25895.2	25944.0	14254.0
2019-01-11 14:00:00	YM	Futures	25943.0	25979.9	25921.2	25945.1	10244.0
2019-01-11 15:00:00	YM	Futures	25944.0	26020.0	25937.5	26016.8	14317.0

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

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