PREVIEW / futures_1hour / 2017-06-16

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-06-16.parquet
  size:    44 KB
  rows:    1,326

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-16 00:00:00	ES	Futures	2662.87	2663.42	2662.05	2662.32	1672.0
2017-06-16 01:00:00	ES	Futures	2662.32	2662.32	2661.23	2661.78	2843.0
2017-06-16 02:00:00	ES	Futures	2661.78	2663.42	2661.5	2661.78	7357.0
2017-06-16 03:00:00	ES	Futures	2661.78	2664.24	2661.5	2662.32	14367.0
2017-06-16 04:00:00	ES	Futures	2662.32	2663.69	2660.96	2660.96	11713.0
2017-06-16 05:00:00	ES	Futures	2660.96	2663.69	2660.96	2661.78	19971.0
2017-06-16 06:00:00	ES	Futures	2661.5	2662.87	2661.5	2662.32	10661.0
2017-06-16 07:00:00	ES	Futures	2662.6	2663.42	2662.32	2662.32	13000.0
2017-06-16 08:00:00	ES	Futures	2662.32	2662.32	2657.4	2658.5	39385.0
2017-06-16 09:00:00	ES	Futures	2658.22	2659.86	2647.84	2652.21	281815.0
2017-06-16 10:00:00	ES	Futures	2652.21	2653.03	2646.2	2648.66	218520.0
2017-06-16 11:00:00	ES	Futures	2648.38	2653.58	2647.02	2653.3	127830.0
2017-06-16 12:00:00	ES	Futures	2653.58	2655.22	2653.03	2653.3	84210.0
2017-06-16 13:00:00	ES	Futures	2653.3	2654.4	2651.39	2654.12	68588.0
2017-06-16 14:00:00	ES	Futures	2653.85	2656.04	2653.03	2654.94	71640.0
2017-06-16 15:00:00	ES	Futures	2655.22	2658.22	2652.48	2657.4	205989.0
2017-06-16 16:00:00	ES	Futures	2657.4	2661.78	2656.58	2661.78	84343.0
2017-06-16 00:00:00	NQ	Futures	6817.61	6819.69	6815.53	6817.31	802.0
2017-06-16 01:00:00	NQ	Futures	6817.61	6817.61	6808.08	6811.36	1500.0
2017-06-16 02:00:00	NQ	Futures	6811.06	6818.5	6808.38	6814.93	1511.0
2017-06-16 03:00:00	NQ	Futures	6815.23	6820.59	6813.44	6814.04	2164.0
2017-06-16 04:00:00	NQ	Futures	6814.04	6817.31	6799.75	6800.64	3158.0
2017-06-16 05:00:00	NQ	Futures	6800.64	6810.76	6800.34	6805.4	2843.0
2017-06-16 06:00:00	NQ	Futures	6805.4	6813.14	6805.4	6811.06	3652.0
2017-06-16 07:00:00	NQ	Futures	6811.36	6813.44	6809.87	6810.17	4613.0
2017-06-16 08:00:00	NQ	Futures	6810.46	6810.46	6785.75	6786.94	9001.0
2017-06-16 09:00:00	NQ	Futures	6786.64	6800.04	6762.53	6789.92	72135.0
2017-06-16 10:00:00	NQ	Futures	6789.92	6790.22	6744.07	6753.3	65461.0
2017-06-16 11:00:00	NQ	Futures	6753.3	6772.95	6742.28	6772.05	40948.0
2017-06-16 12:00:00	NQ	Futures	6772.35	6779.8	6768.48	6771.16	22231.0
2017-06-16 13:00:00	NQ	Futures	6771.76	6779.2	6764.61	6778.9	22520.0
2017-06-16 14:00:00	NQ	Futures	6778.6	6787.54	6777.12	6781.58	21357.0
2017-06-16 15:00:00	NQ	Futures	6781.58	6785.45	6760.74	6770.86	54841.0
2017-06-16 16:00:00	NQ	Futures	6770.86	6779.8	6768.78	6778.9	9740.0
2017-06-16 00:00:00	YM	Futures	23244.5	23246.7	23239.1	23242.4	600.0
2017-06-16 01:00:00	YM	Futures	23242.4	23242.4	23227.1	23234.7	783.0
2017-06-16 02:00:00	YM	Futures	23234.7	23244.5	23231.5	23236.9	1551.0
2017-06-16 03:00:00	YM	Futures	23236.9	23256.5	23236.9	23242.4	2284.0
2017-06-16 04:00:00	YM	Futures	23242.4	23251.1	23231.5	23233.6	1435.0
2017-06-16 05:00:00	YM	Futures	23232.6	23250.0	23224.9	23230.4	2390.0
2017-06-16 06:00:00	YM	Futures	23230.4	23235.8	23222.8	23228.2	1786.0
2017-06-16 07:00:00	YM	Futures	23228.2	23234.7	23227.1	23228.2	1467.0
2017-06-16 08:00:00	YM	Futures	23229.3	23229.3	23197.7	23208.6	4331.0
2017-06-16 09:00:00	YM	Futures	23207.5	23213.0	23145.5	23181.4	24376.0
2017-06-16 10:00:00	YM	Futures	23180.3	23183.6	23145.5	23167.2	21807.0
2017-06-16 11:00:00	YM	Futures	23168.3	23206.4	23156.4	23206.4	11163.0
2017-06-16 12:00:00	YM	Futures	23206.4	23226.0	23202.1	23207.5	8389.0
2017-06-16 13:00:00	YM	Futures	23207.5	23216.2	23185.8	23201.0	5728.0
2017-06-16 14:00:00	YM	Futures	23201.0	23218.4	23195.5	23208.6	5211.0
2017-06-16 15:00:00	YM	Futures	23209.7	23226.0	23193.4	23219.5	11982.0

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

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