PREVIEW / futures_1hour / 2018-08-15

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-08-15.parquet
  size:    57 KB
  rows:    1,700

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-08-15 00:00:00	ES	Futures	3091.68	3091.68	3089.77	3091.68	4103.0
2018-08-15 01:00:00	ES	Futures	3091.4	3092.49	3090.04	3092.22	4042.0
2018-08-15 02:00:00	ES	Futures	3092.22	3094.67	3091.4	3093.85	7696.0
2018-08-15 03:00:00	ES	Futures	3093.85	3094.94	3091.4	3092.49	17295.0
2018-08-15 04:00:00	ES	Futures	3092.49	3094.13	3091.4	3092.49	6779.0
2018-08-15 05:00:00	ES	Futures	3092.49	3092.76	3087.86	3088.41	9198.0
2018-08-15 06:00:00	ES	Futures	3088.13	3089.22	3078.6	3079.69	46639.0
2018-08-15 07:00:00	ES	Futures	3079.96	3082.41	3074.51	3079.14	52898.0
2018-08-15 08:00:00	ES	Futures	3078.87	3081.32	3076.42	3076.69	36888.0
2018-08-15 09:00:00	ES	Futures	3076.42	3080.78	3067.97	3067.97	212207.0
2018-08-15 10:00:00	ES	Futures	3067.97	3068.24	3054.89	3056.25	340934.0
2018-08-15 11:00:00	ES	Futures	3056.25	3069.33	3055.71	3060.07	252878.0
2018-08-15 12:00:00	ES	Futures	3059.8	3071.79	3059.52	3069.61	154759.0
2018-08-15 13:00:00	ES	Futures	3069.33	3072.6	3063.34	3064.16	139955.0
2018-08-15 14:00:00	ES	Futures	3064.16	3067.15	3058.16	3066.88	157087.0
2018-08-15 15:00:00	ES	Futures	3067.15	3076.42	3066.34	3072.6	251810.0
2018-08-15 16:00:00	ES	Futures	3072.87	3076.96	3072.06	3076.14	74177.0
2018-08-15 18:00:00	ES	Futures	3075.87	3076.96	3074.24	3075.6	5921.0
2018-08-15 19:00:00	ES	Futures	3075.33	3075.87	3073.69	3074.24	3003.0
2018-08-15 20:00:00	ES	Futures	3074.24	3075.33	3070.7	3073.42	10986.0
2018-08-15 21:00:00	ES	Futures	3073.42	3086.77	3071.79	3083.77	39670.0
2018-08-15 22:00:00	ES	Futures	3084.05	3088.13	3081.87	3083.23	21163.0
2018-08-15 23:00:00	ES	Futures	3083.23	3084.86	3081.32	3084.05	8353.0
2018-08-15 00:00:00	NQ	Futures	8769.24	8771.01	8763.65	8769.83	1287.0
2018-08-15 01:00:00	NQ	Futures	8769.54	8773.66	8763.95	8770.42	1402.0
2018-08-15 02:00:00	NQ	Futures	8771.01	8778.96	8767.48	8777.49	1916.0
2018-08-15 03:00:00	NQ	Futures	8777.19	8783.67	8769.83	8773.07	3038.0
2018-08-15 04:00:00	NQ	Futures	8773.37	8780.43	8771.31	8776.02	1983.0
2018-08-15 05:00:00	NQ	Futures	8776.02	8776.61	8761.88	8763.36	2604.0
2018-08-15 06:00:00	NQ	Futures	8763.36	8765.12	8718.6	8724.79	14187.0
2018-08-15 07:00:00	NQ	Futures	8725.08	8729.2	8696.82	8711.54	15974.0
2018-08-15 08:00:00	NQ	Futures	8711.24	8720.08	8702.41	8703.0	11544.0
2018-08-15 09:00:00	NQ	Futures	8703.0	8736.27	8683.86	8684.45	75512.0
2018-08-15 10:00:00	NQ	Futures	8684.75	8684.75	8616.44	8626.45	120937.0
2018-08-15 11:00:00	NQ	Futures	8626.16	8664.43	8623.51	8625.27	80092.0
2018-08-15 12:00:00	NQ	Futures	8624.98	8670.91	8624.69	8659.43	41412.0
2018-08-15 13:00:00	NQ	Futures	8659.43	8673.26	8642.06	8648.53	31953.0
2018-08-15 14:00:00	NQ	Futures	8647.94	8659.43	8629.4	8659.43	33794.0
2018-08-15 15:00:00	NQ	Futures	8659.13	8685.34	8655.6	8673.85	57390.0
2018-08-15 16:00:00	NQ	Futures	8674.15	8693.87	8672.38	8691.22	11324.0
2018-08-15 18:00:00	NQ	Futures	8691.22	8695.93	8682.98	8684.45	1547.0
2018-08-15 19:00:00	NQ	Futures	8684.45	8685.92	8679.45	8681.21	1036.0
2018-08-15 20:00:00	NQ	Futures	8681.21	8686.51	8671.5	8679.74	3395.0
2018-08-15 21:00:00	NQ	Futures	8680.33	8723.32	8674.74	8715.07	8827.0
2018-08-15 22:00:00	NQ	Futures	8715.95	8740.69	8712.13	8718.02	8281.0
2018-08-15 23:00:00	NQ	Futures	8717.72	8723.32	8711.24	8718.6	3081.0
2018-08-15 00:00:00	YM	Futures	27449.2	27453.5	27427.4	27451.4	974.0
2018-08-15 01:00:00	YM	Futures	27451.4	27459.0	27436.1	27453.5	1314.0
2018-08-15 02:00:00	YM	Futures	27453.5	27481.8	27445.9	27478.5	2442.0
2018-08-15 03:00:00	YM	Futures	27478.5	27490.5	27449.2	27460.1	3076.0

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

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