PREVIEW / futures_1hour / 2019-05-23

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-05-23.parquet
  size:    61 KB
  rows:    1,874

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-23 00:00:00	ES	Futures	3087.31	3087.85	3086.23	3087.58	2664.0
2019-05-23 01:00:00	ES	Futures	3087.31	3088.13	3082.7	3084.87	7901.0
2019-05-23 02:00:00	ES	Futures	3084.6	3085.14	3078.1	3078.1	16783.0
2019-05-23 03:00:00	ES	Futures	3078.1	3080.81	3074.57	3079.99	36554.0
2019-05-23 04:00:00	ES	Futures	3079.72	3079.99	3071.32	3075.93	37644.0
2019-05-23 05:00:00	ES	Futures	3076.2	3076.47	3065.9	3066.98	38112.0
2019-05-23 06:00:00	ES	Futures	3066.71	3071.05	3063.73	3068.88	30502.0
2019-05-23 07:00:00	ES	Futures	3068.88	3075.11	3068.88	3072.67	38645.0
2019-05-23 08:00:00	ES	Futures	3072.94	3076.47	3068.61	3071.59	52324.0
2019-05-23 09:00:00	ES	Futures	3071.86	3072.4	3054.51	3058.3	263470.0
2019-05-23 10:00:00	ES	Futures	3058.3	3067.52	3052.88	3065.08	256255.0
2019-05-23 11:00:00	ES	Futures	3064.81	3065.35	3049.9	3050.44	212152.0
2019-05-23 12:00:00	ES	Futures	3050.17	3057.22	3045.56	3046.38	193997.0
2019-05-23 13:00:00	ES	Futures	3046.11	3052.88	3043.94	3049.09	135556.0
2019-05-23 14:00:00	ES	Futures	3049.09	3051.8	3043.12	3046.11	127758.0
2019-05-23 15:00:00	ES	Futures	3046.11	3062.37	3042.58	3061.02	365507.0
2019-05-23 16:00:00	ES	Futures	3060.74	3061.29	3056.68	3059.12	72701.0
2019-05-23 18:00:00	ES	Futures	3059.93	3063.46	3057.22	3058.58	9349.0
2019-05-23 19:00:00	ES	Futures	3058.58	3063.18	3058.03	3061.56	5732.0
2019-05-23 20:00:00	ES	Futures	3061.83	3066.44	3061.56	3063.46	15410.0
2019-05-23 21:00:00	ES	Futures	3063.46	3069.42	3063.18	3066.44	18750.0
2019-05-23 22:00:00	ES	Futures	3066.17	3068.06	3064.0	3066.71	11114.0
2019-05-23 23:00:00	ES	Futures	3066.71	3067.25	3064.0	3066.44	7233.0
2019-05-23 00:00:00	NQ	Futures	8603.95	8605.41	8599.0	8604.53	1441.0
2019-05-23 01:00:00	NQ	Futures	8604.53	8607.45	8591.43	8596.09	3457.0
2019-05-23 02:00:00	NQ	Futures	8596.38	8597.84	8569.3	8570.18	7084.0
2019-05-23 03:00:00	NQ	Futures	8570.18	8582.12	8558.53	8578.33	14465.0
2019-05-23 04:00:00	NQ	Futures	8577.46	8578.33	8546.59	8561.15	13628.0
2019-05-23 05:00:00	NQ	Futures	8560.86	8564.65	8530.58	8531.16	13243.0
2019-05-23 06:00:00	NQ	Futures	8531.45	8549.22	8520.39	8539.61	12495.0
2019-05-23 07:00:00	NQ	Futures	8539.61	8560.57	8539.61	8554.16	11804.0
2019-05-23 08:00:00	NQ	Futures	8554.46	8566.98	8537.28	8554.16	20656.0
2019-05-23 09:00:00	NQ	Futures	8554.46	8558.24	8511.07	8527.96	87215.0
2019-05-23 10:00:00	NQ	Futures	8527.67	8553.87	8503.21	8540.48	95175.0
2019-05-23 11:00:00	NQ	Futures	8540.77	8542.52	8491.86	8493.6	74090.0
2019-05-23 12:00:00	NQ	Futures	8493.6	8509.04	8466.82	8471.77	64955.0
2019-05-23 13:00:00	NQ	Futures	8471.48	8501.47	8464.49	8484.87	46282.0
2019-05-23 14:00:00	NQ	Futures	8484.58	8492.73	8467.11	8482.25	43396.0
2019-05-23 15:00:00	NQ	Futures	8481.96	8534.37	8468.56	8520.39	84959.0
2019-05-23 16:00:00	NQ	Futures	8520.39	8523.59	8511.07	8520.97	12386.0
2019-05-23 18:00:00	NQ	Futures	8521.26	8533.49	8511.07	8515.44	3615.0
2019-05-23 19:00:00	NQ	Futures	8515.73	8533.49	8514.57	8530.58	3009.0
2019-05-23 20:00:00	NQ	Futures	8530.87	8544.85	8530.87	8535.82	6053.0
2019-05-23 21:00:00	NQ	Futures	8535.53	8555.62	8534.95	8546.59	6657.0
2019-05-23 22:00:00	NQ	Futures	8546.59	8553.58	8539.61	8547.18	5059.0
2019-05-23 23:00:00	NQ	Futures	8547.18	8548.05	8535.24	8543.68	2771.0
2019-05-23 00:00:00	YM	Futures	27944.3	27946.5	27934.6	27945.4	976.0
2019-05-23 01:00:00	YM	Futures	27944.3	27949.8	27903.0	27918.2	2673.0
2019-05-23 02:00:00	YM	Futures	27919.3	27920.4	27853.0	27855.2	4848.0
2019-05-23 03:00:00	YM	Futures	27856.2	27884.5	27823.6	27872.6	9428.0

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

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