PREVIEW / futures_30min / 2019-07-24

all futures 30-min files

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

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-24 00:00:00	ES	Futures	3256.58	3257.12	3255.77	3255.77	1928.0
2019-07-24 00:30:00	ES	Futures	3255.77	3256.04	3255.23	3255.5	1426.0
2019-07-24 01:00:00	ES	Futures	3255.5	3255.77	3253.6	3254.69	3023.0
2019-07-24 01:30:00	ES	Futures	3254.69	3254.96	3254.15	3254.96	2771.0
2019-07-24 02:00:00	ES	Futures	3254.96	3254.96	3253.33	3254.15	3108.0
2019-07-24 02:30:00	ES	Futures	3254.42	3255.5	3253.06	3253.6	4190.0
2019-07-24 03:00:00	ES	Futures	3253.87	3254.15	3250.63	3250.9	8960.0
2019-07-24 03:30:00	ES	Futures	3250.9	3250.9	3246.84	3249.54	18226.0
2019-07-24 04:00:00	ES	Futures	3249.54	3250.9	3247.11	3248.73	10161.0
2019-07-24 04:30:00	ES	Futures	3248.46	3248.73	3244.67	3245.75	10581.0
2019-07-24 05:00:00	ES	Futures	3245.75	3247.92	3245.21	3246.57	7961.0
2019-07-24 05:30:00	ES	Futures	3246.84	3246.84	3244.13	3245.75	8656.0
2019-07-24 06:00:00	ES	Futures	3246.02	3247.65	3245.21	3247.65	6692.0
2019-07-24 06:30:00	ES	Futures	3247.38	3250.09	3246.84	3250.09	11154.0
2019-07-24 07:00:00	ES	Futures	3249.81	3250.36	3248.19	3249.54	9580.0
2019-07-24 07:30:00	ES	Futures	3249.54	3249.54	3247.92	3249.0	17723.0
2019-07-24 08:00:00	ES	Futures	3248.73	3250.9	3247.11	3249.27	13630.0
2019-07-24 08:30:00	ES	Futures	3249.54	3251.17	3246.84	3247.65	11479.0
2019-07-24 09:00:00	ES	Futures	3247.92	3249.27	3247.65	3247.92	11515.0
2019-07-24 09:30:00	ES	Futures	3247.92	3260.64	3247.11	3256.31	127024.0
2019-07-24 10:00:00	ES	Futures	3256.04	3259.02	3255.5	3257.39	67381.0
2019-07-24 10:30:00	ES	Futures	3257.66	3262.27	3257.12	3258.48	79073.0
2019-07-24 11:00:00	ES	Futures	3258.48	3258.75	3253.6	3255.5	55617.0
2019-07-24 11:30:00	ES	Futures	3255.5	3257.94	3254.69	3255.23	43037.0
2019-07-24 12:00:00	ES	Futures	3255.5	3259.29	3255.23	3257.66	40966.0
2019-07-24 12:30:00	ES	Futures	3257.39	3262.27	3257.39	3261.73	37728.0
2019-07-24 13:00:00	ES	Futures	3261.73	3262.27	3260.37	3260.91	29582.0
2019-07-24 13:30:00	ES	Futures	3261.18	3262.0	3259.29	3261.45	27167.0
2019-07-24 14:00:00	ES	Futures	3261.45	3264.97	3260.91	3264.16	44193.0
2019-07-24 14:30:00	ES	Futures	3264.43	3267.14	3263.62	3266.87	47313.0
2019-07-24 15:00:00	ES	Futures	3266.87	3269.58	3265.52	3269.58	49859.0
2019-07-24 15:30:00	ES	Futures	3269.58	3272.28	3268.49	3271.74	109397.0
2019-07-24 16:00:00	ES	Futures	3272.01	3272.28	3268.49	3271.74	52149.0
2019-07-24 16:30:00	ES	Futures	3268.22	3270.39	3267.14	3267.68	10947.0
2019-07-24 18:00:00	ES	Futures	3267.95	3270.66	3267.68	3270.66	3430.0
2019-07-24 18:30:00	ES	Futures	3270.66	3270.66	3269.03	3269.31	1404.0
2019-07-24 19:00:00	ES	Futures	3269.03	3269.85	3269.03	3269.58	871.0
2019-07-24 19:30:00	ES	Futures	3269.85	3271.74	3269.58	3271.2	1594.0
2019-07-24 20:00:00	ES	Futures	3271.2	3271.74	3269.03	3270.12	4498.0
2019-07-24 20:30:00	ES	Futures	3270.39	3271.47	3270.12	3270.93	2946.0
2019-07-24 21:00:00	ES	Futures	3270.93	3271.47	3269.58	3270.66	2740.0
2019-07-24 21:30:00	ES	Futures	3270.66	3271.74	3269.31	3269.58	3771.0
2019-07-24 22:00:00	ES	Futures	3269.85	3270.93	3269.31	3270.93	2144.0
2019-07-24 22:30:00	ES	Futures	3270.93	3272.55	3270.66	3272.28	2443.0
2019-07-24 23:00:00	ES	Futures	3272.01	3272.82	3271.2	3272.01	2678.0
2019-07-24 23:30:00	ES	Futures	3272.01	3273.09	3271.74	3272.55	1662.0
2019-07-24 00:00:00	NQ	Futures	9247.71	9251.48	9245.39	9246.55	997.0
2019-07-24 00:30:00	NQ	Futures	9246.26	9246.84	9243.94	9244.52	633.0
2019-07-24 01:00:00	NQ	Futures	9244.23	9245.1	9235.23	9237.55	2004.0
2019-07-24 01:30:00	NQ	Futures	9237.55	9241.62	9236.39	9239.3	1156.0

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

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