PREVIEW / futures_1hour / 2019-07-04

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-07-04.parquet
  size:    40 KB
  rows:    1,311

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-04 00:00:00	ES	Futures	3247.38	3248.46	3247.38	3248.19	1957.0
2019-07-04 01:00:00	ES	Futures	3248.46	3248.73	3247.38	3247.92	2836.0
2019-07-04 02:00:00	ES	Futures	3247.65	3247.65	3245.48	3246.84	4812.0
2019-07-04 03:00:00	ES	Futures	3246.57	3248.73	3246.3	3246.84	8253.0
2019-07-04 04:00:00	ES	Futures	3246.84	3247.65	3245.75	3247.11	5306.0
2019-07-04 05:00:00	ES	Futures	3247.11	3249.0	3246.84	3248.46	6261.0
2019-07-04 06:00:00	ES	Futures	3248.19	3248.73	3247.11	3248.46	3633.0
2019-07-04 07:00:00	ES	Futures	3248.46	3249.81	3248.19	3249.54	5433.0
2019-07-04 08:00:00	ES	Futures	3249.81	3251.98	3248.73	3250.36	7549.0
2019-07-04 09:00:00	ES	Futures	3250.36	3251.44	3249.81	3250.9	6983.0
2019-07-04 10:00:00	ES	Futures	3251.17	3252.52	3249.81	3252.25	10307.0
2019-07-04 11:00:00	ES	Futures	3252.25	3252.25	3250.9	3251.44	7470.0
2019-07-04 12:00:00	ES	Futures	3251.44	3251.71	3250.36	3250.9	3576.0
2019-07-04 18:00:00	ES	Futures	3251.44	3252.25	3250.9	3251.17	3331.0
2019-07-04 19:00:00	ES	Futures	3251.17	3251.98	3250.9	3251.44	1657.0
2019-07-04 20:00:00	ES	Futures	3251.44	3251.71	3249.54	3250.63	5163.0
2019-07-04 21:00:00	ES	Futures	3250.36	3251.71	3248.73	3249.0	6968.0
2019-07-04 22:00:00	ES	Futures	3249.27	3252.25	3249.0	3251.71	4908.0
2019-07-04 23:00:00	ES	Futures	3251.71	3252.52	3251.17	3251.71	3364.0
2019-07-04 00:00:00	NQ	Futures	9152.25	9155.15	9151.67	9153.99	785.0
2019-07-04 01:00:00	NQ	Futures	9153.99	9156.32	9151.96	9153.12	849.0
2019-07-04 02:00:00	NQ	Futures	9152.83	9155.44	9147.03	9153.12	1791.0
2019-07-04 03:00:00	NQ	Futures	9152.83	9159.22	9149.64	9151.67	3974.0
2019-07-04 04:00:00	NQ	Futures	9151.96	9153.99	9148.48	9151.38	1556.0
2019-07-04 05:00:00	NQ	Futures	9151.38	9160.67	9151.38	9160.67	2028.0
2019-07-04 06:00:00	NQ	Futures	9160.38	9160.67	9155.73	9157.19	960.0
2019-07-04 07:00:00	NQ	Futures	9157.48	9164.44	9156.61	9163.86	1737.0
2019-07-04 08:00:00	NQ	Futures	9163.86	9167.05	9160.96	9162.41	2049.0
2019-07-04 09:00:00	NQ	Futures	9162.7	9169.08	9162.41	9166.76	3488.0
2019-07-04 10:00:00	NQ	Futures	9166.76	9174.59	9160.96	9174.01	5020.0
2019-07-04 11:00:00	NQ	Futures	9174.01	9176.33	9169.95	9171.98	3440.0
2019-07-04 12:00:00	NQ	Futures	9171.98	9174.01	9166.18	9170.82	1864.0
2019-07-04 18:00:00	NQ	Futures	9170.53	9179.82	9162.7	9174.3	1670.0
2019-07-04 19:00:00	NQ	Futures	9174.3	9176.92	9172.27	9173.43	760.0
2019-07-04 20:00:00	NQ	Futures	9173.72	9174.88	9166.76	9169.95	2221.0
2019-07-04 21:00:00	NQ	Futures	9169.66	9172.85	9162.99	9163.86	2760.0
2019-07-04 22:00:00	NQ	Futures	9163.57	9176.04	9163.57	9173.43	2146.0
2019-07-04 23:00:00	NQ	Futures	9173.14	9174.88	9170.53	9171.4	938.0
2019-07-04 00:00:00	YM	Futures	29314.7	29324.4	29313.6	29322.3	704.0
2019-07-04 01:00:00	YM	Futures	29321.2	29328.8	29315.7	29320.1	677.0
2019-07-04 02:00:00	YM	Futures	29319.0	29320.1	29300.5	29306.0	1420.0
2019-07-04 03:00:00	YM	Futures	29306.0	29319.0	29296.2	29306.0	2268.0
2019-07-04 04:00:00	YM	Futures	29307.0	29320.1	29299.4	29309.2	2640.0
2019-07-04 05:00:00	YM	Futures	29309.2	29327.7	29308.1	29325.5	1434.0
2019-07-04 06:00:00	YM	Futures	29324.4	29328.8	29316.8	29326.6	703.0
2019-07-04 07:00:00	YM	Futures	29327.7	29346.2	29324.4	29345.1	1309.0
2019-07-04 08:00:00	YM	Futures	29345.1	29360.3	29339.7	29345.1	1406.0
2019-07-04 09:00:00	YM	Futures	29346.2	29351.6	29341.8	29348.4	1920.0
2019-07-04 10:00:00	YM	Futures	29348.4	29356.0	29339.7	29354.9	2258.0
2019-07-04 11:00:00	YM	Futures	29354.9	29356.0	29346.2	29348.4	1419.0

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

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