PREVIEW / futures_1hour / 2018-12-17

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-12-17.parquet
  size:    55 KB
  rows:    1,718

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-12-17 00:00:00	ES	Futures	2840.5	2841.59	2838.87	2839.96	3438.0
2018-12-17 01:00:00	ES	Futures	2839.69	2840.77	2838.33	2839.15	2998.0
2018-12-17 02:00:00	ES	Futures	2839.42	2841.59	2832.08	2832.36	8395.0
2018-12-17 03:00:00	ES	Futures	2832.08	2834.8	2826.65	2833.98	16373.0
2018-12-17 04:00:00	ES	Futures	2833.71	2834.26	2829.37	2831.81	10073.0
2018-12-17 05:00:00	ES	Futures	2832.08	2837.79	2831.27	2831.54	10890.0
2018-12-17 06:00:00	ES	Futures	2831.27	2832.63	2825.29	2827.47	13066.0
2018-12-17 07:00:00	ES	Futures	2827.47	2829.91	2821.76	2823.39	17222.0
2018-12-17 08:00:00	ES	Futures	2823.39	2825.02	2814.7	2816.06	32781.0
2018-12-17 09:00:00	ES	Futures	2816.06	2819.86	2792.98	2806.55	243669.0
2018-12-17 10:00:00	ES	Futures	2806.28	2821.22	2801.39	2818.23	272828.0
2018-12-17 11:00:00	ES	Futures	2818.5	2830.45	2816.33	2827.2	210184.0
2018-12-17 12:00:00	ES	Futures	2827.2	2830.18	2797.59	2797.86	181374.0
2018-12-17 13:00:00	ES	Futures	2797.86	2803.02	2782.93	2783.74	262281.0
2018-12-17 14:00:00	ES	Futures	2783.74	2788.36	2774.51	2778.31	233824.0
2018-12-17 15:00:00	ES	Futures	2778.31	2782.11	2752.24	2771.79	483008.0
2018-12-17 16:00:00	ES	Futures	2771.79	2779.94	2769.62	2777.5	108786.0
2018-12-17 18:00:00	ES	Futures	2778.04	2786.73	2777.5	2784.01	9111.0
2018-12-17 19:00:00	ES	Futures	2784.01	2784.28	2777.5	2783.47	11655.0
2018-12-17 20:00:00	ES	Futures	2783.2	2790.8	2782.11	2790.26	16471.0
2018-12-17 21:00:00	ES	Futures	2789.99	2790.26	2786.73	2787.0	9920.0
2018-12-17 22:00:00	ES	Futures	2787.0	2787.0	2776.95	2781.3	18663.0
2018-12-17 23:00:00	ES	Futures	2781.3	2784.56	2776.14	2777.22	9956.0
2018-12-17 00:00:00	NQ	Futures	7774.57	7777.2	7767.85	7773.11	1610.0
2018-12-17 01:00:00	NQ	Futures	7773.11	7777.2	7768.15	7769.9	1517.0
2018-12-17 02:00:00	NQ	Futures	7770.19	7776.91	7746.52	7747.98	3474.0
2018-12-17 03:00:00	NQ	Futures	7746.82	7759.09	7727.82	7755.29	6623.0
2018-12-17 04:00:00	NQ	Futures	7754.7	7756.17	7740.39	7748.86	3236.0
2018-12-17 05:00:00	NQ	Futures	7748.57	7767.85	7745.65	7746.52	3417.0
2018-12-17 06:00:00	NQ	Futures	7745.65	7751.78	7725.19	7734.54	4293.0
2018-12-17 07:00:00	NQ	Futures	7734.25	7743.02	7716.72	7721.1	5762.0
2018-12-17 08:00:00	NQ	Futures	7721.4	7728.41	7695.1	7702.11	12363.0
2018-12-17 09:00:00	NQ	Futures	7702.4	7715.84	7623.8	7660.62	70024.0
2018-12-17 10:00:00	NQ	Futures	7660.33	7732.79	7652.15	7717.89	78001.0
2018-12-17 11:00:00	NQ	Futures	7718.18	7757.92	7714.67	7756.17	56568.0
2018-12-17 12:00:00	NQ	Futures	7756.17	7771.07	7669.39	7670.55	54856.0
2018-12-17 13:00:00	NQ	Futures	7670.26	7684.29	7610.66	7612.99	69907.0
2018-12-17 14:00:00	NQ	Futures	7612.41	7621.76	7575.59	7588.16	67797.0
2018-12-17 15:00:00	NQ	Futures	7588.45	7593.42	7507.22	7573.84	99179.0
2018-12-17 16:00:00	NQ	Futures	7573.84	7595.75	7563.91	7589.03	17299.0
2018-12-17 18:00:00	NQ	Futures	7592.83	7615.33	7586.99	7612.99	4102.0
2018-12-17 19:00:00	NQ	Futures	7613.87	7615.04	7595.46	7612.12	5099.0
2018-12-17 20:00:00	NQ	Futures	7612.12	7629.65	7605.69	7628.48	5443.0
2018-12-17 21:00:00	NQ	Futures	7628.19	7628.77	7614.16	7615.33	3900.0
2018-12-17 22:00:00	NQ	Futures	7614.75	7615.91	7587.57	7601.01	6787.0
2018-12-17 23:00:00	NQ	Futures	7600.43	7620.01	7589.62	7594.0	5730.0
2018-12-17 00:00:00	YM	Futures	26290.4	26296.9	26270.8	26279.5	1449.0
2018-12-17 01:00:00	YM	Futures	26280.6	26288.2	26266.5	26274.1	909.0
2018-12-17 02:00:00	YM	Futures	26275.2	26295.8	26193.8	26205.7	3825.0
2018-12-17 03:00:00	YM	Futures	26203.5	26229.6	26160.1	26219.8	4172.0

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

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