PREVIEW / futures_1hour / 2020-11-17

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-11-17.parquet
  size:    62 KB
  rows:    1,895

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-11-17 00:00:00	ES	Futures	4042.6	4043.44	4036.44	4036.72	6928.0
2020-11-17 01:00:00	ES	Futures	4037.0	4045.68	4036.44	4044.28	5583.0
2020-11-17 02:00:00	ES	Futures	4044.56	4047.65	4040.92	4045.4	5776.0
2020-11-17 03:00:00	ES	Futures	4045.4	4051.85	4043.16	4045.4	16922.0
2020-11-17 04:00:00	ES	Futures	4045.68	4049.61	4044.28	4046.25	10702.0
2020-11-17 05:00:00	ES	Futures	4045.97	4046.53	4040.64	4042.88	13660.0
2020-11-17 06:00:00	ES	Futures	4042.6	4043.16	4035.6	4039.52	15573.0
2020-11-17 07:00:00	ES	Futures	4039.24	4043.44	4032.24	4034.48	26623.0
2020-11-17 08:00:00	ES	Futures	4034.76	4037.28	4025.52	4032.52	40953.0
2020-11-17 09:00:00	ES	Futures	4032.8	4036.16	4015.71	4016.56	189244.0
2020-11-17 10:00:00	ES	Futures	4016.28	4042.04	4016.28	4040.64	178445.0
2020-11-17 11:00:00	ES	Futures	4040.36	4047.65	4038.12	4043.44	144158.0
2020-11-17 12:00:00	ES	Futures	4043.16	4054.09	4041.76	4049.33	98326.0
2020-11-17 13:00:00	ES	Futures	4049.33	4053.81	4042.88	4045.4	71222.0
2020-11-17 14:00:00	ES	Futures	4045.12	4056.05	4044.84	4051.57	94903.0
2020-11-17 15:00:00	ES	Futures	4051.57	4051.85	4031.4	4041.76	227307.0
2020-11-17 16:00:00	ES	Futures	4041.76	4047.09	4037.0	4037.84	37530.0
2020-11-17 18:00:00	ES	Futures	4038.4	4046.53	4035.32	4044.28	8227.0
2020-11-17 19:00:00	ES	Futures	4044.28	4045.12	4028.6	4032.8	13784.0
2020-11-17 20:00:00	ES	Futures	4032.8	4036.44	4028.32	4029.44	8408.0
2020-11-17 21:00:00	ES	Futures	4029.44	4035.88	4027.76	4035.6	6988.0
2020-11-17 22:00:00	ES	Futures	4035.6	4038.12	4032.24	4036.44	4619.0
2020-11-17 23:00:00	ES	Futures	4036.44	4038.12	4031.68	4033.64	6117.0
2020-11-17 00:00:00	NQ	Futures	13904.34	13907.52	13884.66	13889.87	2945.0
2020-11-17 01:00:00	NQ	Futures	13889.87	13916.21	13889.29	13913.31	2569.0
2020-11-17 02:00:00	NQ	Futures	13912.44	13926.63	13906.08	13922.0	3076.0
2020-11-17 03:00:00	NQ	Futures	13922.29	13949.5	13913.02	13933.87	7214.0
2020-11-17 04:00:00	NQ	Futures	13935.31	13962.23	13933.0	13941.97	5576.0
2020-11-17 05:00:00	NQ	Futures	13943.13	13945.15	13899.13	13916.79	5345.0
2020-11-17 06:00:00	NQ	Futures	13915.92	13943.71	13897.68	13935.89	6080.0
2020-11-17 07:00:00	NQ	Futures	13935.89	13953.84	13924.6	13927.79	7166.0
2020-11-17 08:00:00	NQ	Futures	13928.08	13941.39	13904.34	13931.84	17051.0
2020-11-17 09:00:00	NQ	Futures	13931.55	13942.84	13849.92	13853.1	63677.0
2020-11-17 10:00:00	NQ	Futures	13852.24	13935.89	13851.66	13932.42	53177.0
2020-11-17 11:00:00	NQ	Futures	13932.13	13936.76	13854.55	13893.92	46377.0
2020-11-17 12:00:00	NQ	Futures	13893.34	13920.55	13888.71	13914.18	28265.0
2020-11-17 13:00:00	NQ	Futures	13914.47	13943.71	13895.66	13906.66	34357.0
2020-11-17 14:00:00	NQ	Futures	13906.37	13935.89	13902.6	13908.39	29067.0
2020-11-17 15:00:00	NQ	Futures	13908.39	13911.87	13840.95	13867.87	55895.0
2020-11-17 16:00:00	NQ	Futures	13868.73	13884.37	13854.84	13858.6	6887.0
2020-11-17 18:00:00	NQ	Futures	13862.08	13878.29	13850.79	13871.05	2991.0
2020-11-17 19:00:00	NQ	Futures	13871.63	13874.81	13825.03	13837.76	5476.0
2020-11-17 20:00:00	NQ	Futures	13838.34	13848.76	13826.76	13829.08	4111.0
2020-11-17 21:00:00	NQ	Futures	13828.79	13845.29	13816.63	13841.81	3892.0
2020-11-17 22:00:00	NQ	Futures	13842.39	13856.29	13831.68	13851.37	3004.0
2020-11-17 23:00:00	NQ	Futures	13851.95	13871.34	13849.34	13862.37	3086.0
2020-11-17 00:00:00	YM	Futures	32928.7	32940.8	32884.4	32888.9	1766.0
2020-11-17 01:00:00	YM	Futures	32890.0	32961.8	32886.6	32948.6	2593.0
2020-11-17 02:00:00	YM	Futures	32947.5	32960.7	32911.0	32944.1	2936.0
2020-11-17 03:00:00	YM	Futures	32945.2	33006.1	32930.9	32949.7	4310.0

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

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