PREVIEW / futures_1hour / 2017-09-18

all futures 1-hour files

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

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-18 00:00:00	ES	Futures	2739.14	2739.96	2738.87	2739.14	3547.0
2017-09-18 01:00:00	ES	Futures	2739.42	2740.24	2738.87	2739.14	4897.0
2017-09-18 02:00:00	ES	Futures	2739.42	2740.51	2738.87	2739.96	7307.0
2017-09-18 03:00:00	ES	Futures	2739.96	2740.51	2738.05	2738.32	20915.0
2017-09-18 04:00:00	ES	Futures	2738.32	2739.69	2737.5	2738.6	12971.0
2017-09-18 05:00:00	ES	Futures	2738.87	2739.69	2738.6	2738.87	8940.0
2017-09-18 06:00:00	ES	Futures	2738.87	2739.14	2737.77	2738.32	10018.0
2017-09-18 07:00:00	ES	Futures	2738.6	2738.6	2737.23	2738.32	9925.0
2017-09-18 08:00:00	ES	Futures	2738.05	2738.32	2735.59	2736.13	20045.0
2017-09-18 09:00:00	ES	Futures	2736.13	2742.15	2735.04	2741.06	167495.0
2017-09-18 10:00:00	ES	Futures	2740.78	2741.6	2739.14	2739.96	130077.0
2017-09-18 11:00:00	ES	Futures	2739.96	2741.88	2739.42	2739.69	87339.0
2017-09-18 12:00:00	ES	Futures	2739.96	2740.78	2737.77	2739.42	71748.0
2017-09-18 13:00:00	ES	Futures	2739.42	2740.51	2738.05	2739.14	54062.0
2017-09-18 14:00:00	ES	Futures	2739.14	2739.14	2733.12	2735.31	189472.0
2017-09-18 15:00:00	ES	Futures	2735.04	2738.6	2735.04	2738.05	163283.0
2017-09-18 16:00:00	ES	Futures	2737.77	2739.14	2736.68	2738.87	78618.0
2017-09-18 18:00:00	ES	Futures	2738.6	2739.14	2738.05	2738.6	3537.0
2017-09-18 19:00:00	ES	Futures	2738.87	2739.14	2738.05	2738.6	2313.0
2017-09-18 20:00:00	ES	Futures	2738.6	2739.96	2738.32	2739.42	7787.0
2017-09-18 21:00:00	ES	Futures	2739.42	2739.69	2737.5	2738.32	9338.0
2017-09-18 22:00:00	ES	Futures	2738.32	2738.87	2737.77	2737.77	4046.0
2017-09-18 23:00:00	ES	Futures	2737.77	2738.87	2737.77	2738.6	2288.0
2017-09-18 00:00:00	NQ	Futures	7149.89	7150.78	7148.4	7149.3	576.0
2017-09-18 01:00:00	NQ	Futures	7149.59	7151.97	7147.81	7148.7	747.0
2017-09-18 02:00:00	NQ	Futures	7148.7	7151.38	7147.81	7150.49	1032.0
2017-09-18 03:00:00	NQ	Futures	7150.19	7150.19	7140.08	7141.56	3017.0
2017-09-18 04:00:00	NQ	Futures	7141.56	7146.92	7140.08	7142.16	1977.0
2017-09-18 05:00:00	NQ	Futures	7142.16	7147.81	7140.97	7145.43	1404.0
2017-09-18 06:00:00	NQ	Futures	7145.43	7147.21	7141.27	7145.13	1466.0
2017-09-18 07:00:00	NQ	Futures	7145.13	7145.73	7141.56	7143.94	1294.0
2017-09-18 08:00:00	NQ	Futures	7143.94	7144.24	7132.34	7135.02	4564.0
2017-09-18 09:00:00	NQ	Futures	7135.32	7159.71	7129.67	7150.78	40751.0
2017-09-18 10:00:00	NQ	Futures	7151.08	7158.22	7140.97	7144.24	33920.0
2017-09-18 11:00:00	NQ	Futures	7144.24	7156.43	7143.94	7151.08	18137.0
2017-09-18 12:00:00	NQ	Futures	7151.38	7156.43	7145.73	7151.08	13343.0
2017-09-18 13:00:00	NQ	Futures	7150.78	7151.08	7143.35	7146.62	10027.0
2017-09-18 14:00:00	NQ	Futures	7146.92	7147.21	7099.03	7112.71	47025.0
2017-09-18 15:00:00	NQ	Futures	7112.42	7127.29	7110.04	7120.45	36162.0
2017-09-18 16:00:00	NQ	Futures	7120.74	7125.5	7117.47	7123.72	6031.0
2017-09-18 18:00:00	NQ	Futures	7125.8	7128.18	7123.72	7125.8	985.0
2017-09-18 19:00:00	NQ	Futures	7126.1	7126.99	7123.72	7125.8	556.0
2017-09-18 20:00:00	NQ	Futures	7125.5	7131.15	7124.91	7127.59	1571.0
2017-09-18 21:00:00	NQ	Futures	7127.88	7128.18	7120.15	7122.83	2008.0
2017-09-18 22:00:00	NQ	Futures	7123.12	7124.02	7119.85	7120.74	991.0
2017-09-18 23:00:00	NQ	Futures	7120.74	7123.12	7120.74	7122.23	636.0
2017-09-18 00:00:00	YM	Futures	24240.1	24253.2	24235.8	24240.1	2954.0
2017-09-18 01:00:00	YM	Futures	24240.1	24247.7	24238.0	24240.1	1135.0
2017-09-18 02:00:00	YM	Futures	24241.2	24261.9	24240.1	24255.4	1760.0
2017-09-18 03:00:00	YM	Futures	24255.4	24255.4	24229.3	24231.4	2567.0

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

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