PREVIEW / futures_1hour / 2018-12-07

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-12-07.parquet
  size:    49 KB
  rows:    1,413

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-12-07 00:00:00	ES	Futures	2925.07	2925.61	2922.62	2923.98	3430.0
2018-12-07 01:00:00	ES	Futures	2923.71	2924.52	2920.72	2922.08	4023.0
2018-12-07 02:00:00	ES	Futures	2921.8	2924.25	2905.48	2906.03	23573.0
2018-12-07 03:00:00	ES	Futures	2906.03	2919.08	2905.21	2913.64	34237.0
2018-12-07 04:00:00	ES	Futures	2913.64	2920.99	2910.38	2919.63	21793.0
2018-12-07 05:00:00	ES	Futures	2919.36	2920.99	2914.46	2917.72	13884.0
2018-12-07 06:00:00	ES	Futures	2917.45	2917.72	2910.38	2910.65	16517.0
2018-12-07 07:00:00	ES	Futures	2910.65	2914.73	2909.02	2914.19	19129.0
2018-12-07 08:00:00	ES	Futures	2914.19	2935.68	2913.37	2926.7	88449.0
2018-12-07 09:00:00	ES	Futures	2926.7	2948.19	2926.16	2938.4	239597.0
2018-12-07 10:00:00	ES	Futures	2938.4	2942.2	2902.22	2915.55	351600.0
2018-12-07 11:00:00	ES	Futures	2915.55	2918.27	2883.73	2884.0	330405.0
2018-12-07 12:00:00	ES	Futures	2884.0	2897.05	2875.02	2893.79	245399.0
2018-12-07 13:00:00	ES	Futures	2893.52	2900.86	2872.85	2873.12	202924.0
2018-12-07 14:00:00	ES	Futures	2873.12	2880.73	2857.89	2859.79	304758.0
2018-12-07 15:00:00	ES	Futures	2859.79	2885.09	2854.08	2865.23	436841.0
2018-12-07 16:00:00	ES	Futures	2864.96	2870.13	2863.05	2868.77	99214.0
2018-12-07 00:00:00	NQ	Futures	8010.12	8011.58	8001.02	8005.13	1879.0
2018-12-07 01:00:00	NQ	Futures	8005.42	8007.77	7995.16	7998.68	1899.0
2018-12-07 02:00:00	NQ	Futures	7998.68	8005.13	7939.43	7939.43	10350.0
2018-12-07 03:00:00	NQ	Futures	7939.13	7984.89	7936.49	7966.41	12231.0
2018-12-07 04:00:00	NQ	Futures	7966.71	7991.93	7956.44	7984.6	8560.0
2018-12-07 05:00:00	NQ	Futures	7984.6	7988.7	7966.71	7974.04	5846.0
2018-12-07 06:00:00	NQ	Futures	7974.33	7976.38	7950.57	7952.04	6599.0
2018-12-07 07:00:00	NQ	Futures	7951.45	7971.4	7948.52	7969.93	7364.0
2018-12-07 08:00:00	NQ	Futures	7969.93	8033.29	7967.29	7992.52	33793.0
2018-12-07 09:00:00	NQ	Futures	7992.22	8039.15	7979.9	8006.6	85244.0
2018-12-07 10:00:00	NQ	Futures	8006.01	8024.49	7895.14	7924.47	118090.0
2018-12-07 11:00:00	NQ	Futures	7924.17	7931.21	7832.07	7832.95	113426.0
2018-12-07 12:00:00	NQ	Futures	7832.95	7870.21	7805.09	7857.59	93516.0
2018-12-07 13:00:00	NQ	Futures	7857.3	7878.71	7803.92	7806.56	76867.0
2018-12-07 14:00:00	NQ	Futures	7806.26	7830.9	7752.88	7759.33	100899.0
2018-12-07 15:00:00	NQ	Futures	7759.63	7819.17	7737.33	7761.97	117799.0
2018-12-07 16:00:00	NQ	Futures	7761.68	7780.45	7754.35	7780.45	17114.0
2018-12-07 00:00:00	YM	Futures	27029.2	27031.3	27000.9	27017.2	949.0
2018-12-07 01:00:00	YM	Futures	27017.2	27021.6	26990.1	27004.2	965.0
2018-12-07 02:00:00	YM	Futures	27002.0	27028.1	26851.0	26857.5	6493.0
2018-12-07 03:00:00	YM	Futures	26857.5	26981.4	26841.2	26933.6	9952.0
2018-12-07 04:00:00	YM	Futures	26932.5	27006.4	26902.0	26989.0	5554.0
2018-12-07 05:00:00	YM	Futures	26987.9	27004.2	26937.9	26971.6	4526.0
2018-12-07 06:00:00	YM	Futures	26971.6	26972.7	26916.2	26918.3	3984.0
2018-12-07 07:00:00	YM	Futures	26919.4	26946.6	26905.3	26936.8	3727.0
2018-12-07 08:00:00	YM	Futures	26936.8	27138.9	26930.3	27072.6	14391.0
2018-12-07 09:00:00	YM	Futures	27073.7	27286.7	27041.1	27195.4	34299.0
2018-12-07 10:00:00	YM	Futures	27194.3	27223.7	26827.1	26906.4	47375.0
2018-12-07 11:00:00	YM	Futures	26907.5	26936.8	26643.5	26647.8	53578.0
2018-12-07 12:00:00	YM	Futures	26646.7	26797.7	26591.3	26774.9	43676.0
2018-12-07 13:00:00	YM	Futures	26773.8	26843.4	26563.1	26566.3	37146.0
2018-12-07 14:00:00	YM	Futures	26566.3	26631.5	26431.6	26452.2	47413.0
2018-12-07 15:00:00	YM	Futures	26452.2	26683.7	26399.0	26516.3	60427.0

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

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