PREVIEW / futures_1hour / 2018-04-06

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-04-06.parquet
  size:    47 KB
  rows:    1,380

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-04-06 00:00:00	ES	Futures	2873.45	2878.91	2873.18	2876.45	6146.0
2018-04-06 01:00:00	ES	Futures	2876.72	2879.45	2870.72	2876.45	11425.0
2018-04-06 02:00:00	ES	Futures	2876.18	2884.64	2873.18	2884.09	19704.0
2018-04-06 03:00:00	ES	Futures	2884.09	2886.82	2881.09	2881.91	20873.0
2018-04-06 04:00:00	ES	Futures	2882.18	2885.18	2879.73	2883.82	13639.0
2018-04-06 05:00:00	ES	Futures	2883.82	2887.37	2880.54	2886.28	11902.0
2018-04-06 06:00:00	ES	Futures	2886.28	2891.46	2885.73	2887.64	16347.0
2018-04-06 07:00:00	ES	Futures	2887.64	2888.19	2875.63	2875.9	38633.0
2018-04-06 08:00:00	ES	Futures	2875.9	2890.64	2874.54	2885.73	105578.0
2018-04-06 09:00:00	ES	Futures	2885.46	2900.19	2878.09	2894.46	236137.0
2018-04-06 10:00:00	ES	Futures	2894.74	2897.46	2872.63	2875.36	260845.0
2018-04-06 11:00:00	ES	Futures	2875.63	2879.45	2865.81	2877.27	248433.0
2018-04-06 12:00:00	ES	Futures	2877.27	2881.36	2862.26	2880.54	184891.0
2018-04-06 13:00:00	ES	Futures	2880.54	2880.54	2847.25	2847.8	241644.0
2018-04-06 14:00:00	ES	Futures	2847.8	2850.52	2822.14	2826.51	351905.0
2018-04-06 15:00:00	ES	Futures	2826.51	2850.8	2821.32	2841.25	445518.0
2018-04-06 16:00:00	ES	Futures	2841.25	2846.43	2839.61	2843.7	94597.0
2018-04-06 00:00:00	NQ	Futures	7707.48	7724.91	7707.18	7713.98	2070.0
2018-04-06 01:00:00	NQ	Futures	7715.16	7723.14	7693.59	7712.21	3166.0
2018-04-06 02:00:00	NQ	Futures	7711.02	7744.72	7704.82	7735.26	5487.0
2018-04-06 03:00:00	NQ	Futures	7735.26	7747.38	7722.55	7729.64	6064.0
2018-04-06 04:00:00	NQ	Futures	7729.94	7745.6	7727.87	7740.87	4041.0
2018-04-06 05:00:00	NQ	Futures	7741.46	7753.29	7725.8	7748.26	5035.0
2018-04-06 06:00:00	NQ	Futures	7747.97	7767.18	7746.49	7754.47	5400.0
2018-04-06 07:00:00	NQ	Futures	7754.17	7754.17	7702.75	7706.59	14026.0
2018-04-06 08:00:00	NQ	Futures	7707.18	7759.79	7705.11	7739.69	24126.0
2018-04-06 09:00:00	NQ	Futures	7739.69	7801.16	7712.8	7784.32	72353.0
2018-04-06 10:00:00	NQ	Futures	7784.61	7793.18	7708.66	7727.28	75400.0
2018-04-06 11:00:00	NQ	Futures	7727.57	7757.72	7698.61	7750.92	65028.0
2018-04-06 12:00:00	NQ	Futures	7750.33	7753.88	7698.61	7749.74	50070.0
2018-04-06 13:00:00	NQ	Futures	7749.15	7749.15	7644.23	7645.12	62366.0
2018-04-06 14:00:00	NQ	Futures	7645.12	7658.42	7579.51	7595.18	73611.0
2018-04-06 15:00:00	NQ	Futures	7595.18	7651.33	7575.67	7616.45	87821.0
2018-04-06 16:00:00	NQ	Futures	7616.75	7633.3	7611.73	7632.41	12211.0
2018-04-06 00:00:00	YM	Futures	26247.0	26290.5	26240.5	26265.5	1794.0
2018-04-06 01:00:00	YM	Futures	26266.6	26288.3	26217.7	26263.3	3000.0
2018-04-06 02:00:00	YM	Futures	26262.2	26346.9	26243.8	26341.5	4535.0
2018-04-06 03:00:00	YM	Futures	26341.5	26362.1	26311.1	26326.3	5310.0
2018-04-06 04:00:00	YM	Futures	26326.3	26361.0	26301.3	26351.3	3497.0
2018-04-06 05:00:00	YM	Futures	26350.2	26383.8	26324.1	26371.9	4070.0
2018-04-06 06:00:00	YM	Futures	26370.8	26419.7	26366.5	26383.8	4495.0
2018-04-06 07:00:00	YM	Futures	26383.8	26387.1	26272.0	26278.5	10377.0
2018-04-06 08:00:00	YM	Futures	26277.4	26395.8	26267.6	26360.0	17206.0
2018-04-06 09:00:00	YM	Futures	26360.0	26508.7	26272.0	26457.7	43647.0
2018-04-06 10:00:00	YM	Futures	26458.8	26493.5	26184.0	26202.5	45209.0
2018-04-06 11:00:00	YM	Futures	26202.5	26237.2	26113.4	26211.2	42819.0
2018-04-06 12:00:00	YM	Futures	26209.0	26268.7	26078.7	26257.9	35485.0
2018-04-06 13:00:00	YM	Futures	26256.8	26256.8	25956.0	25962.5	43302.0
2018-04-06 14:00:00	YM	Futures	25962.5	25985.3	25754.0	25785.4	57347.0
2018-04-06 15:00:00	YM	Futures	25786.5	26016.8	25738.8	25956.0	57461.0

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

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