PREVIEW / futures_1hour / 2018-02-14

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-02-14.parquet
  size:    58 KB
  rows:    1,706

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-02-14 00:00:00	ES	Futures	2913.95	2916.41	2913.95	2915.59	4541.0
2018-02-14 01:00:00	ES	Futures	2915.59	2917.23	2914.77	2916.14	4074.0
2018-02-14 02:00:00	ES	Futures	2915.86	2927.34	2915.86	2924.88	23078.0
2018-02-14 03:00:00	ES	Futures	2924.88	2925.43	2920.78	2924.61	17153.0
2018-02-14 04:00:00	ES	Futures	2924.61	2925.98	2919.42	2920.78	16212.0
2018-02-14 05:00:00	ES	Futures	2920.78	2924.06	2918.32	2921.33	15262.0
2018-02-14 06:00:00	ES	Futures	2921.33	2924.34	2919.96	2922.97	17440.0
2018-02-14 07:00:00	ES	Futures	2922.97	2923.79	2920.24	2920.78	19703.0
2018-02-14 08:00:00	ES	Futures	2920.51	2925.43	2872.13	2887.71	240524.0
2018-02-14 09:00:00	ES	Futures	2887.71	2909.58	2881.7	2899.46	315224.0
2018-02-14 10:00:00	ES	Futures	2899.46	2926.52	2897.28	2920.51	303890.0
2018-02-14 11:00:00	ES	Futures	2920.51	2929.53	2915.86	2919.69	203443.0
2018-02-14 12:00:00	ES	Futures	2919.96	2934.45	2917.5	2932.81	148916.0
2018-02-14 13:00:00	ES	Futures	2932.81	2945.93	2931.72	2942.92	165682.0
2018-02-14 14:00:00	ES	Futures	2942.65	2947.57	2936.36	2945.38	142127.0
2018-02-14 15:00:00	ES	Futures	2945.11	2953.86	2945.11	2950.58	243762.0
2018-02-14 16:00:00	ES	Futures	2950.58	2951.4	2945.93	2947.84	96452.0
2018-02-14 18:00:00	ES	Futures	2947.02	2948.66	2945.38	2947.02	8324.0
2018-02-14 19:00:00	ES	Futures	2946.75	2950.85	2944.84	2949.21	8360.0
2018-02-14 20:00:00	ES	Futures	2949.48	2956.86	2948.94	2956.04	14518.0
2018-02-14 21:00:00	ES	Futures	2956.04	2956.59	2954.4	2956.32	6194.0
2018-02-14 22:00:00	ES	Futures	2956.32	2962.06	2955.22	2961.24	9350.0
2018-02-14 23:00:00	ES	Futures	2961.24	2962.06	2959.05	2961.51	3916.0
2018-02-14 00:00:00	NQ	Futures	7782.34	7792.72	7782.04	7790.05	2025.0
2018-02-14 01:00:00	NQ	Futures	7790.05	7795.39	7785.9	7792.12	1333.0
2018-02-14 02:00:00	NQ	Futures	7791.83	7833.05	7791.53	7823.56	5353.0
2018-02-14 03:00:00	NQ	Futures	7822.67	7832.16	7816.15	7828.9	3112.0
2018-02-14 04:00:00	NQ	Futures	7829.2	7830.98	7815.26	7818.82	2149.0
2018-02-14 05:00:00	NQ	Futures	7818.82	7821.78	7809.33	7817.33	2281.0
2018-02-14 06:00:00	NQ	Futures	7816.74	7825.34	7811.4	7819.71	1870.0
2018-02-14 07:00:00	NQ	Futures	7820.0	7829.5	7814.37	7816.74	4132.0
2018-02-14 08:00:00	NQ	Futures	7816.44	7825.94	7659.55	7725.69	46346.0
2018-02-14 09:00:00	NQ	Futures	7725.98	7800.73	7704.04	7766.02	67792.0
2018-02-14 10:00:00	NQ	Futures	7766.02	7859.45	7761.58	7840.17	82254.0
2018-02-14 11:00:00	NQ	Futures	7839.58	7875.47	7829.5	7839.28	58472.0
2018-02-14 12:00:00	NQ	Futures	7839.58	7882.88	7825.05	7878.43	42305.0
2018-02-14 13:00:00	NQ	Futures	7878.43	7907.2	7876.36	7895.64	44797.0
2018-02-14 14:00:00	NQ	Futures	7895.93	7914.91	7892.97	7906.61	32169.0
2018-02-14 15:00:00	NQ	Futures	7906.31	7936.86	7906.31	7925.89	48840.0
2018-02-14 16:00:00	NQ	Futures	7925.89	7940.12	7915.21	7920.85	11710.0
2018-02-14 18:00:00	NQ	Futures	7926.18	7930.93	7919.36	7923.81	1926.0
2018-02-14 19:00:00	NQ	Futures	7923.22	7935.68	7918.47	7931.23	2955.0
2018-02-14 20:00:00	NQ	Futures	7931.52	7961.78	7929.15	7959.4	7269.0
2018-02-14 21:00:00	NQ	Futures	7959.4	7964.15	7956.14	7962.67	2561.0
2018-02-14 22:00:00	NQ	Futures	7962.67	7986.99	7960.29	7984.32	4768.0
2018-02-14 23:00:00	NQ	Futures	7984.61	7986.99	7976.9	7981.94	2616.0
2018-02-14 00:00:00	YM	Futures	26812.2	26853.5	26811.2	26830.7	2394.0
2018-02-14 01:00:00	YM	Futures	26830.7	26848.1	26824.2	26831.8	1336.0
2018-02-14 02:00:00	YM	Futures	26831.8	26967.7	26826.4	26929.6	5706.0
2018-02-14 03:00:00	YM	Futures	26931.8	26953.5	26902.5	26942.7	4221.0

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

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