PREVIEW / futures_30min / 2019-07-29

all futures 30-min files

  file:    by_date/futures_30min/2019/2019-07-29.parquet
  size:    85 KB
  rows:    3,456

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-29 00:00:00	ES	Futures	3271.2	3272.28	3271.2	3271.47	1062.0
2019-07-29 00:30:00	ES	Futures	3271.2	3271.74	3270.93	3271.2	907.0
2019-07-29 01:00:00	ES	Futures	3271.47	3271.47	3270.12	3270.66	2075.0
2019-07-29 01:30:00	ES	Futures	3270.66	3271.74	3270.12	3271.47	2214.0
2019-07-29 02:00:00	ES	Futures	3271.47	3272.28	3271.2	3272.01	2531.0
2019-07-29 02:30:00	ES	Futures	3272.01	3272.55	3270.93	3271.47	2508.0
2019-07-29 03:00:00	ES	Futures	3271.47	3273.64	3270.39	3273.09	9572.0
2019-07-29 03:30:00	ES	Futures	3272.82	3275.53	3272.82	3274.99	7295.0
2019-07-29 04:00:00	ES	Futures	3275.26	3276.07	3274.18	3274.99	5383.0
2019-07-29 04:30:00	ES	Futures	3274.72	3275.26	3273.37	3274.18	5305.0
2019-07-29 05:00:00	ES	Futures	3274.18	3274.99	3273.09	3273.09	4803.0
2019-07-29 05:30:00	ES	Futures	3273.09	3273.91	3272.82	3273.64	5724.0
2019-07-29 06:00:00	ES	Futures	3273.64	3275.53	3273.64	3274.45	5870.0
2019-07-29 06:30:00	ES	Futures	3274.45	3274.45	3272.28	3272.82	4449.0
2019-07-29 07:00:00	ES	Futures	3272.82	3275.53	3272.82	3275.26	6097.0
2019-07-29 07:30:00	ES	Futures	3275.53	3277.97	3275.26	3277.16	9250.0
2019-07-29 08:00:00	ES	Futures	3277.16	3277.97	3275.53	3276.07	7972.0
2019-07-29 08:30:00	ES	Futures	3276.07	3276.61	3275.53	3276.07	5904.0
2019-07-29 09:00:00	ES	Futures	3276.34	3277.43	3275.26	3276.61	13676.0
2019-07-29 09:30:00	ES	Futures	3276.61	3276.88	3267.68	3268.22	124695.0
2019-07-29 10:00:00	ES	Futures	3268.22	3269.85	3265.24	3269.03	96587.0
2019-07-29 10:30:00	ES	Futures	3269.03	3271.47	3267.68	3269.58	54339.0
2019-07-29 11:00:00	ES	Futures	3269.85	3272.82	3268.49	3272.55	39462.0
2019-07-29 11:30:00	ES	Futures	3272.55	3274.18	3270.66	3273.37	34466.0
2019-07-29 12:00:00	ES	Futures	3273.37	3273.37	3269.03	3271.47	27230.0
2019-07-29 12:30:00	ES	Futures	3271.2	3273.64	3269.31	3273.64	22949.0
2019-07-29 13:00:00	ES	Futures	3273.37	3274.45	3272.01	3273.37	28922.0
2019-07-29 13:30:00	ES	Futures	3273.37	3274.18	3271.47	3271.47	19649.0
2019-07-29 14:00:00	ES	Futures	3271.74	3273.09	3270.12	3272.82	22343.0
2019-07-29 14:30:00	ES	Futures	3272.82	3273.37	3270.12	3272.55	24140.0
2019-07-29 15:00:00	ES	Futures	3272.28	3273.37	3270.12	3271.2	28042.0
2019-07-29 15:30:00	ES	Futures	3270.93	3274.45	3270.39	3271.74	99792.0
2019-07-29 16:00:00	ES	Futures	3271.74	3273.09	3271.2	3272.28	38844.0
2019-07-29 16:30:00	ES	Futures	3272.01	3274.18	3271.2	3273.09	4205.0
2019-07-29 18:00:00	ES	Futures	3272.55	3274.99	3272.28	3274.45	2472.0
2019-07-29 18:30:00	ES	Futures	3274.72	3275.26	3274.45	3275.26	1549.0
2019-07-29 19:00:00	ES	Futures	3275.26	3275.8	3274.72	3274.99	1094.0
2019-07-29 19:30:00	ES	Futures	3275.26	3275.8	3274.72	3274.99	1540.0
2019-07-29 20:00:00	ES	Futures	3274.99	3277.16	3274.45	3276.61	5853.0
2019-07-29 20:30:00	ES	Futures	3276.88	3276.88	3274.99	3275.26	2348.0
2019-07-29 21:00:00	ES	Futures	3275.53	3276.88	3274.45	3276.88	3498.0
2019-07-29 21:30:00	ES	Futures	3276.88	3277.43	3276.07	3276.34	3262.0
2019-07-29 22:00:00	ES	Futures	3276.34	3277.97	3276.34	3277.7	2365.0
2019-07-29 22:30:00	ES	Futures	3277.97	3278.24	3276.88	3276.88	2277.0
2019-07-29 23:00:00	ES	Futures	3276.88	3277.7	3276.34	3277.16	1711.0
2019-07-29 23:30:00	ES	Futures	3277.16	3277.43	3275.53	3275.8	2352.0
2019-07-29 00:00:00	NQ	Futures	9294.42	9298.48	9294.42	9295.58	598.0
2019-07-29 00:30:00	NQ	Futures	9295.29	9296.45	9293.55	9295.29	426.0
2019-07-29 01:00:00	NQ	Futures	9295.29	9295.87	9289.49	9292.68	867.0
2019-07-29 01:30:00	NQ	Futures	9292.39	9296.16	9288.33	9294.71	874.0

> showing 50 of 3,456 rows — these rows as CSV

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