PREVIEW / futures_30min / 2018-08-19

all futures 30-min files

  file:    by_date/futures_30min/2018/2018-08-19.parquet
  size:    20 KB
  rows:    553

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-08-19 18:00:00	ES	Futures	3108.02	3111.02	3107.75	3110.48	4048.0
2018-08-19 18:30:00	ES	Futures	3110.48	3111.84	3110.48	3111.57	1332.0
2018-08-19 19:00:00	ES	Futures	3111.57	3111.84	3110.48	3110.75	879.0
2018-08-19 19:30:00	ES	Futures	3111.02	3111.29	3109.11	3109.39	2820.0
2018-08-19 20:00:00	ES	Futures	3109.39	3111.57	3109.11	3110.75	3692.0
2018-08-19 20:30:00	ES	Futures	3110.48	3111.29	3109.11	3109.11	3340.0
2018-08-19 21:00:00	ES	Futures	3109.11	3109.39	3107.21	3108.3	5916.0
2018-08-19 21:30:00	ES	Futures	3108.02	3111.02	3106.39	3108.84	7481.0
2018-08-19 22:00:00	ES	Futures	3109.11	3111.29	3108.84	3111.02	3179.0
2018-08-19 22:30:00	ES	Futures	3111.02	3111.29	3107.75	3108.02	2968.0
2018-08-19 23:00:00	ES	Futures	3108.02	3109.11	3106.93	3109.11	2454.0
2018-08-19 23:30:00	ES	Futures	3108.84	3109.66	3108.3	3109.11	1452.0
2018-08-19 18:00:00	NQ	Futures	8703.59	8710.36	8700.06	8707.71	1057.0
2018-08-19 18:30:00	NQ	Futures	8708.3	8714.78	8708.3	8714.19	632.0
2018-08-19 19:00:00	NQ	Futures	8714.19	8714.48	8710.07	8711.54	544.0
2018-08-19 19:30:00	NQ	Futures	8712.13	8713.01	8707.71	8708.59	1067.0
2018-08-19 20:00:00	NQ	Futures	8708.89	8717.72	8706.83	8712.13	1140.0
2018-08-19 20:30:00	NQ	Futures	8712.13	8713.6	8707.12	8707.71	840.0
2018-08-19 21:00:00	NQ	Futures	8708.01	8708.3	8701.82	8706.83	1428.0
2018-08-19 21:30:00	NQ	Futures	8707.12	8716.25	8698.29	8708.59	1871.0
2018-08-19 22:00:00	NQ	Futures	8708.59	8718.9	8708.59	8716.84	882.0
2018-08-19 22:30:00	NQ	Futures	8716.54	8718.31	8707.12	8708.3	900.0
2018-08-19 23:00:00	NQ	Futures	8708.3	8712.13	8704.47	8711.54	584.0
2018-08-19 23:30:00	NQ	Futures	8711.24	8713.6	8709.48	8712.72	369.0
2018-08-19 18:00:00	YM	Futures	27942.7	27944.9	27917.7	27940.6	645.0
2018-08-19 18:30:00	YM	Futures	27939.5	27950.4	27933.0	27949.3	314.0
2018-08-19 19:00:00	YM	Futures	27949.3	27950.4	27936.2	27937.3	269.0
2018-08-19 19:30:00	YM	Futures	27938.4	27941.7	27924.3	27926.4	521.0
2018-08-19 20:00:00	YM	Futures	27926.4	27947.1	27921.0	27938.4	1016.0
2018-08-19 20:30:00	YM	Futures	27937.3	27942.7	27921.0	27922.1	635.0
2018-08-19 21:00:00	YM	Futures	27922.1	27922.1	27903.6	27916.6	941.0
2018-08-19 21:30:00	YM	Futures	27917.7	27947.1	27899.3	27919.9	1570.0
2018-08-19 22:00:00	YM	Futures	27921.0	27944.9	27919.9	27939.5	720.0
2018-08-19 22:30:00	YM	Futures	27941.7	27944.9	27915.6	27916.6	719.0
2018-08-19 23:00:00	YM	Futures	27916.6	27929.7	27908.0	27929.7	617.0
2018-08-19 23:30:00	YM	Futures	27928.6	27935.1	27923.2	27931.9	344.0
2018-08-19 18:00:00	CL	Futures	59.87	59.9	59.8	59.83	1105.0
2018-08-19 18:30:00	CL	Futures	59.83	59.87	59.79	59.83	676.0
2018-08-19 19:00:00	CL	Futures	59.83	59.83	59.74	59.76	798.0
2018-08-19 19:30:00	CL	Futures	59.75	59.77	59.73	59.75	647.0
2018-08-19 20:00:00	CL	Futures	59.75	59.84	59.73	59.81	1435.0
2018-08-19 20:30:00	CL	Futures	59.81	59.86	59.79	59.84	1530.0
2018-08-19 21:00:00	CL	Futures	59.84	59.85	59.73	59.77	3073.0
2018-08-19 21:30:00	CL	Futures	59.76	59.8	59.67	59.74	3519.0
2018-08-19 22:00:00	CL	Futures	59.74	59.77	59.72	59.75	1678.0
2018-08-19 22:30:00	CL	Futures	59.75	59.78	59.65	59.67	2446.0
2018-08-19 23:00:00	CL	Futures	59.67	59.7	59.54	59.58	3346.0
2018-08-19 23:30:00	CL	Futures	59.59	59.65	59.58	59.62	1700.0
2018-08-19 18:00:00	GC	Futures	1550.9	1551.6	1549.9	1550.0	1786.0
2018-08-19 18:30:00	GC	Futures	1550.0	1551.0	1549.9	1550.5	664.0

> showing 50 of 553 rows — these rows as CSV

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