PREVIEW / futures_30min / 2019-07-14

all futures 30-min files

  file:    by_date/futures_30min/2019/2019-07-14.parquet
  size:    25 KB
  rows:    673

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-14 18:00:00	ES	Futures	3264.97	3266.6	3263.89	3264.7	3245.0
2019-07-14 18:30:00	ES	Futures	3264.97	3265.24	3264.43	3264.97	783.0
2019-07-14 19:00:00	ES	Futures	3264.97	3265.79	3264.7	3264.7	768.0
2019-07-14 19:30:00	ES	Futures	3264.7	3264.97	3262.27	3262.81	2257.0
2019-07-14 20:00:00	ES	Futures	3262.81	3263.89	3262.27	3263.35	2039.0
2019-07-14 20:30:00	ES	Futures	3263.35	3264.43	3263.08	3263.89	1192.0
2019-07-14 21:00:00	ES	Futures	3263.62	3264.16	3261.18	3262.0	3031.0
2019-07-14 21:30:00	ES	Futures	3262.0	3263.89	3260.1	3262.54	5083.0
2019-07-14 22:00:00	ES	Futures	3262.81	3267.68	3262.81	3267.14	5830.0
2019-07-14 22:30:00	ES	Futures	3267.14	3268.76	3266.06	3268.22	4539.0
2019-07-14 23:00:00	ES	Futures	3267.95	3269.31	3267.68	3268.76	3075.0
2019-07-14 23:30:00	ES	Futures	3268.76	3269.31	3267.95	3267.95	1409.0
2019-07-14 18:00:00	NQ	Futures	9236.1	9245.97	9233.2	9237.55	1416.0
2019-07-14 18:30:00	NQ	Futures	9237.85	9239.59	9235.81	9236.68	474.0
2019-07-14 19:00:00	NQ	Futures	9236.68	9239.59	9234.07	9234.07	627.0
2019-07-14 19:30:00	NQ	Futures	9234.65	9235.52	9226.82	9228.56	899.0
2019-07-14 20:00:00	NQ	Futures	9228.56	9231.46	9225.66	9229.43	1110.0
2019-07-14 20:30:00	NQ	Futures	9229.43	9232.91	9228.27	9229.14	843.0
2019-07-14 21:00:00	NQ	Futures	9229.14	9231.17	9218.7	9221.89	1684.0
2019-07-14 21:30:00	NQ	Futures	9221.89	9229.14	9216.37	9225.08	3177.0
2019-07-14 22:00:00	NQ	Futures	9225.08	9240.75	9225.08	9239.01	2827.0
2019-07-14 22:30:00	NQ	Futures	9239.59	9243.94	9236.1	9241.91	2105.0
2019-07-14 23:00:00	NQ	Futures	9242.49	9248.0	9240.75	9244.23	1760.0
2019-07-14 23:30:00	NQ	Futures	9244.23	9246.55	9241.62	9242.78	702.0
2019-07-14 18:00:00	YM	Futures	29692.0	29704.0	29688.8	29695.3	1361.0
2019-07-14 18:30:00	YM	Futures	29696.4	29700.7	29694.2	29700.7	270.0
2019-07-14 19:00:00	YM	Futures	29699.6	29705.1	29697.5	29699.6	267.0
2019-07-14 19:30:00	YM	Futures	29700.7	29701.8	29673.5	29680.1	835.0
2019-07-14 20:00:00	YM	Futures	29679.0	29686.6	29670.3	29684.4	757.0
2019-07-14 20:30:00	YM	Futures	29684.4	29690.9	29680.1	29682.2	536.0
2019-07-14 21:00:00	YM	Futures	29682.2	29683.3	29657.2	29664.8	883.0
2019-07-14 21:30:00	YM	Futures	29665.9	29683.3	29648.5	29671.4	1767.0
2019-07-14 22:00:00	YM	Futures	29671.4	29714.9	29671.4	29712.7	1633.0
2019-07-14 22:30:00	YM	Futures	29712.7	29737.7	29699.6	29730.1	1758.0
2019-07-14 23:00:00	YM	Futures	29730.1	29742.0	29726.8	29736.6	759.0
2019-07-14 23:30:00	YM	Futures	29736.6	29741.0	29730.1	29730.1	464.0
2019-07-14 18:00:00	CL	Futures	53.59	53.62	53.47	53.59	488.0
2019-07-14 18:30:00	CL	Futures	53.58	53.62	53.54	53.56	102.0
2019-07-14 19:00:00	CL	Futures	53.56	53.6	53.51	53.54	156.0
2019-07-14 19:30:00	CL	Futures	53.54	53.54	53.44	53.46	495.0
2019-07-14 20:00:00	CL	Futures	53.48	53.52	53.46	53.49	145.0
2019-07-14 20:30:00	CL	Futures	53.52	53.52	53.49	53.52	191.0
2019-07-14 21:00:00	CL	Futures	53.51	53.52	53.23	53.36	1092.0
2019-07-14 21:30:00	CL	Futures	53.37	53.41	53.3	53.3	795.0
2019-07-14 22:00:00	CL	Futures	53.31	53.35	53.25	53.28	462.0
2019-07-14 22:30:00	CL	Futures	53.29	53.33	53.21	53.33	359.0
2019-07-14 23:00:00	CL	Futures	53.34	53.37	53.3	53.37	238.0
2019-07-14 23:30:00	CL	Futures	53.37	53.42	53.36	53.41	238.0
2019-07-14 18:00:00	GC	Futures	1812.4	1817.4	1810.9	1816.0	4332.0
2019-07-14 18:30:00	GC	Futures	1816.0	1817.0	1813.5	1814.6	1319.0

> showing 50 of 673 rows — these rows as CSV

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