PREVIEW / futures_1hour / 2014-05-26

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-05-26.parquet
  size:    30 KB
  rows:    926

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
2014-05-26 00:00:00	ES	Futures	1970.9	1971.42	1970.64	1970.9	637.0
2014-05-26 01:00:00	ES	Futures	1970.9	1971.94	1970.9	1971.68	1176.0
2014-05-26 02:00:00	ES	Futures	1971.68	1973.24	1971.16	1972.98	4578.0
2014-05-26 03:00:00	ES	Futures	1972.72	1976.62	1972.2	1975.58	17227.0
2014-05-26 04:00:00	ES	Futures	1975.58	1976.36	1974.54	1975.06	6077.0
2014-05-26 05:00:00	ES	Futures	1974.8	1975.06	1974.02	1974.28	1627.0
2014-05-26 06:00:00	ES	Futures	1974.54	1975.06	1974.28	1974.54	1676.0
2014-05-26 07:00:00	ES	Futures	1974.8	1975.32	1974.54	1975.06	1702.0
2014-05-26 08:00:00	ES	Futures	1974.8	1976.62	1974.8	1976.62	4299.0
2014-05-26 09:00:00	ES	Futures	1976.62	1976.62	1975.32	1976.36	5324.0
2014-05-26 10:00:00	ES	Futures	1976.36	1977.92	1976.36	1977.92	7883.0
2014-05-26 11:00:00	ES	Futures	1977.92	1977.92	1977.14	1977.4	6170.0
2014-05-26 12:00:00	ES	Futures	1977.4	1978.43	1977.14	1977.66	4084.0
2014-05-26 18:00:00	ES	Futures	1976.88	1977.14	1976.1	1976.36	2127.0
2014-05-26 19:00:00	ES	Futures	1976.36	1976.62	1975.84	1975.84	1624.0
2014-05-26 20:00:00	ES	Futures	1976.1	1977.14	1975.84	1976.62	5172.0
2014-05-26 21:00:00	ES	Futures	1976.36	1976.88	1976.36	1976.88	2337.0
2014-05-26 22:00:00	ES	Futures	1976.88	1977.14	1976.36	1976.88	1719.0
2014-05-26 23:00:00	ES	Futures	1976.62	1977.14	1976.62	1976.62	1315.0
2014-05-26 00:00:00	NQ	Futures	4285.34	4286.5	4285.34	4286.21	132.0
2014-05-26 01:00:00	NQ	Futures	4286.21	4287.96	4285.92	4287.67	214.0
2014-05-26 02:00:00	NQ	Futures	4287.37	4290.58	4285.63	4288.83	654.0
2014-05-26 03:00:00	NQ	Futures	4288.54	4296.11	4287.96	4292.33	2233.0
2014-05-26 04:00:00	NQ	Futures	4292.62	4295.53	4292.03	4292.91	738.0
2014-05-26 05:00:00	NQ	Futures	4292.62	4292.91	4290.87	4291.74	166.0
2014-05-26 06:00:00	NQ	Futures	4291.74	4294.36	4291.45	4294.36	274.0
2014-05-26 07:00:00	NQ	Futures	4294.07	4294.07	4293.2	4293.78	257.0
2014-05-26 08:00:00	NQ	Futures	4293.78	4294.65	4292.62	4294.36	524.0
2014-05-26 09:00:00	NQ	Futures	4294.65	4294.65	4291.45	4294.65	1094.0
2014-05-26 10:00:00	NQ	Futures	4294.65	4297.86	4294.36	4297.28	1048.0
2014-05-26 11:00:00	NQ	Futures	4297.28	4299.31	4295.82	4298.15	706.0
2014-05-26 12:00:00	NQ	Futures	4297.86	4301.35	4297.86	4298.73	961.0
2014-05-26 18:00:00	NQ	Futures	4298.15	4298.15	4294.95	4295.53	559.0
2014-05-26 19:00:00	NQ	Futures	4295.82	4296.11	4294.65	4295.53	165.0
2014-05-26 20:00:00	NQ	Futures	4295.53	4297.57	4295.24	4296.69	521.0
2014-05-26 21:00:00	NQ	Futures	4296.4	4296.98	4295.24	4296.98	287.0
2014-05-26 22:00:00	NQ	Futures	4296.69	4296.69	4294.65	4295.82	346.0
2014-05-26 23:00:00	NQ	Futures	4295.53	4297.28	4295.53	4296.4	107.0
2014-05-26 00:00:00	YM	Futures	17089.5	17094.6	17084.3	17091.5	685.0
2014-05-26 01:00:00	YM	Futures	17093.6	17106.0	17091.5	17098.8	1199.0
2014-05-26 02:00:00	YM	Futures	17098.8	17115.2	17088.5	17111.1	1319.0
2014-05-26 03:00:00	YM	Futures	17110.1	17147.2	17106.0	17136.9	3319.0
2014-05-26 04:00:00	YM	Futures	17140.0	17143.0	17128.6	17131.7	464.0
2014-05-26 05:00:00	YM	Futures	17131.7	17131.7	17118.3	17122.4	567.0
2014-05-26 06:00:00	YM	Futures	17122.4	17127.6	17122.4	17126.6	175.0
2014-05-26 07:00:00	YM	Futures	17126.6	17130.7	17121.4	17128.6	667.0
2014-05-26 08:00:00	YM	Futures	17128.6	17141.0	17128.6	17138.9	1359.0
2014-05-26 09:00:00	YM	Futures	17138.9	17144.1	17133.8	17140.0	519.0
2014-05-26 10:00:00	YM	Futures	17140.0	17143.0	17136.9	17142.0	478.0
2014-05-26 11:00:00	YM	Futures	17142.0	17144.1	17136.9	17140.0	453.0

> showing 50 of 926 rows — these rows as CSV

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