PREVIEW / futures_30min / 2018-09-02

all futures 30-min files

  file:    by_date/futures_30min/2018/2018-09-02.parquet
  size:    19 KB
  rows:    495

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-02 18:00:00	ES	Futures	3167.69	3168.24	3165.79	3166.6	3623.0
2018-09-02 18:30:00	ES	Futures	3166.33	3167.69	3166.33	3167.15	1435.0
2018-09-02 19:00:00	ES	Futures	3167.15	3167.97	3166.06	3167.69	1352.0
2018-09-02 19:30:00	ES	Futures	3167.69	3168.51	3167.42	3167.69	1861.0
2018-09-02 20:00:00	ES	Futures	3167.69	3167.69	3166.06	3167.69	3462.0
2018-09-02 20:30:00	ES	Futures	3167.69	3167.69	3165.24	3167.42	2779.0
2018-09-02 21:00:00	ES	Futures	3167.42	3167.42	3164.7	3166.88	2846.0
2018-09-02 21:30:00	ES	Futures	3166.6	3168.24	3165.79	3167.97	3370.0
2018-09-02 22:00:00	ES	Futures	3167.69	3167.69	3165.79	3166.06	2523.0
2018-09-02 22:30:00	ES	Futures	3166.06	3167.15	3165.24	3166.33	2167.0
2018-09-02 23:00:00	ES	Futures	3166.33	3166.88	3164.7	3164.7	2297.0
2018-09-02 23:30:00	ES	Futures	3164.97	3165.24	3163.88	3165.24	1781.0
2018-09-02 18:00:00	NQ	Futures	9032.75	9038.64	9027.45	9028.33	919.0
2018-09-02 18:30:00	NQ	Futures	9028.33	9030.69	9026.27	9029.51	282.0
2018-09-02 19:00:00	NQ	Futures	9029.51	9033.93	9027.15	9033.63	536.0
2018-09-02 19:30:00	NQ	Futures	9033.63	9040.11	9033.34	9036.87	829.0
2018-09-02 20:00:00	NQ	Futures	9036.58	9037.46	9032.75	9036.28	886.0
2018-09-02 20:30:00	NQ	Futures	9036.28	9036.58	9029.8	9035.1	1006.0
2018-09-02 21:00:00	NQ	Futures	9035.1	9037.46	9026.86	9033.34	1332.0
2018-09-02 21:30:00	NQ	Futures	9033.04	9042.17	9030.39	9038.93	1247.0
2018-09-02 22:00:00	NQ	Futures	9038.64	9039.81	9031.87	9031.87	921.0
2018-09-02 22:30:00	NQ	Futures	9031.87	9035.1	9029.51	9033.34	423.0
2018-09-02 23:00:00	NQ	Futures	9033.04	9034.22	9025.98	9026.27	727.0
2018-09-02 23:30:00	NQ	Futures	9026.57	9029.8	9024.8	9029.51	395.0
2018-09-02 18:00:00	YM	Futures	28288.5	28305.8	28274.3	28281.9	485.0
2018-09-02 18:30:00	YM	Futures	28279.8	28284.1	28266.7	28272.1	313.0
2018-09-02 19:00:00	YM	Futures	28271.1	28276.5	28259.1	28274.3	292.0
2018-09-02 19:30:00	YM	Futures	28274.3	28284.1	28273.2	28279.8	487.0
2018-09-02 20:00:00	YM	Futures	28277.6	28278.7	28260.2	28272.1	700.0
2018-09-02 20:30:00	YM	Futures	28272.1	28272.1	28250.4	28266.7	761.0
2018-09-02 21:00:00	YM	Futures	28268.9	28268.9	28242.8	28259.1	972.0
2018-09-02 21:30:00	YM	Futures	28258.0	28276.5	28250.4	28271.1	787.0
2018-09-02 22:00:00	YM	Futures	28270.0	28270.0	28247.1	28247.1	679.0
2018-09-02 22:30:00	YM	Futures	28247.1	28259.1	28240.6	28252.6	503.0
2018-09-02 23:00:00	YM	Futures	28252.6	28256.9	28235.2	28237.4	550.0
2018-09-02 23:30:00	YM	Futures	28236.3	28240.6	28229.7	28240.6	449.0
2018-09-02 18:00:00	CL	Futures	64.17	64.24	64.17	64.22	885.0
2018-09-02 18:30:00	CL	Futures	64.22	64.27	64.2	64.22	480.0
2018-09-02 19:00:00	CL	Futures	64.22	64.22	64.16	64.19	475.0
2018-09-02 19:30:00	CL	Futures	64.18	64.21	64.17	64.2	292.0
2018-09-02 20:00:00	CL	Futures	64.19	64.22	64.1	64.1	1560.0
2018-09-02 20:30:00	CL	Futures	64.1	64.11	64.04	64.08	1767.0
2018-09-02 21:00:00	CL	Futures	64.08	64.11	64.01	64.1	2094.0
2018-09-02 21:30:00	CL	Futures	64.1	64.11	64.03	64.06	1838.0
2018-09-02 22:00:00	CL	Futures	64.05	64.06	63.84	63.9	4820.0
2018-09-02 22:30:00	CL	Futures	63.9	63.93	63.88	63.9	1990.0
2018-09-02 23:00:00	CL	Futures	63.9	63.95	63.88	63.9	2369.0
2018-09-02 23:30:00	CL	Futures	63.89	63.91	63.86	63.91	1532.0
2018-09-02 18:00:00	GC	Futures	1571.6	1572.2	1570.7	1571.2	695.0
2018-09-02 18:30:00	GC	Futures	1571.2	1571.6	1570.1	1570.6	657.0

> showing 50 of 495 rows — these rows as CSV

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