PREVIEW / futures_1hour / 2018-09-05

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-09-05.parquet
  size:    54 KB
  rows:    1,665

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-05 00:00:00	ES	Futures	3157.88	3158.16	3157.07	3157.07	2278.0
2018-09-05 01:00:00	ES	Futures	3157.34	3157.88	3154.34	3154.61	6865.0
2018-09-05 02:00:00	ES	Futures	3154.61	3154.61	3148.62	3149.17	14288.0
2018-09-05 03:00:00	ES	Futures	3149.17	3151.62	3144.53	3147.8	29471.0
2018-09-05 04:00:00	ES	Futures	3147.53	3148.89	3144.26	3147.53	22016.0
2018-09-05 05:00:00	ES	Futures	3147.53	3149.17	3145.35	3147.8	14482.0
2018-09-05 06:00:00	ES	Futures	3147.8	3152.44	3145.35	3151.89	18073.0
2018-09-05 07:00:00	ES	Futures	3151.62	3152.71	3149.44	3150.53	27116.0
2018-09-05 08:00:00	ES	Futures	3150.26	3151.89	3147.53	3149.17	30244.0
2018-09-05 09:00:00	ES	Futures	3148.89	3155.16	3146.17	3146.71	201870.0
2018-09-05 10:00:00	ES	Futures	3146.99	3148.89	3136.09	3144.26	392921.0
2018-09-05 11:00:00	ES	Futures	3144.26	3146.71	3137.99	3144.81	197278.0
2018-09-05 12:00:00	ES	Futures	3144.81	3151.35	3144.53	3145.62	127563.0
2018-09-05 13:00:00	ES	Futures	3145.62	3153.52	3145.35	3149.44	87928.0
2018-09-05 14:00:00	ES	Futures	3149.44	3151.89	3146.44	3148.35	95224.0
2018-09-05 15:00:00	ES	Futures	3148.35	3151.62	3143.99	3148.89	206365.0
2018-09-05 16:00:00	ES	Futures	3148.62	3150.53	3145.62	3149.44	51579.0
2018-09-05 18:00:00	ES	Futures	3148.08	3148.62	3145.9	3146.44	4139.0
2018-09-05 19:00:00	ES	Futures	3146.44	3146.99	3144.53	3145.08	3066.0
2018-09-05 20:00:00	ES	Futures	3145.35	3147.26	3144.26	3146.17	6200.0
2018-09-05 21:00:00	ES	Futures	3146.17	3149.44	3143.99	3148.35	9419.0
2018-09-05 22:00:00	ES	Futures	3148.35	3150.8	3148.08	3149.98	5103.0
2018-09-05 23:00:00	ES	Futures	3149.98	3150.8	3146.44	3146.99	5683.0
2018-09-05 00:00:00	NQ	Futures	8990.06	8991.82	8986.53	8986.53	833.0
2018-09-05 01:00:00	NQ	Futures	8986.53	8987.41	8974.75	8976.81	2929.0
2018-09-05 02:00:00	NQ	Futures	8976.81	8977.1	8961.79	8962.38	4539.0
2018-09-05 03:00:00	NQ	Futures	8962.38	8970.04	8944.72	8962.38	8395.0
2018-09-05 04:00:00	NQ	Futures	8962.68	8965.03	8948.84	8957.08	4902.0
2018-09-05 05:00:00	NQ	Futures	8957.08	8961.79	8949.72	8957.97	3764.0
2018-09-05 06:00:00	NQ	Futures	8957.97	8975.04	8952.08	8972.1	4382.0
2018-09-05 07:00:00	NQ	Futures	8972.1	8976.22	8962.97	8966.8	5138.0
2018-09-05 08:00:00	NQ	Futures	8966.8	8970.92	8957.67	8963.56	6025.0
2018-09-05 09:00:00	NQ	Futures	8962.97	8979.16	8897.32	8899.97	71460.0
2018-09-05 10:00:00	NQ	Futures	8899.97	8911.45	8836.37	8871.11	140700.0
2018-09-05 11:00:00	NQ	Futures	8871.11	8874.06	8837.26	8863.16	72296.0
2018-09-05 12:00:00	NQ	Futures	8863.16	8904.97	8862.87	8878.47	50473.0
2018-09-05 13:00:00	NQ	Futures	8878.77	8903.2	8875.53	8887.31	32462.0
2018-09-05 14:00:00	NQ	Futures	8887.31	8892.31	8866.4	8872.0	34310.0
2018-09-05 15:00:00	NQ	Futures	8871.7	8877.3	8844.91	8866.11	48920.0
2018-09-05 16:00:00	NQ	Futures	8866.11	8877.3	8863.75	8874.94	12533.0
2018-09-05 18:00:00	NQ	Futures	8867.87	8874.06	8864.34	8867.58	1417.0
2018-09-05 19:00:00	NQ	Futures	8867.87	8870.52	8863.16	8864.05	1260.0
2018-09-05 20:00:00	NQ	Futures	8864.34	8869.64	8860.81	8865.22	2529.0
2018-09-05 21:00:00	NQ	Futures	8865.22	8876.12	8857.86	8869.94	4176.0
2018-09-05 22:00:00	NQ	Futures	8869.94	8876.12	8868.17	8873.17	3329.0
2018-09-05 23:00:00	NQ	Futures	8873.47	8879.36	8861.4	8864.64	3022.0
2018-09-05 00:00:00	YM	Futures	28242.8	28243.9	28233.0	28237.4	639.0
2018-09-05 01:00:00	YM	Futures	28236.3	28237.4	28195.0	28195.0	2223.0
2018-09-05 02:00:00	YM	Futures	28195.0	28196.0	28139.5	28142.8	3477.0
2018-09-05 03:00:00	YM	Futures	28143.9	28164.5	28102.6	28122.1	5943.0

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

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