PREVIEW / futures_1hour / 2019-02-26

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-02-26.parquet
  size:    52 KB
  rows:    1,637

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-02-26 00:00:00	ES	Futures	3027.35	3029.53	3026.81	3027.9	8592.0
2019-02-26 01:00:00	ES	Futures	3027.9	3030.07	3027.08	3028.17	6903.0
2019-02-26 02:00:00	ES	Futures	3027.9	3031.43	3027.62	3031.16	8178.0
2019-02-26 03:00:00	ES	Futures	3030.88	3032.51	3029.25	3030.07	15024.0
2019-02-26 04:00:00	ES	Futures	3030.07	3031.7	3025.45	3031.16	19708.0
2019-02-26 05:00:00	ES	Futures	3031.16	3033.06	3029.8	3032.51	9742.0
2019-02-26 06:00:00	ES	Futures	3032.51	3033.06	3028.17	3031.97	15227.0
2019-02-26 07:00:00	ES	Futures	3031.97	3034.41	3031.16	3033.33	12855.0
2019-02-26 08:00:00	ES	Futures	3033.33	3033.6	3028.71	3029.25	19980.0
2019-02-26 09:00:00	ES	Futures	3029.25	3036.32	3029.25	3034.69	183663.0
2019-02-26 10:00:00	ES	Futures	3034.41	3042.02	3031.16	3031.16	204748.0
2019-02-26 11:00:00	ES	Futures	3031.16	3045.28	3030.34	3039.03	160076.0
2019-02-26 12:00:00	ES	Futures	3039.3	3040.66	3034.14	3034.96	68992.0
2019-02-26 13:00:00	ES	Futures	3034.96	3038.49	3034.14	3036.32	55523.0
2019-02-26 14:00:00	ES	Futures	3036.32	3042.56	3034.96	3041.48	74594.0
2019-02-26 15:00:00	ES	Futures	3041.75	3045.55	3034.41	3034.96	159947.0
2019-02-26 16:00:00	ES	Futures	3035.5	3035.77	3029.53	3029.8	49620.0
2019-02-26 18:00:00	ES	Futures	3028.71	3032.24	3027.08	3029.53	9460.0
2019-02-26 19:00:00	ES	Futures	3029.8	3032.24	3029.53	3030.61	4459.0
2019-02-26 22:00:00	ES	Futures	3030.61	3034.14	3030.61	3032.51	3472.0
2019-02-26 23:00:00	ES	Futures	3032.24	3032.51	3029.53	3031.7	5273.0
2019-02-26 00:00:00	NQ	Futures	8279.77	8285.91	8275.97	8280.35	3432.0
2019-02-26 01:00:00	NQ	Futures	8280.65	8287.95	8278.31	8281.23	2457.0
2019-02-26 02:00:00	NQ	Futures	8281.23	8294.96	8281.23	8292.92	3119.0
2019-02-26 03:00:00	NQ	Futures	8293.21	8300.22	8288.83	8291.75	4683.0
2019-02-26 04:00:00	NQ	Futures	8292.04	8299.05	8280.65	8297.88	5568.0
2019-02-26 05:00:00	NQ	Futures	8297.88	8304.02	8293.21	8301.68	3512.0
2019-02-26 06:00:00	NQ	Futures	8301.39	8307.82	8290.58	8302.56	5078.0
2019-02-26 07:00:00	NQ	Futures	8302.27	8308.99	8301.1	8304.31	3565.0
2019-02-26 08:00:00	NQ	Futures	8304.02	8304.31	8284.44	8287.07	8097.0
2019-02-26 09:00:00	NQ	Futures	8287.66	8320.97	8287.37	8315.42	55457.0
2019-02-26 10:00:00	NQ	Futures	8315.12	8340.84	8304.61	8305.48	61525.0
2019-02-26 11:00:00	NQ	Futures	8305.19	8344.64	8301.1	8325.94	48801.0
2019-02-26 12:00:00	NQ	Futures	8326.23	8331.49	8309.28	8313.37	26385.0
2019-02-26 13:00:00	NQ	Futures	8313.08	8331.19	8312.2	8326.23	23284.0
2019-02-26 14:00:00	NQ	Futures	8326.23	8346.68	8324.18	8342.88	23862.0
2019-02-26 15:00:00	NQ	Futures	8342.88	8357.78	8328.86	8331.49	40442.0
2019-02-26 16:00:00	NQ	Futures	8331.78	8333.82	8309.86	8311.33	10465.0
2019-02-26 18:00:00	NQ	Futures	8308.99	8318.63	8303.73	8313.37	2840.0
2019-02-26 19:00:00	NQ	Futures	8313.66	8322.72	8313.66	8317.17	1897.0
2019-02-26 22:00:00	NQ	Futures	8316.88	8330.32	8316.88	8321.26	824.0
2019-02-26 23:00:00	NQ	Futures	8321.26	8321.84	8313.37	8320.09	1857.0
2019-02-26 00:00:00	YM	Futures	28236.0	28256.6	28226.2	28243.6	3453.0
2019-02-26 01:00:00	YM	Futures	28243.6	28260.9	28236.0	28243.6	2738.0
2019-02-26 02:00:00	YM	Futures	28243.6	28272.9	28241.4	28268.5	2192.0
2019-02-26 03:00:00	YM	Futures	28268.5	28282.7	28247.9	28258.8	3927.0
2019-02-26 04:00:00	YM	Futures	28257.7	28260.9	28183.9	28249.0	6219.0
2019-02-26 05:00:00	YM	Futures	28249.0	28274.0	28239.2	28268.5	3189.0
2019-02-26 06:00:00	YM	Futures	28268.5	28268.5	28196.9	28230.5	5474.0
2019-02-26 07:00:00	YM	Futures	28232.7	28253.3	28227.3	28247.9	3292.0

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

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