PREVIEW / futures_1hour / 2015-06-04

all futures 1-hour files

  file:    by_date/futures_1hour/2015/2015-06-04.parquet
  size:    51 KB
  rows:    1,542

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-06-04 00:00:00	ES	Futures	2232.06	2232.85	2231.8	2232.06	1322.0
2015-06-04 01:00:00	ES	Futures	2232.06	2232.06	2228.63	2231.27	8071.0
2015-06-04 02:00:00	ES	Futures	2231.27	2232.85	2229.42	2232.32	8105.0
2015-06-04 03:00:00	ES	Futures	2232.32	2232.32	2221.76	2222.02	38150.0
2015-06-04 04:00:00	ES	Futures	2222.02	2224.4	2218.33	2222.82	51843.0
2015-06-04 05:00:00	ES	Futures	2222.82	2224.66	2220.44	2222.02	22010.0
2015-06-04 06:00:00	ES	Futures	2222.02	2223.61	2219.91	2223.08	19201.0
2015-06-04 07:00:00	ES	Futures	2223.08	2225.72	2219.91	2225.46	40366.0
2015-06-04 08:00:00	ES	Futures	2225.72	2227.83	2222.82	2225.72	42004.0
2015-06-04 09:00:00	ES	Futures	2225.98	2227.31	2218.33	2226.51	272718.0
2015-06-04 10:00:00	ES	Futures	2226.25	2231.0	2220.7	2221.49	219368.0
2015-06-04 11:00:00	ES	Futures	2221.23	2223.61	2215.68	2218.33	223974.0
2015-06-04 12:00:00	ES	Futures	2218.06	2220.7	2217.0	2217.27	98016.0
2015-06-04 13:00:00	ES	Futures	2217.27	2217.27	2209.35	2210.93	192267.0
2015-06-04 14:00:00	ES	Futures	2210.93	2215.68	2209.61	2213.31	111217.0
2015-06-04 15:00:00	ES	Futures	2213.31	2215.68	2209.35	2214.36	239465.0
2015-06-04 16:00:00	ES	Futures	2214.36	2217.8	2214.1	2217.27	100498.0
2015-06-04 17:00:00	ES	Futures	2217.53	2218.06	2217.0	2217.27	2666.0
2015-06-04 18:00:00	ES	Futures	2217.27	2218.06	2217.0	2217.53	2373.0
2015-06-04 19:00:00	ES	Futures	2217.8	2217.8	2215.95	2217.27	2178.0
2015-06-04 20:00:00	ES	Futures	2217.27	2218.06	2215.68	2217.53	4738.0
2015-06-04 21:00:00	ES	Futures	2217.53	2218.06	2216.21	2216.48	3434.0
2015-06-04 22:00:00	ES	Futures	2216.74	2217.0	2215.95	2216.48	1616.0
2015-06-04 23:00:00	ES	Futures	2216.48	2217.0	2215.42	2215.95	2730.0
2015-06-04 00:00:00	NQ	Futures	5316.08	5319.02	5315.79	5316.67	406.0
2015-06-04 01:00:00	NQ	Futures	5316.67	5316.67	5306.96	5312.55	1609.0
2015-06-04 02:00:00	NQ	Futures	5312.55	5316.37	5308.14	5315.49	1374.0
2015-06-04 03:00:00	NQ	Futures	5314.9	5314.9	5281.09	5281.38	9992.0
2015-06-04 04:00:00	NQ	Futures	5281.68	5289.03	5271.68	5281.68	13345.0
2015-06-04 05:00:00	NQ	Futures	5281.68	5285.2	5274.32	5277.56	5343.0
2015-06-04 06:00:00	NQ	Futures	5277.26	5282.56	5273.15	5282.56	4182.0
2015-06-04 07:00:00	NQ	Futures	5281.97	5291.09	5275.79	5291.09	5310.0
2015-06-04 08:00:00	NQ	Futures	5290.79	5297.85	5283.15	5291.67	9638.0
2015-06-04 09:00:00	NQ	Futures	5292.26	5316.37	5285.2	5312.85	47896.0
2015-06-04 10:00:00	NQ	Futures	5313.14	5323.73	5298.44	5300.2	31662.0
2015-06-04 11:00:00	NQ	Futures	5300.5	5305.49	5285.79	5290.79	34813.0
2015-06-04 12:00:00	NQ	Futures	5290.5	5295.2	5286.67	5287.85	13468.0
2015-06-04 13:00:00	NQ	Futures	5287.85	5287.85	5263.15	5266.09	35824.0
2015-06-04 14:00:00	NQ	Futures	5266.09	5278.15	5261.68	5274.03	21558.0
2015-06-04 15:00:00	NQ	Futures	5273.74	5281.09	5266.38	5279.91	32765.0
2015-06-04 16:00:00	NQ	Futures	5279.91	5290.2	5279.03	5287.85	11765.0
2015-06-04 17:00:00	NQ	Futures	5287.85	5289.32	5286.97	5288.73	211.0
2015-06-04 18:00:00	NQ	Futures	5286.97	5289.91	5286.97	5287.56	537.0
2015-06-04 19:00:00	NQ	Futures	5288.14	5288.14	5284.03	5286.67	384.0
2015-06-04 20:00:00	NQ	Futures	5286.09	5288.44	5283.15	5287.85	812.0
2015-06-04 21:00:00	NQ	Futures	5287.56	5288.14	5284.91	5285.5	436.0
2015-06-04 22:00:00	NQ	Futures	5285.79	5286.09	5283.73	5285.2	239.0
2015-06-04 23:00:00	NQ	Futures	5285.2	5285.79	5281.68	5284.62	683.0
2015-06-04 00:00:00	YM	Futures	18948.4	18954.6	18947.3	18949.4	293.0
2015-06-04 01:00:00	YM	Futures	18948.4	18949.4	18919.0	18940.0	1392.0

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

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