PREVIEW / futures_1hour / 2019-05-28

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-05-28.parquet
  size:    59 KB
  rows:    1,845

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
2019-05-28 00:00:00	ES	Futures	3077.55	3078.64	3076.74	3077.28	3623.0
2019-05-28 01:00:00	ES	Futures	3077.28	3079.72	3076.47	3077.82	7450.0
2019-05-28 02:00:00	ES	Futures	3077.82	3078.1	3071.86	3074.3	11301.0
2019-05-28 03:00:00	ES	Futures	3074.3	3075.66	3068.61	3071.59	25220.0
2019-05-28 04:00:00	ES	Futures	3071.86	3071.86	3061.56	3062.1	29702.0
2019-05-28 05:00:00	ES	Futures	3062.37	3068.88	3062.1	3068.34	22278.0
2019-05-28 06:00:00	ES	Futures	3068.34	3068.34	3060.2	3066.44	21360.0
2019-05-28 07:00:00	ES	Futures	3066.44	3071.86	3063.18	3070.5	21369.0
2019-05-28 08:00:00	ES	Futures	3070.78	3075.11	3067.25	3069.69	46179.0
2019-05-28 09:00:00	ES	Futures	3069.96	3081.08	3068.34	3078.37	157167.0
2019-05-28 10:00:00	ES	Futures	3078.37	3079.99	3063.73	3066.71	211592.0
2019-05-28 11:00:00	ES	Futures	3066.71	3072.94	3062.91	3068.88	157324.0
2019-05-28 12:00:00	ES	Futures	3068.61	3072.94	3066.98	3067.79	83677.0
2019-05-28 13:00:00	ES	Futures	3067.52	3069.42	3064.27	3064.54	70176.0
2019-05-28 14:00:00	ES	Futures	3064.27	3064.54	3051.8	3053.7	138111.0
2019-05-28 15:00:00	ES	Futures	3053.7	3053.97	3037.43	3037.7	309689.0
2019-05-28 16:00:00	ES	Futures	3037.97	3043.94	3036.89	3041.77	93977.0
2019-05-28 18:00:00	ES	Futures	3040.95	3042.58	3038.51	3042.04	8333.0
2019-05-28 19:00:00	ES	Futures	3042.31	3042.85	3038.79	3041.5	5669.0
2019-05-28 20:00:00	ES	Futures	3041.5	3042.31	3028.75	3031.19	34018.0
2019-05-28 21:00:00	ES	Futures	3031.19	3034.45	3027.94	3028.48	20698.0
2019-05-28 22:00:00	ES	Futures	3028.48	3032.28	3028.48	3029.84	11267.0
2019-05-28 23:00:00	ES	Futures	3030.11	3032.82	3029.57	3032.28	5717.0
2019-05-28 00:00:00	NQ	Futures	8553.58	8558.53	8550.09	8553.58	1520.0
2019-05-28 01:00:00	NQ	Futures	8553.58	8565.52	8551.25	8558.82	3447.0
2019-05-28 02:00:00	NQ	Futures	8558.82	8560.28	8536.11	8541.35	5528.0
2019-05-28 03:00:00	NQ	Futures	8541.65	8546.3	8523.01	8532.62	9513.0
2019-05-28 04:00:00	NQ	Futures	8532.91	8532.91	8497.39	8500.59	13608.0
2019-05-28 05:00:00	NQ	Futures	8500.59	8526.21	8500.01	8523.88	9591.0
2019-05-28 06:00:00	NQ	Futures	8524.18	8524.18	8491.57	8516.9	11119.0
2019-05-28 07:00:00	NQ	Futures	8516.9	8537.86	8503.21	8530.87	9352.0
2019-05-28 08:00:00	NQ	Futures	8531.16	8549.51	8522.14	8529.13	16700.0
2019-05-28 09:00:00	NQ	Futures	8529.42	8585.32	8525.34	8570.18	56834.0
2019-05-28 10:00:00	NQ	Futures	8569.6	8575.42	8526.8	8538.73	76522.0
2019-05-28 11:00:00	NQ	Futures	8538.73	8560.86	8527.38	8556.2	58888.0
2019-05-28 12:00:00	NQ	Futures	8555.91	8566.39	8548.63	8550.38	31149.0
2019-05-28 13:00:00	NQ	Futures	8550.38	8555.33	8538.15	8544.85	22842.0
2019-05-28 14:00:00	NQ	Futures	8544.27	8544.85	8506.71	8514.86	36382.0
2019-05-28 15:00:00	NQ	Futures	8514.57	8515.15	8478.76	8482.54	62847.0
2019-05-28 16:00:00	NQ	Futures	8482.54	8498.85	8479.63	8493.02	13314.0
2019-05-28 18:00:00	NQ	Futures	8491.86	8497.1	8481.96	8493.6	2702.0
2019-05-28 19:00:00	NQ	Futures	8493.31	8497.1	8480.79	8488.65	3002.0
2019-05-28 20:00:00	NQ	Futures	8488.65	8491.28	8446.15	8451.68	13033.0
2019-05-28 21:00:00	NQ	Futures	8451.97	8460.12	8437.99	8438.28	9212.0
2019-05-28 22:00:00	NQ	Futures	8438.58	8449.64	8434.79	8438.58	5610.0
2019-05-28 23:00:00	NQ	Futures	8438.58	8449.93	8436.25	8447.6	2714.0
2019-05-28 00:00:00	YM	Futures	27940.0	27947.6	27932.4	27934.6	1310.0
2019-05-28 01:00:00	YM	Futures	27934.6	27959.6	27932.4	27942.2	2326.0
2019-05-28 02:00:00	YM	Futures	27942.2	27946.5	27900.8	27916.1	3334.0
2019-05-28 03:00:00	YM	Futures	27917.2	27924.8	27868.2	27891.0	4919.0

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

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