PREVIEW / futures_1hour / 2018-12-24

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-12-24.parquet
  size:    35 KB
  rows:    934

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-24 00:00:00	ES	Futures	2640.62	2641.43	2637.36	2640.07	4258.0
2018-12-24 01:00:00	ES	Futures	2639.8	2639.8	2636.0	2638.72	4340.0
2018-12-24 02:00:00	ES	Futures	2638.72	2643.06	2636.81	2637.36	7063.0
2018-12-24 03:00:00	ES	Futures	2637.36	2644.69	2635.19	2636.27	12768.0
2018-12-24 04:00:00	ES	Futures	2636.54	2638.17	2630.57	2634.37	12072.0
2018-12-24 05:00:00	ES	Futures	2634.64	2637.09	2632.74	2636.27	7667.0
2018-12-24 06:00:00	ES	Futures	2636.54	2638.44	2629.48	2629.75	7254.0
2018-12-24 07:00:00	ES	Futures	2629.75	2630.3	2599.34	2600.15	44860.0
2018-12-24 08:00:00	ES	Futures	2599.88	2622.42	2597.16	2606.4	52068.0
2018-12-24 09:00:00	ES	Futures	2606.4	2617.53	2580.05	2589.02	226831.0
2018-12-24 10:00:00	ES	Futures	2588.74	2620.79	2572.45	2602.32	271294.0
2018-12-24 11:00:00	ES	Futures	2602.05	2608.03	2573.26	2576.79	180141.0
2018-12-24 12:00:00	ES	Futures	2576.79	2585.49	2553.98	2555.07	238484.0
2018-12-24 13:00:00	ES	Futures	2555.07	2558.33	2542.57	2544.48	79901.0
2018-12-24 00:00:00	NQ	Futures	7125.91	7131.76	7121.53	7129.71	2711.0
2018-12-24 01:00:00	NQ	Futures	7129.71	7129.71	7111.89	7123.58	3100.0
2018-12-24 02:00:00	NQ	Futures	7123.87	7148.41	7122.7	7131.17	5362.0
2018-12-24 03:00:00	NQ	Futures	7130.59	7156.3	7128.25	7132.93	6819.0
2018-12-24 04:00:00	NQ	Futures	7133.22	7145.2	7118.9	7136.43	6009.0
2018-12-24 05:00:00	NQ	Futures	7135.85	7141.4	7128.25	7135.56	3628.0
2018-12-24 06:00:00	NQ	Futures	7136.14	7149.87	7118.9	7119.78	4541.0
2018-12-24 07:00:00	NQ	Futures	7119.78	7120.95	7015.17	7016.05	22249.0
2018-12-24 08:00:00	NQ	Futures	7016.05	7070.4	7011.67	7032.41	22735.0
2018-12-24 09:00:00	NQ	Futures	7033.58	7090.56	6943.88	6981.86	76802.0
2018-12-24 10:00:00	NQ	Futures	6981.86	7127.08	6946.8	7079.75	103694.0
2018-12-24 11:00:00	NQ	Futures	7079.75	7098.16	6978.36	6990.63	65694.0
2018-12-24 12:00:00	NQ	Futures	6990.34	7017.51	6909.11	6911.45	61141.0
2018-12-24 13:00:00	NQ	Futures	6909.69	6924.01	6882.52	6888.66	18265.0
2018-12-24 00:00:00	YM	Futures	24477.3	24493.5	24443.6	24470.7	1213.0
2018-12-24 01:00:00	YM	Futures	24470.7	24476.2	24432.7	24463.1	2242.0
2018-12-24 02:00:00	YM	Futures	24462.1	24493.5	24440.3	24442.5	1835.0
2018-12-24 03:00:00	YM	Futures	24442.5	24502.2	24416.5	24430.6	4545.0
2018-12-24 04:00:00	YM	Futures	24430.6	24451.2	24379.5	24412.1	4768.0
2018-12-24 05:00:00	YM	Futures	24414.3	24434.9	24399.1	24428.4	1606.0
2018-12-24 06:00:00	YM	Futures	24428.4	24444.7	24390.4	24395.8	2253.0
2018-12-24 07:00:00	YM	Futures	24394.7	24396.9	24100.5	24104.9	12253.0
2018-12-24 08:00:00	YM	Futures	24103.8	24312.2	24081.0	24178.7	14332.0
2018-12-24 09:00:00	YM	Futures	24179.8	24257.9	23940.9	24012.6	43754.0
2018-12-24 10:00:00	YM	Futures	24014.7	24248.2	23872.5	24108.1	55753.0
2018-12-24 11:00:00	YM	Futures	24109.2	24164.6	23844.3	23889.9	40712.0
2018-12-24 12:00:00	YM	Futures	23888.8	23960.5	23657.6	23661.9	36705.0
2018-12-24 13:00:00	YM	Futures	23661.9	23676.0	23539.2	23556.6	7562.0
2018-12-24 00:00:00	CL	Futures	42.05	42.06	41.85	41.91	5946.0
2018-12-24 01:00:00	CL	Futures	41.91	41.91	41.68	41.8	10242.0
2018-12-24 02:00:00	CL	Futures	41.8	41.86	41.66	41.7	6997.0
2018-12-24 03:00:00	CL	Futures	41.7	41.79	41.48	41.57	14523.0
2018-12-24 04:00:00	CL	Futures	41.57	41.69	41.33	41.4	15602.0
2018-12-24 05:00:00	CL	Futures	41.4	41.6	41.38	41.45	9036.0
2018-12-24 06:00:00	CL	Futures	41.44	41.59	41.37	41.49	8675.0
2018-12-24 07:00:00	CL	Futures	41.48	41.54	40.81	40.92	35375.0

> showing 50 of 934 rows — these rows as CSV

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