PREVIEW / futures_30min / 2018-08-01

all futures 30-min files

  file:    by_date/futures_30min/2018/2018-08-01.parquet
  size:    84 KB
  rows:    3,185

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-08-01 00:00:00	ES	Futures	3068.52	3069.33	3067.7	3069.06	1696.0
2018-08-01 00:30:00	ES	Futures	3069.06	3070.15	3068.24	3069.88	1722.0
2018-08-01 01:00:00	ES	Futures	3069.88	3070.15	3069.06	3069.61	1565.0
2018-08-01 01:30:00	ES	Futures	3069.88	3070.15	3068.79	3069.88	3075.0
2018-08-01 02:00:00	ES	Futures	3069.88	3075.05	3069.88	3073.42	6968.0
2018-08-01 02:30:00	ES	Futures	3073.42	3073.69	3071.79	3072.06	4721.0
2018-08-01 03:00:00	ES	Futures	3072.06	3073.69	3069.33	3069.88	12481.0
2018-08-01 03:30:00	ES	Futures	3069.88	3072.06	3068.79	3071.24	8317.0
2018-08-01 04:00:00	ES	Futures	3071.24	3072.6	3068.79	3070.15	8333.0
2018-08-01 04:30:00	ES	Futures	3070.15	3070.7	3068.52	3069.06	5728.0
2018-08-01 05:00:00	ES	Futures	3068.79	3069.61	3066.34	3066.34	5822.0
2018-08-01 05:30:00	ES	Futures	3066.34	3067.43	3065.79	3066.61	3624.0
2018-08-01 06:00:00	ES	Futures	3066.88	3070.97	3066.34	3070.15	4910.0
2018-08-01 06:30:00	ES	Futures	3070.42	3070.42	3066.34	3066.88	4843.0
2018-08-01 07:00:00	ES	Futures	3066.88	3068.24	3066.61	3067.97	3852.0
2018-08-01 07:30:00	ES	Futures	3067.97	3070.7	3067.7	3070.42	8811.0
2018-08-01 08:00:00	ES	Futures	3070.42	3071.79	3069.33	3070.42	9181.0
2018-08-01 08:30:00	ES	Futures	3070.42	3073.42	3069.33	3073.15	13943.0
2018-08-01 09:00:00	ES	Futures	3073.15	3075.05	3072.6	3072.87	20634.0
2018-08-01 09:30:00	ES	Futures	3072.87	3076.14	3070.97	3074.51	119632.0
2018-08-01 10:00:00	ES	Futures	3073.96	3078.32	3071.79	3077.51	67982.0
2018-08-01 10:30:00	ES	Futures	3077.51	3079.69	3075.87	3076.42	61716.0
2018-08-01 11:00:00	ES	Futures	3076.69	3076.96	3071.24	3072.06	56542.0
2018-08-01 11:30:00	ES	Futures	3072.06	3072.33	3065.79	3066.88	73544.0
2018-08-01 12:00:00	ES	Futures	3067.15	3067.43	3060.61	3061.98	73081.0
2018-08-01 12:30:00	ES	Futures	3061.7	3065.79	3060.34	3064.16	55529.0
2018-08-01 13:00:00	ES	Futures	3064.16	3065.79	3062.79	3063.07	24196.0
2018-08-01 13:30:00	ES	Futures	3063.07	3064.97	3060.34	3063.34	33496.0
2018-08-01 14:00:00	ES	Futures	3063.07	3066.34	3057.62	3066.06	79720.0
2018-08-01 14:30:00	ES	Futures	3066.06	3067.7	3062.52	3067.43	41558.0
2018-08-01 15:00:00	ES	Futures	3067.43	3067.97	3064.7	3067.43	36733.0
2018-08-01 15:30:00	ES	Futures	3067.43	3070.15	3064.97	3066.34	86482.0
2018-08-01 16:00:00	ES	Futures	3066.06	3066.34	3060.61	3063.34	58529.0
2018-08-01 16:30:00	ES	Futures	3063.34	3067.43	3062.52	3066.61	12818.0
2018-08-01 18:00:00	ES	Futures	3066.88	3067.97	3065.79	3067.7	3107.0
2018-08-01 18:30:00	ES	Futures	3067.7	3067.7	3066.34	3067.15	693.0
2018-08-01 19:00:00	ES	Futures	3067.15	3067.43	3065.52	3066.06	2157.0
2018-08-01 19:30:00	ES	Futures	3065.79	3067.15	3065.79	3066.88	873.0
2018-08-01 20:00:00	ES	Futures	3066.61	3067.43	3065.52	3067.43	2045.0
2018-08-01 20:30:00	ES	Futures	3067.15	3067.97	3066.61	3066.88	1575.0
2018-08-01 21:00:00	ES	Futures	3067.15	3067.7	3066.61	3067.43	1886.0
2018-08-01 21:30:00	ES	Futures	3067.43	3067.43	3064.43	3064.7	5350.0
2018-08-01 22:00:00	ES	Futures	3064.43	3065.79	3063.88	3064.43	3199.0
2018-08-01 22:30:00	ES	Futures	3064.43	3064.7	3061.98	3063.07	3088.0
2018-08-01 23:00:00	ES	Futures	3062.79	3063.88	3062.25	3063.07	2147.0
2018-08-01 23:30:00	ES	Futures	3062.79	3063.07	3059.52	3059.8	5391.0
2018-08-01 00:00:00	NQ	Futures	8551.08	8558.44	8549.9	8555.2	779.0
2018-08-01 00:30:00	NQ	Futures	8555.5	8559.03	8552.85	8557.26	619.0
2018-08-01 01:00:00	NQ	Futures	8557.85	8559.91	8555.2	8558.74	558.0
2018-08-01 01:30:00	NQ	Futures	8559.03	8559.03	8552.26	8556.38	901.0

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

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