PREVIEW / futures_1hour / 2021-05-03

all futures 1-hour files

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

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-05-03 00:00:00	ES	Futures	4707.08	4707.08	4704.55	4706.24	1786.0
2021-05-03 01:00:00	ES	Futures	4706.52	4706.52	4701.18	4702.02	3343.0
2021-05-03 02:00:00	ES	Futures	4702.02	4707.36	4700.62	4707.08	5329.0
2021-05-03 03:00:00	ES	Futures	4706.8	4719.72	4706.8	4716.07	18039.0
2021-05-03 04:00:00	ES	Futures	4716.35	4716.63	4711.57	4713.26	10567.0
2021-05-03 05:00:00	ES	Futures	4713.26	4714.1	4701.18	4706.52	14590.0
2021-05-03 06:00:00	ES	Futures	4706.52	4718.04	4705.96	4713.82	12942.0
2021-05-03 07:00:00	ES	Futures	4713.54	4718.88	4713.54	4714.95	15440.0
2021-05-03 08:00:00	ES	Futures	4714.67	4718.04	4711.57	4711.57	27410.0
2021-05-03 09:00:00	ES	Futures	4711.57	4723.09	4709.05	4719.16	157469.0
2021-05-03 10:00:00	ES	Futures	4718.6	4721.97	4709.05	4711.29	225811.0
2021-05-03 11:00:00	ES	Futures	4711.29	4713.26	4703.99	4711.29	170828.0
2021-05-03 12:00:00	ES	Futures	4711.29	4711.57	4703.99	4707.64	84511.0
2021-05-03 13:00:00	ES	Futures	4707.64	4710.45	4705.39	4708.76	61639.0
2021-05-03 14:00:00	ES	Futures	4709.05	4716.63	4708.76	4714.95	86119.0
2021-05-03 15:00:00	ES	Futures	4714.67	4715.23	4698.93	4704.83	217198.0
2021-05-03 16:00:00	ES	Futures	4704.55	4705.39	4700.05	4701.74	49204.0
2021-05-03 18:00:00	ES	Futures	4702.58	4703.99	4700.62	4701.74	4202.0
2021-05-03 19:00:00	ES	Futures	4701.74	4702.02	4696.4	4697.81	6547.0
2021-05-03 20:00:00	ES	Futures	4697.53	4699.77	4694.44	4696.4	7395.0
2021-05-03 21:00:00	ES	Futures	4696.4	4696.68	4689.1	4689.66	11824.0
2021-05-03 22:00:00	ES	Futures	4689.94	4692.47	4687.69	4691.91	5525.0
2021-05-03 23:00:00	ES	Futures	4691.91	4693.03	4688.54	4691.91	4698.0
2021-05-03 00:00:00	NQ	Futures	16069.01	16069.3	16056.57	16060.62	1486.0
2021-05-03 01:00:00	NQ	Futures	16060.62	16061.78	16044.99	16049.91	1642.0
2021-05-03 02:00:00	NQ	Futures	16050.49	16073.07	16044.99	16069.88	2313.0
2021-05-03 03:00:00	NQ	Futures	16069.88	16112.73	16069.3	16091.31	7863.0
2021-05-03 04:00:00	NQ	Futures	16091.88	16097.1	16066.99	16068.15	4978.0
2021-05-03 05:00:00	NQ	Futures	16068.15	16072.2	16031.67	16050.49	7046.0
2021-05-03 06:00:00	NQ	Futures	16050.49	16087.83	16048.17	16068.15	6855.0
2021-05-03 07:00:00	NQ	Futures	16069.01	16095.94	16068.73	16084.07	8443.0
2021-05-03 08:00:00	NQ	Futures	16083.2	16111.57	16078.57	16095.65	11243.0
2021-05-03 09:00:00	NQ	Futures	16095.36	16114.75	16039.2	16066.7	60107.0
2021-05-03 10:00:00	NQ	Futures	16065.83	16150.94	16023.56	16034.56	96340.0
2021-05-03 11:00:00	NQ	Futures	16035.43	16035.43	15952.06	15995.77	82544.0
2021-05-03 12:00:00	NQ	Futures	15995.77	16005.04	15947.72	15969.72	42091.0
2021-05-03 13:00:00	NQ	Futures	15970.01	15991.72	15949.45	15974.35	32723.0
2021-05-03 14:00:00	NQ	Futures	15974.06	16003.88	15973.48	15995.19	30874.0
2021-05-03 15:00:00	NQ	Futures	15994.9	16002.43	15950.03	15969.14	48306.0
2021-05-03 16:00:00	NQ	Futures	15969.14	15976.38	15955.82	15962.77	7374.0
2021-05-03 18:00:00	NQ	Futures	15962.77	15971.45	15954.95	15963.35	2142.0
2021-05-03 19:00:00	NQ	Futures	15962.77	15964.8	15936.14	15944.82	3188.0
2021-05-03 20:00:00	NQ	Futures	15944.53	15954.09	15922.24	15927.16	4319.0
2021-05-03 21:00:00	NQ	Futures	15927.45	15927.45	15890.98	15902.84	5951.0
2021-05-03 22:00:00	NQ	Futures	15902.27	15915.29	15898.21	15914.71	2547.0
2021-05-03 23:00:00	NQ	Futures	15914.42	15916.74	15901.11	15911.82	1970.0
2021-05-03 00:00:00	YM	Futures	37755.1	37758.4	37732.8	37755.1	699.0
2021-05-03 01:00:00	YM	Futures	37756.2	37757.3	37711.7	37716.1	1045.0
2021-05-03 02:00:00	YM	Futures	37716.1	37747.3	37705.0	37744.0	1113.0
2021-05-03 03:00:00	YM	Futures	37744.0	37843.1	37740.6	37829.7	4679.0

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

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