PREVIEW / futures_1hour / 2018-07-25

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-07-25.parquet
  size:    54 KB
  rows:    1,670

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-25 00:00:00	ES	Futures	3069.06	3069.33	3066.88	3068.24	3237.0
2018-07-25 01:00:00	ES	Futures	3068.52	3069.88	3067.97	3069.88	2815.0
2018-07-25 02:00:00	ES	Futures	3069.61	3072.33	3069.06	3072.06	5338.0
2018-07-25 03:00:00	ES	Futures	3072.06	3073.42	3071.24	3072.6	10960.0
2018-07-25 04:00:00	ES	Futures	3072.33	3073.96	3070.42	3072.06	7698.0
2018-07-25 05:00:00	ES	Futures	3072.06	3073.69	3071.24	3072.87	7020.0
2018-07-25 06:00:00	ES	Futures	3072.87	3075.33	3070.97	3071.24	10034.0
2018-07-25 07:00:00	ES	Futures	3071.24	3071.79	3066.88	3070.15	28333.0
2018-07-25 08:00:00	ES	Futures	3069.88	3072.33	3068.24	3072.33	20105.0
2018-07-25 09:00:00	ES	Futures	3072.33	3079.96	3070.42	3078.05	130637.0
2018-07-25 10:00:00	ES	Futures	3078.05	3079.14	3072.87	3074.51	169055.0
2018-07-25 11:00:00	ES	Futures	3074.78	3081.59	3072.33	3081.59	127953.0
2018-07-25 12:00:00	ES	Futures	3081.32	3084.32	3079.41	3084.32	70431.0
2018-07-25 13:00:00	ES	Futures	3084.05	3086.23	3080.5	3084.86	71364.0
2018-07-25 14:00:00	ES	Futures	3085.14	3090.86	3084.32	3087.86	124543.0
2018-07-25 15:00:00	ES	Futures	3088.13	3105.57	3085.68	3103.12	337232.0
2018-07-25 16:00:00	ES	Futures	3103.39	3103.66	3095.22	3100.94	110674.0
2018-07-25 18:00:00	ES	Futures	3090.04	3094.67	3088.95	3091.4	21741.0
2018-07-25 19:00:00	ES	Futures	3091.4	3092.49	3088.68	3092.22	6760.0
2018-07-25 20:00:00	ES	Futures	3092.22	3093.58	3089.77	3092.49	6716.0
2018-07-25 21:00:00	ES	Futures	3092.49	3093.58	3090.31	3090.59	7737.0
2018-07-25 22:00:00	ES	Futures	3090.59	3091.13	3088.41	3088.41	7435.0
2018-07-25 23:00:00	ES	Futures	3088.41	3089.77	3087.86	3089.22	4982.0
2018-07-25 00:00:00	NQ	Futures	8722.73	8725.38	8718.02	8721.84	1038.0
2018-07-25 01:00:00	NQ	Futures	8721.84	8723.9	8718.9	8723.61	949.0
2018-07-25 02:00:00	NQ	Futures	8723.32	8733.91	8721.84	8732.44	1616.0
2018-07-25 03:00:00	NQ	Futures	8732.74	8739.21	8730.09	8734.8	3024.0
2018-07-25 04:00:00	NQ	Futures	8734.21	8740.69	8729.2	8735.39	1971.0
2018-07-25 05:00:00	NQ	Futures	8735.09	8742.45	8732.44	8739.21	2030.0
2018-07-25 06:00:00	NQ	Futures	8739.21	8747.16	8736.27	8736.56	2765.0
2018-07-25 07:00:00	NQ	Futures	8736.27	8739.21	8720.67	8730.09	6235.0
2018-07-25 08:00:00	NQ	Futures	8730.09	8738.63	8724.49	8738.63	4644.0
2018-07-25 09:00:00	NQ	Futures	8738.33	8768.07	8730.97	8758.65	45035.0
2018-07-25 10:00:00	NQ	Futures	8758.35	8764.24	8735.68	8746.57	58129.0
2018-07-25 11:00:00	NQ	Futures	8746.87	8781.61	8741.86	8780.14	38088.0
2018-07-25 12:00:00	NQ	Futures	8780.14	8802.51	8775.43	8797.8	27768.0
2018-07-25 13:00:00	NQ	Futures	8798.39	8804.87	8786.03	8801.93	21265.0
2018-07-25 14:00:00	NQ	Futures	8801.93	8819.59	8801.04	8811.05	28752.0
2018-07-25 15:00:00	NQ	Futures	8811.05	8862.28	8803.4	8857.28	65005.0
2018-07-25 16:00:00	NQ	Futures	8856.98	8867.87	8788.38	8813.7	28466.0
2018-07-25 18:00:00	NQ	Futures	8729.2	8749.22	8701.23	8729.79	16310.0
2018-07-25 19:00:00	NQ	Futures	8729.79	8738.04	8724.49	8730.68	4252.0
2018-07-25 20:00:00	NQ	Futures	8730.38	8747.75	8725.97	8738.33	3967.0
2018-07-25 21:00:00	NQ	Futures	8738.04	8749.81	8732.74	8733.33	7163.0
2018-07-25 22:00:00	NQ	Futures	8733.33	8735.09	8709.48	8711.24	5494.0
2018-07-25 23:00:00	NQ	Futures	8711.24	8721.25	8704.18	8719.49	2627.0
2018-07-25 00:00:00	YM	Futures	27384.0	27388.3	27354.6	27386.1	1406.0
2018-07-25 01:00:00	YM	Futures	27386.1	27394.8	27381.8	27393.7	1028.0
2018-07-25 02:00:00	YM	Futures	27393.7	27419.8	27390.5	27413.3	2183.0
2018-07-25 03:00:00	YM	Futures	27413.3	27432.9	27407.9	27417.7	2685.0

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

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