PREVIEW / futures_1hour / 2020-05-01

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-05-01.parquet
  size:    44 KB
  rows:    1,249

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-05-01 00:00:00	ES	Futures	3139.85	3146.71	3139.3	3144.24	5652.0
2020-05-01 01:00:00	ES	Futures	3144.24	3145.89	3132.44	3140.67	8851.0
2020-05-01 02:00:00	ES	Futures	3140.95	3140.95	3113.5	3117.35	22667.0
2020-05-01 03:00:00	ES	Futures	3117.62	3123.38	3107.19	3117.62	29397.0
2020-05-01 04:00:00	ES	Futures	3117.62	3129.15	3110.21	3128.05	27788.0
2020-05-01 05:00:00	ES	Futures	3128.32	3129.15	3118.72	3121.19	13623.0
2020-05-01 06:00:00	ES	Futures	3121.19	3129.42	3120.64	3124.48	19009.0
2020-05-01 07:00:00	ES	Futures	3124.48	3125.85	3113.23	3122.29	24315.0
2020-05-01 08:00:00	ES	Futures	3122.83	3123.38	3115.97	3120.09	30973.0
2020-05-01 09:00:00	ES	Futures	3120.09	3136.83	3117.9	3125.58	176212.0
2020-05-01 10:00:00	ES	Futures	3125.58	3135.46	3115.43	3125.85	227459.0
2020-05-01 11:00:00	ES	Futures	3125.85	3125.85	3096.22	3099.51	161528.0
2020-05-01 12:00:00	ES	Futures	3099.24	3102.8	3087.44	3094.84	167614.0
2020-05-01 13:00:00	ES	Futures	3094.84	3099.78	3086.34	3091.0	117764.0
2020-05-01 14:00:00	ES	Futures	3090.73	3100.61	3086.61	3097.59	107887.0
2020-05-01 15:00:00	ES	Futures	3097.59	3106.92	3087.44	3100.06	284015.0
2020-05-01 16:00:00	ES	Futures	3100.06	3103.35	3091.0	3092.1	67526.0
2020-05-01 00:00:00	NQ	Futures	10071.4	10093.11	10069.4	10081.69	2926.0
2020-05-01 01:00:00	NQ	Futures	10081.97	10090.83	10044.84	10063.12	4425.0
2020-05-01 02:00:00	NQ	Futures	10061.69	10063.12	9998.56	10009.7	6907.0
2020-05-01 03:00:00	NQ	Futures	10009.99	10023.13	9969.14	9992.57	7820.0
2020-05-01 04:00:00	NQ	Futures	9992.57	10024.27	9980.86	10022.56	8237.0
2020-05-01 05:00:00	NQ	Futures	10023.13	10025.7	10001.42	10011.42	3839.0
2020-05-01 06:00:00	NQ	Futures	10011.99	10041.41	10009.13	10023.42	5524.0
2020-05-01 07:00:00	NQ	Futures	10023.13	10038.27	9992.0	10032.84	7028.0
2020-05-01 08:00:00	NQ	Futures	10033.41	10039.41	10006.56	10033.98	10470.0
2020-05-01 09:00:00	NQ	Futures	10033.98	10103.4	10025.99	10087.11	51960.0
2020-05-01 10:00:00	NQ	Futures	10087.4	10144.81	10062.26	10086.83	64270.0
2020-05-01 11:00:00	NQ	Futures	10086.83	10087.11	9966.86	9976.57	46968.0
2020-05-01 12:00:00	NQ	Futures	9976.28	9980.86	9912.87	9939.72	45636.0
2020-05-01 13:00:00	NQ	Futures	9939.15	9960.0	9908.3	9937.15	31480.0
2020-05-01 14:00:00	NQ	Futures	9937.15	9975.71	9923.73	9969.43	25784.0
2020-05-01 15:00:00	NQ	Futures	9969.72	10003.42	9926.01	9954.29	43167.0
2020-05-01 16:00:00	NQ	Futures	9954.29	9968.0	9937.72	9942.58	8128.0
2020-05-01 00:00:00	YM	Futures	26212.0	26262.4	26204.4	26239.4	1169.0
2020-05-01 01:00:00	YM	Futures	26239.4	26250.4	26149.6	26203.3	1864.0
2020-05-01 02:00:00	YM	Futures	26203.3	26206.6	25985.3	26020.4	3723.0
2020-05-01 03:00:00	YM	Futures	26025.8	26076.2	25957.9	26028.0	5735.0
2020-05-01 04:00:00	YM	Futures	26030.2	26095.9	25972.2	26081.7	5656.0
2020-05-01 05:00:00	YM	Futures	26082.8	26090.5	26014.9	26039.0	2558.0
2020-05-01 06:00:00	YM	Futures	26039.0	26101.4	26029.1	26052.1	3220.0
2020-05-01 07:00:00	YM	Futures	26051.0	26070.7	25973.3	26056.5	3953.0
2020-05-01 08:00:00	YM	Futures	26057.6	26083.9	26009.4	26054.3	4343.0
2020-05-01 09:00:00	YM	Futures	26052.1	26197.8	26000.6	26066.4	21139.0
2020-05-01 10:00:00	YM	Futures	26067.5	26152.9	25985.3	26101.4	25210.0
2020-05-01 11:00:00	YM	Futures	26102.5	26102.5	25873.6	25914.1	15907.0
2020-05-01 12:00:00	YM	Futures	25916.3	25957.9	25827.6	25888.9	14779.0
2020-05-01 13:00:00	YM	Futures	25888.9	25938.2	25827.6	25856.1	10847.0
2020-05-01 14:00:00	YM	Futures	25856.1	25930.5	25814.4	25886.7	10021.0
2020-05-01 15:00:00	YM	Futures	25888.9	25955.7	25772.8	25871.4	19152.0

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

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