PREVIEW / futures_1hour / 2014-11-21

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-11-21.parquet
  size:    44 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-11-21 00:00:00	ES	Futures	2151.01	2152.06	2150.75	2151.8	3597.0
2014-11-21 01:00:00	ES	Futures	2151.8	2153.9	2151.54	2153.37	4566.0
2014-11-21 02:00:00	ES	Futures	2153.63	2154.16	2153.11	2153.9	6586.0
2014-11-21 03:00:00	ES	Futures	2153.63	2157.83	2152.85	2157.56	29773.0
2014-11-21 04:00:00	ES	Futures	2157.56	2158.09	2155.99	2156.52	11424.0
2014-11-21 05:00:00	ES	Futures	2156.52	2166.99	2155.47	2163.06	57734.0
2014-11-21 06:00:00	ES	Futures	2163.06	2165.95	2161.23	2163.59	32395.0
2014-11-21 07:00:00	ES	Futures	2163.59	2168.04	2162.54	2167.26	45129.0
2014-11-21 08:00:00	ES	Futures	2167.26	2170.14	2166.21	2168.04	69123.0
2014-11-21 09:00:00	ES	Futures	2168.04	2171.45	2166.47	2168.04	254317.0
2014-11-21 10:00:00	ES	Futures	2168.04	2168.3	2163.33	2164.37	209547.0
2014-11-21 11:00:00	ES	Futures	2164.11	2164.64	2160.97	2162.02	170377.0
2014-11-21 12:00:00	ES	Futures	2161.75	2162.8	2157.56	2158.35	128883.0
2014-11-21 13:00:00	ES	Futures	2158.35	2159.14	2153.11	2157.56	158103.0
2014-11-21 14:00:00	ES	Futures	2157.83	2159.14	2154.16	2157.56	118795.0
2014-11-21 15:00:00	ES	Futures	2157.56	2161.75	2157.3	2160.44	198311.0
2014-11-21 16:00:00	ES	Futures	2160.44	2161.75	2159.66	2160.18	90537.0
2014-11-21 17:00:00	ES	Futures	2160.44	2160.97	2160.18	2160.44	2011.0
2014-11-21 00:00:00	NQ	Futures	4977.29	4980.8	4977.29	4979.34	858.0
2014-11-21 01:00:00	NQ	Futures	4979.34	4983.73	4979.34	4982.86	555.0
2014-11-21 02:00:00	NQ	Futures	4983.15	4985.49	4981.1	4982.56	1013.0
2014-11-21 03:00:00	NQ	Futures	4982.27	4991.94	4979.93	4991.65	3628.0
2014-11-21 04:00:00	NQ	Futures	4991.35	4992.23	4988.13	4989.89	1918.0
2014-11-21 05:00:00	NQ	Futures	4990.18	5014.5	4988.13	5007.17	10960.0
2014-11-21 06:00:00	NQ	Futures	5007.17	5013.91	5003.66	5008.93	5360.0
2014-11-21 07:00:00	NQ	Futures	5008.35	5013.91	5006.59	5012.74	5260.0
2014-11-21 08:00:00	NQ	Futures	5012.45	5020.65	5010.98	5014.5	10163.0
2014-11-21 09:00:00	NQ	Futures	5014.79	5021.53	5003.37	5006.59	57528.0
2014-11-21 10:00:00	NQ	Futures	5006.59	5009.52	4988.42	4994.87	40810.0
2014-11-21 11:00:00	NQ	Futures	4994.87	4998.38	4983.73	4989.59	30678.0
2014-11-21 12:00:00	NQ	Futures	4989.59	4995.16	4983.15	4985.49	21725.0
2014-11-21 13:00:00	NQ	Futures	4985.2	4987.54	4966.45	4981.1	34273.0
2014-11-21 14:00:00	NQ	Futures	4981.1	4985.79	4967.91	4979.63	20518.0
2014-11-21 15:00:00	NQ	Futures	4979.93	4986.66	4976.41	4982.86	26161.0
2014-11-21 16:00:00	NQ	Futures	4982.86	4986.08	4979.05	4980.51	9136.0
2014-11-21 17:00:00	NQ	Futures	4980.51	4981.39	4979.93	4980.22	179.0
2014-11-21 00:00:00	YM	Futures	18403.8	18411.1	18401.7	18406.9	919.0
2014-11-21 01:00:00	YM	Futures	18408.0	18423.6	18406.9	18419.4	797.0
2014-11-21 02:00:00	YM	Futures	18420.4	18430.8	18419.4	18425.6	1489.0
2014-11-21 03:00:00	YM	Futures	18424.6	18464.1	18420.4	18461.0	5773.0
2014-11-21 04:00:00	YM	Futures	18460.0	18464.1	18444.4	18445.4	2865.0
2014-11-21 05:00:00	YM	Futures	18446.4	18539.0	18439.2	18507.8	11516.0
2014-11-21 06:00:00	YM	Futures	18507.8	18529.6	18495.3	18511.9	4245.0
2014-11-21 07:00:00	YM	Futures	18511.9	18541.1	18505.7	18536.9	5894.0
2014-11-21 08:00:00	YM	Futures	18537.9	18561.9	18531.7	18552.5	6631.0
2014-11-21 09:00:00	YM	Futures	18552.5	18580.6	18546.3	18559.8	18093.0
2014-11-21 10:00:00	YM	Futures	18559.8	18562.9	18529.6	18539.0	13890.0
2014-11-21 11:00:00	YM	Futures	18537.9	18537.9	18507.8	18515.1	10059.0
2014-11-21 12:00:00	YM	Futures	18515.1	18522.3	18471.4	18476.6	9044.0
2014-11-21 13:00:00	YM	Futures	18476.6	18485.9	18441.2	18480.8	10975.0

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

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