PREVIEW / futures_1hour / 2018-11-20

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-11-20.parquet
  size:    57 KB
  rows:    1,720

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
2018-11-20 00:00:00	ES	Futures	2923.71	2928.06	2923.16	2926.97	7951.0
2018-11-20 01:00:00	ES	Futures	2926.7	2927.52	2924.25	2925.07	5148.0
2018-11-20 02:00:00	ES	Futures	2925.07	2926.16	2918.54	2921.26	10586.0
2018-11-20 03:00:00	ES	Futures	2921.26	2925.07	2912.83	2913.1	28065.0
2018-11-20 04:00:00	ES	Futures	2913.1	2917.45	2908.75	2911.47	25423.0
2018-11-20 05:00:00	ES	Futures	2911.47	2917.18	2909.02	2912.28	23749.0
2018-11-20 06:00:00	ES	Futures	2912.28	2919.63	2908.2	2916.91	28169.0
2018-11-20 07:00:00	ES	Futures	2916.91	2916.91	2896.24	2897.05	53255.0
2018-11-20 08:00:00	ES	Futures	2897.05	2901.68	2888.62	2889.71	81040.0
2018-11-20 09:00:00	ES	Futures	2889.44	2895.69	2873.39	2879.65	411938.0
2018-11-20 10:00:00	ES	Futures	2879.65	2903.04	2865.5	2901.4	475176.0
2018-11-20 11:00:00	ES	Futures	2901.4	2903.31	2881.82	2897.6	297349.0
2018-11-20 12:00:00	ES	Futures	2897.6	2905.76	2884.81	2885.9	194853.0
2018-11-20 13:00:00	ES	Futures	2885.9	2889.17	2875.84	2876.93	170505.0
2018-11-20 14:00:00	ES	Futures	2876.93	2886.45	2870.13	2874.48	201482.0
2018-11-20 15:00:00	ES	Futures	2874.75	2884.54	2863.33	2875.02	323934.0
2018-11-20 16:00:00	ES	Futures	2875.02	2875.57	2868.22	2869.04	94983.0
2018-11-20 18:00:00	ES	Futures	2872.03	2872.03	2863.87	2868.49	13073.0
2018-11-20 19:00:00	ES	Futures	2868.77	2876.65	2868.22	2874.75	14589.0
2018-11-20 20:00:00	ES	Futures	2875.02	2881.28	2871.49	2879.65	13126.0
2018-11-20 21:00:00	ES	Futures	2879.65	2884.27	2878.56	2880.19	11083.0
2018-11-20 22:00:00	ES	Futures	2880.46	2884.27	2880.19	2882.09	7657.0
2018-11-20 23:00:00	ES	Futures	2882.09	2885.09	2880.73	2884.54	4724.0
2018-11-20 00:00:00	NQ	Futures	7793.65	7807.14	7790.72	7800.4	3080.0
2018-11-20 01:00:00	NQ	Futures	7799.81	7803.04	7788.08	7792.77	2893.0
2018-11-20 02:00:00	NQ	Futures	7792.48	7796.29	7764.61	7770.19	6596.0
2018-11-20 03:00:00	NQ	Futures	7769.89	7786.61	7749.36	7751.12	12586.0
2018-11-20 04:00:00	NQ	Futures	7751.12	7765.49	7728.24	7743.49	15322.0
2018-11-20 05:00:00	NQ	Futures	7743.79	7758.75	7728.53	7736.16	11553.0
2018-11-20 06:00:00	NQ	Futures	7736.75	7763.15	7713.28	7750.83	17485.0
2018-11-20 07:00:00	NQ	Futures	7751.12	7751.41	7687.76	7689.52	27116.0
2018-11-20 08:00:00	NQ	Futures	7690.11	7706.83	7645.23	7652.27	41523.0
2018-11-20 09:00:00	NQ	Futures	7652.57	7694.22	7598.6	7631.74	149734.0
2018-11-20 10:00:00	NQ	Futures	7631.74	7759.04	7566.92	7754.93	168978.0
2018-11-20 11:00:00	NQ	Futures	7754.64	7762.85	7688.06	7745.25	108762.0
2018-11-20 12:00:00	NQ	Futures	7744.96	7773.12	7698.03	7701.55	74575.0
2018-11-20 13:00:00	NQ	Futures	7701.84	7715.04	7660.78	7661.95	58992.0
2018-11-20 14:00:00	NQ	Futures	7661.66	7693.34	7641.42	7656.97	66317.0
2018-11-20 15:00:00	NQ	Futures	7656.67	7688.06	7614.44	7668.41	90974.0
2018-11-20 16:00:00	NQ	Futures	7668.41	7669.58	7652.57	7653.15	13754.0
2018-11-20 18:00:00	NQ	Futures	7658.73	7661.07	7636.73	7648.17	4931.0
2018-11-20 19:00:00	NQ	Futures	7647.87	7683.36	7646.7	7675.15	7200.0
2018-11-20 20:00:00	NQ	Futures	7675.44	7697.44	7664.59	7692.16	12222.0
2018-11-20 21:00:00	NQ	Futures	7691.87	7706.54	7681.9	7687.18	4743.0
2018-11-20 22:00:00	NQ	Futures	7688.06	7705.36	7688.06	7698.03	3654.0
2018-11-20 23:00:00	NQ	Futures	7698.32	7706.54	7690.4	7704.48	3246.0
2018-11-20 00:00:00	YM	Futures	27109.6	27149.8	27098.7	27135.6	2162.0
2018-11-20 01:00:00	YM	Futures	27134.6	27141.1	27115.0	27123.7	1800.0
2018-11-20 02:00:00	YM	Futures	27121.5	27134.6	27066.1	27091.1	3889.0
2018-11-20 03:00:00	YM	Futures	27090.0	27117.2	27007.4	27010.7	8779.0

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

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