PREVIEW / futures_1hour / 2018-10-03

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-10-03.parquet
  size:    56 KB
  rows:    1,679

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-10-03 00:00:00	ES	Futures	3190.0	3190.81	3188.91	3189.72	4702.0
2018-10-03 01:00:00	ES	Futures	3189.72	3192.17	3188.91	3189.18	6150.0
2018-10-03 02:00:00	ES	Futures	3189.18	3194.08	3189.18	3192.99	7557.0
2018-10-03 03:00:00	ES	Futures	3192.99	3193.8	3191.9	3192.99	8217.0
2018-10-03 04:00:00	ES	Futures	3193.26	3194.35	3191.9	3193.53	7262.0
2018-10-03 05:00:00	ES	Futures	3193.53	3193.8	3190.27	3193.26	12773.0
2018-10-03 06:00:00	ES	Futures	3193.26	3194.62	3193.26	3193.8	10306.0
2018-10-03 07:00:00	ES	Futures	3193.8	3197.07	3193.53	3196.25	17696.0
2018-10-03 08:00:00	ES	Futures	3196.52	3198.7	3196.25	3198.43	23014.0
2018-10-03 09:00:00	ES	Futures	3198.16	3199.79	3195.16	3195.71	113557.0
2018-10-03 10:00:00	ES	Futures	3195.71	3203.87	3195.44	3197.61	178512.0
2018-10-03 11:00:00	ES	Futures	3197.34	3200.06	3194.08	3199.79	117439.0
2018-10-03 12:00:00	ES	Futures	3199.79	3200.88	3196.8	3199.24	78807.0
2018-10-03 13:00:00	ES	Futures	3198.97	3200.88	3197.07	3198.97	78535.0
2018-10-03 14:00:00	ES	Futures	3198.97	3200.6	3185.92	3189.45	190042.0
2018-10-03 15:00:00	ES	Futures	3189.18	3190.81	3182.92	3188.09	257997.0
2018-10-03 16:00:00	ES	Futures	3188.09	3190.0	3182.11	3184.01	63913.0
2018-10-03 18:00:00	ES	Futures	3183.47	3183.74	3180.75	3182.38	8437.0
2018-10-03 19:00:00	ES	Futures	3182.38	3182.92	3181.29	3182.38	4929.0
2018-10-03 20:00:00	ES	Futures	3182.38	3182.92	3177.76	3179.93	13725.0
2018-10-03 21:00:00	ES	Futures	3180.2	3180.2	3176.4	3177.21	10551.0
2018-10-03 22:00:00	ES	Futures	3176.94	3178.57	3175.04	3178.57	8863.0
2018-10-03 23:00:00	ES	Futures	3178.3	3179.39	3174.76	3174.76	10401.0
2018-10-03 00:00:00	NQ	Futures	8990.08	8994.18	8985.97	8990.67	2366.0
2018-10-03 01:00:00	NQ	Futures	8990.37	8998.29	8979.52	8981.87	3822.0
2018-10-03 02:00:00	NQ	Futures	8981.87	9003.28	8981.57	8996.82	3689.0
2018-10-03 03:00:00	NQ	Futures	8996.82	8999.76	8992.13	8997.41	2859.0
2018-10-03 04:00:00	NQ	Futures	8997.7	9006.5	8995.36	9002.69	3916.0
2018-10-03 05:00:00	NQ	Futures	9002.98	9004.45	8991.55	9002.69	3986.0
2018-10-03 06:00:00	NQ	Futures	9002.98	9006.21	8999.46	9000.93	2707.0
2018-10-03 07:00:00	NQ	Futures	9000.64	9013.54	8999.76	9011.49	4761.0
2018-10-03 08:00:00	NQ	Futures	9012.08	9022.64	9007.97	9021.46	9312.0
2018-10-03 09:00:00	NQ	Futures	9021.46	9031.73	9006.21	9015.6	59908.0
2018-10-03 10:00:00	NQ	Futures	9015.6	9038.48	9001.22	9005.92	64965.0
2018-10-03 11:00:00	NQ	Futures	9005.92	9024.4	8991.25	9024.1	53010.0
2018-10-03 12:00:00	NQ	Futures	9024.1	9029.38	9004.74	9018.53	28349.0
2018-10-03 13:00:00	NQ	Futures	9018.53	9031.73	9011.49	9017.65	21909.0
2018-10-03 14:00:00	NQ	Futures	9017.65	9026.45	8985.09	8996.82	42897.0
2018-10-03 15:00:00	NQ	Futures	8996.82	9001.81	8974.83	8990.96	54707.0
2018-10-03 16:00:00	NQ	Futures	8990.96	8994.77	8970.13	8977.17	9743.0
2018-10-03 18:00:00	NQ	Futures	8976.59	8976.59	8965.44	8971.89	2735.0
2018-10-03 19:00:00	NQ	Futures	8971.31	8972.48	8966.61	8970.43	1390.0
2018-10-03 20:00:00	NQ	Futures	8970.43	8972.77	8953.71	8965.15	4341.0
2018-10-03 21:00:00	NQ	Futures	8965.44	8965.44	8946.08	8949.01	5894.0
2018-10-03 22:00:00	NQ	Futures	8949.01	8953.12	8940.51	8953.12	3828.0
2018-10-03 23:00:00	NQ	Futures	8953.41	8955.47	8940.51	8943.73	3683.0
2018-10-03 00:00:00	YM	Futures	29155.5	29168.5	29138.1	29160.9	1700.0
2018-10-03 01:00:00	YM	Futures	29159.8	29182.6	29146.8	29150.0	1513.0
2018-10-03 02:00:00	YM	Futures	29150.0	29203.3	29149.0	29189.2	2083.0
2018-10-03 03:00:00	YM	Futures	29188.1	29197.8	29172.9	29183.7	2376.0

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

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