PREVIEW / futures_1hour / 2021-07-22

all futures 1-hour files

  file:    by_date/futures_1hour/2021/2021-07-22.parquet
  size:    65 KB
  rows:    1,986

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-22 00:00:00	ES	Futures	4903.47	4904.04	4902.35	4902.91	1402.0
2021-07-22 01:00:00	ES	Futures	4902.91	4906.01	4901.5	4904.6	3568.0
2021-07-22 02:00:00	ES	Futures	4904.32	4908.26	4902.63	4906.57	7365.0
2021-07-22 03:00:00	ES	Futures	4906.57	4911.08	4903.75	4906.85	21974.0
2021-07-22 04:00:00	ES	Futures	4906.85	4908.54	4905.16	4907.41	10578.0
2021-07-22 05:00:00	ES	Futures	4907.7	4910.51	4906.29	4908.82	9176.0
2021-07-22 06:00:00	ES	Futures	4908.82	4912.2	4906.57	4910.79	10706.0
2021-07-22 07:00:00	ES	Futures	4910.79	4910.79	4903.47	4907.13	18697.0
2021-07-22 08:00:00	ES	Futures	4907.13	4907.41	4895.03	4897.84	42888.0
2021-07-22 09:00:00	ES	Futures	4897.56	4905.44	4892.77	4897.84	168000.0
2021-07-22 10:00:00	ES	Futures	4898.12	4909.1	4894.18	4905.16	127833.0
2021-07-22 11:00:00	ES	Futures	4905.44	4906.57	4895.31	4899.25	110312.0
2021-07-22 12:00:00	ES	Futures	4898.97	4902.63	4889.96	4902.35	110636.0
2021-07-22 13:00:00	ES	Futures	4902.63	4907.41	4900.94	4907.13	61023.0
2021-07-22 14:00:00	ES	Futures	4907.41	4913.33	4906.29	4912.2	73372.0
2021-07-22 15:00:00	ES	Futures	4912.2	4912.76	4906.01	4910.51	116721.0
2021-07-22 16:00:00	ES	Futures	4910.79	4923.75	4910.51	4923.18	44358.0
2021-07-22 18:00:00	ES	Futures	4923.75	4924.03	4920.65	4921.78	4142.0
2021-07-22 19:00:00	ES	Futures	4921.49	4923.18	4920.93	4921.21	2502.0
2021-07-22 20:00:00	ES	Futures	4921.49	4926.56	4918.96	4925.44	6121.0
2021-07-22 21:00:00	ES	Futures	4925.15	4926.56	4923.18	4924.31	4110.0
2021-07-22 22:00:00	ES	Futures	4924.03	4925.72	4921.49	4922.9	3912.0
2021-07-22 23:00:00	ES	Futures	4922.9	4923.75	4921.49	4922.34	2014.0
2021-07-22 00:00:00	NQ	Futures	17197.51	17201.85	17193.16	17196.93	1214.0
2021-07-22 01:00:00	NQ	Futures	17196.93	17205.62	17188.24	17196.35	1729.0
2021-07-22 02:00:00	NQ	Futures	17197.22	17225.61	17190.84	17224.16	3636.0
2021-07-22 03:00:00	NQ	Futures	17225.03	17240.96	17211.7	17229.08	6235.0
2021-07-22 04:00:00	NQ	Futures	17229.08	17229.66	17199.25	17207.36	5043.0
2021-07-22 05:00:00	NQ	Futures	17207.65	17218.36	17203.01	17204.46	3110.0
2021-07-22 06:00:00	NQ	Futures	17204.17	17215.76	17192.87	17212.28	4290.0
2021-07-22 07:00:00	NQ	Futures	17212.57	17221.55	17193.45	17206.78	5948.0
2021-07-22 08:00:00	NQ	Futures	17206.78	17214.6	17186.21	17193.45	9750.0
2021-07-22 09:00:00	NQ	Futures	17193.16	17258.92	17183.02	17239.51	70229.0
2021-07-22 10:00:00	NQ	Futures	17239.8	17291.94	17232.56	17276.3	67239.0
2021-07-22 11:00:00	NQ	Futures	17276.3	17291.65	17240.96	17271.09	50445.0
2021-07-22 12:00:00	NQ	Futures	17271.09	17276.01	17207.65	17251.97	54575.0
2021-07-22 13:00:00	NQ	Futures	17252.26	17279.2	17248.78	17271.67	27581.0
2021-07-22 14:00:00	NQ	Futures	17271.67	17295.71	17266.45	17291.65	31099.0
2021-07-22 15:00:00	NQ	Futures	17291.65	17300.63	17275.72	17298.61	42835.0
2021-07-22 16:00:00	NQ	Futures	17298.61	17360.89	17297.45	17354.22	19156.0
2021-07-22 18:00:00	NQ	Futures	17357.12	17363.2	17346.11	17353.94	3122.0
2021-07-22 19:00:00	NQ	Futures	17354.22	17357.41	17346.11	17347.85	1975.0
2021-07-22 20:00:00	NQ	Futures	17348.14	17378.27	17339.74	17370.74	4086.0
2021-07-22 21:00:00	NQ	Futures	17371.61	17377.4	17355.38	17358.57	3367.0
2021-07-22 22:00:00	NQ	Futures	17357.12	17363.49	17342.35	17347.27	3168.0
2021-07-22 23:00:00	NQ	Futures	17346.69	17353.65	17343.22	17349.59	1426.0
2021-07-22 00:00:00	YM	Futures	38789.9	38793.2	38783.2	38786.5	315.0
2021-07-22 01:00:00	YM	Futures	38784.3	38814.5	38777.6	38798.8	760.0
2021-07-22 02:00:00	YM	Futures	38799.9	38812.2	38777.6	38793.2	1506.0
2021-07-22 03:00:00	YM	Futures	38792.1	38834.6	38775.3	38802.2	3956.0

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

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