PREVIEW / futures_30min / 2018-04-22

all futures 30-min files

  file:    by_date/futures_30min/2018/2018-04-22.parquet
  size:    21 KB
  rows:    569

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-22 18:00:00	ES	Futures	2928.85	2930.76	2923.94	2925.3	8420.0
2018-04-22 18:30:00	ES	Futures	2925.57	2926.39	2922.3	2923.94	3289.0
2018-04-22 19:00:00	ES	Futures	2923.94	2923.94	2917.93	2919.3	5528.0
2018-04-22 19:30:00	ES	Futures	2919.3	2923.39	2919.3	2922.85	2104.0
2018-04-22 20:00:00	ES	Futures	2922.57	2924.48	2920.39	2921.48	4785.0
2018-04-22 20:30:00	ES	Futures	2921.21	2922.3	2920.12	2922.03	1846.0
2018-04-22 21:00:00	ES	Futures	2922.03	2922.85	2921.21	2922.57	1946.0
2018-04-22 21:30:00	ES	Futures	2922.57	2924.48	2922.3	2922.3	3926.0
2018-04-22 22:00:00	ES	Futures	2922.3	2923.12	2919.3	2919.3	2614.0
2018-04-22 22:30:00	ES	Futures	2919.3	2922.85	2918.75	2921.75	2415.0
2018-04-22 23:00:00	ES	Futures	2921.75	2923.66	2920.66	2923.66	1959.0
2018-04-22 23:30:00	ES	Futures	2923.66	2924.48	2923.39	2923.39	1678.0
2018-04-22 18:00:00	NQ	Futures	7926.76	7943.9	7917.6	7921.15	2331.0
2018-04-22 18:30:00	NQ	Futures	7920.85	7923.51	7910.21	7914.94	1332.0
2018-04-22 19:00:00	NQ	Futures	7915.24	7917.31	7899.57	7904.89	1265.0
2018-04-22 19:30:00	NQ	Futures	7905.19	7916.71	7904.01	7915.24	715.0
2018-04-22 20:00:00	NQ	Futures	7914.65	7922.63	7907.85	7909.03	1503.0
2018-04-22 20:30:00	NQ	Futures	7909.03	7914.35	7906.67	7911.69	544.0
2018-04-22 21:00:00	NQ	Futures	7912.58	7916.12	7909.33	7913.17	530.0
2018-04-22 21:30:00	NQ	Futures	7913.76	7920.56	7911.69	7911.99	1189.0
2018-04-22 22:00:00	NQ	Futures	7912.28	7914.65	7899.28	7899.57	1368.0
2018-04-22 22:30:00	NQ	Futures	7899.87	7914.94	7896.91	7912.58	1332.0
2018-04-22 23:00:00	NQ	Futures	7912.58	7914.94	7908.44	7914.94	663.0
2018-04-22 23:30:00	NQ	Futures	7915.24	7917.6	7914.35	7914.35	667.0
2018-04-22 18:00:00	YM	Futures	26653.2	26666.2	26607.6	26614.1	1746.0
2018-04-22 18:30:00	YM	Futures	26616.3	26623.9	26590.2	26605.4	695.0
2018-04-22 19:00:00	YM	Futures	26605.4	26611.9	26556.5	26564.1	1429.0
2018-04-22 19:30:00	YM	Futures	26569.6	26603.2	26566.3	26600.0	817.0
2018-04-22 20:00:00	YM	Futures	26598.9	26626.0	26585.8	26592.4	1303.0
2018-04-22 20:30:00	YM	Futures	26593.5	26602.1	26581.5	26597.8	544.0
2018-04-22 21:00:00	YM	Futures	26594.5	26609.7	26589.1	26603.2	976.0
2018-04-22 21:30:00	YM	Futures	26605.4	26623.9	26598.9	26603.2	1094.0
2018-04-22 22:00:00	YM	Futures	26602.1	26609.7	26577.2	26578.2	1033.0
2018-04-22 22:30:00	YM	Futures	26578.2	26608.7	26575.0	26602.1	821.0
2018-04-22 23:00:00	YM	Futures	26603.2	26611.9	26594.5	26610.8	626.0
2018-04-22 23:30:00	YM	Futures	26610.8	26614.1	26603.2	26605.4	527.0
2018-04-22 18:00:00	CL	Futures	60.97	61.13	60.9	61.1	2945.0
2018-04-22 18:30:00	CL	Futures	61.1	61.13	61.02	61.05	1491.0
2018-04-22 19:00:00	CL	Futures	61.05	61.11	60.97	60.97	1549.0
2018-04-22 19:30:00	CL	Futures	60.97	61.04	60.95	60.99	939.0
2018-04-22 20:00:00	CL	Futures	61.0	61.02	60.96	60.96	1633.0
2018-04-22 20:30:00	CL	Futures	60.95	60.96	60.89	60.93	1699.0
2018-04-22 21:00:00	CL	Futures	60.93	60.96	60.87	60.9	2545.0
2018-04-22 21:30:00	CL	Futures	60.91	61.08	60.9	61.03	3472.0
2018-04-22 22:00:00	CL	Futures	61.04	61.06	60.95	60.97	2222.0
2018-04-22 22:30:00	CL	Futures	60.97	61.04	60.91	61.01	2196.0
2018-04-22 23:00:00	CL	Futures	61.02	61.06	60.98	61.04	2021.0
2018-04-22 23:30:00	CL	Futures	61.04	61.13	61.01	61.07	3024.0
2018-04-22 18:00:00	GC	Futures	1760.5	1762.0	1756.6	1759.9	4322.0
2018-04-22 18:30:00	GC	Futures	1759.9	1760.3	1757.6	1758.9	1589.0

> showing 50 of 569 rows — these rows as CSV

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