PREVIEW / futures_1hour / 2021-06-14

all futures 1-hour files

  file:    by_date/futures_1hour/2021/2021-06-14.parquet
  size:    59 KB
  rows:    1,886

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
2021-06-14 00:00:00	ES	Futures	4776.2	4777.32	4775.35	4775.63	1930.0
2021-06-14 01:00:00	ES	Futures	4775.63	4776.76	4775.07	4775.63	1927.0
2021-06-14 02:00:00	ES	Futures	4775.63	4778.17	4773.38	4777.61	5538.0
2021-06-14 03:00:00	ES	Futures	4777.61	4784.08	4774.51	4776.76	19775.0
2021-06-14 04:00:00	ES	Futures	4776.76	4777.04	4773.1	4775.63	10903.0
2021-06-14 05:00:00	ES	Futures	4775.63	4777.89	4773.1	4777.04	8661.0
2021-06-14 06:00:00	ES	Futures	4776.76	4777.89	4774.51	4775.35	8499.0
2021-06-14 07:00:00	ES	Futures	4775.35	4778.17	4770.85	4773.1	12876.0
2021-06-14 08:00:00	ES	Futures	4773.1	4775.63	4768.31	4771.41	17984.0
2021-06-14 09:00:00	ES	Futures	4771.41	4773.38	4764.93	4767.47	113568.0
2021-06-14 10:00:00	ES	Futures	4767.47	4768.31	4759.58	4765.5	140920.0
2021-06-14 11:00:00	ES	Futures	4765.5	4768.03	4759.58	4761.56	90682.0
2021-06-14 12:00:00	ES	Futures	4761.56	4763.81	4758.18	4759.02	70178.0
2021-06-14 13:00:00	ES	Futures	4759.02	4762.68	4758.18	4760.71	51279.0
2021-06-14 14:00:00	ES	Futures	4760.71	4763.81	4758.74	4762.96	58432.0
2021-06-14 15:00:00	ES	Futures	4762.96	4784.08	4761.84	4783.8	166025.0
2021-06-14 16:00:00	ES	Futures	4783.8	4785.21	4780.98	4782.67	58954.0
2021-06-14 18:00:00	ES	Futures	4782.67	4782.67	4779.29	4780.7	3937.0
2021-06-14 19:00:00	ES	Futures	4780.7	4782.96	4780.14	4780.42	4441.0
2021-06-14 20:00:00	ES	Futures	4780.42	4789.43	4780.14	4788.02	14175.0
2021-06-14 21:00:00	ES	Futures	4788.31	4791.68	4786.05	4786.62	10858.0
2021-06-14 22:00:00	ES	Futures	4786.62	4789.43	4784.93	4787.74	6126.0
2021-06-14 23:00:00	ES	Futures	4787.74	4791.4	4786.62	4790.28	4814.0
2021-06-14 00:00:00	NQ	Futures	16233.74	16238.66	16231.42	16233.45	769.0
2021-06-14 01:00:00	NQ	Futures	16232.87	16236.63	16232.0	16232.29	797.0
2021-06-14 02:00:00	NQ	Futures	16232.58	16236.92	16222.73	16235.77	2446.0
2021-06-14 03:00:00	NQ	Futures	16235.48	16255.17	16227.94	16232.58	5446.0
2021-06-14 04:00:00	NQ	Futures	16232.58	16245.9	16225.92	16243.01	3098.0
2021-06-14 05:00:00	NQ	Futures	16243.59	16250.83	16238.66	16247.64	2715.0
2021-06-14 06:00:00	NQ	Futures	16247.35	16265.02	16241.27	16260.68	3799.0
2021-06-14 07:00:00	NQ	Futures	16260.39	16272.27	16248.22	16256.33	4867.0
2021-06-14 08:00:00	NQ	Futures	16256.04	16259.52	16225.92	16234.32	5818.0
2021-06-14 09:00:00	NQ	Futures	16234.61	16265.6	16172.33	16246.48	54529.0
2021-06-14 10:00:00	NQ	Futures	16246.77	16251.7	16199.56	16236.92	48770.0
2021-06-14 11:00:00	NQ	Futures	16236.63	16262.42	16229.97	16259.81	29897.0
2021-06-14 12:00:00	NQ	Futures	16259.81	16285.01	16255.46	16268.79	25697.0
2021-06-14 13:00:00	NQ	Futures	16269.08	16297.18	16264.44	16290.52	19938.0
2021-06-14 14:00:00	NQ	Futures	16290.52	16297.18	16278.06	16286.46	16749.0
2021-06-14 15:00:00	NQ	Futures	16285.88	16365.25	16273.71	16365.25	46495.0
2021-06-14 16:00:00	NQ	Futures	16364.96	16368.15	16347.0	16349.32	10300.0
2021-06-14 18:00:00	NQ	Futures	16350.77	16355.98	16341.79	16349.03	1925.0
2021-06-14 19:00:00	NQ	Futures	16349.32	16355.4	16344.98	16345.55	1526.0
2021-06-14 20:00:00	NQ	Futures	16346.13	16393.06	16345.27	16386.69	5336.0
2021-06-14 21:00:00	NQ	Futures	16386.69	16402.04	16371.34	16373.36	4621.0
2021-06-14 22:00:00	NQ	Futures	16373.65	16384.95	16363.23	16375.39	4249.0
2021-06-14 23:00:00	NQ	Futures	16375.1	16385.82	16371.63	16378.58	2032.0
2021-06-14 00:00:00	YM	Futures	38416.7	38424.5	38403.3	38407.8	411.0
2021-06-14 01:00:00	YM	Futures	38407.8	38415.6	38404.4	38408.9	434.0
2021-06-14 02:00:00	YM	Futures	38408.9	38436.8	38391.0	38427.9	1055.0
2021-06-14 03:00:00	YM	Futures	38430.1	38492.7	38404.4	38430.1	3995.0

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

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