PREVIEW / futures_1hour / 2021-11-04

all futures 1-hour files

  file:    by_date/futures_1hour/2021/2021-11-04.parquet
  size:    66 KB
  rows:    2,010

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-11-04 00:00:00	ES	Futures	5251.41	5254.23	5251.13	5252.54	2580.0
2021-11-04 01:00:00	ES	Futures	5252.54	5253.67	5250.56	5250.84	5344.0
2021-11-04 02:00:00	ES	Futures	5250.84	5255.08	5250.28	5253.67	5756.0
2021-11-04 03:00:00	ES	Futures	5253.67	5256.77	5253.1	5255.08	5960.0
2021-11-04 04:00:00	ES	Futures	5254.79	5263.26	5254.51	5255.92	23867.0
2021-11-04 05:00:00	ES	Futures	5256.21	5258.18	5254.79	5256.49	8623.0
2021-11-04 06:00:00	ES	Futures	5256.77	5260.16	5254.79	5259.59	9234.0
2021-11-04 07:00:00	ES	Futures	5259.59	5260.72	5256.77	5257.33	14484.0
2021-11-04 08:00:00	ES	Futures	5257.62	5262.98	5255.92	5258.75	30562.0
2021-11-04 09:00:00	ES	Futures	5258.46	5272.29	5254.23	5269.75	156138.0
2021-11-04 10:00:00	ES	Futures	5269.75	5277.09	5268.06	5271.45	141112.0
2021-11-04 11:00:00	ES	Futures	5271.16	5271.45	5256.49	5268.34	165883.0
2021-11-04 12:00:00	ES	Futures	5268.34	5271.45	5262.13	5264.95	92296.0
2021-11-04 13:00:00	ES	Futures	5265.24	5270.32	5259.87	5269.47	86404.0
2021-11-04 14:00:00	ES	Futures	5269.19	5269.75	5261.0	5263.26	89298.0
2021-11-04 15:00:00	ES	Futures	5263.26	5276.81	5260.44	5276.24	195300.0
2021-11-04 16:00:00	ES	Futures	5275.96	5278.78	5272.57	5274.83	55013.0
2021-11-04 18:00:00	ES	Futures	5273.7	5278.5	5271.16	5277.09	5536.0
2021-11-04 19:00:00	ES	Futures	5277.09	5280.19	5275.11	5279.63	4685.0
2021-11-04 20:00:00	ES	Futures	5279.63	5280.19	5272.57	5274.83	8280.0
2021-11-04 21:00:00	ES	Futures	5274.83	5276.24	5270.6	5271.73	7573.0
2021-11-04 22:00:00	ES	Futures	5271.45	5275.96	5270.88	5274.55	3979.0
2021-11-04 23:00:00	ES	Futures	5274.55	5275.96	5272.57	5275.11	3518.0
2021-11-04 00:00:00	NQ	Futures	18730.3	18741.61	18729.43	18735.52	1161.0
2021-11-04 01:00:00	NQ	Futures	18735.81	18749.43	18731.75	18735.81	1959.0
2021-11-04 02:00:00	NQ	Futures	18735.81	18748.56	18730.88	18742.48	1990.0
2021-11-04 03:00:00	NQ	Futures	18743.05	18752.33	18741.32	18747.11	1978.0
2021-11-04 04:00:00	NQ	Futures	18747.4	18798.7	18745.95	18766.24	10584.0
2021-11-04 05:00:00	NQ	Futures	18765.66	18777.54	18762.47	18772.04	3645.0
2021-11-04 06:00:00	NQ	Futures	18771.17	18786.82	18766.53	18783.34	3302.0
2021-11-04 07:00:00	NQ	Futures	18783.05	18783.92	18760.73	18768.27	5019.0
2021-11-04 08:00:00	NQ	Futures	18768.85	18783.34	18747.11	18763.05	10067.0
2021-11-04 09:00:00	NQ	Futures	18762.76	18840.43	18730.3	18833.48	73199.0
2021-11-04 10:00:00	NQ	Futures	18833.77	18932.6	18822.18	18911.15	80165.0
2021-11-04 11:00:00	NQ	Futures	18911.44	18914.05	18830.29	18892.31	76801.0
2021-11-04 12:00:00	NQ	Futures	18892.6	18925.93	18882.17	18901.3	49408.0
2021-11-04 13:00:00	NQ	Futures	18901.87	18958.68	18877.53	18953.46	40903.0
2021-11-04 14:00:00	NQ	Futures	18952.88	18984.18	18913.47	18929.99	48517.0
2021-11-04 15:00:00	NQ	Futures	18929.41	18950.27	18888.25	18936.65	77642.0
2021-11-04 16:00:00	NQ	Futures	18936.65	18947.09	18921.0	18940.42	11250.0
2021-11-04 18:00:00	NQ	Futures	18936.65	18956.65	18918.68	18944.19	2946.0
2021-11-04 19:00:00	NQ	Futures	18944.48	18944.77	18926.51	18942.45	2645.0
2021-11-04 20:00:00	NQ	Futures	18942.45	18944.48	18910.28	18926.8	3504.0
2021-11-04 21:00:00	NQ	Futures	18926.8	18933.46	18914.05	18920.71	2821.0
2021-11-04 22:00:00	NQ	Futures	18920.42	18933.75	18916.66	18928.54	1400.0
2021-11-04 23:00:00	NQ	Futures	18929.12	18938.1	18925.35	18937.52	1154.0
2021-11-04 00:00:00	YM	Futures	40360.5	40386.3	40360.5	40372.8	618.0
2021-11-04 01:00:00	YM	Futures	40371.7	40379.6	40350.4	40358.3	1059.0
2021-11-04 02:00:00	YM	Futures	40358.3	40400.9	40356.0	40379.6	1655.0
2021-11-04 03:00:00	YM	Futures	40379.6	40403.1	40372.8	40382.9	1774.0

> showing 50 of 2,010 rows — these rows as CSV

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