PREVIEW / futures_1hour / 2021-08-31

all futures 1-hour files

  file:    by_date/futures_1hour/2021/2021-08-31.parquet
  size:    63 KB
  rows:    1,923

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-08-31 00:00:00	ES	Futures	5103.11	5111.0	5102.55	5110.44	7031.0
2021-08-31 01:00:00	ES	Futures	5110.44	5113.81	5109.31	5113.25	11680.0
2021-08-31 02:00:00	ES	Futures	5113.25	5116.07	5112.41	5113.25	12997.0
2021-08-31 03:00:00	ES	Futures	5113.25	5113.81	5109.87	5110.15	18542.0
2021-08-31 04:00:00	ES	Futures	5110.15	5111.28	5107.62	5108.46	15450.0
2021-08-31 05:00:00	ES	Futures	5108.75	5110.15	5105.09	5105.65	12254.0
2021-08-31 06:00:00	ES	Futures	5105.65	5107.06	5093.54	5095.79	32710.0
2021-08-31 07:00:00	ES	Futures	5095.79	5100.3	5093.26	5094.95	31320.0
2021-08-31 08:00:00	ES	Futures	5094.95	5096.07	5086.5	5093.54	42914.0
2021-08-31 09:00:00	ES	Futures	5093.54	5098.61	5082.56	5085.09	158986.0
2021-08-31 10:00:00	ES	Futures	5085.09	5096.36	5083.97	5096.07	182640.0
2021-08-31 11:00:00	ES	Futures	5096.07	5100.58	5091.29	5098.89	110378.0
2021-08-31 12:00:00	ES	Futures	5098.89	5100.3	5096.36	5098.33	63641.0
2021-08-31 13:00:00	ES	Futures	5098.33	5098.33	5088.19	5093.54	89920.0
2021-08-31 14:00:00	ES	Futures	5093.26	5094.1	5087.63	5093.26	80538.0
2021-08-31 15:00:00	ES	Futures	5093.54	5095.51	5085.94	5091.29	337959.0
2021-08-31 16:00:00	ES	Futures	5091.29	5100.58	5090.72	5100.02	86135.0
2021-08-31 18:00:00	ES	Futures	5099.74	5100.86	5097.48	5098.61	4406.0
2021-08-31 19:00:00	ES	Futures	5098.61	5100.58	5097.2	5100.58	3845.0
2021-08-31 20:00:00	ES	Futures	5100.58	5101.71	5095.23	5096.92	11790.0
2021-08-31 21:00:00	ES	Futures	5096.64	5101.71	5095.79	5101.43	6183.0
2021-08-31 22:00:00	ES	Futures	5101.71	5105.65	5101.71	5105.37	8868.0
2021-08-31 23:00:00	ES	Futures	5105.37	5107.06	5104.24	5104.8	6480.0
2021-08-31 00:00:00	NQ	Futures	18087.41	18129.41	18084.22	18125.94	4262.0
2021-08-31 01:00:00	NQ	Futures	18125.94	18152.88	18122.17	18140.42	7982.0
2021-08-31 02:00:00	NQ	Futures	18140.71	18165.62	18135.78	18155.77	6638.0
2021-08-31 03:00:00	NQ	Futures	18156.35	18157.8	18137.52	18138.68	6330.0
2021-08-31 04:00:00	NQ	Futures	18138.39	18151.43	18128.83	18136.94	5383.0
2021-08-31 05:00:00	NQ	Futures	18136.94	18138.68	18106.53	18113.77	5259.0
2021-08-31 06:00:00	NQ	Futures	18113.48	18118.4	18043.09	18055.25	12392.0
2021-08-31 07:00:00	NQ	Futures	18055.25	18093.78	18048.88	18072.34	13378.0
2021-08-31 08:00:00	NQ	Futures	18072.34	18078.43	18033.24	18059.31	17262.0
2021-08-31 09:00:00	NQ	Futures	18059.02	18093.2	17987.18	17989.5	92623.0
2021-08-31 10:00:00	NQ	Futures	17989.21	18039.61	17980.81	18028.31	77195.0
2021-08-31 11:00:00	NQ	Futures	18028.31	18060.18	18003.11	18054.09	55047.0
2021-08-31 12:00:00	NQ	Futures	18054.09	18073.5	18035.84	18072.34	40086.0
2021-08-31 13:00:00	NQ	Futures	18072.05	18074.08	18033.82	18060.18	34389.0
2021-08-31 14:00:00	NQ	Futures	18060.18	18078.43	18049.75	18074.95	34472.0
2021-08-31 15:00:00	NQ	Futures	18075.24	18080.46	18037.58	18058.15	70616.0
2021-08-31 16:00:00	NQ	Futures	18057.57	18080.75	18054.38	18075.53	14454.0
2021-08-31 18:00:00	NQ	Futures	18075.53	18079.3	18065.39	18068.0	2255.0
2021-08-31 19:00:00	NQ	Futures	18068.0	18074.08	18061.63	18072.63	1781.0
2021-08-31 20:00:00	NQ	Futures	18072.34	18077.27	18052.94	18055.83	3736.0
2021-08-31 21:00:00	NQ	Futures	18055.83	18076.98	18051.2	18075.24	3947.0
2021-08-31 22:00:00	NQ	Futures	18075.53	18088.57	18074.95	18086.25	4663.0
2021-08-31 23:00:00	NQ	Futures	18086.25	18097.84	18085.38	18090.02	3780.0
2021-08-31 00:00:00	YM	Futures	39550.7	39601.0	39544.0	39595.4	1467.0
2021-08-31 01:00:00	YM	Futures	39595.4	39617.8	39583.1	39615.5	2075.0
2021-08-31 02:00:00	YM	Futures	39615.5	39653.5	39599.9	39608.8	3501.0
2021-08-31 03:00:00	YM	Futures	39608.8	39613.3	39583.1	39588.7	3849.0

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

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