PREVIEW / futures_1hour / 2017-05-19

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-05-19.parquet
  size:    47 KB
  rows:    1,381

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-19 00:00:00	ES	Futures	2582.84	2583.39	2581.47	2582.29	1804.0
2017-05-19 01:00:00	ES	Futures	2582.29	2584.21	2582.29	2583.11	3820.0
2017-05-19 02:00:00	ES	Futures	2583.11	2584.21	2582.29	2583.11	7313.0
2017-05-19 03:00:00	ES	Futures	2583.11	2584.48	2581.47	2583.39	15420.0
2017-05-19 04:00:00	ES	Futures	2583.39	2588.85	2582.02	2586.39	25211.0
2017-05-19 05:00:00	ES	Futures	2586.12	2591.03	2586.12	2588.58	20840.0
2017-05-19 06:00:00	ES	Futures	2588.58	2588.85	2586.94	2587.21	13510.0
2017-05-19 07:00:00	ES	Futures	2587.21	2589.67	2587.21	2588.3	15661.0
2017-05-19 08:00:00	ES	Futures	2588.58	2590.21	2587.48	2589.4	30996.0
2017-05-19 09:00:00	ES	Futures	2589.67	2599.23	2587.21	2597.04	269132.0
2017-05-19 10:00:00	ES	Futures	2597.32	2602.78	2596.77	2601.69	242671.0
2017-05-19 11:00:00	ES	Futures	2601.69	2603.87	2600.05	2603.6	153676.0
2017-05-19 12:00:00	ES	Futures	2603.6	2607.42	2603.6	2606.6	114047.0
2017-05-19 13:00:00	ES	Futures	2606.6	2606.6	2603.87	2605.51	99458.0
2017-05-19 14:00:00	ES	Futures	2605.51	2609.06	2604.42	2606.88	126620.0
2017-05-19 15:00:00	ES	Futures	2606.88	2607.15	2598.14	2600.32	358907.0
2017-05-19 16:00:00	ES	Futures	2600.32	2603.05	2599.5	2602.51	115863.0
2017-05-19 00:00:00	NQ	Futures	6715.61	6715.91	6710.54	6714.12	801.0
2017-05-19 01:00:00	NQ	Futures	6714.42	6718.59	6714.12	6715.31	1019.0
2017-05-19 02:00:00	NQ	Futures	6715.61	6717.99	6714.12	6715.91	1469.0
2017-05-19 03:00:00	NQ	Futures	6715.91	6720.38	6711.14	6718.29	2798.0
2017-05-19 04:00:00	NQ	Futures	6718.29	6734.09	6715.31	6727.53	3999.0
2017-05-19 05:00:00	NQ	Futures	6727.24	6735.88	6726.04	6732.3	3890.0
2017-05-19 06:00:00	NQ	Futures	6732.3	6732.6	6727.24	6728.13	1966.0
2017-05-19 07:00:00	NQ	Futures	6728.13	6734.99	6728.13	6732.9	2954.0
2017-05-19 08:00:00	NQ	Futures	6732.6	6742.74	6731.11	6739.16	9267.0
2017-05-19 09:00:00	NQ	Futures	6739.46	6759.73	6733.2	6751.38	64253.0
2017-05-19 10:00:00	NQ	Futures	6751.38	6764.5	6748.4	6760.03	41016.0
2017-05-19 11:00:00	NQ	Futures	6759.73	6765.7	6749.89	6759.43	28073.0
2017-05-19 12:00:00	NQ	Futures	6759.73	6769.57	6758.54	6766.29	19442.0
2017-05-19 13:00:00	NQ	Futures	6766.29	6767.78	6760.03	6760.93	14337.0
2017-05-19 14:00:00	NQ	Futures	6760.93	6768.38	6757.35	6762.42	15971.0
2017-05-19 15:00:00	NQ	Futures	6762.42	6763.31	6737.67	6741.84	59140.0
2017-05-19 16:00:00	NQ	Futures	6741.55	6745.12	6740.06	6744.23	9822.0
2017-05-19 00:00:00	YM	Futures	22439.0	22443.3	22428.1	22433.5	379.0
2017-05-19 01:00:00	YM	Futures	22433.5	22448.8	22433.5	22435.7	787.0
2017-05-19 02:00:00	YM	Futures	22436.8	22443.3	22432.5	22436.8	1246.0
2017-05-19 03:00:00	YM	Futures	22435.7	22447.7	22420.5	22436.8	2395.0
2017-05-19 04:00:00	YM	Futures	22437.9	22478.1	22427.0	22456.4	3304.0
2017-05-19 05:00:00	YM	Futures	22456.4	22490.1	22455.3	22470.5	3468.0
2017-05-19 06:00:00	YM	Futures	22469.4	22469.4	22453.1	22458.5	2033.0
2017-05-19 07:00:00	YM	Futures	22458.5	22479.2	22458.5	22469.4	2156.0
2017-05-19 08:00:00	YM	Futures	22469.4	22484.6	22461.8	22471.6	4924.0
2017-05-19 09:00:00	YM	Futures	22472.7	22531.4	22455.3	22519.4	22638.0
2017-05-19 10:00:00	YM	Futures	22519.4	22562.9	22508.5	22555.3	22548.0
2017-05-19 11:00:00	YM	Futures	22554.2	22580.3	22548.7	22580.3	13678.0
2017-05-19 12:00:00	YM	Futures	22581.3	22629.2	22579.2	22618.3	13446.0
2017-05-19 13:00:00	YM	Futures	22619.4	22621.6	22594.4	22616.1	9679.0
2017-05-19 14:00:00	YM	Futures	22616.1	22645.5	22605.3	22627.0	11306.0
2017-05-19 15:00:00	YM	Futures	22627.0	22630.3	22560.7	22585.7	28096.0

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

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