PREVIEW / futures_1hour / 2017-09-12

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-09-12.parquet
  size:    51 KB
  rows:    1,580

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-12 00:00:00	ES	Futures	2719.73	2720.27	2719.45	2720.0	750.0
2017-09-12 01:00:00	ES	Futures	2720.0	2720.82	2720.0	2720.0	1250.0
2017-09-12 02:00:00	ES	Futures	2720.27	2722.46	2720.0	2721.91	2678.0
2017-09-12 03:00:00	ES	Futures	2722.19	2722.46	2720.55	2722.19	5361.0
2017-09-12 04:00:00	ES	Futures	2722.19	2724.37	2721.64	2723.01	7559.0
2017-09-12 05:00:00	ES	Futures	2723.28	2723.83	2722.73	2723.01	3039.0
2017-09-12 06:00:00	ES	Futures	2723.28	2724.65	2723.01	2724.1	3961.0
2017-09-12 07:00:00	ES	Futures	2724.1	2725.47	2723.55	2725.19	4095.0
2017-09-12 08:00:00	ES	Futures	2725.19	2725.47	2722.19	2723.01	6932.0
2017-09-12 09:00:00	ES	Futures	2722.73	2727.93	2722.73	2726.29	48768.0
2017-09-12 10:00:00	ES	Futures	2726.01	2726.83	2721.91	2723.83	44563.0
2017-09-12 11:00:00	ES	Futures	2723.55	2725.47	2722.73	2725.19	22805.0
2017-09-12 12:00:00	ES	Futures	2725.19	2727.65	2724.37	2727.11	24646.0
2017-09-12 13:00:00	ES	Futures	2727.11	2728.75	2726.01	2726.01	18676.0
2017-09-12 14:00:00	ES	Futures	2726.01	2727.11	2724.37	2725.47	27511.0
2017-09-12 15:00:00	ES	Futures	2725.74	2729.29	2723.83	2729.29	36067.0
2017-09-12 16:00:00	ES	Futures	2729.02	2730.11	2727.65	2729.84	18117.0
2017-09-12 18:00:00	ES	Futures	2730.11	2730.39	2729.02	2730.11	900.0
2017-09-12 19:00:00	ES	Futures	2730.11	2730.11	2729.02	2729.29	676.0
2017-09-12 20:00:00	ES	Futures	2729.29	2729.57	2727.38	2728.2	2693.0
2017-09-12 21:00:00	ES	Futures	2728.2	2729.02	2727.38	2727.38	1050.0
2017-09-12 22:00:00	ES	Futures	2727.38	2727.65	2726.56	2726.83	1208.0
2017-09-12 23:00:00	ES	Futures	2727.11	2727.38	2726.83	2727.38	328.0
2017-09-12 00:00:00	NQ	Futures	7127.57	7131.14	7126.97	7126.97	171.0
2017-09-12 01:00:00	NQ	Futures	7127.27	7131.14	7126.68	7129.06	145.0
2017-09-12 02:00:00	NQ	Futures	7128.76	7134.72	7128.16	7131.74	548.0
2017-09-12 03:00:00	NQ	Futures	7132.04	7134.42	7127.57	7132.93	915.0
2017-09-12 04:00:00	NQ	Futures	7131.74	7137.69	7131.74	7136.5	613.0
2017-09-12 05:00:00	NQ	Futures	7136.8	7138.59	7134.42	7136.8	569.0
2017-09-12 06:00:00	NQ	Futures	7137.4	7141.86	7137.1	7137.99	660.0
2017-09-12 07:00:00	NQ	Futures	7137.69	7145.14	7137.1	7144.84	897.0
2017-09-12 08:00:00	NQ	Futures	7144.54	7146.63	7131.44	7135.01	2019.0
2017-09-12 09:00:00	NQ	Futures	7135.31	7150.79	7120.42	7128.46	11871.0
2017-09-12 10:00:00	NQ	Futures	7128.46	7129.36	7113.28	7121.32	10897.0
2017-09-12 11:00:00	NQ	Futures	7121.02	7129.65	7118.93	7122.51	4714.0
2017-09-12 12:00:00	NQ	Futures	7123.1	7132.63	7118.93	7129.36	4106.0
2017-09-12 13:00:00	NQ	Futures	7128.76	7144.24	7128.76	7134.42	4915.0
2017-09-12 14:00:00	NQ	Futures	7134.72	7141.27	7109.7	7115.96	12794.0
2017-09-12 15:00:00	NQ	Futures	7116.25	7140.37	7107.32	7140.37	8422.0
2017-09-12 16:00:00	NQ	Futures	7140.37	7147.82	7138.29	7146.63	2222.0
2017-09-12 18:00:00	NQ	Futures	7144.84	7146.92	7143.05	7145.43	267.0
2017-09-12 19:00:00	NQ	Futures	7145.73	7145.73	7143.35	7144.54	113.0
2017-09-12 20:00:00	NQ	Futures	7144.24	7145.43	7138.88	7140.97	308.0
2017-09-12 21:00:00	NQ	Futures	7141.27	7142.75	7137.1	7137.69	273.0
2017-09-12 22:00:00	NQ	Futures	7137.4	7138.59	7132.33	7135.61	387.0
2017-09-12 23:00:00	NQ	Futures	7135.61	7137.99	7135.61	7137.4	111.0
2017-09-12 00:00:00	YM	Futures	23962.8	23969.3	23960.6	23966.0	536.0
2017-09-12 01:00:00	YM	Futures	23966.0	23971.5	23963.9	23969.3	499.0
2017-09-12 02:00:00	YM	Futures	23969.3	23995.4	23966.0	23988.9	2746.0
2017-09-12 03:00:00	YM	Futures	23988.9	23992.1	23975.8	23981.3	2152.0

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

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