PREVIEW / futures_1hour / 2018-01-12

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-01-12.parquet
  size:    47 KB
  rows:    1,384

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-01-12 00:00:00	ES	Futures	3027.11	3027.65	3026.56	3027.11	2987.0
2018-01-12 01:00:00	ES	Futures	3027.11	3029.57	3026.83	3028.47	4272.0
2018-01-12 02:00:00	ES	Futures	3028.47	3030.39	3028.2	3030.11	8693.0
2018-01-12 03:00:00	ES	Futures	3029.84	3035.03	3029.02	3034.49	30827.0
2018-01-12 04:00:00	ES	Futures	3034.49	3035.85	3033.39	3033.67	14197.0
2018-01-12 05:00:00	ES	Futures	3033.94	3034.76	3033.12	3034.49	8866.0
2018-01-12 06:00:00	ES	Futures	3034.49	3035.31	3033.94	3034.21	11060.0
2018-01-12 07:00:00	ES	Futures	3034.21	3035.03	3032.3	3032.3	16886.0
2018-01-12 08:00:00	ES	Futures	3032.3	3033.94	3024.92	3027.65	72229.0
2018-01-12 09:00:00	ES	Futures	3027.65	3036.67	3027.11	3036.67	177414.0
2018-01-12 10:00:00	ES	Futures	3036.4	3045.69	3034.49	3043.51	206153.0
2018-01-12 11:00:00	ES	Futures	3043.51	3044.05	3038.31	3043.51	128668.0
2018-01-12 12:00:00	ES	Futures	3043.51	3044.33	3040.77	3044.05	77251.0
2018-01-12 13:00:00	ES	Futures	3044.05	3045.69	3041.32	3044.87	72141.0
2018-01-12 14:00:00	ES	Futures	3044.87	3046.79	3042.69	3045.15	79869.0
2018-01-12 15:00:00	ES	Futures	3045.15	3048.97	3041.05	3046.51	255227.0
2018-01-12 16:00:00	ES	Futures	3046.51	3050.34	3045.69	3049.52	93454.0
2018-01-12 00:00:00	NQ	Futures	7976.01	7978.98	7973.94	7975.12	1252.0
2018-01-12 01:00:00	NQ	Futures	7975.12	7990.55	7974.53	7983.43	2316.0
2018-01-12 02:00:00	NQ	Futures	7983.43	7989.36	7981.94	7989.06	1681.0
2018-01-12 03:00:00	NQ	Futures	7989.36	8001.52	7986.39	7998.26	5001.0
2018-01-12 04:00:00	NQ	Futures	7998.26	7999.44	7990.84	7991.14	2625.0
2018-01-12 05:00:00	NQ	Futures	7991.44	7995.59	7989.06	7990.84	1845.0
2018-01-12 06:00:00	NQ	Futures	7990.84	7992.33	7987.88	7989.95	1943.0
2018-01-12 07:00:00	NQ	Futures	7989.95	7990.84	7986.99	7989.06	3415.0
2018-01-12 08:00:00	NQ	Futures	7988.77	7999.44	7953.47	7957.92	23637.0
2018-01-12 09:00:00	NQ	Futures	7957.62	7981.35	7952.58	7980.46	51922.0
2018-01-12 10:00:00	NQ	Futures	7980.46	8018.13	7978.09	8013.68	46619.0
2018-01-12 11:00:00	NQ	Futures	8013.68	8020.21	8005.67	8016.65	25815.0
2018-01-12 12:00:00	NQ	Futures	8016.65	8028.51	8010.42	8027.32	17880.0
2018-01-12 13:00:00	NQ	Futures	8027.32	8029.4	8017.83	8024.36	14134.0
2018-01-12 14:00:00	NQ	Futures	8024.36	8033.55	8019.91	8023.76	18362.0
2018-01-12 15:00:00	NQ	Futures	8023.76	8036.52	8013.38	8026.43	35518.0
2018-01-12 16:00:00	NQ	Futures	8026.43	8040.97	8025.54	8034.15	10904.0
2018-01-12 00:00:00	YM	Futures	27786.1	27788.3	27778.5	27779.6	883.0
2018-01-12 01:00:00	YM	Futures	27779.6	27804.6	27774.1	27801.3	1210.0
2018-01-12 02:00:00	YM	Futures	27801.3	27816.5	27797.0	27805.7	2229.0
2018-01-12 03:00:00	YM	Futures	27806.7	27888.3	27801.3	27880.7	6859.0
2018-01-12 04:00:00	YM	Futures	27881.7	27904.6	27873.0	27881.7	3372.0
2018-01-12 05:00:00	YM	Futures	27880.7	27889.3	27868.7	27886.1	1602.0
2018-01-12 06:00:00	YM	Futures	27886.1	27898.0	27880.7	27883.9	2098.0
2018-01-12 07:00:00	YM	Futures	27883.9	27894.8	27863.3	27878.5	3092.0
2018-01-12 08:00:00	YM	Futures	27878.5	27886.1	27816.5	27849.1	10240.0
2018-01-12 09:00:00	YM	Futures	27848.0	27950.2	27843.7	27943.7	25994.0
2018-01-12 10:00:00	YM	Futures	27944.8	27998.0	27913.3	27983.9	21344.0
2018-01-12 11:00:00	YM	Futures	27985.0	27996.9	27956.7	27994.8	13516.0
2018-01-12 12:00:00	YM	Futures	27994.8	28003.5	27940.4	27967.6	11813.0
2018-01-12 13:00:00	YM	Futures	27967.6	27991.5	27955.6	27982.8	7460.0
2018-01-12 14:00:00	YM	Futures	27982.8	27989.3	27957.8	27985.0	8521.0
2018-01-12 15:00:00	YM	Futures	27983.9	28023.0	27951.3	28013.3	19001.0

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

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