PREVIEW / futures_1hour / 2014-07-24

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-07-24.parquet
  size:    48 KB
  rows:    1,543

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-07-24 00:00:00	ES	Futures	2062.5	2063.02	2062.24	2062.76	1295.0
2014-07-24 01:00:00	ES	Futures	2063.02	2063.54	2062.5	2062.76	2328.0
2014-07-24 02:00:00	ES	Futures	2063.02	2064.32	2062.5	2063.8	6166.0
2014-07-24 03:00:00	ES	Futures	2063.8	2064.84	2060.67	2062.5	37259.0
2014-07-24 04:00:00	ES	Futures	2062.5	2068.75	2062.5	2067.97	29301.0
2014-07-24 05:00:00	ES	Futures	2067.97	2068.75	2067.19	2067.45	12830.0
2014-07-24 06:00:00	ES	Futures	2067.71	2068.49	2066.93	2067.97	11755.0
2014-07-24 07:00:00	ES	Futures	2067.97	2070.06	2067.97	2069.01	22660.0
2014-07-24 08:00:00	ES	Futures	2069.01	2069.54	2067.71	2068.75	24935.0
2014-07-24 09:00:00	ES	Futures	2068.75	2069.01	2065.11	2065.63	173521.0
2014-07-24 10:00:00	ES	Futures	2065.37	2067.45	2063.54	2066.67	211917.0
2014-07-24 11:00:00	ES	Futures	2066.93	2070.06	2066.41	2068.49	124696.0
2014-07-24 12:00:00	ES	Futures	2068.49	2069.28	2067.45	2067.45	53739.0
2014-07-24 13:00:00	ES	Futures	2067.45	2068.49	2065.11	2068.49	111569.0
2014-07-24 14:00:00	ES	Futures	2068.49	2068.75	2064.32	2064.58	113653.0
2014-07-24 15:00:00	ES	Futures	2064.58	2067.71	2063.54	2065.37	130400.0
2014-07-24 16:00:00	ES	Futures	2065.63	2066.67	2061.98	2063.54	68051.0
2014-07-24 17:00:00	ES	Futures	2063.28	2063.54	2063.02	2063.28	1470.0
2014-07-24 18:00:00	ES	Futures	2062.76	2063.02	2061.2	2062.24	5654.0
2014-07-24 19:00:00	ES	Futures	2062.5	2063.02	2061.72	2062.76	2097.0
2014-07-24 20:00:00	ES	Futures	2062.76	2064.06	2062.5	2062.76	3511.0
2014-07-24 21:00:00	ES	Futures	2062.5	2063.28	2061.98	2061.98	2195.0
2014-07-24 22:00:00	ES	Futures	2061.98	2062.76	2061.46	2062.5	3197.0
2014-07-24 23:00:00	ES	Futures	2062.24	2063.8	2061.98	2063.28	3486.0
2014-07-24 00:00:00	NQ	Futures	4643.91	4645.08	4643.03	4644.79	249.0
2014-07-24 01:00:00	NQ	Futures	4644.79	4647.41	4644.49	4645.95	501.0
2014-07-24 02:00:00	NQ	Futures	4646.54	4649.46	4645.66	4648.29	838.0
2014-07-24 03:00:00	NQ	Futures	4648.58	4650.33	4639.82	4644.49	4224.0
2014-07-24 04:00:00	NQ	Futures	4644.79	4658.8	4644.49	4656.17	4360.0
2014-07-24 05:00:00	NQ	Futures	4656.47	4658.8	4654.71	4656.76	2086.0
2014-07-24 06:00:00	NQ	Futures	4656.76	4657.93	4654.42	4657.34	1760.0
2014-07-24 07:00:00	NQ	Futures	4657.34	4662.01	4656.76	4659.09	3822.0
2014-07-24 08:00:00	NQ	Futures	4659.09	4660.26	4655.01	4655.59	4641.0
2014-07-24 09:00:00	NQ	Futures	4655.88	4660.55	4641.28	4643.91	36630.0
2014-07-24 10:00:00	NQ	Futures	4644.2	4645.08	4635.15	4644.49	43810.0
2014-07-24 11:00:00	NQ	Futures	4644.49	4655.01	4642.16	4653.25	25631.0
2014-07-24 12:00:00	NQ	Futures	4653.25	4656.17	4644.49	4644.49	13673.0
2014-07-24 13:00:00	NQ	Futures	4644.49	4649.17	4636.9	4648.87	18113.0
2014-07-24 14:00:00	NQ	Futures	4648.87	4652.38	4640.11	4640.99	15346.0
2014-07-24 15:00:00	NQ	Futures	4640.99	4648.58	4638.95	4641.87	21551.0
2014-07-24 16:00:00	NQ	Futures	4641.87	4643.91	4629.6	4633.11	8451.0
2014-07-24 17:00:00	NQ	Futures	4632.81	4633.11	4631.06	4631.35	255.0
2014-07-24 18:00:00	NQ	Futures	4628.72	4629.02	4624.05	4626.1	1887.0
2014-07-24 19:00:00	NQ	Futures	4626.39	4626.97	4624.05	4626.68	582.0
2014-07-24 20:00:00	NQ	Futures	4626.97	4629.31	4626.1	4626.39	687.0
2014-07-24 21:00:00	NQ	Futures	4626.1	4627.56	4624.93	4624.93	560.0
2014-07-24 22:00:00	NQ	Futures	4624.93	4628.43	4624.93	4626.1	817.0
2014-07-24 23:00:00	NQ	Futures	4626.1	4628.72	4625.22	4627.85	530.0
2014-07-24 00:00:00	YM	Futures	17598.0	17600.1	17594.9	17598.0	334.0
2014-07-24 01:00:00	YM	Futures	17599.0	17606.3	17598.0	17601.1	636.0

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

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