PREVIEW / futures_1hour / 2014-08-20

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-08-20.parquet
  size:    49 KB
  rows:    1,544

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-08-20 00:00:00	ES	Futures	2060.67	2060.67	2059.63	2059.63	1142.0
2014-08-20 01:00:00	ES	Futures	2059.89	2060.15	2059.63	2059.63	2163.0
2014-08-20 02:00:00	ES	Futures	2059.89	2060.41	2058.85	2059.37	6958.0
2014-08-20 03:00:00	ES	Futures	2059.37	2060.67	2058.59	2059.11	17320.0
2014-08-20 04:00:00	ES	Futures	2059.11	2059.37	2056.77	2058.33	19107.0
2014-08-20 05:00:00	ES	Futures	2058.59	2059.11	2057.55	2058.59	13790.0
2014-08-20 06:00:00	ES	Futures	2058.33	2060.67	2058.33	2059.89	10145.0
2014-08-20 07:00:00	ES	Futures	2060.15	2062.5	2059.37	2061.72	21720.0
2014-08-20 08:00:00	ES	Futures	2061.46	2061.72	2057.29	2059.63	47618.0
2014-08-20 09:00:00	ES	Futures	2059.37	2063.28	2058.07	2061.98	146320.0
2014-08-20 10:00:00	ES	Futures	2061.72	2064.84	2060.94	2064.32	130071.0
2014-08-20 11:00:00	ES	Futures	2064.32	2065.89	2063.8	2064.84	90976.0
2014-08-20 12:00:00	ES	Futures	2065.11	2065.11	2064.32	2064.84	32736.0
2014-08-20 13:00:00	ES	Futures	2064.84	2067.71	2064.58	2065.89	74027.0
2014-08-20 14:00:00	ES	Futures	2065.63	2068.23	2060.15	2067.97	224835.0
2014-08-20 15:00:00	ES	Futures	2067.97	2070.32	2067.45	2067.71	145318.0
2014-08-20 16:00:00	ES	Futures	2067.71	2067.97	2066.67	2067.19	53776.0
2014-08-20 17:00:00	ES	Futures	2067.45	2067.71	2067.19	2067.71	1624.0
2014-08-20 18:00:00	ES	Futures	2066.93	2067.19	2066.41	2066.93	2469.0
2014-08-20 19:00:00	ES	Futures	2066.93	2069.28	2066.67	2068.75	4854.0
2014-08-20 20:00:00	ES	Futures	2068.75	2069.01	2067.71	2067.97	3118.0
2014-08-20 21:00:00	ES	Futures	2067.97	2069.01	2066.41	2067.71	6568.0
2014-08-20 22:00:00	ES	Futures	2067.71	2068.75	2067.71	2068.23	3482.0
2014-08-20 23:00:00	ES	Futures	2068.23	2068.49	2067.45	2067.97	3501.0
2014-08-20 00:00:00	NQ	Futures	4711.36	4711.66	4709.03	4709.9	223.0
2014-08-20 01:00:00	NQ	Futures	4709.9	4711.36	4709.32	4710.78	386.0
2014-08-20 02:00:00	NQ	Futures	4711.07	4711.36	4709.03	4709.03	795.0
2014-08-20 03:00:00	NQ	Futures	4709.9	4712.83	4707.57	4710.2	2635.0
2014-08-20 04:00:00	NQ	Futures	4709.9	4710.49	4705.82	4709.32	2807.0
2014-08-20 05:00:00	NQ	Futures	4709.32	4710.78	4707.57	4709.32	1461.0
2014-08-20 06:00:00	NQ	Futures	4709.32	4714.29	4709.32	4712.53	1700.0
2014-08-20 07:00:00	NQ	Futures	4712.53	4716.91	4711.36	4715.45	3342.0
2014-08-20 08:00:00	NQ	Futures	4715.45	4715.45	4707.57	4711.95	6939.0
2014-08-20 09:00:00	NQ	Futures	4711.95	4717.5	4709.9	4715.45	27551.0
2014-08-20 10:00:00	NQ	Futures	4715.45	4720.71	4709.61	4718.67	22407.0
2014-08-20 11:00:00	NQ	Futures	4718.67	4722.46	4716.33	4721.59	12224.0
2014-08-20 12:00:00	NQ	Futures	4721.29	4723.05	4718.96	4720.42	7051.0
2014-08-20 13:00:00	NQ	Futures	4720.13	4724.8	4718.08	4719.25	9712.0
2014-08-20 14:00:00	NQ	Futures	4719.25	4723.05	4709.03	4721.59	36034.0
2014-08-20 15:00:00	NQ	Futures	4721.88	4726.55	4717.79	4718.08	19558.0
2014-08-20 16:00:00	NQ	Futures	4718.08	4720.42	4716.62	4718.96	4344.0
2014-08-20 17:00:00	NQ	Futures	4718.96	4721.0	4718.96	4720.71	399.0
2014-08-20 18:00:00	NQ	Futures	4718.67	4718.67	4716.91	4717.79	237.0
2014-08-20 19:00:00	NQ	Futures	4717.79	4723.63	4717.5	4722.75	482.0
2014-08-20 20:00:00	NQ	Futures	4722.46	4723.34	4719.83	4721.0	552.0
2014-08-20 21:00:00	NQ	Futures	4721.0	4722.46	4716.91	4718.67	1644.0
2014-08-20 22:00:00	NQ	Futures	4718.37	4719.25	4716.62	4716.91	1056.0
2014-08-20 23:00:00	NQ	Futures	4717.21	4717.21	4715.75	4716.62	520.0
2014-08-20 00:00:00	YM	Futures	17461.4	17463.5	17456.3	17457.3	242.0
2014-08-20 01:00:00	YM	Futures	17456.3	17460.4	17455.2	17457.3	494.0

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

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