PREVIEW / futures_1hour / 2021-01-12

all futures 1-hour files

  file:    by_date/futures_1hour/2021/2021-01-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
2021-01-12 00:00:00	ES	Futures	4255.46	4262.76	4253.78	4261.64	6325.0
2021-01-12 01:00:00	ES	Futures	4261.36	4265.01	4259.11	4263.04	4302.0
2021-01-12 02:00:00	ES	Futures	4263.04	4270.62	4259.67	4265.57	8185.0
2021-01-12 03:00:00	ES	Futures	4265.57	4269.5	4259.39	4263.04	13549.0
2021-01-12 04:00:00	ES	Futures	4263.04	4273.71	4261.92	4268.94	15960.0
2021-01-12 05:00:00	ES	Futures	4269.22	4270.9	4266.69	4267.25	7208.0
2021-01-12 06:00:00	ES	Futures	4267.53	4269.5	4264.16	4266.13	8807.0
2021-01-12 07:00:00	ES	Futures	4266.41	4271.18	4265.01	4267.81	11698.0
2021-01-12 08:00:00	ES	Futures	4267.53	4268.37	4250.41	4255.46	31084.0
2021-01-12 09:00:00	ES	Futures	4255.46	4262.76	4245.36	4257.71	145968.0
2021-01-12 10:00:00	ES	Futures	4257.43	4268.09	4251.53	4261.36	154532.0
2021-01-12 11:00:00	ES	Futures	4261.64	4269.78	4246.76	4251.82	139362.0
2021-01-12 12:00:00	ES	Futures	4251.82	4252.38	4230.2	4248.73	190106.0
2021-01-12 13:00:00	ES	Futures	4248.45	4261.64	4245.92	4258.55	94123.0
2021-01-12 14:00:00	ES	Futures	4258.55	4265.01	4250.13	4256.87	116978.0
2021-01-12 15:00:00	ES	Futures	4257.15	4265.57	4255.18	4257.99	156830.0
2021-01-12 16:00:00	ES	Futures	4257.71	4262.2	4255.46	4257.71	40478.0
2021-01-12 18:00:00	ES	Futures	4257.15	4262.48	4255.46	4262.2	5890.0
2021-01-12 19:00:00	ES	Futures	4262.2	4264.73	4259.67	4260.52	5802.0
2021-01-12 20:00:00	ES	Futures	4260.24	4265.57	4259.11	4265.29	8157.0
2021-01-12 21:00:00	ES	Futures	4265.01	4268.66	4263.32	4266.69	7184.0
2021-01-12 22:00:00	ES	Futures	4266.69	4271.74	4266.13	4271.18	5852.0
2021-01-12 23:00:00	ES	Futures	4271.46	4271.74	4267.81	4268.09	4396.0
2021-01-12 00:00:00	NQ	Futures	14935.65	14957.94	14929.86	14953.59	3213.0
2021-01-12 01:00:00	NQ	Futures	14953.3	14973.28	14948.38	14958.51	3525.0
2021-01-12 02:00:00	NQ	Futures	14960.25	14983.7	14946.36	14977.62	4719.0
2021-01-12 03:00:00	NQ	Futures	14977.04	14991.22	14957.36	14968.93	6371.0
2021-01-12 04:00:00	NQ	Futures	14970.09	15003.09	14968.64	14994.11	6257.0
2021-01-12 05:00:00	NQ	Futures	14994.98	14999.04	14975.59	14987.75	3853.0
2021-01-12 06:00:00	NQ	Futures	14987.46	14993.83	14971.25	14979.35	3768.0
2021-01-12 07:00:00	NQ	Futures	14979.35	14991.8	14974.72	14983.98	5149.0
2021-01-12 08:00:00	NQ	Futures	14984.27	14986.59	14894.84	14915.1	18005.0
2021-01-12 09:00:00	NQ	Futures	14914.81	14990.35	14868.79	14923.78	75500.0
2021-01-12 10:00:00	NQ	Futures	14923.78	14955.91	14894.84	14918.57	68156.0
2021-01-12 11:00:00	NQ	Futures	14918.28	14966.62	14880.37	14899.47	48044.0
2021-01-12 12:00:00	NQ	Futures	14899.18	14904.68	14781.09	14871.39	70026.0
2021-01-12 13:00:00	NQ	Futures	14871.68	14931.6	14863.0	14915.97	34930.0
2021-01-12 14:00:00	NQ	Futures	14916.26	14945.49	14881.52	14907.86	37643.0
2021-01-12 15:00:00	NQ	Futures	14908.44	14948.67	14892.23	14914.23	38690.0
2021-01-12 16:00:00	NQ	Futures	14914.81	14922.62	14905.26	14913.07	7233.0
2021-01-12 18:00:00	NQ	Futures	14914.52	14935.65	14903.23	14930.73	2358.0
2021-01-12 19:00:00	NQ	Futures	14932.47	14938.25	14920.02	14924.94	2189.0
2021-01-12 20:00:00	NQ	Futures	14924.36	14961.41	14920.31	14955.33	3692.0
2021-01-12 21:00:00	NQ	Futures	14955.04	14963.15	14949.54	14953.59	3124.0
2021-01-12 22:00:00	NQ	Futures	14954.46	14975.3	14952.73	14973.28	2591.0
2021-01-12 23:00:00	NQ	Futures	14973.85	14974.14	14957.94	14962.57	2966.0
2021-01-12 00:00:00	YM	Futures	34261.9	34329.6	34246.4	34317.4	1325.0
2021-01-12 01:00:00	YM	Futures	34316.3	34332.9	34291.9	34317.4	809.0
2021-01-12 02:00:00	YM	Futures	34319.6	34385.0	34295.2	34335.1	2441.0
2021-01-12 03:00:00	YM	Futures	34336.2	34368.4	34285.2	34315.2	2440.0

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

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