PREVIEW / futures_1hour / 2019-05-16

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-05-16.parquet
  size:    60 KB
  rows:    1,857

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
2019-05-16 00:00:00	ES	Futures	3087.04	3088.4	3085.14	3085.96	5221.0
2019-05-16 01:00:00	ES	Futures	3085.96	3086.5	3082.7	3086.23	7269.0
2019-05-16 02:00:00	ES	Futures	3086.23	3088.4	3084.6	3087.85	12351.0
2019-05-16 03:00:00	ES	Futures	3087.85	3090.57	3081.62	3087.58	24117.0
2019-05-16 04:00:00	ES	Futures	3087.85	3095.99	3085.41	3095.17	26643.0
2019-05-16 05:00:00	ES	Futures	3095.17	3099.51	3094.09	3098.97	15873.0
2019-05-16 06:00:00	ES	Futures	3098.7	3109.0	3098.43	3107.1	42969.0
2019-05-16 07:00:00	ES	Futures	3107.1	3110.09	3103.31	3106.56	38301.0
2019-05-16 08:00:00	ES	Futures	3106.83	3108.73	3102.77	3104.93	48560.0
2019-05-16 09:00:00	ES	Futures	3105.21	3122.56	3100.33	3121.2	227785.0
2019-05-16 10:00:00	ES	Futures	3121.2	3131.5	3120.39	3131.23	233608.0
2019-05-16 11:00:00	ES	Futures	3130.96	3136.38	3127.16	3133.94	160615.0
2019-05-16 12:00:00	ES	Futures	3134.21	3138.28	3129.6	3131.5	141519.0
2019-05-16 13:00:00	ES	Futures	3131.5	3133.67	3125.0	3126.35	131182.0
2019-05-16 14:00:00	ES	Futures	3126.35	3132.86	3123.91	3128.52	114386.0
2019-05-16 15:00:00	ES	Futures	3128.52	3128.52	3115.24	3120.93	256602.0
2019-05-16 16:00:00	ES	Futures	3120.66	3123.64	3119.84	3122.83	62440.0
2019-05-16 18:00:00	ES	Futures	3122.83	3124.45	3121.2	3123.37	5433.0
2019-05-16 19:00:00	ES	Futures	3123.1	3125.81	3122.56	3124.72	4889.0
2019-05-16 20:00:00	ES	Futures	3125.0	3125.54	3119.57	3123.37	12749.0
2019-05-16 21:00:00	ES	Futures	3123.64	3125.81	3120.93	3123.64	9933.0
2019-05-16 22:00:00	ES	Futures	3123.91	3124.45	3117.95	3118.49	7832.0
2019-05-16 23:00:00	ES	Futures	3118.49	3119.57	3111.17	3111.44	19924.0
2019-05-16 00:00:00	NQ	Futures	8729.44	8735.55	8723.91	8725.36	2378.0
2019-05-16 01:00:00	NQ	Futures	8725.95	8728.28	8717.5	8727.11	3580.0
2019-05-16 02:00:00	NQ	Futures	8727.11	8734.39	8721.87	8731.19	4211.0
2019-05-16 03:00:00	NQ	Futures	8731.48	8741.96	8711.39	8728.86	9314.0
2019-05-16 04:00:00	NQ	Futures	8728.57	8760.89	8721.0	8756.81	10299.0
2019-05-16 05:00:00	NQ	Futures	8756.81	8776.9	8755.06	8774.57	10222.0
2019-05-16 06:00:00	NQ	Futures	8774.57	8808.05	8771.37	8797.28	12943.0
2019-05-16 07:00:00	NQ	Futures	8797.28	8810.38	8782.72	8792.91	12084.0
2019-05-16 08:00:00	NQ	Futures	8792.62	8793.2	8764.96	8773.41	20593.0
2019-05-16 09:00:00	NQ	Futures	8773.41	8832.8	8748.37	8827.27	76662.0
2019-05-16 10:00:00	NQ	Futures	8827.56	8879.97	8820.57	8877.06	77486.0
2019-05-16 11:00:00	NQ	Futures	8877.06	8894.82	8860.17	8888.41	49392.0
2019-05-16 12:00:00	NQ	Futures	8888.41	8898.89	8864.54	8870.94	38918.0
2019-05-16 13:00:00	NQ	Futures	8871.23	8876.77	8841.83	8849.11	39943.0
2019-05-16 14:00:00	NQ	Futures	8849.4	8875.31	8840.37	8862.79	36833.0
2019-05-16 15:00:00	NQ	Futures	8862.79	8862.79	8823.78	8842.41	66199.0
2019-05-16 16:00:00	NQ	Futures	8842.7	8859.59	8840.66	8853.76	12460.0
2019-05-16 18:00:00	NQ	Futures	8852.02	8858.13	8847.07	8852.6	2166.0
2019-05-16 19:00:00	NQ	Futures	8852.31	8863.08	8852.02	8860.17	1875.0
2019-05-16 20:00:00	NQ	Futures	8860.46	8865.41	8842.41	8857.55	5508.0
2019-05-16 21:00:00	NQ	Futures	8856.97	8866.58	8851.14	8860.46	4675.0
2019-05-16 22:00:00	NQ	Futures	8860.17	8861.63	8838.62	8840.08	4705.0
2019-05-16 23:00:00	NQ	Futures	8839.79	8842.7	8814.46	8815.33	9016.0
2019-05-16 00:00:00	YM	Futures	27856.2	27867.1	27838.8	27842.1	1784.0
2019-05-16 01:00:00	YM	Futures	27841.0	27847.5	27812.7	27841.0	2249.0
2019-05-16 02:00:00	YM	Futures	27842.1	27861.7	27826.9	27854.1	2278.0
2019-05-16 03:00:00	YM	Futures	27855.2	27881.3	27806.2	27856.2	5203.0

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

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