PREVIEW / futures_1hour / 2018-12-27

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-12-27.parquet
  size:    58 KB
  rows:    1,754

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-27 00:00:00	ES	Futures	2679.45	2695.75	2671.03	2672.94	22397.0
2018-12-27 01:00:00	ES	Futures	2672.94	2676.74	2667.5	2675.92	11368.0
2018-12-27 02:00:00	ES	Futures	2675.92	2675.92	2666.15	2668.59	14805.0
2018-12-27 03:00:00	ES	Futures	2668.59	2670.22	2653.38	2653.38	34029.0
2018-12-27 04:00:00	ES	Futures	2653.65	2655.28	2632.74	2632.74	45802.0
2018-12-27 05:00:00	ES	Futures	2632.74	2650.12	2631.65	2639.8	33962.0
2018-12-27 06:00:00	ES	Futures	2639.8	2647.95	2634.91	2642.52	27713.0
2018-12-27 07:00:00	ES	Futures	2642.79	2649.04	2636.81	2642.79	35235.0
2018-12-27 08:00:00	ES	Futures	2643.06	2653.11	2635.73	2642.52	50239.0
2018-12-27 09:00:00	ES	Futures	2642.25	2656.91	2627.85	2637.09	253018.0
2018-12-27 10:00:00	ES	Futures	2637.09	2647.68	2620.79	2633.28	321886.0
2018-12-27 11:00:00	ES	Futures	2633.28	2655.55	2626.77	2643.33	193047.0
2018-12-27 12:00:00	ES	Futures	2643.6	2644.15	2624.32	2634.37	143629.0
2018-12-27 13:00:00	ES	Futures	2634.1	2638.17	2611.01	2615.9	139406.0
2018-12-27 14:00:00	ES	Futures	2615.63	2639.8	2603.95	2638.17	208281.0
2018-12-27 15:00:00	ES	Futures	2638.44	2706.34	2627.58	2706.07	449295.0
2018-12-27 16:00:00	ES	Futures	2706.07	2714.49	2699.01	2704.17	133717.0
2018-12-27 18:00:00	ES	Futures	2706.61	2707.15	2691.67	2697.38	17616.0
2018-12-27 19:00:00	ES	Futures	2697.11	2704.98	2696.56	2701.72	17088.0
2018-12-27 20:00:00	ES	Futures	2701.72	2709.33	2700.09	2703.35	15181.0
2018-12-27 21:00:00	ES	Futures	2703.08	2713.67	2701.45	2710.69	13350.0
2018-12-27 22:00:00	ES	Futures	2710.41	2714.76	2708.51	2713.4	10398.0
2018-12-27 23:00:00	ES	Futures	2713.4	2722.09	2712.04	2719.65	11994.0
2018-12-27 00:00:00	NQ	Futures	7319.05	7369.02	7290.71	7296.55	12690.0
2018-12-27 01:00:00	NQ	Futures	7296.84	7309.41	7284.86	7308.82	6914.0
2018-12-27 02:00:00	NQ	Futures	7308.24	7308.53	7279.31	7285.74	7035.0
2018-12-27 03:00:00	NQ	Futures	7285.16	7290.71	7236.07	7237.82	15560.0
2018-12-27 04:00:00	NQ	Futures	7237.53	7243.37	7181.14	7181.72	18435.0
2018-12-27 05:00:00	NQ	Futures	7182.31	7236.95	7180.26	7202.47	17484.0
2018-12-27 06:00:00	NQ	Futures	7201.88	7244.83	7193.99	7226.72	15369.0
2018-12-27 07:00:00	NQ	Futures	7227.3	7250.97	7219.71	7235.19	13935.0
2018-12-27 08:00:00	NQ	Futures	7235.78	7257.69	7211.52	7231.39	18396.0
2018-12-27 09:00:00	NQ	Futures	7231.1	7279.31	7184.06	7215.91	97706.0
2018-12-27 10:00:00	NQ	Futures	7213.28	7241.62	7136.72	7167.11	106979.0
2018-12-27 11:00:00	NQ	Futures	7166.82	7227.6	7146.66	7188.73	63907.0
2018-12-27 12:00:00	NQ	Futures	7188.73	7191.66	7127.96	7164.19	48675.0
2018-12-27 13:00:00	NQ	Futures	7163.61	7174.12	7085.3	7102.25	45944.0
2018-12-27 14:00:00	NQ	Futures	7101.66	7188.44	7074.78	7187.86	69158.0
2018-12-27 15:00:00	NQ	Futures	7188.15	7366.97	7155.42	7366.39	108488.0
2018-12-27 16:00:00	NQ	Futures	7366.68	7401.74	7360.83	7373.4	28266.0
2018-12-27 18:00:00	NQ	Futures	7373.69	7383.04	7329.28	7349.44	7672.0
2018-12-27 19:00:00	NQ	Futures	7348.85	7372.81	7347.39	7362.88	7633.0
2018-12-27 20:00:00	NQ	Futures	7362.59	7383.04	7354.99	7362.0	6263.0
2018-12-27 21:00:00	NQ	Futures	7362.0	7395.6	7356.74	7385.96	6749.0
2018-12-27 22:00:00	NQ	Futures	7386.25	7399.4	7378.37	7395.6	4872.0
2018-12-27 23:00:00	NQ	Futures	7395.31	7418.69	7388.3	7407.0	5685.0
2018-12-27 00:00:00	YM	Futures	24829.0	24979.9	24748.7	24766.1	7168.0
2018-12-27 01:00:00	YM	Futures	24769.3	24806.2	24720.5	24792.1	3619.0
2018-12-27 02:00:00	YM	Futures	24791.0	24792.1	24680.3	24702.0	5180.0
2018-12-27 03:00:00	YM	Futures	24702.0	24722.6	24555.4	24555.4	10215.0

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

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