PREVIEW / futures_1hour / 2017-09-15

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-09-15.parquet
  size:    45 KB
  rows:    1,332

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
2017-09-15 00:00:00	ES	Futures	2726.56	2727.93	2726.56	2727.38	4631.0
2017-09-15 01:00:00	ES	Futures	2727.11	2727.93	2726.29	2726.56	4412.0
2017-09-15 02:00:00	ES	Futures	2726.29	2727.65	2726.29	2727.11	8013.0
2017-09-15 03:00:00	ES	Futures	2727.11	2727.38	2724.92	2725.74	20731.0
2017-09-15 04:00:00	ES	Futures	2725.46	2727.65	2725.46	2727.11	13338.0
2017-09-15 05:00:00	ES	Futures	2727.11	2728.75	2725.46	2726.56	29298.0
2017-09-15 06:00:00	ES	Futures	2726.56	2726.56	2725.19	2725.46	18287.0
2017-09-15 07:00:00	ES	Futures	2725.74	2727.93	2725.19	2727.38	17180.0
2017-09-15 08:00:00	ES	Futures	2727.38	2727.93	2725.19	2725.46	35010.0
2017-09-15 09:00:00	ES	Futures	2725.46	2728.47	2723.82	2726.29	221536.0
2017-09-15 10:00:00	ES	Futures	2726.29	2732.03	2725.19	2730.39	163024.0
2017-09-15 11:00:00	ES	Futures	2730.66	2731.21	2729.29	2730.94	108081.0
2017-09-15 12:00:00	ES	Futures	2730.94	2731.48	2729.57	2729.84	80485.0
2017-09-15 13:00:00	ES	Futures	2730.11	2730.94	2729.02	2729.84	69012.0
2017-09-15 14:00:00	ES	Futures	2729.84	2731.21	2729.57	2730.94	57395.0
2017-09-15 15:00:00	ES	Futures	2730.94	2733.4	2730.39	2732.85	270173.0
2017-09-15 16:00:00	ES	Futures	2732.85	2735.59	2731.76	2735.59	111423.0
2017-09-15 00:00:00	NQ	Futures	7100.52	7104.09	7098.74	7102.01	1183.0
2017-09-15 01:00:00	NQ	Futures	7102.3	7104.09	7097.84	7098.74	828.0
2017-09-15 02:00:00	NQ	Futures	7098.74	7102.6	7097.84	7100.22	1114.0
2017-09-15 03:00:00	NQ	Futures	7099.93	7100.52	7093.68	7096.65	2105.0
2017-09-15 04:00:00	NQ	Futures	7096.65	7103.2	7096.36	7101.41	1568.0
2017-09-15 05:00:00	NQ	Futures	7101.11	7104.09	7093.68	7095.46	3004.0
2017-09-15 06:00:00	NQ	Futures	7095.46	7095.46	7090.71	7092.79	2481.0
2017-09-15 07:00:00	NQ	Futures	7092.79	7100.82	7092.19	7099.33	2507.0
2017-09-15 08:00:00	NQ	Futures	7099.03	7101.71	7093.08	7093.38	5139.0
2017-09-15 09:00:00	NQ	Futures	7093.38	7110.33	7091.0	7100.82	42584.0
2017-09-15 10:00:00	NQ	Futures	7100.82	7156.73	7098.74	7149.3	61327.0
2017-09-15 11:00:00	NQ	Futures	7149.3	7150.19	7134.13	7140.08	28917.0
2017-09-15 12:00:00	NQ	Futures	7140.08	7143.35	7127.88	7128.77	17645.0
2017-09-15 13:00:00	NQ	Futures	7128.77	7132.64	7122.53	7126.1	13959.0
2017-09-15 14:00:00	NQ	Futures	7126.1	7130.56	7123.12	7129.67	15227.0
2017-09-15 15:00:00	NQ	Futures	7129.67	7135.32	7125.21	7128.18	34291.0
2017-09-15 16:00:00	NQ	Futures	7128.18	7136.21	7126.99	7135.32	9474.0
2017-09-15 00:00:00	YM	Futures	24111.8	24122.7	24110.7	24118.3	737.0
2017-09-15 01:00:00	YM	Futures	24117.2	24122.7	24111.8	24112.9	866.0
2017-09-15 02:00:00	YM	Futures	24112.9	24120.5	24110.7	24117.2	1156.0
2017-09-15 03:00:00	YM	Futures	24116.1	24119.4	24099.8	24102.0	2024.0
2017-09-15 04:00:00	YM	Futures	24102.0	24119.4	24102.0	24116.1	1457.0
2017-09-15 05:00:00	YM	Futures	24116.1	24129.2	24106.3	24111.8	2566.0
2017-09-15 06:00:00	YM	Futures	24112.9	24114.0	24102.0	24105.3	1260.0
2017-09-15 07:00:00	YM	Futures	24106.3	24119.4	24102.0	24116.1	1372.0
2017-09-15 08:00:00	YM	Futures	24115.0	24121.6	24098.7	24102.0	3165.0
2017-09-15 09:00:00	YM	Futures	24102.0	24141.2	24091.1	24123.7	23240.0
2017-09-15 10:00:00	YM	Futures	24122.7	24161.8	24111.8	24150.9	15345.0
2017-09-15 11:00:00	YM	Futures	24149.9	24155.3	24135.7	24149.9	7164.0
2017-09-15 12:00:00	YM	Futures	24149.9	24157.5	24143.3	24148.8	4133.0
2017-09-15 13:00:00	YM	Futures	24147.7	24156.4	24146.6	24149.9	3638.0
2017-09-15 14:00:00	YM	Futures	24150.9	24165.1	24149.9	24165.1	5799.0
2017-09-15 15:00:00	YM	Futures	24164.0	24182.5	24159.6	24173.8	11717.0

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

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