PREVIEW / futures_1hour / 2018-10-10

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-10-10.parquet
  size:    58 KB
  rows:    1,715

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-10-10 00:00:00	ES	Futures	3137.77	3140.22	3137.23	3139.95	4459.0
2018-10-10 01:00:00	ES	Futures	3139.95	3142.94	3139.95	3141.04	4890.0
2018-10-10 02:00:00	ES	Futures	3141.04	3144.84	3140.76	3144.03	6403.0
2018-10-10 03:00:00	ES	Futures	3144.03	3144.84	3137.77	3139.4	17572.0
2018-10-10 04:00:00	ES	Futures	3139.68	3141.04	3136.41	3138.32	13375.0
2018-10-10 05:00:00	ES	Futures	3138.32	3140.22	3136.68	3138.32	13546.0
2018-10-10 06:00:00	ES	Futures	3138.32	3143.21	3137.77	3141.31	12659.0
2018-10-10 07:00:00	ES	Futures	3141.04	3143.76	3136.14	3136.41	17770.0
2018-10-10 08:00:00	ES	Futures	3136.68	3137.23	3128.52	3131.79	55210.0
2018-10-10 09:00:00	ES	Futures	3131.52	3133.42	3108.4	3109.76	365777.0
2018-10-10 10:00:00	ES	Futures	3110.03	3113.56	3101.6	3105.13	495189.0
2018-10-10 11:00:00	ES	Futures	3104.86	3105.95	3087.45	3092.35	422856.0
2018-10-10 12:00:00	ES	Futures	3092.35	3100.78	3088.0	3091.53	214940.0
2018-10-10 13:00:00	ES	Futures	3091.26	3099.96	3083.64	3089.36	258491.0
2018-10-10 14:00:00	ES	Futures	3089.08	3090.72	3069.5	3076.03	392010.0
2018-10-10 15:00:00	ES	Futures	3075.76	3076.03	3034.96	3038.22	805339.0
2018-10-10 16:00:00	ES	Futures	3038.22	3041.21	3015.37	3016.73	217420.0
2018-10-10 18:00:00	ES	Futures	3020.81	3025.16	3015.92	3025.16	34313.0
2018-10-10 19:00:00	ES	Futures	3025.16	3030.6	3017.55	3021.36	26555.0
2018-10-10 20:00:00	ES	Futures	3021.36	3026.25	3014.83	3025.16	34051.0
2018-10-10 21:00:00	ES	Futures	3025.16	3025.44	2992.25	2998.78	48407.0
2018-10-10 22:00:00	ES	Futures	2998.51	3010.75	2993.88	3000.68	46063.0
2018-10-10 23:00:00	ES	Futures	3000.68	3010.2	2996.06	3008.57	25717.0
2018-10-10 00:00:00	NQ	Futures	8670.37	8675.94	8666.55	8674.77	1895.0
2018-10-10 01:00:00	NQ	Futures	8675.06	8688.55	8674.77	8683.86	2365.0
2018-10-10 02:00:00	NQ	Futures	8683.27	8696.18	8682.98	8690.31	3489.0
2018-10-10 03:00:00	NQ	Futures	8690.6	8692.07	8667.14	8671.54	6633.0
2018-10-10 04:00:00	NQ	Futures	8671.54	8674.47	8660.39	8663.03	6005.0
2018-10-10 05:00:00	NQ	Futures	8663.03	8668.02	8656.58	8660.1	5601.0
2018-10-10 06:00:00	NQ	Futures	8659.81	8677.11	8659.22	8666.55	5135.0
2018-10-10 07:00:00	NQ	Futures	8666.85	8677.11	8638.98	8642.79	8561.0
2018-10-10 08:00:00	NQ	Futures	8643.09	8646.31	8618.74	8626.96	21460.0
2018-10-10 09:00:00	NQ	Futures	8626.66	8634.0	8500.24	8515.2	130385.0
2018-10-10 10:00:00	NQ	Futures	8515.2	8542.19	8483.23	8514.91	143501.0
2018-10-10 11:00:00	NQ	Futures	8515.79	8522.24	8448.91	8474.73	113766.0
2018-10-10 12:00:00	NQ	Futures	8474.43	8511.39	8452.73	8472.38	71876.0
2018-10-10 13:00:00	NQ	Futures	8472.09	8520.78	8449.79	8483.82	80032.0
2018-10-10 14:00:00	NQ	Futures	8482.94	8488.22	8412.25	8438.06	98063.0
2018-10-10 15:00:00	NQ	Futures	8438.35	8438.35	8286.12	8296.68	151056.0
2018-10-10 16:00:00	NQ	Futures	8297.27	8308.71	8212.8	8216.61	47014.0
2018-10-10 18:00:00	NQ	Futures	8224.82	8247.7	8220.13	8247.41	9789.0
2018-10-10 19:00:00	NQ	Futures	8247.11	8265.59	8217.78	8231.27	7753.0
2018-10-10 20:00:00	NQ	Futures	8230.39	8250.63	8206.34	8244.77	11166.0
2018-10-10 21:00:00	NQ	Futures	8245.35	8246.82	8125.39	8149.73	17412.0
2018-10-10 22:00:00	NQ	Futures	8149.15	8208.4	8134.48	8178.48	19780.0
2018-10-10 23:00:00	NQ	Futures	8178.19	8207.22	8159.41	8203.12	8095.0
2018-10-10 00:00:00	YM	Futures	28738.3	28757.8	28732.8	28751.3	1343.0
2018-10-10 01:00:00	YM	Futures	28751.3	28782.8	28751.3	28761.1	1764.0
2018-10-10 02:00:00	YM	Futures	28760.0	28790.4	28758.9	28782.8	1850.0
2018-10-10 03:00:00	YM	Futures	28782.8	28790.4	28720.9	28739.3	4064.0

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

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