PREVIEW / futures_1hour / 2017-03-10

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-03-10.parquet
  size:    44 KB
  rows:    1,311

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-03-10 00:00:00	ES	Futures	2589.12	2589.4	2588.03	2588.3	2198.0
2017-03-10 01:00:00	ES	Futures	2588.58	2589.4	2588.03	2588.58	3321.0
2017-03-10 02:00:00	ES	Futures	2588.85	2589.4	2588.03	2588.85	3613.0
2017-03-10 03:00:00	ES	Futures	2588.85	2591.3	2587.76	2591.03	9508.0
2017-03-10 04:00:00	ES	Futures	2590.76	2592.4	2589.4	2589.94	7527.0
2017-03-10 05:00:00	ES	Futures	2590.21	2591.85	2589.4	2591.03	4560.0
2017-03-10 06:00:00	ES	Futures	2590.76	2592.94	2590.21	2591.85	7179.0
2017-03-10 07:00:00	ES	Futures	2591.58	2591.85	2589.4	2589.94	9959.0
2017-03-10 08:00:00	ES	Futures	2589.94	2596.49	2589.4	2594.58	40216.0
2017-03-10 09:00:00	ES	Futures	2594.85	2595.12	2586.67	2592.4	86051.0
2017-03-10 10:00:00	ES	Futures	2592.67	2593.49	2584.21	2584.76	82653.0
2017-03-10 11:00:00	ES	Futures	2584.49	2587.76	2582.03	2585.3	66865.0
2017-03-10 12:00:00	ES	Futures	2585.58	2586.94	2579.85	2582.3	32527.0
2017-03-10 13:00:00	ES	Futures	2582.3	2583.67	2577.39	2583.39	46735.0
2017-03-10 14:00:00	ES	Futures	2583.39	2586.4	2582.03	2585.3	32844.0
2017-03-10 15:00:00	ES	Futures	2585.3	2589.4	2585.03	2589.12	66080.0
2017-03-10 16:00:00	ES	Futures	2589.12	2589.4	2586.12	2587.21	40901.0
2017-03-10 00:00:00	NQ	Futures	6422.23	6422.23	6418.65	6421.04	222.0
2017-03-10 01:00:00	NQ	Futures	6421.04	6423.42	6420.14	6421.93	196.0
2017-03-10 02:00:00	NQ	Futures	6421.63	6421.63	6418.65	6420.44	689.0
2017-03-10 03:00:00	NQ	Futures	6421.04	6425.81	6418.05	6425.21	1147.0
2017-03-10 04:00:00	NQ	Futures	6425.51	6428.79	6420.14	6421.33	982.0
2017-03-10 05:00:00	NQ	Futures	6421.63	6425.51	6420.14	6424.62	445.0
2017-03-10 06:00:00	NQ	Futures	6424.62	6429.09	6423.42	6425.51	1061.0
2017-03-10 07:00:00	NQ	Futures	6425.21	6425.21	6420.14	6421.93	650.0
2017-03-10 08:00:00	NQ	Futures	6421.63	6433.86	6419.25	6429.69	5171.0
2017-03-10 09:00:00	NQ	Futures	6429.69	6437.15	6417.75	6434.46	15221.0
2017-03-10 10:00:00	NQ	Futures	6435.06	6438.04	6415.67	6423.12	16997.0
2017-03-10 11:00:00	NQ	Futures	6422.83	6429.09	6415.37	6423.42	9957.0
2017-03-10 12:00:00	NQ	Futures	6423.42	6424.32	6403.44	6410.59	5897.0
2017-03-10 13:00:00	NQ	Futures	6410.59	6414.77	6399.56	6412.98	6388.0
2017-03-10 14:00:00	NQ	Futures	6413.58	6421.04	6411.49	6417.75	4869.0
2017-03-10 15:00:00	NQ	Futures	6417.75	6426.7	6417.75	6426.7	8050.0
2017-03-10 16:00:00	NQ	Futures	6426.7	6427.0	6421.04	6422.23	2678.0
2017-03-10 00:00:00	YM	Futures	22702.0	22702.0	22686.8	22690.0	888.0
2017-03-10 01:00:00	YM	Futures	22688.9	22694.4	22682.4	22688.9	1225.0
2017-03-10 02:00:00	YM	Futures	22688.9	22694.4	22684.6	22693.3	1044.0
2017-03-10 03:00:00	YM	Futures	22692.2	22709.6	22684.6	22708.5	2042.0
2017-03-10 04:00:00	YM	Futures	22707.4	22721.5	22692.2	22698.7	1975.0
2017-03-10 05:00:00	YM	Futures	22698.7	22712.8	22695.5	22708.5	1349.0
2017-03-10 06:00:00	YM	Futures	22708.5	22722.6	22705.2	22713.9	1520.0
2017-03-10 07:00:00	YM	Futures	22713.9	22713.9	22699.8	22704.2	1356.0
2017-03-10 08:00:00	YM	Futures	22703.1	22759.6	22696.5	22745.5	9553.0
2017-03-10 09:00:00	YM	Futures	22745.5	22746.5	22647.6	22694.4	21940.0
2017-03-10 10:00:00	YM	Futures	22693.3	22710.7	22620.5	22622.6	23702.0
2017-03-10 11:00:00	YM	Futures	22622.6	22666.1	22607.4	22645.5	16921.0
2017-03-10 12:00:00	YM	Futures	22645.5	22658.5	22596.6	22622.6	8769.0
2017-03-10 13:00:00	YM	Futures	22622.6	22643.3	22590.0	22636.8	11493.0
2017-03-10 14:00:00	YM	Futures	22637.9	22665.0	22624.8	22656.3	8236.0
2017-03-10 15:00:00	YM	Futures	22657.4	22683.5	22655.2	22672.6	11174.0

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

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