PREVIEW / futures_1hour / 2019-04-04

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-04-04.parquet
  size:    53 KB
  rows:    1,728

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-04-04 00:00:00	ES	Futures	3120.66	3121.74	3119.3	3120.39	3314.0
2019-04-04 01:00:00	ES	Futures	3120.66	3121.74	3119.3	3120.93	4447.0
2019-04-04 02:00:00	ES	Futures	3120.93	3120.93	3117.41	3119.84	8857.0
2019-04-04 03:00:00	ES	Futures	3119.57	3121.2	3117.95	3119.57	12792.0
2019-04-04 04:00:00	ES	Futures	3119.57	3120.66	3116.59	3119.03	11813.0
2019-04-04 05:00:00	ES	Futures	3119.03	3120.39	3117.95	3120.39	9811.0
2019-04-04 06:00:00	ES	Futures	3120.39	3123.64	3119.84	3122.56	10283.0
2019-04-04 07:00:00	ES	Futures	3122.83	3123.1	3119.57	3119.84	11239.0
2019-04-04 08:00:00	ES	Futures	3119.84	3123.64	3119.57	3122.01	17056.0
2019-04-04 09:00:00	ES	Futures	3122.28	3129.33	3121.2	3127.71	173776.0
2019-04-04 10:00:00	ES	Futures	3127.71	3129.06	3117.68	3124.18	188153.0
2019-04-04 11:00:00	ES	Futures	3124.18	3126.08	3116.32	3119.3	137864.0
2019-04-04 12:00:00	ES	Futures	3119.03	3121.74	3113.34	3117.95	112994.0
2019-04-04 13:00:00	ES	Futures	3117.95	3121.74	3116.59	3120.39	70565.0
2019-04-04 14:00:00	ES	Futures	3120.39	3126.08	3119.3	3125.0	61709.0
2019-04-04 15:00:00	ES	Futures	3125.27	3127.98	3122.01	3126.35	123037.0
2019-04-04 16:00:00	ES	Futures	3126.35	3127.98	3125.27	3126.08	40514.0
2019-04-04 18:00:00	ES	Futures	3125.81	3126.08	3124.18	3124.72	3837.0
2019-04-04 19:00:00	ES	Futures	3124.45	3126.08	3123.64	3124.45	2695.0
2019-04-04 20:00:00	ES	Futures	3124.18	3132.32	3123.64	3128.79	21854.0
2019-04-04 21:00:00	ES	Futures	3129.06	3130.15	3127.44	3129.6	29584.0
2019-04-04 22:00:00	ES	Futures	3129.6	3130.42	3126.35	3129.6	32509.0
2019-04-04 23:00:00	ES	Futures	3129.33	3131.23	3129.06	3130.69	20871.0
2019-04-04 00:00:00	NQ	Futures	8821.74	8825.81	8815.04	8819.7	2311.0
2019-04-04 01:00:00	NQ	Futures	8819.7	8822.32	8813.58	8818.83	2925.0
2019-04-04 02:00:00	NQ	Futures	8819.12	8819.41	8807.18	8812.71	5863.0
2019-04-04 03:00:00	NQ	Futures	8813.0	8819.7	8809.51	8816.79	7422.0
2019-04-04 04:00:00	NQ	Futures	8816.5	8817.95	8802.52	8810.67	6599.0
2019-04-04 05:00:00	NQ	Futures	8810.67	8822.03	8809.51	8820.86	5259.0
2019-04-04 06:00:00	NQ	Futures	8820.86	8829.31	8819.12	8825.81	5131.0
2019-04-04 07:00:00	NQ	Futures	8825.81	8826.69	8809.51	8810.67	6200.0
2019-04-04 08:00:00	NQ	Futures	8810.67	8821.45	8807.76	8817.37	7376.0
2019-04-04 09:00:00	NQ	Futures	8817.37	8848.81	8811.26	8840.66	60899.0
2019-04-04 10:00:00	NQ	Futures	8840.66	8844.74	8778.65	8810.38	90038.0
2019-04-04 11:00:00	NQ	Futures	8810.38	8813.0	8780.1	8791.75	61066.0
2019-04-04 12:00:00	NQ	Futures	8791.46	8801.07	8760.3	8782.14	47722.0
2019-04-04 13:00:00	NQ	Futures	8782.43	8795.53	8779.81	8790.87	28889.0
2019-04-04 14:00:00	NQ	Futures	8791.17	8818.83	8786.8	8818.24	26235.0
2019-04-04 15:00:00	NQ	Futures	8817.95	8819.7	8799.32	8810.96	36774.0
2019-04-04 16:00:00	NQ	Futures	8810.96	8814.75	8804.56	8807.76	7852.0
2019-04-04 18:00:00	NQ	Futures	8810.38	8810.38	8801.07	8802.52	2002.0
2019-04-04 19:00:00	NQ	Futures	8802.81	8807.47	8799.9	8801.07	1595.0
2019-04-04 20:00:00	NQ	Futures	8800.77	8828.14	8799.9	8820.28	9691.0
2019-04-04 21:00:00	NQ	Futures	8819.99	8823.19	8812.71	8819.7	8030.0
2019-04-04 22:00:00	NQ	Futures	8819.7	8820.57	8808.93	8816.21	7706.0
2019-04-04 23:00:00	NQ	Futures	8815.91	8821.74	8813.29	8819.99	3885.0
2019-04-04 00:00:00	YM	Futures	28555.6	28574.1	28541.5	28557.8	2308.0
2019-04-04 01:00:00	YM	Futures	28556.7	28571.9	28551.3	28563.2	911.0
2019-04-04 02:00:00	YM	Futures	28564.3	28564.3	28525.2	28550.2	2093.0
2019-04-04 03:00:00	YM	Futures	28551.3	28571.9	28536.0	28560.0	2677.0

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

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