PREVIEW / futures_1hour / 2019-05-09

all futures 1-hour files

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

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-09 00:00:00	ES	Futures	3113.61	3114.42	3112.25	3114.15	4567.0
2019-05-09 01:00:00	ES	Futures	3114.15	3119.03	3112.25	3114.69	13053.0
2019-05-09 02:00:00	ES	Futures	3114.69	3116.59	3108.46	3110.09	23989.0
2019-05-09 03:00:00	ES	Futures	3110.09	3110.09	3099.24	3104.66	54448.0
2019-05-09 04:00:00	ES	Futures	3104.66	3108.19	3100.33	3106.83	32619.0
2019-05-09 05:00:00	ES	Futures	3106.83	3109.54	3104.66	3106.56	20726.0
2019-05-09 06:00:00	ES	Futures	3106.56	3111.98	3103.85	3111.17	21248.0
2019-05-09 07:00:00	ES	Futures	3111.44	3112.8	3107.65	3108.73	32522.0
2019-05-09 08:00:00	ES	Futures	3108.73	3109.54	3098.43	3099.78	59025.0
2019-05-09 09:00:00	ES	Futures	3099.78	3100.33	3083.25	3089.75	351911.0
2019-05-09 10:00:00	ES	Futures	3089.75	3090.02	3076.47	3079.99	390459.0
2019-05-09 11:00:00	ES	Futures	3079.72	3092.73	3075.66	3089.48	282601.0
2019-05-09 12:00:00	ES	Futures	3089.48	3117.41	3085.14	3108.46	441897.0
2019-05-09 13:00:00	ES	Futures	3108.19	3119.84	3104.12	3112.25	241439.0
2019-05-09 14:00:00	ES	Futures	3112.53	3119.3	3106.83	3107.92	175389.0
2019-05-09 15:00:00	ES	Futures	3107.92	3117.13	3100.6	3113.34	310108.0
2019-05-09 16:00:00	ES	Futures	3113.61	3118.49	3112.53	3114.69	66634.0
2019-05-09 18:00:00	ES	Futures	3111.98	3114.97	3107.92	3108.19	15651.0
2019-05-09 19:00:00	ES	Futures	3108.19	3118.22	3107.92	3116.32	16787.0
2019-05-09 20:00:00	ES	Futures	3116.32	3132.86	3109.54	3122.28	70594.0
2019-05-09 21:00:00	ES	Futures	3122.28	3128.25	3113.34	3126.62	47331.0
2019-05-09 22:00:00	ES	Futures	3126.62	3127.16	3107.65	3107.65	28101.0
2019-05-09 23:00:00	ES	Futures	3107.65	3120.39	3098.7	3101.41	56083.0
2019-05-09 00:00:00	NQ	Futures	8846.49	8848.81	8841.24	8847.07	2056.0
2019-05-09 01:00:00	NQ	Futures	8847.36	8865.7	8839.21	8850.85	5525.0
2019-05-09 02:00:00	NQ	Futures	8851.14	8856.68	8822.03	8828.72	7005.0
2019-05-09 03:00:00	NQ	Futures	8828.72	8831.35	8802.81	8818.83	12408.0
2019-05-09 04:00:00	NQ	Futures	8819.12	8827.56	8803.39	8825.23	9747.0
2019-05-09 05:00:00	NQ	Futures	8825.52	8836.0	8817.08	8824.94	8358.0
2019-05-09 06:00:00	NQ	Futures	8824.94	8840.37	8815.33	8836.88	6479.0
2019-05-09 07:00:00	NQ	Futures	8837.46	8843.57	8822.32	8826.69	10509.0
2019-05-09 08:00:00	NQ	Futures	8826.69	8828.72	8792.91	8795.82	19097.0
2019-05-09 09:00:00	NQ	Futures	8795.53	8810.96	8737.01	8764.09	98609.0
2019-05-09 10:00:00	NQ	Futures	8764.38	8764.67	8712.55	8723.33	119942.0
2019-05-09 11:00:00	NQ	Futures	8723.04	8778.94	8719.83	8770.2	88548.0
2019-05-09 12:00:00	NQ	Futures	8770.49	8871.23	8749.24	8829.6	120919.0
2019-05-09 13:00:00	NQ	Futures	8828.72	8869.78	8813.88	8846.19	65252.0
2019-05-09 14:00:00	NQ	Futures	8846.49	8862.79	8817.37	8819.7	45396.0
2019-05-09 15:00:00	NQ	Futures	8819.41	8854.06	8798.74	8842.99	66061.0
2019-05-09 16:00:00	NQ	Futures	8842.99	8856.09	8838.04	8842.41	13142.0
2019-05-09 18:00:00	NQ	Futures	8840.66	8844.45	8821.15	8821.45	3618.0
2019-05-09 19:00:00	NQ	Futures	8821.74	8852.89	8819.99	8847.36	5330.0
2019-05-09 20:00:00	NQ	Futures	8847.65	8914.62	8839.5	8882.59	19886.0
2019-05-09 21:00:00	NQ	Futures	8882.88	8907.34	8852.6	8902.68	16980.0
2019-05-09 22:00:00	NQ	Futures	8902.68	8905.3	8822.03	8822.61	13335.0
2019-05-09 23:00:00	NQ	Futures	8822.32	8861.92	8783.89	8792.04	18490.0
2019-05-09 00:00:00	YM	Futures	28142.3	28152.1	28132.5	28145.6	1615.0
2019-05-09 01:00:00	YM	Futures	28145.6	28194.5	28129.2	28163.0	4259.0
2019-05-09 02:00:00	YM	Futures	28163.0	28178.2	28106.4	28116.2	4214.0
2019-05-09 03:00:00	YM	Futures	28117.3	28117.3	28022.7	28068.3	9436.0

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

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