PREVIEW / futures_1hour / 2020-04-17

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-04-17.parquet
  size:    51 KB
  rows:    1,489

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-04-17 00:00:00	ES	Futures	3156.31	3161.8	3153.29	3156.04	8010.0
2020-04-17 01:00:00	ES	Futures	3156.31	3165.64	3155.22	3157.69	14849.0
2020-04-17 02:00:00	ES	Futures	3157.96	3159.33	3139.85	3147.26	29426.0
2020-04-17 03:00:00	ES	Futures	3147.26	3155.49	3128.32	3138.2	46176.0
2020-04-17 04:00:00	ES	Futures	3138.2	3152.47	3134.63	3134.91	28849.0
2020-04-17 05:00:00	ES	Futures	3134.91	3150.28	3130.24	3144.79	32641.0
2020-04-17 06:00:00	ES	Futures	3144.79	3155.76	3142.04	3153.57	24425.0
2020-04-17 07:00:00	ES	Futures	3153.29	3158.23	3142.59	3148.63	25707.0
2020-04-17 08:00:00	ES	Futures	3148.36	3152.2	3133.26	3139.03	48842.0
2020-04-17 09:00:00	ES	Futures	3139.03	3141.49	3114.88	3130.24	248610.0
2020-04-17 10:00:00	ES	Futures	3130.24	3132.71	3098.41	3107.47	230793.0
2020-04-17 11:00:00	ES	Futures	3107.19	3114.6	3096.49	3108.84	149857.0
2020-04-17 12:00:00	ES	Futures	3109.11	3121.74	3102.53	3118.17	130741.0
2020-04-17 13:00:00	ES	Futures	3118.17	3123.11	3112.13	3115.7	102373.0
2020-04-17 14:00:00	ES	Futures	3115.7	3115.7	3099.51	3110.76	107725.0
2020-04-17 15:00:00	ES	Futures	3110.49	3151.37	3109.11	3144.24	311478.0
2020-04-17 16:00:00	ES	Futures	3144.24	3153.29	3141.49	3149.18	83507.0
2020-04-17 00:00:00	NQ	Futures	10186.8	10200.51	10175.66	10182.8	3018.0
2020-04-17 01:00:00	NQ	Futures	10183.95	10228.79	10182.23	10206.51	5749.0
2020-04-17 02:00:00	NQ	Futures	10207.37	10211.08	10151.1	10188.52	8609.0
2020-04-17 03:00:00	NQ	Futures	10189.09	10218.51	10121.96	10161.67	13180.0
2020-04-17 04:00:00	NQ	Futures	10161.67	10197.09	10146.24	10159.38	8685.0
2020-04-17 05:00:00	NQ	Futures	10159.38	10202.8	10148.24	10187.94	9516.0
2020-04-17 06:00:00	NQ	Futures	10188.8	10217.94	10181.95	10208.51	6794.0
2020-04-17 07:00:00	NQ	Futures	10207.65	10223.65	10164.24	10175.66	8481.0
2020-04-17 08:00:00	NQ	Futures	10174.81	10188.23	10141.1	10150.81	12212.0
2020-04-17 09:00:00	NQ	Futures	10149.95	10158.52	10013.42	10080.83	71456.0
2020-04-17 10:00:00	NQ	Futures	10080.83	10108.54	9986.28	10016.27	72723.0
2020-04-17 11:00:00	NQ	Futures	10016.27	10037.98	9956.86	9992.0	54593.0
2020-04-17 12:00:00	NQ	Futures	9992.57	10016.27	9959.72	10003.99	37696.0
2020-04-17 13:00:00	NQ	Futures	10003.71	10011.42	9976.0	9982.28	32879.0
2020-04-17 14:00:00	NQ	Futures	9982.85	9983.71	9928.3	9968.86	35654.0
2020-04-17 15:00:00	NQ	Futures	9968.57	10085.4	9964.57	10072.26	57347.0
2020-04-17 16:00:00	NQ	Futures	10072.55	10073.12	10053.12	10068.26	13564.0
2020-04-17 00:00:00	YM	Futures	26549.4	26583.4	26523.1	26543.9	1911.0
2020-04-17 01:00:00	YM	Futures	26546.1	26621.7	26543.9	26561.4	2783.0
2020-04-17 02:00:00	YM	Futures	26562.5	26577.9	26424.5	26470.5	5329.0
2020-04-17 03:00:00	YM	Futures	26470.5	26511.1	26289.8	26349.0	8835.0
2020-04-17 04:00:00	YM	Futures	26352.2	26447.5	26331.4	26336.9	5601.0
2020-04-17 05:00:00	YM	Futures	26336.9	26449.7	26303.0	26400.4	5666.0
2020-04-17 06:00:00	YM	Futures	26401.5	26505.6	26375.2	26494.6	4487.0
2020-04-17 07:00:00	YM	Futures	26494.6	26536.3	26408.1	26458.5	4805.0
2020-04-17 08:00:00	YM	Futures	26457.4	26488.1	26365.4	26402.6	6305.0
2020-04-17 09:00:00	YM	Futures	26399.3	26428.9	26175.9	26251.5	30109.0
2020-04-17 10:00:00	YM	Futures	26250.4	26273.4	25960.1	26049.9	30080.0
2020-04-17 11:00:00	YM	Futures	26042.3	26112.4	25968.9	26076.2	20648.0
2020-04-17 12:00:00	YM	Futures	26079.5	26181.4	26030.2	26156.2	12448.0
2020-04-17 13:00:00	YM	Futures	26155.1	26192.3	26081.7	26126.6	13177.0
2020-04-17 14:00:00	YM	Futures	26126.6	26126.6	26012.7	26101.4	12748.0
2020-04-17 15:00:00	YM	Futures	26101.4	26448.6	26091.6	26412.5	25821.0

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

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