PREVIEW / futures_1hour / 2015-05-05

all futures 1-hour files

  file:    by_date/futures_1hour/2015/2015-05-05.parquet
  size:    53 KB
  rows:    1,605

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-05-05 00:00:00	ES	Futures	2225.72	2227.04	2225.46	2226.25	1986.0
2015-05-05 01:00:00	ES	Futures	2226.25	2227.04	2225.46	2225.98	1516.0
2015-05-05 02:00:00	ES	Futures	2225.98	2227.57	2225.19	2225.72	5337.0
2015-05-05 03:00:00	ES	Futures	2225.46	2226.25	2223.34	2224.93	18165.0
2015-05-05 04:00:00	ES	Futures	2224.93	2231.0	2223.87	2225.46	22859.0
2015-05-05 05:00:00	ES	Futures	2225.72	2228.1	2224.4	2227.04	12051.0
2015-05-05 06:00:00	ES	Futures	2227.04	2227.83	2223.87	2224.93	11276.0
2015-05-05 07:00:00	ES	Futures	2224.93	2227.04	2223.61	2227.04	10875.0
2015-05-05 08:00:00	ES	Futures	2227.04	2228.1	2219.91	2220.97	46662.0
2015-05-05 09:00:00	ES	Futures	2220.97	2228.36	2219.12	2219.65	214672.0
2015-05-05 10:00:00	ES	Futures	2219.65	2222.29	2215.68	2218.33	254861.0
2015-05-05 11:00:00	ES	Futures	2218.06	2218.06	2207.5	2211.99	239545.0
2015-05-05 12:00:00	ES	Futures	2211.99	2215.16	2210.14	2210.67	98944.0
2015-05-05 13:00:00	ES	Futures	2210.4	2210.93	2203.8	2206.44	145832.0
2015-05-05 14:00:00	ES	Futures	2206.18	2208.55	2199.04	2201.16	184904.0
2015-05-05 15:00:00	ES	Futures	2201.16	2205.65	2199.04	2200.89	222578.0
2015-05-05 16:00:00	ES	Futures	2200.89	2203.8	2200.37	2203.27	83381.0
2015-05-05 17:00:00	ES	Futures	2203.01	2203.53	2202.74	2203.53	1941.0
2015-05-05 18:00:00	ES	Futures	2203.27	2204.86	2203.27	2204.59	3712.0
2015-05-05 19:00:00	ES	Futures	2204.59	2205.12	2203.27	2204.59	2784.0
2015-05-05 20:00:00	ES	Futures	2204.86	2205.38	2204.33	2204.59	3424.0
2015-05-05 21:00:00	ES	Futures	2204.86	2205.65	2203.8	2205.65	3156.0
2015-05-05 22:00:00	ES	Futures	2205.65	2206.7	2205.12	2206.44	2698.0
2015-05-05 23:00:00	ES	Futures	2206.7	2210.67	2206.18	2209.87	7908.0
2015-05-05 00:00:00	NQ	Futures	5258.15	5261.38	5256.68	5260.21	223.0
2015-05-05 01:00:00	NQ	Futures	5259.62	5261.09	5258.44	5258.74	190.0
2015-05-05 02:00:00	NQ	Futures	5258.44	5261.09	5255.5	5256.39	659.0
2015-05-05 03:00:00	NQ	Futures	5256.68	5257.86	5250.21	5252.56	2997.0
2015-05-05 04:00:00	NQ	Futures	5252.56	5269.91	5251.39	5254.62	4385.0
2015-05-05 05:00:00	NQ	Futures	5254.62	5264.91	5253.45	5262.27	2567.0
2015-05-05 06:00:00	NQ	Futures	5262.27	5263.15	5251.09	5253.45	2448.0
2015-05-05 07:00:00	NQ	Futures	5253.45	5257.86	5251.09	5256.68	1989.0
2015-05-05 08:00:00	NQ	Futures	5256.68	5258.74	5236.1	5239.62	8804.0
2015-05-05 09:00:00	NQ	Futures	5239.33	5253.15	5216.69	5217.57	47323.0
2015-05-05 10:00:00	NQ	Futures	5218.16	5224.63	5203.75	5215.8	58163.0
2015-05-05 11:00:00	NQ	Futures	5215.51	5215.51	5184.34	5201.4	43929.0
2015-05-05 12:00:00	NQ	Futures	5201.1	5208.45	5194.34	5196.98	20104.0
2015-05-05 13:00:00	NQ	Futures	5196.98	5197.87	5181.99	5187.28	25872.0
2015-05-05 14:00:00	NQ	Futures	5186.99	5195.81	5174.93	5183.46	37259.0
2015-05-05 15:00:00	NQ	Futures	5183.46	5195.51	5177.58	5179.34	40562.0
2015-05-05 16:00:00	NQ	Futures	5179.34	5189.34	5178.75	5187.57	6931.0
2015-05-05 17:00:00	NQ	Futures	5187.87	5188.75	5186.99	5187.87	166.0
2015-05-05 18:00:00	NQ	Futures	5186.1	5190.22	5186.1	5188.16	736.0
2015-05-05 19:00:00	NQ	Futures	5187.87	5189.34	5184.93	5188.16	432.0
2015-05-05 20:00:00	NQ	Futures	5188.46	5191.1	5187.87	5188.75	558.0
2015-05-05 21:00:00	NQ	Futures	5188.75	5192.87	5187.28	5192.57	508.0
2015-05-05 22:00:00	NQ	Futures	5192.87	5194.63	5190.52	5194.34	363.0
2015-05-05 23:00:00	NQ	Futures	5194.34	5203.16	5192.87	5202.28	1102.0
2015-05-05 00:00:00	YM	Futures	18851.9	18861.3	18847.7	18855.0	236.0
2015-05-05 01:00:00	YM	Futures	18855.0	18860.3	18849.8	18850.8	249.0

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

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