PREVIEW / futures_1hour / 2018-12-28

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-12-28.parquet
  size:    48 KB
  rows:    1,414

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-28 00:00:00	ES	Futures	2719.38	2721.01	2708.51	2711.5	10780.0
2018-12-28 01:00:00	ES	Futures	2711.5	2711.5	2700.09	2703.08	11667.0
2018-12-28 02:00:00	ES	Futures	2702.81	2707.43	2697.38	2702.54	16421.0
2018-12-28 03:00:00	ES	Futures	2702.81	2713.94	2698.46	2712.32	32276.0
2018-12-28 04:00:00	ES	Futures	2712.32	2716.93	2707.7	2716.39	19798.0
2018-12-28 05:00:00	ES	Futures	2716.12	2728.61	2715.57	2725.89	28528.0
2018-12-28 06:00:00	ES	Futures	2725.89	2736.76	2717.2	2724.54	36070.0
2018-12-28 07:00:00	ES	Futures	2724.81	2728.34	2714.49	2722.64	31515.0
2018-12-28 08:00:00	ES	Futures	2722.64	2725.08	2716.39	2723.45	35055.0
2018-12-28 09:00:00	ES	Futures	2723.45	2726.44	2706.34	2719.1	208911.0
2018-12-28 10:00:00	ES	Futures	2719.1	2721.82	2686.24	2698.19	296135.0
2018-12-28 11:00:00	ES	Futures	2698.19	2714.49	2692.76	2709.06	209146.0
2018-12-28 12:00:00	ES	Futures	2709.33	2717.48	2703.35	2704.98	122119.0
2018-12-28 13:00:00	ES	Futures	2704.71	2714.22	2696.02	2709.33	118771.0
2018-12-28 14:00:00	ES	Futures	2709.6	2740.83	2709.33	2735.94	202958.0
2018-12-28 15:00:00	ES	Futures	2736.21	2738.39	2690.59	2700.91	408936.0
2018-12-28 16:00:00	ES	Futures	2700.91	2703.9	2694.66	2702.81	65110.0
2018-12-28 00:00:00	NQ	Futures	7407.29	7411.97	7376.32	7384.21	5910.0
2018-12-28 01:00:00	NQ	Futures	7384.5	7384.79	7354.7	7362.29	5819.0
2018-12-28 02:00:00	NQ	Futures	7361.42	7371.35	7343.59	7360.54	7288.0
2018-12-28 03:00:00	NQ	Futures	7360.54	7396.19	7345.93	7392.68	13697.0
2018-12-28 04:00:00	NQ	Futures	7392.68	7406.12	7378.07	7403.49	8382.0
2018-12-28 05:00:00	NQ	Futures	7403.49	7434.17	7400.57	7425.12	11662.0
2018-12-28 06:00:00	NQ	Futures	7425.12	7454.04	7402.03	7416.06	14333.0
2018-12-28 07:00:00	NQ	Futures	7415.77	7431.25	7390.05	7408.17	14603.0
2018-12-28 08:00:00	NQ	Futures	7408.17	7415.18	7393.27	7411.38	14299.0
2018-12-28 09:00:00	NQ	Futures	7411.38	7420.15	7345.64	7399.11	79751.0
2018-12-28 10:00:00	NQ	Futures	7399.11	7404.66	7297.43	7333.95	89636.0
2018-12-28 11:00:00	NQ	Futures	7333.37	7395.9	7316.42	7383.04	69120.0
2018-12-28 12:00:00	NQ	Futures	7383.33	7410.8	7366.97	7378.37	43539.0
2018-12-28 13:00:00	NQ	Futures	7378.95	7401.16	7345.06	7388.01	40182.0
2018-12-28 14:00:00	NQ	Futures	7388.3	7482.97	7388.3	7476.54	66853.0
2018-12-28 15:00:00	NQ	Futures	7476.54	7482.68	7332.78	7361.42	93253.0
2018-12-28 16:00:00	NQ	Futures	7360.83	7362.88	7340.67	7358.79	12118.0
2018-12-28 00:00:00	YM	Futures	25218.8	25231.8	25104.8	25129.8	4549.0
2018-12-28 01:00:00	YM	Futures	25128.7	25128.7	25037.5	25059.2	4099.0
2018-12-28 02:00:00	YM	Futures	25059.2	25111.3	25015.8	25061.4	5320.0
2018-12-28 03:00:00	YM	Futures	25064.6	25164.5	25028.8	25154.7	9357.0
2018-12-28 04:00:00	YM	Futures	25154.7	25188.4	25110.2	25183.0	4259.0
2018-12-28 05:00:00	YM	Futures	25183.0	25297.0	25176.5	25265.5	8801.0
2018-12-28 06:00:00	YM	Futures	25264.4	25375.1	25180.8	25270.9	11467.0
2018-12-28 07:00:00	YM	Futures	25270.9	25303.5	25183.0	25255.7	8038.0
2018-12-28 08:00:00	YM	Futures	25255.7	25280.7	25202.5	25274.2	7982.0
2018-12-28 09:00:00	YM	Futures	25273.1	25276.3	25111.3	25198.2	31552.0
2018-12-28 10:00:00	YM	Futures	25199.3	25228.6	24930.0	25027.7	45800.0
2018-12-28 11:00:00	YM	Futures	25029.9	25188.4	24976.7	25154.7	33176.0
2018-12-28 12:00:00	YM	Futures	25155.8	25224.2	25073.3	25086.3	20624.0
2018-12-28 13:00:00	YM	Futures	25087.4	25160.2	24982.1	25111.3	20483.0
2018-12-28 14:00:00	YM	Futures	25112.4	25368.6	25112.4	25342.6	27826.0
2018-12-28 15:00:00	YM	Futures	25342.6	25363.2	24924.6	25021.2	42497.0

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

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