PREVIEW / futures_1hour / 2017-09-21

all futures 1-hour files

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

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-21 00:00:00	ES	Futures	2740.78	2740.78	2739.96	2740.24	2894.0
2017-09-21 01:00:00	ES	Futures	2740.24	2740.51	2738.87	2739.42	7398.0
2017-09-21 02:00:00	ES	Futures	2739.42	2739.96	2738.32	2738.87	6700.0
2017-09-21 03:00:00	ES	Futures	2738.6	2738.87	2737.23	2738.05	20754.0
2017-09-21 04:00:00	ES	Futures	2738.32	2740.24	2738.05	2739.96	13426.0
2017-09-21 05:00:00	ES	Futures	2739.69	2739.96	2738.87	2739.69	8760.0
2017-09-21 06:00:00	ES	Futures	2739.69	2740.78	2739.14	2740.51	12647.0
2017-09-21 07:00:00	ES	Futures	2740.51	2740.78	2739.42	2740.24	10199.0
2017-09-21 08:00:00	ES	Futures	2740.24	2741.06	2739.14	2740.51	16780.0
2017-09-21 09:00:00	ES	Futures	2740.51	2741.06	2732.03	2734.49	212741.0
2017-09-21 10:00:00	ES	Futures	2734.49	2737.77	2731.76	2736.68	209837.0
2017-09-21 11:00:00	ES	Futures	2736.68	2739.14	2736.13	2737.23	117359.0
2017-09-21 12:00:00	ES	Futures	2737.23	2739.14	2736.13	2738.05	67053.0
2017-09-21 13:00:00	ES	Futures	2737.77	2738.87	2736.68	2738.05	48269.0
2017-09-21 14:00:00	ES	Futures	2738.32	2738.6	2734.49	2736.95	85079.0
2017-09-21 15:00:00	ES	Futures	2736.68	2738.32	2733.67	2734.49	173275.0
2017-09-21 16:00:00	ES	Futures	2734.49	2737.5	2734.49	2736.41	63872.0
2017-09-21 18:00:00	ES	Futures	2736.41	2736.68	2735.31	2735.86	3836.0
2017-09-21 19:00:00	ES	Futures	2735.86	2736.41	2734.22	2735.04	3431.0
2017-09-21 20:00:00	ES	Futures	2735.04	2735.59	2729.84	2730.39	16482.0
2017-09-21 21:00:00	ES	Futures	2730.39	2731.21	2727.11	2728.75	21490.0
2017-09-21 22:00:00	ES	Futures	2728.75	2729.29	2726.83	2727.65	9214.0
2017-09-21 23:00:00	ES	Futures	2727.38	2729.29	2727.38	2729.02	5804.0
2017-09-21 00:00:00	NQ	Futures	7103.79	7105.87	7102.01	7104.39	1687.0
2017-09-21 01:00:00	NQ	Futures	7104.68	7105.28	7100.22	7101.71	1071.0
2017-09-21 02:00:00	NQ	Futures	7101.41	7102.3	7096.95	7097.84	1645.0
2017-09-21 03:00:00	NQ	Futures	7098.14	7101.41	7094.87	7098.14	2950.0
2017-09-21 04:00:00	NQ	Futures	7097.84	7106.77	7097.84	7105.87	1914.0
2017-09-21 05:00:00	NQ	Futures	7105.58	7106.47	7102.9	7106.17	1099.0
2017-09-21 06:00:00	NQ	Futures	7106.47	7111.23	7103.79	7110.33	1517.0
2017-09-21 07:00:00	NQ	Futures	7110.33	7110.93	7105.58	7109.44	1846.0
2017-09-21 08:00:00	NQ	Futures	7109.44	7113.31	7103.49	7112.12	3693.0
2017-09-21 09:00:00	NQ	Futures	7111.82	7112.42	7058.29	7068.1	61241.0
2017-09-21 10:00:00	NQ	Futures	7067.8	7072.56	7041.93	7066.32	87241.0
2017-09-21 11:00:00	NQ	Futures	7066.02	7083.27	7064.24	7078.21	39292.0
2017-09-21 12:00:00	NQ	Futures	7078.51	7090.11	7073.46	7083.86	27020.0
2017-09-21 13:00:00	NQ	Futures	7083.86	7097.84	7082.68	7091.3	23109.0
2017-09-21 14:00:00	NQ	Futures	7091.3	7094.27	7074.05	7081.19	30875.0
2017-09-21 15:00:00	NQ	Futures	7081.19	7086.84	7064.83	7066.61	35818.0
2017-09-21 16:00:00	NQ	Futures	7066.91	7075.54	7066.02	7070.78	9257.0
2017-09-21 18:00:00	NQ	Futures	7071.67	7073.16	7066.61	7069.89	1129.0
2017-09-21 19:00:00	NQ	Futures	7069.89	7071.97	7065.43	7068.4	1077.0
2017-09-21 20:00:00	NQ	Futures	7068.1	7070.18	7045.5	7048.17	4737.0
2017-09-21 21:00:00	NQ	Futures	7047.88	7050.55	7033.9	7041.04	6358.0
2017-09-21 22:00:00	NQ	Futures	7041.04	7041.63	7032.11	7035.68	3134.0
2017-09-21 23:00:00	NQ	Futures	7035.98	7042.82	7034.49	7041.63	1997.0
2017-09-21 00:00:00	YM	Futures	24335.8	24338.0	24330.4	24331.5	921.0
2017-09-21 01:00:00	YM	Futures	24332.6	24334.8	24319.5	24323.9	2343.0
2017-09-21 02:00:00	YM	Futures	24323.9	24329.3	24316.3	24323.9	1334.0
2017-09-21 03:00:00	YM	Futures	24322.8	24327.1	24314.1	24317.4	1599.0

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

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