PREVIEW / futures_1hour / 2014-10-30

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-10-30.parquet
  size:    52 KB
  rows:    1,574

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-30 00:00:00	ES	Futures	2067.18	2067.45	2065.87	2066.66	1620.0
2014-10-30 01:00:00	ES	Futures	2066.92	2067.71	2066.92	2067.45	1053.0
2014-10-30 02:00:00	ES	Futures	2067.18	2069.28	2066.92	2067.97	2646.0
2014-10-30 03:00:00	ES	Futures	2067.97	2073.47	2067.97	2073.47	13771.0
2014-10-30 04:00:00	ES	Futures	2073.21	2075.57	2068.76	2069.8	38419.0
2014-10-30 05:00:00	ES	Futures	2070.07	2070.07	2058.28	2060.9	49895.0
2014-10-30 06:00:00	ES	Futures	2060.64	2062.73	2055.4	2057.75	48598.0
2014-10-30 07:00:00	ES	Futures	2057.75	2058.8	2053.04	2057.23	55075.0
2014-10-30 08:00:00	ES	Futures	2057.49	2063.52	2056.97	2059.33	65657.0
2014-10-30 09:00:00	ES	Futures	2059.33	2072.69	2059.06	2064.83	282468.0
2014-10-30 10:00:00	ES	Futures	2065.09	2072.16	2062.21	2071.64	291738.0
2014-10-30 11:00:00	ES	Futures	2071.9	2077.14	2070.85	2076.35	220277.0
2014-10-30 12:00:00	ES	Futures	2076.62	2079.24	2074.26	2078.19	133580.0
2014-10-30 13:00:00	ES	Futures	2077.93	2089.19	2077.66	2087.88	219619.0
2014-10-30 14:00:00	ES	Futures	2087.88	2089.71	2075.83	2077.14	214244.0
2014-10-30 15:00:00	ES	Futures	2077.4	2084.74	2076.09	2084.21	249593.0
2014-10-30 16:00:00	ES	Futures	2084.21	2084.74	2082.38	2084.21	68257.0
2014-10-30 17:00:00	ES	Futures	2084.21	2084.47	2083.16	2083.43	3228.0
2014-10-30 18:00:00	ES	Futures	2082.9	2085.0	2081.85	2084.21	5606.0
2014-10-30 19:00:00	ES	Futures	2084.21	2085.52	2083.43	2085.0	2490.0
2014-10-30 20:00:00	ES	Futures	2084.74	2085.0	2082.38	2084.21	5272.0
2014-10-30 21:00:00	ES	Futures	2084.47	2087.88	2084.21	2087.36	6482.0
2014-10-30 22:00:00	ES	Futures	2087.62	2088.67	2085.78	2087.88	3716.0
2014-10-30 23:00:00	ES	Futures	2087.88	2088.67	2087.62	2087.88	2370.0
2014-10-30 00:00:00	NQ	Futures	4776.58	4776.58	4774.24	4776.58	302.0
2014-10-30 01:00:00	NQ	Futures	4776.58	4778.04	4776.29	4776.58	320.0
2014-10-30 02:00:00	NQ	Futures	4776.87	4781.27	4775.99	4778.63	576.0
2014-10-30 03:00:00	NQ	Futures	4778.63	4785.37	4778.34	4785.37	2247.0
2014-10-30 04:00:00	NQ	Futures	4785.08	4787.71	4775.11	4777.75	6489.0
2014-10-30 05:00:00	NQ	Futures	4776.87	4777.75	4753.14	4758.12	8553.0
2014-10-30 06:00:00	NQ	Futures	4758.41	4763.39	4748.45	4752.26	8274.0
2014-10-30 07:00:00	NQ	Futures	4752.55	4753.72	4738.49	4748.74	11019.0
2014-10-30 08:00:00	NQ	Futures	4748.45	4761.93	4748.16	4754.02	10502.0
2014-10-30 09:00:00	NQ	Futures	4754.31	4785.37	4753.43	4762.81	57261.0
2014-10-30 10:00:00	NQ	Futures	4763.1	4773.06	4754.02	4767.79	54548.0
2014-10-30 11:00:00	NQ	Futures	4767.79	4780.97	4765.74	4780.39	35299.0
2014-10-30 12:00:00	NQ	Futures	4780.1	4787.71	4773.94	4784.49	24971.0
2014-10-30 13:00:00	NQ	Futures	4784.78	4807.93	4782.73	4804.41	43042.0
2014-10-30 14:00:00	NQ	Futures	4804.41	4808.22	4773.65	4777.46	41309.0
2014-10-30 15:00:00	NQ	Futures	4777.46	4799.14	4775.99	4797.38	47676.0
2014-10-30 16:00:00	NQ	Futures	4797.68	4802.36	4790.64	4797.68	10672.0
2014-10-30 17:00:00	NQ	Futures	4797.68	4798.26	4795.33	4795.33	331.0
2014-10-30 18:00:00	NQ	Futures	4795.33	4800.9	4793.28	4799.73	711.0
2014-10-30 19:00:00	NQ	Futures	4799.73	4802.07	4797.09	4800.9	436.0
2014-10-30 20:00:00	NQ	Futures	4800.31	4801.78	4795.33	4800.9	753.0
2014-10-30 21:00:00	NQ	Futures	4800.9	4808.81	4800.9	4807.34	1277.0
2014-10-30 22:00:00	NQ	Futures	4807.34	4809.4	4803.54	4807.93	1218.0
2014-10-30 23:00:00	NQ	Futures	4807.64	4809.98	4806.76	4807.64	567.0
2014-10-30 00:00:00	YM	Futures	17600.1	17600.1	17592.8	17600.1	271.0
2014-10-30 01:00:00	YM	Futures	17598.0	17604.2	17598.0	17601.1	162.0

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

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