PREVIEW / futures_1hour / 2014-10-06

all futures 1-hour files

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

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-06 00:00:00	ES	Futures	2059.85	2059.85	2059.33	2059.59	432.0
2014-10-06 01:00:00	ES	Futures	2059.59	2060.11	2058.8	2059.59	2171.0
2014-10-06 02:00:00	ES	Futures	2059.85	2064.83	2059.06	2061.68	22011.0
2014-10-06 03:00:00	ES	Futures	2061.68	2061.68	2059.33	2061.68	28905.0
2014-10-06 04:00:00	ES	Futures	2061.42	2063.78	2061.42	2062.47	22404.0
2014-10-06 05:00:00	ES	Futures	2062.47	2062.47	2058.02	2058.8	18329.0
2014-10-06 06:00:00	ES	Futures	2058.8	2061.68	2058.54	2060.9	12201.0
2014-10-06 07:00:00	ES	Futures	2061.16	2062.47	2059.59	2060.64	17392.0
2014-10-06 08:00:00	ES	Futures	2060.64	2064.04	2059.85	2061.95	35970.0
2014-10-06 09:00:00	ES	Futures	2061.95	2065.35	2061.42	2062.21	180524.0
2014-10-06 10:00:00	ES	Futures	2061.95	2064.04	2053.04	2054.61	303169.0
2014-10-06 11:00:00	ES	Futures	2054.61	2057.75	2045.7	2048.32	302242.0
2014-10-06 12:00:00	ES	Futures	2048.32	2051.99	2043.87	2045.97	199014.0
2014-10-06 13:00:00	ES	Futures	2045.7	2053.3	2043.87	2052.25	166272.0
2014-10-06 14:00:00	ES	Futures	2052.25	2055.92	2048.85	2053.04	136316.0
2014-10-06 15:00:00	ES	Futures	2053.04	2054.87	2049.37	2050.94	180707.0
2014-10-06 16:00:00	ES	Futures	2051.2	2052.51	2046.23	2047.8	68917.0
2014-10-06 17:00:00	ES	Futures	2047.8	2047.8	2047.01	2047.01	1455.0
2014-10-06 18:00:00	ES	Futures	2046.75	2048.06	2046.49	2047.28	3918.0
2014-10-06 19:00:00	ES	Futures	2047.54	2048.06	2047.01	2048.06	3046.0
2014-10-06 20:00:00	ES	Futures	2048.06	2048.32	2047.28	2047.28	3571.0
2014-10-06 21:00:00	ES	Futures	2047.54	2048.32	2047.28	2048.32	2177.0
2014-10-06 22:00:00	ES	Futures	2048.06	2049.89	2047.8	2049.89	4436.0
2014-10-06 23:00:00	ES	Futures	2049.63	2049.89	2048.06	2048.85	2311.0
2014-10-06 00:00:00	NQ	Futures	4720.91	4721.49	4720.03	4720.91	131.0
2014-10-06 01:00:00	NQ	Futures	4720.91	4721.79	4718.56	4720.32	476.0
2014-10-06 02:00:00	NQ	Futures	4720.32	4733.51	4719.15	4726.77	2164.0
2014-10-06 03:00:00	NQ	Futures	4726.77	4726.77	4720.62	4725.01	5341.0
2014-10-06 04:00:00	NQ	Futures	4725.3	4730.87	4725.3	4727.06	2982.0
2014-10-06 05:00:00	NQ	Futures	4727.35	4727.35	4716.81	4718.86	2755.0
2014-10-06 06:00:00	NQ	Futures	4718.56	4725.3	4718.56	4723.84	2131.0
2014-10-06 07:00:00	NQ	Futures	4724.13	4726.18	4718.27	4720.03	5251.0
2014-10-06 08:00:00	NQ	Futures	4720.32	4727.35	4717.98	4720.62	7876.0
2014-10-06 09:00:00	NQ	Futures	4720.32	4735.56	4720.03	4727.35	46908.0
2014-10-06 10:00:00	NQ	Futures	4727.65	4733.21	4700.98	4707.14	61093.0
2014-10-06 11:00:00	NQ	Futures	4707.43	4713.29	4684.28	4693.95	54555.0
2014-10-06 12:00:00	NQ	Futures	4693.66	4703.62	4683.7	4689.56	37790.0
2014-10-06 13:00:00	NQ	Futures	4689.26	4706.26	4685.16	4701.28	27215.0
2014-10-06 14:00:00	NQ	Futures	4700.98	4711.24	4693.95	4703.62	25191.0
2014-10-06 15:00:00	NQ	Futures	4703.62	4707.72	4693.37	4699.52	39622.0
2014-10-06 16:00:00	NQ	Futures	4699.52	4703.33	4687.8	4692.19	11709.0
2014-10-06 17:00:00	NQ	Futures	4692.19	4692.49	4690.44	4691.02	143.0
2014-10-06 18:00:00	NQ	Futures	4689.85	4692.78	4689.85	4691.31	471.0
2014-10-06 19:00:00	NQ	Futures	4691.31	4693.37	4689.56	4692.78	317.0
2014-10-06 20:00:00	NQ	Futures	4693.37	4693.66	4691.02	4691.9	472.0
2014-10-06 21:00:00	NQ	Futures	4691.61	4694.54	4691.31	4694.24	457.0
2014-10-06 22:00:00	NQ	Futures	4693.95	4699.81	4693.37	4699.81	890.0
2014-10-06 23:00:00	NQ	Futures	4699.81	4700.1	4695.42	4698.64	527.0
2014-10-06 00:00:00	YM	Futures	17642.7	17644.8	17639.6	17643.7	184.0
2014-10-06 01:00:00	YM	Futures	17643.7	17644.8	17636.5	17641.7	379.0

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

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