PREVIEW / futures_1hour / 2021-04-13

all futures 1-hour files

  file:    by_date/futures_1hour/2021/2021-04-13.parquet
  size:    61 KB
  rows:    1,881

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-04-13 00:00:00	ES	Futures	4630.66	4630.66	4626.16	4627.28	5199.0
2021-04-13 01:00:00	ES	Futures	4627.56	4627.56	4623.35	4626.44	8621.0
2021-04-13 02:00:00	ES	Futures	4626.72	4629.25	4624.76	4628.41	7010.0
2021-04-13 03:00:00	ES	Futures	4628.69	4633.18	4628.13	4632.9	13438.0
2021-04-13 04:00:00	ES	Futures	4632.9	4634.31	4630.94	4631.78	9022.0
2021-04-13 05:00:00	ES	Futures	4632.06	4637.96	4630.94	4637.68	8571.0
2021-04-13 06:00:00	ES	Futures	4637.4	4638.24	4625.32	4627.28	16584.0
2021-04-13 07:00:00	ES	Futures	4627.28	4627.28	4609.3	4617.73	65354.0
2021-04-13 08:00:00	ES	Futures	4617.73	4633.18	4615.76	4633.18	43892.0
2021-04-13 09:00:00	ES	Futures	4633.18	4634.59	4625.32	4632.9	145674.0
2021-04-13 10:00:00	ES	Futures	4632.62	4637.68	4632.06	4633.47	129188.0
2021-04-13 11:00:00	ES	Futures	4633.47	4637.68	4632.34	4636.27	96194.0
2021-04-13 12:00:00	ES	Futures	4636.27	4637.4	4630.66	4631.22	65829.0
2021-04-13 13:00:00	ES	Futures	4631.22	4638.24	4630.09	4637.12	70535.0
2021-04-13 14:00:00	ES	Futures	4637.4	4647.79	4636.84	4646.67	95361.0
2021-04-13 15:00:00	ES	Futures	4646.67	4652.57	4643.3	4644.42	196139.0
2021-04-13 16:00:00	ES	Futures	4644.42	4647.51	4643.86	4646.39	32416.0
2021-04-13 18:00:00	ES	Futures	4646.95	4646.95	4643.3	4644.14	3979.0
2021-04-13 19:00:00	ES	Futures	4644.14	4644.14	4641.89	4642.46	3497.0
2021-04-13 20:00:00	ES	Futures	4642.46	4645.83	4641.61	4642.74	9067.0
2021-04-13 21:00:00	ES	Futures	4642.46	4647.51	4641.89	4646.11	9458.0
2021-04-13 22:00:00	ES	Futures	4646.11	4646.95	4642.18	4643.3	5725.0
2021-04-13 23:00:00	ES	Futures	4643.58	4644.42	4642.18	4644.14	3158.0
2021-04-13 00:00:00	NQ	Futures	15984.19	15986.22	15961.32	15970.3	3162.0
2021-04-13 01:00:00	NQ	Futures	15971.17	15972.32	15948.58	15963.93	3914.0
2021-04-13 02:00:00	NQ	Futures	15965.38	15976.96	15954.09	15957.56	3969.0
2021-04-13 03:00:00	NQ	Futures	15958.14	15996.64	15958.14	15993.17	6418.0
2021-04-13 04:00:00	NQ	Futures	15993.17	16000.11	15983.61	15987.09	3811.0
2021-04-13 05:00:00	NQ	Futures	15987.38	16001.56	15977.82	15998.67	2958.0
2021-04-13 06:00:00	NQ	Futures	15998.96	16004.75	15961.03	15976.67	5277.0
2021-04-13 07:00:00	NQ	Futures	15976.67	15990.27	15951.19	15980.43	13253.0
2021-04-13 08:00:00	NQ	Futures	15980.72	16083.2	15977.82	16077.99	28945.0
2021-04-13 09:00:00	NQ	Futures	16078.28	16150.94	16057.43	16143.99	76670.0
2021-04-13 10:00:00	NQ	Futures	16143.99	16152.39	16095.94	16117.94	73732.0
2021-04-13 11:00:00	NQ	Futures	16117.94	16134.44	16077.41	16101.44	60461.0
2021-04-13 12:00:00	NQ	Futures	16101.73	16122.28	16092.46	16100.57	35824.0
2021-04-13 13:00:00	NQ	Futures	16100.57	16152.1	16099.41	16137.05	31404.0
2021-04-13 14:00:00	NQ	Futures	16137.05	16179.31	16126.33	16176.42	39203.0
2021-04-13 15:00:00	NQ	Futures	16176.71	16204.79	16170.63	16183.37	68089.0
2021-04-13 16:00:00	NQ	Futures	16183.08	16191.47	16175.26	16183.37	8317.0
2021-04-13 18:00:00	NQ	Futures	16185.97	16188.58	16173.81	16181.63	2385.0
2021-04-13 19:00:00	NQ	Futures	16181.63	16181.92	16168.89	16173.23	2140.0
2021-04-13 20:00:00	NQ	Futures	16173.52	16184.81	16170.63	16178.15	3149.0
2021-04-13 21:00:00	NQ	Futures	16177.86	16195.52	16172.94	16180.47	4098.0
2021-04-13 22:00:00	NQ	Futures	16180.76	16183.08	16162.52	16172.07	3472.0
2021-04-13 23:00:00	NQ	Futures	16172.65	16179.6	16168.6	16176.42	1386.0
2021-04-13 00:00:00	YM	Futures	37482.2	37486.7	37456.6	37464.4	1237.0
2021-04-13 01:00:00	YM	Futures	37464.4	37468.8	37434.3	37459.9	1459.0
2021-04-13 02:00:00	YM	Futures	37459.9	37485.6	37444.3	37482.2	1638.0
2021-04-13 03:00:00	YM	Futures	37482.2	37508.9	37461.1	37495.6	3471.0

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

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