PREVIEW / futures_1hour / 2019-03-21

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-03-21.parquet
  size:    56 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-21 00:00:00	ES	Futures	3067.79	3069.42	3066.17	3068.06	5547.0
2019-03-21 01:00:00	ES	Futures	3068.34	3070.23	3066.44	3066.44	5675.0
2019-03-21 02:00:00	ES	Futures	3066.44	3067.79	3059.66	3060.74	10805.0
2019-03-21 03:00:00	ES	Futures	3060.74	3062.91	3058.3	3058.85	14085.0
2019-03-21 04:00:00	ES	Futures	3059.12	3064.81	3058.3	3061.02	22769.0
2019-03-21 05:00:00	ES	Futures	3060.74	3065.9	3060.74	3063.46	13737.0
2019-03-21 06:00:00	ES	Futures	3063.46	3065.9	3062.1	3064.81	12984.0
2019-03-21 07:00:00	ES	Futures	3064.81	3065.08	3052.61	3054.24	37742.0
2019-03-21 08:00:00	ES	Futures	3053.97	3056.68	3051.26	3056.14	36860.0
2019-03-21 09:00:00	ES	Futures	3056.14	3077.55	3055.86	3074.03	207966.0
2019-03-21 10:00:00	ES	Futures	3074.03	3085.14	3073.76	3084.87	264279.0
2019-03-21 11:00:00	ES	Futures	3085.14	3097.61	3084.87	3096.8	240833.0
2019-03-21 12:00:00	ES	Futures	3096.8	3097.34	3086.5	3089.75	146807.0
2019-03-21 13:00:00	ES	Futures	3089.75	3097.89	3089.48	3095.72	116234.0
2019-03-21 14:00:00	ES	Futures	3095.45	3105.75	3095.45	3102.77	144655.0
2019-03-21 15:00:00	ES	Futures	3103.04	3107.92	3099.51	3102.49	231975.0
2019-03-21 16:00:00	ES	Futures	3102.49	3104.93	3099.78	3101.68	62421.0
2019-03-21 18:00:00	ES	Futures	3100.87	3104.12	3100.05	3102.77	5694.0
2019-03-21 19:00:00	ES	Futures	3102.49	3104.12	3100.87	3103.58	4489.0
2019-03-21 20:00:00	ES	Futures	3103.31	3106.56	3102.77	3103.85	12203.0
2019-03-21 21:00:00	ES	Futures	3103.85	3104.39	3100.33	3102.77	10666.0
2019-03-21 22:00:00	ES	Futures	3102.77	3103.31	3097.07	3097.34	11449.0
2019-03-21 23:00:00	ES	Futures	3097.07	3099.78	3097.07	3098.97	6590.0
2019-03-21 00:00:00	NQ	Futures	8648.21	8654.32	8642.97	8650.54	2316.0
2019-03-21 01:00:00	NQ	Futures	8651.12	8656.36	8645.3	8646.17	2241.0
2019-03-21 02:00:00	NQ	Futures	8646.46	8649.37	8622.88	8626.37	4186.0
2019-03-21 03:00:00	NQ	Futures	8626.08	8630.74	8618.51	8621.42	5281.0
2019-03-21 04:00:00	NQ	Futures	8621.42	8637.73	8617.93	8626.08	8463.0
2019-03-21 05:00:00	NQ	Futures	8626.08	8641.22	8625.79	8635.4	4702.0
2019-03-21 06:00:00	NQ	Futures	8635.4	8642.97	8630.16	8639.76	4096.0
2019-03-21 07:00:00	NQ	Futures	8639.76	8640.35	8586.19	8593.47	17459.0
2019-03-21 08:00:00	NQ	Futures	8592.6	8599.88	8580.66	8598.42	10660.0
2019-03-21 09:00:00	NQ	Futures	8598.71	8674.12	8596.96	8659.27	74991.0
2019-03-21 10:00:00	NQ	Futures	8659.56	8697.7	8657.23	8697.41	80287.0
2019-03-21 11:00:00	NQ	Futures	8697.41	8722.16	8692.46	8721.0	72602.0
2019-03-21 12:00:00	NQ	Futures	8720.71	8722.45	8695.08	8707.31	43362.0
2019-03-21 13:00:00	NQ	Futures	8707.31	8735.55	8707.02	8730.02	40342.0
2019-03-21 14:00:00	NQ	Futures	8730.31	8769.04	8729.44	8763.51	48031.0
2019-03-21 15:00:00	NQ	Futures	8763.8	8778.06	8755.35	8765.84	66197.0
2019-03-21 16:00:00	NQ	Futures	8765.84	8782.43	8760.3	8769.62	14829.0
2019-03-21 18:00:00	NQ	Futures	8765.84	8775.73	8763.51	8770.2	2550.0
2019-03-21 19:00:00	NQ	Futures	8770.2	8776.32	8763.51	8775.44	2499.0
2019-03-21 20:00:00	NQ	Futures	8775.15	8786.8	8772.24	8778.06	5794.0
2019-03-21 21:00:00	NQ	Futures	8777.77	8779.23	8767.0	8771.95	4878.0
2019-03-21 22:00:00	NQ	Futures	8772.24	8774.28	8753.02	8753.02	6388.0
2019-03-21 23:00:00	NQ	Futures	8753.02	8762.63	8751.57	8760.3	4092.0
2019-03-21 00:00:00	YM	Futures	28003.1	28023.7	27986.8	28015.0	1264.0
2019-03-21 01:00:00	YM	Futures	28015.0	28035.7	27993.3	27995.5	1514.0
2019-03-21 02:00:00	YM	Futures	27995.5	28006.3	27899.8	27913.9	3311.0
2019-03-21 03:00:00	YM	Futures	27911.7	27933.5	27886.7	27887.8	3730.0

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

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