PREVIEW / futures_1hour / 2019-06-10

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-06-10.parquet
  size:    49 KB
  rows:    1,582

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-06-10 00:00:00	ES	Futures	3126.62	3128.79	3126.35	3128.52	6123.0
2019-06-10 01:00:00	ES	Futures	3128.52	3128.79	3126.35	3126.89	6351.0
2019-06-10 02:00:00	ES	Futures	3126.89	3129.6	3125.81	3127.71	9572.0
2019-06-10 03:00:00	ES	Futures	3127.71	3130.15	3125.54	3129.33	15747.0
2019-06-10 04:00:00	ES	Futures	3129.06	3130.42	3125.27	3126.89	16093.0
2019-06-10 05:00:00	ES	Futures	3126.89	3127.98	3125.54	3127.98	10485.0
2019-06-10 06:00:00	ES	Futures	3128.25	3130.69	3127.44	3127.98	11704.0
2019-06-10 07:00:00	ES	Futures	3127.71	3133.67	3126.35	3132.86	22468.0
2019-06-10 08:00:00	ES	Futures	3132.86	3135.3	3130.69	3132.32	41196.0
2019-06-10 09:00:00	ES	Futures	3132.32	3140.18	3131.23	3138.55	171872.0
2019-06-10 10:00:00	ES	Futures	3138.55	3143.97	3136.65	3141.53	184684.0
2019-06-10 11:00:00	ES	Futures	3141.53	3151.02	3140.99	3149.4	157508.0
2019-06-10 12:00:00	ES	Futures	3149.4	3150.21	3139.91	3139.91	108818.0
2019-06-10 13:00:00	ES	Futures	3139.91	3144.52	3136.65	3138.28	94931.0
2019-06-10 14:00:00	ES	Futures	3138.28	3139.36	3130.42	3138.82	142825.0
2019-06-10 15:00:00	ES	Futures	3139.09	3140.18	3129.88	3130.42	193435.0
2019-06-10 16:00:00	ES	Futures	3130.42	3135.57	3129.88	3133.94	54040.0
2019-06-10 18:00:00	ES	Futures	3134.21	3134.76	3130.69	3133.13	5119.0
2019-06-10 19:00:00	ES	Futures	3133.13	3133.13	3129.88	3130.42	4413.0
2019-06-10 20:00:00	ES	Futures	3130.42	3136.92	3129.88	3136.11	13639.0
2019-06-10 21:00:00	ES	Futures	3135.84	3140.18	3135.84	3139.91	17779.0
2019-06-10 22:00:00	ES	Futures	3140.18	3140.99	3138.82	3140.72	7944.0
2019-06-10 23:00:00	ES	Futures	3140.72	3140.99	3138.55	3139.09	6669.0
2019-06-10 00:00:00	NQ	Futures	8667.13	8675.58	8664.8	8674.41	2004.0
2019-06-10 01:00:00	NQ	Futures	8674.12	8675.87	8666.26	8668.3	2151.0
2019-06-10 02:00:00	NQ	Futures	8669.17	8677.61	8665.1	8670.63	3294.0
2019-06-10 03:00:00	NQ	Futures	8670.34	8676.45	8661.31	8674.12	5504.0
2019-06-10 04:00:00	NQ	Futures	8673.83	8677.61	8663.93	8670.34	5944.0
2019-06-10 05:00:00	NQ	Futures	8670.63	8672.37	8664.51	8672.37	4787.0
2019-06-10 06:00:00	NQ	Futures	8672.37	8679.65	8667.72	8670.63	3844.0
2019-06-10 07:00:00	NQ	Futures	8670.63	8699.16	8666.55	8695.67	8427.0
2019-06-10 08:00:00	NQ	Futures	8695.67	8701.78	8683.73	8693.34	13405.0
2019-06-10 09:00:00	NQ	Futures	8693.63	8758.85	8691.01	8748.37	71892.0
2019-06-10 10:00:00	NQ	Futures	8748.37	8796.99	8741.96	8781.56	74779.0
2019-06-10 11:00:00	NQ	Futures	8781.56	8826.1	8779.23	8818.83	51170.0
2019-06-10 12:00:00	NQ	Futures	8819.12	8821.45	8773.41	8776.9	44325.0
2019-06-10 13:00:00	NQ	Futures	8776.61	8792.91	8764.38	8772.53	28210.0
2019-06-10 14:00:00	NQ	Futures	8772.24	8773.41	8736.43	8769.91	42263.0
2019-06-10 15:00:00	NQ	Futures	8769.62	8774.86	8737.59	8741.96	53936.0
2019-06-10 16:00:00	NQ	Futures	8741.96	8760.01	8741.09	8757.1	9336.0
2019-06-10 18:00:00	NQ	Futures	8757.39	8759.14	8746.91	8752.73	2147.0
2019-06-10 19:00:00	NQ	Futures	8753.02	8753.02	8742.25	8744.58	1444.0
2019-06-10 20:00:00	NQ	Futures	8744.58	8768.46	8740.8	8765.25	4373.0
2019-06-10 21:00:00	NQ	Futures	8764.96	8777.48	8764.96	8777.19	5713.0
2019-06-10 22:00:00	NQ	Futures	8776.9	8785.63	8771.66	8785.34	3682.0
2019-06-10 23:00:00	NQ	Futures	8785.34	8787.09	8776.9	8779.52	2711.0
2019-06-10 00:00:00	YM	Futures	28353.3	28357.7	28353.3	28357.7	2.0
2019-06-10 01:00:00	YM	Futures	28358.7	28364.2	28346.8	28349.0	12.0
2019-06-10 02:00:00	YM	Futures	28344.6	28362.0	28344.6	28357.7	41.0
2019-06-10 03:00:00	YM	Futures	28357.7	28378.3	28344.6	28378.3	19.0

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

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