PREVIEW / futures_1hour / 2019-07-26

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-07-26.parquet
  size:    48 KB
  rows:    1,480

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-07-26 00:00:00	ES	Futures	3263.35	3264.43	3263.08	3263.08	3621.0
2019-07-26 01:00:00	ES	Futures	3263.08	3263.89	3262.27	3263.89	4246.0
2019-07-26 02:00:00	ES	Futures	3263.62	3264.16	3261.45	3262.27	8893.0
2019-07-26 03:00:00	ES	Futures	3262.0	3262.81	3259.83	3262.0	18296.0
2019-07-26 04:00:00	ES	Futures	3261.73	3263.08	3260.64	3262.54	11374.0
2019-07-26 05:00:00	ES	Futures	3262.54	3266.33	3261.45	3265.79	14527.0
2019-07-26 06:00:00	ES	Futures	3266.06	3267.14	3264.43	3264.43	13026.0
2019-07-26 07:00:00	ES	Futures	3264.7	3265.52	3263.89	3265.24	12187.0
2019-07-26 08:00:00	ES	Futures	3264.97	3265.79	3259.29	3263.89	32090.0
2019-07-26 09:00:00	ES	Futures	3263.89	3270.93	3262.81	3269.31	155443.0
2019-07-26 10:00:00	ES	Futures	3269.31	3270.66	3265.79	3268.49	145333.0
2019-07-26 11:00:00	ES	Futures	3268.49	3275.26	3267.68	3274.72	97526.0
2019-07-26 12:00:00	ES	Futures	3274.99	3275.53	3273.09	3274.72	51897.0
2019-07-26 13:00:00	ES	Futures	3274.72	3276.34	3273.64	3275.26	44630.0
2019-07-26 14:00:00	ES	Futures	3275.53	3278.78	3274.18	3278.51	54073.0
2019-07-26 15:00:00	ES	Futures	3278.78	3280.4	3277.43	3277.43	139185.0
2019-07-26 16:00:00	ES	Futures	3277.43	3277.97	3273.09	3273.37	75500.0
2019-07-26 00:00:00	NQ	Futures	9304.58	9309.8	9299.94	9299.94	2125.0
2019-07-26 01:00:00	NQ	Futures	9300.52	9307.19	9298.77	9306.9	1692.0
2019-07-26 02:00:00	NQ	Futures	9306.9	9307.77	9297.32	9299.94	2971.0
2019-07-26 03:00:00	NQ	Futures	9299.65	9302.26	9288.62	9294.13	6361.0
2019-07-26 04:00:00	NQ	Futures	9293.84	9296.45	9285.43	9292.39	4678.0
2019-07-26 05:00:00	NQ	Futures	9292.1	9305.45	9289.2	9303.71	4486.0
2019-07-26 06:00:00	NQ	Futures	9303.42	9309.8	9299.94	9300.81	4318.0
2019-07-26 07:00:00	NQ	Futures	9300.52	9302.84	9295.87	9299.94	4261.0
2019-07-26 08:00:00	NQ	Futures	9299.94	9302.55	9274.4	9288.33	15048.0
2019-07-26 09:00:00	NQ	Futures	9288.62	9323.73	9277.88	9315.31	62772.0
2019-07-26 10:00:00	NQ	Futures	9314.73	9319.96	9283.98	9294.42	54323.0
2019-07-26 11:00:00	NQ	Futures	9294.13	9322.28	9288.04	9320.83	35036.0
2019-07-26 12:00:00	NQ	Futures	9320.83	9323.44	9309.22	9316.18	21699.0
2019-07-26 13:00:00	NQ	Futures	9316.18	9326.05	9311.54	9322.28	18562.0
2019-07-26 14:00:00	NQ	Futures	9322.28	9326.92	9314.15	9326.05	16834.0
2019-07-26 15:00:00	NQ	Futures	9326.34	9331.85	9317.34	9317.34	34718.0
2019-07-26 16:00:00	NQ	Futures	9317.34	9317.92	9302.26	9302.26	9777.0
2019-07-26 00:00:00	YM	Futures	29523.5	29534.3	29520.2	29520.2	791.0
2019-07-26 01:00:00	YM	Futures	29522.4	29526.7	29515.8	29524.5	843.0
2019-07-26 02:00:00	YM	Futures	29524.5	29527.8	29501.7	29508.2	1433.0
2019-07-26 03:00:00	YM	Futures	29508.2	29516.9	29489.7	29511.5	3435.0
2019-07-26 04:00:00	YM	Futures	29511.5	29524.5	29502.8	29519.1	2198.0
2019-07-26 05:00:00	YM	Futures	29519.1	29556.1	29511.5	29552.8	3575.0
2019-07-26 06:00:00	YM	Futures	29552.8	29564.8	29546.3	29546.3	2496.0
2019-07-26 07:00:00	YM	Futures	29546.3	29562.6	29543.0	29555.0	2952.0
2019-07-26 08:00:00	YM	Futures	29555.0	29559.3	29503.9	29547.4	6604.0
2019-07-26 09:00:00	YM	Futures	29547.4	29561.5	29486.5	29544.1	23764.0
2019-07-26 10:00:00	YM	Futures	29543.0	29552.8	29473.4	29497.4	18675.0
2019-07-26 11:00:00	YM	Futures	29497.4	29537.6	29487.6	29535.4	10773.0
2019-07-26 12:00:00	YM	Futures	29535.4	29538.7	29510.4	29525.6	6783.0
2019-07-26 13:00:00	YM	Futures	29525.6	29526.7	29486.5	29511.5	5825.0
2019-07-26 14:00:00	YM	Futures	29509.3	29538.7	29500.6	29536.5	5952.0
2019-07-26 15:00:00	YM	Futures	29538.7	29572.4	29526.7	29547.4	12376.0

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

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