PREVIEW / futures_1hour / 2018-08-14

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-08-14.parquet
  size:    54 KB
  rows:    1,673

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-14 00:00:00	ES	Futures	3085.95	3086.77	3084.86	3084.86	3747.0
2018-08-14 01:00:00	ES	Futures	3084.86	3086.77	3083.77	3085.95	7456.0
2018-08-14 02:00:00	ES	Futures	3085.95	3090.31	3085.41	3089.5	16474.0
2018-08-14 03:00:00	ES	Futures	3089.77	3093.85	3088.95	3093.85	24518.0
2018-08-14 04:00:00	ES	Futures	3093.85	3093.85	3087.32	3087.59	15641.0
2018-08-14 05:00:00	ES	Futures	3087.59	3091.4	3087.32	3088.68	12846.0
2018-08-14 06:00:00	ES	Futures	3088.68	3093.04	3088.41	3090.59	12472.0
2018-08-14 07:00:00	ES	Futures	3090.59	3091.13	3087.86	3089.5	11531.0
2018-08-14 08:00:00	ES	Futures	3089.5	3089.5	3086.5	3087.86	18527.0
2018-08-14 09:00:00	ES	Futures	3087.86	3090.04	3083.77	3086.5	140852.0
2018-08-14 10:00:00	ES	Futures	3086.5	3097.4	3080.78	3094.67	177644.0
2018-08-14 11:00:00	ES	Futures	3094.67	3096.58	3091.4	3093.04	111928.0
2018-08-14 12:00:00	ES	Futures	3092.76	3098.49	3092.76	3093.58	74532.0
2018-08-14 13:00:00	ES	Futures	3093.85	3098.21	3093.31	3097.94	46120.0
2018-08-14 14:00:00	ES	Futures	3097.94	3099.03	3094.4	3097.4	70937.0
2018-08-14 15:00:00	ES	Futures	3097.4	3099.03	3094.67	3096.03	156947.0
2018-08-14 16:00:00	ES	Futures	3096.03	3098.21	3093.58	3097.12	59517.0
2018-08-14 18:00:00	ES	Futures	3097.12	3097.67	3094.94	3096.31	5602.0
2018-08-14 19:00:00	ES	Futures	3096.58	3097.4	3095.49	3097.12	4028.0
2018-08-14 20:00:00	ES	Futures	3097.12	3098.49	3096.03	3096.03	4968.0
2018-08-14 21:00:00	ES	Futures	3096.03	3096.03	3093.58	3094.13	8367.0
2018-08-14 22:00:00	ES	Futures	3094.13	3094.67	3091.95	3093.04	8107.0
2018-08-14 23:00:00	ES	Futures	3093.04	3093.04	3090.04	3091.4	5778.0
2018-08-14 00:00:00	NQ	Futures	8761.0	8763.95	8758.35	8758.94	1177.0
2018-08-14 01:00:00	NQ	Futures	8758.94	8765.71	8753.64	8761.3	1771.0
2018-08-14 02:00:00	NQ	Futures	8761.59	8775.72	8760.12	8774.25	3582.0
2018-08-14 03:00:00	NQ	Futures	8774.54	8791.33	8773.96	8790.15	5359.0
2018-08-14 04:00:00	NQ	Futures	8789.85	8790.44	8769.24	8770.72	3984.0
2018-08-14 05:00:00	NQ	Futures	8771.31	8785.14	8768.07	8773.37	2554.0
2018-08-14 06:00:00	NQ	Futures	8774.54	8783.67	8770.72	8777.19	3304.0
2018-08-14 07:00:00	NQ	Futures	8777.19	8777.78	8765.42	8769.83	3171.0
2018-08-14 08:00:00	NQ	Futures	8769.83	8773.07	8762.77	8768.07	5568.0
2018-08-14 09:00:00	NQ	Futures	8767.77	8768.07	8725.97	8736.56	59570.0
2018-08-14 10:00:00	NQ	Futures	8736.86	8777.78	8711.24	8770.42	65301.0
2018-08-14 11:00:00	NQ	Futures	8770.42	8786.32	8761.88	8772.48	40899.0
2018-08-14 12:00:00	NQ	Futures	8772.78	8791.03	8771.31	8774.84	22869.0
2018-08-14 13:00:00	NQ	Futures	8774.54	8786.91	8768.36	8784.85	17507.0
2018-08-14 14:00:00	NQ	Futures	8785.14	8787.79	8769.24	8782.79	20166.0
2018-08-14 15:00:00	NQ	Futures	8783.38	8790.15	8777.19	8781.32	27979.0
2018-08-14 16:00:00	NQ	Futures	8781.02	8789.27	8776.31	8787.79	7567.0
2018-08-14 18:00:00	NQ	Futures	8786.03	8788.97	8781.32	8785.14	1039.0
2018-08-14 19:00:00	NQ	Futures	8785.14	8786.62	8781.9	8786.03	540.0
2018-08-14 20:00:00	NQ	Futures	8786.03	8791.03	8782.2	8782.49	1356.0
2018-08-14 21:00:00	NQ	Futures	8782.79	8783.67	8774.84	8777.49	2665.0
2018-08-14 22:00:00	NQ	Futures	8777.19	8779.84	8771.6	8774.54	1777.0
2018-08-14 23:00:00	NQ	Futures	8774.54	8775.43	8763.65	8769.24	2014.0
2018-08-14 00:00:00	YM	Futures	27463.3	27470.9	27453.5	27456.8	740.0
2018-08-14 01:00:00	YM	Futures	27455.7	27469.8	27440.5	27461.1	1065.0
2018-08-14 02:00:00	YM	Futures	27462.2	27507.9	27454.6	27501.4	2506.0
2018-08-14 03:00:00	YM	Futures	27502.4	27537.2	27498.1	27535.1	3804.0

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

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