PREVIEW / futures_1hour / 2020-01-17

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-01-17.parquet
  size:    49 KB
  rows:    1,502

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
2020-01-17 00:00:00	ES	Futures	3596.0	3597.7	3595.8	3597.4	3582.0
2020-01-17 01:00:00	ES	Futures	3597.7	3598.2	3596.3	3597.1	5484.0
2020-01-17 02:00:00	ES	Futures	3597.1	3600.1	3597.1	3599.8	9281.0
2020-01-17 03:00:00	ES	Futures	3599.6	3604.2	3599.6	3602.3	23346.0
2020-01-17 04:00:00	ES	Futures	3602.0	3604.4	3601.2	3603.4	16413.0
2020-01-17 05:00:00	ES	Futures	3603.4	3606.3	3603.1	3603.6	18307.0
2020-01-17 06:00:00	ES	Futures	3603.6	3604.4	3602.5	3604.2	11323.0
2020-01-17 07:00:00	ES	Futures	3604.2	3604.4	3601.5	3602.8	16512.0
2020-01-17 08:00:00	ES	Futures	3602.8	3608.2	3602.3	3604.4	53984.0
2020-01-17 09:00:00	ES	Futures	3604.4	3606.3	3598.8	3604.4	224177.0
2020-01-17 10:00:00	ES	Futures	3604.2	3605.8	3600.4	3602.0	163194.0
2020-01-17 11:00:00	ES	Futures	3602.3	3603.9	3597.7	3602.8	134767.0
2020-01-17 12:00:00	ES	Futures	3603.1	3605.8	3602.0	3602.5	61486.0
2020-01-17 13:00:00	ES	Futures	3602.5	3605.5	3602.3	3603.9	48173.0
2020-01-17 14:00:00	ES	Futures	3604.2	3605.5	3602.3	3604.7	56970.0
2020-01-17 15:00:00	ES	Futures	3604.7	3609.9	3600.1	3607.7	237007.0
2020-01-17 16:00:00	ES	Futures	3607.7	3608.0	3602.0	3602.8	76062.0
2020-01-17 00:00:00	NQ	Futures	10566.97	10573.33	10565.52	10571.02	2654.0
2020-01-17 01:00:00	NQ	Futures	10571.31	10573.62	10566.68	10571.6	2694.0
2020-01-17 02:00:00	NQ	Futures	10571.6	10580.56	10571.6	10579.69	3413.0
2020-01-17 03:00:00	NQ	Futures	10579.69	10598.78	10578.25	10589.81	10558.0
2020-01-17 04:00:00	NQ	Futures	10590.1	10603.12	10586.92	10598.78	7844.0
2020-01-17 05:00:00	NQ	Futures	10598.78	10609.77	10597.91	10605.72	8065.0
2020-01-17 06:00:00	NQ	Futures	10605.43	10608.9	10601.09	10608.61	5226.0
2020-01-17 07:00:00	NQ	Futures	10608.61	10608.61	10595.6	10601.09	6401.0
2020-01-17 08:00:00	NQ	Futures	10601.09	10619.89	10600.22	10612.08	18586.0
2020-01-17 09:00:00	NQ	Futures	10612.08	10625.38	10572.17	10593.0	85952.0
2020-01-17 10:00:00	NQ	Futures	10593.0	10601.09	10577.09	10582.01	57577.0
2020-01-17 11:00:00	NQ	Futures	10582.01	10588.95	10560.61	10579.69	54361.0
2020-01-17 12:00:00	NQ	Futures	10579.98	10592.71	10575.07	10580.27	27119.0
2020-01-17 13:00:00	NQ	Futures	10580.27	10596.75	10579.69	10595.02	20833.0
2020-01-17 14:00:00	NQ	Futures	10594.73	10599.65	10585.77	10594.44	20809.0
2020-01-17 15:00:00	NQ	Futures	10594.73	10629.14	10580.56	10621.33	58893.0
2020-01-17 16:00:00	NQ	Futures	10621.05	10621.91	10605.72	10608.9	12611.0
2020-01-17 00:00:00	YM	Futures	31869.7	31886.0	31866.4	31884.9	1309.0
2020-01-17 01:00:00	YM	Futures	31884.9	31889.3	31876.2	31880.6	1034.0
2020-01-17 02:00:00	YM	Futures	31881.6	31907.8	31881.6	31907.8	2179.0
2020-01-17 03:00:00	YM	Futures	31907.8	31943.7	31904.5	31924.1	6393.0
2020-01-17 04:00:00	YM	Futures	31925.2	31927.4	31899.1	31920.8	4290.0
2020-01-17 05:00:00	YM	Futures	31920.8	31941.5	31910.0	31918.7	3820.0
2020-01-17 06:00:00	YM	Futures	31918.7	31929.5	31907.8	31923.0	2210.0
2020-01-17 07:00:00	YM	Futures	31923.0	31923.0	31895.8	31905.6	2955.0
2020-01-17 08:00:00	YM	Futures	31906.7	31967.7	31898.0	31932.8	9385.0
2020-01-17 09:00:00	YM	Futures	31932.8	31945.9	31872.9	31923.0	32608.0
2020-01-17 10:00:00	YM	Futures	31923.0	31939.3	31881.6	31903.4	22819.0
2020-01-17 11:00:00	YM	Futures	31904.5	31918.7	31849.0	31893.6	18314.0
2020-01-17 12:00:00	YM	Futures	31894.7	31923.0	31884.9	31887.1	9310.0
2020-01-17 13:00:00	YM	Futures	31887.1	31904.5	31867.5	31887.1	8439.0
2020-01-17 14:00:00	YM	Futures	31887.1	31900.2	31871.8	31892.5	8512.0
2020-01-17 15:00:00	YM	Futures	31891.4	31918.7	31854.4	31902.3	20665.0

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

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