PREVIEW / futures_1hour / 2016-03-04

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-03-04.parquet
  size:    46 KB
  rows:    1,336

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
2016-03-04 00:00:00	ES	Futures	2140.54	2141.34	2138.66	2139.19	5821.0
2016-03-04 01:00:00	ES	Futures	2138.92	2139.73	2138.39	2139.46	3160.0
2016-03-04 02:00:00	ES	Futures	2139.46	2141.07	2138.66	2139.19	8229.0
2016-03-04 03:00:00	ES	Futures	2139.19	2140.54	2135.7	2137.58	23999.0
2016-03-04 04:00:00	ES	Futures	2137.85	2140.0	2135.7	2138.92	23130.0
2016-03-04 05:00:00	ES	Futures	2138.66	2141.07	2138.39	2140.54	11700.0
2016-03-04 06:00:00	ES	Futures	2140.8	2143.76	2140.8	2143.22	21944.0
2016-03-04 07:00:00	ES	Futures	2143.49	2145.1	2141.34	2144.03	24906.0
2016-03-04 08:00:00	ES	Futures	2143.76	2152.09	2139.46	2139.73	160438.0
2016-03-04 09:00:00	ES	Futures	2139.73	2144.57	2132.47	2135.16	332037.0
2016-03-04 10:00:00	ES	Futures	2135.16	2147.25	2132.74	2145.37	341560.0
2016-03-04 11:00:00	ES	Futures	2145.1	2153.7	2145.1	2151.02	288320.0
2016-03-04 12:00:00	ES	Futures	2151.02	2153.17	2147.79	2151.28	161671.0
2016-03-04 13:00:00	ES	Futures	2151.28	2157.73	2148.87	2156.39	158724.0
2016-03-04 14:00:00	ES	Futures	2156.39	2156.66	2140.54	2143.49	223750.0
2016-03-04 15:00:00	ES	Futures	2143.49	2150.21	2139.73	2146.99	292549.0
2016-03-04 16:00:00	ES	Futures	2146.99	2148.06	2142.15	2144.03	73250.0
2016-03-04 00:00:00	NQ	Futures	5136.32	5137.51	5129.49	5131.27	736.0
2016-03-04 01:00:00	NQ	Futures	5131.57	5135.43	5128.6	5135.13	677.0
2016-03-04 02:00:00	NQ	Futures	5135.43	5140.48	5133.05	5136.02	1613.0
2016-03-04 03:00:00	NQ	Futures	5136.02	5139.58	5125.63	5130.38	2693.0
2016-03-04 04:00:00	NQ	Futures	5130.38	5133.65	5123.55	5130.38	2580.0
2016-03-04 05:00:00	NQ	Futures	5129.49	5136.91	5128.6	5136.02	995.0
2016-03-04 06:00:00	NQ	Futures	5136.02	5148.2	5136.02	5148.2	3270.0
2016-03-04 07:00:00	NQ	Futures	5147.3	5153.54	5143.15	5151.16	2641.0
2016-03-04 08:00:00	NQ	Futures	5151.16	5169.87	5133.65	5134.83	22127.0
2016-03-04 09:00:00	NQ	Futures	5134.83	5146.71	5104.84	5114.64	57300.0
2016-03-04 10:00:00	NQ	Futures	5114.05	5141.07	5105.44	5136.32	46167.0
2016-03-04 11:00:00	NQ	Futures	5136.32	5159.18	5136.02	5148.79	34381.0
2016-03-04 12:00:00	NQ	Futures	5149.09	5157.4	5141.66	5155.62	18673.0
2016-03-04 13:00:00	NQ	Futures	5155.32	5172.54	5147.6	5168.98	21721.0
2016-03-04 14:00:00	NQ	Futures	5168.98	5170.17	5125.03	5130.38	26559.0
2016-03-04 15:00:00	NQ	Futures	5130.68	5147.01	5122.36	5138.99	34500.0
2016-03-04 16:00:00	NQ	Futures	5138.69	5140.48	5127.41	5131.27	7347.0
2016-03-04 00:00:00	YM	Futures	18023.7	18029.1	18002.5	18008.8	1214.0
2016-03-04 01:00:00	YM	Futures	18009.9	18016.3	18004.6	18014.2	464.0
2016-03-04 02:00:00	YM	Futures	18013.1	18024.8	18007.8	18014.2	829.0
2016-03-04 03:00:00	YM	Futures	18014.2	18022.7	17980.1	17995.0	3427.0
2016-03-04 04:00:00	YM	Futures	17996.1	18014.2	17983.3	18002.5	2784.0
2016-03-04 05:00:00	YM	Futures	18002.5	18023.7	17999.3	18020.6	1412.0
2016-03-04 06:00:00	YM	Futures	18019.5	18049.3	18019.5	18046.1	2663.0
2016-03-04 07:00:00	YM	Futures	18046.1	18058.9	18032.3	18052.5	2560.0
2016-03-04 08:00:00	YM	Futures	18052.5	18105.7	18016.3	18018.4	18393.0
2016-03-04 09:00:00	YM	Futures	18019.5	18055.7	17968.4	17987.6	30051.0
2016-03-04 10:00:00	YM	Futures	17987.6	18074.8	17966.3	18063.1	26735.0
2016-03-04 11:00:00	YM	Futures	18063.1	18117.4	18061.0	18095.1	18858.0
2016-03-04 12:00:00	YM	Futures	18095.1	18116.4	18074.8	18100.4	9087.0
2016-03-04 13:00:00	YM	Futures	18100.4	18141.9	18080.2	18137.6	10833.0
2016-03-04 14:00:00	YM	Futures	18137.6	18139.8	18025.9	18046.1	14104.0
2016-03-04 15:00:00	YM	Futures	18045.0	18096.1	18016.3	18080.2	15252.0

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

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