PREVIEW / futures_1hour / 2019-04-17

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-04-17.parquet
  size:    54 KB
  rows:    1,743

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-04-17 00:00:00	ES	Futures	3159.97	3161.05	3159.43	3159.7	5318.0
2019-04-17 01:00:00	ES	Futures	3159.7	3162.14	3159.43	3161.59	4358.0
2019-04-17 02:00:00	ES	Futures	3161.59	3162.14	3160.24	3160.51	4895.0
2019-04-17 03:00:00	ES	Futures	3160.51	3161.87	3159.97	3161.32	8392.0
2019-04-17 04:00:00	ES	Futures	3161.32	3162.68	3161.05	3162.14	5865.0
2019-04-17 05:00:00	ES	Futures	3162.41	3163.76	3161.87	3163.49	8293.0
2019-04-17 06:00:00	ES	Futures	3163.49	3163.76	3162.14	3162.14	6145.0
2019-04-17 07:00:00	ES	Futures	3162.14	3164.85	3162.14	3164.31	9217.0
2019-04-17 08:00:00	ES	Futures	3164.58	3167.02	3164.31	3165.93	20058.0
2019-04-17 09:00:00	ES	Futures	3165.93	3170.27	3155.63	3155.9	242839.0
2019-04-17 10:00:00	ES	Futures	3155.9	3157.8	3149.67	3152.38	257049.0
2019-04-17 11:00:00	ES	Futures	3152.38	3156.71	3147.23	3149.94	150119.0
2019-04-17 12:00:00	ES	Futures	3149.94	3152.65	3145.6	3151.56	101940.0
2019-04-17 13:00:00	ES	Futures	3151.29	3154.0	3148.85	3149.12	115030.0
2019-04-17 14:00:00	ES	Futures	3149.12	3150.48	3143.16	3148.58	138715.0
2019-04-17 15:00:00	ES	Futures	3148.58	3152.11	3148.31	3148.58	132726.0
2019-04-17 16:00:00	ES	Futures	3148.58	3149.12	3144.79	3145.6	55191.0
2019-04-17 18:00:00	ES	Futures	3145.87	3147.77	3145.6	3147.5	4587.0
2019-04-17 19:00:00	ES	Futures	3147.77	3148.58	3146.96	3148.58	2886.0
2019-04-17 20:00:00	ES	Futures	3148.58	3148.58	3144.79	3145.6	6822.0
2019-04-17 21:00:00	ES	Futures	3145.6	3146.96	3139.36	3140.99	20659.0
2019-04-17 22:00:00	ES	Futures	3140.72	3142.62	3140.18	3141.8	8097.0
2019-04-17 23:00:00	ES	Futures	3141.53	3141.8	3136.11	3136.92	10880.0
2019-04-17 00:00:00	NQ	Futures	8959.45	8962.66	8956.54	8957.71	2028.0
2019-04-17 01:00:00	NQ	Futures	8957.71	8966.44	8957.71	8964.11	1713.0
2019-04-17 02:00:00	NQ	Futures	8963.82	8964.69	8959.16	8959.75	2260.0
2019-04-17 03:00:00	NQ	Futures	8960.04	8964.4	8958.0	8959.45	3357.0
2019-04-17 04:00:00	NQ	Futures	8959.45	8964.99	8958.0	8964.4	2249.0
2019-04-17 05:00:00	NQ	Futures	8964.11	8967.32	8963.24	8967.02	2572.0
2019-04-17 06:00:00	NQ	Futures	8967.02	8969.94	8966.15	8966.44	2307.0
2019-04-17 07:00:00	NQ	Futures	8966.44	8976.34	8966.15	8975.18	4460.0
2019-04-17 08:00:00	NQ	Futures	8975.18	8994.39	8974.3	8989.73	9903.0
2019-04-17 09:00:00	NQ	Futures	8989.73	9006.62	8963.82	8966.44	77976.0
2019-04-17 10:00:00	NQ	Futures	8966.44	8988.28	8944.02	8964.69	86588.0
2019-04-17 11:00:00	NQ	Futures	8964.69	8978.09	8942.86	8962.37	56991.0
2019-04-17 12:00:00	NQ	Futures	8962.07	8975.18	8943.44	8970.52	41977.0
2019-04-17 13:00:00	NQ	Futures	8970.81	8980.13	8962.66	8967.02	30363.0
2019-04-17 14:00:00	NQ	Futures	8967.02	8970.23	8941.98	8961.49	46844.0
2019-04-17 15:00:00	NQ	Futures	8961.2	8974.3	8953.92	8969.06	47424.0
2019-04-17 16:00:00	NQ	Futures	8969.35	8970.23	8950.72	8952.76	10536.0
2019-04-17 18:00:00	NQ	Futures	8957.71	8958.58	8951.88	8958.29	1431.0
2019-04-17 19:00:00	NQ	Futures	8958.29	8962.66	8956.25	8962.37	1075.0
2019-04-17 20:00:00	NQ	Futures	8962.07	8963.82	8951.01	8953.63	2804.0
2019-04-17 21:00:00	NQ	Futures	8954.21	8958.58	8934.12	8938.78	7859.0
2019-04-17 22:00:00	NQ	Futures	8938.49	8946.06	8936.16	8941.98	3275.0
2019-04-17 23:00:00	NQ	Futures	8941.98	8943.73	8927.43	8931.21	4430.0
2019-04-17 00:00:00	YM	Futures	28773.1	28781.8	28766.6	28769.9	1866.0
2019-04-17 01:00:00	YM	Futures	28771.0	28793.8	28769.9	28787.3	952.0
2019-04-17 02:00:00	YM	Futures	28787.3	28792.7	28772.1	28775.3	1341.0
2019-04-17 03:00:00	YM	Futures	28774.2	28788.4	28767.7	28781.8	1656.0

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

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