PREVIEW / futures_30min / 2019-07-31

all futures 30-min files

  file:    by_date/futures_30min/2019/2019-07-31.parquet
  size:    96 KB
  rows:    3,480

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-31 00:00:00	ES	Futures	3268.76	3269.85	3268.49	3269.31	2114.0
2019-07-31 00:30:00	ES	Futures	3269.31	3269.85	3269.03	3269.31	1470.0
2019-07-31 01:00:00	ES	Futures	3269.58	3270.39	3268.22	3268.76	3022.0
2019-07-31 01:30:00	ES	Futures	3268.76	3269.58	3267.95	3269.03	3293.0
2019-07-31 02:00:00	ES	Futures	3268.76	3270.93	3264.7	3265.24	11571.0
2019-07-31 02:30:00	ES	Futures	3265.24	3267.14	3264.16	3264.16	11876.0
2019-07-31 03:00:00	ES	Futures	3264.16	3267.95	3263.62	3266.87	16652.0
2019-07-31 03:30:00	ES	Futures	3266.87	3268.49	3266.33	3266.6	6195.0
2019-07-31 04:00:00	ES	Futures	3266.87	3270.66	3266.6	3269.58	11238.0
2019-07-31 04:30:00	ES	Futures	3269.58	3269.85	3266.6	3267.68	8492.0
2019-07-31 05:00:00	ES	Futures	3267.95	3269.58	3267.68	3268.76	6819.0
2019-07-31 05:30:00	ES	Futures	3268.76	3269.58	3267.14	3268.76	7599.0
2019-07-31 06:00:00	ES	Futures	3269.03	3269.31	3266.06	3266.87	7772.0
2019-07-31 06:30:00	ES	Futures	3266.87	3266.87	3264.97	3266.33	6489.0
2019-07-31 07:00:00	ES	Futures	3266.6	3268.76	3266.06	3267.95	7306.0
2019-07-31 07:30:00	ES	Futures	3267.95	3269.31	3266.87	3267.95	7879.0
2019-07-31 08:00:00	ES	Futures	3268.22	3269.03	3267.14	3267.68	8658.0
2019-07-31 08:30:00	ES	Futures	3267.68	3269.58	3267.41	3267.95	11311.0
2019-07-31 09:00:00	ES	Futures	3267.95	3268.22	3265.24	3266.06	15148.0
2019-07-31 09:30:00	ES	Futures	3266.06	3266.87	3263.35	3265.24	104757.0
2019-07-31 10:00:00	ES	Futures	3264.97	3265.79	3261.18	3261.45	62907.0
2019-07-31 10:30:00	ES	Futures	3261.45	3262.81	3258.48	3262.54	54202.0
2019-07-31 11:00:00	ES	Futures	3262.54	3267.14	3262.0	3265.24	54994.0
2019-07-31 11:30:00	ES	Futures	3265.24	3268.49	3263.89	3267.95	46823.0
2019-07-31 12:00:00	ES	Futures	3268.22	3268.49	3265.52	3266.06	29094.0
2019-07-31 12:30:00	ES	Futures	3265.79	3266.33	3264.16	3265.79	25850.0
2019-07-31 13:00:00	ES	Futures	3265.52	3267.14	3264.97	3265.52	24720.0
2019-07-31 13:30:00	ES	Futures	3265.24	3266.6	3261.73	3265.79	39428.0
2019-07-31 14:00:00	ES	Futures	3265.79	3265.79	3253.06	3257.94	167855.0
2019-07-31 14:30:00	ES	Futures	3257.66	3262.27	3202.98	3228.97	380806.0
2019-07-31 15:00:00	ES	Futures	3228.97	3247.11	3223.01	3243.86	273290.0
2019-07-31 15:30:00	ES	Futures	3243.86	3243.86	3225.99	3226.26	282597.0
2019-07-31 16:00:00	ES	Futures	3226.26	3229.24	3223.56	3225.45	118912.0
2019-07-31 16:30:00	ES	Futures	3224.1	3225.72	3218.95	3219.77	17247.0
2019-07-31 18:00:00	ES	Futures	3216.25	3218.41	3211.92	3218.41	15386.0
2019-07-31 18:30:00	ES	Futures	3218.41	3220.31	3216.25	3219.5	4521.0
2019-07-31 19:00:00	ES	Futures	3219.77	3223.01	3218.95	3221.93	4850.0
2019-07-31 19:30:00	ES	Futures	3222.2	3223.01	3218.68	3219.5	6408.0
2019-07-31 20:00:00	ES	Futures	3219.5	3222.74	3217.06	3219.77	15703.0
2019-07-31 20:30:00	ES	Futures	3219.77	3222.74	3218.95	3222.2	6460.0
2019-07-31 21:00:00	ES	Futures	3222.47	3226.8	3221.39	3226.53	8942.0
2019-07-31 21:30:00	ES	Futures	3226.8	3231.68	3225.72	3230.86	15079.0
2019-07-31 22:00:00	ES	Futures	3230.86	3231.68	3227.89	3228.7	7399.0
2019-07-31 22:30:00	ES	Futures	3228.7	3229.51	3227.35	3228.16	4937.0
2019-07-31 23:00:00	ES	Futures	3228.16	3231.41	3227.08	3231.41	5076.0
2019-07-31 23:30:00	ES	Futures	3231.41	3232.22	3230.59	3232.22	3694.0
2019-07-31 00:00:00	NQ	Futures	9277.59	9281.37	9275.85	9279.63	844.0
2019-07-31 00:30:00	NQ	Futures	9279.63	9279.63	9277.01	9278.47	626.0
2019-07-31 01:00:00	NQ	Futures	9278.47	9282.24	9273.53	9274.11	1498.0
2019-07-31 01:30:00	NQ	Futures	9274.4	9281.08	9273.24	9278.76	1307.0

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

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