PREVIEW / futures_1hour / 2018-04-23

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-04-23.parquet
  size:    55 KB
  rows:    1,693

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-23 00:00:00	ES	Futures	2923.39	2926.39	2923.39	2926.12	3667.0
2018-04-23 01:00:00	ES	Futures	2926.12	2926.67	2923.66	2923.66	3547.0
2018-04-23 02:00:00	ES	Futures	2923.94	2923.94	2919.02	2920.12	7526.0
2018-04-23 03:00:00	ES	Futures	2920.12	2920.93	2913.02	2914.66	18045.0
2018-04-23 04:00:00	ES	Futures	2914.66	2915.75	2910.84	2913.02	12977.0
2018-04-23 05:00:00	ES	Futures	2913.02	2913.84	2911.11	2912.2	11554.0
2018-04-23 06:00:00	ES	Futures	2912.2	2917.66	2910.84	2915.75	12673.0
2018-04-23 07:00:00	ES	Futures	2916.02	2919.57	2914.93	2919.02	13495.0
2018-04-23 08:00:00	ES	Futures	2918.75	2923.66	2917.93	2923.12	23849.0
2018-04-23 09:00:00	ES	Futures	2923.39	2923.39	2912.2	2919.02	119265.0
2018-04-23 10:00:00	ES	Futures	2919.02	2921.48	2911.93	2919.3	177642.0
2018-04-23 11:00:00	ES	Futures	2919.3	2928.85	2917.93	2923.66	162434.0
2018-04-23 12:00:00	ES	Futures	2923.39	2925.03	2914.11	2916.84	96943.0
2018-04-23 13:00:00	ES	Futures	2916.57	2919.84	2913.84	2917.93	69288.0
2018-04-23 14:00:00	ES	Futures	2918.21	2918.75	2900.74	2903.74	176304.0
2018-04-23 15:00:00	ES	Futures	2903.74	2914.66	2902.65	2914.39	183448.0
2018-04-23 16:00:00	ES	Futures	2914.11	2918.48	2913.57	2916.84	62952.0
2018-04-23 18:00:00	ES	Futures	2916.84	2919.02	2916.3	2917.66	4024.0
2018-04-23 19:00:00	ES	Futures	2917.93	2922.03	2917.39	2920.12	3585.0
2018-04-23 20:00:00	ES	Futures	2920.12	2921.21	2917.93	2918.21	6062.0
2018-04-23 21:00:00	ES	Futures	2918.21	2922.85	2916.02	2922.57	5927.0
2018-04-23 22:00:00	ES	Futures	2922.57	2925.3	2922.57	2923.94	5641.0
2018-04-23 23:00:00	ES	Futures	2923.66	2924.21	2921.75	2922.85	3035.0
2018-04-23 00:00:00	NQ	Futures	7915.24	7923.51	7914.06	7918.19	1499.0
2018-04-23 01:00:00	NQ	Futures	7918.49	7922.63	7911.69	7911.69	1269.0
2018-04-23 02:00:00	NQ	Futures	7911.69	7912.87	7896.03	7904.01	3174.0
2018-04-23 03:00:00	NQ	Futures	7903.71	7908.14	7879.18	7886.87	6068.0
2018-04-23 04:00:00	NQ	Futures	7886.57	7891.3	7872.98	7879.48	3865.0
2018-04-23 05:00:00	NQ	Futures	7879.77	7886.28	7875.04	7881.25	2811.0
2018-04-23 06:00:00	NQ	Futures	7880.96	7901.64	7875.93	7896.32	3143.0
2018-04-23 07:00:00	NQ	Futures	7896.62	7910.8	7893.96	7907.85	3927.0
2018-04-23 08:00:00	NQ	Futures	7908.14	7926.76	7905.19	7923.22	8364.0
2018-04-23 09:00:00	NQ	Futures	7922.92	7926.47	7871.5	7897.51	50638.0
2018-04-23 10:00:00	NQ	Futures	7898.1	7934.74	7883.02	7928.24	61099.0
2018-04-23 11:00:00	NQ	Futures	7928.24	7953.36	7922.33	7933.26	38829.0
2018-04-23 12:00:00	NQ	Futures	7933.26	7936.81	7880.66	7888.34	34836.0
2018-04-23 13:00:00	NQ	Futures	7888.64	7897.51	7875.34	7886.57	29670.0
2018-04-23 14:00:00	NQ	Futures	7886.28	7887.75	7821.85	7833.08	57889.0
2018-04-23 15:00:00	NQ	Futures	7832.78	7870.32	7827.46	7865.59	43300.0
2018-04-23 16:00:00	NQ	Futures	7865.29	7912.28	7860.86	7875.93	17524.0
2018-04-23 18:00:00	NQ	Futures	7873.86	7882.43	7870.91	7879.77	1424.0
2018-04-23 19:00:00	NQ	Futures	7879.77	7889.23	7877.7	7886.57	924.0
2018-04-23 20:00:00	NQ	Futures	7885.68	7888.05	7872.68	7873.86	1355.0
2018-04-23 21:00:00	NQ	Futures	7873.86	7886.28	7865.88	7885.39	2221.0
2018-04-23 22:00:00	NQ	Futures	7885.39	7893.07	7882.73	7887.16	2505.0
2018-04-23 23:00:00	NQ	Futures	7887.75	7891.59	7883.32	7889.82	1123.0
2018-04-23 00:00:00	YM	Futures	26605.4	26626.0	26605.4	26620.6	1115.0
2018-04-23 01:00:00	YM	Futures	26622.8	26630.4	26606.5	26608.7	1329.0
2018-04-23 02:00:00	YM	Futures	26609.7	26611.9	26544.6	26556.5	3278.0
2018-04-23 03:00:00	YM	Futures	26555.4	26568.5	26482.7	26495.7	5177.0

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

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