PREVIEW / futures_1hour / 2019-01-18

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-01-18.parquet
  size:    49 KB
  rows:    1,438

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-18 00:00:00	ES	Futures	2869.29	2870.11	2868.2	2869.56	3503.0
2019-01-18 01:00:00	ES	Futures	2869.83	2870.92	2869.29	2870.11	3704.0
2019-01-18 02:00:00	ES	Futures	2870.38	2870.92	2866.58	2868.2	9805.0
2019-01-18 03:00:00	ES	Futures	2867.93	2872.01	2866.85	2869.83	17826.0
2019-01-18 04:00:00	ES	Futures	2869.83	2873.09	2869.02	2871.74	12497.0
2019-01-18 05:00:00	ES	Futures	2871.46	2872.82	2867.12	2869.83	16874.0
2019-01-18 06:00:00	ES	Futures	2869.83	2877.17	2869.02	2876.08	20404.0
2019-01-18 07:00:00	ES	Futures	2876.35	2877.98	2874.18	2875.81	28776.0
2019-01-18 08:00:00	ES	Futures	2876.08	2878.52	2873.36	2877.71	33288.0
2019-01-18 09:00:00	ES	Futures	2877.44	2887.22	2876.08	2880.43	277109.0
2019-01-18 10:00:00	ES	Futures	2880.15	2893.73	2875.54	2892.38	300675.0
2019-01-18 11:00:00	ES	Futures	2892.38	2901.88	2891.29	2901.88	185791.0
2019-01-18 12:00:00	ES	Futures	2902.15	2907.58	2898.62	2904.33	188627.0
2019-01-18 13:00:00	ES	Futures	2904.6	2906.5	2896.18	2901.88	112307.0
2019-01-18 14:00:00	ES	Futures	2901.61	2902.15	2891.83	2897.26	111377.0
2019-01-18 15:00:00	ES	Futures	2896.99	2902.97	2893.46	2901.07	214346.0
2019-01-18 16:00:00	ES	Futures	2901.07	2908.94	2899.44	2908.13	83428.0
2019-01-18 00:00:00	NQ	Futures	7871.0	7876.84	7869.83	7876.26	1748.0
2019-01-18 01:00:00	NQ	Futures	7876.55	7879.76	7870.7	7877.13	2202.0
2019-01-18 02:00:00	NQ	Futures	7877.42	7878.59	7863.69	7869.24	3838.0
2019-01-18 03:00:00	NQ	Futures	7868.95	7879.47	7864.28	7873.04	5751.0
2019-01-18 04:00:00	NQ	Futures	7873.04	7891.16	7871.58	7885.61	4262.0
2019-01-18 05:00:00	NQ	Futures	7885.31	7889.11	7867.78	7874.5	5400.0
2019-01-18 06:00:00	NQ	Futures	7874.5	7894.08	7870.41	7890.87	6984.0
2019-01-18 07:00:00	NQ	Futures	7890.87	7898.17	7884.73	7892.33	6594.0
2019-01-18 08:00:00	NQ	Futures	7892.62	7903.72	7888.82	7899.92	9224.0
2019-01-18 09:00:00	NQ	Futures	7899.92	7932.94	7876.84	7889.11	85934.0
2019-01-18 10:00:00	NQ	Futures	7888.82	7943.46	7873.04	7942.0	91753.0
2019-01-18 11:00:00	NQ	Futures	7942.29	7967.13	7938.78	7962.74	62333.0
2019-01-18 12:00:00	NQ	Futures	7962.74	7980.57	7956.9	7972.39	49468.0
2019-01-18 13:00:00	NQ	Futures	7972.09	7975.6	7944.63	7954.56	29765.0
2019-01-18 14:00:00	NQ	Futures	7954.56	7954.85	7912.49	7931.77	39368.0
2019-01-18 15:00:00	NQ	Futures	7931.77	7948.13	7917.16	7941.71	48969.0
2019-01-18 16:00:00	NQ	Futures	7941.41	7956.9	7931.19	7953.98	12576.0
2019-01-18 00:00:00	YM	Futures	26491.2	26499.9	26481.5	26496.7	974.0
2019-01-18 01:00:00	YM	Futures	26497.8	26508.6	26490.2	26503.2	1076.0
2019-01-18 02:00:00	YM	Futures	26504.3	26513.0	26464.1	26478.2	2928.0
2019-01-18 03:00:00	YM	Futures	26477.1	26515.1	26466.3	26498.8	4828.0
2019-01-18 04:00:00	YM	Futures	26498.8	26523.8	26492.3	26513.0	3222.0
2019-01-18 05:00:00	YM	Futures	26513.0	26522.7	26478.2	26503.2	3871.0
2019-01-18 06:00:00	YM	Futures	26502.1	26586.8	26501.0	26579.2	5429.0
2019-01-18 07:00:00	YM	Futures	26580.3	26593.3	26562.9	26580.3	5221.0
2019-01-18 08:00:00	YM	Futures	26581.4	26592.2	26551.0	26586.8	5350.0
2019-01-18 09:00:00	YM	Futures	26585.7	26675.8	26540.1	26577.0	34751.0
2019-01-18 10:00:00	YM	Futures	26577.0	26682.3	26528.2	26661.7	37259.0
2019-01-18 11:00:00	YM	Futures	26661.7	26774.6	26653.0	26774.6	21529.0
2019-01-18 12:00:00	YM	Futures	26775.7	26847.4	26752.9	26818.0	22858.0
2019-01-18 13:00:00	YM	Futures	26819.1	26834.3	26733.4	26795.2	13745.0
2019-01-18 14:00:00	YM	Futures	26795.2	26805.0	26706.2	26757.2	14061.0
2019-01-18 15:00:00	YM	Futures	26757.2	26814.8	26729.0	26801.8	17254.0

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

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