PREVIEW / futures_1hour / 2021-08-27

all futures 1-hour files

  file:    by_date/futures_1hour/2021/2021-08-27.parquet
  size:    52 KB
  rows:    1,575

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-27 00:00:00	ES	Futures	5040.6	5042.57	5040.32	5041.45	1772.0
2021-08-27 01:00:00	ES	Futures	5041.45	5042.86	5038.63	5041.73	4043.0
2021-08-27 02:00:00	ES	Futures	5041.73	5047.36	5040.32	5044.83	8869.0
2021-08-27 03:00:00	ES	Futures	5044.55	5050.74	5041.73	5047.36	13561.0
2021-08-27 04:00:00	ES	Futures	5047.36	5047.92	5043.42	5045.39	7673.0
2021-08-27 05:00:00	ES	Futures	5045.67	5048.21	5043.7	5047.08	7164.0
2021-08-27 06:00:00	ES	Futures	5046.8	5047.92	5044.26	5045.11	6702.0
2021-08-27 07:00:00	ES	Futures	5045.11	5046.23	5038.63	5041.45	12557.0
2021-08-27 08:00:00	ES	Futures	5041.45	5046.23	5040.32	5044.83	18305.0
2021-08-27 09:00:00	ES	Futures	5044.83	5050.18	5038.91	5047.36	127572.0
2021-08-27 10:00:00	ES	Futures	5047.64	5071.01	5040.32	5068.48	297704.0
2021-08-27 11:00:00	ES	Futures	5068.2	5072.42	5063.69	5071.3	134817.0
2021-08-27 12:00:00	ES	Futures	5071.3	5074.67	5068.76	5074.67	72267.0
2021-08-27 13:00:00	ES	Futures	5074.39	5077.77	5073.83	5076.36	59159.0
2021-08-27 14:00:00	ES	Futures	5076.36	5076.65	5072.42	5074.39	68286.0
2021-08-27 15:00:00	ES	Futures	5074.39	5079.74	5072.42	5074.11	197228.0
2021-08-27 16:00:00	ES	Futures	5074.11	5078.05	5072.14	5076.93	75593.0
2021-08-27 00:00:00	NQ	Futures	17754.27	17766.73	17753.98	17760.07	1385.0
2021-08-27 01:00:00	NQ	Futures	17760.65	17762.68	17745.87	17749.35	3144.0
2021-08-27 02:00:00	NQ	Futures	17749.06	17771.08	17745.0	17758.04	4363.0
2021-08-27 03:00:00	NQ	Futures	17757.46	17768.76	17746.16	17760.36	5730.0
2021-08-27 04:00:00	NQ	Futures	17760.36	17763.25	17741.82	17754.85	4923.0
2021-08-27 05:00:00	NQ	Futures	17755.14	17762.68	17748.48	17759.49	2898.0
2021-08-27 06:00:00	NQ	Futures	17759.2	17765.28	17753.98	17758.91	2668.0
2021-08-27 07:00:00	NQ	Futures	17758.91	17762.39	17738.34	17743.85	4352.0
2021-08-27 08:00:00	NQ	Futures	17744.14	17767.31	17740.37	17760.65	7189.0
2021-08-27 09:00:00	NQ	Futures	17760.94	17766.15	17710.24	17736.6	61396.0
2021-08-27 10:00:00	NQ	Futures	17736.89	17877.68	17705.32	17843.79	115962.0
2021-08-27 11:00:00	NQ	Futures	17843.79	17864.93	17822.64	17861.17	46066.0
2021-08-27 12:00:00	NQ	Futures	17861.17	17869.86	17848.42	17864.06	28162.0
2021-08-27 13:00:00	NQ	Futures	17864.06	17888.69	17862.62	17883.76	30393.0
2021-08-27 14:00:00	NQ	Futures	17884.05	17886.66	17866.67	17883.18	26895.0
2021-08-27 15:00:00	NQ	Futures	17883.18	17895.06	17869.57	17872.75	60207.0
2021-08-27 16:00:00	NQ	Futures	17873.04	17882.6	17862.33	17877.1	11407.0
2021-08-27 00:00:00	YM	Futures	39337.3	39349.6	39334.0	39345.1	445.0
2021-08-27 01:00:00	YM	Futures	39345.1	39358.6	39328.4	39351.9	967.0
2021-08-27 02:00:00	YM	Futures	39351.9	39399.9	39338.4	39374.2	1944.0
2021-08-27 03:00:00	YM	Futures	39373.1	39437.9	39348.5	39401.0	3247.0
2021-08-27 04:00:00	YM	Futures	39401.0	39405.5	39369.7	39383.1	2179.0
2021-08-27 05:00:00	YM	Futures	39384.3	39409.9	39368.6	39392.1	1546.0
2021-08-27 06:00:00	YM	Futures	39391.0	39399.9	39364.1	39370.8	1745.0
2021-08-27 07:00:00	YM	Futures	39372.0	39382.0	39325.0	39353.0	2311.0
2021-08-27 08:00:00	YM	Futures	39353.0	39388.7	39345.1	39375.3	2669.0
2021-08-27 09:00:00	YM	Futures	39376.4	39424.5	39334.0	39402.1	17306.0
2021-08-27 10:00:00	YM	Futures	39405.5	39571.9	39354.1	39554.1	29604.0
2021-08-27 11:00:00	YM	Futures	39553.0	39565.2	39512.7	39535.1	9533.0
2021-08-27 12:00:00	YM	Futures	39535.1	39556.3	39515.0	39555.2	5918.0
2021-08-27 13:00:00	YM	Futures	39554.1	39578.7	39551.8	39563.0	5761.0
2021-08-27 14:00:00	YM	Futures	39564.1	39565.2	39530.6	39540.7	5472.0
2021-08-27 15:00:00	YM	Futures	39540.7	39582.0	39531.7	39551.8	11095.0

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

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