PREVIEW / futures_1hour / 2022-07-29

all futures 1-hour files

  file:    by_date/futures_1hour/2022/2022-07-29.parquet
  size:    57 KB
  rows:    1,638

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-07-29 00:00:00	ES	Futures	4640.55	4645.37	4640.27	4643.1	2905.0
2022-07-29 01:00:00	ES	Futures	4642.82	4650.75	4638.57	4649.33	8302.0
2022-07-29 02:00:00	ES	Futures	4649.05	4653.87	4643.95	4650.47	12078.0
2022-07-29 03:00:00	ES	Futures	4650.18	4655.57	4642.82	4646.5	19668.0
2022-07-29 04:00:00	ES	Futures	4646.5	4652.17	4641.4	4644.8	16624.0
2022-07-29 05:00:00	ES	Futures	4644.8	4651.32	4641.69	4651.03	14918.0
2022-07-29 06:00:00	ES	Futures	4651.32	4654.43	4646.79	4651.6	15847.0
2022-07-29 07:00:00	ES	Futures	4651.32	4652.45	4641.97	4645.09	20662.0
2022-07-29 08:00:00	ES	Futures	4644.8	4647.35	4629.51	4638.0	53397.0
2022-07-29 09:00:00	ES	Futures	4637.72	4655.0	4624.12	4651.88	214874.0
2022-07-29 10:00:00	ES	Futures	4651.88	4672.0	4646.22	4654.15	275025.0
2022-07-29 11:00:00	ES	Futures	4654.15	4658.68	4638.29	4655.85	252552.0
2022-07-29 12:00:00	ES	Futures	4656.13	4669.45	4647.35	4666.33	168906.0
2022-07-29 13:00:00	ES	Futures	4666.61	4674.83	4660.95	4670.86	113169.0
2022-07-29 14:00:00	ES	Futures	4670.86	4683.89	4668.03	4681.91	138490.0
2022-07-29 15:00:00	ES	Futures	4682.19	4695.51	4680.78	4683.89	376603.0
2022-07-29 16:00:00	ES	Futures	4683.89	4686.44	4680.78	4682.48	70285.0
2022-07-29 00:00:00	NQ	Futures	14912.88	14931.39	14910.85	14924.45	2188.0
2022-07-29 01:00:00	NQ	Futures	14923.87	14953.66	14909.69	14949.03	4813.0
2022-07-29 02:00:00	NQ	Futures	14947.3	14971.01	14932.83	14958.29	5712.0
2022-07-29 03:00:00	NQ	Futures	14956.84	14971.01	14919.53	14926.47	9813.0
2022-07-29 04:00:00	NQ	Futures	14927.34	14943.82	14870.94	14893.21	10829.0
2022-07-29 05:00:00	NQ	Futures	14893.21	14920.97	14877.01	14919.24	7091.0
2022-07-29 06:00:00	NQ	Futures	14919.53	14922.42	14894.65	14899.57	6224.0
2022-07-29 07:00:00	NQ	Futures	14899.28	14906.22	14860.52	14881.64	8970.0
2022-07-29 08:00:00	NQ	Futures	14881.93	14886.56	14812.51	14849.82	20813.0
2022-07-29 09:00:00	NQ	Futures	14849.53	14908.25	14744.54	14884.53	97029.0
2022-07-29 10:00:00	NQ	Futures	14883.37	14960.31	14856.19	14881.93	85765.0
2022-07-29 11:00:00	NQ	Futures	14882.22	14889.16	14793.13	14878.46	74016.0
2022-07-29 12:00:00	NQ	Futures	14878.46	14927.34	14848.09	14920.11	45391.0
2022-07-29 13:00:00	NQ	Futures	14920.69	14969.28	14903.62	14953.95	36667.0
2022-07-29 14:00:00	NQ	Futures	14954.24	15007.46	14942.09	14993.0	44549.0
2022-07-29 15:00:00	NQ	Futures	14993.57	15054.31	14987.5	15008.04	80169.0
2022-07-29 16:00:00	NQ	Futures	15007.75	15016.71	14997.33	15013.82	13983.0
2022-07-29 00:00:00	YM	Futures	36668.9	36697.1	36667.8	36675.7	707.0
2022-07-29 01:00:00	YM	Futures	36675.7	36726.5	36646.3	36714.0	1480.0
2022-07-29 02:00:00	YM	Futures	36711.8	36741.1	36676.8	36712.9	2351.0
2022-07-29 03:00:00	YM	Futures	36712.9	36760.3	36685.8	36710.7	3642.0
2022-07-29 04:00:00	YM	Futures	36715.2	36767.1	36708.4	36733.2	4014.0
2022-07-29 05:00:00	YM	Futures	36733.2	36762.6	36699.4	36758.0	3169.0
2022-07-29 06:00:00	YM	Futures	36760.3	36812.2	36736.6	36793.0	3612.0
2022-07-29 07:00:00	YM	Futures	36791.9	36795.3	36720.8	36741.1	3797.0
2022-07-29 08:00:00	YM	Futures	36741.1	36759.2	36649.7	36681.3	7218.0
2022-07-29 09:00:00	YM	Futures	36681.3	36758.0	36623.8	36751.3	26504.0
2022-07-29 10:00:00	YM	Futures	36747.9	36874.3	36709.5	36776.1	23052.0
2022-07-29 11:00:00	YM	Futures	36775.0	36844.9	36697.1	36815.6	16039.0
2022-07-29 12:00:00	YM	Futures	36819.0	36922.8	36747.9	36894.6	11629.0
2022-07-29 13:00:00	YM	Futures	36893.4	36942.0	36837.0	36910.4	9070.0
2022-07-29 14:00:00	YM	Futures	36913.8	37015.3	36888.9	37011.9	11833.0
2022-07-29 15:00:00	YM	Futures	37011.9	37107.8	37002.9	37032.2	21004.0

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

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