PREVIEW / futures_1hour / 2020-11-30

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-11-30.parquet
  size:    62 KB
  rows:    1,893

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-30 00:00:00	ES	Futures	4055.49	4056.61	4045.12	4049.89	15261.0
2020-11-30 01:00:00	ES	Futures	4049.89	4050.45	4036.44	4038.96	13911.0
2020-11-30 02:00:00	ES	Futures	4038.96	4048.49	4038.4	4048.49	12717.0
2020-11-30 03:00:00	ES	Futures	4048.77	4061.09	4043.72	4057.17	23575.0
2020-11-30 04:00:00	ES	Futures	4057.45	4061.09	4054.65	4059.41	11883.0
2020-11-30 05:00:00	ES	Futures	4059.13	4061.09	4055.77	4059.97	10022.0
2020-11-30 06:00:00	ES	Futures	4059.97	4061.37	4049.33	4057.17	16985.0
2020-11-30 07:00:00	ES	Futures	4057.17	4069.77	4056.61	4064.17	20779.0
2020-11-30 08:00:00	ES	Futures	4064.17	4065.85	4060.53	4065.29	26226.0
2020-11-30 09:00:00	ES	Futures	4065.29	4073.13	4054.93	4059.13	140008.0
2020-11-30 10:00:00	ES	Futures	4059.41	4063.05	4024.68	4044.0	269693.0
2020-11-30 11:00:00	ES	Futures	4043.72	4046.25	4028.32	4037.56	191234.0
2020-11-30 12:00:00	ES	Futures	4037.56	4049.33	4034.48	4048.21	92106.0
2020-11-30 13:00:00	ES	Futures	4048.49	4051.01	4044.0	4045.4	74165.0
2020-11-30 14:00:00	ES	Futures	4045.4	4058.01	4040.92	4057.73	125490.0
2020-11-30 15:00:00	ES	Futures	4058.01	4061.65	4046.53	4056.61	393431.0
2020-11-30 16:00:00	ES	Futures	4056.61	4070.61	4056.61	4069.77	106688.0
2020-11-30 18:00:00	ES	Futures	4068.09	4077.62	4062.49	4077.34	19514.0
2020-11-30 19:00:00	ES	Futures	4077.62	4084.9	4075.66	4083.78	15003.0
2020-11-30 20:00:00	ES	Futures	4084.06	4087.98	4083.22	4087.7	14277.0
2020-11-30 21:00:00	ES	Futures	4087.7	4096.94	4087.14	4093.86	14592.0
2020-11-30 22:00:00	ES	Futures	4093.86	4101.42	4093.3	4094.7	10031.0
2020-11-30 23:00:00	ES	Futures	4094.7	4098.06	4091.9	4092.46	5341.0
2020-11-30 00:00:00	NQ	Futures	14181.65	14186.86	14137.94	14157.91	6441.0
2020-11-30 01:00:00	NQ	Futures	14157.91	14164.86	14118.55	14135.34	5575.0
2020-11-30 02:00:00	NQ	Futures	14136.78	14152.7	14128.1	14150.68	4731.0
2020-11-30 03:00:00	NQ	Futures	14151.26	14201.91	14143.44	14189.18	8597.0
2020-11-30 04:00:00	NQ	Futures	14190.91	14200.18	14171.81	14189.47	4495.0
2020-11-30 05:00:00	NQ	Futures	14188.89	14204.52	14177.02	14200.76	2907.0
2020-11-30 06:00:00	NQ	Futures	14200.76	14205.39	14172.68	14194.1	4530.0
2020-11-30 07:00:00	NQ	Futures	14193.52	14248.81	14189.76	14225.65	9342.0
2020-11-30 08:00:00	NQ	Futures	14225.65	14231.44	14195.83	14212.04	19711.0
2020-11-30 09:00:00	NQ	Futures	14212.33	14241.86	14153.28	14187.15	59632.0
2020-11-30 10:00:00	NQ	Futures	14187.73	14201.62	13994.07	14085.84	99423.0
2020-11-30 11:00:00	NQ	Futures	14086.13	14130.7	14049.65	14117.97	57757.0
2020-11-30 12:00:00	NQ	Futures	14117.68	14151.55	14101.76	14143.44	32184.0
2020-11-30 13:00:00	NQ	Futures	14143.73	14184.83	14135.34	14168.33	28984.0
2020-11-30 14:00:00	NQ	Futures	14168.33	14232.6	14157.62	14230.57	34185.0
2020-11-30 15:00:00	NQ	Futures	14230.86	14236.94	14171.52	14212.04	62213.0
2020-11-30 16:00:00	NQ	Futures	14211.47	14264.15	14210.02	14264.15	16593.0
2020-11-30 18:00:00	NQ	Futures	14283.54	14300.04	14255.75	14300.04	6953.0
2020-11-30 19:00:00	NQ	Futures	14300.04	14318.86	14293.1	14317.7	5038.0
2020-11-30 20:00:00	NQ	Futures	14317.7	14335.94	14316.25	14331.31	4830.0
2020-11-30 21:00:00	NQ	Futures	14330.73	14350.12	14330.15	14336.52	4783.0
2020-11-30 22:00:00	NQ	Futures	14335.94	14359.67	14334.2	14337.67	3602.0
2020-11-30 23:00:00	NQ	Futures	14337.67	14344.04	14324.65	14327.83	2286.0
2020-11-30 00:00:00	YM	Futures	32815.9	32825.8	32755.1	32792.7	3268.0
2020-11-30 01:00:00	YM	Futures	32791.6	32801.5	32611.4	32664.4	5064.0
2020-11-30 02:00:00	YM	Futures	32664.4	32769.5	32655.6	32769.5	3873.0
2020-11-30 03:00:00	YM	Futures	32768.3	32869.0	32717.5	32830.3	5863.0

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

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