PREVIEW / futures_1hour / 2018-07-26

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-07-26.parquet
  size:    53 KB
  rows:    1,667

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-26 00:00:00	ES	Futures	3089.22	3089.5	3088.68	3089.5	2430.0
2018-07-26 01:00:00	ES	Futures	3089.5	3089.77	3088.13	3088.68	4556.0
2018-07-26 02:00:00	ES	Futures	3088.68	3091.13	3088.68	3089.77	8832.0
2018-07-26 03:00:00	ES	Futures	3090.04	3092.22	3089.22	3091.4	14240.0
2018-07-26 04:00:00	ES	Futures	3091.13	3091.4	3089.22	3089.5	10036.0
2018-07-26 05:00:00	ES	Futures	3089.77	3092.76	3089.5	3091.95	11970.0
2018-07-26 06:00:00	ES	Futures	3092.22	3092.76	3089.77	3090.31	7393.0
2018-07-26 07:00:00	ES	Futures	3090.31	3092.22	3089.77	3091.13	12900.0
2018-07-26 08:00:00	ES	Futures	3091.13	3093.85	3089.77	3090.04	25315.0
2018-07-26 09:00:00	ES	Futures	3090.31	3099.3	3090.04	3094.67	180141.0
2018-07-26 10:00:00	ES	Futures	3094.67	3099.3	3093.31	3099.03	130402.0
2018-07-26 11:00:00	ES	Futures	3099.03	3100.39	3095.76	3100.12	95157.0
2018-07-26 12:00:00	ES	Futures	3099.85	3102.3	3091.95	3092.76	87398.0
2018-07-26 13:00:00	ES	Futures	3093.04	3097.12	3091.68	3094.13	72045.0
2018-07-26 14:00:00	ES	Futures	3094.4	3096.85	3092.76	3094.4	54590.0
2018-07-26 15:00:00	ES	Futures	3094.4	3095.49	3091.13	3093.31	136816.0
2018-07-26 16:00:00	ES	Futures	3093.04	3098.76	3088.13	3095.49	97526.0
2018-07-26 18:00:00	ES	Futures	3095.49	3097.4	3094.4	3096.03	3766.0
2018-07-26 19:00:00	ES	Futures	3096.03	3097.94	3095.76	3097.67	2116.0
2018-07-26 20:00:00	ES	Futures	3097.67	3099.03	3097.12	3097.94	3336.0
2018-07-26 21:00:00	ES	Futures	3097.94	3098.76	3096.58	3096.58	4782.0
2018-07-26 22:00:00	ES	Futures	3096.85	3098.76	3095.76	3098.76	2376.0
2018-07-26 23:00:00	ES	Futures	3098.76	3100.39	3098.21	3099.58	3306.0
2018-07-26 00:00:00	NQ	Futures	8719.49	8724.79	8716.54	8722.43	1279.0
2018-07-26 01:00:00	NQ	Futures	8722.73	8723.9	8711.83	8715.66	2283.0
2018-07-26 02:00:00	NQ	Futures	8716.25	8728.03	8715.66	8721.25	3881.0
2018-07-26 03:00:00	NQ	Futures	8721.55	8730.68	8720.67	8724.79	3918.0
2018-07-26 04:00:00	NQ	Futures	8725.08	8727.44	8711.54	8717.13	4153.0
2018-07-26 05:00:00	NQ	Futures	8717.13	8731.26	8711.83	8725.38	3181.0
2018-07-26 06:00:00	NQ	Futures	8725.67	8727.73	8717.43	8722.43	2301.0
2018-07-26 07:00:00	NQ	Futures	8722.43	8739.8	8720.37	8735.09	6649.0
2018-07-26 08:00:00	NQ	Futures	8735.09	8747.16	8722.43	8725.08	9854.0
2018-07-26 09:00:00	NQ	Futures	8725.38	8760.41	8709.48	8728.32	72085.0
2018-07-26 10:00:00	NQ	Futures	8728.61	8757.47	8724.79	8748.34	60096.0
2018-07-26 11:00:00	NQ	Futures	8748.64	8761.88	8740.69	8761.0	36354.0
2018-07-26 12:00:00	NQ	Futures	8760.71	8763.65	8718.9	8725.38	33857.0
2018-07-26 13:00:00	NQ	Futures	8725.08	8739.8	8719.78	8731.26	24274.0
2018-07-26 14:00:00	NQ	Futures	8731.26	8738.04	8724.2	8724.2	16020.0
2018-07-26 15:00:00	NQ	Futures	8724.79	8733.62	8717.43	8726.55	32737.0
2018-07-26 16:00:00	NQ	Futures	8726.55	8773.66	8670.03	8745.4	32555.0
2018-07-26 18:00:00	NQ	Futures	8749.52	8755.41	8746.57	8749.52	1705.0
2018-07-26 19:00:00	NQ	Futures	8748.64	8755.41	8748.34	8755.11	1158.0
2018-07-26 20:00:00	NQ	Futures	8755.41	8760.12	8753.05	8758.35	2808.0
2018-07-26 21:00:00	NQ	Futures	8758.35	8760.71	8750.7	8752.46	2248.0
2018-07-26 22:00:00	NQ	Futures	8752.46	8758.94	8748.64	8758.94	1286.0
2018-07-26 23:00:00	NQ	Futures	8758.94	8768.36	8758.94	8767.18	1883.0
2018-07-26 00:00:00	YM	Futures	27629.6	27636.2	27624.2	27636.2	624.0
2018-07-26 01:00:00	YM	Futures	27636.2	27642.7	27605.7	27628.6	2111.0
2018-07-26 02:00:00	YM	Futures	27630.7	27660.1	27624.2	27641.6	4135.0
2018-07-26 03:00:00	YM	Futures	27640.5	27662.3	27634.0	27655.7	2845.0

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

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