PREVIEW / futures_1hour / 2017-02-22

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-02-22.parquet
  size:    52 KB
  rows:    1,600

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
2017-02-22 00:00:00	ES	Futures	2576.58	2577.94	2576.3	2576.3	4097.0
2017-02-22 01:00:00	ES	Futures	2576.3	2577.12	2576.3	2576.58	1484.0
2017-02-22 02:00:00	ES	Futures	2576.85	2577.67	2576.3	2577.12	3939.0
2017-02-22 03:00:00	ES	Futures	2576.85	2579.03	2575.76	2576.03	17838.0
2017-02-22 04:00:00	ES	Futures	2576.03	2576.58	2573.85	2574.67	14705.0
2017-02-22 05:00:00	ES	Futures	2574.39	2575.21	2570.85	2571.67	15864.0
2017-02-22 06:00:00	ES	Futures	2571.94	2573.03	2569.76	2569.76	14779.0
2017-02-22 07:00:00	ES	Futures	2569.76	2571.39	2569.76	2570.3	32955.0
2017-02-22 08:00:00	ES	Futures	2570.3	2572.76	2570.3	2572.48	35192.0
2017-02-22 09:00:00	ES	Futures	2572.48	2574.12	2570.3	2572.48	176806.0
2017-02-22 10:00:00	ES	Futures	2572.21	2578.48	2571.94	2575.48	217162.0
2017-02-22 11:00:00	ES	Futures	2575.21	2575.76	2572.76	2573.57	153545.0
2017-02-22 12:00:00	ES	Futures	2573.3	2576.58	2573.03	2576.3	90395.0
2017-02-22 13:00:00	ES	Futures	2576.58	2577.67	2575.76	2577.12	70329.0
2017-02-22 14:00:00	ES	Futures	2577.39	2577.94	2571.94	2574.39	158626.0
2017-02-22 15:00:00	ES	Futures	2574.67	2577.12	2573.57	2575.48	181873.0
2017-02-22 16:00:00	ES	Futures	2575.76	2577.39	2574.39	2577.39	72131.0
2017-02-22 18:00:00	ES	Futures	2577.12	2577.39	2574.94	2576.3	4075.0
2017-02-22 19:00:00	ES	Futures	2576.3	2576.3	2574.12	2574.39	3821.0
2017-02-22 20:00:00	ES	Futures	2574.39	2575.48	2573.85	2574.67	3194.0
2017-02-22 21:00:00	ES	Futures	2574.67	2575.21	2573.85	2574.94	2286.0
2017-02-22 22:00:00	ES	Futures	2574.94	2574.94	2574.39	2574.94	1047.0
2017-02-22 23:00:00	ES	Futures	2574.67	2575.21	2574.12	2574.12	1110.0
2017-02-22 00:00:00	NQ	Futures	6383.75	6386.73	6383.15	6383.45	950.0
2017-02-22 01:00:00	NQ	Futures	6383.45	6385.24	6383.15	6383.75	582.0
2017-02-22 02:00:00	NQ	Futures	6383.75	6386.13	6383.15	6383.75	1182.0
2017-02-22 03:00:00	NQ	Futures	6383.75	6388.52	6380.76	6381.36	3501.0
2017-02-22 04:00:00	NQ	Futures	6381.36	6382.25	6376.88	6378.67	2321.0
2017-02-22 05:00:00	NQ	Futures	6378.67	6379.57	6369.13	6370.62	3186.0
2017-02-22 06:00:00	NQ	Futures	6370.62	6374.2	6368.83	6369.13	2528.0
2017-02-22 07:00:00	NQ	Futures	6369.43	6373.3	6369.13	6372.11	2641.0
2017-02-22 08:00:00	NQ	Futures	6372.11	6377.18	6371.81	6376.59	3570.0
2017-02-22 09:00:00	NQ	Futures	6376.59	6382.85	6367.64	6372.41	25796.0
2017-02-22 10:00:00	NQ	Futures	6372.71	6385.83	6370.62	6379.87	27626.0
2017-02-22 11:00:00	NQ	Futures	6379.87	6384.04	6373.3	6379.27	14970.0
2017-02-22 12:00:00	NQ	Futures	6378.97	6387.33	6378.38	6387.03	10594.0
2017-02-22 13:00:00	NQ	Futures	6387.03	6389.12	6384.94	6387.03	8856.0
2017-02-22 14:00:00	NQ	Futures	6387.33	6390.61	6378.97	6380.46	20120.0
2017-02-22 15:00:00	NQ	Futures	6380.46	6389.12	6378.67	6386.43	16611.0
2017-02-22 16:00:00	NQ	Futures	6386.73	6388.52	6380.17	6388.52	5643.0
2017-02-22 18:00:00	NQ	Futures	6387.03	6388.52	6383.15	6385.83	943.0
2017-02-22 19:00:00	NQ	Futures	6385.54	6387.03	6381.36	6381.66	1103.0
2017-02-22 20:00:00	NQ	Futures	6381.36	6385.54	6380.17	6382.25	1056.0
2017-02-22 21:00:00	NQ	Futures	6382.25	6384.04	6380.46	6384.04	737.0
2017-02-22 22:00:00	NQ	Futures	6384.04	6384.34	6381.66	6382.55	511.0
2017-02-22 23:00:00	NQ	Futures	6382.55	6384.34	6382.25	6382.25	411.0
2017-02-22 00:00:00	YM	Futures	22464.4	22475.3	22464.4	22464.4	997.0
2017-02-22 01:00:00	YM	Futures	22465.5	22469.8	22464.4	22466.6	499.0
2017-02-22 02:00:00	YM	Futures	22466.6	22474.2	22465.5	22467.7	951.0
2017-02-22 03:00:00	YM	Futures	22467.7	22485.0	22460.1	22463.3	3270.0

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

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