PREVIEW / futures_1hour / 2018-09-28

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-09-28.parquet
  size:    48 KB
  rows:    1,411

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-28 00:00:00	ES	Futures	3180.2	3180.48	3178.3	3179.66	3222.0
2018-09-28 01:00:00	ES	Futures	3179.66	3179.93	3178.03	3178.03	4512.0
2018-09-28 02:00:00	ES	Futures	3178.3	3178.57	3174.76	3175.04	9366.0
2018-09-28 03:00:00	ES	Futures	3174.76	3176.12	3171.5	3174.22	28158.0
2018-09-28 04:00:00	ES	Futures	3174.22	3178.57	3173.4	3178.03	18666.0
2018-09-28 05:00:00	ES	Futures	3177.76	3178.3	3173.4	3173.95	20940.0
2018-09-28 06:00:00	ES	Futures	3173.95	3174.49	3168.51	3170.68	26578.0
2018-09-28 07:00:00	ES	Futures	3170.68	3171.23	3164.7	3165.79	35109.0
2018-09-28 08:00:00	ES	Futures	3165.52	3169.32	3163.88	3168.51	37092.0
2018-09-28 09:00:00	ES	Futures	3168.78	3173.68	3166.6	3172.86	133822.0
2018-09-28 10:00:00	ES	Futures	3173.13	3181.29	3170.68	3179.93	164457.0
2018-09-28 11:00:00	ES	Futures	3180.2	3182.92	3178.3	3178.84	104471.0
2018-09-28 12:00:00	ES	Futures	3178.57	3180.48	3172.04	3176.67	94093.0
2018-09-28 13:00:00	ES	Futures	3176.67	3181.29	3175.31	3178.57	67453.0
2018-09-28 14:00:00	ES	Futures	3178.57	3178.84	3174.22	3175.04	85724.0
2018-09-28 15:00:00	ES	Futures	3175.31	3178.03	3172.59	3175.85	403571.0
2018-09-28 16:00:00	ES	Futures	3175.85	3179.39	3175.31	3178.84	96045.0
2018-09-28 00:00:00	NQ	Futures	8996.82	8998.88	8990.96	8996.24	1536.0
2018-09-28 01:00:00	NQ	Futures	8996.24	8996.82	8991.25	8991.25	2210.0
2018-09-28 02:00:00	NQ	Futures	8991.84	8992.43	8977.47	8978.64	4072.0
2018-09-28 03:00:00	NQ	Futures	8978.64	8982.16	8966.32	8976.29	11157.0
2018-09-28 04:00:00	NQ	Futures	8976.0	8989.79	8973.07	8986.85	8911.0
2018-09-28 05:00:00	NQ	Futures	8986.85	8989.49	8970.72	8973.95	7960.0
2018-09-28 06:00:00	NQ	Futures	8974.24	8974.83	8957.52	8962.51	9451.0
2018-09-28 07:00:00	NQ	Futures	8962.8	8963.39	8936.7	8939.92	12744.0
2018-09-28 08:00:00	NQ	Futures	8939.92	8957.23	8937.28	8954.0	11308.0
2018-09-28 09:00:00	NQ	Futures	8954.29	8978.35	8944.03	8960.16	58994.0
2018-09-28 10:00:00	NQ	Futures	8960.16	8989.79	8946.67	8984.51	63482.0
2018-09-28 11:00:00	NQ	Futures	8984.51	9007.09	8982.75	8986.27	41616.0
2018-09-28 12:00:00	NQ	Futures	8985.97	8993.6	8956.93	8974.24	28504.0
2018-09-28 13:00:00	NQ	Futures	8973.95	8986.56	8964.85	8977.17	22094.0
2018-09-28 14:00:00	NQ	Futures	8977.17	8978.93	8960.45	8971.31	24203.0
2018-09-28 15:00:00	NQ	Futures	8971.01	8984.8	8968.08	8983.33	46240.0
2018-09-28 16:00:00	NQ	Futures	8983.33	8997.41	8982.16	8996.82	10138.0
2018-09-28 00:00:00	YM	Futures	28800.2	28804.5	28780.6	28800.2	1188.0
2018-09-28 01:00:00	YM	Futures	28799.1	28800.2	28776.3	28777.4	1521.0
2018-09-28 02:00:00	YM	Futures	28777.4	28780.6	28741.5	28742.6	2244.0
2018-09-28 03:00:00	YM	Futures	28742.6	28750.2	28707.8	28729.6	6060.0
2018-09-28 04:00:00	YM	Futures	28728.5	28776.3	28724.1	28770.8	6513.0
2018-09-28 05:00:00	YM	Futures	28768.7	28774.1	28727.4	28733.9	7054.0
2018-09-28 06:00:00	YM	Futures	28735.0	28737.2	28676.3	28699.1	5304.0
2018-09-28 07:00:00	YM	Futures	28699.1	28704.6	28635.0	28647.0	6686.0
2018-09-28 08:00:00	YM	Futures	28645.9	28679.6	28626.3	28672.0	7502.0
2018-09-28 09:00:00	YM	Futures	28672.0	28738.3	28657.9	28736.1	20110.0
2018-09-28 10:00:00	YM	Futures	28735.0	28795.8	28707.8	28788.2	24953.0
2018-09-28 11:00:00	YM	Futures	28788.2	28815.4	28778.5	28793.7	15315.0
2018-09-28 12:00:00	YM	Futures	28791.5	28810.0	28727.4	28775.2	13536.0
2018-09-28 13:00:00	YM	Futures	28773.0	28829.5	28763.2	28802.4	10044.0
2018-09-28 14:00:00	YM	Futures	28803.4	28806.7	28744.8	28748.0	11441.0
2018-09-28 15:00:00	YM	Futures	28748.0	28773.0	28717.6	28766.5	27675.0

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

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