PREVIEW / futures_1hour / 2019-10-30

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-10-30.parquet
  size:    59 KB
  rows:    1,873

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-10-30 00:00:00	ES	Futures	3295.7	3296.24	3294.61	3295.43	2953.0
2019-10-30 01:00:00	ES	Futures	3295.7	3297.06	3295.43	3296.24	3318.0
2019-10-30 02:00:00	ES	Futures	3295.97	3296.51	3294.88	3296.24	4004.0
2019-10-30 03:00:00	ES	Futures	3296.51	3297.06	3295.16	3297.06	4634.0
2019-10-30 04:00:00	ES	Futures	3297.33	3298.69	3295.43	3296.24	11911.0
2019-10-30 05:00:00	ES	Futures	3296.24	3297.6	3295.16	3296.79	7240.0
2019-10-30 06:00:00	ES	Futures	3296.51	3298.96	3296.24	3298.14	8959.0
2019-10-30 07:00:00	ES	Futures	3298.14	3300.86	3297.87	3299.77	10575.0
2019-10-30 08:00:00	ES	Futures	3299.77	3301.67	3298.14	3300.59	21722.0
2019-10-30 09:00:00	ES	Futures	3300.59	3301.95	3292.44	3294.61	118367.0
2019-10-30 10:00:00	ES	Futures	3294.61	3297.06	3284.83	3296.51	196654.0
2019-10-30 11:00:00	ES	Futures	3296.51	3297.06	3291.08	3293.53	76802.0
2019-10-30 12:00:00	ES	Futures	3293.53	3297.87	3293.25	3294.88	71667.0
2019-10-30 13:00:00	ES	Futures	3295.16	3296.51	3288.91	3290.27	67920.0
2019-10-30 14:00:00	ES	Futures	3290.81	3304.66	3286.73	3303.03	216488.0
2019-10-30 15:00:00	ES	Futures	3303.03	3312.81	3302.49	3308.47	200946.0
2019-10-30 16:00:00	ES	Futures	3308.74	3319.33	3307.65	3314.44	89951.0
2019-10-30 18:00:00	ES	Futures	3315.8	3316.07	3312.0	3312.54	7599.0
2019-10-30 19:00:00	ES	Futures	3312.54	3313.35	3311.45	3312.27	4117.0
2019-10-30 20:00:00	ES	Futures	3312.54	3313.9	3311.18	3312.81	9567.0
2019-10-30 21:00:00	ES	Futures	3313.08	3313.08	3308.74	3309.55	13007.0
2019-10-30 22:00:00	ES	Futures	3309.82	3310.1	3307.92	3309.82	5494.0
2019-10-30 23:00:00	ES	Futures	3310.1	3312.27	3309.55	3311.18	5398.0
2019-10-30 00:00:00	NQ	Futures	9357.05	9358.79	9352.98	9357.63	1705.0
2019-10-30 01:00:00	NQ	Futures	9357.63	9362.57	9357.05	9359.66	1429.0
2019-10-30 02:00:00	NQ	Futures	9359.66	9360.53	9352.98	9357.34	1800.0
2019-10-30 03:00:00	NQ	Futures	9357.05	9359.08	9350.95	9358.5	2358.0
2019-10-30 04:00:00	NQ	Futures	9358.5	9362.57	9352.98	9356.76	4223.0
2019-10-30 05:00:00	NQ	Futures	9356.47	9360.53	9352.4	9358.5	2676.0
2019-10-30 06:00:00	NQ	Futures	9358.5	9364.31	9356.47	9363.73	2885.0
2019-10-30 07:00:00	NQ	Futures	9363.73	9377.67	9362.86	9374.19	5537.0
2019-10-30 08:00:00	NQ	Futures	9374.48	9383.19	9368.09	9378.25	9302.0
2019-10-30 09:00:00	NQ	Futures	9377.96	9382.61	9341.65	9355.89	50733.0
2019-10-30 10:00:00	NQ	Futures	9355.6	9374.77	9319.57	9373.02	67714.0
2019-10-30 11:00:00	NQ	Futures	9373.02	9373.61	9343.39	9354.14	31318.0
2019-10-30 12:00:00	NQ	Futures	9353.85	9364.02	9348.62	9352.4	21978.0
2019-10-30 13:00:00	NQ	Futures	9352.4	9363.73	9337.0	9342.23	19202.0
2019-10-30 14:00:00	NQ	Futures	9341.36	9391.33	9328.29	9387.55	71136.0
2019-10-30 15:00:00	NQ	Futures	9387.26	9418.34	9385.81	9398.88	48467.0
2019-10-30 16:00:00	NQ	Futures	9398.88	9459.59	9398.01	9433.16	22803.0
2019-10-30 18:00:00	NQ	Futures	9445.07	9450.88	9433.16	9436.35	3887.0
2019-10-30 19:00:00	NQ	Futures	9436.06	9439.55	9432.29	9438.68	1279.0
2019-10-30 20:00:00	NQ	Futures	9439.26	9444.2	9435.77	9440.71	3055.0
2019-10-30 21:00:00	NQ	Futures	9440.71	9441.0	9427.35	9430.25	3971.0
2019-10-30 22:00:00	NQ	Futures	9430.54	9433.16	9423.86	9431.41	2158.0
2019-10-30 23:00:00	NQ	Futures	9431.41	9437.8	9429.38	9434.03	2009.0
2019-10-30 00:00:00	YM	Futures	29406.2	29408.4	29394.2	29405.1	756.0
2019-10-30 01:00:00	YM	Futures	29405.1	29417.1	29404.0	29411.6	776.0
2019-10-30 02:00:00	YM	Futures	29410.5	29413.8	29400.7	29411.6	909.0
2019-10-30 03:00:00	YM	Futures	29410.5	29421.4	29402.9	29421.4	985.0

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

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