PREVIEW / futures_1hour / 2020-05-04

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-05-04.parquet
  size:    62 KB
  rows:    1,876

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-04 00:00:00	ES	Futures	3080.58	3082.22	3067.95	3071.79	9224.0
2020-05-04 01:00:00	ES	Futures	3071.79	3076.73	3064.93	3067.4	11617.0
2020-05-04 02:00:00	ES	Futures	3067.4	3089.36	3064.66	3084.14	26624.0
2020-05-04 03:00:00	ES	Futures	3084.14	3087.44	3068.5	3074.26	42857.0
2020-05-04 04:00:00	ES	Futures	3074.54	3082.5	3065.76	3067.4	37947.0
2020-05-04 05:00:00	ES	Futures	3067.13	3069.32	3055.33	3069.32	34422.0
2020-05-04 06:00:00	ES	Futures	3069.05	3075.64	3065.48	3069.6	29034.0
2020-05-04 07:00:00	ES	Futures	3069.6	3079.48	3066.03	3073.44	28266.0
2020-05-04 08:00:00	ES	Futures	3073.44	3082.22	3069.6	3075.09	49485.0
2020-05-04 09:00:00	ES	Futures	3074.81	3081.12	3060.82	3076.18	187942.0
2020-05-04 10:00:00	ES	Futures	3075.91	3092.92	3074.81	3077.56	193438.0
2020-05-04 11:00:00	ES	Futures	3077.56	3090.45	3075.36	3085.24	137150.0
2020-05-04 12:00:00	ES	Futures	3085.51	3092.37	3079.75	3081.67	79916.0
2020-05-04 13:00:00	ES	Futures	3081.67	3086.06	3071.79	3085.24	85842.0
2020-05-04 14:00:00	ES	Futures	3085.24	3098.14	3081.4	3096.77	115549.0
2020-05-04 15:00:00	ES	Futures	3096.77	3112.68	3094.3	3109.66	208756.0
2020-05-04 16:00:00	ES	Futures	3109.66	3110.21	3098.96	3103.63	53272.0
2020-05-04 18:00:00	ES	Futures	3103.08	3110.49	3100.33	3103.63	7536.0
2020-05-04 19:00:00	ES	Futures	3103.9	3108.84	3101.43	3107.74	4247.0
2020-05-04 20:00:00	ES	Futures	3107.47	3117.07	3107.47	3116.52	10516.0
2020-05-04 21:00:00	ES	Futures	3116.8	3126.13	3115.7	3125.3	13240.0
2020-05-04 22:00:00	ES	Futures	3125.58	3126.13	3119.54	3121.74	7724.0
2020-05-04 23:00:00	ES	Futures	3122.01	3123.38	3117.62	3119.27	5325.0
2020-05-04 00:00:00	NQ	Futures	9899.16	9906.02	9864.89	9874.03	3706.0
2020-05-04 01:00:00	NQ	Futures	9874.03	9888.31	9855.74	9864.89	4699.0
2020-05-04 02:00:00	NQ	Futures	9865.17	9936.3	9851.17	9924.58	9638.0
2020-05-04 03:00:00	NQ	Futures	9925.73	9936.3	9877.74	9892.88	12010.0
2020-05-04 04:00:00	NQ	Futures	9894.02	9920.59	9872.31	9881.45	9904.0
2020-05-04 05:00:00	NQ	Futures	9881.45	9883.45	9845.18	9882.31	7928.0
2020-05-04 06:00:00	NQ	Futures	9882.31	9902.02	9871.74	9879.17	6552.0
2020-05-04 07:00:00	NQ	Futures	9879.45	9915.73	9863.46	9898.31	8004.0
2020-05-04 08:00:00	NQ	Futures	9898.02	9913.73	9879.17	9896.88	11879.0
2020-05-04 09:00:00	NQ	Futures	9896.88	9968.57	9882.59	9960.57	55001.0
2020-05-04 10:00:00	NQ	Futures	9961.15	10019.13	9955.43	9976.57	55822.0
2020-05-04 11:00:00	NQ	Futures	9976.86	10034.84	9970.29	10016.56	37655.0
2020-05-04 12:00:00	NQ	Futures	10016.56	10029.7	9959.72	9967.43	25950.0
2020-05-04 13:00:00	NQ	Futures	9967.72	9993.42	9938.87	9992.85	23514.0
2020-05-04 14:00:00	NQ	Futures	9992.57	10031.7	9978.28	10027.13	24060.0
2020-05-04 15:00:00	NQ	Futures	10026.56	10086.54	10017.7	10074.83	37414.0
2020-05-04 16:00:00	NQ	Futures	10075.12	10076.54	10045.41	10064.83	7310.0
2020-05-04 18:00:00	NQ	Futures	10061.69	10087.11	10052.84	10065.98	2747.0
2020-05-04 19:00:00	NQ	Futures	10066.26	10084.83	10057.41	10081.69	1584.0
2020-05-04 20:00:00	NQ	Futures	10081.69	10105.68	10075.4	10102.25	4663.0
2020-05-04 21:00:00	NQ	Futures	10101.68	10139.96	10097.97	10135.39	6005.0
2020-05-04 22:00:00	NQ	Futures	10136.24	10137.39	10116.82	10120.25	2737.0
2020-05-04 23:00:00	NQ	Futures	10119.96	10122.25	10090.26	10104.25	3486.0
2020-05-04 00:00:00	YM	Futures	25722.4	25734.5	25615.1	25644.7	1699.0
2020-05-04 01:00:00	YM	Futures	25642.5	25684.1	25580.0	25599.8	1573.0
2020-05-04 02:00:00	YM	Futures	25598.7	25767.3	25574.6	25722.4	5369.0
2020-05-04 03:00:00	YM	Futures	25726.8	25757.5	25600.9	25661.1	4902.0

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

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