PREVIEW / futures_1hour / 2017-06-12

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-06-12.parquet
  size:    49 KB
  rows:    1,555

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-12 00:00:00	ES	Futures	2652.22	2652.22	2651.4	2651.95	1320.0
2017-06-12 01:00:00	ES	Futures	2651.95	2652.22	2651.4	2651.95	1187.0
2017-06-12 02:00:00	ES	Futures	2651.95	2653.04	2650.85	2652.49	5082.0
2017-06-12 03:00:00	ES	Futures	2652.49	2653.31	2649.76	2651.95	8117.0
2017-06-12 04:00:00	ES	Futures	2651.67	2652.22	2646.76	2647.3	10166.0
2017-06-12 05:00:00	ES	Futures	2647.3	2650.31	2646.21	2648.67	10075.0
2017-06-12 06:00:00	ES	Futures	2648.67	2650.58	2647.3	2649.76	7174.0
2017-06-12 07:00:00	ES	Futures	2649.49	2650.31	2647.3	2648.39	7763.0
2017-06-12 08:00:00	ES	Futures	2648.39	2652.76	2648.12	2651.4	10187.0
2017-06-12 09:00:00	ES	Futures	2651.13	2654.4	2644.02	2645.66	66482.0
2017-06-12 10:00:00	ES	Futures	2645.94	2651.67	2642.93	2650.85	71833.0
2017-06-12 11:00:00	ES	Futures	2650.85	2652.76	2647.57	2649.21	47611.0
2017-06-12 12:00:00	ES	Futures	2649.49	2650.03	2644.3	2644.3	23863.0
2017-06-12 13:00:00	ES	Futures	2644.57	2649.21	2644.02	2644.57	25432.0
2017-06-12 14:00:00	ES	Futures	2644.57	2650.85	2644.3	2649.49	23196.0
2017-06-12 15:00:00	ES	Futures	2649.21	2654.13	2647.85	2653.31	60882.0
2017-06-12 16:00:00	ES	Futures	2653.58	2654.68	2652.49	2654.4	22177.0
2017-06-12 18:00:00	ES	Futures	2653.58	2653.86	2651.95	2653.31	1572.0
2017-06-12 19:00:00	ES	Futures	2653.31	2654.13	2652.76	2654.13	1126.0
2017-06-12 20:00:00	ES	Futures	2654.13	2657.95	2654.13	2656.04	3632.0
2017-06-12 21:00:00	ES	Futures	2656.04	2657.68	2655.5	2656.32	1197.0
2017-06-12 22:00:00	ES	Futures	2656.32	2657.41	2655.77	2656.04	1521.0
2017-06-12 23:00:00	ES	Futures	2656.04	2657.68	2655.77	2656.86	1692.0
2017-06-12 00:00:00	NQ	Futures	6830.39	6830.69	6827.41	6829.2	430.0
2017-06-12 01:00:00	NQ	Futures	6828.6	6829.2	6825.62	6825.92	393.0
2017-06-12 02:00:00	NQ	Futures	6825.62	6826.52	6803.26	6815.19	2752.0
2017-06-12 03:00:00	NQ	Futures	6815.19	6815.19	6800.58	6804.16	2009.0
2017-06-12 04:00:00	NQ	Futures	6804.45	6806.54	6761.82	6766.59	6204.0
2017-06-12 05:00:00	NQ	Futures	6765.99	6791.63	6764.8	6791.04	2833.0
2017-06-12 06:00:00	NQ	Futures	6790.74	6803.56	6788.65	6799.68	1851.0
2017-06-12 07:00:00	NQ	Futures	6799.39	6800.58	6771.36	6775.83	2156.0
2017-06-12 08:00:00	NQ	Futures	6775.83	6804.75	6768.68	6794.02	4146.0
2017-06-12 09:00:00	NQ	Futures	6793.72	6797.89	6719.48	6743.04	49359.0
2017-06-12 10:00:00	NQ	Futures	6743.04	6792.23	6732.6	6783.29	34941.0
2017-06-12 11:00:00	NQ	Futures	6782.69	6817.57	6777.02	6790.44	22087.0
2017-06-12 12:00:00	NQ	Futures	6789.84	6795.21	6762.42	6765.4	8247.0
2017-06-12 13:00:00	NQ	Futures	6764.8	6789.55	6758.54	6767.48	6364.0
2017-06-12 14:00:00	NQ	Futures	6767.19	6804.16	6765.4	6787.46	7269.0
2017-06-12 15:00:00	NQ	Futures	6787.16	6807.44	6777.02	6805.94	14881.0
2017-06-12 16:00:00	NQ	Futures	6805.94	6815.19	6802.66	6814.59	2755.0
2017-06-12 18:00:00	NQ	Futures	6813.4	6814.29	6805.65	6810.71	391.0
2017-06-12 19:00:00	NQ	Futures	6810.71	6814.59	6808.63	6814.59	267.0
2017-06-12 20:00:00	NQ	Futures	6814.29	6822.04	6813.99	6818.47	1173.0
2017-06-12 21:00:00	NQ	Futures	6818.17	6825.03	6818.17	6819.06	638.0
2017-06-12 22:00:00	NQ	Futures	6819.36	6822.64	6818.76	6819.66	272.0
2017-06-12 23:00:00	NQ	Futures	6819.66	6825.32	6819.36	6823.24	226.0
2017-06-12 00:00:00	YM	Futures	23057.3	23057.3	23046.4	23053.0	539.0
2017-06-12 01:00:00	YM	Futures	23051.9	23057.3	23046.4	23056.2	431.0
2017-06-12 02:00:00	YM	Futures	23056.2	23063.8	23047.5	23063.8	1960.0
2017-06-12 03:00:00	YM	Futures	23062.8	23067.1	23045.3	23059.5	3031.0

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

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