PREVIEW / futures_1hour / 2018-04-24

all futures 1-hour files

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

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-24 00:00:00	ES	Futures	2922.85	2923.94	2922.3	2922.57	1791.0
2018-04-24 01:00:00	ES	Futures	2922.57	2925.3	2922.3	2923.66	3024.0
2018-04-24 02:00:00	ES	Futures	2923.66	2924.48	2920.93	2921.21	6150.0
2018-04-24 03:00:00	ES	Futures	2921.48	2925.57	2919.02	2925.03	11596.0
2018-04-24 04:00:00	ES	Futures	2925.03	2931.58	2923.66	2930.21	16215.0
2018-04-24 05:00:00	ES	Futures	2930.21	2930.76	2927.76	2928.58	9959.0
2018-04-24 06:00:00	ES	Futures	2928.58	2934.31	2928.3	2933.22	15626.0
2018-04-24 07:00:00	ES	Futures	2933.22	2934.85	2931.03	2933.22	23902.0
2018-04-24 08:00:00	ES	Futures	2933.49	2934.85	2929.39	2930.49	25557.0
2018-04-24 09:00:00	ES	Futures	2930.49	2930.49	2917.93	2921.75	191410.0
2018-04-24 10:00:00	ES	Futures	2921.75	2927.48	2910.29	2911.93	270871.0
2018-04-24 11:00:00	ES	Futures	2912.2	2917.66	2904.56	2904.56	300257.0
2018-04-24 12:00:00	ES	Futures	2904.56	2908.11	2881.09	2881.36	304095.0
2018-04-24 13:00:00	ES	Futures	2881.09	2886.82	2863.62	2867.17	247498.0
2018-04-24 14:00:00	ES	Futures	2867.17	2870.72	2855.71	2867.17	350970.0
2018-04-24 15:00:00	ES	Futures	2867.17	2878.36	2859.8	2875.09	397981.0
2018-04-24 16:00:00	ES	Futures	2874.81	2878.63	2874.27	2877.0	87327.0
2018-04-24 18:00:00	ES	Futures	2876.72	2880.82	2875.09	2879.18	8300.0
2018-04-24 19:00:00	ES	Futures	2879.18	2880.54	2877.82	2879.73	2941.0
2018-04-24 20:00:00	ES	Futures	2879.73	2881.64	2878.36	2880.82	4658.0
2018-04-24 21:00:00	ES	Futures	2880.82	2881.64	2872.63	2874.27	9282.0
2018-04-24 22:00:00	ES	Futures	2873.99	2874.27	2866.35	2871.54	15011.0
2018-04-24 23:00:00	ES	Futures	2871.54	2873.99	2869.08	2873.72	4178.0
2018-04-24 00:00:00	NQ	Futures	7889.82	7891.89	7887.75	7890.12	610.0
2018-04-24 01:00:00	NQ	Futures	7890.41	7901.64	7889.53	7897.8	1611.0
2018-04-24 02:00:00	NQ	Futures	7897.8	7899.28	7890.12	7890.41	1446.0
2018-04-24 03:00:00	NQ	Futures	7891.0	7905.48	7882.43	7901.94	4264.0
2018-04-24 04:00:00	NQ	Futures	7902.53	7927.06	7899.28	7924.4	5826.0
2018-04-24 05:00:00	NQ	Futures	7924.4	7930.61	7918.19	7921.74	3352.0
2018-04-24 06:00:00	NQ	Futures	7921.44	7941.24	7921.44	7936.81	4436.0
2018-04-24 07:00:00	NQ	Futures	7936.52	7936.81	7914.94	7924.99	8385.0
2018-04-24 08:00:00	NQ	Futures	7925.58	7929.72	7909.33	7913.46	6683.0
2018-04-24 09:00:00	NQ	Futures	7913.46	7915.24	7858.5	7880.96	59864.0
2018-04-24 10:00:00	NQ	Futures	7880.96	7892.19	7802.34	7807.37	94224.0
2018-04-24 11:00:00	NQ	Futures	7807.37	7818.3	7757.13	7774.27	98602.0
2018-04-24 12:00:00	NQ	Futures	7773.97	7787.57	7704.82	7705.11	76491.0
2018-04-24 13:00:00	NQ	Futures	7705.11	7732.6	7674.67	7686.79	62319.0
2018-04-24 14:00:00	NQ	Futures	7686.79	7695.66	7645.12	7687.38	87616.0
2018-04-24 15:00:00	NQ	Futures	7687.09	7717.23	7654.28	7698.91	84901.0
2018-04-24 16:00:00	NQ	Futures	7698.32	7719.0	7695.66	7715.16	11898.0
2018-04-24 18:00:00	NQ	Futures	7714.28	7724.91	7708.36	7716.05	2126.0
2018-04-24 19:00:00	NQ	Futures	7715.46	7724.03	7713.39	7722.25	1003.0
2018-04-24 20:00:00	NQ	Futures	7721.66	7729.64	7717.53	7726.98	1456.0
2018-04-24 21:00:00	NQ	Futures	7726.98	7728.76	7696.25	7703.05	3164.0
2018-04-24 22:00:00	NQ	Futures	7702.16	7702.75	7681.18	7699.2	4379.0
2018-04-24 23:00:00	NQ	Futures	7698.91	7705.41	7692.11	7703.34	1559.0
2018-04-24 00:00:00	YM	Futures	26579.3	26585.8	26572.8	26575.0	676.0
2018-04-24 01:00:00	YM	Futures	26573.9	26598.9	26569.6	26586.9	1261.0
2018-04-24 02:00:00	YM	Futures	26585.8	26591.3	26558.7	26563.0	1755.0
2018-04-24 03:00:00	YM	Futures	26563.0	26592.4	26528.3	26583.7	3626.0

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

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