PREVIEW / futures_1hour / 2018-07-23

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-07-23.parquet
  size:    53 KB
  rows:    1,645

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-23 00:00:00	ES	Futures	3048.35	3049.44	3046.17	3049.17	3141.0
2018-07-23 01:00:00	ES	Futures	3049.17	3050.81	3048.9	3049.99	4508.0
2018-07-23 02:00:00	ES	Futures	3049.99	3052.17	3049.17	3050.53	8538.0
2018-07-23 03:00:00	ES	Futures	3050.26	3050.81	3046.72	3048.63	13580.0
2018-07-23 04:00:00	ES	Futures	3048.35	3051.62	3048.08	3050.26	8226.0
2018-07-23 05:00:00	ES	Futures	3050.53	3052.44	3048.9	3050.53	7838.0
2018-07-23 06:00:00	ES	Futures	3050.81	3051.89	3047.81	3048.63	5724.0
2018-07-23 07:00:00	ES	Futures	3048.63	3052.98	3048.35	3052.71	9653.0
2018-07-23 08:00:00	ES	Futures	3052.71	3054.35	3051.35	3052.17	15081.0
2018-07-23 09:00:00	ES	Futures	3052.17	3053.8	3048.35	3052.44	128505.0
2018-07-23 10:00:00	ES	Futures	3052.44	3055.44	3047.26	3052.17	139331.0
2018-07-23 11:00:00	ES	Futures	3052.17	3057.62	3049.72	3057.34	98068.0
2018-07-23 12:00:00	ES	Futures	3057.62	3061.16	3055.98	3059.52	64308.0
2018-07-23 13:00:00	ES	Futures	3059.52	3060.89	3057.07	3059.8	48630.0
2018-07-23 14:00:00	ES	Futures	3059.52	3061.98	3059.25	3060.89	51616.0
2018-07-23 15:00:00	ES	Futures	3061.16	3061.98	3059.25	3060.34	88966.0
2018-07-23 16:00:00	ES	Futures	3060.61	3065.25	3059.8	3063.88	59329.0
2018-07-23 18:00:00	ES	Futures	3063.07	3065.52	3062.79	3064.7	3213.0
2018-07-23 19:00:00	ES	Futures	3064.7	3069.88	3064.43	3069.33	7186.0
2018-07-23 20:00:00	ES	Futures	3069.33	3069.88	3066.88	3067.97	7000.0
2018-07-23 21:00:00	ES	Futures	3068.24	3070.97	3066.34	3070.7	11604.0
2018-07-23 22:00:00	ES	Futures	3070.7	3071.79	3069.61	3071.51	6532.0
2018-07-23 23:00:00	ES	Futures	3071.24	3072.87	3071.24	3071.79	6143.0
2018-07-23 00:00:00	NQ	Futures	8641.47	8646.47	8636.76	8643.53	1159.0
2018-07-23 01:00:00	NQ	Futures	8643.53	8648.24	8637.64	8640.88	2056.0
2018-07-23 02:00:00	NQ	Futures	8641.17	8651.48	8640.58	8642.94	3041.0
2018-07-23 03:00:00	NQ	Futures	8642.94	8644.71	8629.98	8636.46	5027.0
2018-07-23 04:00:00	NQ	Futures	8636.46	8647.65	8634.99	8641.76	3504.0
2018-07-23 05:00:00	NQ	Futures	8641.47	8647.06	8636.17	8636.76	2672.0
2018-07-23 06:00:00	NQ	Futures	8637.05	8640.58	8623.8	8629.4	3891.0
2018-07-23 07:00:00	NQ	Futures	8629.4	8647.06	8628.81	8646.77	3498.0
2018-07-23 08:00:00	NQ	Futures	8646.77	8655.3	8642.35	8648.24	5843.0
2018-07-23 09:00:00	NQ	Futures	8648.24	8660.6	8610.55	8636.76	63621.0
2018-07-23 10:00:00	NQ	Futures	8636.46	8669.44	8634.4	8661.78	51669.0
2018-07-23 11:00:00	NQ	Futures	8661.49	8681.8	8650.59	8679.15	30314.0
2018-07-23 12:00:00	NQ	Futures	8679.74	8690.63	8672.09	8682.98	19530.0
2018-07-23 13:00:00	NQ	Futures	8682.98	8693.58	8673.56	8686.81	18176.0
2018-07-23 14:00:00	NQ	Futures	8687.1	8699.47	8685.34	8695.35	14927.0
2018-07-23 15:00:00	NQ	Futures	8695.35	8703.59	8690.34	8697.11	19855.0
2018-07-23 16:00:00	NQ	Futures	8696.82	8753.35	8694.17	8738.63	21838.0
2018-07-23 18:00:00	NQ	Futures	8738.63	8746.87	8734.5	8745.4	1664.0
2018-07-23 19:00:00	NQ	Futures	8745.4	8764.83	8745.4	8758.65	3156.0
2018-07-23 20:00:00	NQ	Futures	8758.65	8761.59	8752.76	8758.06	2332.0
2018-07-23 21:00:00	NQ	Futures	8758.06	8766.89	8749.52	8764.53	3597.0
2018-07-23 22:00:00	NQ	Futures	8764.53	8770.13	8761.88	8768.95	2601.0
2018-07-23 23:00:00	NQ	Futures	8768.95	8771.31	8766.01	8766.59	1653.0
2018-07-23 00:00:00	YM	Futures	27188.3	27191.5	27165.4	27186.1	923.0
2018-07-23 01:00:00	YM	Futures	27187.2	27208.9	27183.9	27195.9	2255.0
2018-07-23 02:00:00	YM	Futures	27195.9	27225.2	27192.6	27211.1	3987.0
2018-07-23 03:00:00	YM	Futures	27208.9	27212.2	27165.4	27182.8	3077.0

> showing 50 of 1,645 rows — these rows as CSV

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