PREVIEW / futures_1hour / 2020-11-09

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-11-09.parquet
  size:    67 KB
  rows:    1,962

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
2020-11-09 00:00:00	ES	Futures	3989.95	3994.99	3982.94	3985.74	12922.0
2020-11-09 01:00:00	ES	Futures	3985.46	3985.46	3977.06	3979.3	11092.0
2020-11-09 02:00:00	ES	Futures	3979.3	3986.02	3974.26	3977.62	17919.0
2020-11-09 03:00:00	ES	Futures	3977.34	3984.06	3972.02	3979.86	31919.0
2020-11-09 04:00:00	ES	Futures	3979.86	3986.87	3973.14	3977.62	23183.0
2020-11-09 05:00:00	ES	Futures	3977.34	3984.34	3973.7	3983.22	15693.0
2020-11-09 06:00:00	ES	Futures	3983.22	4090.78	3977.06	4071.45	125925.0
2020-11-09 07:00:00	ES	Futures	4071.17	4086.02	4042.32	4085.74	161789.0
2020-11-09 08:00:00	ES	Futures	4085.74	4109.55	4072.29	4091.62	107310.0
2020-11-09 09:00:00	ES	Futures	4091.9	4101.98	4038.96	4040.64	308260.0
2020-11-09 10:00:00	ES	Futures	4040.64	4068.65	4023.0	4038.68	378425.0
2020-11-09 11:00:00	ES	Futures	4038.96	4042.04	4019.92	4030.84	262175.0
2020-11-09 12:00:00	ES	Futures	4031.12	4054.09	4028.04	4051.29	221138.0
2020-11-09 13:00:00	ES	Futures	4051.57	4058.85	4042.6	4047.37	102984.0
2020-11-09 14:00:00	ES	Futures	4047.37	4049.33	4022.16	4030.84	151815.0
2020-11-09 15:00:00	ES	Futures	4030.84	4038.68	3967.54	3973.42	390465.0
2020-11-09 16:00:00	ES	Futures	3973.42	3985.74	3967.82	3973.98	100575.0
2020-11-09 18:00:00	ES	Futures	3976.78	3991.63	3973.98	3975.38	19979.0
2020-11-09 19:00:00	ES	Futures	3975.94	3980.7	3956.33	3966.14	27926.0
2020-11-09 20:00:00	ES	Futures	3966.14	3978.74	3962.78	3974.26	17493.0
2020-11-09 21:00:00	ES	Futures	3974.54	3980.7	3946.25	3947.09	21789.0
2020-11-09 22:00:00	ES	Futures	3947.09	3954.37	3934.77	3941.77	26020.0
2020-11-09 23:00:00	ES	Futures	3942.05	3946.81	3933.93	3937.85	20987.0
2020-11-09 00:00:00	NQ	Futures	14350.12	14362.28	14321.17	14336.52	5486.0
2020-11-09 01:00:00	NQ	Futures	14336.23	14339.7	14252.57	14285.86	10127.0
2020-11-09 02:00:00	NQ	Futures	14287.02	14303.81	14229.12	14269.36	7770.0
2020-11-09 03:00:00	NQ	Futures	14268.49	14295.99	14237.23	14276.31	9576.0
2020-11-09 04:00:00	NQ	Futures	14277.46	14280.07	14194.97	14220.73	10209.0
2020-11-09 05:00:00	NQ	Futures	14222.47	14260.39	14214.07	14253.44	5731.0
2020-11-09 06:00:00	NQ	Futures	14254.02	14338.54	14185.41	14235.49	22761.0
2020-11-09 07:00:00	NQ	Futures	14236.65	14239.25	13824.16	14029.39	62130.0
2020-11-09 08:00:00	NQ	Futures	14029.68	14228.54	13977.0	14083.81	47302.0
2020-11-09 09:00:00	NQ	Futures	14083.52	14145.76	13943.13	14024.76	90428.0
2020-11-09 10:00:00	NQ	Futures	14024.18	14196.12	14017.81	14081.2	88598.0
2020-11-09 11:00:00	NQ	Futures	14080.63	14110.15	13981.34	14026.78	65706.0
2020-11-09 12:00:00	NQ	Futures	14026.78	14054.28	13970.92	14032.0	55420.0
2020-11-09 13:00:00	NQ	Futures	14032.0	14065.57	13959.63	13985.68	33310.0
2020-11-09 14:00:00	NQ	Futures	13984.52	13996.39	13863.23	13902.6	50796.0
2020-11-09 15:00:00	NQ	Futures	13903.18	13947.76	13677.11	13692.74	73848.0
2020-11-09 16:00:00	NQ	Futures	13693.03	13746.87	13687.24	13716.76	19363.0
2020-11-09 18:00:00	NQ	Futures	13736.45	13780.45	13721.11	13726.32	7539.0
2020-11-09 19:00:00	NQ	Futures	13727.18	13737.03	13651.63	13699.69	11091.0
2020-11-09 20:00:00	NQ	Futures	13700.26	13771.47	13688.4	13744.84	7877.0
2020-11-09 21:00:00	NQ	Futures	13745.13	13770.89	13607.34	13624.42	10498.0
2020-11-09 22:00:00	NQ	Futures	13624.13	13652.21	13525.43	13568.27	12824.0
2020-11-09 23:00:00	NQ	Futures	13568.27	13623.84	13559.29	13581.87	9672.0
2020-11-09 00:00:00	YM	Futures	31609.7	31653.9	31558.8	31580.9	2652.0
2020-11-09 01:00:00	YM	Futures	31582.0	31588.7	31540.0	31566.5	2491.0
2020-11-09 02:00:00	YM	Futures	31567.6	31641.7	31543.3	31566.5	4836.0
2020-11-09 03:00:00	YM	Futures	31566.5	31617.4	31532.3	31573.2	7204.0

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

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