PREVIEW / futures_30min / 2018-07-18

all futures 30-min files

  file:    by_date/futures_30min/2018/2018-07-18.parquet
  size:    82 KB
  rows:    3,124

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
2018-07-18 00:00:00	ES	Futures	3066.34	3066.34	3064.43	3064.97	1758.0
2018-07-18 00:30:00	ES	Futures	3065.25	3066.34	3064.97	3066.06	1095.0
2018-07-18 01:00:00	ES	Futures	3066.34	3066.61	3065.25	3065.52	1388.0
2018-07-18 01:30:00	ES	Futures	3065.25	3065.52	3064.43	3064.43	2071.0
2018-07-18 02:00:00	ES	Futures	3064.43	3066.34	3064.16	3065.25	4062.0
2018-07-18 02:30:00	ES	Futures	3065.25	3066.88	3064.97	3066.61	3209.0
2018-07-18 03:00:00	ES	Futures	3066.61	3067.7	3064.43	3066.88	8348.0
2018-07-18 03:30:00	ES	Futures	3066.88	3067.43	3065.52	3066.61	4771.0
2018-07-18 04:00:00	ES	Futures	3066.61	3066.61	3062.79	3064.16	8549.0
2018-07-18 04:30:00	ES	Futures	3064.43	3064.7	3062.79	3064.7	4886.0
2018-07-18 05:00:00	ES	Futures	3064.97	3066.34	3064.43	3066.06	4305.0
2018-07-18 05:30:00	ES	Futures	3065.79	3066.61	3064.97	3065.79	3147.0
2018-07-18 06:00:00	ES	Futures	3065.79	3066.06	3063.88	3064.43	3229.0
2018-07-18 06:30:00	ES	Futures	3064.7	3064.97	3063.07	3064.43	2753.0
2018-07-18 07:00:00	ES	Futures	3064.16	3064.7	3062.52	3062.52	3486.0
2018-07-18 07:30:00	ES	Futures	3062.79	3064.16	3062.52	3062.79	7242.0
2018-07-18 08:00:00	ES	Futures	3063.07	3063.07	3060.07	3060.89	14172.0
2018-07-18 08:30:00	ES	Futures	3060.89	3063.07	3059.8	3062.52	9879.0
2018-07-18 09:00:00	ES	Futures	3062.25	3065.52	3061.98	3064.7	27191.0
2018-07-18 09:30:00	ES	Futures	3064.7	3066.88	3061.43	3062.79	115475.0
2018-07-18 10:00:00	ES	Futures	3063.07	3063.88	3058.98	3062.52	81289.0
2018-07-18 10:30:00	ES	Futures	3062.52	3063.88	3059.25	3063.07	54077.0
2018-07-18 11:00:00	ES	Futures	3063.34	3066.61	3062.25	3066.34	43722.0
2018-07-18 11:30:00	ES	Futures	3066.34	3070.7	3066.06	3070.15	54650.0
2018-07-18 12:00:00	ES	Futures	3069.88	3071.24	3068.79	3069.88	37313.0
2018-07-18 12:30:00	ES	Futures	3070.15	3070.42	3068.24	3069.33	21790.0
2018-07-18 13:00:00	ES	Futures	3069.33	3069.88	3067.97	3069.06	16566.0
2018-07-18 13:30:00	ES	Futures	3069.33	3069.33	3065.52	3067.7	20743.0
2018-07-18 14:00:00	ES	Futures	3067.43	3069.88	3067.15	3069.61	27850.0
2018-07-18 14:30:00	ES	Futures	3069.61	3070.42	3067.97	3069.33	35118.0
2018-07-18 15:00:00	ES	Futures	3069.61	3071.24	3068.79	3070.42	32721.0
2018-07-18 15:30:00	ES	Futures	3070.42	3071.51	3068.79	3069.88	104099.0
2018-07-18 16:00:00	ES	Futures	3070.15	3070.42	3068.52	3068.79	41599.0
2018-07-18 16:30:00	ES	Futures	3068.52	3069.06	3067.43	3067.7	5762.0
2018-07-18 18:00:00	ES	Futures	3067.43	3068.79	3067.15	3067.97	2370.0
2018-07-18 18:30:00	ES	Futures	3067.97	3069.06	3067.97	3068.79	574.0
2018-07-18 19:00:00	ES	Futures	3068.79	3069.61	3068.79	3068.79	595.0
2018-07-18 19:30:00	ES	Futures	3069.06	3069.88	3068.79	3069.06	733.0
2018-07-18 20:00:00	ES	Futures	3069.06	3069.61	3067.7	3068.79	2650.0
2018-07-18 20:30:00	ES	Futures	3068.52	3070.15	3067.97	3069.33	2357.0
2018-07-18 21:00:00	ES	Futures	3069.33	3070.15	3068.79	3069.61	2086.0
2018-07-18 21:30:00	ES	Futures	3069.33	3071.24	3069.06	3070.7	4618.0
2018-07-18 22:00:00	ES	Futures	3070.7	3070.97	3069.06	3069.88	2418.0
2018-07-18 22:30:00	ES	Futures	3070.15	3070.42	3069.61	3070.15	1045.0
2018-07-18 23:00:00	ES	Futures	3070.15	3070.7	3067.97	3068.24	2071.0
2018-07-18 23:30:00	ES	Futures	3067.97	3069.06	3067.97	3068.52	1217.0
2018-07-18 00:00:00	NQ	Futures	8747.75	8748.64	8742.45	8744.51	663.0
2018-07-18 00:30:00	NQ	Futures	8744.51	8749.22	8744.22	8748.34	587.0
2018-07-18 01:00:00	NQ	Futures	8748.34	8749.81	8742.75	8743.92	775.0
2018-07-18 01:30:00	NQ	Futures	8743.63	8743.92	8738.63	8739.21	906.0

> showing 50 of 3,124 rows — these rows as CSV

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