PREVIEW / futures_1hour / 2021-07-12

all futures 1-hour files

  file:    by_date/futures_1hour/2021/2021-07-12.parquet
  size:    62 KB
  rows:    1,927

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-12 00:00:00	ES	Futures	4901.78	4904.04	4900.94	4903.75	3857.0
2021-07-12 01:00:00	ES	Futures	4903.75	4904.04	4900.38	4902.06	4742.0
2021-07-12 02:00:00	ES	Futures	4902.35	4907.98	4901.22	4906.57	9052.0
2021-07-12 03:00:00	ES	Futures	4906.29	4908.26	4890.24	4892.77	30717.0
2021-07-12 04:00:00	ES	Futures	4892.77	4904.88	4891.93	4904.04	19961.0
2021-07-12 05:00:00	ES	Futures	4904.04	4904.32	4897.0	4900.09	12186.0
2021-07-12 06:00:00	ES	Futures	4899.81	4900.94	4892.21	4893.62	18441.0
2021-07-12 07:00:00	ES	Futures	4893.62	4905.16	4893.62	4901.78	22019.0
2021-07-12 08:00:00	ES	Futures	4902.06	4910.23	4901.5	4909.95	18659.0
2021-07-12 09:00:00	ES	Futures	4910.23	4916.14	4904.88	4915.86	142478.0
2021-07-12 10:00:00	ES	Futures	4916.14	4925.15	4912.2	4923.47	171595.0
2021-07-12 11:00:00	ES	Futures	4923.75	4924.31	4917.55	4923.18	109733.0
2021-07-12 12:00:00	ES	Futures	4923.47	4924.87	4920.93	4922.9	72978.0
2021-07-12 13:00:00	ES	Futures	4922.62	4925.72	4921.21	4923.18	54888.0
2021-07-12 14:00:00	ES	Futures	4922.9	4929.1	4922.62	4926.56	70328.0
2021-07-12 15:00:00	ES	Futures	4926.28	4932.48	4925.15	4929.1	176713.0
2021-07-12 16:00:00	ES	Futures	4929.1	4931.63	4928.25	4928.53	45841.0
2021-07-12 18:00:00	ES	Futures	4929.94	4930.5	4926.28	4926.28	3083.0
2021-07-12 19:00:00	ES	Futures	4926.56	4931.07	4926.0	4930.22	3266.0
2021-07-12 20:00:00	ES	Futures	4930.22	4931.91	4928.82	4930.5	6148.0
2021-07-12 21:00:00	ES	Futures	4930.79	4931.07	4925.15	4929.38	7358.0
2021-07-12 22:00:00	ES	Futures	4929.66	4929.94	4926.84	4927.41	3462.0
2021-07-12 23:00:00	ES	Futures	4927.69	4928.82	4926.56	4927.13	1897.0
2021-07-12 00:00:00	NQ	Futures	17146.81	17157.82	17144.5	17156.37	1609.0
2021-07-12 01:00:00	NQ	Futures	17156.66	17157.82	17142.76	17152.32	1677.0
2021-07-12 02:00:00	NQ	Futures	17152.9	17176.65	17150.29	17172.02	4103.0
2021-07-12 03:00:00	NQ	Futures	17171.73	17187.37	17131.75	17137.25	9124.0
2021-07-12 04:00:00	NQ	Futures	17137.83	17209.96	17136.38	17199.25	8628.0
2021-07-12 05:00:00	NQ	Futures	17198.96	17209.09	17186.5	17191.71	5635.0
2021-07-12 06:00:00	NQ	Futures	17191.71	17203.01	17163.9	17189.11	6622.0
2021-07-12 07:00:00	NQ	Futures	17189.4	17209.38	17189.11	17200.98	5546.0
2021-07-12 08:00:00	NQ	Futures	17201.27	17240.09	17198.96	17238.35	10746.0
2021-07-12 09:00:00	NQ	Futures	17238.35	17251.68	17166.51	17182.44	77013.0
2021-07-12 10:00:00	NQ	Futures	17182.73	17209.67	17151.74	17198.67	68280.0
2021-07-12 11:00:00	NQ	Futures	17198.67	17215.76	17176.36	17196.35	35471.0
2021-07-12 12:00:00	NQ	Futures	17196.93	17205.62	17184.76	17194.32	19836.0
2021-07-12 13:00:00	NQ	Futures	17194.61	17196.93	17174.91	17192.0	17158.0
2021-07-12 14:00:00	NQ	Futures	17191.13	17220.97	17189.11	17208.8	20426.0
2021-07-12 15:00:00	NQ	Futures	17208.52	17233.14	17203.59	17228.5	40373.0
2021-07-12 16:00:00	NQ	Futures	17228.21	17245.3	17227.92	17237.19	8781.0
2021-07-12 18:00:00	NQ	Futures	17241.83	17241.83	17227.92	17229.08	1610.0
2021-07-12 19:00:00	NQ	Futures	17229.66	17244.73	17227.92	17241.83	1725.0
2021-07-12 20:00:00	NQ	Futures	17241.54	17247.62	17237.48	17238.93	2646.0
2021-07-12 21:00:00	NQ	Futures	17238.64	17245.88	17229.08	17245.3	3425.0
2021-07-12 22:00:00	NQ	Futures	17245.59	17246.46	17237.77	17239.22	1570.0
2021-07-12 23:00:00	NQ	Futures	17239.51	17244.73	17237.77	17243.28	1079.0
2021-07-12 00:00:00	YM	Futures	38760.8	38778.7	38755.2	38776.5	776.0
2021-07-12 01:00:00	YM	Futures	38777.6	38779.8	38748.5	38766.4	1103.0
2021-07-12 02:00:00	YM	Futures	38766.4	38798.8	38740.7	38786.5	2259.0
2021-07-12 03:00:00	YM	Futures	38786.5	38795.5	38618.9	38651.3	6783.0

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

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