PREVIEW / futures_1hour / 2014-09-29

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-09-29.parquet
  size:    50 KB
  rows:    1,552

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-29 00:00:00	ES	Futures	2064.83	2065.87	2063.78	2065.35	3565.0
2014-09-29 01:00:00	ES	Futures	2065.35	2066.66	2063.78	2063.78	4758.0
2014-09-29 02:00:00	ES	Futures	2063.78	2065.09	2062.99	2064.56	10823.0
2014-09-29 03:00:00	ES	Futures	2064.3	2065.87	2060.37	2061.95	33048.0
2014-09-29 04:00:00	ES	Futures	2061.68	2063.78	2060.64	2062.47	20243.0
2014-09-29 05:00:00	ES	Futures	2062.73	2063.52	2060.37	2062.47	16235.0
2014-09-29 06:00:00	ES	Futures	2062.21	2063.26	2057.23	2059.33	25222.0
2014-09-29 07:00:00	ES	Futures	2059.06	2059.59	2055.66	2059.33	33404.0
2014-09-29 08:00:00	ES	Futures	2059.33	2059.59	2049.89	2050.94	87765.0
2014-09-29 09:00:00	ES	Futures	2050.94	2055.4	2049.11	2054.87	280831.0
2014-09-29 10:00:00	ES	Futures	2054.61	2063.52	2053.04	2061.16	286082.0
2014-09-29 11:00:00	ES	Futures	2061.16	2067.18	2059.85	2065.87	194332.0
2014-09-29 12:00:00	ES	Futures	2066.14	2066.14	2058.02	2061.16	146014.0
2014-09-29 13:00:00	ES	Futures	2061.16	2065.35	2059.06	2062.47	121223.0
2014-09-29 14:00:00	ES	Futures	2062.73	2064.56	2056.44	2062.21	140041.0
2014-09-29 15:00:00	ES	Futures	2061.95	2068.49	2061.42	2064.56	249899.0
2014-09-29 16:00:00	ES	Futures	2064.83	2064.83	2062.21	2062.73	89725.0
2014-09-29 17:00:00	ES	Futures	2062.73	2062.99	2062.47	2062.73	1042.0
2014-09-29 18:00:00	ES	Futures	2062.99	2063.52	2062.73	2062.99	2284.0
2014-09-29 19:00:00	ES	Futures	2062.99	2063.78	2062.73	2063.78	1170.0
2014-09-29 20:00:00	ES	Futures	2063.52	2063.78	2062.47	2062.47	3544.0
2014-09-29 21:00:00	ES	Futures	2062.73	2064.3	2062.21	2062.73	6541.0
2014-09-29 22:00:00	ES	Futures	2062.99	2063.78	2062.47	2063.52	5552.0
2014-09-29 23:00:00	ES	Futures	2063.52	2064.04	2062.73	2064.04	1566.0
2014-09-29 00:00:00	NQ	Futures	4730.28	4733.8	4729.11	4732.92	696.0
2014-09-29 01:00:00	NQ	Futures	4732.92	4736.44	4728.53	4728.53	542.0
2014-09-29 02:00:00	NQ	Futures	4729.11	4731.75	4725.3	4727.65	1814.0
2014-09-29 03:00:00	NQ	Futures	4727.65	4732.34	4716.81	4721.2	6407.0
2014-09-29 04:00:00	NQ	Futures	4720.62	4725.6	4717.69	4722.08	3352.0
2014-09-29 05:00:00	NQ	Futures	4722.08	4725.01	4717.39	4722.37	2859.0
2014-09-29 06:00:00	NQ	Futures	4722.08	4724.72	4710.36	4715.05	4476.0
2014-09-29 07:00:00	NQ	Futures	4715.05	4716.51	4705.96	4715.05	6749.0
2014-09-29 08:00:00	NQ	Futures	4715.34	4715.93	4688.09	4690.44	13062.0
2014-09-29 09:00:00	NQ	Futures	4690.73	4710.07	4685.75	4706.55	57831.0
2014-09-29 10:00:00	NQ	Futures	4705.67	4737.32	4700.4	4731.16	66289.0
2014-09-29 11:00:00	NQ	Futures	4730.87	4745.23	4727.35	4738.49	37156.0
2014-09-29 12:00:00	NQ	Futures	4738.49	4738.78	4715.93	4726.48	29036.0
2014-09-29 13:00:00	NQ	Futures	4726.77	4734.68	4721.49	4728.82	17381.0
2014-09-29 14:00:00	NQ	Futures	4728.82	4734.39	4713.58	4728.53	29884.0
2014-09-29 15:00:00	NQ	Futures	4728.53	4744.06	4726.77	4733.21	53162.0
2014-09-29 16:00:00	NQ	Futures	4733.21	4733.8	4725.89	4727.65	13577.0
2014-09-29 17:00:00	NQ	Futures	4727.65	4728.23	4727.06	4727.65	107.0
2014-09-29 18:00:00	NQ	Futures	4727.65	4730.58	4727.35	4728.82	329.0
2014-09-29 19:00:00	NQ	Futures	4729.11	4729.99	4727.94	4729.7	122.0
2014-09-29 20:00:00	NQ	Futures	4729.41	4729.7	4726.18	4726.77	664.0
2014-09-29 21:00:00	NQ	Futures	4726.77	4730.87	4726.18	4727.65	747.0
2014-09-29 22:00:00	NQ	Futures	4727.35	4729.7	4726.48	4728.82	685.0
2014-09-29 23:00:00	NQ	Futures	4728.53	4730.58	4727.35	4729.99	291.0
2014-09-29 00:00:00	YM	Futures	17657.3	17661.4	17650.0	17660.4	676.0
2014-09-29 01:00:00	YM	Futures	17660.4	17671.8	17653.1	17654.1	729.0

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

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