PREVIEW / futures_1hour / 2021-04-12

all futures 1-hour files

  file:    by_date/futures_1hour/2021/2021-04-12.parquet
  size:    59 KB
  rows:    1,868

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-04-12 00:00:00	ES	Futures	4617.45	4618.29	4614.64	4614.92	3914.0
2021-04-12 01:00:00	ES	Futures	4615.2	4617.73	4612.95	4615.2	7011.0
2021-04-12 02:00:00	ES	Futures	4615.48	4622.23	4614.08	4620.82	9840.0
2021-04-12 03:00:00	ES	Futures	4621.1	4622.51	4616.33	4618.01	19787.0
2021-04-12 04:00:00	ES	Futures	4617.73	4621.1	4616.33	4619.98	11016.0
2021-04-12 05:00:00	ES	Futures	4619.7	4623.91	4619.42	4623.07	7806.0
2021-04-12 06:00:00	ES	Futures	4623.07	4623.35	4619.42	4620.82	7990.0
2021-04-12 07:00:00	ES	Futures	4620.54	4626.16	4620.54	4622.23	11549.0
2021-04-12 08:00:00	ES	Futures	4622.23	4625.04	4620.54	4623.63	13157.0
2021-04-12 09:00:00	ES	Futures	4623.91	4629.53	4617.45	4622.23	137843.0
2021-04-12 10:00:00	ES	Futures	4622.23	4626.16	4614.64	4620.54	164704.0
2021-04-12 11:00:00	ES	Futures	4620.82	4625.88	4619.14	4625.6	99234.0
2021-04-12 12:00:00	ES	Futures	4625.6	4632.9	4621.66	4631.5	89415.0
2021-04-12 13:00:00	ES	Futures	4631.5	4632.34	4619.7	4621.1	81701.0
2021-04-12 14:00:00	ES	Futures	4621.1	4625.32	4619.7	4622.23	80128.0
2021-04-12 15:00:00	ES	Futures	4621.95	4634.59	4618.57	4631.5	212870.0
2021-04-12 16:00:00	ES	Futures	4631.78	4635.43	4630.37	4633.18	39496.0
2021-04-12 18:00:00	ES	Futures	4633.47	4634.03	4630.66	4631.22	3603.0
2021-04-12 19:00:00	ES	Futures	4631.22	4634.59	4629.81	4632.06	3893.0
2021-04-12 20:00:00	ES	Futures	4632.34	4633.75	4630.09	4631.5	6538.0
2021-04-12 21:00:00	ES	Futures	4631.5	4633.75	4629.53	4630.37	8487.0
2021-04-12 22:00:00	ES	Futures	4630.37	4633.18	4630.37	4632.34	4466.0
2021-04-12 23:00:00	ES	Futures	4632.34	4634.03	4630.09	4630.94	4585.0
2021-04-12 00:00:00	NQ	Futures	15977.53	15979.56	15956.98	15961.32	2249.0
2021-04-12 01:00:00	NQ	Futures	15961.61	15974.93	15951.19	15966.53	3574.0
2021-04-12 02:00:00	NQ	Futures	15966.24	15997.22	15964.8	15992.01	5574.0
2021-04-12 03:00:00	NQ	Futures	15992.59	16004.17	15972.32	15991.43	7630.0
2021-04-12 04:00:00	NQ	Futures	15991.72	16010.54	15981.01	15985.06	6376.0
2021-04-12 05:00:00	NQ	Futures	15984.48	16003.88	15982.75	15996.35	3678.0
2021-04-12 06:00:00	NQ	Futures	15997.22	15997.8	15952.64	15956.11	6070.0
2021-04-12 07:00:00	NQ	Futures	15955.82	15984.77	15954.66	15969.43	6304.0
2021-04-12 08:00:00	NQ	Futures	15969.14	15987.09	15953.8	15974.06	6920.0
2021-04-12 09:00:00	NQ	Futures	15974.06	15992.01	15913.56	15942.79	71779.0
2021-04-12 10:00:00	NQ	Futures	15942.51	15986.51	15901.4	15948.3	79129.0
2021-04-12 11:00:00	NQ	Futures	15948.01	15971.74	15927.16	15959.01	48012.0
2021-04-12 12:00:00	NQ	Futures	15959.3	16001.85	15935.85	15998.96	38252.0
2021-04-12 13:00:00	NQ	Futures	15999.54	16013.43	15953.8	15960.16	34667.0
2021-04-12 14:00:00	NQ	Futures	15960.45	15989.98	15951.48	15960.45	33131.0
2021-04-12 15:00:00	NQ	Futures	15960.74	16011.12	15943.08	15994.04	58066.0
2021-04-12 16:00:00	NQ	Futures	15994.04	16010.25	15992.88	16008.8	6992.0
2021-04-12 18:00:00	NQ	Futures	16009.09	16019.22	15994.9	15996.64	2711.0
2021-04-12 19:00:00	NQ	Futures	15997.22	16011.41	15990.85	16000.11	2212.0
2021-04-12 20:00:00	NQ	Futures	16000.69	16000.98	15983.9	15995.77	3460.0
2021-04-12 21:00:00	NQ	Futures	15995.77	16012.85	15992.3	15995.19	4297.0
2021-04-12 22:00:00	NQ	Futures	15995.48	16014.3	15994.61	16003.88	3028.0
2021-04-12 23:00:00	NQ	Futures	16004.46	16007.64	15981.59	15984.48	2518.0
2021-04-12 00:00:00	YM	Futures	37413.2	37424.3	37393.1	37395.3	930.0
2021-04-12 01:00:00	YM	Futures	37394.2	37413.2	37383.1	37392.0	1396.0
2021-04-12 02:00:00	YM	Futures	37392.0	37438.8	37376.4	37426.5	2407.0
2021-04-12 03:00:00	YM	Futures	37427.6	37434.3	37376.4	37386.4	3697.0

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

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