PREVIEW / futures_1hour / 2018-04-27

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-04-27.parquet
  size:    47 KB
  rows:    1,398

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-04-27 00:00:00	ES	Futures	2913.57	2914.66	2912.75	2913.29	2206.0
2018-04-27 01:00:00	ES	Futures	2913.29	2914.66	2911.93	2914.39	3224.0
2018-04-27 02:00:00	ES	Futures	2914.11	2916.84	2914.11	2916.02	6012.0
2018-04-27 03:00:00	ES	Futures	2916.3	2916.3	2911.93	2913.29	11246.0
2018-04-27 04:00:00	ES	Futures	2913.29	2914.66	2910.84	2911.66	10362.0
2018-04-27 05:00:00	ES	Futures	2911.38	2914.11	2909.47	2913.57	11275.0
2018-04-27 06:00:00	ES	Futures	2913.84	2916.84	2913.02	2913.57	10675.0
2018-04-27 07:00:00	ES	Futures	2913.84	2916.57	2912.75	2916.3	10835.0
2018-04-27 08:00:00	ES	Futures	2916.02	2919.57	2914.66	2919.57	30844.0
2018-04-27 09:00:00	ES	Futures	2919.57	2921.48	2910.84	2911.93	192254.0
2018-04-27 10:00:00	ES	Futures	2911.66	2917.93	2901.29	2905.38	252136.0
2018-04-27 11:00:00	ES	Futures	2905.38	2914.66	2904.56	2908.93	128732.0
2018-04-27 12:00:00	ES	Futures	2908.93	2918.75	2907.56	2917.39	92243.0
2018-04-27 13:00:00	ES	Futures	2917.11	2919.02	2911.66	2913.02	56114.0
2018-04-27 14:00:00	ES	Futures	2913.02	2916.02	2910.84	2914.93	58477.0
2018-04-27 15:00:00	ES	Futures	2914.66	2918.21	2910.29	2913.57	157955.0
2018-04-27 16:00:00	ES	Futures	2913.29	2917.39	2913.02	2916.3	53923.0
2018-04-27 00:00:00	NQ	Futures	7966.36	7972.87	7965.48	7969.02	935.0
2018-04-27 01:00:00	NQ	Futures	7969.32	7979.96	7965.77	7978.19	1466.0
2018-04-27 02:00:00	NQ	Futures	7978.48	7985.28	7977.59	7983.51	2537.0
2018-04-27 03:00:00	NQ	Futures	7983.51	7983.51	7967.84	7972.57	3574.0
2018-04-27 04:00:00	NQ	Futures	7972.28	7977.3	7965.18	7968.73	2882.0
2018-04-27 05:00:00	NQ	Futures	7969.32	7973.75	7958.98	7972.28	3097.0
2018-04-27 06:00:00	NQ	Futures	7971.98	7983.8	7969.02	7973.75	3519.0
2018-04-27 07:00:00	NQ	Futures	7974.05	7986.17	7968.14	7984.39	4884.0
2018-04-27 08:00:00	NQ	Futures	7984.69	8004.78	7984.39	8003.31	11003.0
2018-04-27 09:00:00	NQ	Futures	8003.31	8005.37	7888.93	7897.21	99594.0
2018-04-27 10:00:00	NQ	Futures	7896.91	7924.69	7829.24	7848.15	113114.0
2018-04-27 11:00:00	NQ	Futures	7848.15	7897.21	7844.61	7867.07	67137.0
2018-04-27 12:00:00	NQ	Futures	7867.07	7889.82	7844.01	7882.14	43445.0
2018-04-27 13:00:00	NQ	Futures	7882.43	7894.25	7860.86	7864.7	26903.0
2018-04-27 14:00:00	NQ	Futures	7865.0	7889.82	7856.43	7872.98	25558.0
2018-04-27 15:00:00	NQ	Futures	7872.98	7888.93	7857.31	7875.04	40950.0
2018-04-27 16:00:00	NQ	Futures	7875.04	7889.53	7874.16	7887.16	9826.0
2018-04-27 00:00:00	YM	Futures	26348.0	26363.2	26344.8	26350.2	973.0
2018-04-27 01:00:00	YM	Futures	26350.2	26358.9	26340.4	26353.4	1459.0
2018-04-27 02:00:00	YM	Futures	26353.4	26380.6	26353.4	26376.2	2072.0
2018-04-27 03:00:00	YM	Futures	26376.2	26376.2	26333.9	26343.7	2645.0
2018-04-27 04:00:00	YM	Futures	26343.7	26353.4	26307.8	26316.5	2565.0
2018-04-27 05:00:00	YM	Futures	26316.5	26326.3	26276.3	26319.8	3546.0
2018-04-27 06:00:00	YM	Futures	26319.8	26344.8	26311.1	26311.1	2339.0
2018-04-27 07:00:00	YM	Futures	26312.2	26329.5	26285.0	26326.3	3283.0
2018-04-27 08:00:00	YM	Futures	26325.2	26371.9	26311.1	26367.6	4642.0
2018-04-27 09:00:00	YM	Futures	26368.6	26407.7	26328.5	26343.7	32189.0
2018-04-27 10:00:00	YM	Futures	26345.8	26378.4	26224.2	26262.2	34069.0
2018-04-27 11:00:00	YM	Futures	26260.0	26364.3	26255.7	26292.6	21053.0
2018-04-27 12:00:00	YM	Futures	26293.7	26390.4	26292.6	26375.2	15793.0
2018-04-27 13:00:00	YM	Futures	26376.2	26405.6	26343.7	26356.7	10077.0
2018-04-27 14:00:00	YM	Futures	26356.7	26376.2	26338.2	26375.2	7915.0
2018-04-27 15:00:00	YM	Futures	26374.1	26405.6	26326.3	26355.6	16283.0

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

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