PREVIEW / futures_1hour / 2015-06-02

all futures 1-hour files

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

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-02 00:00:00	ES	Futures	2227.83	2228.36	2227.31	2227.57	1616.0
2015-06-02 01:00:00	ES	Futures	2227.83	2228.36	2227.31	2228.1	2034.0
2015-06-02 02:00:00	ES	Futures	2228.1	2231.53	2226.78	2230.74	9082.0
2015-06-02 03:00:00	ES	Futures	2231.0	2231.27	2225.72	2228.1	19774.0
2015-06-02 04:00:00	ES	Futures	2228.1	2228.89	2212.25	2214.89	44493.0
2015-06-02 05:00:00	ES	Futures	2214.89	2219.12	2213.57	2217.27	35560.0
2015-06-02 06:00:00	ES	Futures	2217.53	2228.89	2217.27	2223.87	51650.0
2015-06-02 07:00:00	ES	Futures	2224.14	2225.72	2220.97	2223.08	39725.0
2015-06-02 08:00:00	ES	Futures	2223.08	2225.72	2217.27	2224.14	71473.0
2015-06-02 09:00:00	ES	Futures	2223.87	2224.4	2214.63	2220.17	302640.0
2015-06-02 10:00:00	ES	Futures	2220.17	2227.83	2217.8	2224.4	206678.0
2015-06-02 11:00:00	ES	Futures	2224.4	2227.31	2223.08	2226.78	104959.0
2015-06-02 12:00:00	ES	Futures	2226.51	2234.7	2226.25	2233.64	140456.0
2015-06-02 13:00:00	ES	Futures	2233.38	2235.49	2232.06	2234.96	74810.0
2015-06-02 14:00:00	ES	Futures	2234.7	2235.23	2226.78	2229.95	89593.0
2015-06-02 15:00:00	ES	Futures	2229.95	2229.95	2225.46	2226.78	151473.0
2015-06-02 16:00:00	ES	Futures	2226.78	2227.04	2224.66	2225.72	64593.0
2015-06-02 17:00:00	ES	Futures	2225.72	2225.98	2225.46	2225.72	562.0
2015-06-02 18:00:00	ES	Futures	2225.98	2227.04	2225.72	2226.51	2315.0
2015-06-02 19:00:00	ES	Futures	2226.51	2227.31	2226.25	2227.04	1923.0
2015-06-02 20:00:00	ES	Futures	2227.04	2227.57	2225.98	2227.04	3503.0
2015-06-02 21:00:00	ES	Futures	2227.04	2227.31	2226.25	2226.51	2211.0
2015-06-02 22:00:00	ES	Futures	2226.25	2227.04	2226.25	2226.78	1553.0
2015-06-02 23:00:00	ES	Futures	2226.51	2226.78	2225.72	2226.51	2664.0
2015-06-02 00:00:00	NQ	Futures	5317.55	5319.02	5316.96	5316.96	200.0
2015-06-02 01:00:00	NQ	Futures	5317.26	5319.32	5316.96	5318.43	401.0
2015-06-02 02:00:00	NQ	Futures	5318.43	5326.08	5315.79	5325.78	1218.0
2015-06-02 03:00:00	NQ	Futures	5326.08	5326.08	5311.08	5320.2	3703.0
2015-06-02 04:00:00	NQ	Futures	5319.32	5319.32	5270.5	5274.32	9761.0
2015-06-02 05:00:00	NQ	Futures	5274.62	5286.97	5272.56	5284.32	7371.0
2015-06-02 06:00:00	NQ	Futures	5284.32	5325.78	5284.32	5313.43	13089.0
2015-06-02 07:00:00	NQ	Futures	5313.43	5317.84	5304.61	5308.14	6464.0
2015-06-02 08:00:00	NQ	Futures	5307.85	5313.73	5289.32	5308.14	8603.0
2015-06-02 09:00:00	NQ	Futures	5308.14	5308.14	5274.03	5289.91	46434.0
2015-06-02 10:00:00	NQ	Futures	5289.91	5312.85	5284.03	5300.79	32636.0
2015-06-02 11:00:00	NQ	Futures	5300.79	5308.73	5295.79	5304.61	13496.0
2015-06-02 12:00:00	NQ	Futures	5304.32	5325.49	5303.44	5323.14	19891.0
2015-06-02 13:00:00	NQ	Futures	5322.84	5330.49	5319.9	5326.08	14303.0
2015-06-02 14:00:00	NQ	Futures	5326.37	5327.25	5302.85	5310.2	14246.0
2015-06-02 15:00:00	NQ	Futures	5310.2	5311.67	5301.67	5303.73	19415.0
2015-06-02 16:00:00	NQ	Futures	5303.73	5305.49	5295.2	5296.97	7366.0
2015-06-02 17:00:00	NQ	Futures	5296.97	5297.26	5295.79	5295.79	120.0
2015-06-02 18:00:00	NQ	Futures	5296.97	5299.91	5296.38	5299.32	586.0
2015-06-02 19:00:00	NQ	Futures	5299.02	5300.2	5298.14	5300.2	356.0
2015-06-02 20:00:00	NQ	Futures	5299.91	5300.5	5296.67	5299.32	518.0
2015-06-02 21:00:00	NQ	Futures	5299.32	5299.61	5297.26	5297.55	365.0
2015-06-02 22:00:00	NQ	Futures	5296.97	5299.02	5296.97	5297.85	216.0
2015-06-02 23:00:00	NQ	Futures	5297.55	5298.44	5296.08	5297.85	284.0
2015-06-02 00:00:00	YM	Futures	18903.3	18907.5	18900.1	18900.1	198.0
2015-06-02 01:00:00	YM	Futures	18900.1	18907.5	18900.1	18904.3	346.0

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

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