PREVIEW / futures_1hour / 2018-10-04

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-10-04.parquet
  size:    55 KB
  rows:    1,709

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-10-04 00:00:00	ES	Futures	3175.04	3178.03	3174.49	3176.94	9449.0
2018-10-04 01:00:00	ES	Futures	3176.94	3176.94	3173.4	3174.22	8381.0
2018-10-04 02:00:00	ES	Futures	3174.49	3175.58	3171.77	3175.04	15339.0
2018-10-04 03:00:00	ES	Futures	3175.31	3176.12	3169.6	3174.22	34631.0
2018-10-04 04:00:00	ES	Futures	3174.22	3174.49	3169.87	3172.04	16744.0
2018-10-04 05:00:00	ES	Futures	3172.32	3175.31	3169.6	3173.95	30249.0
2018-10-04 06:00:00	ES	Futures	3173.95	3178.03	3173.4	3178.03	23930.0
2018-10-04 07:00:00	ES	Futures	3177.76	3179.12	3175.31	3177.76	22928.0
2018-10-04 08:00:00	ES	Futures	3178.03	3179.93	3174.22	3179.12	39896.0
2018-10-04 09:00:00	ES	Futures	3178.84	3181.29	3174.49	3175.58	196219.0
2018-10-04 10:00:00	ES	Futures	3175.58	3175.58	3161.16	3164.16	357277.0
2018-10-04 11:00:00	ES	Futures	3164.16	3169.6	3158.17	3158.72	205454.0
2018-10-04 12:00:00	ES	Futures	3158.72	3160.62	3148.38	3153.82	243679.0
2018-10-04 13:00:00	ES	Futures	3153.82	3154.91	3144.84	3147.02	212528.0
2018-10-04 14:00:00	ES	Futures	3147.02	3158.17	3141.85	3157.36	264180.0
2018-10-04 15:00:00	ES	Futures	3157.08	3163.88	3152.19	3161.98	304969.0
2018-10-04 16:00:00	ES	Futures	3162.25	3166.6	3161.71	3166.6	77283.0
2018-10-04 18:00:00	ES	Futures	3166.06	3166.6	3163.88	3164.43	5828.0
2018-10-04 19:00:00	ES	Futures	3164.43	3166.88	3163.88	3166.06	3473.0
2018-10-04 20:00:00	ES	Futures	3166.33	3170.41	3164.97	3169.87	11217.0
2018-10-04 21:00:00	ES	Futures	3169.87	3172.04	3167.96	3168.78	12665.0
2018-10-04 22:00:00	ES	Futures	3168.51	3169.32	3162.8	3165.24	12337.0
2018-10-04 23:00:00	ES	Futures	3165.24	3167.42	3164.43	3166.88	4382.0
2018-10-04 00:00:00	NQ	Futures	8943.73	8960.16	8941.68	8952.83	3496.0
2018-10-04 01:00:00	NQ	Futures	8952.53	8953.12	8938.16	8940.51	3274.0
2018-10-04 02:00:00	NQ	Futures	8940.8	8945.79	8927.6	8945.79	6315.0
2018-10-04 03:00:00	NQ	Futures	8945.49	8947.84	8925.26	8942.27	9270.0
2018-10-04 04:00:00	NQ	Futures	8942.27	8944.03	8923.5	8930.83	6118.0
2018-10-04 05:00:00	NQ	Futures	8931.42	8939.63	8919.39	8931.71	7422.0
2018-10-04 06:00:00	NQ	Futures	8931.71	8946.37	8930.24	8945.49	4201.0
2018-10-04 07:00:00	NQ	Futures	8945.79	8953.41	8934.94	8944.03	6670.0
2018-10-04 08:00:00	NQ	Futures	8944.32	8950.77	8928.48	8946.96	11685.0
2018-10-04 09:00:00	NQ	Futures	8946.67	8955.47	8889.47	8905.9	86597.0
2018-10-04 10:00:00	NQ	Futures	8905.6	8906.19	8841.66	8848.11	120493.0
2018-10-04 11:00:00	NQ	Futures	8848.11	8870.11	8817.32	8822.89	79728.0
2018-10-04 12:00:00	NQ	Futures	8823.18	8830.22	8784.17	8793.56	81447.0
2018-10-04 13:00:00	NQ	Futures	8793.56	8802.36	8758.07	8767.45	71341.0
2018-10-04 14:00:00	NQ	Futures	8767.45	8809.1	8748.39	8804.7	78116.0
2018-10-04 15:00:00	NQ	Futures	8804.41	8823.18	8782.12	8815.85	67719.0
2018-10-04 16:00:00	NQ	Futures	8815.56	8827.58	8809.1	8827.0	13368.0
2018-10-04 18:00:00	NQ	Futures	8824.06	8826.41	8813.8	8816.14	2616.0
2018-10-04 19:00:00	NQ	Futures	8816.14	8824.36	8812.92	8822.89	1276.0
2018-10-04 20:00:00	NQ	Futures	8823.18	8840.78	8817.9	8837.56	4147.0
2018-10-04 21:00:00	NQ	Futures	8837.56	8846.35	8829.64	8833.16	4755.0
2018-10-04 22:00:00	NQ	Futures	8833.45	8837.56	8802.65	8815.56	6992.0
2018-10-04 23:00:00	NQ	Futures	8815.26	8823.77	8811.16	8821.72	2312.0
2018-10-04 00:00:00	YM	Futures	29083.8	29114.2	29079.4	29101.1	1801.0
2018-10-04 01:00:00	YM	Futures	29102.2	29102.2	29062.0	29077.2	2392.0
2018-10-04 02:00:00	YM	Futures	29077.2	29095.7	29046.8	29092.5	3810.0
2018-10-04 03:00:00	YM	Futures	29091.4	29102.2	29042.5	29082.7	6671.0

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

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