PREVIEW / futures_1hour / 2018-01-26

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-01-26.parquet
  size:    48 KB
  rows:    1,393

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-01-26 00:00:00	ES	Futures	3111.57	3111.84	3109.93	3110.47	2958.0
2018-01-26 01:00:00	ES	Futures	3110.47	3111.29	3109.65	3109.93	4822.0
2018-01-26 02:00:00	ES	Futures	3109.93	3112.11	3109.65	3111.84	8846.0
2018-01-26 03:00:00	ES	Futures	3111.57	3112.11	3110.75	3111.57	11165.0
2018-01-26 04:00:00	ES	Futures	3111.57	3113.21	3110.2	3111.84	9536.0
2018-01-26 05:00:00	ES	Futures	3111.84	3116.21	3111.57	3116.21	17223.0
2018-01-26 06:00:00	ES	Futures	3116.21	3118.13	3114.57	3118.13	19685.0
2018-01-26 07:00:00	ES	Futures	3118.13	3118.4	3114.03	3115.94	21926.0
2018-01-26 08:00:00	ES	Futures	3116.21	3117.85	3113.21	3116.76	35358.0
2018-01-26 09:00:00	ES	Futures	3116.49	3118.95	3112.11	3117.58	135411.0
2018-01-26 10:00:00	ES	Futures	3117.58	3123.05	3113.75	3120.04	153549.0
2018-01-26 11:00:00	ES	Futures	3120.04	3122.77	3118.4	3120.04	90600.0
2018-01-26 12:00:00	ES	Futures	3120.31	3126.05	3119.22	3124.69	76821.0
2018-01-26 13:00:00	ES	Futures	3124.96	3129.61	3124.69	3128.51	89539.0
2018-01-26 14:00:00	ES	Futures	3128.79	3130.43	3126.33	3129.61	102842.0
2018-01-26 15:00:00	ES	Futures	3129.88	3141.36	3129.33	3141.09	271496.0
2018-01-26 16:00:00	ES	Futures	3140.81	3144.37	3138.9	3143.0	117280.0
2018-01-26 00:00:00	NQ	Futures	8251.85	8253.03	8245.62	8246.8	1108.0
2018-01-26 01:00:00	NQ	Futures	8246.8	8249.47	8243.54	8245.32	1183.0
2018-01-26 02:00:00	NQ	Futures	8245.91	8250.07	8244.43	8247.4	1500.0
2018-01-26 03:00:00	NQ	Futures	8247.69	8253.62	8244.13	8251.85	2470.0
2018-01-26 04:00:00	NQ	Futures	8251.85	8260.74	8250.36	8255.4	2870.0
2018-01-26 05:00:00	NQ	Futures	8255.4	8269.34	8254.51	8268.45	2619.0
2018-01-26 06:00:00	NQ	Futures	8268.45	8271.42	8259.56	8265.79	4340.0
2018-01-26 07:00:00	NQ	Futures	8265.49	8266.38	8252.74	8260.15	4828.0
2018-01-26 08:00:00	NQ	Futures	8259.85	8269.05	8253.62	8265.19	8499.0
2018-01-26 09:00:00	NQ	Futures	8265.19	8268.45	8244.43	8262.82	54555.0
2018-01-26 10:00:00	NQ	Futures	8262.82	8288.92	8250.07	8282.39	57854.0
2018-01-26 11:00:00	NQ	Futures	8282.39	8288.62	8272.9	8277.06	32963.0
2018-01-26 12:00:00	NQ	Futures	8276.76	8286.25	8270.23	8281.8	19421.0
2018-01-26 13:00:00	NQ	Futures	8282.1	8302.86	8282.1	8300.78	22790.0
2018-01-26 14:00:00	NQ	Futures	8301.08	8309.98	8291.89	8304.34	30157.0
2018-01-26 15:00:00	NQ	Futures	8304.05	8337.56	8301.67	8336.97	49258.0
2018-01-26 16:00:00	NQ	Futures	8336.97	8345.57	8332.22	8342.01	13354.0
2018-01-26 00:00:00	YM	Futures	28717.5	28720.8	28690.4	28693.6	1241.0
2018-01-26 01:00:00	YM	Futures	28694.7	28704.5	28679.5	28686.0	2347.0
2018-01-26 02:00:00	YM	Futures	28687.1	28709.9	28686.0	28706.7	1962.0
2018-01-26 03:00:00	YM	Futures	28705.6	28713.2	28694.7	28703.4	1468.0
2018-01-26 04:00:00	YM	Futures	28702.3	28720.8	28688.2	28708.9	1521.0
2018-01-26 05:00:00	YM	Futures	28706.7	28743.6	28703.4	28739.3	1952.0
2018-01-26 06:00:00	YM	Futures	28739.3	28746.9	28723.0	28745.8	2587.0
2018-01-26 07:00:00	YM	Futures	28745.8	28754.5	28712.1	28727.3	5510.0
2018-01-26 08:00:00	YM	Futures	28728.4	28739.3	28694.7	28717.5	6840.0
2018-01-26 09:00:00	YM	Futures	28717.5	28758.9	28695.8	28748.0	19476.0
2018-01-26 10:00:00	YM	Futures	28748.0	28779.5	28707.8	28737.1	20117.0
2018-01-26 11:00:00	YM	Futures	28738.2	28776.2	28733.9	28750.2	11855.0
2018-01-26 12:00:00	YM	Futures	28750.2	28793.6	28739.3	28783.8	9830.0
2018-01-26 13:00:00	YM	Futures	28784.9	28809.9	28780.6	28803.4	9871.0
2018-01-26 14:00:00	YM	Futures	28804.5	28806.7	28777.3	28799.1	10126.0
2018-01-26 15:00:00	YM	Futures	28800.2	28903.4	28795.8	28901.2	24908.0

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

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