PREVIEW / futures_1hour / 2018-03-22

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-03-22.parquet
  size:    57 KB
  rows:    1,670

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-03-22 00:00:00	ES	Futures	2967.6	2969.51	2967.6	2968.69	1506.0
2018-03-22 01:00:00	ES	Futures	2968.69	2973.06	2968.15	2970.88	3743.0
2018-03-22 02:00:00	ES	Futures	2971.15	2972.24	2965.15	2965.69	4786.0
2018-03-22 03:00:00	ES	Futures	2965.42	2965.69	2944.95	2947.41	33463.0
2018-03-22 04:00:00	ES	Futures	2947.68	2956.14	2945.5	2955.05	22268.0
2018-03-22 05:00:00	ES	Futures	2955.05	2955.32	2942.77	2946.32	29944.0
2018-03-22 06:00:00	ES	Futures	2946.32	2950.14	2942.22	2946.59	22045.0
2018-03-22 07:00:00	ES	Futures	2946.59	2950.14	2943.59	2943.86	21666.0
2018-03-22 08:00:00	ES	Futures	2943.86	2949.32	2932.67	2936.49	68135.0
2018-03-22 09:00:00	ES	Futures	2936.22	2940.31	2926.67	2932.4	240552.0
2018-03-22 10:00:00	ES	Futures	2932.4	2945.5	2917.39	2921.75	319564.0
2018-03-22 11:00:00	ES	Futures	2922.03	2925.57	2907.29	2911.66	274698.0
2018-03-22 12:00:00	ES	Futures	2911.38	2933.49	2907.84	2923.94	349536.0
2018-03-22 13:00:00	ES	Futures	2923.66	2938.4	2916.02	2933.76	206037.0
2018-03-22 14:00:00	ES	Futures	2933.49	2935.4	2910.29	2912.2	187396.0
2018-03-22 15:00:00	ES	Futures	2911.93	2919.02	2884.09	2887.91	511898.0
2018-03-22 16:00:00	ES	Futures	2887.91	2894.46	2883.82	2889.28	142883.0
2018-03-22 18:00:00	ES	Futures	2888.19	2889.55	2875.63	2881.09	29275.0
2018-03-22 19:00:00	ES	Futures	2881.09	2881.09	2867.17	2869.9	23874.0
2018-03-22 20:00:00	ES	Futures	2869.63	2877.0	2866.63	2870.99	18652.0
2018-03-22 21:00:00	ES	Futures	2870.72	2876.45	2864.72	2873.18	24536.0
2018-03-22 22:00:00	ES	Futures	2873.18	2873.99	2856.8	2867.17	24769.0
2018-03-22 23:00:00	ES	Futures	2867.17	2871.81	2865.53	2868.54	17738.0
2018-03-22 00:00:00	NQ	Futures	8141.61	8148.12	8141.02	8145.75	828.0
2018-03-22 01:00:00	NQ	Futures	8145.75	8156.39	8143.68	8146.93	2154.0
2018-03-22 02:00:00	NQ	Futures	8147.23	8152.25	8120.63	8122.7	3224.0
2018-03-22 03:00:00	NQ	Futures	8122.41	8122.41	8052.96	8062.12	13597.0
2018-03-22 04:00:00	NQ	Futures	8063.0	8088.42	8057.09	8079.55	10854.0
2018-03-22 05:00:00	NQ	Futures	8079.26	8079.26	8034.34	8044.98	12347.0
2018-03-22 06:00:00	NQ	Futures	8045.27	8058.57	8027.24	8039.07	8164.0
2018-03-22 07:00:00	NQ	Futures	8039.07	8058.27	8038.77	8040.25	9338.0
2018-03-22 08:00:00	NQ	Futures	8039.95	8059.16	8013.35	8023.7	21894.0
2018-03-22 09:00:00	NQ	Futures	8024.29	8052.66	7997.69	8030.79	73700.0
2018-03-22 10:00:00	NQ	Futures	8030.79	8066.85	7973.46	7989.12	90199.0
2018-03-22 11:00:00	NQ	Futures	7988.82	8005.37	7937.99	7959.27	79261.0
2018-03-22 12:00:00	NQ	Futures	7959.27	8021.33	7945.68	8000.35	88763.0
2018-03-22 13:00:00	NQ	Futures	8000.06	8047.64	7973.75	8033.75	63771.0
2018-03-22 14:00:00	NQ	Futures	8032.86	8038.18	7979.07	7984.69	52423.0
2018-03-22 15:00:00	NQ	Futures	7984.39	8003.31	7913.17	7917.9	98871.0
2018-03-22 16:00:00	NQ	Futures	7918.19	7931.49	7903.71	7914.06	22696.0
2018-03-22 18:00:00	NQ	Futures	7911.1	7914.65	7869.73	7886.57	7410.0
2018-03-22 19:00:00	NQ	Futures	7886.87	7888.34	7842.83	7844.31	8308.0
2018-03-22 20:00:00	NQ	Futures	7844.01	7866.47	7828.94	7842.24	9099.0
2018-03-22 21:00:00	NQ	Futures	7841.95	7849.33	7815.35	7840.47	12073.0
2018-03-22 22:00:00	NQ	Futures	7840.47	7845.49	7795.25	7836.92	9452.0
2018-03-22 23:00:00	NQ	Futures	7836.92	7854.95	7834.26	7839.29	7662.0
2018-03-22 00:00:00	YM	Futures	26844.3	26859.5	26841.1	26851.9	946.0
2018-03-22 01:00:00	YM	Futures	26850.8	26905.1	26845.4	26883.4	2306.0
2018-03-22 02:00:00	YM	Futures	26883.4	26894.3	26841.1	26845.4	1970.0
2018-03-22 03:00:00	YM	Futures	26843.2	26849.8	26646.7	26671.6	10550.0

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

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