PREVIEW / futures_1hour / 2019-08-05

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-08-05.parquet
  size:    64 KB
  rows:    1,904

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
2019-08-05 00:00:00	ES	Futures	3139.1	3140.18	3135.04	3137.47	11056.0
2019-08-05 01:00:00	ES	Futures	3137.47	3143.7	3136.39	3142.62	16606.0
2019-08-05 02:00:00	ES	Futures	3142.62	3144.78	3140.18	3141.8	23972.0
2019-08-05 03:00:00	ES	Futures	3141.8	3146.41	3136.66	3136.93	49321.0
2019-08-05 04:00:00	ES	Futures	3137.2	3138.55	3129.08	3129.62	57919.0
2019-08-05 05:00:00	ES	Futures	3129.62	3142.07	3126.37	3139.1	66473.0
2019-08-05 06:00:00	ES	Futures	3139.1	3141.26	3131.52	3132.33	26040.0
2019-08-05 07:00:00	ES	Futures	3132.33	3135.31	3124.75	3133.14	81953.0
2019-08-05 08:00:00	ES	Futures	3133.14	3134.76	3124.21	3125.29	61651.0
2019-08-05 09:00:00	ES	Futures	3125.29	3127.73	3109.32	3115.82	329507.0
2019-08-05 10:00:00	ES	Futures	3115.54	3116.9	3098.49	3105.8	345689.0
2019-08-05 11:00:00	ES	Futures	3105.8	3116.09	3102.01	3102.28	281996.0
2019-08-05 12:00:00	ES	Futures	3102.28	3104.72	3081.71	3082.79	275341.0
2019-08-05 13:00:00	ES	Futures	3082.52	3095.78	3080.08	3080.62	206223.0
2019-08-05 14:00:00	ES	Futures	3080.35	3084.41	3063.57	3066.01	242109.0
2019-08-05 15:00:00	ES	Futures	3065.73	3087.66	3054.09	3079.81	557628.0
2019-08-05 16:00:00	ES	Futures	3080.08	3081.44	3056.26	3058.7	122588.0
2019-08-05 18:00:00	ES	Futures	3049.49	3052.2	3013.22	3018.63	71946.0
2019-08-05 19:00:00	ES	Futures	3018.36	3026.75	3005.64	3012.14	38858.0
2019-08-05 20:00:00	ES	Futures	3012.41	3030.54	3009.7	3025.94	53697.0
2019-08-05 21:00:00	ES	Futures	3025.94	3057.61	3025.4	3043.81	106737.0
2019-08-05 22:00:00	ES	Futures	3043.54	3045.97	3033.25	3044.08	31114.0
2019-08-05 23:00:00	ES	Futures	3044.35	3076.29	3042.18	3074.94	44794.0
2019-08-05 00:00:00	NQ	Futures	8805.82	8810.76	8792.48	8804.66	4507.0
2019-08-05 01:00:00	NQ	Futures	8805.82	8828.16	8802.92	8825.55	7331.0
2019-08-05 02:00:00	NQ	Futures	8825.55	8834.84	8811.63	8820.33	8350.0
2019-08-05 03:00:00	NQ	Futures	8819.75	8837.45	8804.08	8808.14	12182.0
2019-08-05 04:00:00	NQ	Futures	8808.43	8810.76	8774.2	8776.23	15293.0
2019-08-05 05:00:00	NQ	Futures	8775.94	8817.72	8764.33	8803.21	18695.0
2019-08-05 06:00:00	NQ	Futures	8803.21	8812.5	8781.16	8784.93	8962.0
2019-08-05 07:00:00	NQ	Futures	8784.93	8788.99	8755.34	8776.52	22162.0
2019-08-05 08:00:00	NQ	Futures	8776.52	8783.19	8741.99	8745.76	21180.0
2019-08-05 09:00:00	NQ	Futures	8746.05	8764.04	8682.8	8720.23	101241.0
2019-08-05 10:00:00	NQ	Futures	8720.52	8726.32	8660.75	8684.54	99018.0
2019-08-05 11:00:00	NQ	Futures	8684.54	8718.78	8664.23	8666.55	78095.0
2019-08-05 12:00:00	NQ	Futures	8666.55	8676.13	8607.37	8611.14	79383.0
2019-08-05 13:00:00	NQ	Futures	8611.14	8657.27	8603.3	8605.04	64236.0
2019-08-05 14:00:00	NQ	Futures	8605.04	8615.2	8562.1	8569.36	69813.0
2019-08-05 15:00:00	NQ	Futures	8569.36	8637.54	8542.66	8614.91	130934.0
2019-08-05 16:00:00	NQ	Futures	8615.2	8621.58	8541.5	8551.37	20171.0
2019-08-05 18:00:00	NQ	Futures	8529.03	8529.9	8408.91	8427.77	25802.0
2019-08-05 19:00:00	NQ	Futures	8427.77	8453.88	8384.54	8406.88	18821.0
2019-08-05 20:00:00	NQ	Futures	8407.46	8468.68	8398.46	8453.88	27992.0
2019-08-05 21:00:00	NQ	Futures	8454.17	8551.08	8452.72	8507.85	37335.0
2019-08-05 22:00:00	NQ	Futures	8507.85	8518.0	8475.64	8515.39	14252.0
2019-08-05 23:00:00	NQ	Futures	8515.39	8613.75	8505.82	8611.43	21258.0
2019-08-05 00:00:00	YM	Futures	28458.8	28469.7	28430.5	28453.4	2711.0
2019-08-05 01:00:00	YM	Futures	28455.5	28494.7	28440.3	28486.0	3644.0
2019-08-05 02:00:00	YM	Futures	28487.1	28504.5	28465.3	28480.5	4439.0
2019-08-05 03:00:00	YM	Futures	28480.5	28516.4	28434.9	28441.4	7591.0

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

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