PREVIEW / futures_1hour / 2020-07-17

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-07-17.parquet
  size:    48 KB
  rows:    1,452

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-07-17 00:00:00	ES	Futures	3578.51	3580.46	3575.71	3577.11	4652.0
2020-07-17 01:00:00	ES	Futures	3576.83	3578.23	3574.88	3577.67	5299.0
2020-07-17 02:00:00	ES	Futures	3577.67	3581.3	3574.32	3576.27	21002.0
2020-07-17 03:00:00	ES	Futures	3576.55	3579.34	3569.29	3569.29	24482.0
2020-07-17 04:00:00	ES	Futures	3569.29	3578.23	3568.73	3576.83	13467.0
2020-07-17 05:00:00	ES	Futures	3576.83	3581.02	3572.64	3577.39	17984.0
2020-07-17 06:00:00	ES	Futures	3577.39	3584.93	3576.55	3584.65	14508.0
2020-07-17 07:00:00	ES	Futures	3584.37	3584.65	3579.9	3583.53	17266.0
2020-07-17 08:00:00	ES	Futures	3583.53	3594.14	3583.25	3587.72	42097.0
2020-07-17 09:00:00	ES	Futures	3587.72	3595.82	3583.81	3588.0	170969.0
2020-07-17 10:00:00	ES	Futures	3588.0	3590.51	3570.41	3584.65	189198.0
2020-07-17 11:00:00	ES	Futures	3584.65	3590.79	3581.3	3588.84	126905.0
2020-07-17 12:00:00	ES	Futures	3589.12	3592.47	3585.77	3586.88	76336.0
2020-07-17 13:00:00	ES	Futures	3587.16	3591.07	3583.53	3587.44	117918.0
2020-07-17 14:00:00	ES	Futures	3587.44	3598.33	3587.16	3596.38	105652.0
2020-07-17 15:00:00	ES	Futures	3596.1	3602.52	3591.63	3592.75	175274.0
2020-07-17 16:00:00	ES	Futures	3592.75	3597.77	3588.56	3589.68	48885.0
2020-07-17 00:00:00	NQ	Futures	12252.78	12262.62	12244.98	12251.05	2538.0
2020-07-17 01:00:00	NQ	Futures	12250.47	12254.81	12232.83	12245.55	3530.0
2020-07-17 02:00:00	NQ	Futures	12245.27	12256.25	12229.36	12239.19	4985.0
2020-07-17 03:00:00	NQ	Futures	12239.19	12260.59	12232.25	12233.99	8496.0
2020-07-17 04:00:00	NQ	Futures	12234.28	12282.28	12221.84	12275.34	9000.0
2020-07-17 05:00:00	NQ	Futures	12275.05	12287.77	12262.33	12268.11	7270.0
2020-07-17 06:00:00	NQ	Futures	12267.53	12286.91	12265.8	12278.23	5001.0
2020-07-17 07:00:00	NQ	Futures	12277.94	12281.12	12255.39	12273.6	7580.0
2020-07-17 08:00:00	NQ	Futures	12273.89	12295.29	12269.56	12282.57	13676.0
2020-07-17 09:00:00	NQ	Futures	12282.86	12328.55	12223.29	12265.51	72360.0
2020-07-17 10:00:00	NQ	Futures	12265.8	12277.65	12188.88	12253.36	72238.0
2020-07-17 11:00:00	NQ	Futures	12253.07	12286.62	12237.75	12276.21	44772.0
2020-07-17 12:00:00	NQ	Futures	12276.5	12296.16	12258.86	12269.56	29249.0
2020-07-17 13:00:00	NQ	Futures	12269.85	12287.2	12247.29	12266.66	34854.0
2020-07-17 14:00:00	NQ	Futures	12267.24	12332.31	12266.66	12318.14	32644.0
2020-07-17 15:00:00	NQ	Futures	12317.85	12341.85	12286.33	12296.16	52811.0
2020-07-17 16:00:00	NQ	Futures	12295.58	12312.64	12282.86	12287.2	9191.0
2020-07-17 00:00:00	YM	Futures	29296.9	29311.2	29267.2	29282.6	1814.0
2020-07-17 01:00:00	YM	Futures	29279.3	29294.7	29263.9	29292.5	1465.0
2020-07-17 02:00:00	YM	Futures	29292.5	29323.4	29257.3	29269.4	3311.0
2020-07-17 03:00:00	YM	Futures	29269.4	29298.0	29214.3	29215.4	5610.0
2020-07-17 04:00:00	YM	Futures	29215.4	29283.7	29207.7	29267.2	4159.0
2020-07-17 05:00:00	YM	Futures	29269.4	29314.5	29229.8	29276.0	4595.0
2020-07-17 06:00:00	YM	Futures	29273.8	29333.3	29268.3	29331.1	2901.0
2020-07-17 07:00:00	YM	Futures	29330.0	29354.2	29288.1	29347.6	4123.0
2020-07-17 08:00:00	YM	Futures	29344.3	29426.9	29343.2	29359.7	7875.0
2020-07-17 09:00:00	YM	Futures	29358.6	29404.8	29294.7	29341.0	21835.0
2020-07-17 10:00:00	YM	Futures	29336.6	29363.0	29182.4	29294.7	23423.0
2020-07-17 11:00:00	YM	Futures	29294.7	29328.9	29232.0	29280.4	11491.0
2020-07-17 12:00:00	YM	Futures	29281.5	29311.2	29250.7	29255.1	6529.0
2020-07-17 13:00:00	YM	Futures	29256.2	29289.2	29233.1	29255.1	11232.0
2020-07-17 14:00:00	YM	Futures	29256.2	29313.4	29252.9	29269.4	8432.0
2020-07-17 15:00:00	YM	Futures	29269.4	29302.4	29224.3	29246.3	16379.0

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

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