PREVIEW / futures_1hour / 2016-12-08

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-12-08.parquet
  size:    55 KB
  rows:    1,620

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-12-08 00:00:00	ES	Futures	2435.92	2437.83	2435.65	2437.01	3516.0
2016-12-08 01:00:00	ES	Futures	2437.01	2437.56	2435.92	2435.92	5001.0
2016-12-08 02:00:00	ES	Futures	2435.92	2436.2	2433.75	2434.29	10500.0
2016-12-08 03:00:00	ES	Futures	2434.56	2436.2	2432.93	2433.2	24910.0
2016-12-08 04:00:00	ES	Futures	2433.47	2434.56	2432.11	2433.75	15767.0
2016-12-08 05:00:00	ES	Futures	2433.75	2436.2	2433.2	2435.92	13699.0
2016-12-08 06:00:00	ES	Futures	2435.92	2436.74	2434.29	2435.11	11134.0
2016-12-08 07:00:00	ES	Futures	2435.11	2438.37	2429.67	2436.2	54304.0
2016-12-08 08:00:00	ES	Futures	2436.2	2439.46	2432.11	2437.28	94922.0
2016-12-08 09:00:00	ES	Futures	2437.28	2441.91	2435.11	2437.83	265517.0
2016-12-08 10:00:00	ES	Futures	2437.83	2440.0	2434.29	2439.46	210854.0
2016-12-08 11:00:00	ES	Futures	2439.46	2441.64	2437.56	2440.28	162486.0
2016-12-08 12:00:00	ES	Futures	2440.28	2448.98	2440.0	2445.99	174390.0
2016-12-08 13:00:00	ES	Futures	2445.99	2450.34	2444.63	2449.8	122154.0
2016-12-08 14:00:00	ES	Futures	2449.53	2449.8	2440.0	2443.27	205276.0
2016-12-08 15:00:00	ES	Futures	2443.54	2445.99	2441.36	2443.81	220157.0
2016-12-08 16:00:00	ES	Futures	2444.09	2446.81	2443.54	2446.26	70647.0
2016-12-08 18:00:00	ES	Futures	2445.17	2446.26	2444.9	2445.45	2600.0
2016-12-08 19:00:00	ES	Futures	2445.17	2446.53	2445.17	2446.26	2183.0
2016-12-08 20:00:00	ES	Futures	2446.26	2447.35	2445.72	2446.26	3803.0
2016-12-08 21:00:00	ES	Futures	2445.99	2446.26	2443.81	2445.45	4173.0
2016-12-08 22:00:00	ES	Futures	2445.17	2445.99	2444.9	2445.72	2026.0
2016-12-08 23:00:00	ES	Futures	2445.99	2446.53	2445.72	2446.26	1411.0
2016-12-08 00:00:00	NQ	Futures	5786.5	5792.47	5786.5	5790.98	692.0
2016-12-08 01:00:00	NQ	Futures	5790.98	5791.87	5787.7	5788.29	568.0
2016-12-08 02:00:00	NQ	Futures	5788.0	5788.29	5782.03	5784.12	1136.0
2016-12-08 03:00:00	NQ	Futures	5784.12	5788.89	5781.43	5781.43	2154.0
2016-12-08 04:00:00	NQ	Futures	5781.73	5783.22	5777.55	5781.43	1688.0
2016-12-08 05:00:00	NQ	Futures	5781.43	5787.7	5779.34	5786.5	1436.0
2016-12-08 06:00:00	NQ	Futures	5786.8	5788.0	5780.84	5782.92	1246.0
2016-12-08 07:00:00	NQ	Futures	5783.22	5789.79	5770.99	5783.52	5858.0
2016-12-08 08:00:00	NQ	Futures	5783.82	5790.98	5773.08	5783.52	9863.0
2016-12-08 09:00:00	NQ	Futures	5783.52	5805.9	5776.66	5792.17	37218.0
2016-12-08 10:00:00	NQ	Futures	5791.87	5805.3	5782.33	5800.82	28714.0
2016-12-08 11:00:00	NQ	Futures	5801.12	5809.48	5791.87	5797.54	20270.0
2016-12-08 12:00:00	NQ	Futures	5797.84	5810.97	5796.05	5801.42	14563.0
2016-12-08 13:00:00	NQ	Futures	5802.02	5803.81	5790.98	5800.82	14387.0
2016-12-08 14:00:00	NQ	Futures	5800.82	5802.61	5777.55	5787.1	26258.0
2016-12-08 15:00:00	NQ	Futures	5787.1	5799.33	5785.01	5796.95	24559.0
2016-12-08 16:00:00	NQ	Futures	5796.95	5804.7	5796.35	5804.7	5540.0
2016-12-08 18:00:00	NQ	Futures	5801.12	5803.21	5799.63	5800.82	503.0
2016-12-08 19:00:00	NQ	Futures	5800.82	5802.32	5799.63	5802.32	140.0
2016-12-08 20:00:00	NQ	Futures	5802.02	5804.4	5800.82	5800.82	272.0
2016-12-08 21:00:00	NQ	Futures	5801.12	5802.91	5796.35	5801.12	482.0
2016-12-08 22:00:00	NQ	Futures	5801.42	5803.21	5799.63	5802.32	394.0
2016-12-08 23:00:00	NQ	Futures	5802.61	5804.4	5801.72	5803.81	241.0
2016-12-08 00:00:00	YM	Futures	21107.3	21123.5	21106.2	21118.1	1298.0
2016-12-08 01:00:00	YM	Futures	21119.2	21124.6	21110.5	21112.7	930.0
2016-12-08 02:00:00	YM	Futures	21111.6	21118.1	21100.8	21107.3	2446.0
2016-12-08 03:00:00	YM	Futures	21107.3	21118.1	21097.6	21099.7	3771.0

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

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