PREVIEW / futures_1hour / 2016-07-29

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-07-29.parquet
  size:    47 KB
  rows:    1,340

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
2016-07-29 00:00:00	ES	Futures	2349.02	2349.83	2340.88	2342.78	22330.0
2016-07-29 01:00:00	ES	Futures	2342.78	2347.39	2342.78	2346.85	11965.0
2016-07-29 02:00:00	ES	Futures	2346.58	2349.56	2343.32	2344.95	20458.0
2016-07-29 03:00:00	ES	Futures	2344.95	2345.76	2341.42	2343.32	29715.0
2016-07-29 04:00:00	ES	Futures	2343.32	2346.85	2343.05	2344.68	16607.0
2016-07-29 05:00:00	ES	Futures	2344.68	2345.76	2343.32	2345.22	13151.0
2016-07-29 06:00:00	ES	Futures	2345.49	2346.85	2344.14	2345.22	9717.0
2016-07-29 07:00:00	ES	Futures	2345.22	2345.76	2344.14	2345.22	12193.0
2016-07-29 08:00:00	ES	Futures	2345.22	2345.76	2341.15	2344.68	40408.0
2016-07-29 09:00:00	ES	Futures	2344.68	2348.47	2342.78	2344.14	188493.0
2016-07-29 10:00:00	ES	Futures	2344.14	2350.92	2340.34	2349.29	265739.0
2016-07-29 11:00:00	ES	Futures	2349.02	2354.71	2349.02	2353.63	185172.0
2016-07-29 12:00:00	ES	Futures	2353.63	2355.8	2350.1	2351.19	134075.0
2016-07-29 13:00:00	ES	Futures	2351.19	2353.63	2350.1	2353.36	102866.0
2016-07-29 14:00:00	ES	Futures	2353.36	2354.44	2350.1	2352.0	135611.0
2016-07-29 15:00:00	ES	Futures	2351.73	2355.25	2349.29	2350.92	328565.0
2016-07-29 16:00:00	ES	Futures	2350.92	2355.25	2350.64	2354.98	106201.0
2016-07-29 00:00:00	NQ	Futures	5635.26	5637.94	5620.06	5624.53	3030.0
2016-07-29 01:00:00	NQ	Futures	5625.13	5631.98	5624.53	5629.0	1729.0
2016-07-29 02:00:00	NQ	Futures	5630.19	5636.16	5624.53	5627.51	2219.0
2016-07-29 03:00:00	NQ	Futures	5627.51	5628.11	5617.38	5622.74	3515.0
2016-07-29 04:00:00	NQ	Futures	5622.44	5628.7	5621.55	5623.93	1585.0
2016-07-29 05:00:00	NQ	Futures	5623.34	5626.92	5620.95	5626.02	1203.0
2016-07-29 06:00:00	NQ	Futures	5626.32	5629.3	5623.34	5626.32	1371.0
2016-07-29 07:00:00	NQ	Futures	5626.02	5630.19	5624.53	5629.0	1740.0
2016-07-29 08:00:00	NQ	Futures	5629.3	5633.77	5626.62	5631.98	5601.0
2016-07-29 09:00:00	NQ	Futures	5631.98	5640.63	5624.53	5626.02	34898.0
2016-07-29 10:00:00	NQ	Futures	5625.43	5638.24	5614.1	5635.26	39140.0
2016-07-29 11:00:00	NQ	Futures	5635.26	5645.69	5634.96	5642.12	23488.0
2016-07-29 12:00:00	NQ	Futures	5641.82	5646.88	5631.09	5632.88	15252.0
2016-07-29 13:00:00	NQ	Futures	5633.17	5638.84	5631.68	5636.75	10411.0
2016-07-29 14:00:00	NQ	Futures	5636.75	5637.65	5626.32	5631.68	13910.0
2016-07-29 15:00:00	NQ	Futures	5631.68	5640.03	5623.93	5632.28	29771.0
2016-07-29 16:00:00	NQ	Futures	5631.98	5640.03	5631.39	5639.14	7191.0
2016-07-29 00:00:00	YM	Futures	19778.5	19783.9	19723.6	19734.4	3430.0
2016-07-29 01:00:00	YM	Futures	19736.5	19766.7	19736.5	19762.4	1430.0
2016-07-29 02:00:00	YM	Futures	19761.3	19781.7	19738.7	19750.5	1830.0
2016-07-29 03:00:00	YM	Futures	19750.5	19759.1	19723.6	19738.7	3596.0
2016-07-29 04:00:00	YM	Futures	19738.7	19764.5	19736.5	19745.1	1864.0
2016-07-29 05:00:00	YM	Futures	19744.1	19751.6	19732.2	19749.4	1700.0
2016-07-29 06:00:00	YM	Futures	19749.4	19759.1	19740.8	19746.2	1146.0
2016-07-29 07:00:00	YM	Futures	19746.2	19751.6	19738.7	19746.2	1507.0
2016-07-29 08:00:00	YM	Futures	19746.2	19747.3	19706.4	19726.8	5355.0
2016-07-29 09:00:00	YM	Futures	19727.9	19761.3	19710.7	19724.7	18768.0
2016-07-29 10:00:00	YM	Futures	19723.6	19763.4	19690.2	19748.4	21871.0
2016-07-29 11:00:00	YM	Futures	19748.4	19789.3	19747.3	19779.6	17009.0
2016-07-29 12:00:00	YM	Futures	19779.6	19796.8	19751.6	19758.0	9055.0
2016-07-29 13:00:00	YM	Futures	19758.0	19773.1	19749.4	19767.7	6372.0
2016-07-29 14:00:00	YM	Futures	19767.7	19776.3	19744.1	19755.9	7580.0
2016-07-29 15:00:00	YM	Futures	19757.0	19783.9	19737.6	19754.8	14286.0

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

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