PREVIEW / futures_1hour / 2021-04-21

all futures 1-hour files

  file:    by_date/futures_1hour/2021/2021-04-21.parquet
  size:    63 KB
  rows:    1,931

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-21 00:00:00	ES	Futures	4629.53	4631.5	4627.28	4629.81	5543.0
2021-04-21 01:00:00	ES	Futures	4630.09	4630.94	4624.76	4629.53	7154.0
2021-04-21 02:00:00	ES	Futures	4629.53	4639.37	4628.13	4638.24	12935.0
2021-04-21 03:00:00	ES	Futures	4637.96	4641.61	4635.99	4641.33	23302.0
2021-04-21 04:00:00	ES	Futures	4641.05	4641.61	4635.15	4636.56	13131.0
2021-04-21 05:00:00	ES	Futures	4636.56	4639.65	4632.06	4635.71	13274.0
2021-04-21 06:00:00	ES	Futures	4635.99	4643.86	4633.18	4643.86	16020.0
2021-04-21 07:00:00	ES	Futures	4644.14	4644.14	4635.15	4636.27	16445.0
2021-04-21 08:00:00	ES	Futures	4636.27	4636.84	4624.47	4628.97	30504.0
2021-04-21 09:00:00	ES	Futures	4628.97	4651.17	4627.28	4650.89	266694.0
2021-04-21 10:00:00	ES	Futures	4651.17	4658.75	4646.11	4654.82	270722.0
2021-04-21 11:00:00	ES	Futures	4655.1	4668.02	4652.85	4667.46	164522.0
2021-04-21 12:00:00	ES	Futures	4667.74	4668.02	4661.56	4662.97	88322.0
2021-04-21 13:00:00	ES	Futures	4662.97	4668.02	4662.41	4667.74	79270.0
2021-04-21 14:00:00	ES	Futures	4667.74	4671.68	4666.06	4668.31	93719.0
2021-04-21 15:00:00	ES	Futures	4668.02	4683.48	4666.62	4680.67	260990.0
2021-04-21 16:00:00	ES	Futures	4680.95	4680.95	4671.4	4671.68	54598.0
2021-04-21 18:00:00	ES	Futures	4672.52	4673.92	4669.43	4670.83	5120.0
2021-04-21 19:00:00	ES	Futures	4670.55	4673.08	4668.87	4669.43	6058.0
2021-04-21 20:00:00	ES	Futures	4669.43	4672.52	4668.02	4670.55	8520.0
2021-04-21 21:00:00	ES	Futures	4670.27	4675.61	4668.59	4670.27	11658.0
2021-04-21 22:00:00	ES	Futures	4670.55	4678.14	4669.99	4675.33	8809.0
2021-04-21 23:00:00	ES	Futures	4675.05	4677.3	4673.08	4674.49	4444.0
2021-04-21 00:00:00	NQ	Futures	15906.61	15916.16	15903.71	15911.24	2133.0
2021-04-21 01:00:00	NQ	Futures	15912.11	15917.61	15893.29	15903.71	2931.0
2021-04-21 02:00:00	NQ	Futures	15903.42	15949.74	15901.4	15943.37	6364.0
2021-04-21 03:00:00	NQ	Futures	15942.79	15953.51	15914.42	15940.19	10162.0
2021-04-21 04:00:00	NQ	Futures	15939.61	15942.79	15918.48	15930.06	6243.0
2021-04-21 05:00:00	NQ	Futures	15930.06	15958.14	15919.92	15938.45	7551.0
2021-04-21 06:00:00	NQ	Futures	15939.03	15966.53	15928.03	15965.09	6616.0
2021-04-21 07:00:00	NQ	Futures	15966.53	15966.82	15931.5	15937.58	5250.0
2021-04-21 08:00:00	NQ	Futures	15937.58	15940.48	15891.84	15924.56	11952.0
2021-04-21 09:00:00	NQ	Futures	15923.69	15985.93	15864.92	15982.17	93330.0
2021-04-21 10:00:00	NQ	Futures	15982.46	16005.04	15932.66	15960.74	97988.0
2021-04-21 11:00:00	NQ	Futures	15961.32	16068.73	15952.93	16064.09	64866.0
2021-04-21 12:00:00	NQ	Futures	16064.38	16066.41	16018.06	16023.56	34776.0
2021-04-21 13:00:00	NQ	Futures	16023.85	16058.59	16020.96	16048.75	28794.0
2021-04-21 14:00:00	NQ	Futures	16049.04	16064.67	16034.56	16044.41	28106.0
2021-04-21 15:00:00	NQ	Futures	16044.12	16126.62	16033.7	16117.65	56823.0
2021-04-21 16:00:00	NQ	Futures	16117.36	16117.94	16081.75	16085.81	11889.0
2021-04-21 18:00:00	NQ	Futures	16091.88	16096.52	16075.09	16083.78	2812.0
2021-04-21 19:00:00	NQ	Futures	16084.07	16089.86	16070.46	16076.83	3559.0
2021-04-21 20:00:00	NQ	Futures	16077.41	16089.57	16070.46	16082.33	4194.0
2021-04-21 21:00:00	NQ	Futures	16081.46	16105.49	16079.15	16088.7	5520.0
2021-04-21 22:00:00	NQ	Futures	16088.12	16113.02	16086.96	16093.62	3400.0
2021-04-21 23:00:00	NQ	Futures	16095.07	16104.62	16094.2	16098.83	1606.0
2021-04-21 00:00:00	YM	Futures	37503.4	37520.1	37476.6	37496.7	1129.0
2021-04-21 01:00:00	YM	Futures	37496.7	37510.1	37452.1	37494.5	2150.0
2021-04-21 02:00:00	YM	Futures	37494.5	37565.8	37483.3	37553.5	3023.0
2021-04-21 03:00:00	YM	Futures	37552.4	37590.3	37541.2	37582.5	4605.0

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

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