PREVIEW / futures_30min / 2018-07-19

all futures 30-min files

  file:    by_date/futures_30min/2018/2018-07-19.parquet
  size:    88 KB
  rows:    3,153

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-19 00:00:00	ES	Futures	3068.52	3068.52	3066.88	3067.7	1761.0
2018-07-19 00:30:00	ES	Futures	3067.7	3067.97	3066.88	3067.15	945.0
2018-07-19 01:00:00	ES	Futures	3067.15	3068.24	3066.06	3067.7	2366.0
2018-07-19 01:30:00	ES	Futures	3067.7	3067.7	3066.34	3066.34	1723.0
2018-07-19 02:00:00	ES	Futures	3066.61	3067.15	3064.97	3065.52	2910.0
2018-07-19 02:30:00	ES	Futures	3065.79	3065.79	3063.61	3065.25	4795.0
2018-07-19 03:00:00	ES	Futures	3065.25	3066.34	3063.34	3063.88	8446.0
2018-07-19 03:30:00	ES	Futures	3063.88	3065.25	3061.7	3062.25	5511.0
2018-07-19 04:00:00	ES	Futures	3062.25	3064.43	3060.34	3063.07	7083.0
2018-07-19 04:30:00	ES	Futures	3063.34	3065.52	3062.25	3064.16	4218.0
2018-07-19 05:00:00	ES	Futures	3064.16	3064.7	3063.07	3064.7	2377.0
2018-07-19 05:30:00	ES	Futures	3064.43	3064.97	3061.16	3062.25	4559.0
2018-07-19 06:00:00	ES	Futures	3062.25	3062.52	3058.43	3060.07	9642.0
2018-07-19 06:30:00	ES	Futures	3060.07	3061.7	3059.25	3061.43	7125.0
2018-07-19 07:00:00	ES	Futures	3061.43	3062.52	3059.52	3060.07	7287.0
2018-07-19 07:30:00	ES	Futures	3059.8	3061.7	3059.52	3059.52	6233.0
2018-07-19 08:00:00	ES	Futures	3059.52	3060.34	3058.43	3058.43	11144.0
2018-07-19 08:30:00	ES	Futures	3058.43	3061.16	3058.43	3059.8	13828.0
2018-07-19 09:00:00	ES	Futures	3059.52	3061.7	3058.98	3061.43	14103.0
2018-07-19 09:30:00	ES	Futures	3061.16	3065.52	3051.89	3055.71	161372.0
2018-07-19 10:00:00	ES	Futures	3055.44	3060.34	3054.89	3056.53	97945.0
2018-07-19 10:30:00	ES	Futures	3056.8	3059.8	3053.8	3058.16	69423.0
2018-07-19 11:00:00	ES	Futures	3058.16	3062.52	3057.89	3060.61	59563.0
2018-07-19 11:30:00	ES	Futures	3060.61	3064.16	3060.34	3062.79	49586.0
2018-07-19 12:00:00	ES	Futures	3063.07	3063.61	3058.71	3060.34	32373.0
2018-07-19 12:30:00	ES	Futures	3060.07	3061.16	3056.8	3058.71	32329.0
2018-07-19 13:00:00	ES	Futures	3058.71	3063.34	3055.44	3061.16	79810.0
2018-07-19 13:30:00	ES	Futures	3061.43	3064.16	3060.07	3064.16	40433.0
2018-07-19 14:00:00	ES	Futures	3063.88	3066.06	3063.07	3064.7	41353.0
2018-07-19 14:30:00	ES	Futures	3064.7	3064.97	3058.98	3060.89	45110.0
2018-07-19 15:00:00	ES	Futures	3060.61	3062.52	3056.8	3059.25	44384.0
2018-07-19 15:30:00	ES	Futures	3058.98	3060.89	3055.71	3058.16	101868.0
2018-07-19 16:00:00	ES	Futures	3058.16	3058.71	3055.98	3057.89	56734.0
2018-07-19 16:30:00	ES	Futures	3058.71	3058.71	3056.8	3057.07	4822.0
2018-07-19 18:00:00	ES	Futures	3057.62	3060.07	3056.8	3059.8	4305.0
2018-07-19 18:30:00	ES	Futures	3059.8	3059.8	3057.62	3058.16	1556.0
2018-07-19 19:00:00	ES	Futures	3058.43	3060.61	3058.43	3060.34	1192.0
2018-07-19 19:30:00	ES	Futures	3060.34	3060.61	3057.89	3058.71	1072.0
2018-07-19 20:00:00	ES	Futures	3058.71	3061.7	3058.43	3061.16	3020.0
2018-07-19 20:30:00	ES	Futures	3061.43	3062.52	3060.61	3062.25	2946.0
2018-07-19 21:00:00	ES	Futures	3062.25	3063.07	3055.98	3056.8	10314.0
2018-07-19 21:30:00	ES	Futures	3056.8	3058.16	3044.54	3046.17	31900.0
2018-07-19 22:00:00	ES	Futures	3046.45	3051.35	3044.81	3051.08	8436.0
2018-07-19 22:30:00	ES	Futures	3050.81	3052.98	3049.72	3049.99	5873.0
2018-07-19 23:00:00	ES	Futures	3049.99	3052.17	3048.9	3051.89	3338.0
2018-07-19 23:30:00	ES	Futures	3051.89	3052.44	3050.53	3052.17	1884.0
2018-07-19 00:00:00	NQ	Futures	8724.79	8725.38	8715.95	8720.96	1060.0
2018-07-19 00:30:00	NQ	Futures	8720.67	8720.96	8716.25	8717.43	466.0
2018-07-19 01:00:00	NQ	Futures	8717.43	8721.84	8713.01	8720.67	860.0
2018-07-19 01:30:00	NQ	Futures	8720.67	8720.67	8714.19	8716.25	465.0

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

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