PREVIEW / futures_1hour / 2015-11-23

all futures 1-hour files

  file:    by_date/futures_1hour/2015/2015-11-23.parquet
  size:    51 KB
  rows:    1,580

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-23 00:00:00	ES	Futures	2237.21	2238.55	2235.34	2237.74	2393.0
2015-11-23 01:00:00	ES	Futures	2237.74	2238.01	2236.14	2237.21	3124.0
2015-11-23 02:00:00	ES	Futures	2236.94	2238.01	2234.0	2234.53	4484.0
2015-11-23 03:00:00	ES	Futures	2234.53	2235.34	2229.45	2231.86	20314.0
2015-11-23 04:00:00	ES	Futures	2231.86	2234.8	2230.25	2230.52	12825.0
2015-11-23 05:00:00	ES	Futures	2230.52	2232.66	2230.25	2231.05	8126.0
2015-11-23 06:00:00	ES	Futures	2231.05	2234.8	2228.38	2233.19	15294.0
2015-11-23 07:00:00	ES	Futures	2233.46	2237.74	2232.12	2234.53	26881.0
2015-11-23 08:00:00	ES	Futures	2234.8	2235.6	2231.86	2231.86	24313.0
2015-11-23 09:00:00	ES	Futures	2231.86	2236.94	2231.05	2232.66	116727.0
2015-11-23 10:00:00	ES	Futures	2232.93	2240.15	2231.05	2239.62	164702.0
2015-11-23 11:00:00	ES	Futures	2239.88	2239.88	2236.41	2238.28	107678.0
2015-11-23 12:00:00	ES	Futures	2238.55	2238.81	2235.07	2236.41	65346.0
2015-11-23 13:00:00	ES	Futures	2236.67	2237.74	2232.12	2232.12	58149.0
2015-11-23 14:00:00	ES	Futures	2232.12	2232.93	2224.36	2227.84	158332.0
2015-11-23 15:00:00	ES	Futures	2227.84	2231.86	2227.58	2230.25	115597.0
2015-11-23 16:00:00	ES	Futures	2230.25	2231.59	2229.45	2229.72	39879.0
2015-11-23 18:00:00	ES	Futures	2229.45	2231.59	2228.11	2231.59	3280.0
2015-11-23 19:00:00	ES	Futures	2231.86	2232.12	2230.25	2230.79	3682.0
2015-11-23 20:00:00	ES	Futures	2230.79	2231.32	2229.18	2229.18	2607.0
2015-11-23 21:00:00	ES	Futures	2229.18	2230.52	2228.91	2229.45	2017.0
2015-11-23 22:00:00	ES	Futures	2229.45	2229.98	2228.11	2229.98	2758.0
2015-11-23 23:00:00	ES	Futures	2229.98	2230.79	2229.45	2230.25	1519.0
2015-11-23 00:00:00	NQ	Futures	5566.62	5569.58	5562.76	5566.92	535.0
2015-11-23 01:00:00	NQ	Futures	5566.62	5568.1	5563.36	5564.84	352.0
2015-11-23 02:00:00	NQ	Futures	5564.84	5566.62	5558.61	5559.8	743.0
2015-11-23 03:00:00	NQ	Futures	5560.39	5562.47	5549.72	5554.76	2881.0
2015-11-23 04:00:00	NQ	Futures	5555.35	5563.06	5551.5	5551.79	1761.0
2015-11-23 05:00:00	NQ	Futures	5552.39	5557.43	5550.31	5552.09	1140.0
2015-11-23 06:00:00	NQ	Futures	5551.79	5559.8	5545.27	5555.95	2223.0
2015-11-23 07:00:00	NQ	Futures	5555.95	5568.99	5555.06	5560.69	4615.0
2015-11-23 08:00:00	NQ	Futures	5560.99	5565.14	5556.24	5556.54	2956.0
2015-11-23 09:00:00	NQ	Futures	5556.83	5572.55	5552.98	5566.32	22561.0
2015-11-23 10:00:00	NQ	Futures	5566.32	5582.04	5560.1	5575.51	25726.0
2015-11-23 11:00:00	NQ	Futures	5575.51	5575.51	5559.21	5564.54	15876.0
2015-11-23 12:00:00	NQ	Futures	5564.84	5565.43	5554.76	5559.8	12484.0
2015-11-23 13:00:00	NQ	Futures	5560.39	5563.36	5544.98	5544.98	11442.0
2015-11-23 14:00:00	NQ	Futures	5544.98	5546.75	5519.18	5533.71	30009.0
2015-11-23 15:00:00	NQ	Futures	5534.0	5547.64	5532.52	5542.9	19323.0
2015-11-23 16:00:00	NQ	Futures	5542.6	5547.05	5541.71	5544.38	3771.0
2015-11-23 18:00:00	NQ	Futures	5542.9	5548.83	5539.05	5548.83	562.0
2015-11-23 19:00:00	NQ	Futures	5549.13	5550.02	5544.38	5547.05	536.0
2015-11-23 20:00:00	NQ	Futures	5546.75	5546.75	5540.53	5541.42	394.0
2015-11-23 21:00:00	NQ	Futures	5541.12	5544.38	5539.05	5541.42	281.0
2015-11-23 22:00:00	NQ	Futures	5541.42	5544.38	5538.16	5544.38	390.0
2015-11-23 23:00:00	NQ	Futures	5544.09	5545.86	5542.6	5544.98	249.0
2015-11-23 00:00:00	YM	Futures	18873.8	18883.3	18860.0	18875.9	535.0
2015-11-23 01:00:00	YM	Futures	18877.0	18880.1	18866.4	18875.9	658.0
2015-11-23 02:00:00	YM	Futures	18873.8	18881.2	18846.2	18850.5	1236.0
2015-11-23 03:00:00	YM	Futures	18851.5	18854.7	18808.1	18828.2	3843.0

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

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