PREVIEW / futures_1hour / 2017-04-17

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-04-17.parquet
  size:    42 KB
  rows:    1,281

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-04-17 00:00:00	ES	Futures	2539.68	2541.05	2539.68	2539.68	3026.0
2017-04-17 01:00:00	ES	Futures	2539.96	2541.05	2539.68	2540.23	2052.0
2017-04-17 02:00:00	ES	Futures	2540.23	2541.6	2539.96	2540.78	3576.0
2017-04-17 03:00:00	ES	Futures	2541.05	2541.87	2540.5	2540.78	3288.0
2017-04-17 04:00:00	ES	Futures	2541.05	2541.05	2539.41	2539.68	2315.0
2017-04-17 05:00:00	ES	Futures	2539.68	2540.5	2539.14	2540.5	2528.0
2017-04-17 06:00:00	ES	Futures	2540.5	2540.78	2539.68	2540.5	2436.0
2017-04-17 07:00:00	ES	Futures	2540.5	2546.24	2539.68	2546.24	13912.0
2017-04-17 08:00:00	ES	Futures	2545.97	2548.15	2544.6	2547.06	21863.0
2017-04-17 09:00:00	ES	Futures	2547.06	2549.24	2544.33	2548.15	112347.0
2017-04-17 10:00:00	ES	Futures	2547.88	2554.16	2547.6	2552.52	153083.0
2017-04-17 11:00:00	ES	Futures	2552.52	2555.8	2551.7	2551.97	87841.0
2017-04-17 12:00:00	ES	Futures	2551.7	2555.8	2551.7	2553.34	60719.0
2017-04-17 13:00:00	ES	Futures	2553.61	2556.07	2553.07	2554.71	53899.0
2017-04-17 14:00:00	ES	Futures	2554.71	2557.44	2553.89	2554.98	83206.0
2017-04-17 15:00:00	ES	Futures	2554.71	2562.63	2554.16	2562.63	239754.0
2017-04-17 16:00:00	ES	Futures	2562.63	2563.17	2560.72	2562.35	82602.0
2017-04-17 18:00:00	ES	Futures	2562.08	2562.35	2560.72	2561.81	4873.0
2017-04-17 19:00:00	ES	Futures	2561.81	2562.08	2560.72	2561.26	2768.0
2017-04-17 20:00:00	ES	Futures	2561.26	2564.27	2560.44	2560.99	10725.0
2017-04-17 21:00:00	ES	Futures	2560.99	2562.08	2560.17	2560.72	9151.0
2017-04-17 22:00:00	ES	Futures	2560.72	2561.81	2560.44	2560.99	3709.0
2017-04-17 23:00:00	ES	Futures	2560.99	2561.53	2560.17	2560.44	3819.0
2017-04-17 00:00:00	NQ	Futures	6384.97	6387.95	6383.48	6384.67	560.0
2017-04-17 01:00:00	NQ	Futures	6384.67	6388.55	6384.67	6387.65	508.0
2017-04-17 02:00:00	NQ	Futures	6387.06	6391.83	6386.46	6389.14	828.0
2017-04-17 03:00:00	NQ	Futures	6389.14	6391.53	6387.65	6389.44	461.0
2017-04-17 04:00:00	NQ	Futures	6389.44	6389.44	6384.37	6385.57	481.0
2017-04-17 05:00:00	NQ	Futures	6385.27	6388.85	6384.37	6388.55	408.0
2017-04-17 06:00:00	NQ	Futures	6388.55	6390.34	6386.76	6387.95	810.0
2017-04-17 07:00:00	NQ	Futures	6388.25	6401.37	6384.97	6401.37	2930.0
2017-04-17 08:00:00	NQ	Futures	6401.07	6406.14	6398.09	6405.24	3333.0
2017-04-17 09:00:00	NQ	Futures	6405.54	6414.78	6400.47	6408.52	21566.0
2017-04-17 10:00:00	NQ	Futures	6408.52	6429.39	6407.33	6419.85	27303.0
2017-04-17 11:00:00	NQ	Futures	6420.15	6426.11	6415.38	6415.68	12326.0
2017-04-17 12:00:00	NQ	Futures	6415.38	6424.62	6414.49	6418.66	9572.0
2017-04-17 13:00:00	NQ	Futures	6418.66	6425.82	6418.06	6421.34	8653.0
2017-04-17 14:00:00	NQ	Futures	6421.94	6426.71	6418.96	6421.34	10749.0
2017-04-17 15:00:00	NQ	Futures	6421.64	6439.23	6419.26	6437.44	30246.0
2017-04-17 16:00:00	NQ	Futures	6437.44	6439.23	6430.59	6437.14	8082.0
2017-04-17 18:00:00	NQ	Futures	6436.85	6437.14	6432.67	6435.36	984.0
2017-04-17 19:00:00	NQ	Futures	6435.65	6436.25	6434.16	6436.25	484.0
2017-04-17 20:00:00	NQ	Futures	6436.25	6444.3	6435.95	6436.55	2959.0
2017-04-17 21:00:00	NQ	Futures	6436.85	6438.64	6434.46	6435.65	2016.0
2017-04-17 22:00:00	NQ	Futures	6435.65	6438.64	6435.06	6437.44	1067.0
2017-04-17 23:00:00	NQ	Futures	6437.44	6438.93	6435.95	6437.14	997.0
2017-04-17 00:00:00	YM	Futures	22160.8	22171.6	22158.6	22159.7	486.0
2017-04-17 01:00:00	YM	Futures	22159.7	22169.5	22159.7	22166.2	400.0
2017-04-17 02:00:00	YM	Futures	22165.1	22178.1	22162.9	22169.5	593.0
2017-04-17 03:00:00	YM	Futures	22170.5	22177.1	22165.1	22169.5	704.0

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

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