PREVIEW / futures_30min / 2018-08-27

all futures 30-min files

  file:    by_date/futures_30min/2018/2018-08-27.parquet
  size:    78 KB
  rows:    2,905

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-27 00:00:00	ES	Futures	3142.9	3143.17	3142.08	3142.63	1110.0
2018-08-27 00:30:00	ES	Futures	3142.63	3143.17	3142.35	3142.63	1159.0
2018-08-27 01:00:00	ES	Futures	3142.9	3143.44	3142.35	3142.35	2557.0
2018-08-27 01:30:00	ES	Futures	3142.63	3142.9	3142.08	3142.08	2130.0
2018-08-27 02:00:00	ES	Futures	3142.08	3142.63	3141.26	3141.81	2966.0
2018-08-27 02:30:00	ES	Futures	3142.08	3142.35	3140.99	3141.81	2082.0
2018-08-27 03:00:00	ES	Futures	3141.81	3142.9	3141.26	3141.81	5063.0
2018-08-27 03:30:00	ES	Futures	3141.54	3142.08	3140.17	3140.72	4285.0
2018-08-27 04:00:00	ES	Futures	3140.45	3141.26	3140.17	3141.26	3191.0
2018-08-27 04:30:00	ES	Futures	3140.99	3143.72	3140.99	3142.9	6160.0
2018-08-27 05:00:00	ES	Futures	3143.17	3143.99	3142.63	3142.9	5132.0
2018-08-27 05:30:00	ES	Futures	3142.9	3143.44	3142.35	3142.35	3227.0
2018-08-27 06:00:00	ES	Futures	3142.63	3143.17	3141.54	3142.9	3538.0
2018-08-27 06:30:00	ES	Futures	3142.9	3143.44	3142.35	3142.63	5019.0
2018-08-27 07:00:00	ES	Futures	3142.63	3143.17	3142.63	3142.9	2601.0
2018-08-27 07:30:00	ES	Futures	3143.17	3144.26	3142.9	3144.26	6138.0
2018-08-27 08:00:00	ES	Futures	3143.99	3147.53	3143.72	3147.26	19452.0
2018-08-27 08:30:00	ES	Futures	3146.99	3147.53	3146.17	3147.26	7949.0
2018-08-27 09:00:00	ES	Futures	3147.53	3148.62	3146.71	3148.08	15007.0
2018-08-27 09:30:00	ES	Futures	3148.08	3153.8	3146.44	3153.52	132456.0
2018-08-27 10:00:00	ES	Futures	3153.52	3157.34	3152.44	3156.52	71309.0
2018-08-27 10:30:00	ES	Futures	3156.52	3156.52	3151.89	3155.16	72798.0
2018-08-27 11:00:00	ES	Futures	3155.16	3155.98	3152.71	3155.43	53043.0
2018-08-27 11:30:00	ES	Futures	3155.16	3159.52	3152.44	3159.25	72234.0
2018-08-27 12:00:00	ES	Futures	3159.25	3159.25	3157.07	3158.43	40673.0
2018-08-27 12:30:00	ES	Futures	3158.7	3159.79	3157.88	3158.97	26814.0
2018-08-27 13:00:00	ES	Futures	3158.97	3159.52	3156.52	3156.79	34600.0
2018-08-27 13:30:00	ES	Futures	3156.79	3158.16	3156.52	3157.88	22960.0
2018-08-27 14:00:00	ES	Futures	3158.16	3158.7	3156.25	3158.16	27307.0
2018-08-27 14:30:00	ES	Futures	3158.16	3158.7	3156.52	3158.16	23124.0
2018-08-27 15:00:00	ES	Futures	3158.16	3158.43	3155.16	3157.07	45365.0
2018-08-27 15:30:00	ES	Futures	3157.07	3158.43	3155.43	3158.16	106618.0
2018-08-27 16:00:00	ES	Futures	3157.88	3159.25	3156.25	3159.25	51587.0
2018-08-27 16:30:00	ES	Futures	3159.25	3160.06	3158.97	3159.79	8091.0
2018-08-27 18:00:00	ES	Futures	3159.52	3161.7	3159.52	3161.15	4106.0
2018-08-27 18:30:00	ES	Futures	3161.15	3161.43	3160.61	3161.15	1139.0
2018-08-27 19:00:00	ES	Futures	3161.15	3161.7	3161.15	3161.15	1350.0
2018-08-27 19:30:00	ES	Futures	3161.15	3161.7	3160.61	3161.7	1739.0
2018-08-27 20:00:00	ES	Futures	3161.43	3163.61	3161.15	3162.79	5122.0
2018-08-27 20:30:00	ES	Futures	3162.79	3163.88	3162.79	3163.61	2912.0
2018-08-27 21:00:00	ES	Futures	3163.61	3164.7	3163.61	3163.88	3103.0
2018-08-27 21:30:00	ES	Futures	3163.61	3164.7	3163.06	3163.61	3350.0
2018-08-27 22:00:00	ES	Futures	3163.61	3163.61	3162.52	3163.33	3541.0
2018-08-27 22:30:00	ES	Futures	3163.33	3163.33	3161.97	3162.24	3457.0
2018-08-27 23:00:00	ES	Futures	3161.97	3162.52	3161.7	3162.24	1275.0
2018-08-27 23:30:00	ES	Futures	3162.52	3162.52	3161.15	3161.7	1734.0
2018-08-27 00:00:00	NQ	Futures	8864.05	8864.34	8860.22	8862.28	538.0
2018-08-27 00:30:00	NQ	Futures	8862.58	8863.75	8859.93	8862.58	480.0
2018-08-27 01:00:00	NQ	Futures	8862.58	8864.34	8859.34	8860.81	1212.0
2018-08-27 01:30:00	NQ	Futures	8861.1	8863.46	8858.16	8859.34	679.0

> showing 50 of 2,905 rows — these rows as CSV

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