PREVIEW / futures_1hour / 2018-08-28

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-08-28.parquet
  size:    53 KB
  rows:    1,664

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-08-28 00:00:00	ES	Futures	3161.7	3161.97	3159.79	3159.79	2593.0
2018-08-28 01:00:00	ES	Futures	3160.06	3160.06	3158.7	3159.25	5379.0
2018-08-28 02:00:00	ES	Futures	3158.97	3160.61	3157.88	3160.34	6407.0
2018-08-28 03:00:00	ES	Futures	3160.34	3160.88	3158.97	3159.52	9825.0
2018-08-28 04:00:00	ES	Futures	3159.52	3160.06	3157.88	3158.43	9568.0
2018-08-28 05:00:00	ES	Futures	3158.43	3162.79	3158.16	3162.52	11672.0
2018-08-28 06:00:00	ES	Futures	3162.52	3162.52	3160.88	3161.97	6218.0
2018-08-28 07:00:00	ES	Futures	3161.7	3163.33	3161.15	3163.06	10610.0
2018-08-28 08:00:00	ES	Futures	3163.06	3164.15	3162.52	3163.88	14502.0
2018-08-28 09:00:00	ES	Futures	3163.88	3167.42	3161.15	3163.06	170264.0
2018-08-28 10:00:00	ES	Futures	3163.06	3164.15	3157.07	3160.88	115224.0
2018-08-28 11:00:00	ES	Futures	3160.61	3162.24	3154.61	3154.89	115602.0
2018-08-28 12:00:00	ES	Futures	3154.89	3159.25	3154.34	3158.97	60254.0
2018-08-28 13:00:00	ES	Futures	3158.97	3161.7	3156.25	3160.06	70124.0
2018-08-28 14:00:00	ES	Futures	3160.06	3160.88	3158.43	3160.34	52417.0
2018-08-28 15:00:00	ES	Futures	3160.34	3161.43	3155.43	3159.79	146590.0
2018-08-28 16:00:00	ES	Futures	3159.79	3161.43	3159.25	3160.34	44992.0
2018-08-28 18:00:00	ES	Futures	3161.15	3162.79	3160.61	3162.52	4728.0
2018-08-28 19:00:00	ES	Futures	3162.52	3162.52	3161.7	3162.24	1379.0
2018-08-28 20:00:00	ES	Futures	3162.24	3164.42	3162.24	3163.61	6570.0
2018-08-28 21:00:00	ES	Futures	3163.61	3164.15	3162.52	3163.88	4021.0
2018-08-28 22:00:00	ES	Futures	3163.88	3166.06	3163.88	3164.97	5090.0
2018-08-28 23:00:00	ES	Futures	3165.24	3165.79	3164.42	3165.51	1810.0
2018-08-28 00:00:00	NQ	Futures	8927.64	8928.23	8920.58	8920.58	1021.0
2018-08-28 01:00:00	NQ	Futures	8920.87	8922.34	8914.98	8919.4	2335.0
2018-08-28 02:00:00	NQ	Futures	8919.4	8930.0	8915.86	8928.23	2698.0
2018-08-28 03:00:00	NQ	Futures	8927.94	8929.41	8922.05	8922.93	3020.0
2018-08-28 04:00:00	NQ	Futures	8923.23	8927.64	8919.99	8922.05	3498.0
2018-08-28 05:00:00	NQ	Futures	8921.75	8932.06	8921.16	8930.29	2848.0
2018-08-28 06:00:00	NQ	Futures	8930.88	8931.47	8926.46	8928.82	2557.0
2018-08-28 07:00:00	NQ	Futures	8928.52	8935.0	8926.17	8934.12	3251.0
2018-08-28 08:00:00	NQ	Futures	8934.12	8941.77	8932.65	8933.24	6416.0
2018-08-28 09:00:00	NQ	Futures	8933.53	8947.07	8920.87	8935.3	54203.0
2018-08-28 10:00:00	NQ	Futures	8935.3	8940.01	8913.8	8925.29	47102.0
2018-08-28 11:00:00	NQ	Futures	8924.99	8934.12	8908.5	8911.45	37630.0
2018-08-28 12:00:00	NQ	Futures	8911.45	8932.06	8908.21	8928.82	23956.0
2018-08-28 13:00:00	NQ	Futures	8928.82	8936.77	8920.58	8932.06	16698.0
2018-08-28 14:00:00	NQ	Futures	8932.06	8937.36	8927.35	8931.76	12630.0
2018-08-28 15:00:00	NQ	Futures	8931.76	8933.82	8911.74	8925.88	28885.0
2018-08-28 16:00:00	NQ	Futures	8925.88	8929.11	8923.23	8927.64	7342.0
2018-08-28 18:00:00	NQ	Futures	8927.94	8934.71	8927.94	8933.82	1446.0
2018-08-28 19:00:00	NQ	Futures	8933.82	8935.0	8932.06	8934.71	647.0
2018-08-28 20:00:00	NQ	Futures	8934.41	8942.36	8933.82	8939.12	3197.0
2018-08-28 21:00:00	NQ	Futures	8939.12	8942.95	8936.77	8942.07	1520.0
2018-08-28 22:00:00	NQ	Futures	8942.07	8950.31	8940.3	8946.48	3451.0
2018-08-28 23:00:00	NQ	Futures	8946.78	8948.84	8944.72	8946.78	860.0
2018-08-28 00:00:00	YM	Futures	28381.9	28386.3	28364.6	28364.6	810.0
2018-08-28 01:00:00	YM	Futures	28365.6	28372.2	28347.2	28355.9	1811.0
2018-08-28 02:00:00	YM	Futures	28356.9	28363.5	28334.1	28361.3	1787.0
2018-08-28 03:00:00	YM	Futures	28361.3	28366.7	28342.8	28347.2	2901.0

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

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