PREVIEW / futures_1hour / 2015-02-20

all futures 1-hour files

  file:    by_date/futures_1hour/2015/2015-02-20.parquet
  size:    45 KB
  rows:    1,285

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-02-20 00:00:00	ES	Futures	2204.42	2204.95	2204.16	2204.16	763.0
2015-02-20 01:00:00	ES	Futures	2204.42	2205.48	2203.9	2205.21	1061.0
2015-02-20 02:00:00	ES	Futures	2205.21	2205.48	2202.58	2203.63	5085.0
2015-02-20 03:00:00	ES	Futures	2203.63	2204.95	2202.58	2203.37	6951.0
2015-02-20 04:00:00	ES	Futures	2203.37	2204.42	2203.37	2203.63	5217.0
2015-02-20 05:00:00	ES	Futures	2203.9	2207.05	2202.58	2206.0	16991.0
2015-02-20 06:00:00	ES	Futures	2206.0	2206.79	2204.95	2206.0	7017.0
2015-02-20 07:00:00	ES	Futures	2206.0	2208.9	2199.95	2201.27	49154.0
2015-02-20 08:00:00	ES	Futures	2201.27	2202.05	2198.9	2201.53	47147.0
2015-02-20 09:00:00	ES	Futures	2201.79	2203.63	2192.05	2193.37	266785.0
2015-02-20 10:00:00	ES	Futures	2193.11	2203.37	2191.79	2201.53	222274.0
2015-02-20 11:00:00	ES	Futures	2201.53	2203.37	2200.21	2202.58	148265.0
2015-02-20 12:00:00	ES	Futures	2202.58	2208.63	2201.53	2206.27	221039.0
2015-02-20 13:00:00	ES	Futures	2206.27	2213.9	2205.48	2213.37	164745.0
2015-02-20 14:00:00	ES	Futures	2213.37	2215.74	2211.79	2215.21	138660.0
2015-02-20 15:00:00	ES	Futures	2215.48	2219.69	2215.48	2218.9	234456.0
2015-02-20 16:00:00	ES	Futures	2218.9	2219.42	2217.32	2218.63	75467.0
2015-02-20 17:00:00	ES	Futures	2218.37	2218.63	2217.84	2218.11	1268.0
2015-02-20 00:00:00	NQ	Futures	5185.07	5186.83	5185.07	5185.36	151.0
2015-02-20 01:00:00	NQ	Futures	5185.66	5188.59	5184.77	5187.71	206.0
2015-02-20 02:00:00	NQ	Futures	5186.83	5186.83	5181.25	5184.19	549.0
2015-02-20 03:00:00	NQ	Futures	5183.89	5187.42	5181.54	5184.48	1497.0
2015-02-20 04:00:00	NQ	Futures	5184.48	5186.83	5184.19	5185.66	1219.0
2015-02-20 05:00:00	NQ	Futures	5185.95	5195.64	5183.89	5193.59	3401.0
2015-02-20 06:00:00	NQ	Futures	5193.59	5194.47	5191.24	5192.41	1571.0
2015-02-20 07:00:00	NQ	Futures	5192.12	5198.58	5179.19	5182.13	10458.0
2015-02-20 08:00:00	NQ	Futures	5182.13	5184.19	5176.26	5183.6	7222.0
2015-02-20 09:00:00	NQ	Futures	5183.89	5185.95	5164.22	5169.21	44262.0
2015-02-20 10:00:00	NQ	Futures	5169.21	5193.0	5165.39	5188.3	33307.0
2015-02-20 11:00:00	NQ	Futures	5188.01	5193.0	5183.6	5186.83	18250.0
2015-02-20 12:00:00	NQ	Futures	5186.83	5196.82	5185.66	5193.88	29339.0
2015-02-20 13:00:00	NQ	Futures	5193.59	5208.56	5192.41	5207.39	22288.0
2015-02-20 14:00:00	NQ	Futures	5207.39	5212.97	5204.75	5211.21	19936.0
2015-02-20 15:00:00	NQ	Futures	5211.5	5221.78	5211.5	5217.67	31440.0
2015-02-20 16:00:00	NQ	Futures	5217.96	5218.55	5213.85	5216.79	5179.0
2015-02-20 17:00:00	NQ	Futures	5217.37	5217.67	5215.91	5217.37	148.0
2015-02-20 00:00:00	YM	Futures	18739.7	18743.9	18736.6	18736.6	100.0
2015-02-20 01:00:00	YM	Futures	18738.6	18748.0	18736.6	18747.0	184.0
2015-02-20 02:00:00	YM	Futures	18747.0	18747.0	18731.3	18737.6	966.0
2015-02-20 03:00:00	YM	Futures	18737.6	18750.1	18729.2	18737.6	1799.0
2015-02-20 04:00:00	YM	Futures	18736.6	18744.9	18735.5	18738.6	1056.0
2015-02-20 05:00:00	YM	Futures	18739.7	18767.9	18731.3	18759.5	3071.0
2015-02-20 06:00:00	YM	Futures	18758.5	18765.8	18752.2	18761.6	1397.0
2015-02-20 07:00:00	YM	Futures	18760.6	18787.7	18713.6	18723.0	9796.0
2015-02-20 08:00:00	YM	Futures	18721.9	18728.2	18701.1	18723.0	6511.0
2015-02-20 09:00:00	YM	Futures	18723.0	18731.3	18636.3	18646.8	26072.0
2015-02-20 10:00:00	YM	Futures	18646.8	18761.6	18637.4	18742.8	23956.0
2015-02-20 11:00:00	YM	Futures	18741.8	18774.1	18735.5	18763.7	11889.0
2015-02-20 12:00:00	YM	Futures	18763.7	18808.6	18749.1	18794.0	22266.0
2015-02-20 13:00:00	YM	Futures	18794.0	18873.3	18786.7	18869.1	15575.0

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

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