PREVIEW / futures_1hour / 2018-09-07

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-09-07.parquet
  size:    46 KB
  rows:    1,372

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-09-07 00:00:00	ES	Futures	3133.91	3134.18	3132.55	3133.63	3836.0
2018-09-07 01:00:00	ES	Futures	3133.63	3136.09	3133.63	3135.54	7973.0
2018-09-07 02:00:00	ES	Futures	3135.27	3140.45	3134.72	3137.72	13054.0
2018-09-07 03:00:00	ES	Futures	3137.45	3139.36	3135.81	3136.63	14104.0
2018-09-07 04:00:00	ES	Futures	3136.36	3136.36	3132.82	3133.36	11306.0
2018-09-07 05:00:00	ES	Futures	3133.36	3137.18	3130.64	3131.73	14469.0
2018-09-07 06:00:00	ES	Futures	3131.46	3134.72	3130.37	3133.63	15462.0
2018-09-07 07:00:00	ES	Futures	3133.63	3135.0	3132.0	3132.27	11355.0
2018-09-07 08:00:00	ES	Futures	3132.55	3134.18	3125.19	3125.73	80917.0
2018-09-07 09:00:00	ES	Futures	3126.01	3136.36	3122.46	3134.18	264886.0
2018-09-07 10:00:00	ES	Futures	3133.91	3141.54	3132.55	3139.9	187192.0
2018-09-07 11:00:00	ES	Futures	3140.17	3144.26	3137.72	3137.99	134475.0
2018-09-07 12:00:00	ES	Futures	3138.27	3138.81	3124.64	3131.73	290544.0
2018-09-07 13:00:00	ES	Futures	3131.73	3132.27	3126.55	3127.1	89739.0
2018-09-07 14:00:00	ES	Futures	3127.1	3136.09	3127.1	3135.54	100825.0
2018-09-07 15:00:00	ES	Futures	3135.54	3136.09	3128.19	3132.0	264814.0
2018-09-07 16:00:00	ES	Futures	3132.0	3133.63	3129.55	3130.91	66312.0
2018-09-07 00:00:00	NQ	Futures	8758.65	8763.95	8754.23	8763.36	2621.0
2018-09-07 01:00:00	NQ	Futures	8763.36	8771.89	8760.12	8769.24	3329.0
2018-09-07 02:00:00	NQ	Futures	8769.54	8788.09	8767.48	8782.2	5396.0
2018-09-07 03:00:00	NQ	Futures	8781.9	8785.73	8774.54	8776.9	4575.0
2018-09-07 04:00:00	NQ	Futures	8776.61	8776.61	8764.83	8766.89	4787.0
2018-09-07 05:00:00	NQ	Futures	8766.59	8778.96	8755.11	8760.12	5338.0
2018-09-07 06:00:00	NQ	Futures	8760.41	8771.31	8756.0	8766.89	4880.0
2018-09-07 07:00:00	NQ	Futures	8767.18	8771.6	8762.47	8763.06	3428.0
2018-09-07 08:00:00	NQ	Futures	8763.06	8769.54	8722.14	8722.14	24811.0
2018-09-07 09:00:00	NQ	Futures	8722.14	8811.64	8706.53	8801.04	111582.0
2018-09-07 10:00:00	NQ	Futures	8801.34	8819.3	8790.44	8816.06	86059.0
2018-09-07 11:00:00	NQ	Futures	8816.35	8826.36	8795.74	8796.63	62511.0
2018-09-07 12:00:00	NQ	Futures	8796.63	8800.45	8748.34	8789.85	107822.0
2018-09-07 13:00:00	NQ	Futures	8789.85	8790.44	8756.88	8760.71	39156.0
2018-09-07 14:00:00	NQ	Futures	8760.71	8787.5	8759.82	8785.44	33687.0
2018-09-07 15:00:00	NQ	Futures	8785.14	8787.5	8742.75	8758.06	58275.0
2018-09-07 16:00:00	NQ	Futures	8757.76	8761.59	8746.87	8754.82	10986.0
2018-09-07 00:00:00	YM	Futures	28249.3	28254.8	28240.6	28247.1	1062.0
2018-09-07 01:00:00	YM	Futures	28248.2	28267.8	28247.1	28258.0	1787.0
2018-09-07 02:00:00	YM	Futures	28258.0	28306.9	28250.4	28281.9	3368.0
2018-09-07 03:00:00	YM	Futures	28281.9	28290.6	28262.4	28268.9	3445.0
2018-09-07 04:00:00	YM	Futures	28267.8	28267.8	28234.1	28237.4	2795.0
2018-09-07 05:00:00	YM	Futures	28236.3	28274.3	28218.9	28231.9	3565.0
2018-09-07 06:00:00	YM	Futures	28231.9	28258.0	28223.2	28249.3	3941.0
2018-09-07 07:00:00	YM	Futures	28249.3	28261.3	28233.0	28234.1	2387.0
2018-09-07 08:00:00	YM	Futures	28235.2	28249.3	28174.3	28181.9	11232.0
2018-09-07 09:00:00	YM	Futures	28181.9	28225.4	28158.0	28205.8	30233.0
2018-09-07 10:00:00	YM	Futures	28205.8	28271.1	28199.3	28261.3	21924.0
2018-09-07 11:00:00	YM	Futures	28261.3	28290.6	28234.1	28247.1	16184.0
2018-09-07 12:00:00	YM	Futures	28247.1	28251.5	28084.1	28144.9	34638.0
2018-09-07 13:00:00	YM	Futures	28146.0	28153.6	28109.1	28127.6	10870.0
2018-09-07 14:00:00	YM	Futures	28127.6	28246.1	28125.4	28238.4	18181.0
2018-09-07 15:00:00	YM	Futures	28238.4	28239.5	28174.3	28206.9	22501.0

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

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