PREVIEW / futures_1hour / 2021-07-19

all futures 1-hour files

  file:    by_date/futures_1hour/2021/2021-07-19.parquet
  size:    67 KB
  rows:    2,007

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-19 00:00:00	ES	Futures	4848.28	4848.85	4841.81	4843.5	5970.0
2021-07-19 01:00:00	ES	Futures	4843.5	4849.69	4843.5	4845.75	7015.0
2021-07-19 02:00:00	ES	Futures	4845.75	4852.22	4844.62	4850.25	13591.0
2021-07-19 03:00:00	ES	Futures	4850.25	4852.51	4835.61	4840.12	55009.0
2021-07-19 04:00:00	ES	Futures	4840.12	4848.85	4826.32	4828.85	50162.0
2021-07-19 05:00:00	ES	Futures	4828.85	4836.46	4826.32	4834.49	29159.0
2021-07-19 06:00:00	ES	Futures	4834.77	4835.89	4824.63	4827.16	32074.0
2021-07-19 07:00:00	ES	Futures	4827.16	4829.98	4805.76	4814.21	65099.0
2021-07-19 08:00:00	ES	Futures	4814.49	4815.34	4801.82	4808.02	74434.0
2021-07-19 09:00:00	ES	Futures	4808.02	4811.68	4780.42	4784.08	357708.0
2021-07-19 10:00:00	ES	Futures	4784.08	4787.46	4765.78	4782.11	420993.0
2021-07-19 11:00:00	ES	Futures	4781.83	4796.47	4775.63	4791.12	219171.0
2021-07-19 12:00:00	ES	Futures	4790.84	4791.12	4760.99	4767.75	222966.0
2021-07-19 13:00:00	ES	Futures	4767.47	4774.51	4757.61	4759.58	222369.0
2021-07-19 14:00:00	ES	Futures	4759.3	4773.94	4757.61	4762.68	207221.0
2021-07-19 15:00:00	ES	Futures	4762.4	4793.09	4760.15	4792.53	376449.0
2021-07-19 16:00:00	ES	Futures	4792.81	4800.41	4787.46	4799.29	102508.0
2021-07-19 18:00:00	ES	Futures	4801.26	4802.1	4795.91	4799.85	7183.0
2021-07-19 19:00:00	ES	Futures	4799.85	4802.95	4797.03	4800.41	8240.0
2021-07-19 20:00:00	ES	Futures	4800.41	4807.73	4799.01	4806.61	12505.0
2021-07-19 21:00:00	ES	Futures	4806.33	4813.93	4803.23	4813.65	14541.0
2021-07-19 22:00:00	ES	Futures	4813.37	4814.77	4809.99	4809.99	13120.0
2021-07-19 23:00:00	ES	Futures	4810.27	4813.65	4795.35	4798.16	16165.0
2021-07-19 00:00:00	NQ	Futures	16971.85	16973.0	16948.67	16959.1	2501.0
2021-07-19 01:00:00	NQ	Futures	16959.68	16978.22	16956.49	16964.02	3844.0
2021-07-19 02:00:00	NQ	Futures	16964.89	16995.6	16959.68	16985.46	5027.0
2021-07-19 03:00:00	NQ	Futures	16985.17	16991.54	16948.96	16972.71	12122.0
2021-07-19 04:00:00	NQ	Futures	16973.0	16995.31	16922.31	16931.87	14316.0
2021-07-19 05:00:00	NQ	Futures	16931.29	16957.65	16918.83	16953.6	10194.0
2021-07-19 06:00:00	NQ	Futures	16953.89	16963.16	16925.21	16938.53	8800.0
2021-07-19 07:00:00	NQ	Futures	16939.69	16942.88	16828.74	16859.74	24808.0
2021-07-19 08:00:00	NQ	Futures	16859.45	16865.82	16805.86	16846.7	22715.0
2021-07-19 09:00:00	NQ	Futures	16846.7	16886.68	16768.2	16782.39	108332.0
2021-07-19 10:00:00	NQ	Futures	16782.39	16822.95	16737.78	16820.63	116403.0
2021-07-19 11:00:00	NQ	Futures	16820.63	16887.84	16803.25	16843.81	69037.0
2021-07-19 12:00:00	NQ	Futures	16842.94	16845.83	16751.11	16771.39	60251.0
2021-07-19 13:00:00	NQ	Futures	16771.1	16802.38	16740.39	16760.38	55772.0
2021-07-19 14:00:00	NQ	Futures	16759.8	16824.98	16758.35	16784.71	51310.0
2021-07-19 15:00:00	NQ	Futures	16784.42	16865.82	16749.66	16863.5	84866.0
2021-07-19 16:00:00	NQ	Futures	16863.79	16914.49	16848.15	16908.41	21150.0
2021-07-19 18:00:00	NQ	Futures	16910.14	16917.1	16892.18	16907.25	2849.0
2021-07-19 19:00:00	NQ	Futures	16907.54	16914.49	16894.79	16907.25	3198.0
2021-07-19 20:00:00	NQ	Futures	16906.38	16930.71	16900.87	16925.5	5655.0
2021-07-19 21:00:00	NQ	Futures	16924.63	16968.95	16913.62	16965.76	8089.0
2021-07-19 22:00:00	NQ	Futures	16966.05	16967.5	16936.5	16942.3	5691.0
2021-07-19 23:00:00	NQ	Futures	16943.75	16953.31	16902.03	16912.75	6019.0
2021-07-19 00:00:00	YM	Futures	38448.0	38455.8	38401.1	38414.5	1367.0
2021-07-19 01:00:00	YM	Futures	38412.2	38473.7	38410.0	38442.4	2243.0
2021-07-19 02:00:00	YM	Futures	38437.9	38483.7	38427.9	38470.3	2541.0
2021-07-19 03:00:00	YM	Futures	38471.5	38484.9	38290.5	38327.3	10114.0

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

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