PREVIEW / futures_1hour / 2018-12-12

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-12-12.parquet
  size:    51 KB
  rows:    1,627

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
2018-12-12 00:00:00	ES	Futures	2888.08	2892.97	2885.63	2892.16	6363.0
2018-12-12 01:00:00	ES	Futures	2892.16	2895.15	2887.81	2889.44	7439.0
2018-12-12 02:00:00	ES	Futures	2889.44	2890.25	2879.1	2879.65	19248.0
2018-12-12 03:00:00	ES	Futures	2879.92	2889.71	2878.01	2885.9	29143.0
2018-12-12 04:00:00	ES	Futures	2886.17	2901.4	2885.36	2898.96	30659.0
2018-12-12 05:00:00	ES	Futures	2899.23	2900.04	2894.88	2897.87	18831.0
2018-12-12 06:00:00	ES	Futures	2897.6	2897.87	2891.07	2894.61	20125.0
2018-12-12 07:00:00	ES	Futures	2894.88	2903.31	2891.34	2898.41	32488.0
2018-12-12 08:00:00	ES	Futures	2898.41	2912.56	2896.78	2909.02	49956.0
2018-12-12 09:00:00	ES	Futures	2908.75	2909.29	2895.69	2902.22	202131.0
2018-12-12 10:00:00	ES	Futures	2902.49	2915.28	2898.14	2913.92	251815.0
2018-12-12 11:00:00	ES	Futures	2913.64	2917.72	2906.84	2916.36	175898.0
2018-12-12 12:00:00	ES	Futures	2916.64	2920.99	2910.92	2919.63	140098.0
2018-12-12 13:00:00	ES	Futures	2919.63	2922.89	2911.47	2914.73	85942.0
2018-12-12 14:00:00	ES	Futures	2914.73	2915.55	2889.71	2899.5	223177.0
2018-12-12 15:00:00	ES	Futures	2899.5	2906.3	2883.45	2884.81	286980.0
2018-12-12 16:00:00	ES	Futures	2884.81	2887.81	2879.65	2884.54	86966.0
2018-12-12 18:00:00	ES	Futures	2886.45	2892.97	2885.09	2892.16	10148.0
2018-12-12 19:00:00	ES	Futures	2892.16	2892.7	2888.89	2889.44	7548.0
2018-12-12 20:00:00	ES	Futures	2889.44	2895.42	2888.89	2895.15	9656.0
2018-12-12 21:00:00	ES	Futures	2895.15	2900.32	2894.06	2898.96	11025.0
2018-12-12 22:00:00	ES	Futures	2898.96	2900.32	2897.6	2897.87	5920.0
2018-12-12 23:00:00	ES	Futures	2898.14	2898.96	2896.51	2898.41	2980.0
2018-12-12 00:00:00	NQ	Futures	7933.56	7947.64	7924.76	7944.71	3537.0
2018-12-12 01:00:00	NQ	Futures	7944.71	7957.32	7930.33	7935.91	4162.0
2018-12-12 02:00:00	NQ	Futures	7935.61	7938.55	7904.23	7906.87	7567.0
2018-12-12 03:00:00	NQ	Futures	7906.58	7942.07	7900.12	7929.75	9784.0
2018-12-12 04:00:00	NQ	Futures	7929.75	7981.37	7925.64	7972.87	12221.0
2018-12-12 05:00:00	NQ	Futures	7973.16	7976.68	7958.79	7966.41	7348.0
2018-12-12 06:00:00	NQ	Futures	7966.71	7966.71	7944.41	7953.8	7616.0
2018-12-12 07:00:00	NQ	Futures	7954.68	7981.37	7941.77	7963.48	11521.0
2018-12-12 08:00:00	NQ	Futures	7963.48	8006.6	7954.68	7998.38	24062.0
2018-12-12 09:00:00	NQ	Futures	7998.09	8000.73	7953.51	7990.17	77167.0
2018-12-12 10:00:00	NQ	Futures	7990.46	8031.82	7979.61	8027.42	100079.0
2018-12-12 11:00:00	NQ	Futures	8027.13	8055.87	8017.16	8048.83	69927.0
2018-12-12 12:00:00	NQ	Futures	8049.13	8057.63	8026.54	8053.82	59215.0
2018-12-12 13:00:00	NQ	Futures	8053.82	8062.62	8028.59	8035.93	41699.0
2018-12-12 14:00:00	NQ	Futures	8035.34	8037.69	7953.51	7983.13	79161.0
2018-12-12 15:00:00	NQ	Futures	7982.84	8005.13	7934.73	7938.84	71707.0
2018-12-12 16:00:00	NQ	Futures	7938.55	7946.47	7916.26	7937.37	19496.0
2018-12-12 18:00:00	NQ	Futures	7941.77	7970.81	7940.6	7968.76	4150.0
2018-12-12 19:00:00	NQ	Futures	7968.17	7969.35	7957.32	7958.2	4317.0
2018-12-12 20:00:00	NQ	Futures	7957.91	7978.44	7953.21	7976.97	4364.0
2018-12-12 21:00:00	NQ	Futures	7976.97	7993.4	7971.99	7991.64	5835.0
2018-12-12 22:00:00	NQ	Futures	7991.93	7995.74	7985.18	7986.36	3240.0
2018-12-12 23:00:00	NQ	Futures	7985.77	7992.22	7983.42	7990.46	2112.0
2018-12-12 00:00:00	YM	Futures	26669.3	26708.4	26653.0	26700.8	128.0
2018-12-12 01:00:00	YM	Futures	26705.1	26735.5	26670.4	26686.7	115.0
2018-12-12 02:00:00	YM	Futures	26670.4	26675.8	26577.0	26583.5	179.0
2018-12-12 03:00:00	YM	Futures	26579.2	26687.8	26573.8	26656.3	92.0

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

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