PREVIEW / futures_1hour / 2016-05-13

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-05-13.parquet
  size:    45 KB
  rows:    1,329

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
2016-05-13 00:00:00	ES	Futures	2216.81	2217.35	2215.73	2216.81	2390.0
2016-05-13 01:00:00	ES	Futures	2217.08	2217.62	2216.0	2216.27	3573.0
2016-05-13 02:00:00	ES	Futures	2216.27	2216.27	2213.03	2213.03	20131.0
2016-05-13 03:00:00	ES	Futures	2213.03	2218.43	2209.79	2215.46	60195.0
2016-05-13 04:00:00	ES	Futures	2215.19	2217.08	2211.95	2213.57	28383.0
2016-05-13 05:00:00	ES	Futures	2213.57	2216.0	2211.95	2214.11	20372.0
2016-05-13 06:00:00	ES	Futures	2214.38	2217.62	2213.3	2217.62	17879.0
2016-05-13 07:00:00	ES	Futures	2217.35	2219.24	2215.46	2215.46	20114.0
2016-05-13 08:00:00	ES	Futures	2215.46	2224.1	2215.46	2220.05	74423.0
2016-05-13 09:00:00	ES	Futures	2219.78	2228.41	2217.35	2221.67	242553.0
2016-05-13 10:00:00	ES	Futures	2221.67	2224.64	2215.46	2218.97	292405.0
2016-05-13 11:00:00	ES	Futures	2218.7	2227.33	2218.43	2221.4	184738.0
2016-05-13 12:00:00	ES	Futures	2221.4	2223.29	2216.27	2216.81	104537.0
2016-05-13 13:00:00	ES	Futures	2217.08	2218.97	2207.09	2209.52	200146.0
2016-05-13 14:00:00	ES	Futures	2209.25	2211.14	2201.42	2205.74	232876.0
2016-05-13 15:00:00	ES	Futures	2205.74	2208.44	2203.31	2205.47	233196.0
2016-05-13 16:00:00	ES	Futures	2205.74	2207.63	2204.93	2205.74	91533.0
2016-05-13 00:00:00	NQ	Futures	5141.31	5143.1	5138.34	5142.21	292.0
2016-05-13 01:00:00	NQ	Futures	5141.91	5143.69	5139.83	5140.12	378.0
2016-05-13 02:00:00	NQ	Futures	5139.53	5140.72	5132.39	5132.39	2128.0
2016-05-13 03:00:00	NQ	Futures	5132.09	5146.37	5121.97	5138.04	7912.0
2016-05-13 04:00:00	NQ	Futures	5137.74	5141.91	5129.71	5133.88	3564.0
2016-05-13 05:00:00	NQ	Futures	5133.88	5142.8	5129.71	5137.74	2369.0
2016-05-13 06:00:00	NQ	Futures	5137.15	5146.67	5135.36	5145.48	2229.0
2016-05-13 07:00:00	NQ	Futures	5145.18	5149.05	5139.83	5140.12	2255.0
2016-05-13 08:00:00	NQ	Futures	5139.83	5161.55	5139.23	5155.89	9801.0
2016-05-13 09:00:00	NQ	Futures	5155.59	5184.16	5149.94	5168.69	39999.0
2016-05-13 10:00:00	NQ	Futures	5168.69	5181.48	5155.89	5165.71	40365.0
2016-05-13 11:00:00	NQ	Futures	5165.41	5189.51	5165.12	5175.83	29038.0
2016-05-13 12:00:00	NQ	Futures	5175.53	5182.67	5159.76	5161.84	15989.0
2016-05-13 13:00:00	NQ	Futures	5162.14	5169.88	5143.4	5148.45	24226.0
2016-05-13 14:00:00	NQ	Futures	5148.16	5155.59	5132.98	5142.5	25938.0
2016-05-13 15:00:00	NQ	Futures	5142.5	5152.32	5137.15	5143.4	28833.0
2016-05-13 16:00:00	NQ	Futures	5143.69	5147.26	5142.5	5144.29	6993.0
2016-05-13 00:00:00	YM	Futures	18857.1	18864.6	18848.5	18860.3	595.0
2016-05-13 01:00:00	YM	Futures	18861.3	18865.6	18851.7	18852.8	787.0
2016-05-13 02:00:00	YM	Futures	18852.8	18853.8	18823.9	18823.9	2971.0
2016-05-13 03:00:00	YM	Futures	18823.9	18862.4	18793.9	18841.0	8736.0
2016-05-13 04:00:00	YM	Futures	18838.9	18849.6	18814.2	18826.0	4045.0
2016-05-13 05:00:00	YM	Futures	18827.1	18844.2	18813.2	18829.2	2925.0
2016-05-13 06:00:00	YM	Futures	18829.2	18853.8	18823.9	18852.8	1863.0
2016-05-13 07:00:00	YM	Futures	18851.7	18863.5	18832.4	18832.4	2106.0
2016-05-13 08:00:00	YM	Futures	18831.4	18898.8	18830.3	18868.8	8240.0
2016-05-13 09:00:00	YM	Futures	18867.8	18934.1	18852.8	18881.7	24665.0
2016-05-13 10:00:00	YM	Futures	18882.7	18904.2	18824.9	18851.7	27393.0
2016-05-13 11:00:00	YM	Futures	18851.7	18932.0	18850.6	18875.3	20538.0
2016-05-13 12:00:00	YM	Futures	18875.3	18887.0	18826.0	18831.4	10534.0
2016-05-13 13:00:00	YM	Futures	18831.4	18843.1	18747.9	18761.8	16624.0
2016-05-13 14:00:00	YM	Futures	18760.7	18774.6	18687.9	18725.4	22049.0
2016-05-13 15:00:00	YM	Futures	18724.3	18740.4	18708.3	18719.0	17664.0

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

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