PREVIEW / futures_1hour / 2020-08-07

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-08-07.parquet
  size:    51 KB
  rows:    1,484

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
2020-08-07 00:00:00	ES	Futures	3716.17	3721.2	3713.38	3720.08	10257.0
2020-08-07 01:00:00	ES	Futures	3720.08	3724.83	3715.89	3723.71	10016.0
2020-08-07 02:00:00	ES	Futures	3723.99	3728.18	3720.64	3721.48	12476.0
2020-08-07 03:00:00	ES	Futures	3721.2	3729.58	3717.57	3729.3	25339.0
2020-08-07 04:00:00	ES	Futures	3729.58	3730.97	3718.41	3721.2	20400.0
2020-08-07 05:00:00	ES	Futures	3721.2	3721.76	3711.98	3716.45	20556.0
2020-08-07 06:00:00	ES	Futures	3716.45	3721.48	3713.94	3721.2	16500.0
2020-08-07 07:00:00	ES	Futures	3721.2	3723.15	3719.52	3720.08	12933.0
2020-08-07 08:00:00	ES	Futures	3719.8	3736.84	3716.17	3722.6	71780.0
2020-08-07 09:00:00	ES	Futures	3722.6	3730.69	3716.73	3729.02	156161.0
2020-08-07 10:00:00	ES	Futures	3729.02	3736.56	3718.97	3734.32	200076.0
2020-08-07 11:00:00	ES	Futures	3734.32	3737.4	3724.55	3725.11	142343.0
2020-08-07 12:00:00	ES	Futures	3725.11	3736.84	3722.87	3728.46	118224.0
2020-08-07 13:00:00	ES	Futures	3728.46	3730.69	3717.57	3718.97	162413.0
2020-08-07 14:00:00	ES	Futures	3718.97	3725.39	3710.87	3722.04	204200.0
2020-08-07 15:00:00	ES	Futures	3722.32	3738.23	3717.01	3736.0	261920.0
2020-08-07 16:00:00	ES	Futures	3736.0	3739.35	3733.21	3738.79	51583.0
2020-08-07 00:00:00	NQ	Futures	12949.99	12963.01	12936.69	12960.98	5418.0
2020-08-07 01:00:00	NQ	Futures	12961.27	12973.42	12941.61	12967.34	5324.0
2020-08-07 02:00:00	NQ	Futures	12968.21	12985.56	12956.64	12958.96	5057.0
2020-08-07 03:00:00	NQ	Futures	12958.67	12998.58	12947.97	12996.26	7709.0
2020-08-07 04:00:00	NQ	Futures	12996.84	13000.89	12958.38	12974.57	5679.0
2020-08-07 05:00:00	NQ	Futures	12974.57	12977.47	12943.63	12965.03	5233.0
2020-08-07 06:00:00	NQ	Futures	12965.03	12975.73	12951.73	12973.71	3159.0
2020-08-07 07:00:00	NQ	Futures	12975.15	12982.67	12968.79	12976.31	4002.0
2020-08-07 08:00:00	NQ	Futures	12976.02	13022.29	12958.96	12978.04	23711.0
2020-08-07 09:00:00	NQ	Futures	12977.18	13015.64	12964.16	13010.72	54702.0
2020-08-07 10:00:00	NQ	Futures	13010.43	13033.86	12962.72	13024.6	58388.0
2020-08-07 11:00:00	NQ	Futures	13024.6	13029.23	12923.1	12925.7	50977.0
2020-08-07 12:00:00	NQ	Futures	12925.7	12961.85	12881.46	12882.61	54449.0
2020-08-07 13:00:00	NQ	Futures	12882.61	12886.08	12801.64	12809.74	74518.0
2020-08-07 14:00:00	NQ	Futures	12809.45	12843.29	12764.63	12821.31	60755.0
2020-08-07 15:00:00	NQ	Futures	12821.02	12884.93	12808.58	12872.2	69615.0
2020-08-07 16:00:00	NQ	Futures	12871.92	12877.12	12862.95	12875.96	8815.0
2020-08-07 00:00:00	YM	Futures	29896.0	29942.2	29875.0	29933.4	1792.0
2020-08-07 01:00:00	YM	Futures	29931.2	29977.4	29897.1	29966.4	2439.0
2020-08-07 02:00:00	YM	Futures	29969.7	30005.0	29929.0	29935.6	2451.0
2020-08-07 03:00:00	YM	Futures	29934.5	29995.1	29904.8	29992.9	4162.0
2020-08-07 04:00:00	YM	Futures	29992.9	30009.4	29901.5	29921.3	4044.0
2020-08-07 05:00:00	YM	Futures	29921.3	29925.7	29846.4	29887.1	4716.0
2020-08-07 06:00:00	YM	Futures	29884.9	29924.6	29865.1	29922.4	2567.0
2020-08-07 07:00:00	YM	Futures	29924.6	29942.2	29897.1	29905.9	2204.0
2020-08-07 08:00:00	YM	Futures	29904.8	30080.9	29868.4	29967.5	11257.0
2020-08-07 09:00:00	YM	Futures	29967.5	29984.0	29877.2	29958.7	19235.0
2020-08-07 10:00:00	YM	Futures	29956.5	30025.9	29875.0	29998.4	23696.0
2020-08-07 11:00:00	YM	Futures	29998.4	30040.2	29934.5	29937.8	16809.0
2020-08-07 12:00:00	YM	Futures	29937.8	30049.0	29922.4	30001.7	13006.0
2020-08-07 13:00:00	YM	Futures	30001.7	30052.3	29927.9	29973.0	16089.0
2020-08-07 14:00:00	YM	Futures	29971.9	30016.0	29912.5	29999.5	18906.0
2020-08-07 15:00:00	YM	Futures	30000.6	30139.3	29955.4	30109.6	26611.0

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

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