PREVIEW / futures_30min / 2019-07-28

all futures 30-min files

  file:    by_date/futures_30min/2019/2019-07-28.parquet
  size:    24 KB
  rows:    671

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-07-28 18:00:00	ES	Futures	3272.28	3276.61	3272.28	3276.34	3991.0
2019-07-28 18:30:00	ES	Futures	3276.34	3276.61	3274.72	3274.99	1389.0
2019-07-28 19:00:00	ES	Futures	3274.99	3274.99	3274.45	3274.45	802.0
2019-07-28 19:30:00	ES	Futures	3274.45	3274.99	3273.37	3273.91	1568.0
2019-07-28 20:00:00	ES	Futures	3274.18	3274.45	3271.47	3273.37	4428.0
2019-07-28 20:30:00	ES	Futures	3273.64	3273.91	3271.2	3271.74	2873.0
2019-07-28 21:00:00	ES	Futures	3271.74	3273.37	3271.2	3273.09	3757.0
2019-07-28 21:30:00	ES	Futures	3273.09	3273.91	3272.01	3272.82	4154.0
2019-07-28 22:00:00	ES	Futures	3272.82	3272.82	3270.66	3270.66	3314.0
2019-07-28 22:30:00	ES	Futures	3270.66	3271.74	3270.12	3271.47	2492.0
2019-07-28 23:00:00	ES	Futures	3271.2	3272.01	3270.66	3271.2	1240.0
2019-07-28 23:30:00	ES	Futures	3271.47	3271.74	3270.93	3271.2	1039.0
2019-07-28 18:00:00	NQ	Futures	9304.87	9315.6	9304.87	9313.86	1738.0
2019-07-28 18:30:00	NQ	Futures	9313.86	9314.44	9308.35	9309.51	690.0
2019-07-28 19:00:00	NQ	Futures	9309.51	9310.09	9306.32	9306.9	450.0
2019-07-28 19:30:00	NQ	Futures	9306.9	9308.35	9303.42	9305.45	771.0
2019-07-28 20:00:00	NQ	Futures	9305.45	9305.74	9297.03	9301.68	1880.0
2019-07-28 20:30:00	NQ	Futures	9301.39	9302.84	9293.84	9295.0	1428.0
2019-07-28 21:00:00	NQ	Futures	9294.71	9301.68	9293.84	9299.36	1751.0
2019-07-28 21:30:00	NQ	Futures	9299.65	9303.13	9294.71	9297.32	1767.0
2019-07-28 22:00:00	NQ	Futures	9297.32	9297.32	9290.07	9290.65	1645.0
2019-07-28 22:30:00	NQ	Futures	9290.65	9292.68	9286.88	9291.52	1284.0
2019-07-28 23:00:00	NQ	Futures	9290.94	9294.13	9288.62	9292.1	769.0
2019-07-28 23:30:00	NQ	Futures	9292.1	9295.87	9290.65	9294.13	741.0
2019-07-28 18:00:00	YM	Futures	29518.0	29539.8	29514.8	29538.7	799.0
2019-07-28 18:30:00	YM	Futures	29538.7	29538.7	29525.6	29525.6	192.0
2019-07-28 19:00:00	YM	Futures	29526.7	29527.8	29523.5	29524.5	107.0
2019-07-28 19:30:00	YM	Futures	29523.5	29531.1	29519.1	29523.5	284.0
2019-07-28 20:00:00	YM	Futures	29524.5	29524.5	29496.3	29513.7	929.0
2019-07-28 20:30:00	YM	Futures	29514.8	29518.0	29494.1	29496.3	461.0
2019-07-28 21:00:00	YM	Futures	29496.3	29514.8	29495.2	29511.5	541.0
2019-07-28 21:30:00	YM	Futures	29511.5	29518.0	29501.7	29508.2	518.0
2019-07-28 22:00:00	YM	Futures	29508.2	29508.2	29491.9	29493.0	719.0
2019-07-28 22:30:00	YM	Futures	29491.9	29500.6	29484.3	29497.4	623.0
2019-07-28 23:00:00	YM	Futures	29495.2	29503.9	29490.8	29497.4	238.0
2019-07-28 23:30:00	YM	Futures	29496.3	29501.7	29495.2	29498.4	236.0
2019-07-28 18:00:00	CL	Futures	49.89	50.0	49.78	49.82	2170.0
2019-07-28 18:30:00	CL	Futures	49.82	49.82	49.74	49.77	1103.0
2019-07-28 19:00:00	CL	Futures	49.78	49.78	49.72	49.74	1011.0
2019-07-28 19:30:00	CL	Futures	49.75	49.78	49.69	49.71	1227.0
2019-07-28 20:00:00	CL	Futures	49.72	49.82	49.71	49.8	3505.0
2019-07-28 20:30:00	CL	Futures	49.8	49.83	49.77	49.78	1138.0
2019-07-28 21:00:00	CL	Futures	49.77	49.88	49.77	49.8	2675.0
2019-07-28 21:30:00	CL	Futures	49.8	49.88	49.8	49.82	2486.0
2019-07-28 22:00:00	CL	Futures	49.82	49.82	49.77	49.78	1499.0
2019-07-28 22:30:00	CL	Futures	49.77	49.8	49.75	49.78	1519.0
2019-07-28 23:00:00	CL	Futures	49.78	49.83	49.77	49.8	1234.0
2019-07-28 23:30:00	CL	Futures	49.8	49.83	49.8	49.82	576.0
2019-07-28 18:00:00	GC	Futures	1814.0	1816.3	1812.9	1815.9	921.0
2019-07-28 18:30:00	GC	Futures	1815.9	1815.9	1814.4	1814.5	421.0

> showing 50 of 671 rows — these rows as CSV

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