PREVIEW / futures_1hour / 2014-09-23

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-09-23.parquet
  size:    52 KB
  rows:    1,597

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-23 00:00:00	ES	Futures	2082.64	2082.64	2081.85	2082.12	1824.0
2014-09-23 01:00:00	ES	Futures	2082.12	2082.9	2082.12	2082.64	2907.0
2014-09-23 02:00:00	ES	Futures	2082.38	2082.9	2081.07	2081.59	8736.0
2014-09-23 03:00:00	ES	Futures	2081.33	2081.85	2075.83	2076.35	38540.0
2014-09-23 04:00:00	ES	Futures	2076.35	2077.14	2074.0	2075.57	27343.0
2014-09-23 05:00:00	ES	Futures	2075.57	2076.09	2073.21	2075.31	19098.0
2014-09-23 06:00:00	ES	Futures	2075.31	2076.35	2074.0	2076.09	18381.0
2014-09-23 07:00:00	ES	Futures	2076.09	2077.14	2073.21	2074.52	27682.0
2014-09-23 08:00:00	ES	Futures	2074.52	2076.62	2072.16	2075.83	47997.0
2014-09-23 09:00:00	ES	Futures	2075.83	2081.59	2072.95	2080.81	206239.0
2014-09-23 10:00:00	ES	Futures	2080.81	2083.16	2076.88	2077.4	256815.0
2014-09-23 11:00:00	ES	Futures	2077.4	2080.54	2074.26	2079.5	176681.0
2014-09-23 12:00:00	ES	Futures	2079.24	2080.28	2074.52	2075.31	88015.0
2014-09-23 13:00:00	ES	Futures	2075.04	2077.14	2071.64	2072.42	148264.0
2014-09-23 14:00:00	ES	Futures	2072.42	2074.52	2070.07	2072.95	138257.0
2014-09-23 15:00:00	ES	Futures	2072.95	2075.83	2069.28	2069.8	226424.0
2014-09-23 16:00:00	ES	Futures	2069.54	2070.07	2062.47	2062.99	158398.0
2014-09-23 17:00:00	ES	Futures	2062.99	2064.3	2062.47	2064.04	5356.0
2014-09-23 18:00:00	ES	Futures	2064.04	2066.92	2063.78	2066.66	9001.0
2014-09-23 19:00:00	ES	Futures	2066.66	2067.71	2066.14	2067.71	4393.0
2014-09-23 20:00:00	ES	Futures	2067.71	2068.49	2067.18	2068.49	10271.0
2014-09-23 21:00:00	ES	Futures	2068.49	2069.54	2068.23	2069.54	6831.0
2014-09-23 22:00:00	ES	Futures	2069.54	2070.07	2069.02	2069.8	5311.0
2014-09-23 23:00:00	ES	Futures	2070.07	2070.07	2068.23	2069.02	4413.0
2014-09-23 00:00:00	NQ	Futures	4751.09	4751.09	4749.04	4749.62	235.0
2014-09-23 01:00:00	NQ	Futures	4749.62	4750.5	4749.62	4750.21	259.0
2014-09-23 02:00:00	NQ	Futures	4750.21	4750.79	4746.69	4746.99	976.0
2014-09-23 03:00:00	NQ	Futures	4746.99	4747.57	4732.63	4733.51	5794.0
2014-09-23 04:00:00	NQ	Futures	4732.92	4735.56	4727.06	4732.34	5403.0
2014-09-23 05:00:00	NQ	Futures	4732.34	4733.8	4726.48	4732.34	4038.0
2014-09-23 06:00:00	NQ	Futures	4732.63	4735.85	4730.28	4735.85	2597.0
2014-09-23 07:00:00	NQ	Futures	4735.85	4738.2	4729.7	4731.75	5173.0
2014-09-23 08:00:00	NQ	Futures	4731.75	4739.37	4727.65	4738.2	7075.0
2014-09-23 09:00:00	NQ	Futures	4738.2	4754.6	4728.23	4752.85	43304.0
2014-09-23 10:00:00	NQ	Futures	4752.85	4759.58	4740.54	4746.69	48782.0
2014-09-23 11:00:00	NQ	Futures	4746.99	4758.41	4741.13	4754.9	30560.0
2014-09-23 12:00:00	NQ	Futures	4754.9	4756.95	4747.86	4749.33	18686.0
2014-09-23 13:00:00	NQ	Futures	4749.04	4754.31	4739.07	4742.59	27212.0
2014-09-23 14:00:00	NQ	Futures	4742.59	4748.16	4737.61	4742.88	27212.0
2014-09-23 15:00:00	NQ	Futures	4742.59	4754.02	4737.61	4738.78	33277.0
2014-09-23 16:00:00	NQ	Futures	4738.78	4738.78	4720.62	4721.79	12196.0
2014-09-23 17:00:00	NQ	Futures	4722.37	4724.42	4720.32	4723.55	444.0
2014-09-23 18:00:00	NQ	Futures	4725.3	4733.51	4724.42	4732.92	1951.0
2014-09-23 19:00:00	NQ	Futures	4733.21	4734.09	4731.75	4733.8	914.0
2014-09-23 20:00:00	NQ	Futures	4733.8	4734.97	4732.63	4734.39	1449.0
2014-09-23 21:00:00	NQ	Futures	4734.39	4735.85	4733.8	4735.56	859.0
2014-09-23 22:00:00	NQ	Futures	4735.56	4738.49	4735.56	4738.49	844.0
2014-09-23 23:00:00	NQ	Futures	4738.49	4739.07	4734.68	4736.73	730.0
2014-09-23 00:00:00	YM	Futures	17787.2	17787.2	17782.0	17783.1	238.0
2014-09-23 01:00:00	YM	Futures	17783.1	17791.4	17783.1	17791.4	488.0

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

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