PREVIEW / futures_1hour / 2020-10-12

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-10-12.parquet
  size:    58 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
2020-10-12 00:00:00	ES	Futures	3895.55	3898.36	3894.99	3897.8	5353.0
2020-10-12 01:00:00	ES	Futures	3897.51	3906.76	3896.95	3905.08	11393.0
2020-10-12 02:00:00	ES	Futures	3905.08	3906.76	3898.92	3899.2	11517.0
2020-10-12 03:00:00	ES	Futures	3899.48	3902.0	3896.11	3900.04	23791.0
2020-10-12 04:00:00	ES	Futures	3900.04	3912.08	3898.92	3900.32	23416.0
2020-10-12 05:00:00	ES	Futures	3900.6	3905.92	3899.76	3900.6	20389.0
2020-10-12 06:00:00	ES	Futures	3900.88	3910.12	3900.32	3909.84	13576.0
2020-10-12 07:00:00	ES	Futures	3910.12	3914.04	3906.76	3912.92	20878.0
2020-10-12 08:00:00	ES	Futures	3912.64	3921.32	3911.8	3917.4	35726.0
2020-10-12 09:00:00	ES	Futures	3917.68	3920.2	3911.52	3915.72	121472.0
2020-10-12 10:00:00	ES	Futures	3915.72	3932.81	3913.48	3930.01	165440.0
2020-10-12 11:00:00	ES	Futures	3930.29	3945.97	3930.01	3941.77	155837.0
2020-10-12 12:00:00	ES	Futures	3941.77	3959.42	3940.65	3954.09	132405.0
2020-10-12 13:00:00	ES	Futures	3954.37	3965.02	3951.01	3959.42	119944.0
2020-10-12 14:00:00	ES	Futures	3959.42	3967.26	3959.14	3961.66	107645.0
2020-10-12 15:00:00	ES	Futures	3961.66	3964.46	3946.81	3949.33	253762.0
2020-10-12 16:00:00	ES	Futures	3949.61	3960.26	3946.81	3956.89	62432.0
2020-10-12 18:00:00	ES	Futures	3959.42	3961.38	3954.93	3956.05	6766.0
2020-10-12 19:00:00	ES	Futures	3956.05	3959.14	3954.09	3956.89	6052.0
2020-10-12 20:00:00	ES	Futures	3956.89	3957.74	3939.53	3944.57	26288.0
2020-10-12 21:00:00	ES	Futures	3944.57	3947.37	3938.41	3941.21	12072.0
2020-10-12 22:00:00	ES	Futures	3941.49	3943.17	3936.17	3943.17	8340.0
2020-10-12 23:00:00	ES	Futures	3942.89	3945.13	3939.81	3942.89	6998.0
2020-10-12 00:00:00	NQ	Futures	13627.9	13636.0	13624.13	13631.95	3890.0
2020-10-12 01:00:00	NQ	Futures	13631.37	13653.95	13628.77	13647.0	5019.0
2020-10-12 02:00:00	NQ	Futures	13647.29	13652.79	13633.98	13635.42	4472.0
2020-10-12 03:00:00	NQ	Futures	13635.71	13662.92	13631.95	13660.03	9543.0
2020-10-12 04:00:00	NQ	Futures	13659.74	13754.97	13653.66	13713.58	18932.0
2020-10-12 05:00:00	NQ	Futures	13713.87	13734.42	13695.92	13704.03	8778.0
2020-10-12 06:00:00	NQ	Futures	13703.74	13768.87	13701.42	13763.08	9193.0
2020-10-12 07:00:00	NQ	Futures	13763.08	13809.97	13751.21	13804.76	18838.0
2020-10-12 08:00:00	NQ	Futures	13803.89	13844.42	13787.97	13814.6	20275.0
2020-10-12 09:00:00	NQ	Futures	13814.31	13832.26	13740.79	13764.53	79824.0
2020-10-12 10:00:00	NQ	Futures	13764.24	13861.5	13741.37	13856.0	76439.0
2020-10-12 11:00:00	NQ	Futures	13855.71	13939.37	13855.13	13912.73	78785.0
2020-10-12 12:00:00	NQ	Futures	13913.02	14047.92	13910.13	14008.55	84849.0
2020-10-12 13:00:00	NQ	Futures	14009.13	14068.76	13982.5	14046.18	75608.0
2020-10-12 14:00:00	NQ	Futures	14047.34	14122.6	14045.02	14061.52	80799.0
2020-10-12 15:00:00	NQ	Futures	14062.1	14082.65	13962.81	13979.6	86731.0
2020-10-12 16:00:00	NQ	Futures	13980.18	14025.05	13966.86	13997.84	13279.0
2020-10-12 18:00:00	NQ	Futures	14010.29	14036.63	14005.36	14012.31	4351.0
2020-10-12 19:00:00	NQ	Futures	14012.89	14031.42	14012.31	14020.71	2724.0
2020-10-12 20:00:00	NQ	Futures	14020.71	14025.92	13948.63	13969.47	9470.0
2020-10-12 21:00:00	NQ	Futures	13969.18	13987.42	13944.0	13951.81	6348.0
2020-10-12 22:00:00	NQ	Futures	13953.26	13963.1	13934.15	13961.08	3966.0
2020-10-12 23:00:00	NQ	Futures	13960.5	13971.5	13945.15	13966.58	2721.0
2020-10-12 00:00:00	YM	Futures	31535.6	31559.9	31530.1	31550.0	1223.0
2020-10-12 01:00:00	YM	Futures	31550.0	31620.7	31545.5	31613.0	3393.0
2020-10-12 02:00:00	YM	Futures	31613.0	31622.9	31546.6	31550.0	3080.0
2020-10-12 03:00:00	YM	Futures	31551.1	31567.6	31514.6	31544.4	5481.0

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

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