PREVIEW / futures_1hour / 2017-05-12

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-05-12.parquet
  size:    45 KB
  rows:    1,342

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-05-12 00:00:00	ES	Futures	2607.97	2608.79	2607.7	2608.24	3163.0
2017-05-12 01:00:00	ES	Futures	2608.52	2609.33	2608.24	2609.33	3311.0
2017-05-12 02:00:00	ES	Futures	2609.33	2609.33	2607.7	2607.97	7332.0
2017-05-12 03:00:00	ES	Futures	2607.97	2608.24	2605.24	2606.06	20382.0
2017-05-12 04:00:00	ES	Futures	2605.78	2607.15	2605.24	2605.78	11210.0
2017-05-12 05:00:00	ES	Futures	2606.06	2606.88	2604.96	2606.33	15148.0
2017-05-12 06:00:00	ES	Futures	2606.06	2606.88	2605.24	2606.88	10329.0
2017-05-12 07:00:00	ES	Futures	2606.88	2608.79	2606.6	2607.15	13113.0
2017-05-12 08:00:00	ES	Futures	2607.15	2611.52	2606.6	2610.7	37360.0
2017-05-12 09:00:00	ES	Futures	2610.7	2612.89	2607.42	2608.52	152991.0
2017-05-12 10:00:00	ES	Futures	2608.79	2609.88	2604.96	2606.33	156928.0
2017-05-12 11:00:00	ES	Futures	2606.6	2610.97	2605.78	2609.06	115941.0
2017-05-12 12:00:00	ES	Futures	2609.33	2609.33	2607.15	2607.7	65146.0
2017-05-12 13:00:00	ES	Futures	2607.7	2608.79	2606.6	2608.79	49840.0
2017-05-12 14:00:00	ES	Futures	2608.79	2609.61	2606.88	2608.24	63008.0
2017-05-12 15:00:00	ES	Futures	2608.24	2609.33	2605.78	2608.79	210299.0
2017-05-12 16:00:00	ES	Futures	2608.79	2611.25	2608.52	2610.15	95929.0
2017-05-12 00:00:00	NQ	Futures	6749.3	6754.07	6748.4	6752.88	1245.0
2017-05-12 01:00:00	NQ	Futures	6752.88	6754.37	6751.98	6753.77	589.0
2017-05-12 02:00:00	NQ	Futures	6754.07	6754.96	6751.09	6751.38	1059.0
2017-05-12 03:00:00	NQ	Futures	6751.38	6753.17	6746.91	6748.4	2488.0
2017-05-12 04:00:00	NQ	Futures	6748.4	6750.79	6745.72	6746.91	1804.0
2017-05-12 05:00:00	NQ	Futures	6746.91	6751.68	6746.02	6750.79	1591.0
2017-05-12 06:00:00	NQ	Futures	6750.49	6754.07	6748.4	6754.07	1354.0
2017-05-12 07:00:00	NQ	Futures	6754.07	6760.03	6754.07	6755.86	2272.0
2017-05-12 08:00:00	NQ	Futures	6755.56	6765.99	6754.96	6765.1	7322.0
2017-05-12 09:00:00	NQ	Futures	6765.1	6777.02	6764.5	6768.38	41777.0
2017-05-12 10:00:00	NQ	Futures	6768.38	6777.02	6762.71	6767.19	30973.0
2017-05-12 11:00:00	NQ	Futures	6767.19	6781.5	6765.7	6780.01	24063.0
2017-05-12 12:00:00	NQ	Futures	6780.3	6780.3	6773.75	6776.73	13280.0
2017-05-12 13:00:00	NQ	Futures	6776.43	6782.09	6774.34	6782.09	8940.0
2017-05-12 14:00:00	NQ	Futures	6782.09	6782.39	6776.73	6778.81	9491.0
2017-05-12 15:00:00	NQ	Futures	6778.81	6781.2	6769.57	6780.3	19721.0
2017-05-12 16:00:00	NQ	Futures	6780.3	6785.37	6780.01	6785.07	7585.0
2017-05-12 00:00:00	YM	Futures	22655.2	22663.9	22653.1	22657.4	664.0
2017-05-12 01:00:00	YM	Futures	22657.4	22666.1	22656.3	22663.9	465.0
2017-05-12 02:00:00	YM	Futures	22663.9	22667.2	22655.2	22656.3	1361.0
2017-05-12 03:00:00	YM	Futures	22657.4	22661.8	22634.6	22638.9	3146.0
2017-05-12 04:00:00	YM	Futures	22637.9	22652.0	22634.6	22641.1	1581.0
2017-05-12 05:00:00	YM	Futures	22641.1	22647.6	22633.5	22646.6	1912.0
2017-05-12 06:00:00	YM	Futures	22647.6	22648.7	22636.8	22647.6	1212.0
2017-05-12 07:00:00	YM	Futures	22647.6	22669.4	22647.6	22656.3	2194.0
2017-05-12 08:00:00	YM	Futures	22654.2	22677.0	22644.4	22668.3	5390.0
2017-05-12 09:00:00	YM	Futures	22668.3	22685.7	22641.1	22659.6	13718.0
2017-05-12 10:00:00	YM	Futures	22658.5	22673.7	22637.9	22647.6	11188.0
2017-05-12 11:00:00	YM	Futures	22648.7	22690.0	22643.3	22667.2	10302.0
2017-05-12 12:00:00	YM	Futures	22668.3	22668.3	22652.0	22658.5	4331.0
2017-05-12 13:00:00	YM	Futures	22657.4	22662.9	22645.5	22660.7	3561.0
2017-05-12 14:00:00	YM	Futures	22660.7	22665.0	22646.6	22657.4	4285.0
2017-05-12 15:00:00	YM	Futures	22657.4	22663.9	22641.1	22661.8	9590.0

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

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