PREVIEW / futures_1hour / 2015-11-25

all futures 1-hour files

  file:    by_date/futures_1hour/2015/2015-11-25.parquet
  size:    49 KB
  rows:    1,532

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-25 00:00:00	ES	Futures	2232.39	2234.26	2232.12	2234.0	2714.0
2015-11-25 01:00:00	ES	Futures	2233.73	2234.0	2232.66	2232.93	1802.0
2015-11-25 02:00:00	ES	Futures	2232.93	2233.46	2229.98	2230.79	6786.0
2015-11-25 03:00:00	ES	Futures	2231.05	2234.0	2228.91	2231.86	18840.0
2015-11-25 04:00:00	ES	Futures	2232.12	2239.62	2231.86	2237.48	22495.0
2015-11-25 05:00:00	ES	Futures	2237.74	2238.81	2236.14	2238.28	10437.0
2015-11-25 06:00:00	ES	Futures	2238.28	2238.55	2235.34	2237.21	10825.0
2015-11-25 07:00:00	ES	Futures	2237.21	2237.21	2234.26	2235.6	12568.0
2015-11-25 08:00:00	ES	Futures	2235.87	2238.28	2234.8	2235.87	21390.0
2015-11-25 09:00:00	ES	Futures	2235.87	2236.67	2229.72	2235.6	152898.0
2015-11-25 10:00:00	ES	Futures	2235.6	2237.48	2232.66	2234.8	134548.0
2015-11-25 11:00:00	ES	Futures	2235.07	2235.6	2232.93	2235.07	72380.0
2015-11-25 12:00:00	ES	Futures	2235.34	2237.48	2235.07	2236.14	58509.0
2015-11-25 13:00:00	ES	Futures	2236.41	2236.67	2233.46	2235.87	46232.0
2015-11-25 14:00:00	ES	Futures	2235.87	2236.67	2234.26	2235.87	42321.0
2015-11-25 15:00:00	ES	Futures	2235.87	2236.67	2232.39	2233.19	80890.0
2015-11-25 16:00:00	ES	Futures	2233.19	2235.87	2232.66	2235.34	30052.0
2015-11-25 18:00:00	ES	Futures	2236.41	2236.94	2236.14	2236.41	2042.0
2015-11-25 19:00:00	ES	Futures	2236.67	2237.48	2235.87	2236.94	2441.0
2015-11-25 20:00:00	ES	Futures	2237.21	2238.55	2236.67	2237.48	2640.0
2015-11-25 21:00:00	ES	Futures	2237.74	2238.28	2237.48	2237.74	971.0
2015-11-25 22:00:00	ES	Futures	2238.01	2239.08	2237.48	2238.81	1810.0
2015-11-25 23:00:00	ES	Futures	2238.81	2239.08	2237.48	2237.74	926.0
2015-11-25 00:00:00	NQ	Futures	5536.08	5542.01	5536.08	5540.53	665.0
2015-11-25 01:00:00	NQ	Futures	5539.93	5540.53	5536.97	5538.16	446.0
2015-11-25 02:00:00	NQ	Futures	5538.16	5539.05	5529.56	5533.12	732.0
2015-11-25 03:00:00	NQ	Futures	5533.41	5542.6	5528.08	5536.67	2354.0
2015-11-25 04:00:00	NQ	Futures	5536.97	5555.65	5536.08	5550.31	3047.0
2015-11-25 05:00:00	NQ	Futures	5550.61	5550.9	5544.98	5549.72	1540.0
2015-11-25 06:00:00	NQ	Futures	5549.42	5550.31	5543.79	5546.75	1392.0
2015-11-25 07:00:00	NQ	Futures	5546.75	5547.94	5541.42	5546.46	1693.0
2015-11-25 08:00:00	NQ	Futures	5546.46	5553.57	5545.27	5546.75	3303.0
2015-11-25 09:00:00	NQ	Futures	5546.75	5549.72	5531.34	5548.83	24717.0
2015-11-25 10:00:00	NQ	Futures	5548.83	5553.57	5539.05	5543.49	23970.0
2015-11-25 11:00:00	NQ	Futures	5543.49	5550.9	5535.49	5549.72	13730.0
2015-11-25 12:00:00	NQ	Futures	5550.31	5553.28	5547.35	5550.31	9745.0
2015-11-25 13:00:00	NQ	Futures	5550.31	5551.5	5542.9	5548.24	8214.0
2015-11-25 14:00:00	NQ	Futures	5548.53	5551.5	5544.68	5548.53	6118.0
2015-11-25 15:00:00	NQ	Futures	5548.83	5550.9	5539.93	5542.6	10284.0
2015-11-25 16:00:00	NQ	Futures	5542.31	5548.83	5542.01	5548.24	2458.0
2015-11-25 18:00:00	NQ	Futures	5550.02	5550.9	5549.13	5549.42	214.0
2015-11-25 19:00:00	NQ	Futures	5549.42	5552.39	5548.83	5552.09	504.0
2015-11-25 20:00:00	NQ	Futures	5552.09	5558.61	5551.79	5554.76	751.0
2015-11-25 21:00:00	NQ	Futures	5555.06	5558.32	5554.76	5557.13	237.0
2015-11-25 22:00:00	NQ	Futures	5557.13	5559.5	5555.95	5558.32	278.0
2015-11-25 23:00:00	NQ	Futures	5558.61	5558.91	5553.87	5554.46	359.0
2015-11-25 00:00:00	YM	Futures	18824.0	18837.8	18824.0	18833.5	442.0
2015-11-25 01:00:00	YM	Futures	18832.5	18834.6	18826.1	18829.3	317.0
2015-11-25 02:00:00	YM	Futures	18830.3	18834.6	18804.9	18814.5	905.0
2015-11-25 03:00:00	YM	Futures	18815.5	18847.3	18802.8	18831.4	3002.0

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

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