PREVIEW / futures_1hour / 2017-02-10

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-02-10.parquet
  size:    45 KB
  rows:    1,341

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
2017-02-10 00:00:00	ES	Futures	2517.38	2517.66	2516.02	2517.11	3382.0
2017-02-10 01:00:00	ES	Futures	2517.38	2518.75	2517.11	2518.75	3642.0
2017-02-10 02:00:00	ES	Futures	2518.75	2519.84	2517.93	2518.48	9572.0
2017-02-10 03:00:00	ES	Futures	2518.48	2518.75	2516.02	2516.29	13902.0
2017-02-10 04:00:00	ES	Futures	2516.29	2517.93	2516.02	2517.38	9882.0
2017-02-10 05:00:00	ES	Futures	2517.66	2517.93	2514.93	2515.2	10083.0
2017-02-10 06:00:00	ES	Futures	2515.2	2516.29	2514.66	2515.2	8358.0
2017-02-10 07:00:00	ES	Futures	2515.2	2517.66	2515.2	2517.11	12606.0
2017-02-10 08:00:00	ES	Futures	2517.38	2517.66	2516.29	2517.11	13126.0
2017-02-10 09:00:00	ES	Futures	2516.84	2520.38	2516.84	2519.02	178118.0
2017-02-10 10:00:00	ES	Futures	2519.29	2522.02	2517.11	2520.66	196215.0
2017-02-10 11:00:00	ES	Futures	2520.66	2520.93	2518.75	2520.93	116072.0
2017-02-10 12:00:00	ES	Futures	2520.93	2524.2	2519.84	2523.11	99763.0
2017-02-10 13:00:00	ES	Futures	2523.39	2526.66	2522.84	2524.48	123910.0
2017-02-10 14:00:00	ES	Futures	2524.48	2525.84	2522.29	2522.57	87935.0
2017-02-10 15:00:00	ES	Futures	2522.84	2525.02	2522.57	2523.39	181690.0
2017-02-10 16:00:00	ES	Futures	2523.39	2524.2	2522.57	2523.93	71219.0
2017-02-10 00:00:00	NQ	Futures	6229.81	6231.9	6227.72	6230.71	1094.0
2017-02-10 01:00:00	NQ	Futures	6230.71	6234.59	6230.71	6233.69	1136.0
2017-02-10 02:00:00	NQ	Futures	6233.69	6237.57	6233.69	6234.88	1953.0
2017-02-10 03:00:00	NQ	Futures	6234.88	6236.08	6228.62	6228.62	2966.0
2017-02-10 04:00:00	NQ	Futures	6229.22	6233.09	6227.13	6230.71	1488.0
2017-02-10 05:00:00	NQ	Futures	6230.71	6231.3	6223.85	6224.44	1508.0
2017-02-10 06:00:00	NQ	Futures	6224.44	6226.83	6222.95	6224.74	1198.0
2017-02-10 07:00:00	NQ	Futures	6225.04	6229.22	6224.74	6228.92	1536.0
2017-02-10 08:00:00	NQ	Futures	6228.92	6229.22	6224.74	6226.53	2411.0
2017-02-10 09:00:00	NQ	Futures	6226.53	6231.01	6219.37	6220.86	26190.0
2017-02-10 10:00:00	NQ	Futures	6220.86	6234.59	6217.28	6231.01	26164.0
2017-02-10 11:00:00	NQ	Futures	6231.3	6234.29	6225.64	6233.09	13406.0
2017-02-10 12:00:00	NQ	Futures	6233.09	6239.66	6229.22	6237.87	13049.0
2017-02-10 13:00:00	NQ	Futures	6237.87	6243.83	6236.97	6238.17	14665.0
2017-02-10 14:00:00	NQ	Futures	6238.17	6240.55	6234.29	6234.59	9838.0
2017-02-10 15:00:00	NQ	Futures	6234.88	6239.66	6233.39	6234.88	18840.0
2017-02-10 16:00:00	NQ	Futures	6234.88	6238.76	6233.69	6237.57	3894.0
2017-02-10 00:00:00	YM	Futures	21876.5	21880.8	21870.0	21875.4	801.0
2017-02-10 01:00:00	YM	Futures	21875.4	21894.9	21875.4	21894.9	1379.0
2017-02-10 02:00:00	YM	Futures	21894.9	21907.9	21891.7	21894.9	2411.0
2017-02-10 03:00:00	YM	Futures	21896.0	21898.2	21870.0	21870.0	3288.0
2017-02-10 04:00:00	YM	Futures	21871.1	21884.1	21865.6	21880.8	1965.0
2017-02-10 05:00:00	YM	Futures	21879.7	21884.1	21859.1	21861.3	1405.0
2017-02-10 06:00:00	YM	Futures	21861.3	21871.1	21856.9	21863.5	1190.0
2017-02-10 07:00:00	YM	Futures	21862.4	21884.1	21862.4	21880.8	2011.0
2017-02-10 08:00:00	YM	Futures	21880.8	21883.0	21868.9	21873.2	2649.0
2017-02-10 09:00:00	YM	Futures	21874.3	21901.4	21865.6	21892.7	14949.0
2017-02-10 10:00:00	YM	Futures	21894.9	21930.7	21875.4	21912.3	17589.0
2017-02-10 11:00:00	YM	Futures	21912.3	21913.4	21890.6	21907.9	9536.0
2017-02-10 12:00:00	YM	Futures	21909.0	21937.2	21902.5	21928.5	7005.0
2017-02-10 13:00:00	YM	Futures	21928.5	21964.3	21926.4	21948.1	9805.0
2017-02-10 14:00:00	YM	Futures	21948.1	21954.6	21929.6	21931.8	5541.0
2017-02-10 15:00:00	YM	Futures	21931.8	21950.2	21929.6	21937.2	9278.0

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

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