PREVIEW / futures_1hour / 2015-11-27

all futures 1-hour files

  file:    by_date/futures_1hour/2015/2015-11-27.parquet
  size:    36 KB
  rows:    1,056

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-11-27 00:00:00	ES	Futures	2239.35	2239.62	2238.81	2239.08	1617.0
2015-11-27 01:00:00	ES	Futures	2239.08	2239.35	2232.66	2234.26	9709.0
2015-11-27 02:00:00	ES	Futures	2234.26	2235.87	2232.66	2234.8	9983.0
2015-11-27 03:00:00	ES	Futures	2235.07	2235.07	2229.72	2232.66	26678.0
2015-11-27 04:00:00	ES	Futures	2232.39	2235.07	2229.72	2233.46	13531.0
2015-11-27 05:00:00	ES	Futures	2233.46	2238.01	2231.86	2237.74	11071.0
2015-11-27 06:00:00	ES	Futures	2237.74	2238.01	2235.07	2236.94	9798.0
2015-11-27 07:00:00	ES	Futures	2236.94	2238.01	2235.34	2237.48	10139.0
2015-11-27 08:00:00	ES	Futures	2237.48	2238.81	2234.0	2234.8	26125.0
2015-11-27 09:00:00	ES	Futures	2234.53	2235.87	2229.98	2231.59	119831.0
2015-11-27 10:00:00	ES	Futures	2231.86	2234.26	2227.84	2233.73	109200.0
2015-11-27 11:00:00	ES	Futures	2233.73	2238.28	2233.46	2235.34	88414.0
2015-11-27 12:00:00	ES	Futures	2235.07	2237.48	2234.26	2235.6	66098.0
2015-11-27 13:00:00	ES	Futures	2235.34	2237.48	2234.26	2237.48	20591.0
2015-11-27 00:00:00	NQ	Futures	5562.47	5562.76	5559.21	5560.1	349.0
2015-11-27 01:00:00	NQ	Futures	5560.1	5560.39	5541.71	5545.57	1414.0
2015-11-27 02:00:00	NQ	Futures	5545.86	5553.28	5545.86	5551.5	1527.0
2015-11-27 03:00:00	NQ	Futures	5551.79	5552.39	5541.12	5545.27	4010.0
2015-11-27 04:00:00	NQ	Futures	5545.27	5551.79	5539.64	5548.53	1936.0
2015-11-27 05:00:00	NQ	Futures	5548.53	5565.73	5545.86	5564.84	2325.0
2015-11-27 06:00:00	NQ	Futures	5564.84	5565.14	5557.43	5561.88	1606.0
2015-11-27 07:00:00	NQ	Futures	5561.88	5565.43	5560.99	5564.84	1677.0
2015-11-27 08:00:00	NQ	Futures	5564.84	5566.62	5557.13	5558.02	3125.0
2015-11-27 09:00:00	NQ	Futures	5558.32	5560.1	5541.12	5544.68	21498.0
2015-11-27 10:00:00	NQ	Futures	5544.98	5548.53	5532.23	5544.68	17151.0
2015-11-27 11:00:00	NQ	Futures	5544.68	5563.06	5544.68	5554.17	14290.0
2015-11-27 12:00:00	NQ	Futures	5554.46	5560.69	5550.61	5551.5	8765.0
2015-11-27 13:00:00	NQ	Futures	5551.79	5557.13	5549.72	5557.13	2373.0
2015-11-27 00:00:00	YM	Futures	18877.0	18879.1	18868.5	18871.7	305.0
2015-11-27 01:00:00	YM	Futures	18872.7	18872.7	18817.6	18831.4	1900.0
2015-11-27 02:00:00	YM	Futures	18829.3	18848.4	18819.8	18842.0	2000.0
2015-11-27 03:00:00	YM	Futures	18844.1	18844.1	18802.8	18816.6	4078.0
2015-11-27 04:00:00	YM	Futures	18816.6	18836.7	18791.2	18822.9	2372.0
2015-11-27 05:00:00	YM	Futures	18822.9	18865.3	18815.5	18863.2	1823.0
2015-11-27 06:00:00	YM	Futures	18864.2	18866.4	18843.1	18853.7	1757.0
2015-11-27 07:00:00	YM	Futures	18854.7	18861.1	18839.9	18854.7	1525.0
2015-11-27 08:00:00	YM	Futures	18854.7	18862.1	18826.1	18828.2	2108.0
2015-11-27 09:00:00	YM	Futures	18830.3	18842.0	18786.9	18801.7	16688.0
2015-11-27 10:00:00	YM	Futures	18802.8	18824.0	18772.1	18817.6	10493.0
2015-11-27 11:00:00	YM	Futures	18818.7	18861.1	18818.7	18836.7	7064.0
2015-11-27 12:00:00	YM	Futures	18837.8	18852.6	18827.2	18829.3	5136.0
2015-11-27 13:00:00	YM	Futures	18830.3	18864.2	18826.1	18860.0	1591.0
2015-11-27 00:00:00	CL	Futures	58.33	58.37	58.2	58.24	840.0
2015-11-27 01:00:00	CL	Futures	58.25	58.31	58.07	58.1	1619.0
2015-11-27 02:00:00	CL	Futures	58.11	58.13	57.83	57.95	4218.0
2015-11-27 03:00:00	CL	Futures	57.95	58.1	57.68	58.02	10404.0
2015-11-27 04:00:00	CL	Futures	58.02	58.06	57.61	57.72	7832.0
2015-11-27 05:00:00	CL	Futures	57.72	57.73	57.48	57.66	6383.0
2015-11-27 06:00:00	CL	Futures	57.68	57.84	57.52	57.72	7158.0
2015-11-27 07:00:00	CL	Futures	57.7	58.06	57.65	57.98	10343.0

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

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