PREVIEW / futures_1hour / 2021-06-21

all futures 1-hour files

  file:    by_date/futures_1hour/2021/2021-06-21.parquet
  size:    66 KB
  rows:    1,974

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-21 00:00:00	ES	Futures	4653.15	4658.21	4651.18	4657.65	9266.0
2021-06-21 01:00:00	ES	Futures	4657.37	4659.62	4655.4	4659.34	7852.0
2021-06-21 02:00:00	ES	Futures	4659.34	4677.93	4658.78	4670.6	23115.0
2021-06-21 03:00:00	ES	Futures	4670.89	4695.1	4669.48	4691.44	50513.0
2021-06-21 04:00:00	ES	Futures	4691.44	4696.51	4686.09	4695.38	24161.0
2021-06-21 05:00:00	ES	Futures	4695.38	4705.24	4693.98	4700.17	27241.0
2021-06-21 06:00:00	ES	Futures	4700.45	4702.14	4697.07	4699.89	15679.0
2021-06-21 07:00:00	ES	Futures	4700.17	4702.14	4691.72	4698.48	25756.0
2021-06-21 08:00:00	ES	Futures	4698.48	4701.3	4693.69	4700.45	27405.0
2021-06-21 09:00:00	ES	Futures	4700.45	4714.25	4690.88	4712.56	210996.0
2021-06-21 10:00:00	ES	Futures	4712.56	4739.87	4711.43	4737.34	259289.0
2021-06-21 11:00:00	ES	Futures	4737.34	4741.56	4733.12	4738.75	131681.0
2021-06-21 12:00:00	ES	Futures	4739.03	4740.72	4734.81	4735.65	69580.0
2021-06-21 13:00:00	ES	Futures	4735.93	4748.32	4734.52	4745.22	89994.0
2021-06-21 14:00:00	ES	Futures	4745.51	4747.19	4741.0	4744.38	70880.0
2021-06-21 15:00:00	ES	Futures	4744.38	4748.88	4740.72	4746.35	187892.0
2021-06-21 16:00:00	ES	Futures	4746.35	4752.83	4744.66	4751.42	59421.0
2021-06-21 18:00:00	ES	Futures	4752.26	4752.83	4749.17	4749.73	4783.0
2021-06-21 19:00:00	ES	Futures	4749.73	4754.8	4749.17	4750.29	5674.0
2021-06-21 20:00:00	ES	Futures	4750.29	4753.39	4748.32	4749.17	7987.0
2021-06-21 21:00:00	ES	Futures	4748.88	4750.57	4747.19	4748.32	6355.0
2021-06-21 22:00:00	ES	Futures	4748.32	4752.54	4748.04	4751.42	4853.0
2021-06-21 23:00:00	ES	Futures	4751.42	4754.23	4750.86	4753.11	3392.0
2021-06-21 00:00:00	NQ	Futures	16224.76	16235.77	16212.88	16223.31	3757.0
2021-06-21 01:00:00	NQ	Futures	16223.02	16233.74	16212.88	16232.0	3416.0
2021-06-21 02:00:00	NQ	Futures	16232.0	16317.46	16227.36	16286.17	12350.0
2021-06-21 03:00:00	NQ	Futures	16285.59	16353.38	16265.6	16331.07	18695.0
2021-06-21 04:00:00	NQ	Futures	16331.36	16344.11	16298.63	16336.86	12688.0
2021-06-21 05:00:00	NQ	Futures	16336.86	16369.02	16332.23	16351.93	9727.0
2021-06-21 06:00:00	NQ	Futures	16351.35	16355.69	16330.78	16338.89	6425.0
2021-06-21 07:00:00	NQ	Futures	16338.6	16346.42	16293.99	16311.08	11940.0
2021-06-21 08:00:00	NQ	Futures	16311.37	16314.56	16279.8	16301.23	12550.0
2021-06-21 09:00:00	NQ	Futures	16300.36	16305.87	16174.06	16288.49	96867.0
2021-06-21 10:00:00	NQ	Futures	16288.49	16355.4	16237.21	16334.55	86612.0
2021-06-21 11:00:00	NQ	Futures	16334.84	16376.26	16328.75	16354.25	49191.0
2021-06-21 12:00:00	NQ	Futures	16354.82	16369.31	16338.89	16346.42	28293.0
2021-06-21 13:00:00	NQ	Futures	16346.42	16389.01	16334.55	16377.13	28943.0
2021-06-21 14:00:00	NQ	Futures	16377.13	16382.63	16351.93	16369.31	26390.0
2021-06-21 15:00:00	NQ	Futures	16369.6	16379.74	16334.84	16370.76	48370.0
2021-06-21 16:00:00	NQ	Futures	16370.76	16385.53	16368.15	16381.48	8585.0
2021-06-21 18:00:00	NQ	Futures	16380.61	16386.4	16371.05	16375.1	1856.0
2021-06-21 19:00:00	NQ	Futures	16374.81	16394.51	16372.5	16378.29	2659.0
2021-06-21 20:00:00	NQ	Futures	16378.0	16400.59	16374.23	16388.72	4389.0
2021-06-21 21:00:00	NQ	Futures	16387.85	16393.64	16376.55	16379.45	2724.0
2021-06-21 22:00:00	NQ	Futures	16379.45	16388.72	16376.26	16377.71	2109.0
2021-06-21 23:00:00	NQ	Futures	16378.58	16384.95	16376.84	16380.61	1267.0
2021-06-21 00:00:00	YM	Futures	36802.3	36861.5	36781.1	36859.3	2693.0
2021-06-21 01:00:00	YM	Futures	36859.3	36867.1	36833.6	36857.0	1952.0
2021-06-21 02:00:00	YM	Futures	36857.0	37011.2	36849.2	36956.5	7583.0
2021-06-21 03:00:00	YM	Futures	36958.7	37193.3	36940.8	37169.9	11295.0

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

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