PREVIEW / futures_30min / 2018-09-18

all futures 30-min files

  file:    by_date/futures_30min/2018/2018-09-18.parquet
  size:    85 KB
  rows:    3,113

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-09-18 00:00:00	ES	Futures	3148.92	3149.2	3146.75	3147.56	1855.0
2018-09-18 00:30:00	ES	Futures	3147.56	3148.38	3147.29	3147.84	1110.0
2018-09-18 01:00:00	ES	Futures	3147.84	3148.38	3147.02	3147.56	1537.0
2018-09-18 01:30:00	ES	Futures	3147.56	3149.47	3147.29	3149.2	2247.0
2018-09-18 02:00:00	ES	Futures	3149.2	3154.36	3149.2	3154.09	7964.0
2018-09-18 02:30:00	ES	Futures	3154.09	3154.91	3153.0	3154.09	5293.0
2018-09-18 03:00:00	ES	Futures	3153.82	3154.64	3150.28	3154.09	16876.0
2018-09-18 03:30:00	ES	Futures	3154.36	3156.0	3153.82	3154.64	10924.0
2018-09-18 04:00:00	ES	Futures	3154.64	3156.54	3153.55	3155.45	7001.0
2018-09-18 04:30:00	ES	Futures	3155.18	3156.27	3154.09	3155.18	4095.0
2018-09-18 05:00:00	ES	Futures	3155.18	3158.44	3155.18	3156.54	6752.0
2018-09-18 05:30:00	ES	Futures	3156.54	3157.9	3154.91	3157.36	9866.0
2018-09-18 06:00:00	ES	Futures	3157.63	3158.17	3156.0	3156.27	6305.0
2018-09-18 06:30:00	ES	Futures	3156.0	3157.9	3156.0	3157.36	3425.0
2018-09-18 07:00:00	ES	Futures	3157.36	3158.44	3154.36	3154.91	9039.0
2018-09-18 07:30:00	ES	Futures	3154.64	3157.08	3154.64	3156.54	6279.0
2018-09-18 08:00:00	ES	Futures	3156.81	3157.36	3154.36	3155.45	10011.0
2018-09-18 08:30:00	ES	Futures	3155.45	3159.53	3155.18	3157.63	18581.0
2018-09-18 09:00:00	ES	Futures	3157.9	3158.17	3150.28	3152.46	42376.0
2018-09-18 09:30:00	ES	Futures	3152.73	3163.34	3152.19	3160.08	167690.0
2018-09-18 10:00:00	ES	Futures	3160.35	3164.7	3156.81	3163.61	117429.0
2018-09-18 10:30:00	ES	Futures	3163.34	3166.33	3160.89	3166.06	83462.0
2018-09-18 11:00:00	ES	Futures	3166.06	3169.32	3164.43	3169.32	75099.0
2018-09-18 11:30:00	ES	Futures	3169.05	3170.68	3167.96	3170.41	55675.0
2018-09-18 12:00:00	ES	Futures	3170.41	3173.13	3168.78	3168.78	59995.0
2018-09-18 12:30:00	ES	Futures	3169.05	3170.96	3167.69	3168.51	35219.0
2018-09-18 13:00:00	ES	Futures	3168.24	3170.96	3167.96	3167.96	21736.0
2018-09-18 13:30:00	ES	Futures	3167.96	3170.96	3166.88	3170.68	26924.0
2018-09-18 14:00:00	ES	Futures	3170.41	3173.68	3169.87	3172.86	29319.0
2018-09-18 14:30:00	ES	Futures	3172.86	3174.49	3170.96	3171.5	43483.0
2018-09-18 15:00:00	ES	Futures	3171.23	3173.13	3170.14	3171.77	37544.0
2018-09-18 15:30:00	ES	Futures	3171.5	3171.77	3166.6	3167.42	135871.0
2018-09-18 16:00:00	ES	Futures	3167.42	3168.78	3166.33	3168.51	51359.0
2018-09-18 16:30:00	ES	Futures	3168.51	3169.6	3167.69	3169.05	5936.0
2018-09-18 18:00:00	ES	Futures	3169.32	3170.14	3168.78	3170.14	2693.0
2018-09-18 18:30:00	ES	Futures	3169.87	3171.77	3169.87	3170.68	1775.0
2018-09-18 19:00:00	ES	Futures	3170.68	3171.23	3170.41	3171.23	958.0
2018-09-18 19:30:00	ES	Futures	3171.23	3171.23	3168.51	3168.51	1662.0
2018-09-18 20:00:00	ES	Futures	3168.51	3168.51	3164.97	3166.88	5488.0
2018-09-18 20:30:00	ES	Futures	3167.15	3168.24	3166.06	3167.15	2513.0
2018-09-18 21:00:00	ES	Futures	3167.15	3167.96	3166.88	3166.88	1687.0
2018-09-18 21:30:00	ES	Futures	3166.88	3167.42	3165.52	3166.33	3640.0
2018-09-18 22:00:00	ES	Futures	3166.33	3169.32	3165.52	3169.32	4512.0
2018-09-18 22:30:00	ES	Futures	3169.05	3169.32	3167.69	3169.05	2460.0
2018-09-18 23:00:00	ES	Futures	3169.32	3169.87	3167.69	3169.05	2800.0
2018-09-18 23:30:00	ES	Futures	3169.32	3169.32	3166.33	3166.33	2796.0
2018-09-18 00:00:00	NQ	Futures	8745.45	8746.63	8738.71	8742.23	844.0
2018-09-18 00:30:00	NQ	Futures	8742.52	8746.33	8741.35	8743.4	661.0
2018-09-18 01:00:00	NQ	Futures	8743.69	8745.16	8738.71	8742.52	930.0
2018-09-18 01:30:00	NQ	Futures	8742.52	8749.56	8742.52	8748.68	1109.0

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

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