PREVIEW / futures_30min / 2019-07-04

all futures 30-min files

  file:    by_date/futures_30min/2019/2019-07-04.parquet
  size:    59 KB
  rows:    2,461

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-04 00:00:00	ES	Futures	3247.38	3248.19	3247.38	3247.92	1454.0
2019-07-04 00:30:00	ES	Futures	3247.65	3248.46	3247.65	3248.19	503.0
2019-07-04 01:00:00	ES	Futures	3248.46	3248.46	3247.65	3248.19	1462.0
2019-07-04 01:30:00	ES	Futures	3248.46	3248.73	3247.38	3247.92	1374.0
2019-07-04 02:00:00	ES	Futures	3247.65	3247.65	3246.3	3246.84	2696.0
2019-07-04 02:30:00	ES	Futures	3246.57	3247.65	3245.48	3246.84	2116.0
2019-07-04 03:00:00	ES	Futures	3246.57	3248.73	3246.57	3247.38	5362.0
2019-07-04 03:30:00	ES	Futures	3247.38	3247.65	3246.3	3246.84	2891.0
2019-07-04 04:00:00	ES	Futures	3246.84	3247.38	3245.75	3246.02	2719.0
2019-07-04 04:30:00	ES	Futures	3246.3	3247.65	3246.02	3247.11	2587.0
2019-07-04 05:00:00	ES	Futures	3247.11	3249.0	3246.84	3248.46	4249.0
2019-07-04 05:30:00	ES	Futures	3248.46	3248.73	3247.38	3248.46	2012.0
2019-07-04 06:00:00	ES	Futures	3248.19	3248.19	3247.11	3247.65	1837.0
2019-07-04 06:30:00	ES	Futures	3247.65	3248.73	3247.11	3248.46	1796.0
2019-07-04 07:00:00	ES	Futures	3248.46	3249.54	3248.19	3248.19	2882.0
2019-07-04 07:30:00	ES	Futures	3248.19	3249.81	3248.19	3249.54	2551.0
2019-07-04 08:00:00	ES	Futures	3249.81	3250.09	3248.73	3250.09	2848.0
2019-07-04 08:30:00	ES	Futures	3250.09	3251.98	3249.54	3250.36	4701.0
2019-07-04 09:00:00	ES	Futures	3250.36	3251.44	3250.36	3250.9	2776.0
2019-07-04 09:30:00	ES	Futures	3251.17	3251.44	3249.81	3250.9	4207.0
2019-07-04 10:00:00	ES	Futures	3251.17	3251.17	3249.81	3250.36	3468.0
2019-07-04 10:30:00	ES	Futures	3250.36	3252.52	3250.36	3252.25	6839.0
2019-07-04 11:00:00	ES	Futures	3252.25	3252.25	3250.9	3251.44	4667.0
2019-07-04 11:30:00	ES	Futures	3251.44	3251.98	3250.9	3251.44	2803.0
2019-07-04 12:00:00	ES	Futures	3251.44	3251.71	3250.63	3250.9	1340.0
2019-07-04 12:30:00	ES	Futures	3250.9	3251.71	3250.36	3250.9	2236.0
2019-07-04 18:00:00	ES	Futures	3251.44	3252.25	3250.9	3251.98	2161.0
2019-07-04 18:30:00	ES	Futures	3251.98	3251.98	3251.17	3251.17	1170.0
2019-07-04 19:00:00	ES	Futures	3251.17	3251.71	3250.9	3251.17	608.0
2019-07-04 19:30:00	ES	Futures	3251.44	3251.98	3250.9	3251.44	1049.0
2019-07-04 20:00:00	ES	Futures	3251.44	3251.71	3249.81	3249.81	3747.0
2019-07-04 20:30:00	ES	Futures	3249.81	3251.17	3249.54	3250.63	1416.0
2019-07-04 21:00:00	ES	Futures	3250.36	3251.71	3250.36	3250.9	2507.0
2019-07-04 21:30:00	ES	Futures	3251.17	3251.71	3248.73	3249.0	4461.0
2019-07-04 22:00:00	ES	Futures	3249.27	3251.44	3249.0	3251.44	2524.0
2019-07-04 22:30:00	ES	Futures	3251.44	3252.25	3251.17	3251.71	2384.0
2019-07-04 23:00:00	ES	Futures	3251.71	3252.25	3251.17	3252.25	1672.0
2019-07-04 23:30:00	ES	Futures	3252.25	3252.52	3251.17	3251.71	1692.0
2019-07-04 00:00:00	NQ	Futures	9152.25	9154.28	9151.67	9152.54	488.0
2019-07-04 00:30:00	NQ	Futures	9152.83	9155.15	9152.83	9153.99	297.0
2019-07-04 01:00:00	NQ	Futures	9153.99	9154.86	9151.96	9154.57	386.0
2019-07-04 01:30:00	NQ	Futures	9154.86	9156.32	9152.25	9153.12	463.0
2019-07-04 02:00:00	NQ	Futures	9152.83	9153.41	9149.93	9150.8	843.0
2019-07-04 02:30:00	NQ	Futures	9150.8	9155.44	9147.03	9153.12	948.0
2019-07-04 03:00:00	NQ	Futures	9152.83	9159.22	9151.09	9153.7	2887.0
2019-07-04 03:30:00	NQ	Futures	9153.7	9154.86	9149.64	9151.67	1087.0
2019-07-04 04:00:00	NQ	Futures	9151.96	9152.83	9148.48	9149.93	822.0
2019-07-04 04:30:00	NQ	Futures	9150.22	9153.99	9149.35	9151.38	734.0
2019-07-04 05:00:00	NQ	Futures	9151.38	9160.09	9151.38	9158.64	1259.0
2019-07-04 05:30:00	NQ	Futures	9158.64	9160.67	9155.15	9160.67	769.0

> showing 50 of 2,461 rows — these rows as CSV

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