PREVIEW / futures_1hour / 2017-11-20

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-11-20.parquet
  size:    52 KB
  rows:    1,635

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
2017-11-20 00:00:00	ES	Futures	2813.0	2814.37	2812.73	2813.82	3876.0
2017-11-20 01:00:00	ES	Futures	2813.82	2815.19	2809.99	2811.64	8614.0
2017-11-20 02:00:00	ES	Futures	2811.36	2813.82	2810.81	2813.55	14914.0
2017-11-20 03:00:00	ES	Futures	2813.55	2815.74	2812.18	2814.92	27925.0
2017-11-20 04:00:00	ES	Futures	2814.92	2816.29	2814.1	2814.92	13337.0
2017-11-20 05:00:00	ES	Futures	2815.19	2817.38	2814.92	2816.83	16608.0
2017-11-20 06:00:00	ES	Futures	2816.83	2819.29	2816.56	2818.2	15830.0
2017-11-20 07:00:00	ES	Futures	2818.47	2819.29	2817.11	2817.65	16548.0
2017-11-20 08:00:00	ES	Futures	2817.93	2822.03	2817.11	2821.21	27092.0
2017-11-20 09:00:00	ES	Futures	2821.48	2823.67	2819.84	2823.12	132800.0
2017-11-20 10:00:00	ES	Futures	2823.12	2825.04	2820.94	2824.49	127504.0
2017-11-20 11:00:00	ES	Futures	2824.77	2825.86	2823.67	2825.04	87640.0
2017-11-20 12:00:00	ES	Futures	2825.04	2825.59	2822.85	2825.04	67580.0
2017-11-20 13:00:00	ES	Futures	2825.31	2826.95	2824.49	2826.68	61353.0
2017-11-20 14:00:00	ES	Futures	2826.68	2826.95	2825.31	2825.86	42555.0
2017-11-20 15:00:00	ES	Futures	2826.13	2827.5	2822.85	2824.77	150465.0
2017-11-20 16:00:00	ES	Futures	2824.77	2826.68	2823.12	2825.59	103660.0
2017-11-20 18:00:00	ES	Futures	2825.31	2825.86	2823.4	2823.95	5134.0
2017-11-20 19:00:00	ES	Futures	2823.95	2825.59	2822.85	2823.95	6492.0
2017-11-20 20:00:00	ES	Futures	2823.95	2824.77	2822.3	2824.22	6473.0
2017-11-20 21:00:00	ES	Futures	2824.22	2826.13	2823.95	2825.04	5378.0
2017-11-20 22:00:00	ES	Futures	2825.04	2825.31	2824.49	2825.04	2786.0
2017-11-20 23:00:00	ES	Futures	2824.77	2825.86	2824.77	2825.86	1682.0
2017-11-20 00:00:00	NQ	Futures	7494.0	7499.95	7493.7	7498.46	1162.0
2017-11-20 01:00:00	NQ	Futures	7498.46	7504.71	7488.05	7493.41	2406.0
2017-11-20 02:00:00	NQ	Futures	7493.11	7502.03	7490.73	7501.44	2576.0
2017-11-20 03:00:00	NQ	Futures	7501.44	7505.01	7493.41	7501.14	3140.0
2017-11-20 04:00:00	NQ	Futures	7501.44	7506.49	7498.76	7501.44	1740.0
2017-11-20 05:00:00	NQ	Futures	7501.44	7510.36	7500.55	7508.87	1828.0
2017-11-20 06:00:00	NQ	Futures	7508.28	7516.61	7507.98	7513.33	2979.0
2017-11-20 07:00:00	NQ	Futures	7513.33	7516.9	7510.66	7512.14	2485.0
2017-11-20 08:00:00	NQ	Futures	7512.14	7523.45	7510.66	7521.36	6858.0
2017-11-20 09:00:00	NQ	Futures	7521.36	7529.69	7514.82	7524.34	32728.0
2017-11-20 10:00:00	NQ	Futures	7524.04	7527.31	7510.06	7518.99	36018.0
2017-11-20 11:00:00	NQ	Futures	7518.99	7521.96	7510.06	7516.61	20339.0
2017-11-20 12:00:00	NQ	Futures	7516.61	7518.09	7500.84	7513.04	21505.0
2017-11-20 13:00:00	NQ	Futures	7513.33	7518.09	7510.95	7515.71	12159.0
2017-11-20 14:00:00	NQ	Futures	7515.71	7516.31	7509.47	7512.14	11549.0
2017-11-20 15:00:00	NQ	Futures	7512.14	7517.2	7504.71	7511.25	21948.0
2017-11-20 16:00:00	NQ	Futures	7511.25	7516.31	7509.47	7515.71	6361.0
2017-11-20 18:00:00	NQ	Futures	7513.63	7513.93	7510.06	7513.04	740.0
2017-11-20 19:00:00	NQ	Futures	7512.14	7516.01	7508.87	7512.44	1110.0
2017-11-20 20:00:00	NQ	Futures	7513.04	7517.2	7508.28	7515.42	1614.0
2017-11-20 21:00:00	NQ	Futures	7515.71	7522.26	7515.42	7518.99	1717.0
2017-11-20 22:00:00	NQ	Futures	7518.99	7519.88	7517.2	7518.99	716.0
2017-11-20 23:00:00	NQ	Futures	7518.39	7520.77	7518.39	7520.47	433.0
2017-11-20 00:00:00	YM	Futures	25301.7	25321.3	25300.6	25316.9	1074.0
2017-11-20 01:00:00	YM	Futures	25316.9	25328.9	25294.1	25305.0	1634.0
2017-11-20 02:00:00	YM	Futures	25305.0	25321.3	25298.4	25320.2	2037.0
2017-11-20 03:00:00	YM	Futures	25320.2	25333.3	25306.1	25326.7	3080.0

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

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