PREVIEW / futures_30min / 2018-07-08

all futures 30-min files

  file:    by_date/futures_30min/2018/2018-07-08.parquet
  size:    22 KB
  rows:    573

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-08 18:00:00	ES	Futures	3010.21	3014.02	3009.94	3012.93	2861.0
2018-07-08 18:30:00	ES	Futures	3013.2	3013.48	3012.39	3012.66	517.0
2018-07-08 19:00:00	ES	Futures	3012.66	3015.66	3011.57	3014.29	2043.0
2018-07-08 19:30:00	ES	Futures	3014.29	3015.66	3013.48	3014.29	1828.0
2018-07-08 20:00:00	ES	Futures	3014.57	3017.84	3013.75	3017.29	5391.0
2018-07-08 20:30:00	ES	Futures	3017.29	3018.65	3016.47	3017.56	3167.0
2018-07-08 21:00:00	ES	Futures	3017.84	3021.38	3017.29	3018.38	6853.0
2018-07-08 21:30:00	ES	Futures	3018.11	3021.92	3017.84	3021.38	6332.0
2018-07-08 22:00:00	ES	Futures	3021.65	3023.29	3021.38	3022.47	5699.0
2018-07-08 22:30:00	ES	Futures	3022.47	3023.56	3021.92	3023.29	3231.0
2018-07-08 23:00:00	ES	Futures	3023.01	3023.29	3021.65	3022.47	2077.0
2018-07-08 23:30:00	ES	Futures	3022.47	3023.83	3022.2	3022.47	1982.0
2018-07-08 18:00:00	NQ	Futures	8517.52	8525.76	8517.22	8522.23	900.0
2018-07-08 18:30:00	NQ	Futures	8522.23	8525.47	8521.64	8523.41	380.0
2018-07-08 19:00:00	NQ	Futures	8523.11	8529.0	8519.87	8526.06	1084.0
2018-07-08 19:30:00	NQ	Futures	8526.06	8529.59	8521.64	8525.17	653.0
2018-07-08 20:00:00	NQ	Futures	8524.88	8537.24	8523.41	8536.07	1918.0
2018-07-08 20:30:00	NQ	Futures	8536.07	8545.19	8533.42	8541.36	1821.0
2018-07-08 21:00:00	NQ	Futures	8541.36	8552.26	8538.13	8541.07	2265.0
2018-07-08 21:30:00	NQ	Futures	8541.36	8554.32	8539.89	8552.55	2452.0
2018-07-08 22:00:00	NQ	Futures	8553.14	8561.68	8553.14	8558.74	2136.0
2018-07-08 22:30:00	NQ	Futures	8558.74	8561.09	8554.32	8558.15	1052.0
2018-07-08 23:00:00	NQ	Futures	8557.85	8559.62	8551.38	8554.02	990.0
2018-07-08 23:30:00	NQ	Futures	8553.73	8558.74	8552.26	8552.85	731.0
2018-07-08 18:00:00	YM	Futures	26588.2	26627.3	26583.8	26624.0	816.0
2018-07-08 18:30:00	YM	Futures	26625.1	26626.2	26613.2	26618.6	280.0
2018-07-08 19:00:00	YM	Futures	26618.6	26662.1	26605.6	26643.6	736.0
2018-07-08 19:30:00	YM	Futures	26642.5	26656.7	26637.1	26641.4	491.0
2018-07-08 20:00:00	YM	Futures	26643.6	26677.3	26632.7	26673.0	1496.0
2018-07-08 20:30:00	YM	Futures	26674.0	26690.4	26666.4	26678.4	789.0
2018-07-08 21:00:00	YM	Futures	26678.4	26717.5	26671.9	26681.7	1774.0
2018-07-08 21:30:00	YM	Futures	26681.7	26716.4	26676.2	26709.9	1429.0
2018-07-08 22:00:00	YM	Futures	26709.9	26724.1	26709.9	26716.4	930.0
2018-07-08 22:30:00	YM	Futures	26718.6	26725.1	26712.1	26718.6	655.0
2018-07-08 23:00:00	YM	Futures	26719.7	26723.0	26711.0	26720.8	478.0
2018-07-08 23:30:00	YM	Futures	26720.8	26748.0	26720.8	26733.8	1282.0
2018-07-08 18:00:00	CL	Futures	66.13	66.5	66.1	66.21	2832.0
2018-07-08 18:30:00	CL	Futures	66.21	66.24	66.11	66.18	1012.0
2018-07-08 19:00:00	CL	Futures	66.18	66.2	66.05	66.07	1835.0
2018-07-08 19:30:00	CL	Futures	66.06	66.17	66.02	66.15	1287.0
2018-07-08 20:00:00	CL	Futures	66.14	66.17	66.03	66.08	3037.0
2018-07-08 20:30:00	CL	Futures	66.08	66.11	66.02	66.07	2362.0
2018-07-08 21:00:00	CL	Futures	66.07	66.19	66.07	66.12	2823.0
2018-07-08 21:30:00	CL	Futures	66.12	66.37	66.12	66.33	3870.0
2018-07-08 22:00:00	CL	Futures	66.34	66.37	66.27	66.3	2771.0
2018-07-08 22:30:00	CL	Futures	66.3	66.39	66.29	66.38	2668.0
2018-07-08 23:00:00	CL	Futures	66.38	66.43	66.31	66.37	2502.0
2018-07-08 23:30:00	CL	Futures	66.37	66.4	66.28	66.32	1635.0
2018-07-08 18:00:00	GC	Futures	1648.7	1650.5	1648.7	1649.7	1083.0
2018-07-08 18:30:00	GC	Futures	1649.7	1650.6	1649.5	1650.2	508.0

> showing 50 of 573 rows — these rows as CSV

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