PREVIEW / futures_1hour / 2019-07-29

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-07-29.parquet
  size:    56 KB
  rows:    1,833

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-07-29 00:00:00	ES	Futures	3271.2	3272.28	3270.93	3271.2	1969.0
2019-07-29 01:00:00	ES	Futures	3271.47	3271.74	3270.12	3271.47	4289.0
2019-07-29 02:00:00	ES	Futures	3271.47	3272.55	3270.93	3271.47	5039.0
2019-07-29 03:00:00	ES	Futures	3271.47	3275.53	3270.39	3274.99	16867.0
2019-07-29 04:00:00	ES	Futures	3275.26	3276.07	3273.37	3274.18	10688.0
2019-07-29 05:00:00	ES	Futures	3274.18	3274.99	3272.82	3273.64	10527.0
2019-07-29 06:00:00	ES	Futures	3273.64	3275.53	3272.28	3272.82	10319.0
2019-07-29 07:00:00	ES	Futures	3272.82	3277.97	3272.82	3277.16	15347.0
2019-07-29 08:00:00	ES	Futures	3277.16	3277.97	3275.53	3276.07	13876.0
2019-07-29 09:00:00	ES	Futures	3276.34	3277.43	3267.68	3268.22	138371.0
2019-07-29 10:00:00	ES	Futures	3268.22	3271.47	3265.24	3269.58	150926.0
2019-07-29 11:00:00	ES	Futures	3269.85	3274.18	3268.49	3273.37	73928.0
2019-07-29 12:00:00	ES	Futures	3273.37	3273.64	3269.03	3273.64	50179.0
2019-07-29 13:00:00	ES	Futures	3273.37	3274.45	3271.47	3271.47	48571.0
2019-07-29 14:00:00	ES	Futures	3271.74	3273.37	3270.12	3272.55	46483.0
2019-07-29 15:00:00	ES	Futures	3272.28	3274.45	3270.12	3271.74	127834.0
2019-07-29 16:00:00	ES	Futures	3271.74	3274.18	3271.2	3273.09	43049.0
2019-07-29 18:00:00	ES	Futures	3272.55	3275.26	3272.28	3275.26	4021.0
2019-07-29 19:00:00	ES	Futures	3275.26	3275.8	3274.72	3274.99	2634.0
2019-07-29 20:00:00	ES	Futures	3274.99	3277.16	3274.45	3275.26	8201.0
2019-07-29 21:00:00	ES	Futures	3275.53	3277.43	3274.45	3276.34	6760.0
2019-07-29 22:00:00	ES	Futures	3276.34	3278.24	3276.34	3276.88	4642.0
2019-07-29 23:00:00	ES	Futures	3276.88	3277.7	3275.53	3275.8	4063.0
2019-07-29 00:00:00	NQ	Futures	9294.42	9298.48	9293.55	9295.29	1024.0
2019-07-29 01:00:00	NQ	Futures	9295.29	9296.16	9288.33	9294.71	1741.0
2019-07-29 02:00:00	NQ	Futures	9295.0	9297.32	9292.39	9293.55	1327.0
2019-07-29 03:00:00	NQ	Futures	9293.84	9309.22	9289.78	9308.06	4966.0
2019-07-29 04:00:00	NQ	Futures	9308.06	9311.25	9301.39	9303.71	3287.0
2019-07-29 05:00:00	NQ	Futures	9303.42	9306.61	9297.9	9301.68	2796.0
2019-07-29 06:00:00	NQ	Futures	9301.68	9307.48	9297.61	9299.65	3050.0
2019-07-29 07:00:00	NQ	Futures	9299.65	9321.41	9299.36	9316.18	6373.0
2019-07-29 08:00:00	NQ	Futures	9316.47	9319.08	9311.54	9316.18	5342.0
2019-07-29 09:00:00	NQ	Futures	9316.18	9320.54	9245.1	9250.03	60284.0
2019-07-29 10:00:00	NQ	Futures	9249.74	9262.8	9228.56	9252.35	62865.0
2019-07-29 11:00:00	NQ	Futures	9252.64	9275.27	9247.71	9270.34	33437.0
2019-07-29 12:00:00	NQ	Futures	9270.34	9277.3	9254.96	9277.01	22355.0
2019-07-29 13:00:00	NQ	Futures	9276.43	9284.56	9272.37	9275.56	19735.0
2019-07-29 14:00:00	NQ	Futures	9275.56	9290.94	9270.63	9287.75	20125.0
2019-07-29 15:00:00	NQ	Futures	9288.04	9295.0	9281.37	9287.17	29669.0
2019-07-29 16:00:00	NQ	Futures	9287.17	9292.1	9284.27	9290.36	7166.0
2019-07-29 18:00:00	NQ	Futures	9289.49	9298.19	9286.88	9297.32	1933.0
2019-07-29 19:00:00	NQ	Futures	9297.61	9299.36	9295.0	9296.16	1378.0
2019-07-29 20:00:00	NQ	Futures	9296.16	9305.16	9294.71	9297.61	3368.0
2019-07-29 21:00:00	NQ	Futures	9297.61	9304.29	9293.26	9300.23	3472.0
2019-07-29 22:00:00	NQ	Futures	9300.23	9307.77	9299.65	9303.71	2398.0
2019-07-29 23:00:00	NQ	Futures	9303.42	9306.32	9297.61	9298.19	2149.0
2019-07-29 00:00:00	YM	Futures	29498.4	29503.9	29494.1	29496.3	549.0
2019-07-29 01:00:00	YM	Futures	29496.3	29500.6	29484.3	29498.4	789.0
2019-07-29 02:00:00	YM	Futures	29499.5	29508.2	29495.2	29497.4	970.0
2019-07-29 03:00:00	YM	Futures	29497.4	29534.3	29488.7	29531.1	2485.0

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

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