PREVIEW / futures_1hour / 2020-07-28

all futures 1-hour files

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

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-28 00:00:00	ES	Futures	3612.85	3615.92	3609.5	3613.97	7182.0
2020-07-28 01:00:00	ES	Futures	3613.69	3613.97	3609.78	3612.85	7921.0
2020-07-28 02:00:00	ES	Futures	3612.85	3615.65	3610.34	3610.9	7554.0
2020-07-28 03:00:00	ES	Futures	3610.62	3617.04	3608.11	3610.62	24204.0
2020-07-28 04:00:00	ES	Futures	3610.62	3613.41	3607.83	3613.41	15972.0
2020-07-28 05:00:00	ES	Futures	3613.41	3614.53	3596.94	3600.85	25452.0
2020-07-28 06:00:00	ES	Futures	3600.85	3603.92	3592.75	3603.64	20204.0
2020-07-28 07:00:00	ES	Futures	3603.92	3605.03	3591.07	3596.1	24049.0
2020-07-28 08:00:00	ES	Futures	3595.82	3601.68	3593.58	3601.4	20456.0
2020-07-28 09:00:00	ES	Futures	3601.12	3607.83	3588.28	3594.7	181409.0
2020-07-28 10:00:00	ES	Futures	3594.42	3608.38	3592.47	3605.03	221534.0
2020-07-28 11:00:00	ES	Futures	3605.31	3612.57	3597.21	3606.43	143438.0
2020-07-28 12:00:00	ES	Futures	3606.43	3608.11	3601.68	3607.55	84802.0
2020-07-28 13:00:00	ES	Futures	3607.27	3614.81	3603.92	3613.13	102812.0
2020-07-28 14:00:00	ES	Futures	3612.85	3614.25	3606.71	3607.27	100843.0
2020-07-28 15:00:00	ES	Futures	3607.27	3608.66	3583.25	3587.44	246467.0
2020-07-28 16:00:00	ES	Futures	3587.72	3591.35	3584.65	3588.84	44232.0
2020-07-28 18:00:00	ES	Futures	3591.07	3595.54	3589.95	3593.31	5408.0
2020-07-28 19:00:00	ES	Futures	3593.31	3594.42	3588.84	3593.86	6151.0
2020-07-28 20:00:00	ES	Futures	3594.14	3598.05	3589.95	3596.1	13841.0
2020-07-28 21:00:00	ES	Futures	3596.1	3596.94	3585.49	3590.51	13719.0
2020-07-28 22:00:00	ES	Futures	3590.23	3591.07	3586.05	3587.16	7966.0
2020-07-28 23:00:00	ES	Futures	3586.88	3590.51	3583.53	3587.16	5723.0
2020-07-28 00:00:00	NQ	Futures	12372.79	12391.01	12363.54	12380.6	3756.0
2020-07-28 01:00:00	NQ	Futures	12380.31	12382.91	12354.86	12369.32	3921.0
2020-07-28 02:00:00	NQ	Futures	12369.03	12399.11	12359.78	12377.13	4521.0
2020-07-28 03:00:00	NQ	Futures	12377.13	12395.35	12340.98	12354.86	8671.0
2020-07-28 04:00:00	NQ	Futures	12355.15	12362.09	12323.34	12355.44	6624.0
2020-07-28 05:00:00	NQ	Futures	12355.15	12360.94	12290.38	12304.84	8027.0
2020-07-28 06:00:00	NQ	Futures	12304.84	12322.48	12278.81	12321.03	7175.0
2020-07-28 07:00:00	NQ	Futures	12321.61	12333.18	12262.33	12273.89	11360.0
2020-07-28 08:00:00	NQ	Futures	12273.89	12315.25	12268.69	12312.07	10914.0
2020-07-28 09:00:00	NQ	Futures	12311.49	12315.25	12211.72	12247.0	69447.0
2020-07-28 10:00:00	NQ	Futures	12247.0	12297.32	12229.94	12289.8	64230.0
2020-07-28 11:00:00	NQ	Futures	12290.38	12321.03	12250.47	12278.81	43474.0
2020-07-28 12:00:00	NQ	Futures	12278.81	12302.23	12252.49	12296.45	34464.0
2020-07-28 13:00:00	NQ	Futures	12296.74	12319.87	12275.63	12304.26	24054.0
2020-07-28 14:00:00	NQ	Futures	12304.55	12305.99	12253.94	12260.88	34011.0
2020-07-28 15:00:00	NQ	Futures	12260.3	12264.93	12161.69	12174.71	60874.0
2020-07-28 16:00:00	NQ	Futures	12175.57	12203.05	12174.42	12202.47	9592.0
2020-07-28 18:00:00	NQ	Futures	12212.59	12231.38	12207.96	12220.4	2454.0
2020-07-28 19:00:00	NQ	Futures	12221.55	12224.73	12201.02	12218.95	2301.0
2020-07-28 20:00:00	NQ	Futures	12218.66	12238.04	12196.68	12232.54	4786.0
2020-07-28 21:00:00	NQ	Futures	12231.96	12235.14	12174.42	12200.15	5525.0
2020-07-28 22:00:00	NQ	Futures	12200.15	12209.99	12188.01	12195.82	4503.0
2020-07-28 23:00:00	NQ	Futures	12195.53	12214.03	12189.45	12205.65	3310.0
2020-07-28 00:00:00	YM	Futures	29170.3	29187.9	29139.5	29173.6	2030.0
2020-07-28 01:00:00	YM	Futures	29173.6	29181.3	29145.0	29173.6	2240.0
2020-07-28 02:00:00	YM	Futures	29172.5	29186.8	29146.1	29146.1	1778.0
2020-07-28 03:00:00	YM	Futures	29146.1	29215.4	29131.8	29154.9	4584.0

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

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