PREVIEW / futures_1hour / 2019-08-28

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-08-28.parquet
  size:    57 KB
  rows:    1,787

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-08-28 00:00:00	ES	Futures	3113.38	3115.27	3111.21	3112.57	6086.0
2019-08-28 01:00:00	ES	Futures	3112.84	3114.19	3111.48	3113.92	6157.0
2019-08-28 02:00:00	ES	Futures	3114.19	3115.0	3111.48	3112.57	8126.0
2019-08-28 03:00:00	ES	Futures	3112.57	3112.57	3102.28	3107.69	36215.0
2019-08-28 04:00:00	ES	Futures	3107.69	3115.0	3100.11	3107.15	46066.0
2019-08-28 05:00:00	ES	Futures	3107.15	3112.57	3104.99	3108.24	31194.0
2019-08-28 06:00:00	ES	Futures	3108.24	3112.57	3102.82	3105.8	28451.0
2019-08-28 07:00:00	ES	Futures	3106.07	3107.15	3094.16	3097.41	36229.0
2019-08-28 08:00:00	ES	Futures	3097.41	3099.84	3090.1	3099.3	76949.0
2019-08-28 09:00:00	ES	Futures	3099.03	3109.32	3087.93	3108.51	256740.0
2019-08-28 10:00:00	ES	Futures	3108.51	3120.15	3106.07	3117.17	213572.0
2019-08-28 11:00:00	ES	Futures	3117.17	3126.91	3113.11	3123.67	162533.0
2019-08-28 12:00:00	ES	Futures	3123.4	3126.37	3119.88	3125.56	75296.0
2019-08-28 13:00:00	ES	Futures	3125.83	3126.1	3117.98	3123.67	82834.0
2019-08-28 14:00:00	ES	Futures	3123.67	3129.08	3122.31	3128.27	71027.0
2019-08-28 15:00:00	ES	Futures	3128.27	3129.89	3121.23	3127.46	172197.0
2019-08-28 16:00:00	ES	Futures	3127.46	3129.89	3119.88	3122.04	66008.0
2019-08-28 18:00:00	ES	Futures	3122.04	3126.91	3121.5	3125.29	6975.0
2019-08-28 19:00:00	ES	Futures	3125.29	3125.29	3121.5	3123.67	5585.0
2019-08-28 20:00:00	ES	Futures	3123.4	3125.29	3120.69	3122.04	10554.0
2019-08-28 21:00:00	ES	Futures	3121.77	3121.77	3113.38	3114.46	20663.0
2019-08-28 22:00:00	ES	Futures	3114.73	3119.33	3114.46	3119.06	8819.0
2019-08-28 23:00:00	ES	Futures	3119.06	3119.33	3116.9	3118.52	4449.0
2019-08-28 00:00:00	NQ	Futures	8810.76	8815.98	8803.5	8809.59	3028.0
2019-08-28 01:00:00	NQ	Futures	8809.59	8814.24	8804.66	8813.08	3630.0
2019-08-28 02:00:00	NQ	Futures	8813.37	8817.43	8804.95	8806.98	3738.0
2019-08-28 03:00:00	NQ	Futures	8807.56	8807.56	8773.04	8790.45	16625.0
2019-08-28 04:00:00	NQ	Futures	8790.74	8815.69	8762.88	8782.32	21801.0
2019-08-28 05:00:00	NQ	Futures	8782.03	8802.05	8774.78	8787.83	10072.0
2019-08-28 06:00:00	NQ	Futures	8787.83	8802.63	8771.01	8781.16	9807.0
2019-08-28 07:00:00	NQ	Futures	8781.16	8785.8	8746.05	8755.92	14639.0
2019-08-28 08:00:00	NQ	Futures	8756.21	8760.56	8729.52	8756.79	25594.0
2019-08-28 09:00:00	NQ	Futures	8756.5	8779.42	8709.21	8762.59	82836.0
2019-08-28 10:00:00	NQ	Futures	8762.3	8800.02	8754.18	8788.99	68977.0
2019-08-28 11:00:00	NQ	Futures	8788.99	8820.33	8771.01	8809.88	51901.0
2019-08-28 12:00:00	NQ	Futures	8809.59	8813.37	8792.48	8809.59	24603.0
2019-08-28 13:00:00	NQ	Futures	8809.88	8810.47	8780.87	8799.15	25482.0
2019-08-28 14:00:00	NQ	Futures	8799.44	8819.75	8791.61	8817.14	21747.0
2019-08-28 15:00:00	NQ	Futures	8816.85	8827.0	8799.44	8812.79	40029.0
2019-08-28 16:00:00	NQ	Futures	8812.79	8821.49	8790.45	8799.15	10349.0
2019-08-28 18:00:00	NQ	Futures	8799.73	8812.79	8793.93	8806.4	2966.0
2019-08-28 19:00:00	NQ	Futures	8806.11	8806.11	8792.48	8799.73	2882.0
2019-08-28 20:00:00	NQ	Futures	8799.73	8804.66	8784.93	8789.58	5132.0
2019-08-28 21:00:00	NQ	Futures	8789.58	8789.87	8760.56	8763.75	9581.0
2019-08-28 22:00:00	NQ	Futures	8763.17	8778.84	8762.59	8777.39	4836.0
2019-08-28 23:00:00	NQ	Futures	8777.97	8780.58	8772.17	8777.39	2882.0
2019-08-28 00:00:00	YM	Futures	28091.2	28103.2	28070.6	28083.6	1213.0
2019-08-28 01:00:00	YM	Futures	28082.5	28094.5	28069.5	28090.1	1010.0
2019-08-28 02:00:00	YM	Futures	28091.2	28099.9	28064.0	28078.2	1615.0
2019-08-28 03:00:00	YM	Futures	28078.2	28078.2	27982.5	28026.0	5955.0

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

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