PREVIEW / futures_1hour / 2019-03-26

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-03-26.parquet
  size:    55 KB
  rows:    1,746

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-03-26 00:00:00	ES	Futures	3053.15	3054.24	3051.8	3052.61	3585.0
2019-03-26 01:00:00	ES	Futures	3052.88	3055.05	3052.61	3054.51	6278.0
2019-03-26 02:00:00	ES	Futures	3054.51	3054.78	3046.92	3050.71	10826.0
2019-03-26 03:00:00	ES	Futures	3050.44	3052.61	3046.65	3051.8	10181.0
2019-03-26 04:00:00	ES	Futures	3052.07	3052.61	3046.38	3046.92	17934.0
2019-03-26 05:00:00	ES	Futures	3046.92	3055.59	3046.92	3054.78	17925.0
2019-03-26 06:00:00	ES	Futures	3055.05	3059.12	3054.51	3058.85	20890.0
2019-03-26 07:00:00	ES	Futures	3058.85	3060.74	3057.22	3059.12	16094.0
2019-03-26 08:00:00	ES	Futures	3059.12	3062.1	3056.14	3056.41	31446.0
2019-03-26 09:00:00	ES	Futures	3056.68	3072.13	3056.41	3072.13	201263.0
2019-03-26 10:00:00	ES	Futures	3071.86	3074.3	3064.0	3073.49	210215.0
2019-03-26 11:00:00	ES	Futures	3073.49	3074.3	3059.12	3062.37	162890.0
2019-03-26 12:00:00	ES	Futures	3062.37	3065.08	3052.88	3056.95	146343.0
2019-03-26 13:00:00	ES	Futures	3057.22	3060.74	3049.63	3050.44	117245.0
2019-03-26 14:00:00	ES	Futures	3050.17	3054.24	3045.56	3053.7	122969.0
2019-03-26 15:00:00	ES	Futures	3053.7	3062.37	3048.55	3061.56	214627.0
2019-03-26 16:00:00	ES	Futures	3061.29	3063.18	3058.85	3062.64	58510.0
2019-03-26 18:00:00	ES	Futures	3061.83	3062.37	3058.03	3058.3	5556.0
2019-03-26 19:00:00	ES	Futures	3058.3	3061.29	3056.95	3061.02	9276.0
2019-03-26 20:00:00	ES	Futures	3060.74	3063.18	3056.41	3060.2	22049.0
2019-03-26 21:00:00	ES	Futures	3060.2	3061.29	3055.86	3059.66	18693.0
2019-03-26 22:00:00	ES	Futures	3059.93	3064.27	3058.3	3062.37	14058.0
2019-03-26 23:00:00	ES	Futures	3062.64	3063.46	3061.02	3062.37	8831.0
2019-03-26 00:00:00	NQ	Futures	8592.6	8595.51	8586.19	8587.94	1921.0
2019-03-26 01:00:00	NQ	Futures	8588.52	8596.38	8587.36	8591.72	2643.0
2019-03-26 02:00:00	NQ	Futures	8592.31	8594.05	8567.56	8578.04	5656.0
2019-03-26 03:00:00	NQ	Futures	8577.75	8585.03	8565.23	8582.99	5663.0
2019-03-26 04:00:00	NQ	Futures	8582.99	8586.77	8568.14	8570.18	8536.0
2019-03-26 05:00:00	NQ	Futures	8570.18	8597.26	8569.89	8594.64	8260.0
2019-03-26 06:00:00	NQ	Futures	8594.93	8605.41	8592.89	8603.66	7361.0
2019-03-26 07:00:00	NQ	Futures	8603.37	8613.27	8602.21	8610.07	7171.0
2019-03-26 08:00:00	NQ	Futures	8610.65	8621.71	8603.08	8605.7	11868.0
2019-03-26 09:00:00	NQ	Futures	8605.41	8666.84	8604.83	8666.26	79140.0
2019-03-26 10:00:00	NQ	Futures	8666.55	8673.54	8620.26	8651.7	92263.0
2019-03-26 11:00:00	NQ	Futures	8651.7	8655.78	8603.08	8615.02	68119.0
2019-03-26 12:00:00	NQ	Futures	8614.73	8628.99	8589.39	8607.16	60283.0
2019-03-26 13:00:00	NQ	Futures	8606.86	8619.38	8572.8	8574.84	45373.0
2019-03-26 14:00:00	NQ	Futures	8575.13	8581.82	8554.75	8572.22	47306.0
2019-03-26 15:00:00	NQ	Futures	8572.51	8593.76	8548.92	8592.6	63397.0
2019-03-26 16:00:00	NQ	Futures	8592.31	8602.79	8586.19	8599.0	12620.0
2019-03-26 18:00:00	NQ	Futures	8599.0	8599.29	8585.9	8587.65	2373.0
2019-03-26 19:00:00	NQ	Futures	8587.07	8594.93	8578.91	8593.47	3773.0
2019-03-26 20:00:00	NQ	Futures	8593.18	8600.75	8579.79	8590.27	8077.0
2019-03-26 21:00:00	NQ	Futures	8589.69	8594.64	8576.87	8589.69	6025.0
2019-03-26 22:00:00	NQ	Futures	8589.69	8604.83	8584.44	8599.88	4747.0
2019-03-26 23:00:00	NQ	Futures	8599.59	8602.79	8594.93	8596.96	2798.0
2019-03-26 00:00:00	YM	Futures	27910.6	27924.8	27900.8	27910.6	1185.0
2019-03-26 01:00:00	YM	Futures	27911.7	27935.6	27911.7	27923.7	1875.0
2019-03-26 02:00:00	YM	Futures	27924.8	27928.0	27859.5	27895.4	2693.0
2019-03-26 03:00:00	YM	Futures	27895.4	27912.8	27864.9	27906.3	3326.0

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

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