PREVIEW / futures_1hour / 2015-07-13

all futures 1-hour files

  file:    by_date/futures_1hour/2015/2015-07-13.parquet
  size:    51 KB
  rows:    1,553

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-07-13 00:00:00	ES	Futures	2200.28	2204.27	2197.88	2198.94	8058.0
2015-07-13 01:00:00	ES	Futures	2199.21	2202.67	2198.94	2199.48	6175.0
2015-07-13 02:00:00	ES	Futures	2199.21	2214.12	2195.48	2211.19	46668.0
2015-07-13 03:00:00	ES	Futures	2211.19	2213.06	2205.07	2211.46	52061.0
2015-07-13 04:00:00	ES	Futures	2211.46	2214.12	2210.39	2213.32	21518.0
2015-07-13 05:00:00	ES	Futures	2213.32	2223.17	2213.06	2220.24	42642.0
2015-07-13 06:00:00	ES	Futures	2220.24	2220.24	2217.58	2218.11	13102.0
2015-07-13 07:00:00	ES	Futures	2218.11	2220.51	2216.78	2218.65	34363.0
2015-07-13 08:00:00	ES	Futures	2218.65	2218.91	2215.98	2217.58	38606.0
2015-07-13 09:00:00	ES	Futures	2217.85	2226.37	2217.58	2223.71	218627.0
2015-07-13 10:00:00	ES	Futures	2223.71	2227.17	2222.64	2224.5	169625.0
2015-07-13 11:00:00	ES	Futures	2224.5	2226.63	2222.11	2225.04	115291.0
2015-07-13 12:00:00	ES	Futures	2225.04	2225.04	2221.58	2222.37	65718.0
2015-07-13 13:00:00	ES	Futures	2222.37	2224.5	2222.11	2223.17	72229.0
2015-07-13 14:00:00	ES	Futures	2223.17	2228.23	2223.17	2227.43	78637.0
2015-07-13 15:00:00	ES	Futures	2227.7	2230.1	2226.63	2228.5	191479.0
2015-07-13 16:00:00	ES	Futures	2228.5	2230.89	2228.5	2229.83	79616.0
2015-07-13 17:00:00	ES	Futures	2229.83	2230.89	2229.56	2230.89	2787.0
2015-07-13 18:00:00	ES	Futures	2230.1	2230.36	2229.03	2229.56	4325.0
2015-07-13 19:00:00	ES	Futures	2229.56	2230.1	2228.76	2229.83	1872.0
2015-07-13 20:00:00	ES	Futures	2229.56	2230.63	2229.3	2230.1	5298.0
2015-07-13 21:00:00	ES	Futures	2229.83	2230.36	2229.3	2229.56	3824.0
2015-07-13 22:00:00	ES	Futures	2229.56	2230.63	2229.3	2229.83	2875.0
2015-07-13 23:00:00	ES	Futures	2230.1	2230.36	2229.03	2229.56	2491.0
2015-07-13 00:00:00	NQ	Futures	5214.47	5223.05	5208.56	5210.63	1301.0
2015-07-13 01:00:00	NQ	Futures	5210.63	5218.32	5208.56	5209.44	671.0
2015-07-13 02:00:00	NQ	Futures	5209.44	5248.78	5201.16	5243.16	5103.0
2015-07-13 03:00:00	NQ	Futures	5242.87	5248.78	5228.67	5244.64	7247.0
2015-07-13 04:00:00	NQ	Futures	5244.35	5252.63	5242.28	5250.56	3544.0
2015-07-13 05:00:00	NQ	Futures	5250.26	5270.67	5249.37	5264.46	7374.0
2015-07-13 06:00:00	NQ	Futures	5264.46	5264.46	5257.66	5257.95	2267.0
2015-07-13 07:00:00	NQ	Futures	5258.25	5261.8	5253.81	5257.95	7387.0
2015-07-13 08:00:00	NQ	Futures	5257.95	5261.5	5252.04	5258.54	7703.0
2015-07-13 09:00:00	NQ	Futures	5258.84	5293.15	5257.66	5285.46	41667.0
2015-07-13 10:00:00	NQ	Futures	5285.76	5297.88	5285.46	5291.97	28462.0
2015-07-13 11:00:00	NQ	Futures	5292.26	5299.95	5285.46	5298.48	17606.0
2015-07-13 12:00:00	NQ	Futures	5298.77	5300.84	5291.97	5294.93	10801.0
2015-07-13 13:00:00	NQ	Futures	5294.63	5300.84	5292.26	5295.52	9454.0
2015-07-13 14:00:00	NQ	Futures	5295.81	5309.12	5295.81	5306.76	16236.0
2015-07-13 15:00:00	NQ	Futures	5307.05	5314.45	5304.39	5307.65	25638.0
2015-07-13 16:00:00	NQ	Futures	5307.65	5310.9	5307.35	5308.53	5699.0
2015-07-13 17:00:00	NQ	Futures	5308.83	5310.9	5308.53	5310.31	207.0
2015-07-13 18:00:00	NQ	Futures	5309.12	5309.72	5305.87	5307.35	381.0
2015-07-13 19:00:00	NQ	Futures	5308.24	5310.01	5307.35	5309.72	377.0
2015-07-13 20:00:00	NQ	Futures	5309.72	5312.38	5308.83	5310.31	468.0
2015-07-13 21:00:00	NQ	Futures	5310.6	5311.19	5308.83	5309.72	264.0
2015-07-13 22:00:00	NQ	Futures	5309.42	5311.49	5308.24	5311.19	346.0
2015-07-13 23:00:00	NQ	Futures	5310.6	5310.9	5308.53	5309.72	256.0
2015-07-13 00:00:00	YM	Futures	18595.7	18621.0	18580.9	18586.2	1859.0
2015-07-13 01:00:00	YM	Futures	18587.3	18608.3	18583.0	18586.2	1334.0

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

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