PREVIEW / futures_1hour / 2016-11-11

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-11-11.parquet
  size:    48 KB
  rows:    1,329

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-11-11 00:00:00	ES	Futures	2354.84	2357.02	2354.57	2356.2	6231.0
2016-11-11 01:00:00	ES	Futures	2356.2	2362.19	2355.93	2359.2	10369.0
2016-11-11 02:00:00	ES	Futures	2359.2	2359.74	2357.84	2358.92	12335.0
2016-11-11 03:00:00	ES	Futures	2358.92	2361.65	2354.03	2354.57	43345.0
2016-11-11 04:00:00	ES	Futures	2354.57	2357.02	2351.31	2351.85	28670.0
2016-11-11 05:00:00	ES	Futures	2351.85	2352.12	2341.24	2346.14	49329.0
2016-11-11 06:00:00	ES	Futures	2345.87	2347.5	2343.69	2346.95	26459.0
2016-11-11 07:00:00	ES	Futures	2346.95	2351.31	2346.68	2350.76	31931.0
2016-11-11 08:00:00	ES	Futures	2350.49	2352.4	2346.68	2349.95	46681.0
2016-11-11 09:00:00	ES	Futures	2349.67	2352.67	2343.96	2346.41	286927.0
2016-11-11 10:00:00	ES	Futures	2346.41	2352.12	2339.88	2342.06	336200.0
2016-11-11 11:00:00	ES	Futures	2342.33	2345.32	2338.25	2343.69	241944.0
2016-11-11 12:00:00	ES	Futures	2343.96	2352.12	2343.42	2347.5	185492.0
2016-11-11 13:00:00	ES	Futures	2347.23	2351.85	2346.68	2346.68	101597.0
2016-11-11 14:00:00	ES	Futures	2346.95	2349.95	2343.42	2343.69	110692.0
2016-11-11 15:00:00	ES	Futures	2343.42	2353.21	2343.14	2350.49	205252.0
2016-11-11 16:00:00	ES	Futures	2350.76	2354.03	2350.22	2351.31	90051.0
2016-11-11 00:00:00	NQ	Futures	5619.44	5627.19	5619.44	5623.91	1291.0
2016-11-11 01:00:00	NQ	Futures	5624.21	5646.29	5623.02	5637.04	1988.0
2016-11-11 02:00:00	NQ	Futures	5636.74	5644.8	5629.28	5631.37	2517.0
2016-11-11 03:00:00	NQ	Futures	5632.26	5645.39	5622.12	5623.61	5046.0
2016-11-11 04:00:00	NQ	Futures	5623.91	5630.77	5603.92	5605.71	5076.0
2016-11-11 05:00:00	NQ	Futures	5606.31	5608.4	5586.92	5605.12	6383.0
2016-11-11 06:00:00	NQ	Futures	5605.41	5608.4	5595.27	5604.82	3849.0
2016-11-11 07:00:00	NQ	Futures	5605.41	5619.14	5602.43	5615.56	4442.0
2016-11-11 08:00:00	NQ	Futures	5615.56	5633.16	5613.77	5631.37	8610.0
2016-11-11 09:00:00	NQ	Futures	5631.37	5654.94	5615.86	5619.44	49555.0
2016-11-11 10:00:00	NQ	Futures	5620.03	5668.66	5616.15	5633.76	60738.0
2016-11-11 11:00:00	NQ	Futures	5633.76	5645.39	5617.05	5639.13	31423.0
2016-11-11 12:00:00	NQ	Futures	5639.13	5675.82	5638.53	5651.36	46861.0
2016-11-11 13:00:00	NQ	Futures	5651.36	5665.98	5646.29	5646.88	27428.0
2016-11-11 14:00:00	NQ	Futures	5646.88	5657.03	5637.64	5639.72	19328.0
2016-11-11 15:00:00	NQ	Futures	5639.72	5670.75	5639.13	5663.89	23264.0
2016-11-11 16:00:00	NQ	Futures	5663.59	5677.91	5658.82	5658.82	8170.0
2016-11-11 00:00:00	YM	Futures	20268.6	20287.0	20268.6	20281.6	1590.0
2016-11-11 01:00:00	YM	Futures	20281.6	20354.0	20279.4	20323.7	3953.0
2016-11-11 02:00:00	YM	Futures	20325.9	20332.4	20308.6	20327.0	2237.0
2016-11-11 03:00:00	YM	Futures	20327.0	20346.4	20290.2	20294.6	8182.0
2016-11-11 04:00:00	YM	Futures	20294.6	20316.2	20280.5	20289.2	5110.0
2016-11-11 05:00:00	YM	Futures	20288.1	20290.2	20215.7	20243.8	8903.0
2016-11-11 06:00:00	YM	Futures	20241.6	20260.0	20221.1	20244.8	5166.0
2016-11-11 07:00:00	YM	Futures	20244.8	20279.4	20237.3	20272.9	4285.0
2016-11-11 08:00:00	YM	Futures	20272.9	20285.9	20245.9	20272.9	4988.0
2016-11-11 09:00:00	YM	Futures	20272.9	20288.1	20223.2	20256.7	28131.0
2016-11-11 10:00:00	YM	Futures	20256.7	20280.5	20205.9	20216.7	34486.0
2016-11-11 11:00:00	YM	Futures	20216.7	20240.5	20190.8	20228.6	24542.0
2016-11-11 12:00:00	YM	Futures	20228.6	20289.2	20224.3	20257.8	19014.0
2016-11-11 13:00:00	YM	Futures	20257.8	20295.6	20251.3	20262.1	11820.0
2016-11-11 14:00:00	YM	Futures	20261.1	20290.2	20249.2	20250.3	10933.0
2016-11-11 15:00:00	YM	Futures	20250.3	20320.5	20248.1	20306.5	14753.0

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

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