PREVIEW / futures_1hour / 2018-02-01

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-02-01.parquet
  size:    57 KB
  rows:    1,702

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-02-01 00:00:00	ES	Futures	3100.91	3100.91	3098.72	3099.54	4697.0
2018-02-01 01:00:00	ES	Futures	3099.54	3099.81	3097.63	3098.17	2952.0
2018-02-01 02:00:00	ES	Futures	3098.17	3099.54	3097.63	3098.17	7526.0
2018-02-01 03:00:00	ES	Futures	3098.45	3100.63	3096.53	3096.53	16629.0
2018-02-01 04:00:00	ES	Futures	3096.81	3097.9	3094.07	3094.07	21303.0
2018-02-01 05:00:00	ES	Futures	3094.35	3096.53	3092.16	3092.16	15796.0
2018-02-01 06:00:00	ES	Futures	3091.89	3093.53	3089.43	3092.16	24202.0
2018-02-01 07:00:00	ES	Futures	3091.89	3092.71	3088.61	3092.71	23964.0
2018-02-01 08:00:00	ES	Futures	3092.43	3092.71	3076.03	3080.41	95980.0
2018-02-01 09:00:00	ES	Futures	3080.41	3088.88	3071.66	3086.42	253357.0
2018-02-01 10:00:00	ES	Futures	3086.15	3089.7	3080.95	3085.33	188747.0
2018-02-01 11:00:00	ES	Futures	3085.33	3099.27	3084.51	3098.99	162886.0
2018-02-01 12:00:00	ES	Futures	3098.99	3100.36	3096.26	3097.35	100496.0
2018-02-01 13:00:00	ES	Futures	3097.35	3101.45	3088.61	3089.97	103665.0
2018-02-01 14:00:00	ES	Futures	3090.25	3091.61	3079.59	3091.07	170342.0
2018-02-01 15:00:00	ES	Futures	3091.07	3091.89	3074.94	3085.33	256490.0
2018-02-01 16:00:00	ES	Futures	3085.6	3089.43	3080.41	3086.97	86155.0
2018-02-01 18:00:00	ES	Futures	3090.25	3095.17	3088.88	3091.34	19088.0
2018-02-01 19:00:00	ES	Futures	3091.34	3092.43	3086.97	3087.51	10453.0
2018-02-01 20:00:00	ES	Futures	3087.51	3087.51	3074.12	3080.41	23849.0
2018-02-01 21:00:00	ES	Futures	3080.41	3081.23	3075.49	3079.86	9652.0
2018-02-01 22:00:00	ES	Futures	3079.59	3083.14	3079.04	3080.13	6389.0
2018-02-01 23:00:00	ES	Futures	3080.13	3084.23	3077.95	3082.87	5137.0
2018-02-01 00:00:00	NQ	Futures	8287.73	8289.51	8281.5	8282.99	1335.0
2018-02-01 01:00:00	NQ	Futures	8282.39	8284.47	8280.32	8281.8	781.0
2018-02-01 02:00:00	NQ	Futures	8282.1	8284.77	8276.76	8280.32	1609.0
2018-02-01 03:00:00	NQ	Futures	8280.02	8285.06	8269.34	8270.53	3188.0
2018-02-01 04:00:00	NQ	Futures	8270.83	8273.5	8260.74	8261.34	4776.0
2018-02-01 05:00:00	NQ	Futures	8261.34	8272.31	8259.56	8259.85	3162.0
2018-02-01 06:00:00	NQ	Futures	8259.56	8267.86	8255.4	8258.96	3729.0
2018-02-01 07:00:00	NQ	Futures	8258.67	8258.67	8242.06	8254.51	7837.0
2018-02-01 08:00:00	NQ	Futures	8254.51	8254.81	8191.04	8203.8	31293.0
2018-02-01 09:00:00	NQ	Futures	8204.39	8251.25	8183.63	8244.43	82290.0
2018-02-01 10:00:00	NQ	Futures	8244.43	8272.31	8233.46	8265.19	64801.0
2018-02-01 11:00:00	NQ	Futures	8264.9	8271.72	8243.54	8266.97	46034.0
2018-02-01 12:00:00	NQ	Futures	8267.27	8272.01	8255.11	8266.38	24723.0
2018-02-01 13:00:00	NQ	Futures	8266.38	8280.32	8232.57	8234.35	31639.0
2018-02-01 14:00:00	NQ	Futures	8234.64	8242.35	8202.31	8233.75	59681.0
2018-02-01 15:00:00	NQ	Futures	8233.75	8236.72	8167.91	8194.9	72486.0
2018-02-01 16:00:00	NQ	Futures	8194.9	8232.27	8174.43	8228.41	33403.0
2018-02-01 18:00:00	NQ	Futures	8250.07	8261.34	8241.76	8249.77	7801.0
2018-02-01 19:00:00	NQ	Futures	8249.47	8251.25	8234.64	8239.09	2870.0
2018-02-01 20:00:00	NQ	Futures	8239.39	8239.68	8200.83	8224.26	5983.0
2018-02-01 21:00:00	NQ	Futures	8224.26	8232.27	8212.1	8232.27	3688.0
2018-02-01 22:00:00	NQ	Futures	8231.68	8238.2	8227.23	8228.41	3609.0
2018-02-01 23:00:00	NQ	Futures	8229.01	8231.97	8218.03	8223.37	2849.0
2018-02-01 00:00:00	YM	Futures	28478.4	28479.5	28466.5	28476.3	1191.0
2018-02-01 01:00:00	YM	Futures	28474.1	28479.5	28465.4	28470.8	629.0
2018-02-01 02:00:00	YM	Futures	28473.0	28479.5	28463.2	28467.6	1563.0
2018-02-01 03:00:00	YM	Futures	28466.5	28481.7	28426.3	28431.7	3536.0

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

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