PREVIEW / futures_1hour / 2020-05-14

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-05-14.parquet
  size:    61 KB
  rows:    1,881

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-14 00:00:00	ES	Futures	3087.71	3094.3	3079.48	3080.3	12480.0
2020-05-14 01:00:00	ES	Futures	3080.58	3085.79	3074.54	3074.81	16720.0
2020-05-14 02:00:00	ES	Futures	3074.81	3080.03	3069.32	3075.36	24823.0
2020-05-14 03:00:00	ES	Futures	3075.64	3095.39	3075.36	3083.32	44841.0
2020-05-14 04:00:00	ES	Futures	3083.59	3088.53	3077.83	3083.32	41609.0
2020-05-14 05:00:00	ES	Futures	3083.04	3092.65	3080.58	3091.83	25413.0
2020-05-14 06:00:00	ES	Futures	3091.83	3092.1	3077.56	3085.79	37458.0
2020-05-14 07:00:00	ES	Futures	3086.06	3088.26	3067.68	3069.32	55217.0
2020-05-14 08:00:00	ES	Futures	3069.6	3073.17	3048.19	3057.8	103443.0
2020-05-14 09:00:00	ES	Futures	3057.52	3067.4	3032.28	3035.3	284116.0
2020-05-14 10:00:00	ES	Futures	3035.57	3076.18	3029.81	3067.68	389983.0
2020-05-14 11:00:00	ES	Futures	3067.95	3087.16	3058.35	3066.85	318368.0
2020-05-14 12:00:00	ES	Futures	3066.85	3098.41	3062.19	3095.94	197658.0
2020-05-14 13:00:00	ES	Futures	3095.94	3109.66	3089.36	3092.37	174901.0
2020-05-14 14:00:00	ES	Futures	3092.37	3099.24	3080.85	3093.2	174631.0
2020-05-14 15:00:00	ES	Futures	3093.47	3125.58	3090.45	3124.48	342600.0
2020-05-14 16:00:00	ES	Futures	3124.48	3132.44	3122.01	3126.13	92762.0
2020-05-14 18:00:00	ES	Futures	3124.21	3126.95	3118.44	3121.19	9132.0
2020-05-14 19:00:00	ES	Futures	3121.46	3133.54	3119.82	3132.44	9608.0
2020-05-14 20:00:00	ES	Futures	3132.44	3137.65	3123.38	3125.85	16503.0
2020-05-14 21:00:00	ES	Futures	3125.58	3127.5	3115.7	3119.27	17437.0
2020-05-14 22:00:00	ES	Futures	3119.54	3124.21	3111.58	3121.74	18810.0
2020-05-14 23:00:00	ES	Futures	3122.01	3126.4	3114.33	3125.58	11941.0
2020-05-14 00:00:00	NQ	Futures	10283.92	10304.77	10254.21	10256.21	5478.0
2020-05-14 01:00:00	NQ	Futures	10256.5	10277.06	10241.93	10243.36	5670.0
2020-05-14 02:00:00	NQ	Futures	10243.36	10257.64	10220.22	10247.64	8007.0
2020-05-14 03:00:00	NQ	Futures	10247.64	10320.77	10245.93	10280.78	13644.0
2020-05-14 04:00:00	NQ	Futures	10279.92	10301.34	10262.21	10287.06	12222.0
2020-05-14 05:00:00	NQ	Futures	10286.49	10326.48	10278.49	10320.48	8941.0
2020-05-14 06:00:00	NQ	Futures	10320.77	10322.48	10265.35	10281.06	12017.0
2020-05-14 07:00:00	NQ	Futures	10281.06	10289.35	10203.37	10209.08	16983.0
2020-05-14 08:00:00	NQ	Futures	10209.08	10219.65	10157.1	10203.37	28004.0
2020-05-14 09:00:00	NQ	Futures	10203.08	10255.36	10115.96	10136.82	79646.0
2020-05-14 10:00:00	NQ	Futures	10137.1	10203.37	10108.25	10173.09	93594.0
2020-05-14 11:00:00	NQ	Futures	10172.52	10253.93	10163.67	10171.95	82603.0
2020-05-14 12:00:00	NQ	Futures	10172.23	10265.07	10158.24	10258.78	60066.0
2020-05-14 13:00:00	NQ	Futures	10259.35	10294.49	10234.5	10249.64	42082.0
2020-05-14 14:00:00	NQ	Futures	10249.36	10271.07	10209.94	10265.92	44413.0
2020-05-14 15:00:00	NQ	Futures	10266.5	10384.75	10256.21	10381.61	68498.0
2020-05-14 16:00:00	NQ	Futures	10381.32	10401.89	10366.76	10384.18	12926.0
2020-05-14 18:00:00	NQ	Futures	10380.75	10392.18	10365.9	10373.61	2581.0
2020-05-14 19:00:00	NQ	Futures	10374.47	10410.46	10367.33	10406.46	2973.0
2020-05-14 20:00:00	NQ	Futures	10405.6	10420.46	10378.18	10388.46	6613.0
2020-05-14 21:00:00	NQ	Futures	10389.04	10393.89	10354.76	10366.76	7018.0
2020-05-14 22:00:00	NQ	Futures	10367.04	10385.04	10342.76	10377.32	6858.0
2020-05-14 23:00:00	NQ	Futures	10376.75	10395.32	10355.62	10392.18	5402.0
2020-05-14 00:00:00	YM	Futures	25386.2	25434.4	25317.2	25322.6	2627.0
2020-05-14 01:00:00	YM	Futures	25312.8	25358.8	25266.8	25270.1	3126.0
2020-05-14 02:00:00	YM	Futures	25270.1	25304.0	25216.4	25269.0	4837.0
2020-05-14 03:00:00	YM	Futures	25270.1	25420.1	25266.8	25323.7	9420.0

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

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