PREVIEW / futures_1hour / 2017-09-29

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-09-29.parquet
  size:    45 KB
  rows:    1,347

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
2017-09-29 00:00:00	ES	Futures	2742.97	2743.79	2742.43	2742.7	4289.0
2017-09-29 01:00:00	ES	Futures	2742.7	2742.97	2742.15	2742.43	2915.0
2017-09-29 02:00:00	ES	Futures	2742.43	2743.25	2741.88	2742.15	7590.0
2017-09-29 03:00:00	ES	Futures	2742.43	2742.97	2741.6	2742.7	11973.0
2017-09-29 04:00:00	ES	Futures	2742.7	2743.25	2741.88	2742.15	10438.0
2017-09-29 05:00:00	ES	Futures	2742.15	2742.97	2742.15	2742.7	8857.0
2017-09-29 06:00:00	ES	Futures	2742.43	2743.79	2742.43	2743.25	10336.0
2017-09-29 07:00:00	ES	Futures	2743.52	2743.79	2742.15	2742.7	7479.0
2017-09-29 08:00:00	ES	Futures	2742.7	2743.52	2741.33	2742.15	16755.0
2017-09-29 09:00:00	ES	Futures	2742.15	2745.71	2740.78	2742.7	171599.0
2017-09-29 10:00:00	ES	Futures	2742.97	2748.44	2742.7	2747.9	131126.0
2017-09-29 11:00:00	ES	Futures	2748.17	2750.91	2747.08	2750.91	122297.0
2017-09-29 12:00:00	ES	Futures	2750.91	2752.55	2750.36	2751.73	87745.0
2017-09-29 13:00:00	ES	Futures	2752.0	2752.27	2750.36	2751.18	49249.0
2017-09-29 14:00:00	ES	Futures	2751.18	2751.73	2749.26	2750.91	88431.0
2017-09-29 15:00:00	ES	Futures	2750.63	2754.19	2750.36	2752.82	374607.0
2017-09-29 16:00:00	ES	Futures	2752.55	2755.01	2751.73	2755.01	181016.0
2017-09-29 00:00:00	NQ	Futures	7067.51	7070.48	7066.32	7067.51	966.0
2017-09-29 01:00:00	NQ	Futures	7067.8	7068.4	7065.43	7065.72	940.0
2017-09-29 02:00:00	NQ	Futures	7066.02	7069.59	7064.83	7066.02	1416.0
2017-09-29 03:00:00	NQ	Futures	7066.61	7069.89	7064.53	7069.29	2234.0
2017-09-29 04:00:00	NQ	Futures	7069.29	7071.97	7067.51	7068.99	2043.0
2017-09-29 05:00:00	NQ	Futures	7068.99	7074.05	7068.99	7071.08	1409.0
2017-09-29 06:00:00	NQ	Futures	7070.78	7075.54	7069.59	7075.54	1972.0
2017-09-29 07:00:00	NQ	Futures	7075.54	7077.02	7071.97	7074.64	2646.0
2017-09-29 08:00:00	NQ	Futures	7074.35	7076.73	7070.78	7072.27	3758.0
2017-09-29 09:00:00	NQ	Futures	7072.27	7087.14	7062.15	7062.75	43219.0
2017-09-29 10:00:00	NQ	Futures	7063.05	7091.3	7058.29	7085.65	48624.0
2017-09-29 11:00:00	NQ	Futures	7085.95	7107.96	7083.57	7107.06	39795.0
2017-09-29 12:00:00	NQ	Futures	7107.06	7119.85	7102.6	7118.37	22884.0
2017-09-29 13:00:00	NQ	Futures	7118.37	7119.85	7110.04	7113.61	17754.0
2017-09-29 14:00:00	NQ	Futures	7113.31	7114.8	7104.98	7110.04	17574.0
2017-09-29 15:00:00	NQ	Futures	7110.04	7118.96	7105.58	7115.09	38581.0
2017-09-29 16:00:00	NQ	Futures	7115.39	7120.74	7111.52	7114.2	13288.0
2017-09-29 00:00:00	YM	Futures	24281.5	24288.0	24281.5	24281.5	759.0
2017-09-29 01:00:00	YM	Futures	24282.6	24285.8	24278.2	24281.5	443.0
2017-09-29 02:00:00	YM	Futures	24282.6	24288.0	24276.0	24280.4	940.0
2017-09-29 03:00:00	YM	Futures	24280.4	24283.6	24271.7	24278.2	1281.0
2017-09-29 04:00:00	YM	Futures	24278.2	24279.3	24266.2	24268.4	1119.0
2017-09-29 05:00:00	YM	Futures	24269.5	24272.8	24265.1	24268.4	1037.0
2017-09-29 06:00:00	YM	Futures	24268.4	24280.4	24263.0	24269.5	1986.0
2017-09-29 07:00:00	YM	Futures	24270.6	24270.6	24254.3	24264.1	1515.0
2017-09-29 08:00:00	YM	Futures	24264.1	24269.5	24243.4	24247.7	2393.0
2017-09-29 09:00:00	YM	Futures	24247.7	24264.1	24234.7	24255.4	14991.0
2017-09-29 10:00:00	YM	Futures	24255.4	24286.9	24254.3	24267.3	11418.0
2017-09-29 11:00:00	YM	Futures	24268.4	24282.6	24258.6	24281.5	7669.0
2017-09-29 12:00:00	YM	Futures	24281.5	24285.8	24267.3	24271.7	4603.0
2017-09-29 13:00:00	YM	Futures	24270.6	24276.0	24259.7	24265.1	3717.0
2017-09-29 14:00:00	YM	Futures	24265.1	24282.6	24252.1	24278.2	6321.0
2017-09-29 15:00:00	YM	Futures	24278.2	24310.8	24273.9	24302.1	12754.0

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

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