PREVIEW / futures_1hour / 2021-09-13

all futures 1-hour files

  file:    by_date/futures_1hour/2021/2021-09-13.parquet
  size:    61 KB
  rows:    1,909

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-09-13 00:00:00	ES	Futures	5029.9	5031.31	5027.65	5028.21	2125.0
2021-09-13 01:00:00	ES	Futures	5028.5	5032.44	5018.92	5032.44	7672.0
2021-09-13 02:00:00	ES	Futures	5032.44	5043.14	5031.87	5040.32	7079.0
2021-09-13 03:00:00	ES	Futures	5040.32	5046.23	5039.76	5042.01	8250.0
2021-09-13 04:00:00	ES	Futures	5042.01	5046.8	5041.17	5043.14	5581.0
2021-09-13 05:00:00	ES	Futures	5043.14	5045.11	5041.73	5044.83	4109.0
2021-09-13 06:00:00	ES	Futures	5044.83	5052.99	5044.83	5051.02	5981.0
2021-09-13 07:00:00	ES	Futures	5051.02	5051.3	5046.52	5049.33	5985.0
2021-09-13 08:00:00	ES	Futures	5049.33	5054.96	5047.92	5054.68	10579.0
2021-09-13 09:00:00	ES	Futures	5054.68	5060.31	5035.82	5040.88	98110.0
2021-09-13 10:00:00	ES	Futures	5040.88	5043.7	5021.17	5034.97	93913.0
2021-09-13 11:00:00	ES	Futures	5034.97	5036.94	5014.13	5020.33	61745.0
2021-09-13 12:00:00	ES	Futures	5020.33	5029.62	5017.23	5027.93	38424.0
2021-09-13 13:00:00	ES	Futures	5028.21	5031.31	5012.73	5014.98	34242.0
2021-09-13 14:00:00	ES	Futures	5014.7	5019.48	5006.25	5014.7	44289.0
2021-09-13 15:00:00	ES	Futures	5014.42	5034.41	5006.25	5033.85	85016.0
2021-09-13 16:00:00	ES	Futures	5033.56	5042.57	5033.0	5041.45	16576.0
2021-09-13 18:00:00	ES	Futures	5040.88	5043.98	5038.63	5042.57	1525.0
2021-09-13 19:00:00	ES	Futures	5042.57	5043.98	5039.48	5041.17	1070.0
2021-09-13 20:00:00	ES	Futures	5041.45	5042.57	5037.51	5041.17	1726.0
2021-09-13 21:00:00	ES	Futures	5041.45	5047.08	5041.17	5044.55	2519.0
2021-09-13 22:00:00	ES	Futures	5044.83	5046.23	5039.76	5041.17	1875.0
2021-09-13 23:00:00	ES	Futures	5040.88	5044.26	5039.76	5043.98	866.0
2021-09-13 00:00:00	NQ	Futures	17902.01	17907.81	17897.38	17904.04	1145.0
2021-09-13 01:00:00	NQ	Futures	17905.2	17906.65	17859.72	17905.78	5315.0
2021-09-13 02:00:00	NQ	Futures	17905.2	17948.65	17904.04	17939.96	3920.0
2021-09-13 03:00:00	NQ	Futures	17939.96	17955.6	17937.35	17941.41	3444.0
2021-09-13 04:00:00	NQ	Futures	17941.7	17971.83	17939.96	17962.56	3754.0
2021-09-13 05:00:00	NQ	Futures	17962.27	17968.93	17957.92	17964.58	1528.0
2021-09-13 06:00:00	NQ	Futures	17964.58	17990.65	17963.71	17988.34	2767.0
2021-09-13 07:00:00	NQ	Futures	17987.76	17991.52	17972.4	17982.83	2531.0
2021-09-13 08:00:00	NQ	Futures	17983.12	18004.27	17977.91	18002.24	4446.0
2021-09-13 09:00:00	NQ	Futures	18002.53	18035.56	17885.79	17897.96	45396.0
2021-09-13 10:00:00	NQ	Futures	17897.96	17910.41	17804.39	17875.07	56034.0
2021-09-13 11:00:00	NQ	Futures	17875.36	17893.61	17789.33	17815.69	35064.0
2021-09-13 12:00:00	NQ	Futures	17815.11	17899.12	17802.65	17893.03	18995.0
2021-09-13 13:00:00	NQ	Futures	17893.61	17903.75	17821.19	17831.62	15421.0
2021-09-13 14:00:00	NQ	Futures	17832.2	17849.29	17793.09	17823.51	16639.0
2021-09-13 15:00:00	NQ	Futures	17822.93	17890.42	17786.72	17887.82	24177.0
2021-09-13 16:00:00	NQ	Futures	17888.11	17912.15	17886.95	17905.78	3941.0
2021-09-13 18:00:00	NQ	Futures	17904.91	17912.44	17895.35	17906.94	1150.0
2021-09-13 19:00:00	NQ	Futures	17906.94	17916.5	17900.27	17904.91	1050.0
2021-09-13 20:00:00	NQ	Futures	17904.04	17907.52	17891.0	17900.85	1320.0
2021-09-13 21:00:00	NQ	Futures	17901.14	17924.61	17897.67	17917.65	1600.0
2021-09-13 22:00:00	NQ	Futures	17917.37	17925.19	17901.72	17905.2	1199.0
2021-09-13 23:00:00	NQ	Futures	17905.2	17915.92	17899.98	17914.18	887.0
2021-09-13 00:00:00	YM	Futures	38748.6	38758.7	38718.4	38729.6	786.0
2021-09-13 01:00:00	YM	Futures	38729.6	38772.2	38651.1	38771.1	2874.0
2021-09-13 02:00:00	YM	Futures	38772.2	38845.0	38767.7	38821.5	3500.0
2021-09-13 03:00:00	YM	Futures	38822.6	38873.1	38813.7	38841.7	3434.0

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

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