PREVIEW / futures_1hour / 2019-12-24

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-12-24.parquet
  size:    33 KB
  rows:    964

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
2019-12-24 00:00:00	ES	Futures	3498.8	3499.6	3498.5	3499.6	1853.0
2019-12-24 01:00:00	ES	Futures	3499.6	3499.8	3499.0	3499.3	2059.0
2019-12-24 02:00:00	ES	Futures	3499.3	3500.1	3499.0	3500.1	1634.0
2019-12-24 03:00:00	ES	Futures	3500.1	3500.1	3498.2	3499.6	2509.0
2019-12-24 04:00:00	ES	Futures	3499.6	3500.9	3499.3	3500.1	2361.0
2019-12-24 05:00:00	ES	Futures	3500.1	3500.7	3499.8	3500.7	2925.0
2019-12-24 06:00:00	ES	Futures	3500.4	3501.2	3500.1	3500.7	1955.0
2019-12-24 07:00:00	ES	Futures	3500.9	3502.5	3500.4	3500.7	4909.0
2019-12-24 08:00:00	ES	Futures	3500.4	3501.2	3499.0	3499.8	6468.0
2019-12-24 09:00:00	ES	Futures	3499.8	3500.1	3493.1	3495.0	69663.0
2019-12-24 10:00:00	ES	Futures	3494.7	3497.1	3494.4	3495.5	52809.0
2019-12-24 11:00:00	ES	Futures	3495.8	3497.1	3495.2	3495.5	39342.0
2019-12-24 12:00:00	ES	Futures	3495.5	3497.4	3494.4	3497.1	55629.0
2019-12-24 13:00:00	ES	Futures	3496.9	3497.7	3495.8	3497.4	21135.0
2019-12-24 00:00:00	NQ	Futures	10089.83	10093.88	10089.26	10093.59	837.0
2019-12-24 01:00:00	NQ	Futures	10093.59	10094.75	10090.99	10093.88	1208.0
2019-12-24 02:00:00	NQ	Futures	10093.88	10096.48	10091.86	10096.2	1626.0
2019-12-24 03:00:00	NQ	Futures	10095.91	10095.91	10090.99	10093.88	1339.0
2019-12-24 04:00:00	NQ	Futures	10093.88	10100.24	10093.59	10098.22	1782.0
2019-12-24 05:00:00	NQ	Futures	10098.22	10100.53	10096.77	10099.38	1376.0
2019-12-24 06:00:00	NQ	Futures	10099.38	10103.14	10098.22	10101.69	1285.0
2019-12-24 07:00:00	NQ	Futures	10101.69	10104.87	10097.64	10099.38	2398.0
2019-12-24 08:00:00	NQ	Futures	10099.38	10101.98	10097.06	10100.53	2887.0
2019-12-24 09:00:00	NQ	Futures	10100.53	10103.42	10071.33	10082.03	27997.0
2019-12-24 10:00:00	NQ	Futures	10081.74	10091.28	10081.74	10087.23	21800.0
2019-12-24 11:00:00	NQ	Futures	10087.23	10095.33	10086.65	10090.99	14687.0
2019-12-24 12:00:00	NQ	Futures	10090.99	10094.75	10086.65	10092.73	13911.0
2019-12-24 13:00:00	NQ	Futures	10092.44	10099.38	10091.86	10097.64	3069.0
2019-12-24 00:00:00	YM	Futures	31090.1	31097.7	31090.1	31097.7	675.0
2019-12-24 01:00:00	YM	Futures	31097.7	31099.9	31093.4	31095.6	567.0
2019-12-24 02:00:00	YM	Futures	31096.7	31104.3	31093.4	31104.3	728.0
2019-12-24 03:00:00	YM	Futures	31103.2	31103.2	31090.1	31098.8	780.0
2019-12-24 04:00:00	YM	Futures	31098.8	31109.7	31097.7	31105.4	792.0
2019-12-24 05:00:00	YM	Futures	31104.3	31106.5	31094.5	31103.2	974.0
2019-12-24 06:00:00	YM	Futures	31104.3	31108.6	31099.9	31107.5	649.0
2019-12-24 07:00:00	YM	Futures	31107.5	31125.0	31104.3	31116.3	1421.0
2019-12-24 08:00:00	YM	Futures	31115.2	31119.5	31103.2	31107.5	1592.0
2019-12-24 09:00:00	YM	Futures	31107.5	31113.0	31032.4	31061.8	12985.0
2019-12-24 10:00:00	YM	Futures	31060.7	31068.4	31043.3	31049.8	7878.0
2019-12-24 11:00:00	YM	Futures	31050.9	31064.0	31037.9	31039.0	4774.0
2019-12-24 12:00:00	YM	Futures	31039.0	31046.6	31028.1	31042.2	5305.0
2019-12-24 13:00:00	YM	Futures	31041.1	31046.6	31034.6	31037.9	876.0
2019-12-24 00:00:00	CL	Futures	53.65	53.69	53.63	53.67	1651.0
2019-12-24 01:00:00	CL	Futures	53.68	53.74	53.68	53.7	3404.0
2019-12-24 02:00:00	CL	Futures	53.7	53.72	53.66	53.69	2637.0
2019-12-24 03:00:00	CL	Futures	53.69	53.7	53.6	53.67	6221.0
2019-12-24 04:00:00	CL	Futures	53.67	53.73	53.63	53.66	5299.0
2019-12-24 05:00:00	CL	Futures	53.67	53.73	53.63	53.71	4152.0
2019-12-24 06:00:00	CL	Futures	53.71	53.78	53.7	53.74	5635.0
2019-12-24 07:00:00	CL	Futures	53.73	53.94	53.7	53.86	17904.0

> showing 50 of 964 rows — these rows as CSV

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