PREVIEW / futures_1hour / 2020-07-20

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-07-20.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-20 00:00:00	ES	Futures	3579.9	3580.74	3574.88	3576.55	11973.0
2020-07-20 01:00:00	ES	Futures	3576.55	3578.23	3572.08	3577.95	15307.0
2020-07-20 02:00:00	ES	Futures	3577.95	3578.78	3567.34	3572.08	15237.0
2020-07-20 03:00:00	ES	Futures	3572.08	3572.64	3563.43	3572.08	29328.0
2020-07-20 04:00:00	ES	Futures	3572.08	3584.09	3569.29	3583.25	22191.0
2020-07-20 05:00:00	ES	Futures	3583.53	3589.4	3582.42	3584.09	21646.0
2020-07-20 06:00:00	ES	Futures	3584.09	3585.49	3578.23	3580.74	20984.0
2020-07-20 07:00:00	ES	Futures	3581.02	3590.79	3581.02	3586.88	22253.0
2020-07-20 08:00:00	ES	Futures	3586.88	3592.47	3581.86	3590.79	39697.0
2020-07-20 09:00:00	ES	Futures	3590.51	3597.77	3580.18	3586.32	209084.0
2020-07-20 10:00:00	ES	Futures	3586.05	3607.27	3583.81	3601.68	178587.0
2020-07-20 11:00:00	ES	Futures	3601.4	3608.66	3599.73	3605.31	102592.0
2020-07-20 12:00:00	ES	Futures	3605.31	3608.11	3600.85	3607.27	103287.0
2020-07-20 13:00:00	ES	Futures	3607.27	3616.2	3605.31	3614.81	111012.0
2020-07-20 14:00:00	ES	Futures	3614.81	3618.16	3612.57	3615.92	101343.0
2020-07-20 15:00:00	ES	Futures	3615.92	3630.72	3614.25	3622.07	228786.0
2020-07-20 16:00:00	ES	Futures	3622.07	3626.54	3620.95	3623.18	51340.0
2020-07-20 18:00:00	ES	Futures	3623.18	3625.98	3620.11	3622.35	6556.0
2020-07-20 19:00:00	ES	Futures	3622.35	3626.54	3620.95	3622.63	5195.0
2020-07-20 20:00:00	ES	Futures	3622.91	3630.17	3620.95	3628.49	12530.0
2020-07-20 21:00:00	ES	Futures	3628.49	3632.12	3623.74	3625.14	17641.0
2020-07-20 22:00:00	ES	Futures	3625.14	3627.65	3624.3	3627.37	9269.0
2020-07-20 23:00:00	ES	Futures	3627.09	3630.72	3624.58	3630.17	8110.0
2020-07-20 00:00:00	NQ	Futures	12248.74	12251.92	12236.01	12243.24	2988.0
2020-07-20 01:00:00	NQ	Futures	12242.66	12245.55	12223.58	12239.19	5087.0
2020-07-20 02:00:00	NQ	Futures	12239.48	12245.27	12210.56	12224.44	5324.0
2020-07-20 03:00:00	NQ	Futures	12223.58	12230.23	12199.0	12227.91	10312.0
2020-07-20 04:00:00	NQ	Futures	12228.49	12271.87	12218.08	12265.22	9584.0
2020-07-20 05:00:00	NQ	Futures	12265.22	12304.26	12265.22	12296.45	9298.0
2020-07-20 06:00:00	NQ	Futures	12295.58	12299.05	12279.39	12294.71	5589.0
2020-07-20 07:00:00	NQ	Futures	12295.0	12337.51	12292.11	12324.5	9450.0
2020-07-20 08:00:00	NQ	Futures	12323.92	12347.92	12311.2	12338.09	13589.0
2020-07-20 09:00:00	NQ	Futures	12338.38	12371.06	12267.82	12355.73	76238.0
2020-07-20 10:00:00	NQ	Futures	12356.6	12465.04	12342.72	12439.3	81967.0
2020-07-20 11:00:00	NQ	Futures	12440.17	12506.39	12430.34	12498.87	44637.0
2020-07-20 12:00:00	NQ	Futures	12498.59	12532.42	12476.03	12528.66	37857.0
2020-07-20 13:00:00	NQ	Futures	12528.95	12565.96	12523.17	12545.43	31785.0
2020-07-20 14:00:00	NQ	Futures	12545.72	12601.53	12542.25	12597.77	31893.0
2020-07-20 15:00:00	NQ	Futures	12598.06	12682.79	12594.01	12650.4	67581.0
2020-07-20 16:00:00	NQ	Futures	12650.12	12671.23	12648.09	12663.13	11141.0
2020-07-20 18:00:00	NQ	Futures	12668.62	12693.49	12645.78	12653.87	3731.0
2020-07-20 19:00:00	NQ	Futures	12654.16	12676.43	12649.83	12665.15	2913.0
2020-07-20 20:00:00	NQ	Futures	12665.73	12715.76	12657.63	12710.26	8028.0
2020-07-20 21:00:00	NQ	Futures	12709.98	12734.84	12696.96	12706.22	9580.0
2020-07-20 22:00:00	NQ	Futures	12706.5	12724.43	12703.03	12718.07	5018.0
2020-07-20 23:00:00	NQ	Futures	12717.49	12740.63	12705.35	12738.6	4001.0
2020-07-20 00:00:00	YM	Futures	29118.5	29124.1	29077.8	29095.4	1763.0
2020-07-20 01:00:00	YM	Futures	29095.4	29121.8	29064.6	29115.2	2265.0
2020-07-20 02:00:00	YM	Futures	29117.4	29124.1	29030.5	29073.4	2711.0
2020-07-20 03:00:00	YM	Futures	29070.1	29074.5	28993.0	29065.7	6340.0

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

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