PREVIEW / futures_1hour / 2017-09-20

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-09-20.parquet
  size:    52 KB
  rows:    1,609

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-09-20 00:00:00	ES	Futures	2739.69	2740.51	2739.42	2739.69	2248.0
2017-09-20 01:00:00	ES	Futures	2739.69	2739.96	2739.14	2739.69	4294.0
2017-09-20 02:00:00	ES	Futures	2739.69	2740.24	2739.14	2739.42	5661.0
2017-09-20 03:00:00	ES	Futures	2739.42	2741.06	2739.14	2740.78	13934.0
2017-09-20 04:00:00	ES	Futures	2741.06	2741.88	2740.51	2741.6	11011.0
2017-09-20 05:00:00	ES	Futures	2741.6	2741.88	2740.24	2741.6	12406.0
2017-09-20 06:00:00	ES	Futures	2741.6	2741.88	2740.51	2741.33	9526.0
2017-09-20 07:00:00	ES	Futures	2741.33	2742.15	2740.51	2740.51	11521.0
2017-09-20 08:00:00	ES	Futures	2740.78	2741.88	2740.24	2741.6	10144.0
2017-09-20 09:00:00	ES	Futures	2741.6	2743.52	2740.51	2741.33	121100.0
2017-09-20 10:00:00	ES	Futures	2741.33	2741.6	2738.32	2738.87	102520.0
2017-09-20 11:00:00	ES	Futures	2738.87	2742.15	2738.32	2741.6	108177.0
2017-09-20 12:00:00	ES	Futures	2741.6	2742.97	2741.06	2742.43	64966.0
2017-09-20 13:00:00	ES	Futures	2742.43	2742.43	2738.87	2739.96	60246.0
2017-09-20 14:00:00	ES	Futures	2739.96	2739.96	2729.02	2736.95	349992.0
2017-09-20 15:00:00	ES	Futures	2736.95	2742.97	2735.04	2742.15	228471.0
2017-09-20 16:00:00	ES	Futures	2742.15	2742.43	2740.51	2740.78	71455.0
2017-09-20 18:00:00	ES	Futures	2740.51	2741.06	2739.96	2740.24	4150.0
2017-09-20 19:00:00	ES	Futures	2740.51	2742.43	2740.24	2741.33	3303.0
2017-09-20 20:00:00	ES	Futures	2741.33	2741.88	2739.14	2739.42	10518.0
2017-09-20 21:00:00	ES	Futures	2739.69	2740.78	2739.14	2740.51	7715.0
2017-09-20 22:00:00	ES	Futures	2740.24	2741.06	2739.96	2740.78	3510.0
2017-09-20 23:00:00	ES	Futures	2740.78	2741.06	2739.96	2740.78	4269.0
2017-09-20 00:00:00	NQ	Futures	7130.56	7132.64	7128.18	7129.37	435.0
2017-09-20 01:00:00	NQ	Futures	7129.37	7130.86	7128.48	7129.67	588.0
2017-09-20 02:00:00	NQ	Futures	7129.37	7130.86	7126.1	7126.4	1165.0
2017-09-20 03:00:00	NQ	Futures	7126.99	7131.75	7125.5	7130.86	1268.0
2017-09-20 04:00:00	NQ	Futures	7130.56	7135.32	7129.67	7132.94	1619.0
2017-09-20 05:00:00	NQ	Futures	7133.53	7134.72	7129.96	7132.94	1557.0
2017-09-20 06:00:00	NQ	Futures	7133.24	7135.32	7132.05	7133.83	1235.0
2017-09-20 07:00:00	NQ	Futures	7134.13	7135.91	7131.15	7131.75	1584.0
2017-09-20 08:00:00	NQ	Futures	7131.45	7134.72	7129.37	7131.45	2164.0
2017-09-20 09:00:00	NQ	Futures	7131.45	7138.59	7120.74	7125.8	35499.0
2017-09-20 10:00:00	NQ	Futures	7125.5	7129.37	7089.52	7090.41	44885.0
2017-09-20 11:00:00	NQ	Futures	7090.71	7104.09	7082.68	7102.6	52301.0
2017-09-20 12:00:00	NQ	Futures	7102.6	7119.55	7101.41	7114.2	29065.0
2017-09-20 13:00:00	NQ	Futures	7114.5	7115.69	7101.41	7107.36	18333.0
2017-09-20 14:00:00	NQ	Futures	7107.96	7108.25	7055.31	7086.24	95682.0
2017-09-20 15:00:00	NQ	Futures	7086.24	7116.58	7080.3	7111.52	43986.0
2017-09-20 16:00:00	NQ	Futures	7111.52	7116.58	7110.04	7110.04	8467.0
2017-09-20 18:00:00	NQ	Futures	7109.44	7110.63	7105.87	7107.36	1111.0
2017-09-20 19:00:00	NQ	Futures	7107.36	7114.5	7106.77	7110.33	909.0
2017-09-20 20:00:00	NQ	Futures	7110.63	7112.42	7099.93	7101.11	2330.0
2017-09-20 21:00:00	NQ	Futures	7101.11	7106.17	7099.93	7103.49	2511.0
2017-09-20 22:00:00	NQ	Futures	7103.2	7104.68	7101.71	7103.49	1381.0
2017-09-20 23:00:00	NQ	Futures	7103.49	7105.58	7102.3	7103.49	1266.0
2017-09-20 00:00:00	YM	Futures	24293.4	24303.2	24292.3	24294.5	921.0
2017-09-20 01:00:00	YM	Futures	24294.5	24297.8	24291.3	24295.6	592.0
2017-09-20 02:00:00	YM	Futures	24294.5	24297.8	24290.2	24294.5	822.0
2017-09-20 03:00:00	YM	Futures	24294.5	24304.3	24291.3	24300.0	1821.0

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

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