PREVIEW / futures_1hour / 2014-01-31

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-01-31.parquet
  size:    45 KB
  rows:    1,288

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-01-31 00:00:00	ES	Futures	1838.77	1842.65	1837.99	1842.13	6510.0
2014-01-31 01:00:00	ES	Futures	1842.13	1843.68	1841.09	1842.13	4725.0
2014-01-31 02:00:00	ES	Futures	1842.13	1843.42	1841.35	1842.65	10088.0
2014-01-31 03:00:00	ES	Futures	1842.65	1842.65	1837.73	1839.8	39118.0
2014-01-31 04:00:00	ES	Futures	1839.54	1840.58	1833.85	1835.4	37108.0
2014-01-31 05:00:00	ES	Futures	1835.14	1835.66	1829.2	1832.82	50528.0
2014-01-31 06:00:00	ES	Futures	1832.56	1834.89	1825.06	1826.35	61537.0
2014-01-31 07:00:00	ES	Futures	1826.35	1833.59	1825.83	1828.94	61147.0
2014-01-31 08:00:00	ES	Futures	1828.94	1830.23	1822.21	1825.57	122038.0
2014-01-31 09:00:00	ES	Futures	1825.32	1833.85	1824.28	1830.49	301104.0
2014-01-31 10:00:00	ES	Futures	1830.49	1838.25	1828.94	1835.66	364370.0
2014-01-31 11:00:00	ES	Futures	1835.4	1843.94	1834.37	1842.9	275175.0
2014-01-31 12:00:00	ES	Futures	1842.9	1845.75	1839.02	1842.13	169880.0
2014-01-31 13:00:00	ES	Futures	1842.39	1847.56	1838.77	1847.56	152810.0
2014-01-31 14:00:00	ES	Futures	1847.56	1850.15	1845.49	1846.53	165613.0
2014-01-31 15:00:00	ES	Futures	1846.53	1846.53	1835.92	1837.73	383725.0
2014-01-31 16:00:00	ES	Futures	1837.73	1841.87	1837.47	1837.99	134778.0
2014-01-31 17:00:00	ES	Futures	1837.99	1838.77	1837.73	1838.51	3121.0
2014-01-31 00:00:00	NQ	Futures	4079.76	4087.32	4077.14	4086.45	919.0
2014-01-31 01:00:00	NQ	Futures	4086.45	4089.06	4083.83	4085.28	602.0
2014-01-31 02:00:00	NQ	Futures	4085.57	4088.19	4082.96	4087.03	829.0
2014-01-31 03:00:00	NQ	Futures	4086.74	4087.03	4073.66	4080.05	5386.0
2014-01-31 04:00:00	NQ	Futures	4080.05	4082.09	4066.97	4069.59	4815.0
2014-01-31 05:00:00	NQ	Futures	4069.59	4069.59	4054.47	4062.03	6975.0
2014-01-31 06:00:00	NQ	Futures	4061.74	4069.3	4047.49	4049.53	8446.0
2014-01-31 07:00:00	NQ	Futures	4049.53	4064.94	4047.49	4056.8	8955.0
2014-01-31 08:00:00	NQ	Futures	4056.8	4062.32	4045.46	4053.02	16916.0
2014-01-31 09:00:00	NQ	Futures	4053.02	4067.26	4048.37	4061.74	45636.0
2014-01-31 10:00:00	NQ	Futures	4062.03	4075.98	4055.34	4069.0	51220.0
2014-01-31 11:00:00	NQ	Futures	4069.3	4085.86	4066.68	4085.57	34879.0
2014-01-31 12:00:00	NQ	Futures	4085.57	4095.46	4082.38	4091.68	30800.0
2014-01-31 13:00:00	NQ	Futures	4091.68	4102.14	4082.96	4102.14	24531.0
2014-01-31 14:00:00	NQ	Futures	4101.85	4107.67	4095.46	4097.78	24537.0
2014-01-31 15:00:00	NQ	Futures	4097.78	4097.78	4080.63	4085.28	46501.0
2014-01-31 16:00:00	NQ	Futures	4085.57	4096.62	4085.28	4086.74	8751.0
2014-01-31 17:00:00	NQ	Futures	4087.03	4087.32	4086.16	4087.32	132.0
2014-01-31 00:00:00	YM	Futures	16093.7	16124.5	16089.6	16122.4	1188.0
2014-01-31 01:00:00	YM	Futures	16121.4	16132.7	16114.2	16122.4	504.0
2014-01-31 02:00:00	YM	Futures	16121.4	16132.7	16113.2	16126.5	904.0
2014-01-31 03:00:00	YM	Futures	16126.5	16126.5	16082.4	16099.9	5122.0
2014-01-31 04:00:00	YM	Futures	16100.9	16109.1	16057.8	16065.0	4301.0
2014-01-31 05:00:00	YM	Futures	16064.0	16064.0	16014.7	16041.4	6624.0
2014-01-31 06:00:00	YM	Futures	16041.4	16054.7	15978.9	15986.0	7567.0
2014-01-31 07:00:00	YM	Futures	15987.1	16040.4	15980.9	16001.4	9120.0
2014-01-31 08:00:00	YM	Futures	16002.4	16013.7	15945.0	15969.6	14653.0
2014-01-31 09:00:00	YM	Futures	15968.6	16012.7	15954.2	15969.6	31022.0
2014-01-31 10:00:00	YM	Futures	15970.7	16033.2	15947.1	16012.7	34135.0
2014-01-31 11:00:00	YM	Futures	16011.7	16090.6	16000.4	16075.2	24028.0
2014-01-31 12:00:00	YM	Futures	16077.3	16107.0	16040.4	16072.2	17808.0
2014-01-31 13:00:00	YM	Futures	16072.2	16120.4	16045.5	16118.3	14288.0

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

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