PREVIEW / futures_1hour / 2017-06-15

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-06-15.parquet
  size:    53 KB
  rows:    1,648

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-06-15 00:00:00	ES	Futures	2655.76	2657.13	2655.49	2656.86	3461.0
2017-06-15 01:00:00	ES	Futures	2656.86	2657.68	2656.31	2657.4	3593.0
2017-06-15 02:00:00	ES	Futures	2657.4	2657.68	2655.22	2656.04	8136.0
2017-06-15 03:00:00	ES	Futures	2655.76	2656.58	2649.75	2650.84	42921.0
2017-06-15 04:00:00	ES	Futures	2651.12	2652.76	2648.11	2648.38	25229.0
2017-06-15 05:00:00	ES	Futures	2648.38	2651.39	2645.65	2645.92	26746.0
2017-06-15 06:00:00	ES	Futures	2645.92	2646.74	2642.1	2646.2	38758.0
2017-06-15 07:00:00	ES	Futures	2646.2	2647.29	2644.83	2645.38	28057.0
2017-06-15 08:00:00	ES	Futures	2645.65	2647.56	2642.92	2647.02	46602.0
2017-06-15 09:00:00	ES	Futures	2647.29	2650.3	2643.74	2649.2	263660.0
2017-06-15 10:00:00	ES	Futures	2648.93	2651.39	2641.82	2648.66	302350.0
2017-06-15 11:00:00	ES	Futures	2648.66	2654.94	2648.11	2650.84	224073.0
2017-06-15 12:00:00	ES	Futures	2651.12	2653.58	2649.48	2653.3	105746.0
2017-06-15 13:00:00	ES	Futures	2653.3	2655.76	2651.12	2652.76	102653.0
2017-06-15 14:00:00	ES	Futures	2652.48	2657.4	2651.94	2656.04	87567.0
2017-06-15 15:00:00	ES	Futures	2656.04	2659.04	2653.3	2657.68	184379.0
2017-06-15 16:00:00	ES	Futures	2657.95	2660.41	2657.4	2658.77	70331.0
2017-06-15 18:00:00	ES	Futures	2658.22	2659.04	2656.58	2657.4	6696.0
2017-06-15 19:00:00	ES	Futures	2657.4	2658.77	2656.86	2658.77	2454.0
2017-06-15 20:00:00	ES	Futures	2658.77	2662.05	2658.5	2660.68	11411.0
2017-06-15 21:00:00	ES	Futures	2660.96	2662.6	2660.68	2662.05	2732.0
2017-06-15 22:00:00	ES	Futures	2662.32	2662.6	2661.23	2661.78	2278.0
2017-06-15 23:00:00	ES	Futures	2661.78	2663.69	2661.78	2662.6	4735.0
2017-06-15 00:00:00	NQ	Futures	6793.19	6799.15	6792.6	6795.28	1119.0
2017-06-15 01:00:00	NQ	Futures	6795.28	6799.45	6790.81	6799.15	1223.0
2017-06-15 02:00:00	NQ	Futures	6799.15	6799.75	6789.92	6792.0	1473.0
2017-06-15 03:00:00	NQ	Futures	6792.0	6794.68	6758.95	6759.85	9464.0
2017-06-15 04:00:00	NQ	Futures	6759.85	6769.08	6746.45	6748.23	6517.0
2017-06-15 05:00:00	NQ	Futures	6748.23	6762.23	6743.47	6751.21	4895.0
2017-06-15 06:00:00	NQ	Futures	6750.91	6756.87	6739.6	6756.57	6605.0
2017-06-15 07:00:00	NQ	Futures	6756.57	6761.93	6754.78	6756.57	9219.0
2017-06-15 08:00:00	NQ	Futures	6756.27	6767.29	6748.83	6766.1	10999.0
2017-06-15 09:00:00	NQ	Futures	6766.1	6774.14	6725.01	6749.43	73590.0
2017-06-15 10:00:00	NQ	Futures	6749.13	6757.46	6718.76	6755.38	76829.0
2017-06-15 11:00:00	NQ	Futures	6755.68	6773.25	6749.43	6755.08	49980.0
2017-06-15 12:00:00	NQ	Futures	6755.08	6780.69	6752.4	6777.71	28032.0
2017-06-15 13:00:00	NQ	Futures	6778.01	6786.64	6764.02	6772.35	26607.0
2017-06-15 14:00:00	NQ	Futures	6772.65	6798.55	6768.18	6790.81	30001.0
2017-06-15 15:00:00	NQ	Futures	6790.81	6806.59	6786.94	6798.85	47596.0
2017-06-15 16:00:00	NQ	Futures	6798.55	6804.81	6792.0	6800.94	8207.0
2017-06-15 18:00:00	NQ	Futures	6799.45	6802.13	6792.6	6794.39	1098.0
2017-06-15 19:00:00	NQ	Futures	6794.39	6799.15	6792.9	6799.15	781.0
2017-06-15 20:00:00	NQ	Futures	6799.45	6808.08	6799.45	6804.81	1645.0
2017-06-15 21:00:00	NQ	Futures	6804.51	6809.87	6804.21	6807.78	868.0
2017-06-15 22:00:00	NQ	Futures	6808.08	6811.06	6806.59	6808.98	984.0
2017-06-15 23:00:00	NQ	Futures	6809.27	6821.48	6808.68	6817.91	2169.0
2017-06-15 00:00:00	YM	Futures	23179.2	23195.5	23165.1	23184.7	1545.0
2017-06-15 01:00:00	YM	Futures	23184.7	23192.3	23183.6	23186.8	1018.0
2017-06-15 02:00:00	YM	Futures	23186.8	23190.1	23171.6	23178.1	1548.0
2017-06-15 03:00:00	YM	Futures	23178.1	23183.6	23134.6	23149.8	8329.0

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

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