PREVIEW / futures_1hour / 2020-08-13

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-08-13.parquet
  size:    59 KB
  rows:    1,828

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-08-13 00:00:00	ES	Futures	3762.53	3766.16	3762.53	3764.2	2912.0
2020-08-13 01:00:00	ES	Futures	3764.2	3764.2	3759.46	3760.29	6240.0
2020-08-13 02:00:00	ES	Futures	3760.29	3762.81	3756.1	3761.69	9405.0
2020-08-13 03:00:00	ES	Futures	3761.69	3767.27	3759.73	3762.81	18142.0
2020-08-13 04:00:00	ES	Futures	3762.53	3765.32	3757.5	3762.81	12997.0
2020-08-13 05:00:00	ES	Futures	3762.81	3765.04	3758.62	3759.73	8377.0
2020-08-13 06:00:00	ES	Futures	3759.73	3762.53	3759.18	3760.01	6980.0
2020-08-13 07:00:00	ES	Futures	3760.01	3762.53	3758.06	3758.9	10645.0
2020-08-13 08:00:00	ES	Futures	3759.18	3768.95	3757.5	3765.32	28405.0
2020-08-13 09:00:00	ES	Futures	3765.6	3773.98	3757.22	3773.42	170859.0
2020-08-13 10:00:00	ES	Futures	3773.42	3774.53	3766.16	3772.86	134938.0
2020-08-13 11:00:00	ES	Futures	3772.58	3776.21	3768.95	3771.18	103224.0
2020-08-13 12:00:00	ES	Futures	3771.18	3776.21	3771.18	3775.65	55980.0
2020-08-13 13:00:00	ES	Futures	3775.93	3777.61	3764.2	3770.07	108042.0
2020-08-13 14:00:00	ES	Futures	3770.07	3771.46	3750.24	3755.27	232127.0
2020-08-13 15:00:00	ES	Futures	3755.27	3767.27	3751.64	3761.41	179875.0
2020-08-13 16:00:00	ES	Futures	3761.97	3765.04	3757.22	3763.64	36867.0
2020-08-13 18:00:00	ES	Futures	3763.36	3767.55	3762.81	3767.0	4458.0
2020-08-13 19:00:00	ES	Futures	3767.0	3772.02	3767.0	3770.9	6246.0
2020-08-13 20:00:00	ES	Futures	3770.9	3773.14	3766.16	3767.0	10465.0
2020-08-13 21:00:00	ES	Futures	3767.27	3770.35	3764.2	3768.67	9044.0
2020-08-13 22:00:00	ES	Futures	3768.39	3770.63	3765.88	3767.27	7312.0
2020-08-13 23:00:00	ES	Futures	3767.27	3768.67	3765.04	3767.55	3577.0
2020-08-13 00:00:00	NQ	Futures	12855.14	12866.13	12854.28	12859.19	1026.0
2020-08-13 01:00:00	NQ	Futures	12858.9	12858.9	12841.26	12845.6	2227.0
2020-08-13 02:00:00	NQ	Futures	12845.31	12862.37	12833.17	12860.93	3336.0
2020-08-13 03:00:00	NQ	Futures	12860.93	12895.92	12845.89	12864.69	7061.0
2020-08-13 04:00:00	NQ	Futures	12864.4	12872.78	12834.03	12862.08	4476.0
2020-08-13 05:00:00	NQ	Futures	12860.64	12871.92	12847.62	12852.83	2280.0
2020-08-13 06:00:00	NQ	Futures	12853.12	12866.42	12851.67	12859.48	1806.0
2020-08-13 07:00:00	NQ	Futures	12859.19	12894.47	12859.19	12887.82	4358.0
2020-08-13 08:00:00	NQ	Futures	12887.53	12952.89	12880.88	12944.5	13074.0
2020-08-13 09:00:00	NQ	Futures	12944.5	12989.32	12914.14	12972.84	67282.0
2020-08-13 10:00:00	NQ	Futures	12972.55	13011.88	12928.59	12999.73	51780.0
2020-08-13 11:00:00	NQ	Futures	13000.02	13024.31	12973.71	12993.08	37697.0
2020-08-13 12:00:00	NQ	Futures	12992.79	13026.91	12990.77	13023.16	24754.0
2020-08-13 13:00:00	NQ	Futures	13023.44	13031.54	12932.64	12966.48	44095.0
2020-08-13 14:00:00	NQ	Futures	12966.19	12972.26	12873.36	12898.52	67919.0
2020-08-13 15:00:00	NQ	Futures	12899.39	12954.33	12884.93	12920.5	50789.0
2020-08-13 16:00:00	NQ	Futures	12920.21	12939.0	12905.75	12933.51	6930.0
2020-08-13 18:00:00	NQ	Futures	12932.64	12948.84	12931.2	12946.23	1728.0
2020-08-13 19:00:00	NQ	Futures	12945.66	12969.08	12945.66	12961.85	2332.0
2020-08-13 20:00:00	NQ	Futures	12961.85	12971.97	12941.61	12947.1	2888.0
2020-08-13 21:00:00	NQ	Futures	12945.94	12963.01	12936.98	12957.51	3305.0
2020-08-13 22:00:00	NQ	Futures	12957.51	12968.5	12949.41	12958.38	1853.0
2020-08-13 23:00:00	NQ	Futures	12957.22	12962.72	12947.39	12956.64	1152.0
2020-08-13 00:00:00	YM	Futures	30685.5	30716.3	30684.4	30699.8	695.0
2020-08-13 01:00:00	YM	Futures	30699.8	30699.8	30660.1	30669.0	1441.0
2020-08-13 02:00:00	YM	Futures	30666.7	30689.9	30620.5	30670.1	2323.0
2020-08-13 03:00:00	YM	Futures	30669.0	30705.3	30643.6	30672.3	3341.0

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

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