PREVIEW / futures_1hour / 2019-10-09

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-10-09.parquet
  size:    61 KB
  rows:    1,871

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-10-09 00:00:00	ES	Futures	3152.28	3152.55	3147.12	3148.75	5793.0
2019-10-09 01:00:00	ES	Futures	3148.75	3151.19	3147.93	3149.83	5900.0
2019-10-09 02:00:00	ES	Futures	3149.83	3152.28	3143.04	3145.49	12454.0
2019-10-09 03:00:00	ES	Futures	3145.49	3158.53	3142.23	3151.19	43132.0
2019-10-09 04:00:00	ES	Futures	3151.46	3159.88	3149.83	3157.71	28861.0
2019-10-09 05:00:00	ES	Futures	3157.71	3188.13	3157.17	3172.92	96407.0
2019-10-09 06:00:00	ES	Futures	3173.19	3173.19	3164.77	3168.58	29623.0
2019-10-09 07:00:00	ES	Futures	3168.58	3173.19	3166.95	3173.19	23222.0
2019-10-09 08:00:00	ES	Futures	3173.19	3174.01	3164.77	3167.76	35456.0
2019-10-09 09:00:00	ES	Futures	3167.49	3171.02	3158.8	3162.33	155037.0
2019-10-09 10:00:00	ES	Futures	3162.33	3169.12	3160.7	3166.13	137858.0
2019-10-09 11:00:00	ES	Futures	3166.13	3172.11	3157.98	3168.03	119809.0
2019-10-09 12:00:00	ES	Futures	3168.03	3172.38	3168.03	3172.11	59792.0
2019-10-09 13:00:00	ES	Futures	3172.38	3177.54	3168.03	3172.65	77977.0
2019-10-09 14:00:00	ES	Futures	3172.65	3179.98	3169.93	3178.9	81812.0
2019-10-09 15:00:00	ES	Futures	3178.63	3182.97	3168.58	3171.02	224227.0
2019-10-09 16:00:00	ES	Futures	3171.02	3175.64	3167.49	3173.19	63388.0
2019-10-09 18:00:00	ES	Futures	3173.19	3176.45	3131.09	3135.16	70450.0
2019-10-09 19:00:00	ES	Futures	3135.16	3150.38	3132.72	3150.38	29292.0
2019-10-09 20:00:00	ES	Futures	3150.38	3169.93	3136.25	3146.3	96253.0
2019-10-09 21:00:00	ES	Futures	3146.57	3175.91	3146.03	3163.96	61471.0
2019-10-09 22:00:00	ES	Futures	3164.23	3171.02	3163.69	3167.49	15576.0
2019-10-09 23:00:00	ES	Futures	3167.22	3168.3	3165.04	3165.32	5695.0
2019-10-09 00:00:00	NQ	Futures	8877.74	8879.48	8858.27	8864.37	3412.0
2019-10-09 01:00:00	NQ	Futures	8864.37	8874.25	8861.47	8868.73	2914.0
2019-10-09 02:00:00	NQ	Futures	8868.44	8879.48	8845.49	8855.08	5935.0
2019-10-09 03:00:00	NQ	Futures	8854.79	8903.3	8843.75	8880.64	14831.0
2019-10-09 04:00:00	NQ	Futures	8880.35	8905.91	8873.38	8898.07	9117.0
2019-10-09 05:00:00	NQ	Futures	8898.07	8969.24	8895.46	8951.52	26229.0
2019-10-09 06:00:00	NQ	Futures	8952.39	8954.13	8926.54	8943.39	9511.0
2019-10-09 07:00:00	NQ	Futures	8943.1	8952.97	8931.48	8950.36	10219.0
2019-10-09 08:00:00	NQ	Futures	8949.78	8955.3	8923.05	8932.64	15667.0
2019-10-09 09:00:00	NQ	Futures	8932.35	8944.26	8902.72	8916.37	51023.0
2019-10-09 10:00:00	NQ	Futures	8915.5	8939.03	8910.85	8937.0	44099.0
2019-10-09 11:00:00	NQ	Futures	8937.0	8954.72	8912.59	8943.1	39976.0
2019-10-09 12:00:00	NQ	Futures	8942.81	8957.33	8939.61	8955.01	22160.0
2019-10-09 13:00:00	NQ	Futures	8955.01	8970.69	8939.9	8952.39	25977.0
2019-10-09 14:00:00	NQ	Futures	8952.68	8979.41	8943.39	8973.02	30823.0
2019-10-09 15:00:00	NQ	Futures	8972.73	8984.35	8941.35	8948.03	57042.0
2019-10-09 16:00:00	NQ	Futures	8948.33	8959.94	8934.09	8950.65	12723.0
2019-10-09 18:00:00	NQ	Futures	8949.78	8964.01	8811.5	8822.83	21020.0
2019-10-09 19:00:00	NQ	Futures	8823.7	8874.83	8811.79	8874.25	10548.0
2019-10-09 20:00:00	NQ	Futures	8874.25	8948.33	8844.04	8866.12	37716.0
2019-10-09 21:00:00	NQ	Futures	8866.41	8959.36	8865.53	8928.28	22812.0
2019-10-09 22:00:00	NQ	Futures	8929.15	8954.13	8926.25	8939.32	8524.0
2019-10-09 23:00:00	NQ	Futures	8939.61	8941.93	8930.02	8931.77	3433.0
2019-10-09 00:00:00	YM	Futures	28512.7	28514.8	28469.1	28482.2	1412.0
2019-10-09 01:00:00	YM	Futures	28481.1	28502.9	28473.5	28490.9	1272.0
2019-10-09 02:00:00	YM	Futures	28490.9	28511.6	28431.0	28452.8	2832.0
2019-10-09 03:00:00	YM	Futures	28449.5	28566.0	28420.1	28501.8	8686.0

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

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