PREVIEW / futures_1hour / 2022-05-06

all futures 1-hour files

  file:    by_date/futures_1hour/2022/2022-05-06.parquet
  size:    59 KB
  rows:    1,685

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
2022-05-06 00:00:00	ES	Futures	4699.72	4701.42	4690.09	4694.34	6598.0
2022-05-06 01:00:00	ES	Futures	4694.05	4695.19	4687.25	4694.34	8602.0
2022-05-06 02:00:00	ES	Futures	4694.62	4701.99	4688.67	4689.8	13400.0
2022-05-06 03:00:00	ES	Futures	4689.8	4689.8	4662.87	4682.72	33012.0
2022-05-06 04:00:00	ES	Futures	4682.72	4700.01	4675.35	4679.31	26247.0
2022-05-06 05:00:00	ES	Futures	4679.31	4689.8	4669.39	4688.38	18346.0
2022-05-06 06:00:00	ES	Futures	4688.67	4691.5	4676.48	4681.3	13361.0
2022-05-06 07:00:00	ES	Futures	4681.58	4681.87	4661.74	4674.78	21724.0
2022-05-06 08:00:00	ES	Futures	4674.5	4707.94	4661.17	4663.16	88283.0
2022-05-06 09:00:00	ES	Futures	4663.44	4674.78	4605.34	4612.99	306041.0
2022-05-06 10:00:00	ES	Futures	4612.71	4693.2	4605.62	4684.98	418016.0
2022-05-06 11:00:00	ES	Futures	4684.7	4708.79	4648.42	4652.39	245384.0
2022-05-06 12:00:00	ES	Futures	4652.39	4699.16	4648.42	4696.89	201573.0
2022-05-06 13:00:00	ES	Futures	4696.89	4703.69	4651.54	4655.22	165988.0
2022-05-06 14:00:00	ES	Futures	4654.94	4662.31	4628.58	4641.33	187928.0
2022-05-06 15:00:00	ES	Futures	4641.33	4688.1	4623.48	4669.96	341818.0
2022-05-06 16:00:00	ES	Futures	4669.96	4671.94	4651.82	4660.61	62620.0
2022-05-06 00:00:00	NQ	Futures	14929.66	14933.13	14878.62	14893.99	3311.0
2022-05-06 01:00:00	NQ	Futures	14895.44	14907.04	14873.11	14899.5	3308.0
2022-05-06 02:00:00	NQ	Futures	14901.24	14944.73	14878.91	14884.13	7122.0
2022-05-06 03:00:00	NQ	Futures	14883.26	14885.0	14786.41	14864.99	16085.0
2022-05-06 04:00:00	NQ	Futures	14864.7	14923.86	14831.06	14836.28	13790.0
2022-05-06 05:00:00	NQ	Futures	14835.12	14872.82	14804.68	14865.86	9131.0
2022-05-06 06:00:00	NQ	Futures	14866.73	14877.75	14818.3	14838.02	7016.0
2022-05-06 07:00:00	NQ	Futures	14838.02	14840.34	14762.05	14817.14	12865.0
2022-05-06 08:00:00	NQ	Futures	14817.14	14956.62	14749.58	14758.28	40571.0
2022-05-06 09:00:00	NQ	Futures	14759.15	14838.31	14520.79	14557.04	117449.0
2022-05-06 10:00:00	NQ	Futures	14557.33	14925.6	14548.05	14893.12	169218.0
2022-05-06 11:00:00	NQ	Futures	14893.12	14996.06	14728.41	14746.39	98646.0
2022-05-06 12:00:00	NQ	Futures	14745.23	14922.7	14728.99	14919.51	78930.0
2022-05-06 13:00:00	NQ	Futures	14919.22	14935.45	14705.79	14716.23	61978.0
2022-05-06 14:00:00	NQ	Futures	14713.91	14748.42	14620.83	14649.54	64196.0
2022-05-06 15:00:00	NQ	Futures	14650.41	14793.66	14575.6	14722.9	90960.0
2022-05-06 16:00:00	NQ	Futures	14723.77	14736.53	14648.38	14688.4	17146.0
2022-05-06 00:00:00	YM	Futures	37127.5	37142.2	37065.5	37091.4	1261.0
2022-05-06 01:00:00	YM	Futures	37088.1	37102.7	37041.8	37095.9	1435.0
2022-05-06 02:00:00	YM	Futures	37090.3	37151.2	37050.9	37059.9	2711.0
2022-05-06 03:00:00	YM	Futures	37058.7	37058.7	36859.2	36996.7	4725.0
2022-05-06 04:00:00	YM	Futures	36997.9	37121.9	36951.6	36990.0	4385.0
2022-05-06 05:00:00	YM	Futures	36988.8	37074.5	36922.3	37065.5	2669.0
2022-05-06 06:00:00	YM	Futures	37065.5	37093.7	36988.8	37026.1	2087.0
2022-05-06 07:00:00	YM	Futures	37026.1	37028.3	36895.3	36961.8	3366.0
2022-05-06 08:00:00	YM	Futures	36961.8	37163.6	36880.6	36889.6	12027.0
2022-05-06 09:00:00	YM	Futures	36893.0	36956.2	36516.5	36572.9	32679.0
2022-05-06 10:00:00	YM	Futures	36575.1	37063.3	36498.5	36999.0	43452.0
2022-05-06 11:00:00	YM	Futures	36996.7	37160.2	36730.7	36762.3	24580.0
2022-05-06 12:00:00	YM	Futures	36762.3	37089.2	36739.7	37071.1	21598.0
2022-05-06 13:00:00	YM	Futures	37072.3	37117.4	36770.1	36801.7	17937.0
2022-05-06 14:00:00	YM	Futures	36799.5	36854.7	36621.3	36736.3	18074.0
2022-05-06 15:00:00	YM	Futures	36734.1	37102.7	36613.4	36984.3	31337.0

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

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