PREVIEW / futures_1hour / 2021-03-31

all futures 1-hour files

  file:    by_date/futures_1hour/2021/2021-03-31.parquet
  size:    62 KB
  rows:    1,936

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-03-31 00:00:00	ES	Futures	4438.75	4440.16	4434.54	4436.51	4417.0
2021-03-31 01:00:00	ES	Futures	4436.22	4437.63	4432.01	4434.54	8427.0
2021-03-31 02:00:00	ES	Futures	4434.26	4435.66	4429.76	4435.1	9583.0
2021-03-31 03:00:00	ES	Futures	4435.1	4439.32	4432.57	4434.54	13939.0
2021-03-31 04:00:00	ES	Futures	4434.82	4437.63	4431.45	4436.79	10664.0
2021-03-31 05:00:00	ES	Futures	4437.07	4438.75	4434.54	4436.79	9146.0
2021-03-31 06:00:00	ES	Futures	4436.79	4442.13	4436.22	4440.44	14302.0
2021-03-31 07:00:00	ES	Futures	4440.72	4444.09	4439.32	4442.41	13795.0
2021-03-31 08:00:00	ES	Futures	4442.69	4447.18	4441.28	4444.37	23528.0
2021-03-31 09:00:00	ES	Futures	4444.09	4458.98	4443.53	4456.45	187186.0
2021-03-31 10:00:00	ES	Futures	4456.17	4465.73	4454.49	4463.76	192363.0
2021-03-31 11:00:00	ES	Futures	4463.76	4469.38	4460.39	4467.69	157000.0
2021-03-31 12:00:00	ES	Futures	4467.69	4473.31	4467.41	4473.03	88963.0
2021-03-31 13:00:00	ES	Futures	4473.03	4477.25	4471.63	4473.87	92410.0
2021-03-31 14:00:00	ES	Futures	4473.87	4474.44	4467.13	4469.38	120588.0
2021-03-31 15:00:00	ES	Futures	4469.1	4475.0	4456.17	4460.39	451056.0
2021-03-31 16:00:00	ES	Futures	4460.11	4464.88	4454.21	4457.58	119845.0
2021-03-31 18:00:00	ES	Futures	4458.98	4461.79	4457.86	4460.39	6061.0
2021-03-31 19:00:00	ES	Futures	4460.39	4462.92	4457.02	4462.64	7485.0
2021-03-31 20:00:00	ES	Futures	4462.92	4465.73	4459.26	4464.32	12838.0
2021-03-31 21:00:00	ES	Futures	4464.32	4464.88	4458.7	4461.51	8852.0
2021-03-31 22:00:00	ES	Futures	4461.23	4465.45	4455.61	4457.86	8934.0
2021-03-31 23:00:00	ES	Futures	4458.14	4459.83	4456.45	4459.55	5472.0
2021-03-31 00:00:00	NQ	Futures	14924.35	14928.4	14915.95	14920.3	1655.0
2021-03-31 01:00:00	NQ	Futures	14919.43	14921.46	14899.45	14907.56	4068.0
2021-03-31 02:00:00	NQ	Futures	14908.14	14917.11	14891.93	14916.53	4176.0
2021-03-31 03:00:00	NQ	Futures	14917.11	14937.09	14903.22	14931.3	5891.0
2021-03-31 04:00:00	NQ	Futures	14931.88	14948.67	14919.14	14942.88	6435.0
2021-03-31 05:00:00	NQ	Futures	14943.75	14972.7	14927.82	14966.33	5708.0
2021-03-31 06:00:00	NQ	Futures	14965.46	15019.02	14962.85	15005.7	10369.0
2021-03-31 07:00:00	NQ	Futures	15005.41	15006.86	14989.2	14997.3	6010.0
2021-03-31 08:00:00	NQ	Futures	14998.17	15031.17	14992.96	15011.78	11562.0
2021-03-31 09:00:00	NQ	Futures	15011.49	15118.89	14999.33	15113.68	65312.0
2021-03-31 10:00:00	NQ	Futures	15113.97	15200.53	15113.68	15177.08	80722.0
2021-03-31 11:00:00	NQ	Futures	15176.79	15196.77	15158.55	15195.32	50039.0
2021-03-31 12:00:00	NQ	Futures	15195.32	15223.69	15194.45	15206.03	31383.0
2021-03-31 13:00:00	NQ	Futures	15206.03	15230.64	15193.0	15198.79	31875.0
2021-03-31 14:00:00	NQ	Futures	15198.5	15205.45	15157.97	15190.11	40785.0
2021-03-31 15:00:00	NQ	Futures	15189.82	15236.72	15134.81	15151.6	77323.0
2021-03-31 16:00:00	NQ	Futures	15151.89	15174.18	15146.39	15156.82	13202.0
2021-03-31 18:00:00	NQ	Futures	15163.18	15180.55	15158.26	15177.08	2959.0
2021-03-31 19:00:00	NQ	Futures	15177.08	15194.74	15165.21	15194.45	2937.0
2021-03-31 20:00:00	NQ	Futures	15194.45	15203.13	15177.08	15199.08	4697.0
2021-03-31 21:00:00	NQ	Futures	15198.21	15200.24	15174.47	15188.08	4138.0
2021-03-31 22:00:00	NQ	Futures	15187.79	15214.71	15182.29	15190.4	4577.0
2021-03-31 23:00:00	NQ	Futures	15190.98	15198.5	15182.0	15195.9	2276.0
2021-03-31 00:00:00	YM	Futures	36697.0	36710.3	36659.1	36669.1	1056.0
2021-03-31 01:00:00	YM	Futures	36670.2	36690.3	36642.4	36663.6	1617.0
2021-03-31 02:00:00	YM	Futures	36663.6	36666.9	36627.9	36658.0	1937.0
2021-03-31 03:00:00	YM	Futures	36658.0	36695.9	36630.1	36641.3	3029.0

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

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