PREVIEW / futures_1hour / 2017-06-06

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-06-06.parquet
  size:    52 KB
  rows:    1,630

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-06-06 00:00:00	ES	Futures	2657.95	2658.23	2657.68	2658.23	1360.0
2017-06-06 01:00:00	ES	Futures	2658.23	2658.5	2655.77	2656.32	6644.0
2017-06-06 02:00:00	ES	Futures	2656.59	2656.86	2654.4	2655.5	11760.0
2017-06-06 03:00:00	ES	Futures	2655.77	2657.41	2654.4	2656.59	18604.0
2017-06-06 04:00:00	ES	Futures	2656.86	2658.23	2655.77	2657.13	13784.0
2017-06-06 05:00:00	ES	Futures	2657.41	2657.95	2655.77	2656.86	10558.0
2017-06-06 06:00:00	ES	Futures	2656.86	2657.13	2654.68	2654.68	10134.0
2017-06-06 07:00:00	ES	Futures	2654.68	2655.22	2650.85	2653.04	38161.0
2017-06-06 08:00:00	ES	Futures	2653.04	2654.13	2652.49	2653.86	17856.0
2017-06-06 09:00:00	ES	Futures	2653.86	2657.95	2651.67	2657.41	171498.0
2017-06-06 10:00:00	ES	Futures	2657.68	2659.59	2655.5	2656.59	181183.0
2017-06-06 11:00:00	ES	Futures	2656.32	2659.59	2654.4	2657.68	136286.0
2017-06-06 12:00:00	ES	Futures	2657.68	2658.5	2656.32	2657.95	81904.0
2017-06-06 13:00:00	ES	Futures	2657.68	2658.23	2654.95	2656.32	99934.0
2017-06-06 14:00:00	ES	Futures	2656.32	2661.23	2656.04	2659.87	117243.0
2017-06-06 15:00:00	ES	Futures	2660.14	2660.69	2652.49	2653.58	248252.0
2017-06-06 16:00:00	ES	Futures	2653.31	2656.32	2652.76	2654.95	79006.0
2017-06-06 18:00:00	ES	Futures	2654.4	2656.04	2654.13	2656.04	3767.0
2017-06-06 19:00:00	ES	Futures	2655.77	2656.04	2655.22	2655.77	1624.0
2017-06-06 20:00:00	ES	Futures	2655.5	2657.13	2655.5	2656.59	5641.0
2017-06-06 21:00:00	ES	Futures	2656.59	2657.95	2656.32	2657.13	3946.0
2017-06-06 22:00:00	ES	Futures	2656.86	2657.95	2656.86	2657.41	2022.0
2017-06-06 23:00:00	ES	Futures	2657.13	2657.68	2657.13	2657.41	646.0
2017-06-06 00:00:00	NQ	Futures	7010.47	7011.36	7008.68	7010.77	262.0
2017-06-06 01:00:00	NQ	Futures	7010.77	7011.96	7003.91	7005.4	1124.0
2017-06-06 02:00:00	NQ	Futures	7005.7	7006.59	7000.63	7004.8	1933.0
2017-06-06 03:00:00	NQ	Futures	7004.8	7011.66	7000.93	7010.47	3309.0
2017-06-06 04:00:00	NQ	Futures	7010.77	7013.75	7007.49	7011.06	2721.0
2017-06-06 05:00:00	NQ	Futures	7011.06	7013.15	7006.89	7010.47	2118.0
2017-06-06 06:00:00	NQ	Futures	7010.77	7011.96	7005.7	7006.89	2040.0
2017-06-06 07:00:00	NQ	Futures	7006.89	7007.79	6993.77	6999.44	5996.0
2017-06-06 08:00:00	NQ	Futures	6999.44	7002.42	6996.46	7002.12	4108.0
2017-06-06 09:00:00	NQ	Futures	7002.12	7021.5	7000.03	7017.92	43107.0
2017-06-06 10:00:00	NQ	Futures	7017.92	7028.06	7008.98	7019.41	37529.0
2017-06-06 11:00:00	NQ	Futures	7019.41	7020.61	7008.98	7016.73	25369.0
2017-06-06 12:00:00	NQ	Futures	7016.43	7018.22	7011.66	7015.84	12366.0
2017-06-06 13:00:00	NQ	Futures	7016.43	7017.03	7006.29	7011.36	14036.0
2017-06-06 14:00:00	NQ	Futures	7011.06	7022.1	7010.17	7018.82	19265.0
2017-06-06 15:00:00	NQ	Futures	7019.11	7020.9	6974.69	6985.72	62104.0
2017-06-06 16:00:00	NQ	Futures	6986.32	6994.07	6985.42	6991.98	6016.0
2017-06-06 18:00:00	NQ	Futures	6991.09	6995.86	6990.49	6994.07	864.0
2017-06-06 19:00:00	NQ	Futures	6994.07	6995.86	6992.28	6995.26	401.0
2017-06-06 20:00:00	NQ	Futures	6995.26	6998.54	6993.18	6996.75	1582.0
2017-06-06 21:00:00	NQ	Futures	6997.35	7000.63	6997.05	6997.65	1222.0
2017-06-06 22:00:00	NQ	Futures	6997.65	6999.74	6996.46	6997.95	556.0
2017-06-06 23:00:00	NQ	Futures	6997.95	6998.24	6997.05	6997.65	277.0
2017-06-06 00:00:00	YM	Futures	23004.1	23007.4	23001.9	23006.3	254.0
2017-06-06 01:00:00	YM	Futures	23006.3	23010.6	22982.4	22986.7	1481.0
2017-06-06 02:00:00	YM	Futures	22986.7	22990.0	22973.7	22981.3	1879.0
2017-06-06 03:00:00	YM	Futures	22982.4	22995.4	22971.5	22988.9	3044.0

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

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