PREVIEW / futures_1hour / 2016-08-19

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-08-19.parquet
  size:    44 KB
  rows:    1,311

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-08-19 00:00:00	ES	Futures	2368.0	2368.0	2367.46	2367.73	1274.0
2016-08-19 01:00:00	ES	Futures	2368.0	2368.27	2367.46	2368.0	1710.0
2016-08-19 02:00:00	ES	Futures	2368.0	2368.81	2367.73	2368.27	4812.0
2016-08-19 03:00:00	ES	Futures	2368.27	2368.81	2363.12	2363.93	30912.0
2016-08-19 04:00:00	ES	Futures	2363.93	2364.2	2359.59	2360.41	21934.0
2016-08-19 05:00:00	ES	Futures	2360.41	2362.58	2360.41	2362.3	12676.0
2016-08-19 06:00:00	ES	Futures	2362.03	2364.2	2361.49	2361.76	16227.0
2016-08-19 07:00:00	ES	Futures	2361.49	2363.12	2360.41	2360.68	12198.0
2016-08-19 08:00:00	ES	Futures	2360.68	2363.39	2359.86	2362.85	25472.0
2016-08-19 09:00:00	ES	Futures	2362.85	2363.93	2356.61	2357.97	265833.0
2016-08-19 10:00:00	ES	Futures	2357.97	2366.37	2357.69	2363.93	256736.0
2016-08-19 11:00:00	ES	Futures	2363.93	2365.83	2363.12	2365.29	111721.0
2016-08-19 12:00:00	ES	Futures	2365.56	2366.37	2360.14	2361.22	137362.0
2016-08-19 13:00:00	ES	Futures	2361.22	2364.47	2360.68	2363.39	112861.0
2016-08-19 14:00:00	ES	Futures	2363.39	2367.19	2363.12	2366.37	88806.0
2016-08-19 15:00:00	ES	Futures	2366.37	2368.0	2365.29	2366.1	221623.0
2016-08-19 16:00:00	ES	Futures	2366.1	2367.46	2365.56	2367.46	77989.0
2016-08-19 00:00:00	NQ	Futures	5727.95	5728.55	5727.06	5727.95	266.0
2016-08-19 01:00:00	NQ	Futures	5728.25	5729.15	5727.66	5728.55	278.0
2016-08-19 02:00:00	NQ	Futures	5728.85	5732.13	5728.55	5730.04	832.0
2016-08-19 03:00:00	NQ	Futures	5730.34	5731.23	5715.73	5716.63	4282.0
2016-08-19 04:00:00	NQ	Futures	5716.93	5717.23	5708.28	5712.16	3285.0
2016-08-19 05:00:00	NQ	Futures	5712.16	5717.52	5711.86	5715.44	1077.0
2016-08-19 06:00:00	NQ	Futures	5716.03	5720.21	5714.54	5715.44	1821.0
2016-08-19 07:00:00	NQ	Futures	5714.84	5719.31	5712.75	5714.24	1673.0
2016-08-19 08:00:00	NQ	Futures	5714.54	5721.4	5712.46	5720.5	3645.0
2016-08-19 09:00:00	NQ	Futures	5720.5	5723.19	5704.71	5712.16	41017.0
2016-08-19 10:00:00	NQ	Futures	5712.16	5742.56	5708.28	5735.41	40767.0
2016-08-19 11:00:00	NQ	Futures	5735.11	5742.26	5733.02	5738.68	17581.0
2016-08-19 12:00:00	NQ	Futures	5738.68	5741.07	5716.03	5718.42	19975.0
2016-08-19 13:00:00	NQ	Futures	5718.42	5722.59	5713.65	5720.21	15105.0
2016-08-19 14:00:00	NQ	Futures	5720.21	5730.34	5719.91	5728.85	10465.0
2016-08-19 15:00:00	NQ	Futures	5728.85	5733.32	5726.76	5729.15	19055.0
2016-08-19 16:00:00	NQ	Futures	5729.15	5733.32	5728.55	5733.32	5714.0
2016-08-19 00:00:00	YM	Futures	19966.8	19971.1	19965.8	19971.1	232.0
2016-08-19 01:00:00	YM	Futures	19970.1	19973.3	19964.7	19970.1	407.0
2016-08-19 02:00:00	YM	Futures	19971.1	19979.7	19971.1	19977.6	976.0
2016-08-19 03:00:00	YM	Futures	19977.6	19980.8	19931.3	19937.8	3860.0
2016-08-19 04:00:00	YM	Futures	19938.9	19938.9	19909.8	19917.3	3604.0
2016-08-19 05:00:00	YM	Futures	19918.4	19932.4	19916.2	19930.2	1457.0
2016-08-19 06:00:00	YM	Futures	19930.2	19946.4	19921.6	19921.6	1325.0
2016-08-19 07:00:00	YM	Futures	19921.6	19932.4	19913.0	19916.2	1551.0
2016-08-19 08:00:00	YM	Futures	19917.3	19936.7	19911.9	19931.3	2419.0
2016-08-19 09:00:00	YM	Futures	19931.3	19936.7	19876.4	19888.3	22050.0
2016-08-19 10:00:00	YM	Futures	19888.3	19975.4	19882.9	19959.3	23716.0
2016-08-19 11:00:00	YM	Futures	19958.2	19973.3	19946.4	19961.5	8983.0
2016-08-19 12:00:00	YM	Futures	19962.5	19979.7	19917.3	19922.7	12259.0
2016-08-19 13:00:00	YM	Futures	19921.6	19942.1	19915.2	19933.5	8208.0
2016-08-19 14:00:00	YM	Futures	19932.4	19957.1	19931.3	19951.8	4606.0
2016-08-19 15:00:00	YM	Futures	19951.8	19961.5	19941.0	19943.2	9376.0

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

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