PREVIEW / futures_1hour / 2018-12-10

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-12-10.parquet
  size:    50 KB
  rows:    1,559

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-10 00:00:00	ES	Futures	2848.64	2849.73	2845.92	2849.18	6364.0
2018-12-10 01:00:00	ES	Futures	2849.18	2851.9	2845.65	2846.73	7372.0
2018-12-10 02:00:00	ES	Futures	2847.01	2857.89	2847.01	2856.25	20307.0
2018-12-10 03:00:00	ES	Futures	2856.53	2863.05	2851.9	2852.99	37277.0
2018-12-10 04:00:00	ES	Futures	2852.99	2859.79	2852.45	2859.25	20478.0
2018-12-10 05:00:00	ES	Futures	2859.25	2861.69	2855.44	2861.15	14934.0
2018-12-10 06:00:00	ES	Futures	2861.15	2864.14	2856.25	2859.79	17889.0
2018-12-10 07:00:00	ES	Futures	2859.79	2871.49	2855.98	2868.49	28358.0
2018-12-10 08:00:00	ES	Futures	2868.49	2877.74	2867.68	2868.22	41265.0
2018-12-10 09:00:00	ES	Futures	2867.95	2871.49	2839.12	2843.47	308416.0
2018-12-10 10:00:00	ES	Futures	2843.74	2860.88	2826.88	2830.69	427872.0
2018-12-10 11:00:00	ES	Futures	2830.96	2839.39	2810.29	2828.24	423597.0
2018-12-10 12:00:00	ES	Futures	2827.97	2855.71	2821.17	2850.27	255594.0
2018-12-10 13:00:00	ES	Futures	2850.27	2864.69	2845.37	2857.89	201564.0
2018-12-10 14:00:00	ES	Futures	2858.16	2873.12	2850.54	2861.15	210201.0
2018-12-10 15:00:00	ES	Futures	2860.88	2881.55	2854.62	2869.58	282044.0
2018-12-10 16:00:00	ES	Futures	2869.85	2878.83	2869.04	2873.93	82541.0
2018-12-10 18:00:00	ES	Futures	2876.65	2876.65	2867.41	2869.58	8672.0
2018-12-10 19:00:00	ES	Futures	2869.58	2871.49	2862.24	2864.14	14988.0
2018-12-10 20:00:00	ES	Futures	2863.87	2873.93	2859.52	2866.59	24833.0
2018-12-10 21:00:00	ES	Futures	2866.59	2868.22	2860.61	2865.23	10536.0
2018-12-10 22:00:00	ES	Futures	2865.5	2868.77	2863.05	2863.87	8310.0
2018-12-10 23:00:00	ES	Futures	2863.87	2867.68	2863.33	2866.86	3935.0
2018-12-10 00:00:00	NQ	Futures	7712.11	7718.56	7704.19	7716.22	2803.0
2018-12-10 01:00:00	NQ	Futures	7715.92	7727.36	7708.88	7713.28	4067.0
2018-12-10 02:00:00	NQ	Futures	7712.99	7751.12	7712.7	7743.49	8744.0
2018-12-10 03:00:00	NQ	Futures	7744.08	7759.33	7720.03	7722.96	12181.0
2018-12-10 04:00:00	NQ	Futures	7722.96	7747.01	7720.03	7744.96	7650.0
2018-12-10 05:00:00	NQ	Futures	7745.25	7756.99	7735.57	7754.64	5592.0
2018-12-10 06:00:00	NQ	Futures	7754.05	7764.03	7744.08	7752.0	6606.0
2018-12-10 07:00:00	NQ	Futures	7751.71	7795.12	7738.51	7783.97	11963.0
2018-12-10 08:00:00	NQ	Futures	7783.09	7813.89	7773.12	7774.29	21782.0
2018-12-10 09:00:00	NQ	Futures	7774.0	7828.55	7722.37	7742.03	97351.0
2018-12-10 10:00:00	NQ	Futures	7742.32	7810.08	7712.7	7725.89	122480.0
2018-12-10 11:00:00	NQ	Futures	7726.19	7761.09	7667.53	7725.6	131800.0
2018-12-10 12:00:00	NQ	Futures	7725.01	7811.54	7696.56	7792.48	84306.0
2018-12-10 13:00:00	NQ	Futures	7792.48	7828.55	7761.97	7808.9	62963.0
2018-12-10 14:00:00	NQ	Futures	7809.2	7858.18	7788.37	7818.58	77074.0
2018-12-10 15:00:00	NQ	Futures	7818.29	7877.83	7800.69	7843.22	64458.0
2018-12-10 16:00:00	NQ	Futures	7843.22	7870.21	7840.87	7854.95	12110.0
2018-12-10 18:00:00	NQ	Futures	7854.95	7854.95	7834.13	7837.06	3541.0
2018-12-10 19:00:00	NQ	Futures	7837.35	7844.39	7817.41	7822.98	6341.0
2018-12-10 20:00:00	NQ	Futures	7822.39	7854.95	7808.02	7828.55	9703.0
2018-12-10 21:00:00	NQ	Futures	7828.85	7833.25	7810.66	7822.98	5112.0
2018-12-10 22:00:00	NQ	Futures	7822.98	7836.47	7818.29	7821.81	3882.0
2018-12-10 23:00:00	NQ	Futures	7820.93	7832.66	7820.34	7830.02	1746.0
2018-12-10 00:00:00	YM	Futures	26356.6	26367.5	26338.2	26367.5	8.0
2018-12-10 01:00:00	YM	Futures	26375.1	26394.6	26334.9	26340.3	147.0
2018-12-10 02:00:00	YM	Futures	26382.7	26440.2	26381.6	26412.0	40.0
2018-12-10 03:00:00	YM	Futures	26450.0	26496.7	26409.8	26413.1	73.0

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

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