PREVIEW / futures_1hour / 2020-08-16

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-08-16.parquet
  size:    17 KB
  rows:    357

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
2020-08-16 18:00:00	ES	Futures	3759.73	3763.09	3759.18	3761.13	6624.0
2020-08-16 19:00:00	ES	Futures	3761.13	3765.32	3760.01	3764.76	3768.0
2020-08-16 20:00:00	ES	Futures	3764.48	3765.88	3761.69	3763.09	6978.0
2020-08-16 21:00:00	ES	Futures	3762.81	3766.44	3761.69	3765.6	7435.0
2020-08-16 22:00:00	ES	Futures	3765.88	3770.35	3765.6	3768.67	9849.0
2020-08-16 23:00:00	ES	Futures	3768.67	3769.79	3765.04	3765.88	4500.0
2020-08-16 18:00:00	NQ	Futures	12891.58	12910.66	12888.4	12901.7	2215.0
2020-08-16 19:00:00	NQ	Futures	12901.7	12913.85	12896.5	12910.66	1644.0
2020-08-16 20:00:00	NQ	Futures	12910.09	12914.14	12901.99	12906.91	2083.0
2020-08-16 21:00:00	NQ	Futures	12906.91	12927.73	12901.12	12925.12	3079.0
2020-08-16 22:00:00	NQ	Futures	12925.12	12942.76	12924.55	12937.27	2819.0
2020-08-16 23:00:00	NQ	Futures	12937.27	12943.63	12925.7	12930.04	1913.0
2020-08-16 18:00:00	YM	Futures	30655.7	30672.3	30627.1	30659.0	1500.0
2020-08-16 19:00:00	YM	Futures	30660.1	30700.9	30653.5	30696.5	1903.0
2020-08-16 20:00:00	YM	Futures	30695.4	30708.6	30666.7	30677.8	1682.0
2020-08-16 21:00:00	YM	Futures	30677.8	30704.2	30663.4	30694.3	1185.0
2020-08-16 22:00:00	YM	Futures	30697.6	30752.6	30695.4	30737.2	2045.0
2020-08-16 23:00:00	YM	Futures	30739.4	30747.1	30710.8	30727.3	1305.0
2020-08-16 18:00:00	CL	Futures	29.42	29.6	29.37	29.54	1706.0
2020-08-16 19:00:00	CL	Futures	29.53	29.54	29.49	29.51	499.0
2020-08-16 20:00:00	CL	Futures	29.51	29.52	29.46	29.47	575.0
2020-08-16 21:00:00	CL	Futures	29.47	29.53	29.45	29.51	707.0
2020-08-16 22:00:00	CL	Futures	29.52	29.61	29.52	29.58	1425.0
2020-08-16 23:00:00	CL	Futures	29.58	29.58	29.53	29.55	456.0
2020-08-16 18:00:00	GC	Futures	2379.3	2383.6	2375.4	2380.9	4589.0
2020-08-16 19:00:00	GC	Futures	2380.9	2381.2	2362.3	2363.0	5541.0
2020-08-16 20:00:00	GC	Futures	2362.6	2368.4	2358.3	2367.3	8423.0
2020-08-16 21:00:00	GC	Futures	2367.4	2372.0	2361.2	2370.5	8324.0
2020-08-16 22:00:00	GC	Futures	2370.3	2374.7	2368.5	2371.4	3901.0
2020-08-16 23:00:00	GC	Futures	2371.5	2373.8	2369.9	2371.8	2563.0
2020-08-16 18:00:00	ZN	Futures	138.789342	138.804926	138.758174	138.758174	9458.0
2020-08-16 19:00:00	ZN	Futures	138.773758	138.789342	138.742591	138.758174	6963.0
2020-08-16 20:00:00	ZN	Futures	138.758174	138.804926	138.742591	138.789342	9255.0
2020-08-16 21:00:00	ZN	Futures	138.789342	138.82051	138.773758	138.804926	7170.0
2020-08-16 22:00:00	ZN	Futures	138.804926	138.82051	138.773758	138.804926	6310.0
2020-08-16 23:00:00	ZN	Futures	138.804926	138.882845	138.804926	138.882845	14422.0

> showing 36 of 357 rows — these rows as CSV

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