PREVIEW / futures_1hour / 2014-10-27

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-10-27.parquet
  size:    49 KB
  rows:    1,518

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-10-27 00:00:00	ES	Futures	2053.56	2055.66	2053.3	2054.61	2887.0
2014-10-27 01:00:00	ES	Futures	2054.61	2055.13	2053.56	2054.61	2208.0
2014-10-27 02:00:00	ES	Futures	2054.87	2055.66	2053.82	2054.87	1870.0
2014-10-27 03:00:00	ES	Futures	2055.13	2059.85	2054.09	2058.28	15451.0
2014-10-27 04:00:00	ES	Futures	2058.28	2058.8	2051.73	2053.04	32377.0
2014-10-27 05:00:00	ES	Futures	2053.04	2054.61	2047.28	2050.42	39273.0
2014-10-27 06:00:00	ES	Futures	2050.42	2051.2	2047.01	2048.58	29217.0
2014-10-27 07:00:00	ES	Futures	2048.85	2051.73	2047.8	2049.63	29938.0
2014-10-27 08:00:00	ES	Futures	2049.63	2050.68	2043.35	2045.18	54274.0
2014-10-27 09:00:00	ES	Futures	2045.18	2046.23	2038.63	2041.51	193295.0
2014-10-27 10:00:00	ES	Futures	2041.25	2050.42	2037.58	2048.06	261293.0
2014-10-27 11:00:00	ES	Futures	2047.8	2052.78	2042.3	2043.61	203981.0
2014-10-27 12:00:00	ES	Futures	2043.35	2048.06	2042.82	2046.49	125643.0
2014-10-27 13:00:00	ES	Futures	2046.23	2051.47	2045.44	2047.28	116931.0
2014-10-27 14:00:00	ES	Futures	2047.28	2049.63	2044.66	2046.23	91745.0
2014-10-27 15:00:00	ES	Futures	2045.97	2050.94	2045.7	2049.11	136111.0
2014-10-27 16:00:00	ES	Futures	2049.11	2051.99	2048.58	2051.47	75093.0
2014-10-27 17:00:00	ES	Futures	2051.2	2051.73	2050.94	2051.2	1467.0
2014-10-27 18:00:00	ES	Futures	2051.47	2053.04	2050.68	2050.68	4467.0
2014-10-27 19:00:00	ES	Futures	2050.94	2052.25	2050.42	2051.47	1856.0
2014-10-27 20:00:00	ES	Futures	2051.73	2052.25	2050.68	2051.99	2276.0
2014-10-27 21:00:00	ES	Futures	2051.73	2052.51	2051.2	2051.47	2862.0
2014-10-27 22:00:00	ES	Futures	2051.73	2051.73	2050.42	2051.2	2191.0
2014-10-27 23:00:00	ES	Futures	2051.2	2052.25	2050.68	2051.73	1741.0
2014-10-27 00:00:00	NQ	Futures	4733.51	4738.2	4733.51	4736.44	499.0
2014-10-27 01:00:00	NQ	Futures	4736.44	4738.2	4733.21	4736.73	535.0
2014-10-27 02:00:00	NQ	Futures	4736.44	4738.2	4735.27	4737.32	478.0
2014-10-27 03:00:00	NQ	Futures	4737.32	4746.4	4735.85	4743.47	2743.0
2014-10-27 04:00:00	NQ	Futures	4743.47	4744.35	4728.53	4732.04	4333.0
2014-10-27 05:00:00	NQ	Futures	4731.46	4734.97	4720.32	4726.77	5181.0
2014-10-27 06:00:00	NQ	Futures	4727.06	4727.35	4719.15	4722.08	3958.0
2014-10-27 07:00:00	NQ	Futures	4722.37	4728.82	4720.91	4724.42	4521.0
2014-10-27 08:00:00	NQ	Futures	4724.42	4729.41	4714.76	4718.27	8692.0
2014-10-27 09:00:00	NQ	Futures	4718.27	4728.82	4705.67	4707.72	44179.0
2014-10-27 10:00:00	NQ	Futures	4708.02	4736.44	4699.23	4727.65	53744.0
2014-10-27 11:00:00	NQ	Futures	4727.35	4738.78	4717.1	4720.03	36430.0
2014-10-27 12:00:00	NQ	Futures	4720.03	4731.75	4718.56	4729.7	23046.0
2014-10-27 13:00:00	NQ	Futures	4729.99	4740.54	4724.13	4727.06	26930.0
2014-10-27 14:00:00	NQ	Futures	4726.77	4732.63	4721.49	4724.72	22257.0
2014-10-27 15:00:00	NQ	Futures	4724.72	4737.61	4724.13	4732.34	25172.0
2014-10-27 16:00:00	NQ	Futures	4732.34	4739.37	4731.46	4736.14	7946.0
2014-10-27 17:00:00	NQ	Futures	4736.14	4736.73	4735.56	4736.73	99.0
2014-10-27 18:00:00	NQ	Futures	4736.14	4739.66	4734.39	4734.39	432.0
2014-10-27 19:00:00	NQ	Futures	4734.39	4737.32	4733.21	4735.27	226.0
2014-10-27 20:00:00	NQ	Futures	4735.56	4736.44	4733.51	4735.85	480.0
2014-10-27 21:00:00	NQ	Futures	4735.85	4737.9	4734.09	4734.97	427.0
2014-10-27 22:00:00	NQ	Futures	4734.97	4735.27	4732.34	4734.39	465.0
2014-10-27 23:00:00	NQ	Futures	4734.39	4736.44	4733.51	4735.85	309.0
2014-10-27 00:00:00	YM	Futures	17411.9	17427.5	17411.9	17421.2	664.0
2014-10-27 01:00:00	YM	Futures	17421.2	17426.4	17410.8	17419.2	664.0

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

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