PREVIEW / futures_1hour / 2020-07-16

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-07-16.parquet
  size:    57 KB
  rows:    1,802

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-16 00:00:00	ES	Futures	3580.46	3584.09	3579.06	3581.02	6374.0
2020-07-16 01:00:00	ES	Futures	3581.02	3581.86	3571.25	3579.62	19204.0
2020-07-16 02:00:00	ES	Futures	3579.34	3583.53	3574.32	3575.71	18928.0
2020-07-16 03:00:00	ES	Futures	3575.71	3581.02	3569.29	3574.32	55034.0
2020-07-16 04:00:00	ES	Futures	3574.04	3577.67	3564.26	3568.73	28907.0
2020-07-16 05:00:00	ES	Futures	3568.45	3571.8	3561.47	3567.62	23355.0
2020-07-16 06:00:00	ES	Futures	3567.34	3573.76	3564.54	3572.64	17889.0
2020-07-16 07:00:00	ES	Futures	3572.92	3577.67	3570.13	3573.2	24478.0
2020-07-16 08:00:00	ES	Futures	3573.2	3574.32	3565.38	3569.29	40043.0
2020-07-16 09:00:00	ES	Futures	3569.29	3579.06	3563.71	3570.69	180835.0
2020-07-16 10:00:00	ES	Futures	3570.41	3581.86	3563.43	3572.64	210674.0
2020-07-16 11:00:00	ES	Futures	3572.36	3577.39	3565.38	3570.97	151872.0
2020-07-16 12:00:00	ES	Futures	3570.97	3574.88	3564.82	3570.13	89395.0
2020-07-16 13:00:00	ES	Futures	3569.85	3580.18	3569.29	3572.64	121434.0
2020-07-16 14:00:00	ES	Futures	3572.36	3580.46	3564.82	3566.5	111940.0
2020-07-16 15:00:00	ES	Futures	3566.5	3587.72	3564.54	3582.42	199392.0
2020-07-16 16:00:00	ES	Futures	3582.69	3584.09	3567.06	3570.69	62147.0
2020-07-16 18:00:00	ES	Futures	3572.64	3577.11	3568.45	3576.55	7691.0
2020-07-16 19:00:00	ES	Futures	3576.55	3579.06	3575.71	3578.23	4262.0
2020-07-16 20:00:00	ES	Futures	3578.23	3581.58	3577.67	3580.74	9758.0
2020-07-16 21:00:00	ES	Futures	3580.74	3581.02	3572.92	3578.78	18974.0
2020-07-16 22:00:00	ES	Futures	3578.78	3583.53	3577.67	3578.51	8743.0
2020-07-16 23:00:00	ES	Futures	3578.51	3579.9	3576.83	3578.51	8433.0
2020-07-16 00:00:00	NQ	Futures	12255.68	12283.15	12255.1	12269.27	3676.0
2020-07-16 01:00:00	NQ	Futures	12268.98	12273.6	12236.01	12264.35	6472.0
2020-07-16 02:00:00	NQ	Futures	12264.06	12283.15	12238.61	12241.51	7492.0
2020-07-16 03:00:00	NQ	Futures	12242.08	12262.62	12223.0	12238.61	12763.0
2020-07-16 04:00:00	NQ	Futures	12238.9	12249.89	12170.95	12189.16	13959.0
2020-07-16 05:00:00	NQ	Futures	12188.01	12189.45	12141.45	12162.56	13947.0
2020-07-16 06:00:00	NQ	Futures	12162.85	12199.29	12128.15	12184.54	14030.0
2020-07-16 07:00:00	NQ	Futures	12186.56	12221.26	12169.21	12196.68	10304.0
2020-07-16 08:00:00	NQ	Futures	12198.13	12218.95	12164.01	12211.43	15923.0
2020-07-16 09:00:00	NQ	Futures	12210.56	12260.88	12188.88	12209.41	84781.0
2020-07-16 10:00:00	NQ	Futures	12209.41	12224.73	12147.23	12157.64	96130.0
2020-07-16 11:00:00	NQ	Futures	12158.22	12195.24	12117.16	12194.37	79780.0
2020-07-16 12:00:00	NQ	Futures	12194.37	12229.94	12168.92	12212.88	43080.0
2020-07-16 13:00:00	NQ	Futures	12212.3	12274.47	12209.41	12245.27	50806.0
2020-07-16 14:00:00	NQ	Futures	12245.55	12289.8	12227.34	12229.65	39766.0
2020-07-16 15:00:00	NQ	Futures	12229.94	12314.38	12220.11	12276.21	63078.0
2020-07-16 16:00:00	NQ	Futures	12276.79	12281.99	12152.44	12184.83	18370.0
2020-07-16 18:00:00	NQ	Futures	12182.8	12217.79	12172.97	12215.48	3400.0
2020-07-16 19:00:00	NQ	Futures	12215.48	12226.76	12209.7	12223.0	2092.0
2020-07-16 20:00:00	NQ	Futures	12223.87	12247.0	12221.84	12245.84	5397.0
2020-07-16 21:00:00	NQ	Futures	12246.13	12250.47	12216.06	12244.11	7187.0
2020-07-16 22:00:00	NQ	Futures	12244.4	12270.13	12238.32	12252.21	4551.0
2020-07-16 23:00:00	NQ	Futures	12251.34	12255.68	12242.95	12252.78	2890.0
2020-07-16 00:00:00	YM	Futures	29361.9	29383.9	29343.2	29365.2	1530.0
2020-07-16 01:00:00	YM	Futures	29363.0	29371.8	29276.0	29352.0	4537.0
2020-07-16 02:00:00	YM	Futures	29349.8	29387.2	29302.4	29309.0	3784.0
2020-07-16 03:00:00	YM	Futures	29311.2	29349.8	29238.6	29283.7	9654.0

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

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