PREVIEW / futures_1hour / 2018-07-27

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-07-27.parquet
  size:    45 KB
  rows:    1,365

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-07-27 00:00:00	ES	Futures	3099.58	3100.39	3098.76	3099.3	2329.0
2018-07-27 01:00:00	ES	Futures	3099.3	3099.85	3098.21	3099.58	3122.0
2018-07-27 02:00:00	ES	Futures	3099.58	3101.76	3098.76	3099.3	6651.0
2018-07-27 03:00:00	ES	Futures	3099.58	3101.48	3099.03	3099.03	7190.0
2018-07-27 04:00:00	ES	Futures	3099.03	3100.12	3098.21	3098.49	7476.0
2018-07-27 05:00:00	ES	Futures	3098.21	3102.85	3098.21	3100.12	12828.0
2018-07-27 06:00:00	ES	Futures	3100.39	3101.21	3098.21	3100.12	8655.0
2018-07-27 07:00:00	ES	Futures	3100.12	3100.12	3098.49	3098.49	9368.0
2018-07-27 08:00:00	ES	Futures	3098.49	3100.12	3094.13	3099.58	39744.0
2018-07-27 09:00:00	ES	Futures	3099.3	3099.85	3090.31	3090.59	134466.0
2018-07-27 10:00:00	ES	Futures	3090.59	3093.31	3084.86	3088.13	167920.0
2018-07-27 11:00:00	ES	Futures	3088.13	3088.68	3084.32	3084.86	109448.0
2018-07-27 12:00:00	ES	Futures	3084.86	3084.86	3065.25	3066.06	234606.0
2018-07-27 13:00:00	ES	Futures	3066.06	3073.42	3061.16	3073.15	237015.0
2018-07-27 14:00:00	ES	Futures	3073.42	3074.51	3064.97	3066.06	138383.0
2018-07-27 15:00:00	ES	Futures	3066.06	3074.78	3066.06	3073.42	242325.0
2018-07-27 16:00:00	ES	Futures	3073.42	3073.96	3069.33	3070.42	72086.0
2018-07-27 00:00:00	NQ	Futures	8767.18	8771.89	8766.89	8770.13	1720.0
2018-07-27 01:00:00	NQ	Futures	8770.13	8770.42	8764.53	8767.18	1156.0
2018-07-27 02:00:00	NQ	Futures	8767.18	8771.01	8765.12	8766.59	2298.0
2018-07-27 03:00:00	NQ	Futures	8766.59	8773.37	8765.71	8766.59	2394.0
2018-07-27 04:00:00	NQ	Futures	8766.59	8772.78	8766.59	8768.95	2274.0
2018-07-27 05:00:00	NQ	Futures	8768.95	8793.68	8768.66	8781.02	5169.0
2018-07-27 06:00:00	NQ	Futures	8781.32	8781.32	8762.47	8772.19	4819.0
2018-07-27 07:00:00	NQ	Futures	8772.19	8772.19	8758.06	8759.23	3897.0
2018-07-27 08:00:00	NQ	Futures	8758.94	8782.49	8751.87	8778.37	15271.0
2018-07-27 09:00:00	NQ	Futures	8778.37	8782.2	8717.72	8718.6	61382.0
2018-07-27 10:00:00	NQ	Futures	8718.9	8730.97	8676.8	8691.81	78454.0
2018-07-27 11:00:00	NQ	Futures	8691.81	8699.47	8672.38	8673.85	50950.0
2018-07-27 12:00:00	NQ	Futures	8673.56	8674.74	8576.11	8577.58	85357.0
2018-07-27 13:00:00	NQ	Futures	8577.58	8620.56	8554.02	8617.91	77646.0
2018-07-27 14:00:00	NQ	Futures	8618.21	8623.51	8574.93	8581.11	52981.0
2018-07-27 15:00:00	NQ	Futures	8580.82	8616.74	8580.82	8605.25	63034.0
2018-07-27 16:00:00	NQ	Futures	8604.96	8605.25	8595.24	8596.72	8860.0
2018-07-27 00:00:00	YM	Futures	27776.4	27779.7	27767.7	27768.8	652.0
2018-07-27 01:00:00	YM	Futures	27769.9	27774.2	27743.8	27765.5	1829.0
2018-07-27 02:00:00	YM	Futures	27766.6	27800.3	27765.5	27773.1	3235.0
2018-07-27 03:00:00	YM	Futures	27771.0	27796.0	27768.8	27774.2	2474.0
2018-07-27 04:00:00	YM	Futures	27775.3	27788.4	27757.9	27760.1	2083.0
2018-07-27 05:00:00	YM	Futures	27760.1	27787.3	27746.0	27766.6	2294.0
2018-07-27 06:00:00	YM	Futures	27766.6	27785.1	27754.7	27778.6	2330.0
2018-07-27 07:00:00	YM	Futures	27777.5	27782.9	27763.4	27765.5	1765.0
2018-07-27 08:00:00	YM	Futures	27766.6	27769.9	27703.6	27761.2	8684.0
2018-07-27 09:00:00	YM	Futures	27761.2	27787.3	27727.5	27736.2	20579.0
2018-07-27 10:00:00	YM	Futures	27735.1	27771.0	27724.2	27744.9	22534.0
2018-07-27 11:00:00	YM	Futures	27744.9	27768.8	27723.1	27736.2	16646.0
2018-07-27 12:00:00	YM	Futures	27736.2	27737.3	27587.2	27594.9	32654.0
2018-07-27 13:00:00	YM	Futures	27594.9	27648.1	27556.8	27646.0	26170.0
2018-07-27 14:00:00	YM	Futures	27644.9	27660.1	27586.2	27605.7	17587.0
2018-07-27 15:00:00	YM	Futures	27605.7	27660.1	27605.7	27646.0	21740.0

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

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