PREVIEW / futures_30min / 2017-07-02

all futures 30-min files

  file:    by_date/futures_30min/2017/2017-07-02.parquet
  size:    21 KB
  rows:    557

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-07-02 18:00:00	ES	Futures	2648.11	2650.57	2647.56	2650.3	4502.0
2017-07-02 18:30:00	ES	Futures	2650.3	2651.12	2649.75	2651.12	629.0
2017-07-02 19:00:00	ES	Futures	2651.12	2653.85	2650.57	2652.48	2535.0
2017-07-02 19:30:00	ES	Futures	2652.48	2652.76	2650.02	2650.84	1717.0
2017-07-02 20:00:00	ES	Futures	2650.84	2653.58	2650.84	2650.84	4300.0
2017-07-02 20:30:00	ES	Futures	2650.84	2651.66	2649.75	2651.39	2069.0
2017-07-02 21:00:00	ES	Futures	2651.39	2651.94	2650.57	2651.94	2531.0
2017-07-02 21:30:00	ES	Futures	2651.94	2654.12	2651.94	2653.03	4564.0
2017-07-02 22:00:00	ES	Futures	2653.3	2654.12	2652.76	2653.03	1841.0
2017-07-02 22:30:00	ES	Futures	2653.03	2653.85	2652.48	2653.3	1683.0
2017-07-02 23:00:00	ES	Futures	2653.58	2653.58	2652.48	2653.3	1165.0
2017-07-02 23:30:00	ES	Futures	2653.03	2653.58	2652.76	2653.58	745.0
2017-07-02 18:00:00	NQ	Futures	6738.71	6748.83	6736.62	6745.55	975.0
2017-07-02 18:30:00	NQ	Futures	6745.55	6748.53	6744.07	6748.23	300.0
2017-07-02 19:00:00	NQ	Futures	6747.94	6757.46	6745.26	6754.19	757.0
2017-07-02 19:30:00	NQ	Futures	6754.19	6756.27	6743.77	6746.75	569.0
2017-07-02 20:00:00	NQ	Futures	6747.04	6752.7	6743.47	6743.77	1045.0
2017-07-02 20:30:00	NQ	Futures	6743.77	6746.75	6739.6	6744.36	749.0
2017-07-02 21:00:00	NQ	Futures	6744.07	6746.75	6740.49	6746.15	529.0
2017-07-02 21:30:00	NQ	Futures	6746.45	6752.7	6746.45	6750.02	671.0
2017-07-02 22:00:00	NQ	Futures	6749.72	6752.1	6745.55	6747.04	509.0
2017-07-02 22:30:00	NQ	Futures	6747.04	6750.32	6746.15	6748.83	565.0
2017-07-02 23:00:00	NQ	Futures	6748.23	6749.13	6744.96	6748.83	574.0
2017-07-02 23:30:00	NQ	Futures	6748.53	6750.32	6747.94	6750.02	503.0
2017-07-02 18:00:00	YM	Futures	23191.2	23219.5	23191.2	23216.2	517.0
2017-07-02 18:30:00	YM	Futures	23216.2	23226.0	23215.1	23226.0	229.0
2017-07-02 19:00:00	YM	Futures	23224.9	23239.1	23222.8	23231.5	493.0
2017-07-02 19:30:00	YM	Futures	23232.6	23233.6	23217.3	23220.6	441.0
2017-07-02 20:00:00	YM	Futures	23221.7	23238.0	23219.5	23219.5	716.0
2017-07-02 20:30:00	YM	Futures	23221.7	23221.7	23213.0	23217.3	428.0
2017-07-02 21:00:00	YM	Futures	23217.3	23221.7	23210.8	23221.7	448.0
2017-07-02 21:30:00	YM	Futures	23220.6	23235.8	23220.6	23227.1	553.0
2017-07-02 22:00:00	YM	Futures	23228.2	23234.7	23222.8	23223.8	269.0
2017-07-02 22:30:00	YM	Futures	23224.9	23230.4	23223.8	23230.4	290.0
2017-07-02 23:00:00	YM	Futures	23230.4	23231.5	23224.9	23230.4	282.0
2017-07-02 23:30:00	YM	Futures	23230.4	23233.6	23227.1	23232.6	216.0
2017-07-02 18:00:00	CL	Futures	42.14	42.17	42.06	42.12	2055.0
2017-07-02 18:30:00	CL	Futures	42.12	42.16	42.08	42.15	802.0
2017-07-02 19:00:00	CL	Futures	42.14	42.23	42.14	42.19	1614.0
2017-07-02 19:30:00	CL	Futures	42.18	42.19	42.14	42.14	935.0
2017-07-02 20:00:00	CL	Futures	42.15	42.17	42.08	42.11	2363.0
2017-07-02 20:30:00	CL	Futures	42.11	42.13	42.04	42.05	1913.0
2017-07-02 21:00:00	CL	Futures	42.05	42.06	42.02	42.04	2155.0
2017-07-02 21:30:00	CL	Futures	42.04	42.09	42.02	42.06	1671.0
2017-07-02 22:00:00	CL	Futures	42.06	42.16	42.06	42.13	2830.0
2017-07-02 22:30:00	CL	Futures	42.13	42.16	42.11	42.13	1372.0
2017-07-02 23:00:00	CL	Futures	42.12	42.14	42.05	42.06	1733.0
2017-07-02 23:30:00	CL	Futures	42.06	42.08	42.04	42.08	1328.0
2017-07-02 18:00:00	GC	Futures	1662.4	1663.6	1661.9	1663.2	932.0
2017-07-02 18:30:00	GC	Futures	1663.2	1663.6	1661.9	1662.4	586.0

> showing 50 of 557 rows — these rows as CSV

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