PREVIEW / futures_30min / 2019-07-09

all futures 30-min files

  file:    by_date/futures_30min/2019/2019-07-09.parquet
  size:    89 KB
  rows:    3,471

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-09 00:00:00	ES	Futures	3212.19	3212.46	3211.37	3212.19	2558.0
2019-07-09 00:30:00	ES	Futures	3212.19	3214.08	3211.92	3213.81	2625.0
2019-07-09 01:00:00	ES	Futures	3213.81	3215.16	3213.54	3213.81	2239.0
2019-07-09 01:30:00	ES	Futures	3213.81	3215.43	3213.54	3214.89	2618.0
2019-07-09 02:00:00	ES	Futures	3215.16	3216.79	3214.08	3214.08	6328.0
2019-07-09 02:30:00	ES	Futures	3214.08	3214.35	3212.46	3213.54	4783.0
2019-07-09 03:00:00	ES	Futures	3213.27	3215.43	3211.37	3213.81	13938.0
2019-07-09 03:30:00	ES	Futures	3213.81	3214.08	3209.21	3209.75	13054.0
2019-07-09 04:00:00	ES	Futures	3209.75	3211.64	3208.94	3211.1	13090.0
2019-07-09 04:30:00	ES	Futures	3210.83	3211.92	3208.94	3211.1	8894.0
2019-07-09 05:00:00	ES	Futures	3211.1	3212.19	3209.21	3210.29	9894.0
2019-07-09 05:30:00	ES	Futures	3210.02	3211.37	3208.94	3210.29	8695.0
2019-07-09 06:00:00	ES	Futures	3210.29	3213.0	3209.75	3212.73	8844.0
2019-07-09 06:30:00	ES	Futures	3212.73	3214.62	3212.46	3213.27	10658.0
2019-07-09 07:00:00	ES	Futures	3213.27	3214.89	3212.46	3214.89	9261.0
2019-07-09 07:30:00	ES	Futures	3214.89	3215.16	3213.0	3213.54	7654.0
2019-07-09 08:00:00	ES	Futures	3213.81	3215.43	3213.0	3214.35	11606.0
2019-07-09 08:30:00	ES	Futures	3214.35	3215.16	3212.19	3214.35	12477.0
2019-07-09 09:00:00	ES	Futures	3214.08	3214.62	3211.37	3211.92	16003.0
2019-07-09 09:30:00	ES	Futures	3211.92	3219.22	3211.37	3217.6	127859.0
2019-07-09 10:00:00	ES	Futures	3217.6	3221.39	3217.6	3220.85	79643.0
2019-07-09 10:30:00	ES	Futures	3220.58	3224.91	3220.31	3221.93	60747.0
2019-07-09 11:00:00	ES	Futures	3221.93	3226.26	3221.39	3223.29	54584.0
2019-07-09 11:30:00	ES	Futures	3223.56	3225.18	3221.93	3224.1	35167.0
2019-07-09 12:00:00	ES	Futures	3224.1	3225.99	3223.56	3225.18	32771.0
2019-07-09 12:30:00	ES	Futures	3225.45	3226.53	3224.37	3224.64	22797.0
2019-07-09 13:00:00	ES	Futures	3224.37	3225.45	3223.29	3225.18	22251.0
2019-07-09 13:30:00	ES	Futures	3224.91	3225.99	3224.64	3225.45	16268.0
2019-07-09 14:00:00	ES	Futures	3225.45	3227.62	3224.37	3226.53	26352.0
2019-07-09 14:30:00	ES	Futures	3226.53	3226.8	3225.18	3226.26	22424.0
2019-07-09 15:00:00	ES	Futures	3226.26	3227.08	3222.74	3224.1	33207.0
2019-07-09 15:30:00	ES	Futures	3224.37	3233.57	3223.83	3230.59	133076.0
2019-07-09 16:00:00	ES	Futures	3230.59	3230.86	3228.7	3229.24	37441.0
2019-07-09 16:30:00	ES	Futures	3228.97	3230.59	3228.7	3229.24	5016.0
2019-07-09 18:00:00	ES	Futures	3229.24	3230.05	3227.89	3229.24	1932.0
2019-07-09 18:30:00	ES	Futures	3229.51	3229.51	3227.89	3228.97	1072.0
2019-07-09 19:00:00	ES	Futures	3228.7	3228.97	3227.89	3228.43	703.0
2019-07-09 19:30:00	ES	Futures	3228.43	3229.51	3227.08	3228.97	3261.0
2019-07-09 20:00:00	ES	Futures	3228.97	3233.03	3228.43	3231.95	6181.0
2019-07-09 20:30:00	ES	Futures	3231.95	3234.93	3231.14	3233.57	5875.0
2019-07-09 21:00:00	ES	Futures	3233.84	3234.38	3232.22	3233.03	3858.0
2019-07-09 21:30:00	ES	Futures	3233.03	3233.3	3230.05	3230.05	3931.0
2019-07-09 22:00:00	ES	Futures	3230.05	3231.14	3228.7	3230.05	2963.0
2019-07-09 22:30:00	ES	Futures	3229.78	3230.86	3229.24	3230.59	1894.0
2019-07-09 23:00:00	ES	Futures	3230.32	3230.59	3229.78	3230.32	1735.0
2019-07-09 23:30:00	ES	Futures	3230.32	3230.86	3228.97	3228.97	1764.0
2019-07-09 00:00:00	NQ	Futures	9001.96	9005.15	8999.35	9004.28	1014.0
2019-07-09 00:30:00	NQ	Futures	9004.57	9009.5	9003.12	9008.34	838.0
2019-07-09 01:00:00	NQ	Futures	9008.63	9012.69	9007.18	9008.63	1168.0
2019-07-09 01:30:00	NQ	Futures	9008.63	9015.89	9007.18	9015.02	1124.0

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

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