PREVIEW / futures_1hour / 2015-03-27

all futures 1-hour files

  file:    by_date/futures_1hour/2015/2015-03-27.parquet
  size:    44 KB
  rows:    1,283

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-03-27 00:00:00	ES	Futures	2172.9	2173.69	2168.67	2169.73	5727.0
2015-03-27 01:00:00	ES	Futures	2169.46	2171.05	2166.82	2169.73	5946.0
2015-03-27 02:00:00	ES	Futures	2169.99	2170.52	2167.09	2168.94	3136.0
2015-03-27 03:00:00	ES	Futures	2168.94	2169.2	2165.24	2167.35	7339.0
2015-03-27 04:00:00	ES	Futures	2167.35	2169.2	2162.6	2163.39	20636.0
2015-03-27 05:00:00	ES	Futures	2163.39	2164.18	2156.26	2157.31	20559.0
2015-03-27 06:00:00	ES	Futures	2157.58	2162.33	2156.79	2160.48	22587.0
2015-03-27 07:00:00	ES	Futures	2160.48	2164.45	2160.22	2162.86	20842.0
2015-03-27 08:00:00	ES	Futures	2162.6	2164.18	2159.96	2162.33	25207.0
2015-03-27 09:00:00	ES	Futures	2162.07	2167.88	2159.16	2166.82	158366.0
2015-03-27 10:00:00	ES	Futures	2166.56	2170.52	2159.43	2169.73	204867.0
2015-03-27 11:00:00	ES	Futures	2169.73	2170.78	2163.39	2166.82	133841.0
2015-03-27 12:00:00	ES	Futures	2166.82	2167.61	2163.12	2167.09	94980.0
2015-03-27 13:00:00	ES	Futures	2167.35	2167.88	2163.65	2166.56	75114.0
2015-03-27 14:00:00	ES	Futures	2166.56	2167.88	2164.45	2166.29	55199.0
2015-03-27 15:00:00	ES	Futures	2166.29	2170.78	2164.45	2167.88	204814.0
2015-03-27 16:00:00	ES	Futures	2168.14	2169.2	2166.82	2167.61	64273.0
2015-03-27 17:00:00	ES	Futures	2167.88	2168.41	2167.35	2168.14	1269.0
2015-03-27 00:00:00	NQ	Futures	5088.77	5091.42	5079.65	5082.3	1432.0
2015-03-27 01:00:00	NQ	Futures	5081.42	5084.36	5073.77	5079.95	1579.0
2015-03-27 02:00:00	NQ	Futures	5079.95	5081.71	5074.65	5078.77	582.0
2015-03-27 03:00:00	NQ	Futures	5078.48	5078.48	5070.83	5075.24	1283.0
2015-03-27 04:00:00	NQ	Futures	5075.24	5079.95	5065.83	5067.01	3611.0
2015-03-27 05:00:00	NQ	Futures	5066.71	5068.77	5054.66	5056.72	3704.0
2015-03-27 06:00:00	NQ	Futures	5056.13	5068.48	5054.95	5065.24	3419.0
2015-03-27 07:00:00	NQ	Futures	5065.24	5073.77	5064.95	5069.95	2744.0
2015-03-27 08:00:00	NQ	Futures	5069.66	5071.71	5060.83	5064.07	4746.0
2015-03-27 09:00:00	NQ	Futures	5064.07	5087.3	5057.89	5080.83	35725.0
2015-03-27 10:00:00	NQ	Futures	5080.54	5090.24	5056.42	5086.12	42674.0
2015-03-27 11:00:00	NQ	Futures	5086.12	5090.24	5067.6	5073.77	19592.0
2015-03-27 12:00:00	NQ	Futures	5074.07	5076.12	5064.66	5074.07	16194.0
2015-03-27 13:00:00	NQ	Futures	5074.65	5077.3	5066.13	5073.48	12432.0
2015-03-27 14:00:00	NQ	Futures	5073.48	5076.42	5067.3	5072.89	9724.0
2015-03-27 15:00:00	NQ	Futures	5072.89	5097.3	5069.95	5085.53	38705.0
2015-03-27 16:00:00	NQ	Futures	5085.83	5089.95	5083.18	5085.83	5453.0
2015-03-27 17:00:00	NQ	Futures	5086.12	5088.18	5085.24	5085.83	97.0
2015-03-27 00:00:00	YM	Futures	18517.4	18538.3	18490.1	18499.5	2530.0
2015-03-27 01:00:00	YM	Futures	18497.4	18509.0	18477.5	18499.5	1593.0
2015-03-27 02:00:00	YM	Futures	18499.5	18503.7	18475.4	18490.1	758.0
2015-03-27 03:00:00	YM	Futures	18489.0	18489.0	18463.9	18481.7	965.0
2015-03-27 04:00:00	YM	Futures	18480.7	18499.5	18445.0	18451.3	3778.0
2015-03-27 05:00:00	YM	Futures	18449.2	18455.5	18398.9	18406.2	4195.0
2015-03-27 06:00:00	YM	Futures	18407.2	18445.0	18404.1	18426.1	3642.0
2015-03-27 07:00:00	YM	Futures	18426.1	18453.4	18425.1	18440.8	2155.0
2015-03-27 08:00:00	YM	Futures	18439.8	18450.2	18416.7	18431.4	3376.0
2015-03-27 09:00:00	YM	Futures	18431.4	18476.5	18407.2	18454.4	16082.0
2015-03-27 10:00:00	YM	Futures	18454.4	18492.2	18388.4	18489.0	19961.0
2015-03-27 11:00:00	YM	Futures	18489.0	18495.3	18427.2	18455.5	10474.0
2015-03-27 12:00:00	YM	Futures	18455.5	18467.0	18431.4	18460.7	8189.0
2015-03-27 13:00:00	YM	Futures	18461.8	18471.2	18435.6	18461.8	6646.0

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

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