PREVIEW / futures_30min / 2018-07-22

all futures 30-min files

  file:    by_date/futures_30min/2018/2018-07-22.parquet
  size:    21 KB
  rows:    561

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-22 18:00:00	ES	Futures	3057.34	3058.16	3054.89	3055.98	2720.0
2018-07-22 18:30:00	ES	Futures	3055.98	3056.8	3055.16	3056.53	1083.0
2018-07-22 19:00:00	ES	Futures	3056.53	3057.07	3055.98	3056.53	979.0
2018-07-22 19:30:00	ES	Futures	3056.53	3056.8	3053.8	3053.8	1657.0
2018-07-22 20:00:00	ES	Futures	3053.8	3054.62	3052.17	3052.44	4458.0
2018-07-22 20:30:00	ES	Futures	3052.44	3053.8	3048.35	3048.9	6859.0
2018-07-22 21:00:00	ES	Futures	3048.9	3049.17	3046.17	3047.26	9089.0
2018-07-22 21:30:00	ES	Futures	3047.26	3048.63	3045.36	3047.54	5272.0
2018-07-22 22:00:00	ES	Futures	3047.26	3047.81	3043.45	3046.45	5460.0
2018-07-22 22:30:00	ES	Futures	3046.45	3047.81	3045.9	3046.45	3073.0
2018-07-22 23:00:00	ES	Futures	3046.45	3047.81	3045.36	3046.17	3178.0
2018-07-22 23:30:00	ES	Futures	3046.17	3048.35	3045.63	3048.08	2871.0
2018-07-22 18:00:00	NQ	Futures	8677.09	8688.28	8670.61	8677.09	1189.0
2018-07-22 18:30:00	NQ	Futures	8677.39	8680.33	8674.44	8680.33	384.0
2018-07-22 19:00:00	NQ	Futures	8680.33	8682.1	8678.27	8678.27	288.0
2018-07-22 19:30:00	NQ	Futures	8677.98	8680.04	8672.09	8672.09	572.0
2018-07-22 20:00:00	NQ	Futures	8672.09	8677.09	8668.85	8668.85	1213.0
2018-07-22 20:30:00	NQ	Futures	8669.44	8675.91	8655.3	8658.84	1810.0
2018-07-22 21:00:00	NQ	Futures	8658.84	8659.13	8647.65	8650.3	2482.0
2018-07-22 21:30:00	NQ	Futures	8651.18	8654.42	8638.52	8646.18	2489.0
2018-07-22 22:00:00	NQ	Futures	8645.88	8646.18	8629.1	8637.05	2160.0
2018-07-22 22:30:00	NQ	Futures	8635.87	8641.76	8635.28	8636.46	843.0
2018-07-22 23:00:00	NQ	Futures	8637.05	8641.76	8635.28	8637.35	768.0
2018-07-22 23:30:00	NQ	Futures	8637.93	8642.35	8635.87	8640.88	749.0
2018-07-22 18:00:00	YM	Futures	27274.2	27274.2	27243.7	27251.3	629.0
2018-07-22 18:30:00	YM	Futures	27252.4	27262.2	27250.2	27261.1	327.0
2018-07-22 19:00:00	YM	Futures	27261.1	27263.3	27257.8	27257.8	224.0
2018-07-22 19:30:00	YM	Futures	27257.8	27260.0	27232.8	27232.8	472.0
2018-07-22 20:00:00	YM	Futures	27232.8	27241.5	27214.4	27216.5	1102.0
2018-07-22 20:30:00	YM	Futures	27216.5	27232.8	27179.6	27187.2	1399.0
2018-07-22 21:00:00	YM	Futures	27187.2	27187.2	27161.1	27175.2	1761.0
2018-07-22 21:30:00	YM	Futures	27177.4	27188.3	27153.5	27177.4	1466.0
2018-07-22 22:00:00	YM	Futures	27175.2	27185.0	27126.3	27163.3	1759.0
2018-07-22 22:30:00	YM	Futures	27162.2	27180.7	27153.5	27170.9	888.0
2018-07-22 23:00:00	YM	Futures	27169.8	27181.7	27158.9	27165.4	601.0
2018-07-22 23:30:00	YM	Futures	27166.5	27190.4	27162.2	27188.3	690.0
2018-07-22 18:00:00	CL	Futures	61.96	62.05	61.82	62.04	1946.0
2018-07-22 18:30:00	CL	Futures	62.05	62.12	62.03	62.06	929.0
2018-07-22 19:00:00	CL	Futures	62.06	62.12	62.05	62.06	781.0
2018-07-22 19:30:00	CL	Futures	62.06	62.07	62.01	62.06	894.0
2018-07-22 20:00:00	CL	Futures	62.07	62.11	61.94	61.99	2381.0
2018-07-22 20:30:00	CL	Futures	62.0	62.02	61.9	61.91	1535.0
2018-07-22 21:00:00	CL	Futures	61.91	61.96	61.87	61.94	2218.0
2018-07-22 21:30:00	CL	Futures	61.93	61.98	61.82	61.87	2935.0
2018-07-22 22:00:00	CL	Futures	61.86	61.91	61.77	61.83	1958.0
2018-07-22 22:30:00	CL	Futures	61.84	61.92	61.83	61.88	1244.0
2018-07-22 23:00:00	CL	Futures	61.88	61.95	61.87	61.93	929.0
2018-07-22 23:30:00	CL	Futures	61.93	62.01	61.91	61.98	1716.0
2018-07-22 18:00:00	GC	Futures	1617.2	1617.6	1615.3	1616.7	1132.0
2018-07-22 18:30:00	GC	Futures	1616.6	1617.6	1616.4	1617.5	1239.0

> showing 50 of 561 rows — these rows as CSV

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