PREVIEW / futures_1hour / 2020-07-15

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-07-15.parquet
  size:    59 KB
  rows:    1,834

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-07-15 00:00:00	ES	Futures	3582.69	3586.6	3581.3	3586.05	9312.0
2020-07-15 01:00:00	ES	Futures	3586.05	3587.16	3581.86	3583.81	7959.0
2020-07-15 02:00:00	ES	Futures	3583.53	3587.16	3580.18	3580.46	13418.0
2020-07-15 03:00:00	ES	Futures	3580.46	3582.14	3572.08	3581.02	24656.0
2020-07-15 04:00:00	ES	Futures	3581.02	3585.49	3577.67	3578.23	18215.0
2020-07-15 05:00:00	ES	Futures	3578.23	3580.46	3574.32	3575.99	17885.0
2020-07-15 06:00:00	ES	Futures	3575.71	3598.61	3574.88	3596.1	49567.0
2020-07-15 07:00:00	ES	Futures	3596.38	3606.43	3594.98	3604.2	41066.0
2020-07-15 08:00:00	ES	Futures	3604.48	3611.46	3601.12	3609.78	55289.0
2020-07-15 09:00:00	ES	Futures	3609.78	3610.06	3587.16	3594.42	217632.0
2020-07-15 10:00:00	ES	Futures	3594.42	3607.55	3586.05	3598.61	213454.0
2020-07-15 11:00:00	ES	Futures	3598.33	3601.12	3570.41	3570.97	280999.0
2020-07-15 12:00:00	ES	Futures	3570.97	3586.32	3565.38	3585.77	178481.0
2020-07-15 13:00:00	ES	Futures	3585.77	3593.58	3581.58	3585.77	113835.0
2020-07-15 14:00:00	ES	Futures	3586.05	3598.33	3582.14	3584.09	209630.0
2020-07-15 15:00:00	ES	Futures	3584.09	3603.08	3575.71	3594.7	276446.0
2020-07-15 16:00:00	ES	Futures	3594.42	3600.85	3591.91	3598.05	45252.0
2020-07-15 18:00:00	ES	Futures	3600.29	3606.15	3592.75	3594.42	13374.0
2020-07-15 19:00:00	ES	Futures	3594.42	3598.89	3593.58	3594.42	5101.0
2020-07-15 20:00:00	ES	Futures	3594.42	3594.42	3582.97	3586.32	18671.0
2020-07-15 21:00:00	ES	Futures	3586.32	3591.35	3580.18	3588.84	13608.0
2020-07-15 22:00:00	ES	Futures	3588.84	3594.7	3575.15	3579.06	19408.0
2020-07-15 23:00:00	ES	Futures	3579.06	3581.3	3576.27	3580.18	13744.0
2020-07-15 00:00:00	NQ	Futures	12349.66	12371.64	12339.83	12369.9	4433.0
2020-07-15 01:00:00	NQ	Futures	12369.61	12382.05	12357.18	12375.4	4255.0
2020-07-15 02:00:00	NQ	Futures	12375.68	12391.88	12364.12	12367.01	5812.0
2020-07-15 03:00:00	NQ	Futures	12366.43	12381.18	12343.01	12365.56	10703.0
2020-07-15 04:00:00	NQ	Futures	12366.43	12385.23	12361.23	12363.54	8039.0
2020-07-15 05:00:00	NQ	Futures	12362.67	12374.24	12338.09	12348.79	7986.0
2020-07-15 06:00:00	NQ	Futures	12349.37	12414.15	12347.35	12412.41	15037.0
2020-07-15 07:00:00	NQ	Futures	12412.7	12440.46	12383.2	12395.64	16967.0
2020-07-15 08:00:00	NQ	Futures	12395.93	12417.04	12369.9	12404.31	23618.0
2020-07-15 09:00:00	NQ	Futures	12404.02	12453.76	12350.53	12385.52	102508.0
2020-07-15 10:00:00	NQ	Futures	12385.52	12444.8	12361.51	12381.76	93732.0
2020-07-15 11:00:00	NQ	Futures	12381.76	12389.57	12230.23	12230.23	106101.0
2020-07-15 12:00:00	NQ	Futures	12230.81	12318.72	12204.78	12314.67	78376.0
2020-07-15 13:00:00	NQ	Futures	12314.09	12345.61	12281.12	12313.51	48390.0
2020-07-15 14:00:00	NQ	Futures	12313.8	12390.14	12297.03	12327.39	60487.0
2020-07-15 15:00:00	NQ	Futures	12327.39	12378.0	12286.33	12362.67	70068.0
2020-07-15 16:00:00	NQ	Futures	12361.8	12368.74	12351.39	12364.99	8619.0
2020-07-15 18:00:00	NQ	Futures	12368.74	12374.82	12296.45	12302.52	5606.0
2020-07-15 19:00:00	NQ	Futures	12302.52	12323.92	12302.52	12315.82	3094.0
2020-07-15 20:00:00	NQ	Futures	12314.67	12316.4	12267.24	12279.68	8196.0
2020-07-15 21:00:00	NQ	Futures	12280.26	12303.39	12261.46	12292.98	6685.0
2020-07-15 22:00:00	NQ	Futures	12292.69	12306.57	12235.43	12251.05	8929.0
2020-07-15 23:00:00	NQ	Futures	12251.05	12259.15	12232.83	12255.96	2991.0
2020-07-15 00:00:00	YM	Futures	29479.7	29521.6	29468.7	29511.7	1818.0
2020-07-15 01:00:00	YM	Futures	29512.8	29515.0	29454.4	29468.7	2508.0
2020-07-15 02:00:00	YM	Futures	29469.8	29501.7	29437.9	29439.0	2259.0
2020-07-15 03:00:00	YM	Futures	29442.3	29455.5	29369.6	29446.7	5003.0

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

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