PREVIEW / futures_30min / 2017-02-19

all futures 30-min files

  file:    by_date/futures_30min/2017/2017-02-19.parquet
  size:    18 KB
  rows:    470

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-02-19 18:00:00	ES	Futures	2560.21	2561.85	2560.21	2561.03	3310.0
2017-02-19 18:30:00	ES	Futures	2561.03	2561.3	2559.94	2561.3	1421.0
2017-02-19 19:00:00	ES	Futures	2561.03	2561.3	2559.66	2560.48	1567.0
2017-02-19 19:30:00	ES	Futures	2560.48	2561.85	2560.48	2561.57	1354.0
2017-02-19 20:00:00	ES	Futures	2561.57	2561.85	2560.48	2560.48	1055.0
2017-02-19 20:30:00	ES	Futures	2560.75	2562.12	2560.21	2561.57	1659.0
2017-02-19 21:00:00	ES	Futures	2561.57	2562.39	2561.3	2562.12	1208.0
2017-02-19 21:30:00	ES	Futures	2562.12	2562.66	2561.85	2561.85	1576.0
2017-02-19 22:00:00	ES	Futures	2562.12	2562.66	2561.85	2562.66	307.0
2017-02-19 22:30:00	ES	Futures	2562.39	2562.94	2562.39	2562.94	598.0
2017-02-19 23:00:00	ES	Futures	2562.94	2564.57	2562.66	2564.03	2161.0
2017-02-19 23:30:00	ES	Futures	2564.03	2564.3	2563.21	2563.21	1533.0
2017-02-19 18:00:00	NQ	Futures	6352.42	6354.51	6351.83	6352.72	840.0
2017-02-19 18:30:00	NQ	Futures	6353.02	6353.02	6349.74	6350.93	575.0
2017-02-19 19:00:00	NQ	Futures	6351.23	6352.12	6348.84	6350.63	620.0
2017-02-19 19:30:00	NQ	Futures	6350.33	6353.91	6350.33	6353.02	372.0
2017-02-19 20:00:00	NQ	Futures	6352.72	6353.32	6350.33	6350.33	348.0
2017-02-19 20:30:00	NQ	Futures	6350.63	6356.3	6350.04	6355.11	493.0
2017-02-19 21:00:00	NQ	Futures	6355.41	6358.09	6354.81	6356.0	578.0
2017-02-19 21:30:00	NQ	Futures	6356.3	6358.39	6356.0	6356.3	319.0
2017-02-19 22:00:00	NQ	Futures	6356.0	6357.49	6355.41	6356.3	223.0
2017-02-19 22:30:00	NQ	Futures	6356.0	6356.6	6355.11	6356.6	250.0
2017-02-19 23:00:00	NQ	Futures	6356.6	6359.88	6356.6	6358.39	473.0
2017-02-19 23:30:00	NQ	Futures	6358.69	6358.99	6356.0	6356.0	393.0
2017-02-19 18:00:00	YM	Futures	22327.7	22331.0	22320.1	22322.3	684.0
2017-02-19 18:30:00	YM	Futures	22323.4	22327.7	22315.8	22324.5	524.0
2017-02-19 19:00:00	YM	Futures	22324.5	22324.5	22311.5	22318.0	522.0
2017-02-19 19:30:00	YM	Futures	22316.9	22331.0	22316.9	22326.7	379.0
2017-02-19 20:00:00	YM	Futures	22327.7	22328.8	22318.0	22319.1	360.0
2017-02-19 20:30:00	YM	Futures	22319.1	22338.6	22318.0	22334.2	658.0
2017-02-19 21:00:00	YM	Futures	22334.2	22344.0	22332.1	22340.8	474.0
2017-02-19 21:30:00	YM	Futures	22340.8	22347.3	22340.8	22342.9	458.0
2017-02-19 22:00:00	YM	Futures	22341.8	22345.1	22340.8	22344.0	166.0
2017-02-19 22:30:00	YM	Futures	22344.0	22345.1	22340.8	22345.1	247.0
2017-02-19 23:00:00	YM	Futures	22345.1	22358.1	22345.1	22354.9	561.0
2017-02-19 23:30:00	YM	Futures	22353.8	22354.9	22346.2	22346.2	307.0
2017-02-19 18:00:00	CL	Futures	50.64	50.71	50.55	50.57	2624.0
2017-02-19 18:30:00	CL	Futures	50.58	50.59	50.52	50.54	573.0
2017-02-19 19:00:00	CL	Futures	50.53	50.58	50.51	50.55	784.0
2017-02-19 19:30:00	CL	Futures	50.55	50.59	50.54	50.56	441.0
2017-02-19 20:00:00	CL	Futures	50.56	50.58	50.5	50.5	1062.0
2017-02-19 20:30:00	CL	Futures	50.5	50.52	50.48	50.5	1069.0
2017-02-19 21:00:00	CL	Futures	50.51	50.52	50.49	50.52	544.0
2017-02-19 21:30:00	CL	Futures	50.51	50.55	50.5	50.52	558.0
2017-02-19 22:00:00	CL	Futures	50.53	50.57	50.52	50.56	710.0
2017-02-19 22:30:00	CL	Futures	50.55	50.58	50.52	50.57	682.0
2017-02-19 23:00:00	CL	Futures	50.56	50.6	50.55	50.56	710.0
2017-02-19 23:30:00	CL	Futures	50.56	50.6	50.56	50.59	441.0
2017-02-19 18:00:00	GC	Futures	1665.1	1667.4	1664.7	1667.1	1598.0
2017-02-19 18:30:00	GC	Futures	1667.0	1668.8	1666.0	1666.3	2099.0

> showing 50 of 470 rows — these rows as CSV

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