PREVIEW / futures_30min / 2019-01-20

all futures 30-min files

  file:    by_date/futures_30min/2019/2019-01-20.parquet
  size:    20 KB
  rows:    534

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-01-20 18:00:00	ES	Futures	2899.71	2904.33	2899.71	2900.79	4547.0
2019-01-20 18:30:00	ES	Futures	2900.52	2900.79	2897.54	2898.62	2065.0
2019-01-20 19:00:00	ES	Futures	2898.62	2899.44	2895.91	2897.81	4566.0
2019-01-20 19:30:00	ES	Futures	2897.81	2899.71	2897.54	2898.08	2643.0
2019-01-20 20:00:00	ES	Futures	2897.81	2898.08	2890.47	2892.65	9305.0
2019-01-20 20:30:00	ES	Futures	2892.65	2895.63	2892.1	2893.73	5234.0
2019-01-20 21:00:00	ES	Futures	2894.01	2897.81	2892.92	2894.28	6176.0
2019-01-20 21:30:00	ES	Futures	2894.28	2897.81	2894.01	2896.72	2372.0
2019-01-20 22:00:00	ES	Futures	2896.45	2896.72	2894.55	2894.55	1983.0
2019-01-20 22:30:00	ES	Futures	2894.55	2895.36	2893.73	2893.73	1809.0
2019-01-20 23:00:00	ES	Futures	2894.01	2894.82	2892.65	2893.73	2154.0
2019-01-20 23:30:00	ES	Futures	2894.01	2896.72	2893.46	2896.45	2355.0
2019-01-20 18:00:00	NQ	Futures	7941.12	7941.12	7921.55	7930.02	1611.0
2019-01-20 18:30:00	NQ	Futures	7930.31	7931.77	7920.96	7924.76	1217.0
2019-01-20 19:00:00	NQ	Futures	7923.59	7930.31	7917.16	7923.88	2559.0
2019-01-20 19:30:00	NQ	Futures	7924.17	7930.02	7920.38	7920.96	1757.0
2019-01-20 20:00:00	NQ	Futures	7920.67	7921.84	7897.0	7905.18	4747.0
2019-01-20 20:30:00	NQ	Futures	7905.18	7914.82	7902.84	7909.27	2487.0
2019-01-20 21:00:00	NQ	Futures	7909.27	7924.17	7907.52	7911.03	2955.0
2019-01-20 21:30:00	NQ	Futures	7911.03	7923.3	7910.44	7918.92	2121.0
2019-01-20 22:00:00	NQ	Futures	7918.92	7920.38	7909.57	7910.15	1364.0
2019-01-20 22:30:00	NQ	Futures	7910.15	7915.99	7907.23	7908.98	1109.0
2019-01-20 23:00:00	NQ	Futures	7908.69	7911.32	7904.01	7908.98	953.0
2019-01-20 23:30:00	NQ	Futures	7908.98	7916.87	7908.1	7916.58	936.0
2019-01-20 18:00:00	YM	Futures	26806.1	26819.1	26776.8	26786.6	1138.0
2019-01-20 18:30:00	YM	Futures	26788.7	26788.7	26754.0	26767.0	654.0
2019-01-20 19:00:00	YM	Futures	26764.8	26772.4	26736.6	26756.2	1141.0
2019-01-20 19:30:00	YM	Futures	26755.1	26775.7	26754.0	26755.1	785.0
2019-01-20 20:00:00	YM	Futures	26754.0	26757.2	26687.8	26704.0	2647.0
2019-01-20 20:30:00	YM	Futures	26704.0	26743.1	26698.6	26722.5	1513.0
2019-01-20 21:00:00	YM	Futures	26721.4	26764.8	26714.9	26730.1	1533.0
2019-01-20 21:30:00	YM	Futures	26729.0	26761.6	26726.8	26756.2	798.0
2019-01-20 22:00:00	YM	Futures	26756.2	26757.2	26729.0	26729.0	788.0
2019-01-20 22:30:00	YM	Futures	26730.1	26738.8	26719.2	26722.5	566.0
2019-01-20 23:00:00	YM	Futures	26721.4	26725.8	26710.6	26718.2	637.0
2019-01-20 23:30:00	YM	Futures	26718.2	26741.0	26713.8	26741.0	506.0
2019-01-20 18:00:00	CL	Futures	48.97	49.07	48.59	48.83	3460.0
2019-01-20 18:30:00	CL	Futures	48.83	48.84	48.67	48.69	1380.0
2019-01-20 19:00:00	CL	Futures	48.7	48.72	48.62	48.68	2336.0
2019-01-20 19:30:00	CL	Futures	48.69	48.86	48.68	48.78	2433.0
2019-01-20 20:00:00	CL	Futures	48.78	48.94	48.69	48.81	5150.0
2019-01-20 20:30:00	CL	Futures	48.81	48.87	48.79	48.79	2161.0
2019-01-20 21:00:00	CL	Futures	48.79	49.02	48.79	48.99	4429.0
2019-01-20 21:30:00	CL	Futures	48.99	49.24	48.97	49.16	6714.0
2019-01-20 22:00:00	CL	Futures	49.17	49.31	49.13	49.2	5514.0
2019-01-20 22:30:00	CL	Futures	49.19	49.38	49.19	49.27	4078.0
2019-01-20 23:00:00	CL	Futures	49.28	49.29	49.23	49.24	1712.0
2019-01-20 23:30:00	CL	Futures	49.24	49.29	49.23	49.27	1414.0
2019-01-20 18:00:00	GC	Futures	1659.1	1661.9	1658.9	1661.3	2074.0
2019-01-20 18:30:00	GC	Futures	1661.3	1661.4	1660.6	1660.8	485.0

> showing 50 of 534 rows — these rows as CSV

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