PREVIEW / futures_1hour / 2018-09-04

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-09-04.parquet
  size:    55 KB
  rows:    1,708

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-09-04 00:00:00	ES	Futures	3166.6	3168.24	3165.51	3167.97	3240.0
2018-09-04 01:00:00	ES	Futures	3167.69	3170.69	3167.15	3169.33	7774.0
2018-09-04 02:00:00	ES	Futures	3169.33	3172.33	3169.33	3171.78	7253.0
2018-09-04 03:00:00	ES	Futures	3171.78	3173.69	3169.6	3170.69	15511.0
2018-09-04 04:00:00	ES	Futures	3170.69	3171.51	3166.88	3167.97	11977.0
2018-09-04 05:00:00	ES	Futures	3168.24	3168.24	3162.79	3163.33	18293.0
2018-09-04 06:00:00	ES	Futures	3163.33	3166.06	3161.15	3162.79	16766.0
2018-09-04 07:00:00	ES	Futures	3162.52	3163.33	3151.62	3156.52	58970.0
2018-09-04 08:00:00	ES	Futures	3156.52	3158.97	3155.43	3157.88	33080.0
2018-09-04 09:00:00	ES	Futures	3157.88	3158.97	3145.62	3150.26	257984.0
2018-09-04 10:00:00	ES	Futures	3150.26	3161.7	3149.98	3159.79	269737.0
2018-09-04 11:00:00	ES	Futures	3159.79	3160.34	3149.71	3150.26	159576.0
2018-09-04 12:00:00	ES	Futures	3150.53	3152.16	3144.81	3151.35	159354.0
2018-09-04 13:00:00	ES	Futures	3151.07	3155.98	3150.53	3154.89	94127.0
2018-09-04 14:00:00	ES	Futures	3154.89	3159.52	3153.8	3158.43	87056.0
2018-09-04 15:00:00	ES	Futures	3158.43	3159.25	3152.44	3157.61	160361.0
2018-09-04 16:00:00	ES	Futures	3157.61	3160.34	3157.34	3159.25	52830.0
2018-09-04 18:00:00	ES	Futures	3159.25	3159.79	3157.88	3158.16	3079.0
2018-09-04 19:00:00	ES	Futures	3158.16	3158.16	3156.79	3157.88	2067.0
2018-09-04 20:00:00	ES	Futures	3157.88	3158.16	3155.7	3158.16	6379.0
2018-09-04 21:00:00	ES	Futures	3158.16	3161.15	3156.79	3157.88	11332.0
2018-09-04 22:00:00	ES	Futures	3157.88	3159.79	3156.79	3157.88	5023.0
2018-09-04 23:00:00	ES	Futures	3157.88	3158.43	3156.25	3158.16	4509.0
2018-09-04 00:00:00	NQ	Futures	9035.1	9040.7	9031.57	9038.93	1048.0
2018-09-04 01:00:00	NQ	Futures	9038.64	9048.06	9036.58	9042.46	2989.0
2018-09-04 02:00:00	NQ	Futures	9042.17	9052.47	9042.17	9050.12	3213.0
2018-09-04 03:00:00	NQ	Futures	9050.12	9060.72	9044.82	9047.76	4900.0
2018-09-04 04:00:00	NQ	Futures	9048.06	9052.18	9039.52	9041.88	3562.0
2018-09-04 05:00:00	NQ	Futures	9041.88	9042.17	9028.92	9031.87	4937.0
2018-09-04 06:00:00	NQ	Futures	9032.16	9039.23	9022.15	9026.57	4340.0
2018-09-04 07:00:00	NQ	Futures	9026.57	9027.74	8983.88	8995.06	12641.0
2018-09-04 08:00:00	NQ	Futures	8995.65	9002.13	8990.94	8995.36	9065.0
2018-09-04 09:00:00	NQ	Futures	8995.65	9005.37	8934.71	8956.2	74843.0
2018-09-04 10:00:00	NQ	Futures	8956.2	9009.2	8956.2	9001.83	82932.0
2018-09-04 11:00:00	NQ	Futures	9001.83	9005.07	8960.32	8961.79	55913.0
2018-09-04 12:00:00	NQ	Futures	8961.79	8971.22	8939.12	8965.62	53046.0
2018-09-04 13:00:00	NQ	Futures	8965.33	8978.28	8957.67	8975.04	27238.0
2018-09-04 14:00:00	NQ	Futures	8974.45	8990.65	8967.98	8987.7	23974.0
2018-09-04 15:00:00	NQ	Futures	8987.7	8992.12	8969.45	8983.58	35566.0
2018-09-04 16:00:00	NQ	Futures	8983.29	9003.01	8982.7	8999.77	11494.0
2018-09-04 18:00:00	NQ	Futures	9000.07	9000.36	8989.47	8990.35	1596.0
2018-09-04 19:00:00	NQ	Futures	8990.06	8990.94	8986.53	8990.35	890.0
2018-09-04 20:00:00	NQ	Futures	8990.06	8990.35	8982.4	8989.76	2241.0
2018-09-04 21:00:00	NQ	Futures	8989.76	9001.25	8986.23	8989.47	3475.0
2018-09-04 22:00:00	NQ	Futures	8989.76	8996.54	8986.23	8989.17	2362.0
2018-09-04 23:00:00	NQ	Futures	8989.17	8991.24	8985.05	8990.65	1484.0
2018-09-04 00:00:00	YM	Futures	28264.5	28281.9	28252.6	28277.6	931.0
2018-09-04 01:00:00	YM	Futures	28277.6	28308.0	28272.1	28297.1	1592.0
2018-09-04 02:00:00	YM	Futures	28296.1	28325.4	28296.1	28314.5	1673.0
2018-09-04 03:00:00	YM	Futures	28315.6	28340.6	28297.1	28311.3	2635.0

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

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