PREVIEW / futures_30min / 2018-04-01

all futures 30-min files

  file:    by_date/futures_30min/2018/2018-04-01.parquet
  size:    21 KB
  rows:    566

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-04-01 18:00:00	ES	Futures	2876.45	2883.55	2872.36	2882.45	9661.0
2018-04-01 18:30:00	ES	Futures	2882.73	2883.0	2878.09	2878.63	3012.0
2018-04-01 19:00:00	ES	Futures	2878.63	2881.64	2875.36	2875.36	2921.0
2018-04-01 19:30:00	ES	Futures	2875.36	2878.36	2872.63	2877.54	6033.0
2018-04-01 20:00:00	ES	Futures	2877.54	2883.27	2875.63	2880.0	6313.0
2018-04-01 20:30:00	ES	Futures	2880.0	2880.27	2875.9	2878.09	3900.0
2018-04-01 21:00:00	ES	Futures	2878.09	2881.64	2876.72	2881.36	4007.0
2018-04-01 21:30:00	ES	Futures	2881.36	2883.0	2880.0	2882.18	3315.0
2018-04-01 22:00:00	ES	Futures	2882.18	2883.27	2878.63	2879.18	2784.0
2018-04-01 22:30:00	ES	Futures	2879.18	2879.18	2875.09	2878.09	2520.0
2018-04-01 23:00:00	ES	Futures	2877.82	2878.91	2875.9	2878.91	1987.0
2018-04-01 23:30:00	ES	Futures	2878.63	2880.54	2877.82	2879.18	2108.0
2018-04-01 18:00:00	NQ	Futures	7751.22	7788.45	7749.44	7784.91	2698.0
2018-04-01 18:30:00	NQ	Futures	7784.32	7784.32	7761.27	7763.04	1263.0
2018-04-01 19:00:00	NQ	Futures	7763.04	7770.43	7752.4	7752.69	1121.0
2018-04-01 19:30:00	NQ	Futures	7752.69	7758.9	7740.87	7753.58	1896.0
2018-04-01 20:00:00	NQ	Futures	7753.88	7774.27	7745.31	7762.45	2287.0
2018-04-01 20:30:00	NQ	Futures	7762.45	7767.47	7751.22	7762.15	1574.0
2018-04-01 21:00:00	NQ	Futures	7761.56	7771.9	7754.47	7768.95	1318.0
2018-04-01 21:30:00	NQ	Futures	7768.65	7770.72	7759.79	7765.99	1102.0
2018-04-01 22:00:00	NQ	Futures	7765.7	7769.84	7755.95	7758.01	875.0
2018-04-01 22:30:00	NQ	Futures	7757.72	7760.08	7748.26	7755.35	1105.0
2018-04-01 23:00:00	NQ	Futures	7755.65	7762.15	7750.33	7758.01	851.0
2018-04-01 23:30:00	NQ	Futures	7758.01	7765.11	7754.17	7761.27	743.0
2018-04-01 18:00:00	YM	Futures	26169.9	26224.2	26121.0	26218.8	1260.0
2018-04-01 18:30:00	YM	Futures	26219.9	26223.1	26168.8	26180.8	768.0
2018-04-01 19:00:00	YM	Futures	26180.8	26201.4	26151.4	26151.4	517.0
2018-04-01 19:30:00	YM	Futures	26151.4	26173.2	26129.7	26164.5	1149.0
2018-04-01 20:00:00	YM	Futures	26166.6	26214.4	26149.3	26181.8	1764.0
2018-04-01 20:30:00	YM	Futures	26180.8	26191.6	26153.6	26175.3	1676.0
2018-04-01 21:00:00	YM	Futures	26174.2	26222.0	26162.3	26219.9	2565.0
2018-04-01 21:30:00	YM	Futures	26219.9	26220.9	26198.1	26211.2	1376.0
2018-04-01 22:00:00	YM	Futures	26212.3	26219.9	26176.4	26179.7	1344.0
2018-04-01 22:30:00	YM	Futures	26180.8	26180.8	26151.4	26166.6	1114.0
2018-04-01 23:00:00	YM	Futures	26167.7	26172.1	26138.4	26165.6	1640.0
2018-04-01 23:30:00	YM	Futures	26165.6	26179.7	26155.8	26169.9	1209.0
2018-04-01 18:00:00	CL	Futures	57.91	58.08	57.87	58.01	2776.0
2018-04-01 18:30:00	CL	Futures	58.01	58.04	57.95	58.04	1037.0
2018-04-01 19:00:00	CL	Futures	58.04	58.12	58.0	58.05	1437.0
2018-04-01 19:30:00	CL	Futures	58.05	58.12	58.04	58.07	988.0
2018-04-01 20:00:00	CL	Futures	58.07	58.31	58.07	58.21	5370.0
2018-04-01 20:30:00	CL	Futures	58.2	58.21	58.13	58.13	2283.0
2018-04-01 21:00:00	CL	Futures	58.13	58.21	58.13	58.16	3078.0
2018-04-01 21:30:00	CL	Futures	58.16	58.21	58.15	58.18	1938.0
2018-04-01 22:00:00	CL	Futures	58.19	58.25	58.16	58.18	2103.0
2018-04-01 22:30:00	CL	Futures	58.17	58.19	58.12	58.15	2281.0
2018-04-01 23:00:00	CL	Futures	58.15	58.17	58.13	58.14	1035.0
2018-04-01 23:30:00	CL	Futures	58.14	58.17	58.13	58.16	573.0
2018-04-01 18:00:00	GC	Futures	1753.3	1753.7	1751.3	1752.0	1948.0
2018-04-01 18:30:00	GC	Futures	1752.0	1753.1	1751.0	1752.9	1051.0

> showing 50 of 566 rows — these rows as CSV

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