PREVIEW / futures_1hour / 2019-01-10

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-01-10.parquet
  size:    57 KB
  rows:    1,745

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-01-10 00:00:00	ES	Futures	2796.23	2796.51	2789.72	2790.8	6952.0
2019-01-10 01:00:00	ES	Futures	2791.07	2793.79	2788.36	2789.99	6019.0
2019-01-10 02:00:00	ES	Futures	2789.99	2792.43	2787.0	2788.09	13298.0
2019-01-10 03:00:00	ES	Futures	2788.09	2790.8	2781.57	2784.83	26924.0
2019-01-10 04:00:00	ES	Futures	2784.83	2791.62	2784.83	2788.09	15657.0
2019-01-10 05:00:00	ES	Futures	2787.82	2794.61	2786.73	2788.09	17439.0
2019-01-10 06:00:00	ES	Futures	2788.36	2791.89	2786.73	2789.45	9607.0
2019-01-10 07:00:00	ES	Futures	2789.45	2794.33	2787.82	2793.25	16805.0
2019-01-10 08:00:00	ES	Futures	2793.25	2796.78	2789.72	2790.8	24996.0
2019-01-10 09:00:00	ES	Futures	2790.8	2793.79	2783.2	2787.27	164579.0
2019-01-10 10:00:00	ES	Futures	2787.54	2805.74	2785.1	2804.93	228640.0
2019-01-10 11:00:00	ES	Futures	2805.2	2813.62	2803.3	2811.72	132642.0
2019-01-10 12:00:00	ES	Futures	2811.72	2817.69	2806.55	2813.34	115651.0
2019-01-10 13:00:00	ES	Futures	2813.07	2813.89	2795.69	2804.38	170586.0
2019-01-10 14:00:00	ES	Futures	2804.11	2819.59	2803.84	2813.34	182057.0
2019-01-10 15:00:00	ES	Futures	2813.62	2823.12	2811.72	2820.95	198063.0
2019-01-10 16:00:00	ES	Futures	2820.95	2823.94	2816.88	2818.5	63264.0
2019-01-10 18:00:00	ES	Futures	2817.96	2818.5	2812.8	2814.43	7520.0
2019-01-10 19:00:00	ES	Futures	2814.7	2820.41	2814.16	2816.06	12074.0
2019-01-10 20:00:00	ES	Futures	2816.33	2818.5	2811.72	2815.52	12365.0
2019-01-10 21:00:00	ES	Futures	2815.79	2817.15	2810.63	2813.34	10100.0
2019-01-10 22:00:00	ES	Futures	2813.34	2815.79	2811.17	2814.7	5919.0
2019-01-10 23:00:00	ES	Futures	2814.97	2816.88	2813.62	2814.43	4127.0
2019-01-10 00:00:00	NQ	Futures	7693.93	7695.39	7667.63	7676.11	3921.0
2019-01-10 01:00:00	NQ	Futures	7676.69	7685.46	7668.8	7672.31	2802.0
2019-01-10 02:00:00	NQ	Futures	7672.31	7681.66	7662.96	7664.71	5317.0
2019-01-10 03:00:00	NQ	Futures	7665.29	7672.89	7644.26	7654.78	10732.0
2019-01-10 04:00:00	NQ	Futures	7655.07	7675.23	7653.9	7665.0	6665.0
2019-01-10 05:00:00	NQ	Futures	7664.71	7685.16	7661.2	7665.59	6767.0
2019-01-10 06:00:00	NQ	Futures	7665.88	7676.11	7662.67	7669.68	4012.0
2019-01-10 07:00:00	NQ	Futures	7669.68	7683.7	7658.87	7676.4	8962.0
2019-01-10 08:00:00	NQ	Futures	7676.11	7687.5	7667.92	7671.43	8278.0
2019-01-10 09:00:00	NQ	Futures	7671.72	7678.74	7629.06	7643.09	57229.0
2019-01-10 10:00:00	NQ	Futures	7643.09	7715.84	7639.58	7709.71	83290.0
2019-01-10 11:00:00	NQ	Futures	7710.0	7725.19	7693.93	7719.64	45945.0
2019-01-10 12:00:00	NQ	Futures	7719.64	7746.82	7704.74	7734.25	45621.0
2019-01-10 13:00:00	NQ	Futures	7734.25	7736.88	7672.31	7700.65	57029.0
2019-01-10 14:00:00	NQ	Futures	7700.36	7745.94	7699.77	7728.7	51073.0
2019-01-10 15:00:00	NQ	Futures	7728.7	7759.09	7724.32	7750.03	45393.0
2019-01-10 16:00:00	NQ	Futures	7750.91	7762.59	7740.39	7746.23	10723.0
2019-01-10 18:00:00	NQ	Futures	7740.1	7745.06	7728.12	7732.5	2770.0
2019-01-10 19:00:00	NQ	Futures	7733.08	7750.91	7731.62	7738.34	5536.0
2019-01-10 20:00:00	NQ	Futures	7738.93	7746.23	7722.86	7732.79	4961.0
2019-01-10 21:00:00	NQ	Futures	7733.38	7738.34	7719.35	7728.41	5122.0
2019-01-10 22:00:00	NQ	Futures	7728.12	7733.08	7720.23	7728.99	2416.0
2019-01-10 23:00:00	NQ	Futures	7729.87	7737.17	7727.24	7730.45	1766.0
2019-01-10 00:00:00	YM	Futures	25809.4	25813.8	25741.0	25748.6	2603.0
2019-01-10 01:00:00	YM	Futures	25750.8	25775.8	25728.0	25743.2	2235.0
2019-01-10 02:00:00	YM	Futures	25742.1	25763.8	25724.7	25734.5	3866.0
2019-01-10 03:00:00	YM	Futures	25733.4	25759.5	25666.1	25703.0	6947.0

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

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