PREVIEW / futures_1hour / 2019-05-22

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-05-22.parquet
  size:    58 KB
  rows:    1,840

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-22 00:00:00	ES	Futures	3109.27	3110.09	3104.39	3107.1	9204.0
2019-05-22 01:00:00	ES	Futures	3107.1	3107.37	3103.58	3104.12	6849.0
2019-05-22 02:00:00	ES	Futures	3104.39	3104.93	3101.41	3104.39	8573.0
2019-05-22 03:00:00	ES	Futures	3104.12	3104.39	3098.97	3099.24	16087.0
2019-05-22 04:00:00	ES	Futures	3099.24	3104.39	3098.7	3101.14	14098.0
2019-05-22 05:00:00	ES	Futures	3101.14	3107.92	3101.14	3106.83	18771.0
2019-05-22 06:00:00	ES	Futures	3106.56	3108.46	3103.58	3103.85	14999.0
2019-05-22 07:00:00	ES	Futures	3103.58	3104.12	3093.82	3094.09	29610.0
2019-05-22 08:00:00	ES	Futures	3094.36	3096.8	3088.67	3096.26	79778.0
2019-05-22 09:00:00	ES	Futures	3095.99	3102.77	3094.09	3102.22	179215.0
2019-05-22 10:00:00	ES	Futures	3102.49	3110.09	3095.45	3098.43	232964.0
2019-05-22 11:00:00	ES	Futures	3098.43	3105.48	3094.36	3101.14	137091.0
2019-05-22 12:00:00	ES	Futures	3101.14	3102.77	3094.9	3096.53	78146.0
2019-05-22 13:00:00	ES	Futures	3096.26	3102.49	3092.73	3100.87	84884.0
2019-05-22 14:00:00	ES	Futures	3100.87	3106.29	3097.61	3104.12	87409.0
2019-05-22 15:00:00	ES	Futures	3104.12	3105.75	3098.43	3098.7	120381.0
2019-05-22 16:00:00	ES	Futures	3098.7	3100.33	3096.26	3097.89	45236.0
2019-05-22 18:00:00	ES	Futures	3098.97	3099.78	3097.89	3097.89	3385.0
2019-05-22 19:00:00	ES	Futures	3097.89	3098.16	3093.82	3095.17	5011.0
2019-05-22 20:00:00	ES	Futures	3095.17	3096.53	3089.21	3091.38	13727.0
2019-05-22 21:00:00	ES	Futures	3091.11	3091.11	3083.52	3085.96	21415.0
2019-05-22 22:00:00	ES	Futures	3085.69	3089.75	3083.52	3087.58	12216.0
2019-05-22 23:00:00	ES	Futures	3087.58	3088.13	3085.69	3087.31	6167.0
2019-05-22 00:00:00	NQ	Futures	8692.17	8694.79	8674.12	8683.15	3232.0
2019-05-22 01:00:00	NQ	Futures	8683.15	8684.89	8667.72	8670.04	3423.0
2019-05-22 02:00:00	NQ	Futures	8670.04	8676.45	8661.6	8673.54	4168.0
2019-05-22 03:00:00	NQ	Futures	8673.54	8673.54	8653.74	8655.2	7402.0
2019-05-22 04:00:00	NQ	Futures	8654.61	8674.7	8652.28	8664.51	6335.0
2019-05-22 05:00:00	NQ	Futures	8664.22	8693.34	8663.93	8679.36	9584.0
2019-05-22 06:00:00	NQ	Futures	8679.36	8688.68	8666.55	8668.59	6498.0
2019-05-22 07:00:00	NQ	Futures	8668.3	8669.75	8630.16	8633.36	12451.0
2019-05-22 08:00:00	NQ	Futures	8633.65	8643.26	8608.03	8640.35	31986.0
2019-05-22 09:00:00	NQ	Futures	8640.35	8679.94	8631.32	8676.16	61537.0
2019-05-22 10:00:00	NQ	Futures	8675.87	8703.24	8650.25	8659.85	78465.0
2019-05-22 11:00:00	NQ	Futures	8659.85	8686.64	8644.71	8669.75	59753.0
2019-05-22 12:00:00	NQ	Futures	8669.75	8674.7	8647.63	8656.65	32294.0
2019-05-22 13:00:00	NQ	Futures	8655.78	8677.03	8640.64	8671.5	33161.0
2019-05-22 14:00:00	NQ	Futures	8671.5	8693.34	8658.4	8682.56	34553.0
2019-05-22 15:00:00	NQ	Futures	8682.56	8686.93	8653.74	8653.74	35941.0
2019-05-22 16:00:00	NQ	Futures	8654.03	8657.53	8644.71	8648.5	9868.0
2019-05-22 18:00:00	NQ	Futures	8654.03	8658.69	8649.96	8651.12	1571.0
2019-05-22 19:00:00	NQ	Futures	8651.12	8651.12	8633.07	8638.31	2829.0
2019-05-22 20:00:00	NQ	Futures	8638.6	8642.68	8619.67	8624.04	5537.0
2019-05-22 21:00:00	NQ	Futures	8623.46	8623.75	8593.76	8602.79	9827.0
2019-05-22 22:00:00	NQ	Futures	8602.79	8615.02	8591.14	8605.12	7110.0
2019-05-22 23:00:00	NQ	Futures	8605.12	8606.28	8598.13	8603.37	3248.0
2019-05-22 00:00:00	YM	Futures	28152.1	28164.1	28117.3	28141.2	3439.0
2019-05-22 01:00:00	YM	Futures	28140.1	28145.6	28107.5	28115.1	2738.0
2019-05-22 02:00:00	YM	Futures	28116.2	28123.8	28091.2	28118.4	2612.0
2019-05-22 03:00:00	YM	Futures	28117.3	28117.3	28069.4	28072.7	4246.0

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

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