PREVIEW / futures_1hour / 2017-01-27

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-01-27.parquet
  size:    45 KB
  rows:    1,344

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-01-27 00:00:00	ES	Futures	2501.84	2501.84	2500.75	2501.29	1434.0
2017-01-27 01:00:00	ES	Futures	2501.56	2502.66	2501.56	2502.66	1506.0
2017-01-27 02:00:00	ES	Futures	2502.66	2505.93	2502.38	2505.11	9292.0
2017-01-27 03:00:00	ES	Futures	2505.38	2505.38	2502.93	2504.56	10794.0
2017-01-27 04:00:00	ES	Futures	2504.56	2504.84	2500.75	2501.29	11587.0
2017-01-27 05:00:00	ES	Futures	2501.29	2502.11	2499.93	2501.56	8714.0
2017-01-27 06:00:00	ES	Futures	2501.84	2502.93	2501.29	2501.29	7067.0
2017-01-27 07:00:00	ES	Futures	2501.29	2504.02	2501.29	2503.75	10603.0
2017-01-27 08:00:00	ES	Futures	2503.75	2504.29	2502.11	2502.93	20794.0
2017-01-27 09:00:00	ES	Futures	2502.93	2504.56	2496.65	2498.02	165621.0
2017-01-27 10:00:00	ES	Futures	2498.29	2499.38	2495.56	2496.38	157402.0
2017-01-27 11:00:00	ES	Futures	2496.38	2499.11	2496.11	2498.84	107449.0
2017-01-27 12:00:00	ES	Futures	2498.84	2499.93	2496.65	2498.02	70119.0
2017-01-27 13:00:00	ES	Futures	2498.29	2498.56	2496.65	2496.93	53822.0
2017-01-27 14:00:00	ES	Futures	2497.2	2498.29	2496.65	2497.75	58905.0
2017-01-27 15:00:00	ES	Futures	2497.75	2498.84	2495.29	2497.75	161716.0
2017-01-27 16:00:00	ES	Futures	2497.75	2498.29	2496.93	2498.29	59936.0
2017-01-27 00:00:00	NQ	Futures	6143.9	6145.09	6141.51	6143.6	506.0
2017-01-27 01:00:00	NQ	Futures	6144.2	6145.09	6143.9	6145.09	351.0
2017-01-27 02:00:00	NQ	Futures	6145.39	6150.76	6144.79	6149.86	1583.0
2017-01-27 03:00:00	NQ	Futures	6149.86	6150.16	6144.49	6148.97	1516.0
2017-01-27 04:00:00	NQ	Futures	6149.27	6149.27	6140.91	6142.41	1713.0
2017-01-27 05:00:00	NQ	Futures	6142.7	6144.79	6140.02	6143.3	1466.0
2017-01-27 06:00:00	NQ	Futures	6143.6	6147.77	6143.3	6144.79	1160.0
2017-01-27 07:00:00	NQ	Futures	6145.09	6153.44	6145.09	6152.55	1900.0
2017-01-27 08:00:00	NQ	Futures	6152.25	6156.13	6150.46	6155.53	3986.0
2017-01-27 09:00:00	NQ	Futures	6155.53	6166.27	6143.6	6148.07	33899.0
2017-01-27 10:00:00	NQ	Futures	6147.48	6157.62	6140.62	6153.74	24229.0
2017-01-27 11:00:00	NQ	Futures	6153.74	6159.41	6149.56	6156.13	13483.0
2017-01-27 12:00:00	NQ	Futures	6155.83	6160.9	6154.64	6159.11	8674.0
2017-01-27 13:00:00	NQ	Futures	6159.11	6160.3	6154.04	6154.64	7579.0
2017-01-27 14:00:00	NQ	Futures	6154.64	6158.51	6153.14	6157.62	7229.0
2017-01-27 15:00:00	NQ	Futures	6157.32	6161.2	6149.86	6160.01	18731.0
2017-01-27 16:00:00	NQ	Futures	6160.01	6163.88	6159.41	6163.29	4629.0
2017-01-27 00:00:00	YM	Futures	21740.9	21740.9	21733.3	21738.7	390.0
2017-01-27 01:00:00	YM	Futures	21739.8	21749.6	21739.8	21749.6	461.0
2017-01-27 02:00:00	YM	Futures	21749.6	21774.5	21747.4	21770.2	2034.0
2017-01-27 03:00:00	YM	Futures	21769.1	21770.2	21752.8	21768.0	2167.0
2017-01-27 04:00:00	YM	Futures	21768.0	21769.1	21737.6	21742.0	1993.0
2017-01-27 05:00:00	YM	Futures	21742.0	21755.0	21733.3	21749.6	1599.0
2017-01-27 06:00:00	YM	Futures	21750.6	21762.6	21748.5	21748.5	1036.0
2017-01-27 07:00:00	YM	Futures	21749.6	21762.6	21749.6	21761.5	1178.0
2017-01-27 08:00:00	YM	Futures	21761.5	21763.7	21730.0	21734.4	3764.0
2017-01-27 09:00:00	YM	Futures	21735.5	21747.4	21709.4	21721.4	15697.0
2017-01-27 10:00:00	YM	Futures	21722.4	21735.5	21700.7	21706.2	12375.0
2017-01-27 11:00:00	YM	Futures	21706.2	21730.0	21705.1	21727.9	8768.0
2017-01-27 12:00:00	YM	Futures	21727.9	21737.6	21706.2	21717.0	5425.0
2017-01-27 13:00:00	YM	Futures	21717.0	21720.3	21706.2	21710.5	3542.0
2017-01-27 14:00:00	YM	Futures	21709.4	21725.7	21707.3	21718.1	3281.0
2017-01-27 15:00:00	YM	Futures	21718.1	21725.7	21702.9	21720.3	7394.0

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

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