PREVIEW / futures_30min / 2019-07-18

all futures 30-min files

  file:    by_date/futures_30min/2019/2019-07-18.parquet
  size:    98 KB
  rows:    3,515

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-18 00:00:00	ES	Futures	3225.18	3225.45	3223.01	3224.91	3705.0
2019-07-18 00:30:00	ES	Futures	3224.91	3226.26	3224.64	3225.72	2141.0
2019-07-18 01:00:00	ES	Futures	3225.99	3226.26	3223.29	3223.83	3511.0
2019-07-18 01:30:00	ES	Futures	3224.1	3224.37	3221.93	3223.01	6552.0
2019-07-18 02:00:00	ES	Futures	3223.01	3226.8	3223.01	3225.72	6483.0
2019-07-18 02:30:00	ES	Futures	3225.72	3225.99	3223.83	3224.37	5973.0
2019-07-18 03:00:00	ES	Futures	3224.37	3225.18	3223.01	3224.37	14010.0
2019-07-18 03:30:00	ES	Futures	3224.37	3227.89	3224.1	3226.8	12503.0
2019-07-18 04:00:00	ES	Futures	3226.8	3227.08	3223.29	3224.37	10201.0
2019-07-18 04:30:00	ES	Futures	3224.37	3225.18	3223.56	3225.18	6437.0
2019-07-18 05:00:00	ES	Futures	3224.91	3229.24	3224.37	3228.7	10940.0
2019-07-18 05:30:00	ES	Futures	3228.97	3229.24	3227.08	3227.35	6736.0
2019-07-18 06:00:00	ES	Futures	3227.62	3229.24	3226.8	3227.62	7524.0
2019-07-18 06:30:00	ES	Futures	3227.62	3231.14	3227.08	3231.14	17182.0
2019-07-18 07:00:00	ES	Futures	3230.86	3233.03	3230.05	3230.59	14649.0
2019-07-18 07:30:00	ES	Futures	3230.59	3231.95	3228.97	3229.78	11109.0
2019-07-18 08:00:00	ES	Futures	3229.78	3231.68	3229.51	3231.14	8173.0
2019-07-18 08:30:00	ES	Futures	3231.41	3234.38	3230.32	3230.32	18665.0
2019-07-18 09:00:00	ES	Futures	3230.32	3230.59	3227.08	3227.62	20235.0
2019-07-18 09:30:00	ES	Futures	3227.62	3233.3	3225.99	3231.41	135682.0
2019-07-18 10:00:00	ES	Futures	3231.41	3237.09	3228.97	3235.74	111143.0
2019-07-18 10:30:00	ES	Futures	3235.47	3237.63	3232.76	3234.93	68960.0
2019-07-18 11:00:00	ES	Futures	3234.93	3235.74	3226.8	3228.16	75427.0
2019-07-18 11:30:00	ES	Futures	3227.89	3228.43	3222.2	3223.83	74628.0
2019-07-18 12:00:00	ES	Futures	3223.56	3231.14	3223.29	3230.05	61409.0
2019-07-18 12:30:00	ES	Futures	3230.32	3232.76	3229.51	3230.05	34934.0
2019-07-18 13:00:00	ES	Futures	3230.32	3234.11	3229.78	3232.22	30102.0
2019-07-18 13:30:00	ES	Futures	3232.22	3234.11	3230.32	3232.76	30218.0
2019-07-18 14:00:00	ES	Futures	3232.76	3243.32	3232.22	3241.69	87541.0
2019-07-18 14:30:00	ES	Futures	3241.69	3246.57	3241.15	3246.57	66188.0
2019-07-18 15:00:00	ES	Futures	3246.57	3250.09	3240.34	3243.59	92162.0
2019-07-18 15:30:00	ES	Futures	3243.86	3246.3	3240.88	3245.75	113590.0
2019-07-18 16:00:00	ES	Futures	3245.48	3247.92	3243.59	3246.02	57814.0
2019-07-18 16:30:00	ES	Futures	3246.57	3254.15	3246.57	3252.25	15390.0
2019-07-18 18:00:00	ES	Futures	3252.52	3258.75	3244.4	3245.75	19844.0
2019-07-18 18:30:00	ES	Futures	3246.02	3249.81	3244.94	3245.21	6929.0
2019-07-18 19:00:00	ES	Futures	3244.94	3249.27	3244.4	3247.65	3550.0
2019-07-18 19:30:00	ES	Futures	3247.65	3251.17	3247.38	3249.0	4215.0
2019-07-18 20:00:00	ES	Futures	3249.0	3253.33	3248.73	3252.79	8936.0
2019-07-18 20:30:00	ES	Futures	3252.79	3255.23	3252.52	3254.69	7117.0
2019-07-18 21:00:00	ES	Futures	3254.96	3256.58	3253.87	3256.04	6462.0
2019-07-18 21:30:00	ES	Futures	3255.77	3257.39	3255.5	3256.85	7088.0
2019-07-18 22:00:00	ES	Futures	3256.85	3257.94	3256.04	3256.31	5105.0
2019-07-18 22:30:00	ES	Futures	3256.31	3257.39	3255.77	3257.12	3924.0
2019-07-18 23:00:00	ES	Futures	3256.85	3257.66	3256.31	3257.12	2801.0
2019-07-18 23:30:00	ES	Futures	3257.12	3257.39	3255.23	3255.5	2739.0
2019-07-18 00:00:00	NQ	Futures	9113.66	9114.24	9105.83	9109.6	1313.0
2019-07-18 00:30:00	NQ	Futures	9109.89	9112.79	9109.31	9111.34	639.0
2019-07-18 01:00:00	NQ	Futures	9111.34	9111.63	9099.45	9100.61	1856.0
2019-07-18 01:30:00	NQ	Futures	9100.32	9102.35	9090.74	9098.29	3006.0

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

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