PREVIEW / futures_1hour / 2021-06-03

all futures 1-hour files

  file:    by_date/futures_1hour/2021/2021-06-03.parquet
  size:    62 KB
  rows:    1,928

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-06-03 00:00:00	ES	Futures	4730.4	4731.8	4729.28	4729.28	1667.0
2021-06-03 01:00:00	ES	Futures	4729.28	4731.24	4728.43	4730.12	3668.0
2021-06-03 02:00:00	ES	Futures	4729.84	4730.96	4721.69	4725.9	10105.0
2021-06-03 03:00:00	ES	Futures	4725.62	4726.19	4718.04	4719.44	14378.0
2021-06-03 04:00:00	ES	Futures	4719.16	4724.22	4717.47	4722.81	12951.0
2021-06-03 05:00:00	ES	Futures	4722.81	4723.09	4715.23	4717.76	11894.0
2021-06-03 06:00:00	ES	Futures	4717.47	4718.32	4698.09	4701.18	37275.0
2021-06-03 07:00:00	ES	Futures	4700.9	4701.46	4688.25	4692.47	55954.0
2021-06-03 08:00:00	ES	Futures	4692.47	4701.18	4686.01	4696.12	51359.0
2021-06-03 09:00:00	ES	Futures	4696.4	4702.86	4681.23	4690.78	207883.0
2021-06-03 10:00:00	ES	Futures	4690.78	4715.79	4689.38	4715.51	280250.0
2021-06-03 11:00:00	ES	Futures	4715.51	4723.09	4712.42	4716.63	176910.0
2021-06-03 12:00:00	ES	Futures	4716.63	4720.28	4711.01	4718.04	93198.0
2021-06-03 13:00:00	ES	Futures	4718.04	4721.97	4710.45	4717.76	99432.0
2021-06-03 14:00:00	ES	Futures	4717.76	4718.88	4709.05	4709.33	83786.0
2021-06-03 15:00:00	ES	Futures	4709.05	4717.19	4708.76	4709.89	140670.0
2021-06-03 16:00:00	ES	Futures	4709.89	4711.29	4707.64	4710.45	44865.0
2021-06-03 18:00:00	ES	Futures	4709.89	4713.82	4707.36	4710.17	5365.0
2021-06-03 19:00:00	ES	Futures	4710.17	4711.57	4704.27	4705.11	5346.0
2021-06-03 20:00:00	ES	Futures	4705.11	4705.39	4694.44	4700.9	19718.0
2021-06-03 21:00:00	ES	Futures	4700.9	4707.36	4700.05	4704.83	11257.0
2021-06-03 22:00:00	ES	Futures	4704.83	4708.2	4703.43	4706.8	6991.0
2021-06-03 23:00:00	ES	Futures	4706.8	4713.82	4706.52	4712.7	7987.0
2021-06-03 00:00:00	NQ	Futures	15850.45	15855.37	15847.26	15847.55	907.0
2021-06-03 01:00:00	NQ	Futures	15847.55	15861.16	15844.95	15856.24	2242.0
2021-06-03 02:00:00	NQ	Futures	15855.95	15859.42	15810.78	15820.92	5327.0
2021-06-03 03:00:00	NQ	Futures	15822.08	15824.1	15802.97	15812.52	6231.0
2021-06-03 04:00:00	NQ	Futures	15811.36	15828.15	15805.57	15826.13	5262.0
2021-06-03 05:00:00	NQ	Futures	15825.55	15825.55	15784.44	15798.05	5387.0
2021-06-03 06:00:00	NQ	Futures	15798.05	15800.36	15711.78	15723.07	14884.0
2021-06-03 07:00:00	NQ	Futures	15723.36	15726.83	15653.88	15671.54	24301.0
2021-06-03 08:00:00	NQ	Futures	15671.25	15703.38	15645.48	15685.43	20776.0
2021-06-03 09:00:00	NQ	Futures	15685.72	15713.51	15589.03	15629.27	84476.0
2021-06-03 10:00:00	NQ	Futures	15629.27	15724.23	15609.88	15723.94	109550.0
2021-06-03 11:00:00	NQ	Futures	15723.94	15759.54	15664.01	15691.51	76707.0
2021-06-03 12:00:00	NQ	Futures	15691.22	15725.09	15670.67	15724.23	44923.0
2021-06-03 13:00:00	NQ	Futures	15724.23	15741.6	15685.14	15709.75	42759.0
2021-06-03 14:00:00	NQ	Futures	15709.46	15718.73	15669.8	15671.54	30058.0
2021-06-03 15:00:00	NQ	Futures	15671.54	15695.28	15655.33	15665.46	48287.0
2021-06-03 16:00:00	NQ	Futures	15665.17	15674.43	15652.72	15667.77	8836.0
2021-06-03 18:00:00	NQ	Futures	15669.51	15681.09	15651.27	15661.12	3130.0
2021-06-03 19:00:00	NQ	Futures	15660.54	15665.46	15633.9	15636.8	3110.0
2021-06-03 20:00:00	NQ	Futures	15637.38	15637.38	15595.4	15620.59	9062.0
2021-06-03 21:00:00	NQ	Futures	15620.88	15645.77	15618.27	15638.54	5812.0
2021-06-03 22:00:00	NQ	Futures	15637.96	15653.01	15635.06	15646.06	3729.0
2021-06-03 23:00:00	NQ	Futures	15646.64	15670.96	15642.01	15666.91	4165.0
2021-06-03 00:00:00	YM	Futures	38540.3	38549.3	38530.3	38530.3	303.0
2021-06-03 01:00:00	YM	Futures	38530.3	38543.7	38515.8	38530.3	685.0
2021-06-03 02:00:00	YM	Futures	38530.3	38534.8	38475.7	38511.4	2132.0
2021-06-03 03:00:00	YM	Futures	38512.5	38518.1	38442.3	38450.1	2917.0

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

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