PREVIEW / futures_1hour / 2021-09-16

all futures 1-hour files

  file:    by_date/futures_1hour/2021/2021-09-16.parquet
  size:    63 KB
  rows:    1,982

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
2021-09-16 00:00:00	ES	Futures	5043.42	5046.24	5042.85	5044.55	4221.0
2021-09-16 01:00:00	ES	Futures	5044.83	5047.09	5040.88	5044.55	8205.0
2021-09-16 02:00:00	ES	Futures	5044.83	5048.22	5042.01	5043.98	6930.0
2021-09-16 03:00:00	ES	Futures	5043.7	5051.04	5043.42	5048.78	16936.0
2021-09-16 04:00:00	ES	Futures	5048.5	5049.91	5044.26	5045.11	12542.0
2021-09-16 05:00:00	ES	Futures	5045.39	5046.24	5038.62	5040.88	14726.0
2021-09-16 06:00:00	ES	Futures	5040.88	5042.85	5039.47	5042.29	8227.0
2021-09-16 07:00:00	ES	Futures	5042.29	5044.55	5036.64	5037.77	12584.0
2021-09-16 08:00:00	ES	Futures	5037.77	5046.24	5030.15	5044.83	56287.0
2021-09-16 09:00:00	ES	Futures	5045.11	5052.73	5024.79	5028.46	215059.0
2021-09-16 10:00:00	ES	Futures	5028.18	5028.18	5004.47	5010.68	273212.0
2021-09-16 11:00:00	ES	Futures	5010.68	5019.15	5007.86	5018.87	139232.0
2021-09-16 12:00:00	ES	Futures	5018.58	5030.44	5015.2	5026.49	88443.0
2021-09-16 13:00:00	ES	Futures	5026.49	5035.23	5019.71	5035.23	89229.0
2021-09-16 14:00:00	ES	Futures	5034.95	5043.98	5031.85	5042.85	100357.0
2021-09-16 15:00:00	ES	Futures	5043.14	5053.3	5038.06	5039.75	228686.0
2021-09-16 16:00:00	ES	Futures	5040.03	5040.6	5033.82	5034.95	43990.0
2021-09-16 18:00:00	ES	Futures	5033.82	5036.93	5033.82	5035.23	3864.0
2021-09-16 19:00:00	ES	Futures	5035.52	5036.36	5029.31	5031.85	5258.0
2021-09-16 20:00:00	ES	Futures	5031.85	5033.26	5028.46	5030.72	7422.0
2021-09-16 21:00:00	ES	Futures	5031.0	5035.8	5025.92	5033.82	12488.0
2021-09-16 22:00:00	ES	Futures	5033.82	5037.77	5033.82	5036.36	6203.0
2021-09-16 23:00:00	ES	Futures	5036.36	5041.72	5035.8	5039.18	6221.0
2021-09-16 00:00:00	NQ	Futures	17946.93	17955.91	17942.58	17950.69	1972.0
2021-09-16 01:00:00	NQ	Futures	17950.12	17962.87	17935.62	17946.93	3212.0
2021-09-16 02:00:00	NQ	Futures	17946.06	17956.49	17928.96	17936.49	3151.0
2021-09-16 03:00:00	NQ	Futures	17936.2	17969.24	17935.91	17959.97	5486.0
2021-09-16 04:00:00	NQ	Futures	17959.39	17964.03	17932.15	17937.36	4858.0
2021-09-16 05:00:00	NQ	Futures	17937.65	17942.29	17912.15	17918.81	4533.0
2021-09-16 06:00:00	NQ	Futures	17918.53	17932.73	17916.21	17930.41	3085.0
2021-09-16 07:00:00	NQ	Futures	17930.7	17939.39	17906.93	17912.73	5411.0
2021-09-16 08:00:00	NQ	Futures	17912.44	17923.45	17890.99	17919.97	16411.0
2021-09-16 09:00:00	NQ	Futures	17920.55	17937.07	17837.96	17863.75	82803.0
2021-09-16 10:00:00	NQ	Futures	17863.17	17871.0	17810.13	17837.09	80643.0
2021-09-16 11:00:00	NQ	Futures	17837.38	17858.24	17804.92	17857.66	49210.0
2021-09-16 12:00:00	NQ	Futures	17857.95	17896.21	17851.0	17888.38	31368.0
2021-09-16 13:00:00	NQ	Futures	17888.38	17938.23	17871.57	17934.18	32681.0
2021-09-16 14:00:00	NQ	Futures	17934.18	17966.92	17923.45	17960.84	34517.0
2021-09-16 15:00:00	NQ	Futures	17961.13	18006.34	17957.65	17980.55	66821.0
2021-09-16 16:00:00	NQ	Futures	17980.55	17982.28	17957.94	17966.34	9143.0
2021-09-16 18:00:00	NQ	Futures	17966.06	17969.53	17957.94	17960.84	1570.0
2021-09-16 19:00:00	NQ	Futures	17960.84	17966.92	17937.65	17946.93	2503.0
2021-09-16 20:00:00	NQ	Futures	17947.22	17950.69	17938.23	17945.48	2374.0
2021-09-16 21:00:00	NQ	Futures	17946.35	17958.23	17927.22	17950.69	4572.0
2021-09-16 22:00:00	NQ	Futures	17950.98	17965.77	17950.98	17964.03	3063.0
2021-09-16 23:00:00	NQ	Futures	17964.32	17990.69	17963.74	17982.86	3524.0
2021-09-16 00:00:00	YM	Futures	38859.6	38887.6	38855.1	38874.2	955.0
2021-09-16 01:00:00	YM	Futures	38874.2	38889.9	38838.3	38866.3	1858.0
2021-09-16 02:00:00	YM	Futures	38864.1	38902.2	38856.3	38877.6	1643.0
2021-09-16 03:00:00	YM	Futures	38874.2	38919.0	38855.1	38893.2	3857.0

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

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