PREVIEW / futures_30min / 2019-04-14

all futures 30-min files

  file:    by_date/futures_30min/2019/2019-04-14.parquet
  size:    22 KB
  rows:    627

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
2019-04-14 18:00:00	ES	Futures	3157.8	3159.7	3155.63	3155.9	5751.0
2019-04-14 18:30:00	ES	Futures	3156.17	3156.71	3155.9	3156.17	2305.0
2019-04-14 19:00:00	ES	Futures	3156.17	3157.53	3156.17	3156.99	1590.0
2019-04-14 19:30:00	ES	Futures	3157.26	3157.53	3156.17	3156.99	1730.0
2019-04-14 20:00:00	ES	Futures	3156.99	3157.8	3155.9	3156.99	5047.0
2019-04-14 20:30:00	ES	Futures	3156.99	3157.26	3155.9	3156.17	2122.0
2019-04-14 21:00:00	ES	Futures	3156.44	3156.71	3154.82	3156.17	5328.0
2019-04-14 21:30:00	ES	Futures	3156.17	3157.53	3155.9	3157.26	4245.0
2019-04-14 22:00:00	ES	Futures	3157.26	3158.34	3156.71	3158.34	2505.0
2019-04-14 22:30:00	ES	Futures	3158.34	3158.88	3158.07	3158.88	3544.0
2019-04-14 23:00:00	ES	Futures	3158.88	3158.88	3157.53	3157.8	2459.0
2019-04-14 23:30:00	ES	Futures	3157.53	3157.53	3155.63	3156.71	4114.0
2019-04-14 18:00:00	NQ	Futures	8914.03	8917.53	8905.01	8905.3	1807.0
2019-04-14 18:30:00	NQ	Futures	8905.88	8908.79	8905.3	8906.46	549.0
2019-04-14 19:00:00	NQ	Futures	8906.75	8910.25	8906.46	8909.08	683.0
2019-04-14 19:30:00	NQ	Futures	8909.08	8910.25	8906.75	8909.38	847.0
2019-04-14 20:00:00	NQ	Futures	8908.79	8913.16	8905.01	8909.38	2384.0
2019-04-14 20:30:00	NQ	Futures	8909.38	8909.96	8904.72	8905.88	1354.0
2019-04-14 21:00:00	NQ	Futures	8905.88	8907.92	8901.22	8907.34	2139.0
2019-04-14 21:30:00	NQ	Futures	8907.34	8911.41	8906.17	8907.92	2481.0
2019-04-14 22:00:00	NQ	Futures	8907.92	8910.83	8905.59	8910.83	1406.0
2019-04-14 22:30:00	NQ	Futures	8910.83	8914.91	8909.96	8913.74	1406.0
2019-04-14 23:00:00	NQ	Futures	8914.03	8914.03	8908.5	8908.79	1300.0
2019-04-14 23:30:00	NQ	Futures	8908.79	8909.08	8901.51	8903.55	2372.0
2019-04-14 18:00:00	YM	Futures	28720.9	28752.5	28714.4	28714.4	980.0
2019-04-14 18:30:00	YM	Futures	28716.6	28726.4	28715.5	28724.2	355.0
2019-04-14 19:00:00	YM	Futures	28724.2	28737.3	28723.1	28732.9	406.0
2019-04-14 19:30:00	YM	Futures	28732.9	28739.4	28726.4	28732.9	402.0
2019-04-14 20:00:00	YM	Futures	28734.0	28744.9	28728.6	28739.4	1053.0
2019-04-14 20:30:00	YM	Futures	28740.5	28740.5	28722.0	28729.6	469.0
2019-04-14 21:00:00	YM	Futures	28729.6	28732.9	28711.2	28729.6	958.0
2019-04-14 21:30:00	YM	Futures	28730.7	28742.7	28728.6	28741.6	749.0
2019-04-14 22:00:00	YM	Futures	28742.7	28746.0	28735.1	28746.0	581.0
2019-04-14 22:30:00	YM	Futures	28746.0	28762.3	28744.9	28755.7	807.0
2019-04-14 23:00:00	YM	Futures	28755.7	28760.1	28744.9	28746.0	464.0
2019-04-14 23:30:00	YM	Futures	28744.9	28746.0	28726.4	28735.1	736.0
2019-04-14 18:00:00	CL	Futures	57.13	57.18	56.9	56.95	717.0
2019-04-14 18:30:00	CL	Futures	56.94	56.97	56.9	56.95	207.0
2019-04-14 19:00:00	CL	Futures	56.94	56.96	56.91	56.94	116.0
2019-04-14 19:30:00	CL	Futures	56.95	57.02	56.93	57.0	243.0
2019-04-14 20:00:00	CL	Futures	57.02	57.06	56.94	56.94	327.0
2019-04-14 20:30:00	CL	Futures	56.94	56.94	56.81	56.87	512.0
2019-04-14 21:00:00	CL	Futures	56.88	56.92	56.81	56.89	570.0
2019-04-14 21:30:00	CL	Futures	56.89	56.97	56.86	56.97	346.0
2019-04-14 22:00:00	CL	Futures	56.97	57.06	56.96	57.02	562.0
2019-04-14 22:30:00	CL	Futures	57.02	57.06	56.99	57.04	699.0
2019-04-14 23:00:00	CL	Futures	57.05	57.11	57.03	57.06	486.0
2019-04-14 23:30:00	CL	Futures	57.06	57.06	56.99	57.0	207.0
2019-04-14 18:00:00	GC	Futures	1660.6	1662.1	1660.6	1661.8	1117.0
2019-04-14 18:30:00	GC	Futures	1661.8	1661.8	1660.6	1661.2	607.0

> showing 50 of 627 rows — these rows as CSV

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