PREVIEW / futures_1hour / 2019-02-01

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-02-01.parquet
  size:    48 KB
  rows:    1,451

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-02-01 00:00:00	ES	Futures	2936.92	2937.73	2934.2	2935.29	6484.0
2019-02-01 01:00:00	ES	Futures	2935.56	2939.9	2934.2	2939.63	5151.0
2019-02-01 02:00:00	ES	Futures	2939.63	2942.08	2939.36	2940.72	8490.0
2019-02-01 03:00:00	ES	Futures	2940.72	2941.53	2936.92	2937.46	18275.0
2019-02-01 04:00:00	ES	Futures	2937.46	2939.9	2936.37	2937.73	13366.0
2019-02-01 05:00:00	ES	Futures	2937.73	2939.09	2935.01	2936.64	9901.0
2019-02-01 06:00:00	ES	Futures	2936.64	2938.27	2934.47	2935.56	10472.0
2019-02-01 07:00:00	ES	Futures	2935.83	2936.37	2931.21	2931.48	16143.0
2019-02-01 08:00:00	ES	Futures	2931.48	2943.16	2929.04	2941.26	69189.0
2019-02-01 09:00:00	ES	Futures	2941.26	2942.62	2932.03	2932.03	202737.0
2019-02-01 10:00:00	ES	Futures	2932.3	2950.49	2932.3	2938.54	307703.0
2019-02-01 11:00:00	ES	Futures	2938.82	2948.32	2934.74	2947.78	148026.0
2019-02-01 12:00:00	ES	Futures	2948.05	2948.32	2937.19	2940.72	98222.0
2019-02-01 13:00:00	ES	Futures	2940.72	2942.35	2935.01	2938.54	72697.0
2019-02-01 14:00:00	ES	Futures	2938.54	2939.09	2929.31	2931.21	105557.0
2019-02-01 15:00:00	ES	Futures	2930.94	2939.63	2928.22	2938.0	187641.0
2019-02-01 16:00:00	ES	Futures	2938.0	2939.63	2936.92	2938.0	59925.0
2019-02-01 00:00:00	NQ	Futures	8044.56	8053.32	8033.45	8042.51	3569.0
2019-02-01 01:00:00	NQ	Futures	8043.39	8057.41	8039.3	8056.54	2252.0
2019-02-01 02:00:00	NQ	Futures	8056.54	8068.22	8055.37	8062.67	3554.0
2019-02-01 03:00:00	NQ	Futures	8062.67	8067.93	8050.69	8052.45	5487.0
2019-02-01 04:00:00	NQ	Futures	8052.45	8057.12	8044.26	8048.94	4948.0
2019-02-01 05:00:00	NQ	Futures	8049.23	8055.95	8042.22	8046.89	3087.0
2019-02-01 06:00:00	NQ	Futures	8046.89	8052.74	8039.01	8042.8	4290.0
2019-02-01 07:00:00	NQ	Futures	8042.8	8048.65	8031.12	8031.12	6914.0
2019-02-01 08:00:00	NQ	Futures	8031.41	8063.84	8020.31	8050.98	22096.0
2019-02-01 09:00:00	NQ	Futures	8050.98	8080.2	8030.82	8038.13	79629.0
2019-02-01 10:00:00	NQ	Futures	8038.13	8096.57	8038.13	8057.71	84992.0
2019-02-01 11:00:00	NQ	Futures	8057.71	8089.55	8048.36	8085.76	43778.0
2019-02-01 12:00:00	NQ	Futures	8085.76	8086.63	8048.36	8055.66	37464.0
2019-02-01 13:00:00	NQ	Futures	8055.66	8062.67	8030.24	8046.6	33634.0
2019-02-01 14:00:00	NQ	Futures	8046.31	8047.48	8020.31	8024.1	35183.0
2019-02-01 15:00:00	NQ	Futures	8024.1	8042.51	8018.26	8040.17	43388.0
2019-02-01 16:00:00	NQ	Futures	8039.88	8043.97	8034.33	8041.34	8507.0
2019-02-01 00:00:00	YM	Futures	27136.2	27141.6	27112.3	27123.1	1891.0
2019-02-01 01:00:00	YM	Futures	27123.1	27164.4	27111.2	27164.4	1533.0
2019-02-01 02:00:00	YM	Futures	27164.4	27179.6	27156.8	27166.6	2942.0
2019-02-01 03:00:00	YM	Futures	27166.6	27177.4	27136.2	27144.8	4839.0
2019-02-01 04:00:00	YM	Futures	27144.8	27166.6	27135.1	27145.9	3245.0
2019-02-01 05:00:00	YM	Futures	27147.0	27157.9	27124.2	27148.1	3350.0
2019-02-01 06:00:00	YM	Futures	27148.1	27163.3	27134.0	27142.7	2604.0
2019-02-01 07:00:00	YM	Futures	27144.8	27151.4	27091.6	27094.9	4049.0
2019-02-01 08:00:00	YM	Futures	27094.9	27205.6	27084.0	27194.8	12658.0
2019-02-01 09:00:00	YM	Futures	27193.7	27208.9	27137.2	27142.7	28167.0
2019-02-01 10:00:00	YM	Futures	27145.9	27297.9	27145.9	27190.4	38387.0
2019-02-01 11:00:00	YM	Futures	27189.4	27283.8	27156.8	27280.6	19296.0
2019-02-01 12:00:00	YM	Futures	27280.6	27282.7	27165.5	27206.7	14326.0
2019-02-01 13:00:00	YM	Futures	27206.7	27214.3	27143.8	27167.6	8931.0
2019-02-01 14:00:00	YM	Futures	27169.8	27169.8	27075.4	27092.7	14704.0
2019-02-01 15:00:00	YM	Futures	27092.7	27169.8	27069.9	27154.6	16558.0

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

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