PREVIEW / futures_1hour / 2015-12-16

all futures 1-hour files

  file:    by_date/futures_1hour/2015/2015-12-16.parquet
  size:    53 KB
  rows:    1,572

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-12-16 00:00:00	ES	Futures	2196.43	2196.43	2192.93	2194.55	3298.0
2015-12-16 01:00:00	ES	Futures	2194.55	2196.43	2193.74	2195.35	2433.0
2015-12-16 02:00:00	ES	Futures	2195.35	2195.62	2192.93	2195.62	5314.0
2015-12-16 03:00:00	ES	Futures	2195.62	2197.77	2190.52	2192.93	23270.0
2015-12-16 04:00:00	ES	Futures	2192.93	2196.97	2192.13	2196.97	17109.0
2015-12-16 05:00:00	ES	Futures	2196.97	2203.95	2195.35	2201.53	24626.0
2015-12-16 06:00:00	ES	Futures	2201.26	2203.41	2198.31	2200.19	19941.0
2015-12-16 07:00:00	ES	Futures	2200.19	2200.73	2196.97	2198.58	14998.0
2015-12-16 08:00:00	ES	Futures	2198.58	2202.88	2196.7	2201.26	34935.0
2015-12-16 09:00:00	ES	Futures	2201.26	2205.83	2199.11	2199.11	161966.0
2015-12-16 10:00:00	ES	Futures	2199.38	2201.26	2191.59	2194.28	182699.0
2015-12-16 11:00:00	ES	Futures	2194.28	2195.08	2189.98	2193.74	116696.0
2015-12-16 12:00:00	ES	Futures	2193.47	2196.16	2190.78	2191.32	82834.0
2015-12-16 13:00:00	ES	Futures	2191.32	2201.8	2189.98	2199.65	113709.0
2015-12-16 14:00:00	ES	Futures	2200.19	2216.85	2182.99	2215.77	446391.0
2015-12-16 15:00:00	ES	Futures	2216.04	2223.57	2208.52	2219.0	356505.0
2015-12-16 16:00:00	ES	Futures	2219.0	2221.69	2213.89	2214.16	92943.0
2015-12-16 18:00:00	ES	Futures	2214.97	2218.19	2213.36	2217.39	7425.0
2015-12-16 19:00:00	ES	Futures	2217.12	2217.66	2213.89	2214.43	5316.0
2015-12-16 20:00:00	ES	Futures	2214.43	2215.51	2209.86	2212.82	9846.0
2015-12-16 21:00:00	ES	Futures	2212.82	2216.04	2212.28	2214.97	5128.0
2015-12-16 22:00:00	ES	Futures	2214.97	2215.51	2211.21	2211.74	5735.0
2015-12-16 23:00:00	ES	Futures	2211.74	2213.89	2210.4	2210.94	4124.0
2015-12-16 00:00:00	NQ	Futures	5482.54	5482.54	5474.52	5477.2	451.0
2015-12-16 01:00:00	NQ	Futures	5477.49	5482.54	5476.3	5479.87	327.0
2015-12-16 02:00:00	NQ	Futures	5479.27	5482.24	5474.82	5482.24	698.0
2015-12-16 03:00:00	NQ	Futures	5482.54	5488.78	5470.66	5476.6	4133.0
2015-12-16 04:00:00	NQ	Futures	5476.3	5485.81	5474.23	5485.51	1943.0
2015-12-16 05:00:00	NQ	Futures	5485.51	5503.33	5481.35	5496.79	2917.0
2015-12-16 06:00:00	NQ	Futures	5496.2	5503.03	5490.56	5492.64	2638.0
2015-12-16 07:00:00	NQ	Futures	5492.64	5492.93	5483.73	5486.4	2751.0
2015-12-16 08:00:00	NQ	Futures	5487.29	5495.9	5484.02	5493.53	4088.0
2015-12-16 09:00:00	NQ	Futures	5493.82	5504.51	5475.71	5476.01	23797.0
2015-12-16 10:00:00	NQ	Futures	5476.6	5481.95	5451.36	5466.8	37307.0
2015-12-16 11:00:00	NQ	Futures	5466.8	5470.66	5456.11	5461.76	21186.0
2015-12-16 12:00:00	NQ	Futures	5461.46	5466.51	5452.85	5453.74	13831.0
2015-12-16 13:00:00	NQ	Futures	5454.03	5481.06	5450.77	5475.12	15714.0
2015-12-16 14:00:00	NQ	Futures	5477.79	5527.67	5433.84	5526.19	61946.0
2015-12-16 15:00:00	NQ	Futures	5526.19	5546.38	5506.0	5535.69	41839.0
2015-12-16 16:00:00	NQ	Futures	5535.99	5542.82	5522.03	5523.22	9883.0
2015-12-16 18:00:00	NQ	Futures	5523.22	5533.32	5522.33	5530.64	876.0
2015-12-16 19:00:00	NQ	Futures	5530.64	5531.83	5524.11	5525.89	837.0
2015-12-16 20:00:00	NQ	Futures	5525.6	5526.78	5516.09	5520.55	1817.0
2015-12-16 21:00:00	NQ	Futures	5521.14	5529.46	5520.84	5526.49	698.0
2015-12-16 22:00:00	NQ	Futures	5526.78	5528.56	5517.58	5519.06	720.0
2015-12-16 23:00:00	NQ	Futures	5518.77	5524.7	5515.8	5517.58	616.0
2015-12-16 00:00:00	YM	Futures	18663.5	18663.5	18616.7	18626.2	3039.0
2015-12-16 01:00:00	YM	Futures	18627.3	18659.2	18625.2	18644.3	1650.0
2015-12-16 02:00:00	YM	Futures	18643.3	18645.4	18624.1	18642.2	795.0
2015-12-16 03:00:00	YM	Futures	18644.3	18661.4	18611.3	18631.6	4174.0

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

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