PREVIEW / futures_30min / 2019-07-08

all futures 30-min files

  file:    by_date/futures_30min/2019/2019-07-08.parquet
  size:    91 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-08 00:00:00	ES	Futures	3231.68	3232.22	3231.14	3231.14	2376.0
2019-07-08 00:30:00	ES	Futures	3231.14	3231.68	3229.78	3230.59	3491.0
2019-07-08 01:00:00	ES	Futures	3230.59	3230.59	3228.43	3228.97	3946.0
2019-07-08 01:30:00	ES	Futures	3228.97	3229.24	3225.45	3227.08	6869.0
2019-07-08 02:00:00	ES	Futures	3227.08	3230.86	3226.8	3230.59	8432.0
2019-07-08 02:30:00	ES	Futures	3230.86	3231.14	3229.24	3229.51	5091.0
2019-07-08 03:00:00	ES	Futures	3229.51	3234.93	3229.24	3233.84	14339.0
2019-07-08 03:30:00	ES	Futures	3233.57	3234.93	3232.49	3233.57	7726.0
2019-07-08 04:00:00	ES	Futures	3233.84	3236.28	3233.84	3234.93	7537.0
2019-07-08 04:30:00	ES	Futures	3234.93	3235.2	3233.03	3233.57	6587.0
2019-07-08 05:00:00	ES	Futures	3233.57	3233.84	3229.51	3230.32	9953.0
2019-07-08 05:30:00	ES	Futures	3230.05	3232.76	3229.51	3232.22	6427.0
2019-07-08 06:00:00	ES	Futures	3232.22	3233.03	3231.41	3231.68	4588.0
2019-07-08 06:30:00	ES	Futures	3231.95	3231.95	3229.24	3229.78	5591.0
2019-07-08 07:00:00	ES	Futures	3230.05	3233.57	3229.51	3232.76	7651.0
2019-07-08 07:30:00	ES	Futures	3233.03	3233.3	3230.05	3230.05	4999.0
2019-07-08 08:00:00	ES	Futures	3230.05	3231.95	3229.78	3230.59	8320.0
2019-07-08 08:30:00	ES	Futures	3230.59	3231.41	3228.97	3229.24	10218.0
2019-07-08 09:00:00	ES	Futures	3228.97	3229.78	3227.89	3228.43	14252.0
2019-07-08 09:30:00	ES	Futures	3228.43	3228.7	3221.93	3223.29	134069.0
2019-07-08 10:00:00	ES	Futures	3223.29	3231.95	3223.29	3225.99	87984.0
2019-07-08 10:30:00	ES	Futures	3225.99	3227.89	3222.47	3224.64	73298.0
2019-07-08 11:00:00	ES	Futures	3224.91	3228.7	3224.64	3225.72	48904.0
2019-07-08 11:30:00	ES	Futures	3225.72	3226.26	3222.74	3224.37	41754.0
2019-07-08 12:00:00	ES	Futures	3224.37	3224.91	3220.85	3221.39	33463.0
2019-07-08 12:30:00	ES	Futures	3221.66	3224.37	3221.39	3223.56	32452.0
2019-07-08 13:00:00	ES	Futures	3223.56	3225.45	3223.56	3224.1	23307.0
2019-07-08 13:30:00	ES	Futures	3224.1	3226.26	3222.2	3223.83	29210.0
2019-07-08 14:00:00	ES	Futures	3223.83	3224.1	3219.5	3222.47	38588.0
2019-07-08 14:30:00	ES	Futures	3222.74	3225.72	3222.2	3223.56	36453.0
2019-07-08 15:00:00	ES	Futures	3223.29	3227.89	3222.47	3226.26	49547.0
2019-07-08 15:30:00	ES	Futures	3226.26	3229.24	3225.45	3226.53	107005.0
2019-07-08 16:00:00	ES	Futures	3226.53	3228.16	3224.91	3224.91	42784.0
2019-07-08 16:30:00	ES	Futures	3225.18	3225.45	3223.29	3225.18	5766.0
2019-07-08 18:00:00	ES	Futures	3224.37	3225.18	3223.01	3224.91	2350.0
2019-07-08 18:30:00	ES	Futures	3225.18	3226.26	3224.91	3225.45	1043.0
2019-07-08 19:00:00	ES	Futures	3225.45	3225.99	3224.1	3224.64	861.0
2019-07-08 19:30:00	ES	Futures	3224.37	3224.37	3221.12	3222.2	3771.0
2019-07-08 20:00:00	ES	Futures	3222.2	3223.83	3221.66	3223.01	3579.0
2019-07-08 20:30:00	ES	Futures	3222.74	3225.18	3221.93	3221.93	4540.0
2019-07-08 21:00:00	ES	Futures	3222.2	3223.01	3220.04	3220.31	4997.0
2019-07-08 21:30:00	ES	Futures	3220.31	3222.2	3218.68	3221.39	7962.0
2019-07-08 22:00:00	ES	Futures	3221.39	3221.66	3220.04	3220.31	3755.0
2019-07-08 22:30:00	ES	Futures	3220.04	3221.12	3217.6	3217.87	4483.0
2019-07-08 23:00:00	ES	Futures	3217.87	3218.14	3210.56	3211.64	13568.0
2019-07-08 23:30:00	ES	Futures	3211.64	3213.0	3210.56	3212.19	6712.0
2019-07-08 00:00:00	NQ	Futures	9086.39	9088.71	9084.65	9084.94	926.0
2019-07-08 00:30:00	NQ	Futures	9085.23	9087.26	9082.33	9085.23	1608.0
2019-07-08 01:00:00	NQ	Futures	9084.94	9085.23	9076.24	9078.56	1608.0
2019-07-08 01:30:00	NQ	Futures	9078.56	9078.56	9062.02	9068.4	2804.0

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

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