PREVIEW / futures_1hour / 2015-01-02

all futures 1-hour files

  file:    by_date/futures_1hour/2015/2015-01-02.parquet
  size:    42 KB
  rows:    1,176

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
2015-01-02 00:00:00	ES	Futures	2171.53	2172.58	2170.48	2171.0	2433.0
2015-01-02 01:00:00	ES	Futures	2170.74	2172.32	2169.69	2172.32	1899.0
2015-01-02 02:00:00	ES	Futures	2172.32	2176.0	2172.06	2175.21	9930.0
2015-01-02 03:00:00	ES	Futures	2175.21	2176.0	2168.9	2168.9	16732.0
2015-01-02 04:00:00	ES	Futures	2168.9	2170.21	2167.06	2168.37	16653.0
2015-01-02 05:00:00	ES	Futures	2168.63	2170.48	2166.0	2168.9	10923.0
2015-01-02 06:00:00	ES	Futures	2168.9	2169.95	2166.0	2166.53	8619.0
2015-01-02 07:00:00	ES	Futures	2166.79	2170.21	2166.79	2169.42	9529.0
2015-01-02 08:00:00	ES	Futures	2169.42	2170.48	2167.06	2170.21	20493.0
2015-01-02 09:00:00	ES	Futures	2170.21	2175.21	2168.37	2171.0	138001.0
2015-01-02 10:00:00	ES	Futures	2170.74	2171.53	2153.11	2157.58	291598.0
2015-01-02 11:00:00	ES	Futures	2157.58	2158.37	2149.16	2154.69	196218.0
2015-01-02 12:00:00	ES	Futures	2154.42	2159.16	2152.06	2152.85	126157.0
2015-01-02 13:00:00	ES	Futures	2152.85	2154.69	2146.0	2150.48	97786.0
2015-01-02 14:00:00	ES	Futures	2150.48	2158.11	2150.21	2155.48	106465.0
2015-01-02 15:00:00	ES	Futures	2155.48	2163.9	2150.74	2158.63	189439.0
2015-01-02 16:00:00	ES	Futures	2158.37	2158.9	2152.85	2154.95	86424.0
2015-01-02 17:00:00	ES	Futures	2155.21	2155.21	2153.9	2153.9	1026.0
2015-01-02 00:00:00	NQ	Futures	4999.16	5001.81	4997.11	4997.7	299.0
2015-01-02 01:00:00	NQ	Futures	4997.7	5001.51	4995.64	5001.22	206.0
2015-01-02 02:00:00	NQ	Futures	5001.51	5007.39	4997.7	5002.39	2228.0
2015-01-02 03:00:00	NQ	Futures	5002.98	5004.45	4990.35	4991.23	2335.0
2015-01-02 04:00:00	NQ	Futures	4991.23	4996.81	4988.88	4991.82	2872.0
2015-01-02 05:00:00	NQ	Futures	4992.41	4997.7	4988.0	4994.17	1152.0
2015-01-02 06:00:00	NQ	Futures	4994.46	4996.52	4987.42	4988.3	1199.0
2015-01-02 07:00:00	NQ	Futures	4988.59	4997.4	4988.59	4995.35	1231.0
2015-01-02 08:00:00	NQ	Futures	4995.64	4998.87	4988.59	4997.99	2971.0
2015-01-02 09:00:00	NQ	Futures	4998.28	5019.43	4995.35	5002.1	31149.0
2015-01-02 10:00:00	NQ	Futures	5002.69	5004.45	4946.3	4959.81	49783.0
2015-01-02 11:00:00	NQ	Futures	4959.81	4961.28	4935.14	4954.23	36051.0
2015-01-02 12:00:00	NQ	Futures	4953.94	4963.92	4946.3	4949.24	21815.0
2015-01-02 13:00:00	NQ	Futures	4949.24	4953.05	4935.43	4948.65	15538.0
2015-01-02 14:00:00	NQ	Futures	4948.36	4963.63	4946.89	4956.29	13443.0
2015-01-02 15:00:00	NQ	Futures	4955.99	4973.61	4946.01	4960.4	29830.0
2015-01-02 16:00:00	NQ	Futures	4960.1	4960.1	4947.18	4953.94	14516.0
2015-01-02 17:00:00	NQ	Futures	4953.94	4953.94	4951.0	4951.0	62.0
2015-01-02 00:00:00	YM	Futures	18635.3	18642.6	18625.9	18628.0	210.0
2015-01-02 01:00:00	YM	Futures	18626.9	18641.6	18621.7	18641.6	316.0
2015-01-02 02:00:00	YM	Futures	18642.6	18668.7	18637.4	18660.4	1767.0
2015-01-02 03:00:00	YM	Futures	18659.3	18663.5	18607.1	18607.1	2522.0
2015-01-02 04:00:00	YM	Futures	18608.2	18613.4	18586.2	18602.9	2444.0
2015-01-02 05:00:00	YM	Futures	18604.0	18621.7	18587.3	18609.2	1464.0
2015-01-02 06:00:00	YM	Futures	18610.2	18619.6	18590.4	18593.5	1126.0
2015-01-02 07:00:00	YM	Futures	18594.6	18616.5	18594.6	18610.2	1035.0
2015-01-02 08:00:00	YM	Futures	18611.3	18613.4	18592.5	18613.4	1739.0
2015-01-02 09:00:00	YM	Futures	18613.4	18663.5	18595.6	18652.0	13172.0
2015-01-02 10:00:00	YM	Futures	18652.0	18659.3	18519.4	18539.3	26432.0
2015-01-02 11:00:00	YM	Futures	18540.3	18544.5	18471.4	18496.5	17847.0
2015-01-02 12:00:00	YM	Futures	18496.5	18527.8	18481.8	18487.1	11031.0
2015-01-02 13:00:00	YM	Futures	18487.1	18498.5	18429.7	18468.3	8970.0

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

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