PREVIEW / futures_1hour / 2019-01-09

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-01-09.parquet
  size:    58 KB
  rows:    1,780

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-09 00:00:00	ES	Futures	2807.1	2808.46	2805.47	2806.83	4174.0
2019-01-09 01:00:00	ES	Futures	2806.83	2806.83	2800.85	2801.12	7405.0
2019-01-09 02:00:00	ES	Futures	2801.39	2805.74	2798.14	2799.49	13417.0
2019-01-09 03:00:00	ES	Futures	2799.49	2807.37	2797.86	2804.93	20100.0
2019-01-09 04:00:00	ES	Futures	2804.93	2808.73	2802.48	2806.01	16017.0
2019-01-09 05:00:00	ES	Futures	2806.01	2806.83	2800.04	2804.38	15071.0
2019-01-09 06:00:00	ES	Futures	2804.38	2805.47	2798.41	2801.94	11808.0
2019-01-09 07:00:00	ES	Futures	2801.94	2804.65	2796.78	2804.11	19982.0
2019-01-09 08:00:00	ES	Futures	2804.11	2809.0	2803.3	2807.37	27738.0
2019-01-09 09:00:00	ES	Futures	2807.1	2812.8	2800.58	2811.72	209758.0
2019-01-09 10:00:00	ES	Futures	2811.72	2813.89	2790.8	2799.22	273855.0
2019-01-09 11:00:00	ES	Futures	2799.22	2816.6	2797.86	2812.53	202906.0
2019-01-09 12:00:00	ES	Futures	2812.53	2819.59	2809.81	2818.78	109099.0
2019-01-09 13:00:00	ES	Futures	2818.5	2819.32	2809.54	2812.53	77757.0
2019-01-09 14:00:00	ES	Futures	2812.26	2820.95	2803.02	2812.8	193088.0
2019-01-09 15:00:00	ES	Futures	2812.53	2817.42	2803.02	2809.54	199427.0
2019-01-09 16:00:00	ES	Futures	2809.54	2810.36	2800.58	2804.65	64995.0
2019-01-09 18:00:00	ES	Futures	2802.75	2804.65	2798.95	2800.31	7555.0
2019-01-09 19:00:00	ES	Futures	2800.31	2804.65	2794.61	2795.15	17346.0
2019-01-09 20:00:00	ES	Futures	2795.15	2796.23	2786.19	2792.7	24046.0
2019-01-09 21:00:00	ES	Futures	2792.7	2794.61	2788.09	2789.72	12512.0
2019-01-09 22:00:00	ES	Futures	2789.72	2795.42	2789.17	2794.88	9342.0
2019-01-09 23:00:00	ES	Futures	2794.88	2796.78	2791.89	2795.96	4678.0
2019-01-09 00:00:00	NQ	Futures	7711.17	7716.43	7705.62	7710.58	2559.0
2019-01-09 01:00:00	NQ	Futures	7710.58	7711.46	7684.87	7688.38	4556.0
2019-01-09 02:00:00	NQ	Futures	7688.38	7700.94	7669.97	7677.86	6425.0
2019-01-09 03:00:00	NQ	Futures	7677.86	7703.86	7670.26	7696.56	8705.0
2019-01-09 04:00:00	NQ	Futures	7696.56	7711.17	7688.96	7701.53	6012.0
2019-01-09 05:00:00	NQ	Futures	7701.23	7703.28	7681.66	7698.31	5633.0
2019-01-09 06:00:00	NQ	Futures	7697.73	7702.11	7681.66	7693.64	5412.0
2019-01-09 07:00:00	NQ	Futures	7693.35	7700.65	7674.65	7698.9	6993.0
2019-01-09 08:00:00	NQ	Futures	7698.31	7709.71	7695.68	7700.94	12804.0
2019-01-09 09:00:00	NQ	Futures	7700.65	7729.28	7677.57	7721.4	81231.0
2019-01-09 10:00:00	NQ	Futures	7721.69	7731.04	7667.34	7693.93	86153.0
2019-01-09 11:00:00	NQ	Futures	7693.64	7746.23	7688.09	7733.08	53130.0
2019-01-09 12:00:00	NQ	Futures	7732.79	7753.24	7725.78	7750.03	34200.0
2019-01-09 13:00:00	NQ	Futures	7750.03	7754.41	7729.87	7739.51	23102.0
2019-01-09 14:00:00	NQ	Futures	7739.51	7766.39	7704.45	7740.39	64119.0
2019-01-09 15:00:00	NQ	Futures	7740.68	7756.46	7710.0	7731.33	49123.0
2019-01-09 16:00:00	NQ	Futures	7731.62	7734.54	7705.03	7717.89	9199.0
2019-01-09 18:00:00	NQ	Futures	7710.58	7718.77	7698.31	7705.32	3141.0
2019-01-09 19:00:00	NQ	Futures	7705.62	7719.06	7685.75	7686.92	7322.0
2019-01-09 20:00:00	NQ	Futures	7686.33	7690.72	7658.87	7681.07	12243.0
2019-01-09 21:00:00	NQ	Futures	7681.37	7686.33	7666.46	7670.85	7427.0
2019-01-09 22:00:00	NQ	Futures	7670.85	7689.55	7667.05	7688.09	4586.0
2019-01-09 23:00:00	NQ	Futures	7687.79	7696.56	7680.78	7693.93	2996.0
2019-01-09 00:00:00	YM	Futures	25903.9	25915.8	25888.7	25897.4	1542.0
2019-01-09 01:00:00	YM	Futures	25898.4	25898.4	25836.6	25843.1	2752.0
2019-01-09 02:00:00	YM	Futures	25845.2	25890.8	25821.4	25836.6	3981.0
2019-01-09 03:00:00	YM	Futures	25837.6	25891.9	25814.8	25874.6	5798.0

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

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