PREVIEW / futures_1hour / 2021-07-06

all futures 1-hour files

  file:    by_date/futures_1hour/2021/2021-07-06.parquet
  size:    63 KB
  rows:    1,899

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-07-06 00:00:00	ES	Futures	4890.8	4892.21	4890.24	4890.52	1828.0
2021-07-06 01:00:00	ES	Futures	4890.8	4892.49	4887.7	4888.55	5279.0
2021-07-06 02:00:00	ES	Futures	4888.83	4892.21	4886.58	4891.08	7287.0
2021-07-06 03:00:00	ES	Futures	4891.08	4891.36	4884.61	4887.99	19200.0
2021-07-06 04:00:00	ES	Futures	4887.99	4889.96	4885.45	4888.83	10189.0
2021-07-06 05:00:00	ES	Futures	4888.55	4889.96	4886.01	4889.68	8802.0
2021-07-06 06:00:00	ES	Futures	4889.68	4891.36	4887.14	4887.99	10623.0
2021-07-06 07:00:00	ES	Futures	4887.99	4891.93	4887.14	4889.11	14080.0
2021-07-06 08:00:00	ES	Futures	4889.11	4891.65	4886.86	4890.8	14614.0
2021-07-06 09:00:00	ES	Futures	4890.52	4894.74	4881.79	4882.92	122995.0
2021-07-06 10:00:00	ES	Futures	4882.64	4884.04	4860.67	4860.67	231867.0
2021-07-06 11:00:00	ES	Futures	4860.95	4866.02	4854.48	4862.36	180822.0
2021-07-06 12:00:00	ES	Futures	4862.08	4862.36	4849.13	4860.95	163244.0
2021-07-06 13:00:00	ES	Futures	4860.95	4869.96	4859.55	4869.12	114881.0
2021-07-06 14:00:00	ES	Futures	4869.12	4877.0	4868.27	4873.34	91979.0
2021-07-06 15:00:00	ES	Futures	4873.34	4885.45	4872.78	4882.07	172839.0
2021-07-06 16:00:00	ES	Futures	4882.07	4882.92	4874.19	4875.03	41196.0
2021-07-06 18:00:00	ES	Futures	4874.75	4877.85	4874.19	4876.72	4013.0
2021-07-06 19:00:00	ES	Futures	4876.72	4877.29	4872.78	4874.47	3730.0
2021-07-06 20:00:00	ES	Futures	4874.47	4877.85	4871.65	4877.0	10306.0
2021-07-06 21:00:00	ES	Futures	4877.0	4880.66	4875.6	4878.98	7345.0
2021-07-06 22:00:00	ES	Futures	4878.69	4879.82	4876.72	4878.98	4081.0
2021-07-06 23:00:00	ES	Futures	4878.98	4881.51	4878.41	4880.1	3631.0
2021-07-06 00:00:00	NQ	Futures	17016.17	17026.6	17015.01	17017.62	1589.0
2021-07-06 01:00:00	NQ	Futures	17018.19	17026.31	17011.24	17017.62	2430.0
2021-07-06 02:00:00	NQ	Futures	17017.33	17039.05	17012.98	17033.84	4710.0
2021-07-06 03:00:00	NQ	Futures	17033.84	17034.13	16999.65	17031.52	10657.0
2021-07-06 04:00:00	NQ	Futures	17031.23	17043.69	17022.54	17032.97	5143.0
2021-07-06 05:00:00	NQ	Futures	17032.68	17047.16	17028.33	17045.13	4198.0
2021-07-06 06:00:00	NQ	Futures	17045.13	17071.79	17038.76	17053.54	8232.0
2021-07-06 07:00:00	NQ	Futures	17052.96	17083.95	17052.38	17071.79	8107.0
2021-07-06 08:00:00	NQ	Futures	17071.21	17088.01	17066.57	17077.0	8108.0
2021-07-06 09:00:00	NQ	Futures	17077.0	17118.71	17070.34	17095.25	64701.0
2021-07-06 10:00:00	NQ	Futures	17094.96	17137.54	17050.35	17069.18	95981.0
2021-07-06 11:00:00	NQ	Futures	17070.05	17097.86	17035.29	17057.3	66548.0
2021-07-06 12:00:00	NQ	Futures	17057.01	17057.01	16946.64	17034.71	72822.0
2021-07-06 13:00:00	NQ	Futures	17034.13	17080.77	17027.75	17073.52	37711.0
2021-07-06 14:00:00	NQ	Futures	17073.23	17098.15	17065.12	17086.56	33462.0
2021-07-06 15:00:00	NQ	Futures	17086.85	17130.59	17082.21	17121.9	48212.0
2021-07-06 16:00:00	NQ	Futures	17121.9	17123.93	17101.62	17107.13	9701.0
2021-07-06 18:00:00	NQ	Futures	17108.0	17117.56	17103.36	17109.44	2374.0
2021-07-06 19:00:00	NQ	Futures	17109.44	17112.63	17099.31	17108.29	1837.0
2021-07-06 20:00:00	NQ	Futures	17108.0	17116.11	17095.83	17111.76	3267.0
2021-07-06 21:00:00	NQ	Futures	17111.76	17134.07	17106.55	17127.4	3449.0
2021-07-06 22:00:00	NQ	Futures	17126.54	17135.81	17122.77	17133.49	2166.0
2021-07-06 23:00:00	NQ	Futures	17133.49	17146.52	17130.88	17136.09	3134.0
2021-07-06 00:00:00	YM	Futures	38796.6	38803.3	38786.5	38792.1	554.0
2021-07-06 01:00:00	YM	Futures	38793.2	38803.3	38759.7	38770.9	1149.0
2021-07-06 02:00:00	YM	Futures	38770.9	38792.1	38750.8	38780.9	1640.0
2021-07-06 03:00:00	YM	Futures	38780.9	38791.0	38719.5	38735.1	3995.0

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

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