PREVIEW / futures_1hour / 2017-09-14

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-09-14.parquet
  size:    52 KB
  rows:    1,620

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-14 00:00:00	ES	Futures	2726.83	2727.11	2726.29	2727.11	2755.0
2017-09-14 01:00:00	ES	Futures	2727.11	2727.38	2726.29	2727.11	2741.0
2017-09-14 02:00:00	ES	Futures	2727.11	2727.38	2726.29	2726.56	3946.0
2017-09-14 03:00:00	ES	Futures	2726.83	2728.2	2726.29	2728.2	14366.0
2017-09-14 04:00:00	ES	Futures	2728.2	2728.75	2726.83	2728.75	10325.0
2017-09-14 05:00:00	ES	Futures	2728.75	2729.02	2727.93	2728.75	6496.0
2017-09-14 06:00:00	ES	Futures	2728.75	2729.29	2727.65	2728.47	8384.0
2017-09-14 07:00:00	ES	Futures	2728.47	2729.02	2727.38	2728.2	18627.0
2017-09-14 08:00:00	ES	Futures	2728.47	2728.75	2721.91	2723.82	84111.0
2017-09-14 09:00:00	ES	Futures	2723.82	2727.65	2723.0	2727.38	155417.0
2017-09-14 10:00:00	ES	Futures	2727.38	2729.84	2726.01	2728.75	129235.0
2017-09-14 11:00:00	ES	Futures	2728.75	2731.48	2728.2	2729.29	123956.0
2017-09-14 12:00:00	ES	Futures	2729.29	2730.66	2727.65	2729.84	84741.0
2017-09-14 13:00:00	ES	Futures	2730.11	2730.11	2727.93	2728.2	74715.0
2017-09-14 14:00:00	ES	Futures	2728.2	2730.11	2727.38	2729.29	81467.0
2017-09-14 15:00:00	ES	Futures	2729.02	2729.84	2727.38	2729.57	186333.0
2017-09-14 16:00:00	ES	Futures	2729.29	2729.84	2728.2	2729.02	91558.0
2017-09-14 18:00:00	ES	Futures	2728.75	2729.02	2721.36	2722.18	27789.0
2017-09-14 19:00:00	ES	Futures	2722.18	2723.55	2721.63	2722.46	8890.0
2017-09-14 20:00:00	ES	Futures	2722.18	2724.64	2721.91	2724.64	8913.0
2017-09-14 21:00:00	ES	Futures	2724.37	2725.46	2723.55	2724.64	8416.0
2017-09-14 22:00:00	ES	Futures	2724.37	2724.64	2723.0	2724.1	5319.0
2017-09-14 23:00:00	ES	Futures	2724.1	2727.11	2724.1	2726.83	6452.0
2017-09-14 00:00:00	NQ	Futures	7141.56	7141.86	7139.18	7140.37	368.0
2017-09-14 01:00:00	NQ	Futures	7140.67	7140.67	7137.4	7140.67	560.0
2017-09-14 02:00:00	NQ	Futures	7140.08	7141.27	7138.29	7139.18	865.0
2017-09-14 03:00:00	NQ	Futures	7139.18	7143.35	7137.99	7143.35	1332.0
2017-09-14 04:00:00	NQ	Futures	7143.65	7145.13	7139.78	7144.84	1328.0
2017-09-14 05:00:00	NQ	Futures	7144.84	7144.84	7141.27	7143.65	1355.0
2017-09-14 06:00:00	NQ	Futures	7143.65	7145.13	7138.89	7140.37	1226.0
2017-09-14 07:00:00	NQ	Futures	7140.08	7141.86	7137.99	7139.48	2261.0
2017-09-14 08:00:00	NQ	Futures	7139.78	7140.37	7111.23	7118.07	18024.0
2017-09-14 09:00:00	NQ	Futures	7118.07	7126.69	7102.6	7121.93	45399.0
2017-09-14 10:00:00	NQ	Futures	7121.93	7133.83	7113.9	7131.75	31963.0
2017-09-14 11:00:00	NQ	Futures	7132.05	7142.75	7126.99	7130.56	26756.0
2017-09-14 12:00:00	NQ	Futures	7130.56	7131.75	7113.01	7124.61	23823.0
2017-09-14 13:00:00	NQ	Futures	7124.61	7125.5	7113.61	7114.2	18444.0
2017-09-14 14:00:00	NQ	Futures	7114.5	7120.74	7112.12	7117.77	19504.0
2017-09-14 15:00:00	NQ	Futures	7117.47	7120.15	7100.82	7105.87	40154.0
2017-09-14 16:00:00	NQ	Futures	7105.87	7108.55	7102.01	7103.49	7988.0
2017-09-14 18:00:00	NQ	Futures	7104.39	7105.28	7076.13	7081.19	6900.0
2017-09-14 19:00:00	NQ	Futures	7081.19	7086.84	7080.89	7082.97	2002.0
2017-09-14 20:00:00	NQ	Futures	7082.97	7092.19	7082.08	7092.19	3002.0
2017-09-14 21:00:00	NQ	Futures	7091.9	7096.06	7090.11	7093.38	2445.0
2017-09-14 22:00:00	NQ	Futures	7093.38	7094.27	7089.22	7093.98	1425.0
2017-09-14 23:00:00	NQ	Futures	7094.27	7102.3	7093.98	7100.52	1608.0
2017-09-14 00:00:00	YM	Futures	24041.1	24041.1	24037.8	24038.9	356.0
2017-09-14 01:00:00	YM	Futures	24038.9	24040.0	24034.6	24040.0	427.0
2017-09-14 02:00:00	YM	Futures	24038.9	24041.1	24034.6	24038.9	715.0
2017-09-14 03:00:00	YM	Futures	24038.9	24048.7	24034.6	24045.4	1554.0

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

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