PREVIEW / futures_1hour / 2018-04-20

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-04-20.parquet
  size:    47 KB
  rows:    1,383

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-04-20 00:00:00	ES	Futures	2940.86	2943.31	2940.58	2943.31	1740.0
2018-04-20 01:00:00	ES	Futures	2943.59	2943.59	2939.49	2940.04	3527.0
2018-04-20 02:00:00	ES	Futures	2940.04	2940.86	2937.04	2937.86	6026.0
2018-04-20 03:00:00	ES	Futures	2938.13	2938.95	2928.58	2930.76	18000.0
2018-04-20 04:00:00	ES	Futures	2930.76	2935.67	2930.76	2935.13	12693.0
2018-04-20 05:00:00	ES	Futures	2935.13	2939.22	2930.49	2938.13	15066.0
2018-04-20 06:00:00	ES	Futures	2938.13	2943.59	2936.49	2943.31	15402.0
2018-04-20 07:00:00	ES	Futures	2943.04	2945.5	2940.04	2941.4	12197.0
2018-04-20 08:00:00	ES	Futures	2941.13	2942.22	2936.76	2940.86	28997.0
2018-04-20 09:00:00	ES	Futures	2940.86	2943.04	2932.12	2934.58	162431.0
2018-04-20 10:00:00	ES	Futures	2934.58	2935.13	2921.48	2924.21	235281.0
2018-04-20 11:00:00	ES	Futures	2924.21	2924.76	2912.75	2919.3	236192.0
2018-04-20 12:00:00	ES	Futures	2919.57	2919.84	2908.93	2911.93	146527.0
2018-04-20 13:00:00	ES	Futures	2911.93	2922.3	2910.29	2918.48	152073.0
2018-04-20 14:00:00	ES	Futures	2918.48	2920.12	2910.84	2914.11	118159.0
2018-04-20 15:00:00	ES	Futures	2913.84	2915.75	2903.47	2915.48	289360.0
2018-04-20 16:00:00	ES	Futures	2915.48	2918.21	2913.84	2916.02	83253.0
2018-04-20 00:00:00	NQ	Futures	8012.76	8023.4	8012.76	8022.81	865.0
2018-04-20 01:00:00	NQ	Futures	8022.81	8023.99	8010.99	8012.76	1266.0
2018-04-20 02:00:00	NQ	Futures	8013.06	8014.83	7997.99	8003.01	2241.0
2018-04-20 03:00:00	NQ	Futures	8003.31	8004.19	7960.16	7966.96	7536.0
2018-04-20 04:00:00	NQ	Futures	7967.25	7991.19	7966.66	7989.71	4548.0
2018-04-20 05:00:00	NQ	Futures	7989.71	8000.94	7973.16	7996.8	4310.0
2018-04-20 06:00:00	NQ	Futures	7996.8	8016.01	7990.3	8014.83	4882.0
2018-04-20 07:00:00	NQ	Futures	8014.83	8025.77	8005.67	8008.63	5293.0
2018-04-20 08:00:00	NQ	Futures	8008.92	8010.99	7982.62	8000.94	9330.0
2018-04-20 09:00:00	NQ	Futures	8000.94	8006.85	7942.72	7956.32	52259.0
2018-04-20 10:00:00	NQ	Futures	7956.32	7970.8	7920.56	7932.08	62567.0
2018-04-20 11:00:00	NQ	Futures	7931.79	7935.04	7887.46	7904.3	62924.0
2018-04-20 12:00:00	NQ	Futures	7904.6	7909.92	7873.27	7880.96	41309.0
2018-04-20 13:00:00	NQ	Futures	7880.96	7918.19	7875.04	7905.19	40249.0
2018-04-20 14:00:00	NQ	Futures	7905.48	7911.1	7877.7	7888.64	30203.0
2018-04-20 15:00:00	NQ	Futures	7888.34	7890.41	7856.43	7888.34	62007.0
2018-04-20 16:00:00	NQ	Futures	7888.64	7900.76	7882.14	7891.59	10445.0
2018-04-20 00:00:00	YM	Futures	26750.9	26770.5	26750.9	26769.4	645.0
2018-04-20 01:00:00	YM	Futures	26769.4	26770.5	26743.3	26747.7	1062.0
2018-04-20 02:00:00	YM	Futures	26747.7	26754.2	26728.1	26733.5	2167.0
2018-04-20 03:00:00	YM	Futures	26733.5	26739.0	26639.1	26659.7	5000.0
2018-04-20 04:00:00	YM	Futures	26660.8	26702.1	26660.8	26696.6	3214.0
2018-04-20 05:00:00	YM	Futures	26696.6	26729.2	26655.4	26718.3	3588.0
2018-04-20 06:00:00	YM	Futures	26718.3	26767.2	26704.2	26759.6	3653.0
2018-04-20 07:00:00	YM	Futures	26759.6	26782.4	26730.3	26740.1	2721.0
2018-04-20 08:00:00	YM	Futures	26741.1	26749.8	26705.3	26740.1	4174.0
2018-04-20 09:00:00	YM	Futures	26741.1	26767.2	26686.8	26718.3	19923.0
2018-04-20 10:00:00	YM	Futures	26717.3	26721.6	26588.0	26603.2	26723.0
2018-04-20 11:00:00	YM	Futures	26602.1	26606.5	26480.5	26558.7	34049.0
2018-04-20 12:00:00	YM	Futures	26559.8	26563.0	26471.8	26505.5	19755.0
2018-04-20 13:00:00	YM	Futures	26504.4	26589.1	26489.2	26551.1	18635.0
2018-04-20 14:00:00	YM	Futures	26552.2	26563.0	26490.3	26515.3	13746.0
2018-04-20 15:00:00	YM	Futures	26515.3	26535.9	26431.6	26531.5	29153.0

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

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