PREVIEW / futures_1hour / 2015-01-26

all futures 1-hour files

  file:    by_date/futures_1hour/2015/2015-01-26.parquet
  size:    52 KB
  rows:    1,560

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-26 00:00:00	ES	Futures	2140.21	2140.74	2138.37	2140.74	2663.0
2015-01-26 01:00:00	ES	Futures	2140.74	2142.85	2138.64	2141.79	3894.0
2015-01-26 02:00:00	ES	Futures	2141.79	2145.74	2141.27	2145.21	10504.0
2015-01-26 03:00:00	ES	Futures	2145.21	2147.06	2142.32	2143.9	28593.0
2015-01-26 04:00:00	ES	Futures	2144.16	2149.42	2142.58	2146.0	23176.0
2015-01-26 05:00:00	ES	Futures	2146.0	2148.63	2143.9	2145.48	12489.0
2015-01-26 06:00:00	ES	Futures	2145.21	2146.0	2142.85	2144.95	11263.0
2015-01-26 07:00:00	ES	Futures	2144.95	2150.74	2144.69	2149.95	17929.0
2015-01-26 08:00:00	ES	Futures	2149.95	2154.42	2147.85	2153.37	35602.0
2015-01-26 09:00:00	ES	Futures	2153.37	2153.63	2141.53	2146.53	219553.0
2015-01-26 10:00:00	ES	Futures	2146.53	2155.48	2145.48	2153.9	189838.0
2015-01-26 11:00:00	ES	Futures	2153.9	2155.74	2149.69	2154.95	153877.0
2015-01-26 12:00:00	ES	Futures	2154.95	2157.06	2151.79	2153.37	96201.0
2015-01-26 13:00:00	ES	Futures	2153.63	2159.69	2151.79	2158.37	94202.0
2015-01-26 14:00:00	ES	Futures	2158.11	2159.16	2153.9	2155.21	84559.0
2015-01-26 15:00:00	ES	Futures	2155.21	2159.69	2152.85	2158.37	142844.0
2015-01-26 16:00:00	ES	Futures	2158.37	2163.11	2157.85	2162.32	72635.0
2015-01-26 17:00:00	ES	Futures	2162.58	2162.85	2162.32	2162.58	1019.0
2015-01-26 18:00:00	ES	Futures	2162.06	2162.58	2161.53	2161.53	3608.0
2015-01-26 19:00:00	ES	Futures	2161.53	2162.06	2161.27	2162.06	3351.0
2015-01-26 20:00:00	ES	Futures	2161.79	2162.06	2161.27	2161.53	2026.0
2015-01-26 21:00:00	ES	Futures	2161.27	2161.53	2160.74	2161.0	2803.0
2015-01-26 22:00:00	ES	Futures	2161.27	2161.53	2160.48	2160.48	2591.0
2015-01-26 23:00:00	ES	Futures	2160.48	2161.53	2159.95	2161.0	2249.0
2015-01-26 00:00:00	NQ	Futures	4990.35	4992.41	4987.12	4992.41	587.0
2015-01-26 01:00:00	NQ	Futures	4991.53	4998.58	4987.42	4996.23	528.0
2015-01-26 02:00:00	NQ	Futures	4995.93	5004.45	4995.05	5003.57	1399.0
2015-01-26 03:00:00	NQ	Futures	5003.57	5007.68	4995.64	4999.75	4938.0
2015-01-26 04:00:00	NQ	Futures	5000.04	5012.38	4996.52	5004.74	3500.0
2015-01-26 05:00:00	NQ	Futures	5003.86	5010.91	4999.75	5003.86	1579.0
2015-01-26 06:00:00	NQ	Futures	5003.57	5006.21	5000.04	5005.04	1985.0
2015-01-26 07:00:00	NQ	Futures	5005.04	5018.55	5005.04	5016.2	3024.0
2015-01-26 08:00:00	NQ	Futures	5016.2	5025.89	5011.21	5022.37	6237.0
2015-01-26 09:00:00	NQ	Futures	5022.37	5022.66	4988.0	4999.16	37524.0
2015-01-26 10:00:00	NQ	Futures	4999.75	5013.55	4992.7	5012.09	33005.0
2015-01-26 11:00:00	NQ	Futures	5012.09	5016.79	4996.52	5007.09	19638.0
2015-01-26 12:00:00	NQ	Futures	5007.39	5013.55	5003.28	5007.97	11892.0
2015-01-26 13:00:00	NQ	Futures	5007.39	5023.25	5003.57	5018.25	14551.0
2015-01-26 14:00:00	NQ	Futures	5018.25	5020.02	5003.57	5007.39	11638.0
2015-01-26 15:00:00	NQ	Futures	5007.68	5017.08	5003.86	5014.44	19041.0
2015-01-26 16:00:00	NQ	Futures	5014.44	5021.48	5012.97	5014.73	7230.0
2015-01-26 17:00:00	NQ	Futures	5014.73	5018.84	5014.44	5018.25	476.0
2015-01-26 18:00:00	NQ	Futures	5012.38	5013.55	5010.32	5011.5	422.0
2015-01-26 19:00:00	NQ	Futures	5011.21	5012.97	5010.32	5012.09	559.0
2015-01-26 20:00:00	NQ	Futures	5011.79	5012.09	5010.62	5011.79	274.0
2015-01-26 21:00:00	NQ	Futures	5011.5	5012.09	5010.32	5011.79	328.0
2015-01-26 22:00:00	NQ	Futures	5011.79	5013.55	5011.21	5011.5	426.0
2015-01-26 23:00:00	NQ	Futures	5011.5	5014.44	5010.32	5012.97	361.0
2015-01-26 00:00:00	YM	Futures	18243.8	18250.1	18231.3	18248.0	870.0
2015-01-26 01:00:00	YM	Futures	18245.9	18266.8	18232.4	18257.4	598.0

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

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