PREVIEW / futures_1hour / 2014-12-16

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-12-16.parquet
  size:    53 KB
  rows:    1,562

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-12-16 00:00:00	ES	Futures	2094.43	2094.43	2087.85	2088.37	7823.0
2014-12-16 01:00:00	ES	Futures	2088.64	2093.11	2088.11	2092.06	2997.0
2014-12-16 02:00:00	ES	Futures	2092.06	2094.16	2088.9	2094.16	15889.0
2014-12-16 03:00:00	ES	Futures	2094.16	2096.79	2086.53	2089.16	63428.0
2014-12-16 04:00:00	ES	Futures	2089.16	2095.74	2086.79	2095.48	41667.0
2014-12-16 05:00:00	ES	Futures	2095.48	2098.9	2093.64	2096.27	33162.0
2014-12-16 06:00:00	ES	Futures	2096.0	2096.0	2078.9	2079.43	60303.0
2014-12-16 07:00:00	ES	Futures	2079.16	2079.95	2064.69	2071.53	121942.0
2014-12-16 08:00:00	ES	Futures	2071.79	2082.85	2071.01	2077.06	94217.0
2014-12-16 09:00:00	ES	Futures	2076.79	2085.48	2072.06	2080.22	296640.0
2014-12-16 10:00:00	ES	Futures	2080.22	2097.58	2077.06	2096.79	400433.0
2014-12-16 11:00:00	ES	Futures	2096.53	2117.06	2093.11	2105.74	412269.0
2014-12-16 12:00:00	ES	Futures	2105.74	2107.58	2097.32	2097.32	210904.0
2014-12-16 13:00:00	ES	Futures	2097.32	2100.48	2083.64	2092.32	277186.0
2014-12-16 14:00:00	ES	Futures	2092.32	2097.58	2085.48	2088.9	161936.0
2014-12-16 15:00:00	ES	Futures	2088.9	2091.53	2069.16	2069.69	344142.0
2014-12-16 16:00:00	ES	Futures	2069.95	2072.85	2066.27	2070.48	122393.0
2014-12-16 17:00:00	ES	Futures	2070.48	2070.74	2069.43	2069.95	3385.0
2014-12-16 18:00:00	ES	Futures	2070.22	2073.64	2069.95	2072.06	7627.0
2014-12-16 19:00:00	ES	Futures	2072.06	2076.0	2072.06	2075.48	9254.0
2014-12-16 20:00:00	ES	Futures	2075.22	2076.0	2073.64	2074.95	5392.0
2014-12-16 21:00:00	ES	Futures	2074.95	2076.53	2071.53	2072.58	6794.0
2014-12-16 22:00:00	ES	Futures	2072.32	2074.43	2069.43	2074.43	7624.0
2014-12-16 23:00:00	ES	Futures	2074.16	2074.69	2071.01	2072.32	4167.0
2014-12-16 00:00:00	NQ	Futures	4898.43	4898.43	4883.45	4884.33	1864.0
2014-12-16 01:00:00	NQ	Futures	4884.04	4895.79	4884.04	4893.14	797.0
2014-12-16 02:00:00	NQ	Futures	4893.73	4898.43	4885.8	4897.84	1790.0
2014-12-16 03:00:00	NQ	Futures	4897.55	4903.13	4875.52	4879.93	9371.0
2014-12-16 04:00:00	NQ	Futures	4879.05	4898.14	4873.76	4897.55	5971.0
2014-12-16 05:00:00	NQ	Futures	4897.84	4906.36	4892.85	4899.02	4148.0
2014-12-16 06:00:00	NQ	Futures	4898.72	4898.72	4862.6	4863.19	9434.0
2014-12-16 07:00:00	NQ	Futures	4863.19	4863.19	4828.53	4841.45	24541.0
2014-12-16 08:00:00	NQ	Futures	4841.75	4865.83	4840.28	4854.08	17683.0
2014-12-16 09:00:00	NQ	Futures	4854.08	4871.12	4830.29	4849.68	64606.0
2014-12-16 10:00:00	NQ	Futures	4849.38	4872.88	4822.66	4870.53	85296.0
2014-12-16 11:00:00	NQ	Futures	4870.23	4921.92	4861.42	4895.49	75501.0
2014-12-16 12:00:00	NQ	Futures	4895.49	4901.66	4876.99	4876.99	40648.0
2014-12-16 13:00:00	NQ	Futures	4877.28	4884.92	4842.63	4864.95	60446.0
2014-12-16 14:00:00	NQ	Futures	4864.65	4873.47	4842.33	4850.26	30011.0
2014-12-16 15:00:00	NQ	Futures	4849.97	4857.31	4799.75	4801.51	80141.0
2014-12-16 16:00:00	NQ	Futures	4801.51	4809.44	4793.88	4802.39	16334.0
2014-12-16 17:00:00	NQ	Futures	4802.69	4803.27	4800.04	4801.22	600.0
2014-12-16 18:00:00	NQ	Futures	4802.69	4807.09	4802.39	4804.74	1925.0
2014-12-16 19:00:00	NQ	Futures	4804.45	4812.08	4804.45	4811.2	2714.0
2014-12-16 20:00:00	NQ	Futures	4811.2	4812.08	4807.09	4809.44	980.0
2014-12-16 21:00:00	NQ	Futures	4809.73	4812.97	4801.81	4804.45	1210.0
2014-12-16 22:00:00	NQ	Futures	4804.15	4808.85	4794.76	4808.56	1901.0
2014-12-16 23:00:00	NQ	Futures	4808.27	4814.14	4801.81	4808.56	2644.0
2014-12-16 00:00:00	YM	Futures	17946.3	17948.4	17882.7	17885.8	6558.0
2014-12-16 01:00:00	YM	Futures	17886.8	17924.4	17880.6	17911.9	2158.0

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

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