PREVIEW / futures_1hour / 2019-01-30

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-01-30.parquet
  size:    57 KB
  rows:    1,780

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
2019-01-30 00:00:00	ES	Futures	2871.74	2872.28	2866.85	2867.93	6268.0
2019-01-30 01:00:00	ES	Futures	2867.93	2870.11	2866.03	2866.3	6856.0
2019-01-30 02:00:00	ES	Futures	2866.58	2869.02	2863.86	2869.02	9248.0
2019-01-30 03:00:00	ES	Futures	2869.02	2874.18	2867.12	2873.91	15843.0
2019-01-30 04:00:00	ES	Futures	2873.91	2876.62	2872.28	2874.72	12464.0
2019-01-30 05:00:00	ES	Futures	2874.72	2876.08	2873.09	2875.54	7278.0
2019-01-30 06:00:00	ES	Futures	2875.27	2877.71	2874.45	2877.71	7951.0
2019-01-30 07:00:00	ES	Futures	2877.71	2884.5	2876.9	2880.7	39149.0
2019-01-30 08:00:00	ES	Futures	2880.7	2882.33	2877.71	2881.24	25768.0
2019-01-30 09:00:00	ES	Futures	2881.24	2886.13	2877.71	2878.8	163787.0
2019-01-30 10:00:00	ES	Futures	2878.52	2884.23	2874.99	2882.06	163076.0
2019-01-30 11:00:00	ES	Futures	2881.78	2892.65	2881.78	2892.1	143679.0
2019-01-30 12:00:00	ES	Futures	2892.38	2897.26	2890.75	2891.56	100667.0
2019-01-30 13:00:00	ES	Futures	2891.83	2893.46	2886.4	2888.57	58482.0
2019-01-30 14:00:00	ES	Futures	2888.57	2921.98	2884.23	2921.44	343675.0
2019-01-30 15:00:00	ES	Futures	2921.71	2921.71	2905.14	2911.66	265485.0
2019-01-30 16:00:00	ES	Futures	2911.93	2916.82	2906.23	2914.92	77656.0
2019-01-30 18:00:00	ES	Futures	2915.19	2920.08	2913.29	2919.53	13814.0
2019-01-30 19:00:00	ES	Futures	2919.81	2919.81	2913.02	2914.65	18026.0
2019-01-30 20:00:00	ES	Futures	2914.37	2918.99	2913.83	2918.45	14508.0
2019-01-30 21:00:00	ES	Futures	2918.45	2921.44	2917.09	2920.62	9719.0
2019-01-30 22:00:00	ES	Futures	2920.62	2924.15	2919.81	2923.06	11721.0
2019-01-30 23:00:00	ES	Futures	2923.06	2924.15	2920.89	2921.16	4917.0
2019-01-30 00:00:00	NQ	Futures	7813.14	7813.73	7797.95	7799.7	3435.0
2019-01-30 01:00:00	NQ	Futures	7799.99	7809.34	7798.53	7800.87	3322.0
2019-01-30 02:00:00	NQ	Futures	7800.58	7805.84	7790.94	7804.08	3935.0
2019-01-30 03:00:00	NQ	Futures	7803.79	7818.11	7796.2	7817.53	5600.0
2019-01-30 04:00:00	NQ	Futures	7817.53	7826.29	7811.97	7817.23	4605.0
2019-01-30 05:00:00	NQ	Futures	7817.23	7822.79	7810.81	7820.74	3152.0
2019-01-30 06:00:00	NQ	Futures	7820.74	7826.58	7813.73	7825.71	3291.0
2019-01-30 07:00:00	NQ	Futures	7826.29	7841.19	7823.95	7832.43	9923.0
2019-01-30 08:00:00	NQ	Futures	7832.43	7839.44	7817.53	7834.47	10378.0
2019-01-30 09:00:00	NQ	Futures	7834.47	7873.63	7832.43	7842.65	71855.0
2019-01-30 10:00:00	NQ	Futures	7842.36	7855.51	7824.25	7842.95	59902.0
2019-01-30 11:00:00	NQ	Futures	7842.65	7868.66	7841.49	7868.37	43474.0
2019-01-30 12:00:00	NQ	Futures	7868.37	7901.68	7866.91	7892.03	41618.0
2019-01-30 13:00:00	NQ	Futures	7892.03	7896.71	7879.18	7883.85	20357.0
2019-01-30 14:00:00	NQ	Futures	7883.85	7987.87	7877.13	7985.53	108299.0
2019-01-30 15:00:00	NQ	Futures	7985.83	7985.83	7944.92	7964.5	68775.0
2019-01-30 16:00:00	NQ	Futures	7964.5	8000.44	7933.52	7992.84	27949.0
2019-01-30 18:00:00	NQ	Futures	7999.27	8024.1	7999.27	8022.64	7548.0
2019-01-30 19:00:00	NQ	Futures	8022.93	8026.73	8002.19	8007.74	10584.0
2019-01-30 20:00:00	NQ	Futures	8007.45	8020.31	8004.53	8018.84	6417.0
2019-01-30 21:00:00	NQ	Futures	8019.14	8030.53	8015.34	8027.61	4062.0
2019-01-30 22:00:00	NQ	Futures	8027.61	8042.8	8026.73	8039.59	5170.0
2019-01-30 23:00:00	NQ	Futures	8039.59	8040.76	8031.7	8032.58	2242.0
2019-01-30 00:00:00	YM	Futures	26713.8	26719.2	26668.2	26678.0	2080.0
2019-01-30 01:00:00	YM	Futures	26678.0	26697.5	26661.7	26666.0	1952.0
2019-01-30 02:00:00	YM	Futures	26666.0	26686.7	26643.2	26683.4	3116.0
2019-01-30 03:00:00	YM	Futures	26683.4	26731.2	26671.5	26729.0	5057.0

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

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