PREVIEW / futures_30min / 2018-07-13

all futures 30-min files

  file:    by_date/futures_30min/2018/2018-07-13.parquet
  size:    71 KB
  rows:    2,540

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-13 00:00:00	ES	Futures	3057.89	3059.25	3057.89	3058.98	3083.0
2018-07-13 00:30:00	ES	Futures	3058.98	3059.52	3058.43	3058.98	2375.0
2018-07-13 01:00:00	ES	Futures	3058.98	3058.98	3058.16	3058.43	2108.0
2018-07-13 01:30:00	ES	Futures	3058.43	3058.71	3057.62	3057.89	2221.0
2018-07-13 02:00:00	ES	Futures	3057.89	3059.25	3057.34	3057.89	4197.0
2018-07-13 02:30:00	ES	Futures	3057.62	3058.16	3056.25	3056.8	2892.0
2018-07-13 03:00:00	ES	Futures	3056.8	3057.89	3054.89	3055.44	7561.0
2018-07-13 03:30:00	ES	Futures	3055.44	3056.25	3053.8	3055.16	5227.0
2018-07-13 04:00:00	ES	Futures	3055.16	3055.44	3052.98	3054.89	4635.0
2018-07-13 04:30:00	ES	Futures	3054.89	3054.89	3051.89	3052.44	5740.0
2018-07-13 05:00:00	ES	Futures	3052.71	3052.71	3048.63	3049.44	8607.0
2018-07-13 05:30:00	ES	Futures	3049.44	3049.99	3046.72	3049.72	11576.0
2018-07-13 06:00:00	ES	Futures	3049.99	3052.44	3048.63	3050.26	5335.0
2018-07-13 06:30:00	ES	Futures	3050.26	3052.44	3048.9	3051.62	4649.0
2018-07-13 07:00:00	ES	Futures	3051.89	3052.17	3048.63	3049.72	5693.0
2018-07-13 07:30:00	ES	Futures	3049.72	3053.26	3049.17	3052.98	6054.0
2018-07-13 08:00:00	ES	Futures	3052.98	3052.98	3048.9	3049.44	8381.0
2018-07-13 08:30:00	ES	Futures	3049.44	3050.53	3048.63	3048.63	9472.0
2018-07-13 09:00:00	ES	Futures	3048.9	3050.53	3048.63	3050.26	10730.0
2018-07-13 09:30:00	ES	Futures	3050.26	3053.26	3044.27	3045.9	121017.0
2018-07-13 10:00:00	ES	Futures	3046.17	3051.35	3045.36	3050.26	79522.0
2018-07-13 10:30:00	ES	Futures	3050.26	3056.8	3050.26	3055.16	88865.0
2018-07-13 11:00:00	ES	Futures	3055.16	3058.43	3054.35	3056.8	59581.0
2018-07-13 11:30:00	ES	Futures	3056.8	3058.16	3051.89	3055.16	70737.0
2018-07-13 12:00:00	ES	Futures	3055.16	3057.89	3053.8	3057.07	52037.0
2018-07-13 12:30:00	ES	Futures	3056.8	3058.16	3054.89	3057.89	33204.0
2018-07-13 13:00:00	ES	Futures	3057.62	3058.43	3054.89	3056.53	22556.0
2018-07-13 13:30:00	ES	Futures	3056.25	3056.8	3053.53	3055.71	18087.0
2018-07-13 14:00:00	ES	Futures	3055.44	3055.71	3052.98	3054.35	20261.0
2018-07-13 14:30:00	ES	Futures	3054.07	3055.44	3052.71	3054.62	19651.0
2018-07-13 15:00:00	ES	Futures	3054.62	3056.53	3053.53	3054.35	26858.0
2018-07-13 15:30:00	ES	Futures	3054.62	3056.53	3053.26	3054.35	98668.0
2018-07-13 16:00:00	ES	Futures	3054.35	3055.98	3053.26	3055.16	41910.0
2018-07-13 16:30:00	ES	Futures	3054.62	3056.8	3054.35	3056.25	4762.0
2018-07-13 00:00:00	NQ	Futures	8725.08	8730.09	8725.08	8728.03	1316.0
2018-07-13 00:30:00	NQ	Futures	8728.32	8729.79	8726.26	8729.2	951.0
2018-07-13 01:00:00	NQ	Futures	8728.91	8729.2	8725.67	8727.44	850.0
2018-07-13 01:30:00	NQ	Futures	8727.44	8731.56	8726.55	8728.03	1348.0
2018-07-13 02:00:00	NQ	Futures	8728.03	8729.79	8724.49	8725.67	1452.0
2018-07-13 02:30:00	NQ	Futures	8725.67	8726.55	8721.25	8722.73	1022.0
2018-07-13 03:00:00	NQ	Futures	8722.14	8728.91	8720.08	8721.25	2595.0
2018-07-13 03:30:00	NQ	Futures	8720.96	8725.67	8717.72	8720.37	1939.0
2018-07-13 04:00:00	NQ	Futures	8720.08	8721.55	8710.95	8717.43	2674.0
2018-07-13 04:30:00	NQ	Futures	8717.13	8718.31	8709.48	8710.07	1719.0
2018-07-13 05:00:00	NQ	Futures	8710.07	8710.07	8695.35	8696.52	3289.0
2018-07-13 05:30:00	NQ	Futures	8696.82	8698.88	8688.57	8698.29	3780.0
2018-07-13 06:00:00	NQ	Futures	8698.88	8706.24	8694.17	8700.35	1937.0
2018-07-13 06:30:00	NQ	Futures	8700.35	8707.71	8696.82	8704.18	1927.0
2018-07-13 07:00:00	NQ	Futures	8704.18	8707.71	8697.11	8698.88	2121.0
2018-07-13 07:30:00	NQ	Futures	8698.29	8705.06	8694.17	8704.77	2358.0

> showing 50 of 2,540 rows — these rows as CSV

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