PREVIEW / futures_1hour / 2018-09-14

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-09-14.parquet
  size:    45 KB
  rows:    1,356

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
2018-09-14 00:00:00	ES	Futures	3166.6	3166.88	3165.52	3166.33	969.0
2018-09-14 01:00:00	ES	Futures	3166.33	3168.51	3166.06	3167.69	2838.0
2018-09-14 02:00:00	ES	Futures	3167.69	3171.77	3167.69	3171.23	5967.0
2018-09-14 03:00:00	ES	Futures	3171.5	3173.95	3170.68	3171.5	11681.0
2018-09-14 04:00:00	ES	Futures	3171.23	3172.86	3170.14	3172.04	7844.0
2018-09-14 05:00:00	ES	Futures	3172.04	3172.86	3170.68	3171.23	4719.0
2018-09-14 06:00:00	ES	Futures	3171.23	3172.04	3169.6	3171.5	4188.0
2018-09-14 07:00:00	ES	Futures	3171.23	3173.4	3170.68	3171.5	9659.0
2018-09-14 08:00:00	ES	Futures	3171.5	3171.77	3169.05	3169.32	12114.0
2018-09-14 09:00:00	ES	Futures	3169.6	3170.41	3165.52	3167.69	107171.0
2018-09-14 10:00:00	ES	Futures	3167.69	3169.32	3162.52	3168.51	118340.0
2018-09-14 11:00:00	ES	Futures	3168.51	3170.96	3167.15	3169.87	74871.0
2018-09-14 12:00:00	ES	Futures	3169.87	3170.14	3158.99	3160.62	177694.0
2018-09-14 13:00:00	ES	Futures	3160.35	3164.16	3157.36	3164.16	60488.0
2018-09-14 14:00:00	ES	Futures	3164.16	3165.79	3163.07	3165.52	49536.0
2018-09-14 15:00:00	ES	Futures	3165.52	3169.05	3164.43	3167.15	90065.0
2018-09-14 16:00:00	ES	Futures	3167.15	3168.78	3166.06	3167.42	37607.0
2018-09-14 00:00:00	NQ	Futures	8917.34	8919.98	8915.28	8917.34	503.0
2018-09-14 01:00:00	NQ	Futures	8917.63	8928.19	8915.87	8925.26	1219.0
2018-09-14 02:00:00	NQ	Futures	8925.26	8941.68	8924.38	8939.34	2990.0
2018-09-14 03:00:00	NQ	Futures	8939.34	8948.43	8936.11	8937.58	4671.0
2018-09-14 04:00:00	NQ	Futures	8937.58	8946.08	8932.88	8944.61	2873.0
2018-09-14 05:00:00	NQ	Futures	8944.61	8946.08	8939.04	8939.63	1923.0
2018-09-14 06:00:00	NQ	Futures	8939.34	8943.73	8934.64	8939.34	1695.0
2018-09-14 07:00:00	NQ	Futures	8939.04	8944.32	8936.4	8941.1	3080.0
2018-09-14 08:00:00	NQ	Futures	8941.39	8941.68	8923.2	8923.79	4685.0
2018-09-14 09:00:00	NQ	Futures	8923.5	8931.71	8896.8	8917.92	48085.0
2018-09-14 10:00:00	NQ	Futures	8918.22	8933.18	8897.68	8920.27	46489.0
2018-09-14 11:00:00	NQ	Futures	8919.98	8924.08	8902.38	8908.54	31080.0
2018-09-14 12:00:00	NQ	Futures	8908.24	8910.0	8856.03	8870.11	56394.0
2018-09-14 13:00:00	NQ	Futures	8869.82	8888.89	8851.34	8886.54	26557.0
2018-09-14 14:00:00	NQ	Futures	8886.83	8892.7	8881.55	8887.13	14942.0
2018-09-14 15:00:00	NQ	Futures	8886.83	8900.91	8880.97	8886.25	21480.0
2018-09-14 16:00:00	NQ	Futures	8886.54	8892.11	8881.26	8886.25	4630.0
2018-09-14 00:00:00	YM	Futures	28457.9	28461.2	28450.3	28457.9	302.0
2018-09-14 01:00:00	YM	Futures	28459.0	28482.9	28454.7	28473.1	979.0
2018-09-14 02:00:00	YM	Futures	28473.1	28506.8	28471.0	28502.5	1566.0
2018-09-14 03:00:00	YM	Futures	28502.5	28532.9	28493.8	28502.5	2759.0
2018-09-14 04:00:00	YM	Futures	28501.4	28513.3	28487.3	28501.4	1850.0
2018-09-14 05:00:00	YM	Futures	28501.4	28511.2	28486.2	28490.5	994.0
2018-09-14 06:00:00	YM	Futures	28488.4	28499.2	28473.1	28492.7	1238.0
2018-09-14 07:00:00	YM	Futures	28492.7	28509.0	28488.4	28499.2	2011.0
2018-09-14 08:00:00	YM	Futures	28499.2	28500.3	28471.0	28479.7	2003.0
2018-09-14 09:00:00	YM	Futures	28479.7	28504.7	28465.5	28473.1	11011.0
2018-09-14 10:00:00	YM	Futures	28476.4	28484.0	28437.3	28475.3	11781.0
2018-09-14 11:00:00	YM	Futures	28476.4	28519.9	28469.9	28504.7	8857.0
2018-09-14 12:00:00	YM	Futures	28504.7	28507.9	28378.6	28397.1	18464.0
2018-09-14 13:00:00	YM	Futures	28397.1	28419.9	28362.3	28415.6	8406.0
2018-09-14 14:00:00	YM	Futures	28416.6	28432.9	28410.1	28427.5	5177.0
2018-09-14 15:00:00	YM	Futures	28427.5	28469.9	28422.1	28456.8	7457.0

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

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