PREVIEW / futures_1hour / 2014-09-24

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-09-24.parquet
  size:    51 KB
  rows:    1,583

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
2014-09-24 00:00:00	ES	Futures	2069.28	2069.54	2068.49	2069.02	1470.0
2014-09-24 01:00:00	ES	Futures	2069.28	2070.33	2069.02	2069.8	4241.0
2014-09-24 02:00:00	ES	Futures	2069.54	2072.16	2069.54	2071.9	12062.0
2014-09-24 03:00:00	ES	Futures	2071.9	2072.16	2067.45	2068.23	28109.0
2014-09-24 04:00:00	ES	Futures	2067.97	2070.33	2067.97	2069.54	19534.0
2014-09-24 05:00:00	ES	Futures	2069.54	2070.33	2069.02	2069.28	13221.0
2014-09-24 06:00:00	ES	Futures	2069.28	2073.47	2069.28	2071.64	20304.0
2014-09-24 07:00:00	ES	Futures	2071.64	2072.69	2071.11	2071.64	16542.0
2014-09-24 08:00:00	ES	Futures	2071.9	2072.69	2070.07	2070.33	19908.0
2014-09-24 09:00:00	ES	Futures	2070.33	2073.73	2066.92	2068.76	179302.0
2014-09-24 10:00:00	ES	Futures	2068.76	2073.21	2064.83	2071.64	321451.0
2014-09-24 11:00:00	ES	Futures	2071.64	2080.81	2071.11	2079.5	244322.0
2014-09-24 12:00:00	ES	Futures	2079.24	2080.02	2076.62	2077.93	105105.0
2014-09-24 13:00:00	ES	Futures	2077.93	2082.64	2077.14	2081.85	119951.0
2014-09-24 14:00:00	ES	Futures	2081.85	2086.31	2080.81	2086.05	147413.0
2014-09-24 15:00:00	ES	Futures	2085.78	2087.88	2085.26	2086.83	201135.0
2014-09-24 16:00:00	ES	Futures	2086.57	2087.09	2085.52	2085.78	70719.0
2014-09-24 17:00:00	ES	Futures	2086.05	2086.57	2085.78	2085.78	1483.0
2014-09-24 18:00:00	ES	Futures	2086.05	2086.83	2085.52	2086.31	3269.0
2014-09-24 19:00:00	ES	Futures	2086.57	2086.83	2086.31	2086.57	1087.0
2014-09-24 20:00:00	ES	Futures	2086.31	2086.57	2085.52	2085.52	2711.0
2014-09-24 21:00:00	ES	Futures	2085.78	2086.05	2085.26	2085.78	2535.0
2014-09-24 22:00:00	ES	Futures	2085.52	2085.78	2084.21	2084.47	3269.0
2014-09-24 23:00:00	ES	Futures	2084.47	2084.74	2083.95	2084.47	2758.0
2014-09-24 00:00:00	NQ	Futures	4736.73	4738.2	4736.14	4736.73	397.0
2014-09-24 01:00:00	NQ	Futures	4736.73	4739.66	4736.73	4738.78	381.0
2014-09-24 02:00:00	NQ	Futures	4738.78	4743.47	4738.49	4742.88	1118.0
2014-09-24 03:00:00	NQ	Futures	4742.88	4743.18	4732.63	4733.51	3538.0
2014-09-24 04:00:00	NQ	Futures	4733.51	4741.13	4732.63	4737.02	2263.0
2014-09-24 05:00:00	NQ	Futures	4737.61	4740.25	4736.44	4737.61	1784.0
2014-09-24 06:00:00	NQ	Futures	4737.9	4749.92	4737.61	4745.52	3645.0
2014-09-24 07:00:00	NQ	Futures	4745.23	4746.69	4742.88	4743.47	2056.0
2014-09-24 08:00:00	NQ	Futures	4743.47	4746.69	4740.83	4740.83	2908.0
2014-09-24 09:00:00	NQ	Futures	4741.13	4756.65	4734.97	4743.18	37349.0
2014-09-24 10:00:00	NQ	Futures	4743.18	4750.79	4726.77	4745.52	60747.0
2014-09-24 11:00:00	NQ	Futures	4745.81	4775.99	4744.64	4774.82	45399.0
2014-09-24 12:00:00	NQ	Futures	4774.82	4775.7	4766.03	4768.38	19255.0
2014-09-24 13:00:00	NQ	Futures	4768.38	4784.49	4766.91	4781.56	23677.0
2014-09-24 14:00:00	NQ	Futures	4781.56	4786.54	4776.58	4785.37	24233.0
2014-09-24 15:00:00	NQ	Futures	4785.37	4792.99	4783.03	4790.35	35196.0
2014-09-24 16:00:00	NQ	Futures	4790.64	4793.57	4789.18	4789.76	7433.0
2014-09-24 17:00:00	NQ	Futures	4789.76	4791.52	4789.76	4790.64	230.0
2014-09-24 18:00:00	NQ	Futures	4788.01	4790.64	4787.71	4789.76	782.0
2014-09-24 19:00:00	NQ	Futures	4789.18	4790.35	4788.59	4790.35	155.0
2014-09-24 20:00:00	NQ	Futures	4789.76	4790.06	4788.59	4788.59	383.0
2014-09-24 21:00:00	NQ	Futures	4788.59	4789.18	4787.42	4788.3	446.0
2014-09-24 22:00:00	NQ	Futures	4788.01	4788.3	4785.08	4785.66	540.0
2014-09-24 23:00:00	NQ	Futures	4785.96	4786.54	4784.78	4785.96	427.0
2014-09-24 00:00:00	YM	Futures	17654.1	17655.2	17651.0	17653.1	334.0
2014-09-24 01:00:00	YM	Futures	17654.1	17662.5	17653.1	17661.4	508.0

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

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