PREVIEW / futures_1hour / 2015-01-23

all futures 1-hour files

  file:    by_date/futures_1hour/2015/2015-01-23.parquet
  size:    45 KB
  rows:    1,301

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
2015-01-23 00:00:00	ES	Futures	2162.06	2162.58	2161.0	2161.0	2594.0
2015-01-23 01:00:00	ES	Futures	2161.27	2163.9	2161.0	2162.85	2066.0
2015-01-23 02:00:00	ES	Futures	2162.58	2165.21	2162.58	2164.16	9104.0
2015-01-23 03:00:00	ES	Futures	2163.9	2170.48	2162.06	2168.9	34313.0
2015-01-23 04:00:00	ES	Futures	2168.9	2169.16	2163.37	2166.53	18637.0
2015-01-23 05:00:00	ES	Futures	2166.53	2167.06	2163.11	2164.69	10451.0
2015-01-23 06:00:00	ES	Futures	2164.69	2168.11	2164.16	2166.0	11268.0
2015-01-23 07:00:00	ES	Futures	2166.27	2171.0	2164.69	2169.16	26804.0
2015-01-23 08:00:00	ES	Futures	2169.16	2169.95	2161.53	2161.53	49720.0
2015-01-23 09:00:00	ES	Futures	2161.79	2163.37	2156.27	2159.42	239714.0
2015-01-23 10:00:00	ES	Futures	2159.16	2163.37	2153.9	2161.27	243659.0
2015-01-23 11:00:00	ES	Futures	2161.0	2163.37	2157.85	2160.48	137838.0
2015-01-23 12:00:00	ES	Futures	2160.21	2165.48	2159.16	2163.63	111148.0
2015-01-23 13:00:00	ES	Futures	2163.63	2165.48	2159.95	2163.9	84970.0
2015-01-23 14:00:00	ES	Futures	2163.63	2164.69	2157.85	2157.85	86335.0
2015-01-23 15:00:00	ES	Futures	2157.85	2158.9	2151.53	2153.37	188707.0
2015-01-23 16:00:00	ES	Futures	2153.37	2153.9	2150.21	2150.74	68263.0
2015-01-23 17:00:00	ES	Futures	2151.0	2151.0	2149.69	2150.74	1864.0
2015-01-23 00:00:00	NQ	Futures	5003.86	5005.33	5001.51	5001.81	293.0
2015-01-23 01:00:00	NQ	Futures	5001.81	5008.56	5001.81	5006.51	224.0
2015-01-23 02:00:00	NQ	Futures	5005.92	5010.32	5005.63	5009.44	929.0
2015-01-23 03:00:00	NQ	Futures	5008.86	5022.37	5003.86	5017.67	5026.0
2015-01-23 04:00:00	NQ	Futures	5017.67	5018.25	5004.74	5012.38	2616.0
2015-01-23 05:00:00	NQ	Futures	5011.79	5014.44	5005.63	5009.15	1572.0
2015-01-23 06:00:00	NQ	Futures	5009.15	5016.49	5007.97	5010.62	1888.0
2015-01-23 07:00:00	NQ	Futures	5011.21	5021.19	5008.56	5017.08	4088.0
2015-01-23 08:00:00	NQ	Futures	5017.67	5020.31	5005.92	5007.39	6005.0
2015-01-23 09:00:00	NQ	Futures	5007.39	5016.79	4993.0	5015.32	46673.0
2015-01-23 10:00:00	NQ	Futures	5014.44	5022.07	4995.05	5011.79	40699.0
2015-01-23 11:00:00	NQ	Futures	5012.09	5022.66	5006.21	5015.32	20764.0
2015-01-23 12:00:00	NQ	Futures	5015.02	5028.83	5010.32	5025.89	21305.0
2015-01-23 13:00:00	NQ	Futures	5025.6	5035.29	5019.13	5032.35	16902.0
2015-01-23 14:00:00	NQ	Futures	5032.06	5034.11	5015.32	5017.37	15840.0
2015-01-23 15:00:00	NQ	Futures	5017.67	5022.37	5009.74	5019.13	30990.0
2015-01-23 16:00:00	NQ	Futures	5019.13	5021.19	5009.15	5011.21	5785.0
2015-01-23 17:00:00	NQ	Futures	5010.91	5011.5	5009.44	5009.44	119.0
2015-01-23 00:00:00	YM	Futures	18501.7	18505.9	18495.4	18495.4	508.0
2015-01-23 01:00:00	YM	Futures	18494.4	18518.4	18493.3	18506.9	322.0
2015-01-23 02:00:00	YM	Futures	18505.9	18536.1	18505.9	18522.6	1106.0
2015-01-23 03:00:00	YM	Futures	18523.6	18575.8	18507.9	18563.3	5878.0
2015-01-23 04:00:00	YM	Futures	18563.3	18564.3	18520.5	18542.4	2768.0
2015-01-23 05:00:00	YM	Futures	18542.4	18546.6	18512.1	18525.7	1770.0
2015-01-23 06:00:00	YM	Futures	18526.7	18557.0	18521.5	18543.4	2035.0
2015-01-23 07:00:00	YM	Futures	18543.4	18570.6	18529.9	18551.8	5156.0
2015-01-23 08:00:00	YM	Futures	18552.8	18565.4	18503.8	18506.9	5031.0
2015-01-23 09:00:00	YM	Futures	18506.9	18523.6	18444.3	18468.3	27573.0
2015-01-23 10:00:00	YM	Futures	18471.4	18504.8	18427.6	18483.9	22147.0
2015-01-23 11:00:00	YM	Futures	18483.9	18494.4	18453.7	18463.1	10819.0
2015-01-23 12:00:00	YM	Futures	18461.0	18512.1	18457.8	18497.5	9315.0
2015-01-23 13:00:00	YM	Futures	18497.5	18507.9	18467.2	18497.5	7224.0

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

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