PREVIEW / futures_30min / 2017-08-20

all futures 30-min files

  file:    by_date/futures_30min/2017/2017-08-20.parquet
  size:    20 KB
  rows:    523

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
2017-08-20 18:00:00	ES	Futures	2655.49	2658.22	2653.85	2657.13	8902.0
2017-08-20 18:30:00	ES	Futures	2657.13	2658.22	2656.86	2657.68	3070.0
2017-08-20 19:00:00	ES	Futures	2657.68	2658.5	2656.86	2657.4	2243.0
2017-08-20 19:30:00	ES	Futures	2657.4	2657.4	2654.4	2655.76	3313.0
2017-08-20 20:00:00	ES	Futures	2655.76	2655.76	2650.84	2651.39	9918.0
2017-08-20 20:30:00	ES	Futures	2651.39	2652.76	2651.39	2651.94	2630.0
2017-08-20 21:00:00	ES	Futures	2651.94	2652.48	2648.93	2651.12	8282.0
2017-08-20 21:30:00	ES	Futures	2651.12	2653.03	2651.12	2651.66	4630.0
2017-08-20 22:00:00	ES	Futures	2651.66	2651.94	2650.57	2651.12	3480.0
2017-08-20 22:30:00	ES	Futures	2651.12	2651.94	2649.75	2650.02	5212.0
2017-08-20 23:00:00	ES	Futures	2650.02	2651.12	2649.2	2650.84	2128.0
2017-08-20 23:30:00	ES	Futures	2650.84	2651.39	2650.3	2650.84	2753.0
2017-08-20 18:00:00	NQ	Futures	6913.78	6927.78	6908.42	6920.33	1716.0
2017-08-20 18:30:00	NQ	Futures	6920.33	6923.31	6919.14	6920.33	556.0
2017-08-20 19:00:00	NQ	Futures	6920.04	6921.53	6919.44	6920.04	395.0
2017-08-20 19:30:00	NQ	Futures	6920.33	6920.63	6909.32	6917.06	734.0
2017-08-20 20:00:00	NQ	Futures	6916.76	6917.36	6893.83	6898.3	2501.0
2017-08-20 20:30:00	NQ	Futures	6898.0	6902.77	6897.11	6899.49	815.0
2017-08-20 21:00:00	NQ	Futures	6899.79	6900.98	6889.07	6895.92	2087.0
2017-08-20 21:30:00	NQ	Futures	6895.92	6902.77	6895.62	6898.9	1124.0
2017-08-20 22:00:00	NQ	Futures	6898.3	6901.87	6896.81	6900.09	676.0
2017-08-20 22:30:00	NQ	Futures	6900.39	6901.87	6893.54	6893.83	583.0
2017-08-20 23:00:00	NQ	Futures	6893.54	6900.68	6889.96	6900.39	851.0
2017-08-20 23:30:00	NQ	Futures	6900.68	6901.87	6896.22	6899.79	574.0
2017-08-20 18:00:00	YM	Futures	23608.1	23636.4	23607.0	23629.9	849.0
2017-08-20 18:30:00	YM	Futures	23629.9	23638.6	23628.8	23638.6	376.0
2017-08-20 19:00:00	YM	Futures	23637.5	23641.8	23630.9	23634.2	232.0
2017-08-20 19:30:00	YM	Futures	23635.3	23637.5	23612.4	23622.2	668.0
2017-08-20 20:00:00	YM	Futures	23621.1	23622.2	23582.0	23588.5	1993.0
2017-08-20 20:30:00	YM	Futures	23589.6	23600.5	23588.5	23592.8	833.0
2017-08-20 21:00:00	YM	Futures	23592.8	23595.0	23572.2	23586.3	1273.0
2017-08-20 21:30:00	YM	Futures	23585.2	23597.2	23585.2	23588.5	761.0
2017-08-20 22:00:00	YM	Futures	23587.4	23592.8	23584.1	23587.4	419.0
2017-08-20 22:30:00	YM	Futures	23588.5	23593.9	23580.9	23580.9	389.0
2017-08-20 23:00:00	YM	Futures	23579.8	23589.6	23575.4	23589.6	446.0
2017-08-20 23:30:00	YM	Futures	23589.6	23593.9	23583.0	23589.6	478.0
2017-08-20 18:00:00	CL	Futures	44.21	44.23	44.09	44.11	1785.0
2017-08-20 18:30:00	CL	Futures	44.1	44.11	44.09	44.1	464.0
2017-08-20 19:00:00	CL	Futures	44.1	44.13	44.1	44.1	491.0
2017-08-20 19:30:00	CL	Futures	44.11	44.11	44.04	44.06	1103.0
2017-08-20 20:00:00	CL	Futures	44.06	44.06	43.94	43.98	2944.0
2017-08-20 20:30:00	CL	Futures	43.98	44.08	43.98	44.04	2287.0
2017-08-20 21:00:00	CL	Futures	44.05	44.05	43.98	44.02	2345.0
2017-08-20 21:30:00	CL	Futures	44.03	44.05	44.0	44.01	2332.0
2017-08-20 22:00:00	CL	Futures	44.01	44.09	44.01	44.05	2534.0
2017-08-20 22:30:00	CL	Futures	44.04	44.05	44.01	44.01	1778.0
2017-08-20 23:00:00	CL	Futures	44.01	44.07	43.99	44.01	3225.0
2017-08-20 23:30:00	CL	Futures	44.01	44.04	43.99	44.0	1814.0
2017-08-20 18:00:00	GC	Futures	1717.3	1718.9	1716.1	1717.4	2688.0
2017-08-20 18:30:00	GC	Futures	1717.4	1717.4	1715.3	1716.7	1475.0

> showing 50 of 523 rows — these rows as CSV

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