PREVIEW / futures_1hour / 2016-08-11

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-08-11.parquet
  size:    52 KB
  rows:    1,575

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-08-11 00:00:00	ES	Futures	2357.42	2359.05	2357.42	2358.78	3041.0
2016-08-11 01:00:00	ES	Futures	2358.78	2359.59	2357.97	2359.32	2917.0
2016-08-11 02:00:00	ES	Futures	2359.59	2363.66	2359.59	2361.49	15248.0
2016-08-11 03:00:00	ES	Futures	2361.49	2362.03	2356.34	2357.15	22802.0
2016-08-11 04:00:00	ES	Futures	2356.88	2359.32	2356.88	2359.05	12865.0
2016-08-11 05:00:00	ES	Futures	2359.05	2361.49	2359.05	2360.95	14039.0
2016-08-11 06:00:00	ES	Futures	2360.95	2363.12	2360.41	2362.58	14416.0
2016-08-11 07:00:00	ES	Futures	2362.58	2363.66	2361.49	2361.49	19418.0
2016-08-11 08:00:00	ES	Futures	2361.76	2362.85	2360.68	2361.76	22849.0
2016-08-11 09:00:00	ES	Futures	2362.03	2365.56	2361.76	2362.03	197006.0
2016-08-11 10:00:00	ES	Futures	2362.03	2367.73	2359.59	2365.83	238324.0
2016-08-11 11:00:00	ES	Futures	2366.1	2369.36	2365.29	2368.27	151638.0
2016-08-11 12:00:00	ES	Futures	2368.27	2368.81	2367.19	2367.73	86938.0
2016-08-11 13:00:00	ES	Futures	2368.0	2369.36	2367.19	2368.0	80051.0
2016-08-11 14:00:00	ES	Futures	2368.0	2370.17	2366.1	2367.46	126979.0
2016-08-11 15:00:00	ES	Futures	2367.46	2370.44	2367.19	2367.19	211323.0
2016-08-11 16:00:00	ES	Futures	2367.19	2367.46	2365.02	2366.64	80616.0
2016-08-11 18:00:00	ES	Futures	2366.64	2367.46	2366.1	2366.92	2853.0
2016-08-11 19:00:00	ES	Futures	2367.19	2368.27	2366.92	2367.19	2965.0
2016-08-11 20:00:00	ES	Futures	2367.46	2368.0	2366.1	2366.37	5120.0
2016-08-11 21:00:00	ES	Futures	2366.37	2367.19	2365.83	2365.83	4643.0
2016-08-11 22:00:00	ES	Futures	2365.83	2366.37	2365.29	2365.83	4044.0
2016-08-11 23:00:00	ES	Futures	2365.83	2366.1	2365.29	2365.29	1444.0
2016-08-11 00:00:00	NQ	Futures	5701.13	5705.6	5701.13	5704.11	552.0
2016-08-11 01:00:00	NQ	Futures	5704.11	5708.58	5703.51	5708.58	476.0
2016-08-11 02:00:00	NQ	Futures	5708.58	5718.72	5708.28	5713.65	2135.0
2016-08-11 03:00:00	NQ	Futures	5713.95	5715.44	5700.53	5703.81	2840.0
2016-08-11 04:00:00	NQ	Futures	5703.81	5709.77	5703.22	5709.77	925.0
2016-08-11 05:00:00	NQ	Futures	5709.77	5716.33	5709.18	5714.24	1825.0
2016-08-11 06:00:00	NQ	Futures	5714.54	5718.42	5713.65	5716.63	1216.0
2016-08-11 07:00:00	NQ	Futures	5716.63	5719.31	5715.14	5715.14	1567.0
2016-08-11 08:00:00	NQ	Futures	5714.84	5716.93	5712.16	5715.14	2389.0
2016-08-11 09:00:00	NQ	Futures	5715.14	5735.7	5715.14	5722.59	32922.0
2016-08-11 10:00:00	NQ	Futures	5722.59	5725.57	5706.5	5719.61	26934.0
2016-08-11 11:00:00	NQ	Futures	5719.31	5727.66	5715.73	5726.46	14283.0
2016-08-11 12:00:00	NQ	Futures	5726.46	5727.36	5721.7	5724.68	10135.0
2016-08-11 13:00:00	NQ	Futures	5724.97	5729.74	5723.19	5726.17	7382.0
2016-08-11 14:00:00	NQ	Futures	5726.17	5731.53	5719.61	5722.59	12611.0
2016-08-11 15:00:00	NQ	Futures	5722.29	5732.13	5721.99	5723.19	16346.0
2016-08-11 16:00:00	NQ	Futures	5723.19	5724.97	5718.12	5723.19	5823.0
2016-08-11 18:00:00	NQ	Futures	5722.59	5725.57	5721.7	5724.38	379.0
2016-08-11 19:00:00	NQ	Futures	5724.68	5728.25	5724.38	5726.17	530.0
2016-08-11 20:00:00	NQ	Futures	5726.46	5727.36	5722.29	5723.48	581.0
2016-08-11 21:00:00	NQ	Futures	5723.48	5724.68	5721.7	5722.29	519.0
2016-08-11 22:00:00	NQ	Futures	5722.29	5722.59	5719.91	5721.4	413.0
2016-08-11 23:00:00	NQ	Futures	5721.4	5721.99	5718.42	5719.61	358.0
2016-08-11 00:00:00	YM	Futures	19870.0	19882.9	19870.0	19880.7	449.0
2016-08-11 01:00:00	YM	Futures	19879.7	19891.5	19877.5	19890.4	710.0
2016-08-11 02:00:00	YM	Futures	19891.5	19920.6	19889.3	19903.3	2410.0
2016-08-11 03:00:00	YM	Futures	19903.3	19909.8	19865.7	19875.4	3117.0

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

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