PREVIEW / futures_1hour / 2017-09-26

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-09-26.parquet
  size:    53 KB
  rows:    1,638

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
2017-09-26 00:00:00	ES	Futures	2730.11	2730.39	2729.02	2729.29	6983.0
2017-09-26 01:00:00	ES	Futures	2729.57	2730.11	2728.75	2729.57	5430.0
2017-09-26 02:00:00	ES	Futures	2729.29	2730.94	2729.02	2730.39	11155.0
2017-09-26 03:00:00	ES	Futures	2730.39	2730.94	2729.02	2730.66	21161.0
2017-09-26 04:00:00	ES	Futures	2730.94	2731.21	2729.57	2730.94	10345.0
2017-09-26 05:00:00	ES	Futures	2730.94	2732.3	2730.39	2731.21	11532.0
2017-09-26 06:00:00	ES	Futures	2731.21	2732.58	2730.94	2730.94	11258.0
2017-09-26 07:00:00	ES	Futures	2730.94	2732.03	2729.29	2730.66	18048.0
2017-09-26 08:00:00	ES	Futures	2730.66	2733.67	2729.84	2733.12	22500.0
2017-09-26 09:00:00	ES	Futures	2733.4	2736.95	2732.58	2735.86	148452.0
2017-09-26 10:00:00	ES	Futures	2735.59	2736.68	2730.39	2730.94	143957.0
2017-09-26 11:00:00	ES	Futures	2730.94	2731.76	2727.11	2730.94	136717.0
2017-09-26 12:00:00	ES	Futures	2730.94	2733.12	2729.29	2731.48	100648.0
2017-09-26 13:00:00	ES	Futures	2731.48	2734.77	2731.21	2733.94	70025.0
2017-09-26 14:00:00	ES	Futures	2733.94	2734.49	2731.48	2732.3	68610.0
2017-09-26 15:00:00	ES	Futures	2732.03	2734.49	2728.47	2730.11	236735.0
2017-09-26 16:00:00	ES	Futures	2730.11	2731.21	2729.29	2730.39	68179.0
2017-09-26 18:00:00	ES	Futures	2730.11	2730.94	2729.29	2729.84	3969.0
2017-09-26 19:00:00	ES	Futures	2730.11	2730.94	2729.84	2730.66	2002.0
2017-09-26 20:00:00	ES	Futures	2730.94	2731.21	2729.29	2729.84	7361.0
2017-09-26 21:00:00	ES	Futures	2730.11	2731.21	2729.57	2730.94	4705.0
2017-09-26 22:00:00	ES	Futures	2730.94	2732.58	2730.94	2732.3	5025.0
2017-09-26 23:00:00	ES	Futures	2732.3	2732.85	2731.76	2732.3	3147.0
2017-09-26 00:00:00	NQ	Futures	6990.18	6990.77	6985.72	6988.69	2007.0
2017-09-26 01:00:00	NQ	Futures	6988.39	6990.48	6984.83	6986.31	2129.0
2017-09-26 02:00:00	NQ	Futures	6986.61	6994.05	6985.12	6989.88	1681.0
2017-09-26 03:00:00	NQ	Futures	6989.58	6990.18	6984.83	6989.58	2028.0
2017-09-26 04:00:00	NQ	Futures	6989.88	6994.64	6988.39	6993.75	1885.0
2017-09-26 05:00:00	NQ	Futures	6993.75	7002.37	6992.56	7000.59	3464.0
2017-09-26 06:00:00	NQ	Futures	7000.89	7005.05	6999.4	6999.4	1898.0
2017-09-26 07:00:00	NQ	Futures	6999.4	7007.13	6995.83	7002.67	3162.0
2017-09-26 08:00:00	NQ	Futures	7002.37	7019.33	7001.78	7018.73	7403.0
2017-09-26 09:00:00	NQ	Futures	7018.43	7033.9	7013.38	7018.73	51169.0
2017-09-26 10:00:00	NQ	Futures	7018.73	7031.52	6995.83	7000.29	56907.0
2017-09-26 11:00:00	NQ	Futures	7000.59	7000.59	6978.58	6994.64	52993.0
2017-09-26 12:00:00	NQ	Futures	6994.34	7008.92	6988.1	7003.26	40023.0
2017-09-26 13:00:00	NQ	Futures	7003.56	7029.14	7003.56	7022.3	30372.0
2017-09-26 14:00:00	NQ	Futures	7022.6	7025.27	7009.21	7012.48	21354.0
2017-09-26 15:00:00	NQ	Futures	7012.48	7020.52	6998.8	7004.75	38781.0
2017-09-26 16:00:00	NQ	Futures	7004.75	7011.0	7002.67	7008.62	7390.0
2017-09-26 18:00:00	NQ	Futures	7006.83	7010.11	7004.75	7007.43	1017.0
2017-09-26 19:00:00	NQ	Futures	7008.02	7009.81	7007.13	7009.51	517.0
2017-09-26 20:00:00	NQ	Futures	7009.51	7011.89	7002.97	7004.45	1783.0
2017-09-26 21:00:00	NQ	Futures	7004.16	7012.78	7002.97	7011.89	1506.0
2017-09-26 22:00:00	NQ	Futures	7011.89	7018.14	7011.59	7016.65	2696.0
2017-09-26 23:00:00	NQ	Futures	7016.65	7018.73	7014.86	7017.54	867.0
2017-09-26 00:00:00	YM	Futures	24207.5	24209.7	24198.8	24205.3	2699.0
2017-09-26 01:00:00	YM	Futures	24205.3	24209.7	24198.8	24203.2	1624.0
2017-09-26 02:00:00	YM	Futures	24203.2	24216.2	24199.9	24211.9	1412.0
2017-09-26 03:00:00	YM	Futures	24211.9	24223.8	24204.2	24223.8	2284.0

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

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