PREVIEW / futures_1hour / 2019-10-13

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-10-13.parquet
  size:    17 KB
  rows:    366

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-10-13 18:00:00	ES	Futures	3224.8	3237.3	3224.26	3235.4	13729.0
2019-10-13 19:00:00	ES	Futures	3235.4	3239.74	3235.4	3239.74	5792.0
2019-10-13 20:00:00	ES	Futures	3239.74	3240.56	3231.87	3234.04	11838.0
2019-10-13 21:00:00	ES	Futures	3234.04	3234.58	3225.89	3233.77	15418.0
2019-10-13 22:00:00	ES	Futures	3233.77	3236.21	3231.87	3234.04	8598.0
2019-10-13 23:00:00	ES	Futures	3234.31	3236.48	3232.95	3235.94	4222.0
2019-10-13 18:00:00	NQ	Futures	9121.75	9167.07	9121.46	9160.67	4864.0
2019-10-13 19:00:00	NQ	Futures	9160.09	9171.71	9158.35	9171.13	2574.0
2019-10-13 20:00:00	NQ	Futures	9171.13	9173.46	9145.86	9151.09	6431.0
2019-10-13 21:00:00	NQ	Futures	9150.51	9155.16	9128.14	9151.67	8206.0
2019-10-13 22:00:00	NQ	Futures	9151.67	9160.09	9145.57	9150.8	4728.0
2019-10-13 23:00:00	NQ	Futures	9150.51	9156.9	9147.02	9155.45	3281.0
2019-10-13 18:00:00	YM	Futures	29125.4	29251.6	29124.3	29235.3	3090.0
2019-10-13 19:00:00	YM	Futures	29233.1	29266.9	29229.9	29266.9	1270.0
2019-10-13 20:00:00	YM	Futures	29268.0	29270.1	29190.7	29209.2	2485.0
2019-10-13 21:00:00	YM	Futures	29207.0	29216.8	29137.4	29204.8	3424.0
2019-10-13 22:00:00	YM	Futures	29204.8	29224.4	29184.2	29207.0	2000.0
2019-10-13 23:00:00	YM	Futures	29209.2	29224.4	29197.2	29219.0	1042.0
2019-10-13 18:00:00	CL	Futures	48.77	48.77	48.58	48.62	2904.0
2019-10-13 19:00:00	CL	Futures	48.61	48.73	48.61	48.69	1644.0
2019-10-13 20:00:00	CL	Futures	48.69	48.69	48.44	48.44	3911.0
2019-10-13 21:00:00	CL	Futures	48.44	48.45	48.25	48.41	10132.0
2019-10-13 22:00:00	CL	Futures	48.41	48.45	48.29	48.36	5927.0
2019-10-13 23:00:00	CL	Futures	48.37	48.38	48.33	48.37	1935.0
2019-10-13 18:00:00	GC	Futures	1890.2	1891.9	1884.0	1885.7	4892.0
2019-10-13 19:00:00	GC	Futures	1885.6	1887.2	1884.6	1886.4	2415.0
2019-10-13 20:00:00	GC	Futures	1886.4	1888.6	1885.3	1887.6	6291.0
2019-10-13 21:00:00	GC	Futures	1887.8	1890.9	1885.1	1888.1	11668.0
2019-10-13 22:00:00	GC	Futures	1888.1	1889.7	1886.4	1889.1	4776.0
2019-10-13 23:00:00	GC	Futures	1889.0	1889.5	1887.0	1888.4	3371.0
2019-10-13 18:00:00	ZN	Futures	130.138949	130.170217	130.013875	130.092046	11601.0
2019-10-13 19:00:00	ZN	Futures	130.092046	130.092046	130.045144	130.060778	2019.0
2019-10-13 20:00:00	ZN	Futures	130.045144	130.21712	130.045144	130.201485	14934.0
2019-10-13 21:00:00	ZN	Futures	130.201485	130.310925	130.185851	130.232754	13307.0
2019-10-13 22:00:00	ZN	Futures	130.232754	130.232754	130.170217	130.21712	4802.0
2019-10-13 23:00:00	ZN	Futures	130.21712	130.21712	130.185851	130.201485	3675.0

> showing 36 of 366 rows — these rows as CSV

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