PREVIEW / futures_1hour / 2019-08-29

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-08-29.parquet
  size:    59 KB
  rows:    1,832

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
2019-08-29 00:00:00	ES	Futures	3118.25	3120.96	3118.25	3119.88	3998.0
2019-08-29 01:00:00	ES	Futures	3120.15	3124.75	3119.33	3120.15	12386.0
2019-08-29 02:00:00	ES	Futures	3120.42	3123.12	3119.88	3121.77	10453.0
2019-08-29 03:00:00	ES	Futures	3121.77	3152.09	3118.25	3148.57	97856.0
2019-08-29 04:00:00	ES	Futures	3148.57	3151.82	3144.78	3149.92	40687.0
2019-08-29 05:00:00	ES	Futures	3150.19	3159.13	3149.92	3155.88	42352.0
2019-08-29 06:00:00	ES	Futures	3155.88	3160.75	3155.61	3159.67	31728.0
2019-08-29 07:00:00	ES	Futures	3159.67	3160.48	3155.07	3159.67	33429.0
2019-08-29 08:00:00	ES	Futures	3159.67	3161.56	3156.96	3156.96	45678.0
2019-08-29 09:00:00	ES	Futures	3156.96	3167.79	3154.8	3164.54	202873.0
2019-08-29 10:00:00	ES	Futures	3164.54	3165.35	3145.86	3158.59	256085.0
2019-08-29 11:00:00	ES	Futures	3158.59	3168.87	3156.42	3166.98	121233.0
2019-08-29 12:00:00	ES	Futures	3166.98	3171.04	3164.81	3168.6	88430.0
2019-08-29 13:00:00	ES	Futures	3168.87	3172.39	3166.44	3171.04	70448.0
2019-08-29 14:00:00	ES	Futures	3171.04	3173.48	3167.25	3168.6	91902.0
2019-08-29 15:00:00	ES	Futures	3168.33	3169.96	3163.19	3166.98	161975.0
2019-08-29 16:00:00	ES	Futures	3166.98	3169.96	3165.63	3166.17	60910.0
2019-08-29 18:00:00	ES	Futures	3165.35	3166.71	3163.19	3165.63	4877.0
2019-08-29 19:00:00	ES	Futures	3165.9	3166.17	3162.38	3165.63	14872.0
2019-08-29 20:00:00	ES	Futures	3165.9	3169.14	3164.27	3167.25	9687.0
2019-08-29 21:00:00	ES	Futures	3167.25	3171.31	3166.71	3170.77	15217.0
2019-08-29 22:00:00	ES	Futures	3170.77	3177.27	3170.5	3175.64	14689.0
2019-08-29 23:00:00	ES	Futures	3175.64	3176.45	3173.75	3176.45	6916.0
2019-08-29 00:00:00	NQ	Futures	8777.39	8789.28	8775.65	8785.8	3735.0
2019-08-29 01:00:00	NQ	Futures	8786.09	8806.11	8784.06	8789.58	5926.0
2019-08-29 02:00:00	NQ	Futures	8789.58	8799.44	8786.96	8793.35	4480.0
2019-08-29 03:00:00	NQ	Futures	8793.64	8904.18	8778.26	8895.77	30339.0
2019-08-29 04:00:00	NQ	Futures	8895.48	8905.63	8884.74	8899.54	13948.0
2019-08-29 05:00:00	NQ	Futures	8899.83	8931.74	8899.83	8919.56	15205.0
2019-08-29 06:00:00	NQ	Futures	8919.27	8939.58	8918.11	8935.81	11454.0
2019-08-29 07:00:00	NQ	Futures	8935.81	8936.68	8911.14	8925.36	12851.0
2019-08-29 08:00:00	NQ	Futures	8925.65	8933.2	8918.11	8920.43	13329.0
2019-08-29 09:00:00	NQ	Futures	8920.14	8966.56	8913.18	8954.96	67601.0
2019-08-29 10:00:00	NQ	Futures	8954.67	8956.7	8884.45	8930.58	75809.0
2019-08-29 11:00:00	NQ	Futures	8930.58	8960.47	8924.78	8948.57	38582.0
2019-08-29 12:00:00	NQ	Futures	8948.57	8962.5	8939.87	8952.34	28633.0
2019-08-29 13:00:00	NQ	Futures	8952.34	8968.59	8947.12	8964.24	19808.0
2019-08-29 14:00:00	NQ	Futures	8964.53	8971.49	8944.22	8948.86	26136.0
2019-08-29 15:00:00	NQ	Futures	8948.86	8954.38	8934.07	8945.38	36816.0
2019-08-29 16:00:00	NQ	Futures	8945.09	8954.38	8941.32	8943.93	10016.0
2019-08-29 18:00:00	NQ	Futures	8941.32	8943.35	8923.33	8938.71	2102.0
2019-08-29 19:00:00	NQ	Futures	8939.29	8940.16	8926.23	8936.1	4906.0
2019-08-29 20:00:00	NQ	Futures	8936.39	8947.7	8930.87	8940.16	4984.0
2019-08-29 21:00:00	NQ	Futures	8940.45	8957.86	8938.42	8954.96	7431.0
2019-08-29 22:00:00	NQ	Futures	8954.96	8974.98	8953.22	8969.75	6967.0
2019-08-29 23:00:00	NQ	Futures	8970.33	8971.2	8959.89	8970.62	3991.0
2019-08-29 00:00:00	YM	Futures	28244.6	28266.3	28240.2	28257.6	821.0
2019-08-29 01:00:00	YM	Futures	28258.7	28296.8	28247.8	28253.3	2246.0
2019-08-29 02:00:00	YM	Futures	28254.3	28277.2	28253.3	28269.6	1997.0
2019-08-29 03:00:00	YM	Futures	28267.4	28541.4	28236.9	28512.1	14542.0

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

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