PREVIEW / futures_30min / 2018-08-02

all futures 30-min files

  file:    by_date/futures_30min/2018/2018-08-02.parquet
  size:    87 KB
  rows:    3,186

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-02 00:00:00	ES	Futures	3060.07	3060.89	3056.8	3057.62	3936.0
2018-08-02 00:30:00	ES	Futures	3057.34	3061.43	3057.07	3060.34	4384.0
2018-08-02 01:00:00	ES	Futures	3060.34	3061.98	3057.34	3058.43	5534.0
2018-08-02 01:30:00	ES	Futures	3058.43	3060.34	3057.34	3058.16	7447.0
2018-08-02 02:00:00	ES	Futures	3058.16	3058.71	3055.44	3056.8	6742.0
2018-08-02 02:30:00	ES	Futures	3057.07	3058.71	3053.26	3054.89	7187.0
2018-08-02 03:00:00	ES	Futures	3054.89	3055.44	3051.35	3053.53	15006.0
2018-08-02 03:30:00	ES	Futures	3053.26	3054.35	3051.62	3053.26	13217.0
2018-08-02 04:00:00	ES	Futures	3052.98	3055.98	3052.17	3053.26	8553.0
2018-08-02 04:30:00	ES	Futures	3053.53	3054.35	3049.44	3049.99	10916.0
2018-08-02 05:00:00	ES	Futures	3049.99	3050.53	3045.36	3046.45	15150.0
2018-08-02 05:30:00	ES	Futures	3046.72	3046.72	3042.63	3045.63	19929.0
2018-08-02 06:00:00	ES	Futures	3045.36	3046.45	3042.09	3044.27	13027.0
2018-08-02 06:30:00	ES	Futures	3044.54	3044.81	3041.81	3044.81	14505.0
2018-08-02 07:00:00	ES	Futures	3044.81	3047.54	3043.99	3047.26	14244.0
2018-08-02 07:30:00	ES	Futures	3047.26	3047.81	3046.17	3046.45	9462.0
2018-08-02 08:00:00	ES	Futures	3046.45	3048.08	3043.45	3047.54	20036.0
2018-08-02 08:30:00	ES	Futures	3047.81	3050.26	3046.99	3048.9	13233.0
2018-08-02 09:00:00	ES	Futures	3048.9	3049.44	3046.99	3048.63	14254.0
2018-08-02 09:30:00	ES	Futures	3048.63	3055.98	3046.17	3055.16	134596.0
2018-08-02 10:00:00	ES	Futures	3054.89	3063.07	3054.62	3061.16	109283.0
2018-08-02 10:30:00	ES	Futures	3061.16	3065.25	3056.8	3058.71	89856.0
2018-08-02 11:00:00	ES	Futures	3058.71	3064.97	3057.89	3063.61	51619.0
2018-08-02 11:30:00	ES	Futures	3063.88	3069.88	3063.61	3068.79	78418.0
2018-08-02 12:00:00	ES	Futures	3068.79	3076.14	3066.34	3074.51	73956.0
2018-08-02 12:30:00	ES	Futures	3074.51	3076.96	3072.87	3075.6	55927.0
2018-08-02 13:00:00	ES	Futures	3075.6	3078.87	3075.33	3078.05	37591.0
2018-08-02 13:30:00	ES	Futures	3078.32	3081.87	3078.32	3081.32	45809.0
2018-08-02 14:00:00	ES	Futures	3081.59	3082.96	3078.87	3079.14	39809.0
2018-08-02 14:30:00	ES	Futures	3079.14	3080.5	3077.78	3080.23	29203.0
2018-08-02 15:00:00	ES	Futures	3080.23	3081.32	3077.23	3080.23	44578.0
2018-08-02 15:30:00	ES	Futures	3080.5	3083.77	3079.96	3081.05	107173.0
2018-08-02 16:00:00	ES	Futures	3081.05	3083.5	3080.78	3082.68	49839.0
2018-08-02 16:30:00	ES	Futures	3082.41	3085.68	3082.41	3084.86	8542.0
2018-08-02 18:00:00	ES	Futures	3085.14	3085.14	3083.5	3083.5	2209.0
2018-08-02 18:30:00	ES	Futures	3083.77	3085.14	3082.96	3083.77	1810.0
2018-08-02 19:00:00	ES	Futures	3083.77	3084.05	3083.23	3083.23	929.0
2018-08-02 19:30:00	ES	Futures	3083.23	3083.77	3082.68	3083.23	2080.0
2018-08-02 20:00:00	ES	Futures	3083.5	3084.86	3082.41	3082.96	3032.0
2018-08-02 20:30:00	ES	Futures	3083.23	3084.05	3082.96	3082.96	1870.0
2018-08-02 21:00:00	ES	Futures	3083.23	3083.77	3082.68	3083.23	2148.0
2018-08-02 21:30:00	ES	Futures	3083.23	3084.05	3080.5	3082.41	6049.0
2018-08-02 22:00:00	ES	Futures	3082.41	3082.41	3080.78	3081.59	2890.0
2018-08-02 22:30:00	ES	Futures	3081.32	3081.59	3079.96	3080.5	2757.0
2018-08-02 23:00:00	ES	Futures	3080.5	3082.14	3080.5	3081.05	1867.0
2018-08-02 23:30:00	ES	Futures	3081.05	3081.59	3080.78	3080.78	1212.0
2018-08-02 00:00:00	NQ	Futures	8551.96	8556.38	8540.19	8542.25	1410.0
2018-08-02 00:30:00	NQ	Futures	8542.25	8556.67	8541.07	8553.73	1327.0
2018-08-02 01:00:00	NQ	Futures	8553.73	8557.85	8544.31	8548.14	1334.0
2018-08-02 01:30:00	NQ	Futures	8547.84	8558.74	8545.49	8552.55	1587.0

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

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