PREVIEW / futures_1hour / 2014-08-14

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-08-14.parquet
  size:    48 KB
  rows:    1,540

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-08-14 00:00:00	ES	Futures	2027.84	2028.1	2027.06	2027.32	1221.0
2014-08-14 01:00:00	ES	Futures	2027.32	2028.88	2027.32	2028.1	2911.0
2014-08-14 02:00:00	ES	Futures	2028.1	2028.1	2024.71	2025.49	11465.0
2014-08-14 03:00:00	ES	Futures	2025.49	2027.58	2024.45	2026.27	25070.0
2014-08-14 04:00:00	ES	Futures	2026.53	2027.84	2024.97	2026.27	20579.0
2014-08-14 05:00:00	ES	Futures	2026.01	2026.79	2024.97	2026.53	10414.0
2014-08-14 06:00:00	ES	Futures	2026.27	2031.75	2026.27	2030.44	39835.0
2014-08-14 07:00:00	ES	Futures	2030.44	2030.7	2028.88	2029.92	19505.0
2014-08-14 08:00:00	ES	Futures	2029.92	2030.7	2024.97	2026.79	46476.0
2014-08-14 09:00:00	ES	Futures	2026.79	2030.44	2026.53	2029.14	138209.0
2014-08-14 10:00:00	ES	Futures	2029.14	2032.01	2026.53	2029.4	151397.0
2014-08-14 11:00:00	ES	Futures	2029.4	2032.53	2029.14	2032.01	94164.0
2014-08-14 12:00:00	ES	Futures	2032.01	2032.79	2030.7	2032.01	59660.0
2014-08-14 13:00:00	ES	Futures	2032.01	2034.35	2030.96	2031.75	86089.0
2014-08-14 14:00:00	ES	Futures	2032.01	2033.31	2030.96	2032.79	55885.0
2014-08-14 15:00:00	ES	Futures	2032.79	2034.87	2032.53	2034.61	101582.0
2014-08-14 16:00:00	ES	Futures	2034.87	2037.74	2034.35	2036.96	77508.0
2014-08-14 17:00:00	ES	Futures	2036.96	2038.0	2036.96	2037.48	5173.0
2014-08-14 18:00:00	ES	Futures	2037.22	2037.48	2035.66	2035.92	5081.0
2014-08-14 19:00:00	ES	Futures	2036.18	2036.44	2035.13	2035.4	2672.0
2014-08-14 20:00:00	ES	Futures	2035.13	2035.66	2034.61	2035.13	3117.0
2014-08-14 21:00:00	ES	Futures	2035.4	2036.44	2035.13	2035.92	1956.0
2014-08-14 22:00:00	ES	Futures	2035.92	2036.18	2035.4	2035.4	1313.0
2014-08-14 23:00:00	ES	Futures	2035.4	2036.7	2035.13	2036.7	1659.0
2014-08-14 00:00:00	NQ	Futures	4610.33	4610.33	4608.28	4608.87	156.0
2014-08-14 01:00:00	NQ	Futures	4609.16	4611.79	4608.58	4609.74	361.0
2014-08-14 02:00:00	NQ	Futures	4609.74	4609.74	4603.32	4604.2	1246.0
2014-08-14 03:00:00	NQ	Futures	4604.49	4609.74	4602.15	4605.66	4323.0
2014-08-14 04:00:00	NQ	Futures	4605.07	4610.62	4601.57	4606.24	3614.0
2014-08-14 05:00:00	NQ	Futures	4606.24	4608.58	4604.2	4607.7	1950.0
2014-08-14 06:00:00	NQ	Futures	4607.7	4621.13	4607.7	4615.29	8057.0
2014-08-14 07:00:00	NQ	Futures	4615.58	4617.04	4612.96	4616.46	3932.0
2014-08-14 08:00:00	NQ	Futures	4616.17	4617.63	4606.24	4610.62	7102.0
2014-08-14 09:00:00	NQ	Futures	4610.62	4619.09	4608.28	4616.75	30730.0
2014-08-14 10:00:00	NQ	Futures	4617.04	4620.84	4609.16	4617.63	27895.0
2014-08-14 11:00:00	NQ	Futures	4617.34	4623.76	4616.17	4622.3	16891.0
2014-08-14 12:00:00	NQ	Futures	4622.3	4623.47	4618.8	4621.72	8456.0
2014-08-14 13:00:00	NQ	Futures	4621.42	4628.43	4619.38	4625.22	17731.0
2014-08-14 14:00:00	NQ	Futures	4625.51	4629.02	4623.47	4628.14	12530.0
2014-08-14 15:00:00	NQ	Futures	4627.85	4633.11	4626.97	4631.94	16354.0
2014-08-14 16:00:00	NQ	Futures	4632.23	4640.99	4630.48	4638.95	9938.0
2014-08-14 17:00:00	NQ	Futures	4639.24	4642.74	4638.65	4641.87	1123.0
2014-08-14 18:00:00	NQ	Futures	4640.7	4641.28	4636.9	4637.78	743.0
2014-08-14 19:00:00	NQ	Futures	4637.78	4638.36	4636.61	4636.9	279.0
2014-08-14 20:00:00	NQ	Futures	4636.9	4637.49	4636.03	4636.9	502.0
2014-08-14 21:00:00	NQ	Futures	4636.61	4638.95	4636.61	4637.19	548.0
2014-08-14 22:00:00	NQ	Futures	4637.19	4638.07	4636.03	4637.19	316.0
2014-08-14 23:00:00	NQ	Futures	4636.9	4639.82	4636.32	4639.82	411.0
2014-08-14 00:00:00	YM	Futures	17199.7	17199.7	17190.4	17192.5	271.0
2014-08-14 01:00:00	YM	Futures	17192.5	17202.8	17191.4	17196.6	544.0

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

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