PREVIEW / futures_30min / 2018-08-31

all futures 30-min files

  file:    by_date/futures_30min/2018/2018-08-31.parquet
  size:    73 KB
  rows:    2,576

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-31 00:00:00	ES	Futures	3162.52	3163.33	3161.97	3162.24	1178.0
2018-08-31 00:30:00	ES	Futures	3162.24	3163.06	3161.97	3162.79	882.0
2018-08-31 01:00:00	ES	Futures	3162.52	3164.15	3162.52	3163.88	2599.0
2018-08-31 01:30:00	ES	Futures	3163.61	3164.97	3163.06	3163.06	3765.0
2018-08-31 02:00:00	ES	Futures	3163.06	3163.88	3161.7	3163.61	3472.0
2018-08-31 02:30:00	ES	Futures	3163.61	3164.15	3162.79	3163.61	2834.0
2018-08-31 03:00:00	ES	Futures	3163.61	3163.61	3157.34	3158.43	12944.0
2018-08-31 03:30:00	ES	Futures	3158.43	3161.43	3157.61	3158.7	8202.0
2018-08-31 04:00:00	ES	Futures	3158.7	3160.88	3157.61	3159.52	6521.0
2018-08-31 04:30:00	ES	Futures	3159.79	3161.43	3159.25	3160.61	5654.0
2018-08-31 05:00:00	ES	Futures	3160.34	3163.06	3159.52	3161.97	5426.0
2018-08-31 05:30:00	ES	Futures	3161.97	3162.52	3157.07	3157.61	8476.0
2018-08-31 06:00:00	ES	Futures	3157.88	3158.97	3155.98	3158.16	6552.0
2018-08-31 06:30:00	ES	Futures	3158.16	3160.06	3157.61	3158.7	5132.0
2018-08-31 07:00:00	ES	Futures	3158.7	3159.25	3156.52	3156.52	3993.0
2018-08-31 07:30:00	ES	Futures	3156.79	3157.61	3155.7	3155.98	8196.0
2018-08-31 08:00:00	ES	Futures	3155.98	3158.7	3155.7	3157.88	8088.0
2018-08-31 08:30:00	ES	Futures	3157.88	3157.88	3155.16	3155.43	12277.0
2018-08-31 09:00:00	ES	Futures	3155.7	3158.43	3155.16	3157.88	15505.0
2018-08-31 09:30:00	ES	Futures	3157.88	3162.79	3157.34	3161.43	99320.0
2018-08-31 10:00:00	ES	Futures	3161.43	3168.78	3161.15	3164.7	99639.0
2018-08-31 10:30:00	ES	Futures	3164.97	3166.33	3163.06	3164.97	57124.0
2018-08-31 11:00:00	ES	Futures	3164.7	3166.6	3158.7	3159.25	89055.0
2018-08-31 11:30:00	ES	Futures	3158.97	3161.43	3156.25	3156.25	66447.0
2018-08-31 12:00:00	ES	Futures	3156.52	3156.79	3152.98	3155.98	60869.0
2018-08-31 12:30:00	ES	Futures	3155.7	3156.79	3151.62	3156.79	61664.0
2018-08-31 13:00:00	ES	Futures	3156.79	3158.16	3154.89	3156.79	35685.0
2018-08-31 13:30:00	ES	Futures	3156.52	3158.16	3154.34	3157.34	34184.0
2018-08-31 14:00:00	ES	Futures	3157.07	3157.61	3152.16	3153.8	37605.0
2018-08-31 14:30:00	ES	Futures	3153.8	3157.61	3152.98	3154.89	46919.0
2018-08-31 15:00:00	ES	Futures	3154.89	3159.25	3154.07	3154.61	72848.0
2018-08-31 15:30:00	ES	Futures	3154.89	3164.7	3154.61	3161.97	239309.0
2018-08-31 16:00:00	ES	Futures	3162.24	3166.88	3161.43	3166.88	72403.0
2018-08-31 16:30:00	ES	Futures	3166.88	3168.51	3165.79	3168.24	9571.0
2018-08-31 17:00:00	ES	Futures	3168.24	3168.24	3168.24	3168.24	5.0
2018-08-31 00:00:00	NQ	Futures	9015.67	9019.21	9015.08	9016.85	683.0
2018-08-31 00:30:00	NQ	Futures	9016.56	9017.73	9015.08	9015.97	365.0
2018-08-31 01:00:00	NQ	Futures	9015.97	9020.68	9015.97	9019.5	1243.0
2018-08-31 01:30:00	NQ	Futures	9019.5	9024.8	9015.38	9015.97	1694.0
2018-08-31 02:00:00	NQ	Futures	9016.26	9017.44	9010.08	9017.14	1634.0
2018-08-31 02:30:00	NQ	Futures	9017.14	9018.62	9014.2	9015.97	927.0
2018-08-31 03:00:00	NQ	Futures	9016.26	9016.26	8993.0	8999.19	3599.0
2018-08-31 03:30:00	NQ	Futures	8999.19	9007.72	8994.18	8999.77	2364.0
2018-08-31 04:00:00	NQ	Futures	8999.77	9004.48	8995.36	9001.83	1492.0
2018-08-31 04:30:00	NQ	Futures	9001.83	9008.02	9000.66	9004.78	1430.0
2018-08-31 05:00:00	NQ	Futures	9005.07	9013.32	9002.13	9008.61	1082.0
2018-08-31 05:30:00	NQ	Futures	9008.31	9010.08	8995.65	8997.12	2114.0
2018-08-31 06:00:00	NQ	Futures	8998.01	9001.25	8993.59	8999.48	1587.0
2018-08-31 06:30:00	NQ	Futures	8999.48	9005.66	8997.71	9001.54	1276.0
2018-08-31 07:00:00	NQ	Futures	9000.95	9006.25	8998.01	8998.01	1257.0

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

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