PREVIEW / futures_30min / 2018-07-09

all futures 30-min files

  file:    by_date/futures_30min/2018/2018-07-09.parquet
  size:    81 KB
  rows:    3,125

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
2018-07-09 00:00:00	ES	Futures	3022.47	3023.01	3021.92	3022.47	1201.0
2018-07-09 00:30:00	ES	Futures	3022.2	3022.74	3021.38	3021.65	1386.0
2018-07-09 01:00:00	ES	Futures	3021.65	3021.92	3020.29	3021.38	2321.0
2018-07-09 01:30:00	ES	Futures	3021.11	3022.47	3021.11	3021.38	2173.0
2018-07-09 02:00:00	ES	Futures	3021.38	3022.47	3020.83	3021.92	3739.0
2018-07-09 02:30:00	ES	Futures	3021.65	3021.92	3020.29	3021.11	2496.0
2018-07-09 03:00:00	ES	Futures	3021.38	3022.47	3020.29	3022.2	6879.0
2018-07-09 03:30:00	ES	Futures	3022.2	3024.1	3021.92	3023.56	6124.0
2018-07-09 04:00:00	ES	Futures	3023.56	3023.83	3020.83	3022.2	6249.0
2018-07-09 04:30:00	ES	Futures	3021.92	3022.47	3019.74	3019.74	5055.0
2018-07-09 05:00:00	ES	Futures	3019.74	3022.47	3019.2	3021.92	3699.0
2018-07-09 05:30:00	ES	Futures	3021.92	3023.29	3021.11	3023.29	3380.0
2018-07-09 06:00:00	ES	Futures	3023.01	3024.1	3021.92	3023.01	3869.0
2018-07-09 06:30:00	ES	Futures	3022.74	3023.29	3022.2	3023.29	3104.0
2018-07-09 07:00:00	ES	Futures	3023.29	3024.65	3021.65	3022.2	6505.0
2018-07-09 07:30:00	ES	Futures	3022.2	3022.47	3021.11	3022.2	3704.0
2018-07-09 08:00:00	ES	Futures	3022.2	3023.01	3020.83	3022.47	7634.0
2018-07-09 08:30:00	ES	Futures	3022.47	3023.01	3020.83	3021.11	5655.0
2018-07-09 09:00:00	ES	Futures	3021.38	3023.01	3021.38	3022.74	10048.0
2018-07-09 09:30:00	ES	Futures	3022.74	3028.74	3022.2	3025.74	112295.0
2018-07-09 10:00:00	ES	Futures	3026.01	3026.83	3021.92	3024.92	82724.0
2018-07-09 10:30:00	ES	Futures	3024.92	3030.1	3024.65	3029.83	72768.0
2018-07-09 11:00:00	ES	Futures	3030.1	3032.82	3029.28	3030.37	59008.0
2018-07-09 11:30:00	ES	Futures	3030.64	3034.18	3028.74	3032.55	62033.0
2018-07-09 12:00:00	ES	Futures	3032.82	3035.82	3032.28	3033.37	57429.0
2018-07-09 12:30:00	ES	Futures	3033.64	3034.18	3030.64	3032.82	48741.0
2018-07-09 13:00:00	ES	Futures	3032.82	3034.18	3029.01	3030.92	35626.0
2018-07-09 13:30:00	ES	Futures	3031.19	3033.37	3030.92	3032.82	19551.0
2018-07-09 14:00:00	ES	Futures	3032.82	3033.64	3031.19	3033.37	18216.0
2018-07-09 14:30:00	ES	Futures	3033.37	3036.09	3032.82	3035.27	32465.0
2018-07-09 15:00:00	ES	Futures	3035.55	3036.64	3032.28	3034.46	42324.0
2018-07-09 15:30:00	ES	Futures	3034.46	3037.73	3033.37	3036.91	107679.0
2018-07-09 16:00:00	ES	Futures	3036.64	3038.27	3036.36	3038.0	56829.0
2018-07-09 16:30:00	ES	Futures	3038.0	3038.54	3037.73	3037.73	6544.0
2018-07-09 18:00:00	ES	Futures	3038.0	3038.27	3036.64	3037.73	2183.0
2018-07-09 18:30:00	ES	Futures	3037.73	3041.54	3037.45	3041.0	2641.0
2018-07-09 19:00:00	ES	Futures	3041.0	3042.36	3040.72	3041.54	1846.0
2018-07-09 19:30:00	ES	Futures	3041.54	3042.9	3040.72	3041.81	1975.0
2018-07-09 20:00:00	ES	Futures	3041.81	3043.72	3041.0	3043.45	3980.0
2018-07-09 20:30:00	ES	Futures	3043.45	3049.17	3043.45	3046.99	9947.0
2018-07-09 21:00:00	ES	Futures	3046.72	3047.26	3043.45	3044.54	5707.0
2018-07-09 21:30:00	ES	Futures	3044.54	3045.36	3042.63	3042.9	5667.0
2018-07-09 22:00:00	ES	Futures	3043.18	3045.08	3042.9	3043.45	2298.0
2018-07-09 22:30:00	ES	Futures	3043.72	3044.54	3042.63	3043.45	2694.0
2018-07-09 23:00:00	ES	Futures	3043.18	3044.81	3042.63	3044.81	1724.0
2018-07-09 23:30:00	ES	Futures	3044.54	3044.81	3043.18	3043.18	1382.0
2018-07-09 00:00:00	NQ	Futures	8552.85	8554.91	8551.08	8551.67	557.0
2018-07-09 00:30:00	NQ	Futures	8551.67	8553.73	8549.9	8550.79	728.0
2018-07-09 01:00:00	NQ	Futures	8550.49	8550.49	8543.72	8546.08	1623.0
2018-07-09 01:30:00	NQ	Futures	8546.08	8549.31	8544.6	8545.78	818.0

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

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