PREVIEW / futures_1hour / 2022-09-12

all futures 1-hour files

  file:    by_date/futures_1hour/2022/2022-09-12.parquet
  size:    64 KB
  rows:    1,943

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-09-12 00:00:00	ES	Futures	4607.13	4608.54	4602.88	4605.71	2729.0
2022-09-12 01:00:00	ES	Futures	4605.71	4613.93	4605.71	4613.93	2865.0
2022-09-12 02:00:00	ES	Futures	4613.93	4619.87	4604.86	4619.02	6249.0
2022-09-12 03:00:00	ES	Futures	4618.74	4628.37	4615.06	4624.12	11108.0
2022-09-12 04:00:00	ES	Futures	4624.12	4639.42	4620.72	4638.85	10043.0
2022-09-12 05:00:00	ES	Futures	4638.85	4642.25	4632.06	4632.34	7204.0
2022-09-12 06:00:00	ES	Futures	4632.34	4633.76	4626.96	4628.94	7007.0
2022-09-12 07:00:00	ES	Futures	4628.94	4636.87	4625.82	4635.45	10017.0
2022-09-12 08:00:00	ES	Futures	4635.17	4636.02	4620.16	4629.79	16873.0
2022-09-12 09:00:00	ES	Futures	4629.79	4659.82	4625.54	4659.25	82680.0
2022-09-12 10:00:00	ES	Futures	4659.53	4668.03	4651.32	4653.87	102195.0
2022-09-12 11:00:00	ES	Futures	4653.87	4661.52	4632.06	4638.85	75913.0
2022-09-12 12:00:00	ES	Futures	4638.57	4650.75	4630.07	4650.47	83415.0
2022-09-12 13:00:00	ES	Futures	4650.47	4659.82	4641.69	4658.12	43750.0
2022-09-12 14:00:00	ES	Futures	4658.12	4658.97	4641.12	4651.03	46229.0
2022-09-12 15:00:00	ES	Futures	4651.03	4660.38	4645.09	4658.4	88018.0
2022-09-12 16:00:00	ES	Futures	4658.4	4667.18	4657.55	4666.33	22662.0
2022-09-12 18:00:00	ES	Futures	4666.33	4670.01	4660.95	4662.65	1906.0
2022-09-12 19:00:00	ES	Futures	4662.93	4665.48	4662.08	4662.93	2591.0
2022-09-12 20:00:00	ES	Futures	4662.93	4666.61	4660.1	4663.22	3041.0
2022-09-12 21:00:00	ES	Futures	4662.93	4664.91	4656.7	4660.1	2655.0
2022-09-12 22:00:00	ES	Futures	4660.1	4664.07	4656.13	4663.78	2437.0
2022-09-12 23:00:00	ES	Futures	4663.5	4665.48	4660.38	4660.95	1442.0
2022-09-12 00:00:00	NQ	Futures	14560.29	14567.52	14546.7	14556.53	2224.0
2022-09-12 01:00:00	NQ	Futures	14556.82	14586.33	14555.96	14586.33	2782.0
2022-09-12 02:00:00	NQ	Futures	14586.33	14627.98	14556.82	14622.19	6148.0
2022-09-12 03:00:00	NQ	Futures	14621.61	14656.32	14601.65	14633.76	8767.0
2022-09-12 04:00:00	NQ	Futures	14633.18	14678.59	14610.33	14675.7	8025.0
2022-09-12 05:00:00	NQ	Futures	14675.41	14689.87	14651.4	14654.3	5465.0
2022-09-12 06:00:00	NQ	Futures	14653.72	14653.72	14627.11	14638.1	4730.0
2022-09-12 07:00:00	NQ	Futures	14637.23	14673.68	14626.24	14665.87	5923.0
2022-09-12 08:00:00	NQ	Futures	14665.58	14668.76	14589.51	14627.69	10280.0
2022-09-12 09:00:00	NQ	Futures	14627.69	14737.89	14611.49	14735.57	35703.0
2022-09-12 10:00:00	NQ	Futures	14735.57	14758.42	14686.4	14697.1	48217.0
2022-09-12 11:00:00	NQ	Futures	14697.39	14738.46	14627.4	14649.09	40871.0
2022-09-12 12:00:00	NQ	Futures	14649.96	14713.01	14621.32	14709.54	35712.0
2022-09-12 13:00:00	NQ	Futures	14709.54	14744.83	14674.25	14737.6	22266.0
2022-09-12 14:00:00	NQ	Futures	14737.89	14741.36	14670.78	14707.81	24827.0
2022-09-12 15:00:00	NQ	Futures	14707.81	14744.54	14694.79	14742.51	23889.0
2022-09-12 16:00:00	NQ	Futures	14742.23	14778.67	14738.75	14775.78	6673.0
2022-09-12 18:00:00	NQ	Futures	14773.75	14781.27	14754.37	14765.65	1516.0
2022-09-12 19:00:00	NQ	Futures	14765.65	14774.62	14760.45	14765.94	1240.0
2022-09-12 20:00:00	NQ	Futures	14766.23	14775.49	14751.19	14761.03	3011.0
2022-09-12 21:00:00	NQ	Futures	14760.16	14769.99	14742.23	14752.35	3017.0
2022-09-12 22:00:00	NQ	Futures	14752.06	14764.5	14735.86	14762.76	3161.0
2022-09-12 23:00:00	NQ	Futures	14762.76	14767.97	14752.64	14755.53	1402.0
2022-09-12 00:00:00	YM	Futures	36205.5	36211.1	36175.2	36194.3	323.0
2022-09-12 01:00:00	YM	Futures	36194.3	36239.2	36193.2	36236.9	587.0
2022-09-12 02:00:00	YM	Futures	36239.2	36259.4	36178.6	36259.4	1096.0
2022-09-12 03:00:00	YM	Futures	36256.0	36323.3	36232.4	36296.4	1951.0

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

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