PREVIEW / futures_1hour / 2019-07-18

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-07-18.parquet
  size:    61 KB
  rows:    1,857

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-07-18 00:00:00	ES	Futures	3225.18	3226.26	3223.01	3225.72	5846.0
2019-07-18 01:00:00	ES	Futures	3225.99	3226.26	3221.93	3223.01	10063.0
2019-07-18 02:00:00	ES	Futures	3223.01	3226.8	3223.01	3224.37	12456.0
2019-07-18 03:00:00	ES	Futures	3224.37	3227.89	3223.01	3226.8	26513.0
2019-07-18 04:00:00	ES	Futures	3226.8	3227.08	3223.29	3225.18	16638.0
2019-07-18 05:00:00	ES	Futures	3224.91	3229.24	3224.37	3227.35	17676.0
2019-07-18 06:00:00	ES	Futures	3227.62	3231.14	3226.8	3231.14	24706.0
2019-07-18 07:00:00	ES	Futures	3230.86	3233.03	3228.97	3229.78	25758.0
2019-07-18 08:00:00	ES	Futures	3229.78	3234.38	3229.51	3230.32	26838.0
2019-07-18 09:00:00	ES	Futures	3230.32	3233.3	3225.99	3231.41	155917.0
2019-07-18 10:00:00	ES	Futures	3231.41	3237.63	3228.97	3234.93	180103.0
2019-07-18 11:00:00	ES	Futures	3234.93	3235.74	3222.2	3223.83	150055.0
2019-07-18 12:00:00	ES	Futures	3223.56	3232.76	3223.29	3230.05	96343.0
2019-07-18 13:00:00	ES	Futures	3230.32	3234.11	3229.78	3232.76	60320.0
2019-07-18 14:00:00	ES	Futures	3232.76	3246.57	3232.22	3246.57	153729.0
2019-07-18 15:00:00	ES	Futures	3246.57	3250.09	3240.34	3245.75	205752.0
2019-07-18 16:00:00	ES	Futures	3245.48	3254.15	3243.59	3252.25	73204.0
2019-07-18 18:00:00	ES	Futures	3252.52	3258.75	3244.4	3245.21	26773.0
2019-07-18 19:00:00	ES	Futures	3244.94	3251.17	3244.4	3249.0	7765.0
2019-07-18 20:00:00	ES	Futures	3249.0	3255.23	3248.73	3254.69	16053.0
2019-07-18 21:00:00	ES	Futures	3254.96	3257.39	3253.87	3256.85	13550.0
2019-07-18 22:00:00	ES	Futures	3256.85	3257.94	3255.77	3257.12	9029.0
2019-07-18 23:00:00	ES	Futures	3256.85	3257.66	3255.23	3255.5	5540.0
2019-07-18 00:00:00	NQ	Futures	9113.66	9114.24	9105.83	9111.34	1952.0
2019-07-18 01:00:00	NQ	Futures	9111.34	9111.63	9090.74	9098.29	4862.0
2019-07-18 02:00:00	NQ	Futures	9098.29	9117.15	9098.29	9111.34	4655.0
2019-07-18 03:00:00	NQ	Futures	9111.34	9128.17	9107.28	9123.24	6881.0
2019-07-18 04:00:00	NQ	Futures	9123.53	9124.98	9115.7	9122.37	5602.0
2019-07-18 05:00:00	NQ	Futures	9122.66	9136.3	9121.21	9128.75	6202.0
2019-07-18 06:00:00	NQ	Futures	9128.46	9138.91	9123.82	9138.33	6126.0
2019-07-18 07:00:00	NQ	Futures	9138.33	9144.71	9133.68	9136.59	6149.0
2019-07-18 08:00:00	NQ	Futures	9136.59	9155.73	9134.55	9143.26	9641.0
2019-07-18 09:00:00	NQ	Futures	9142.97	9170.53	9126.43	9156.02	59399.0
2019-07-18 10:00:00	NQ	Futures	9155.73	9174.59	9139.49	9145.29	57906.0
2019-07-18 11:00:00	NQ	Futures	9145.29	9149.06	9104.96	9109.31	48597.0
2019-07-18 12:00:00	NQ	Futures	9109.31	9134.84	9106.12	9125.56	31109.0
2019-07-18 13:00:00	NQ	Futures	9125.56	9143.55	9124.4	9138.33	22008.0
2019-07-18 14:00:00	NQ	Futures	9138.33	9194.03	9137.46	9193.45	40913.0
2019-07-18 15:00:00	NQ	Futures	9193.45	9205.93	9171.11	9192.58	52213.0
2019-07-18 16:00:00	NQ	Futures	9192.58	9232.04	9180.69	9223.05	22397.0
2019-07-18 18:00:00	NQ	Futures	9227.11	9255.54	9211.73	9212.6	9748.0
2019-07-18 19:00:00	NQ	Futures	9212.89	9232.04	9210.57	9221.6	4170.0
2019-07-18 20:00:00	NQ	Futures	9221.31	9243.36	9220.73	9242.2	4500.0
2019-07-18 21:00:00	NQ	Futures	9242.49	9253.8	9237.55	9250.03	4291.0
2019-07-18 22:00:00	NQ	Futures	9250.61	9254.67	9245.68	9250.32	3325.0
2019-07-18 23:00:00	NQ	Futures	9250.03	9252.06	9240.75	9241.91	2225.0
2019-07-18 00:00:00	YM	Futures	29527.8	29535.4	29510.4	29533.2	1386.0
2019-07-18 01:00:00	YM	Futures	29534.3	29536.5	29506.1	29514.8	1869.0
2019-07-18 02:00:00	YM	Futures	29514.8	29537.6	29514.8	29516.9	2806.0
2019-07-18 03:00:00	YM	Futures	29518.0	29548.5	29509.3	29541.9	4497.0

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

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