PREVIEW / futures_1hour / 2021-07-14

all futures 1-hour files

  file:    by_date/futures_1hour/2021/2021-07-14.parquet
  size:    64 KB
  rows:    1,946

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-14 00:00:00	ES	Futures	4908.82	4909.1	4902.63	4902.63	6385.0
2021-07-14 01:00:00	ES	Futures	4902.63	4906.57	4902.35	4902.35	6136.0
2021-07-14 02:00:00	ES	Futures	4902.63	4908.26	4899.53	4900.94	15351.0
2021-07-14 03:00:00	ES	Futures	4900.94	4914.17	4899.53	4906.57	25837.0
2021-07-14 04:00:00	ES	Futures	4906.57	4912.76	4902.91	4907.7	18675.0
2021-07-14 05:00:00	ES	Futures	4907.41	4917.27	4907.41	4913.33	16045.0
2021-07-14 06:00:00	ES	Futures	4913.33	4917.83	4912.48	4914.74	7592.0
2021-07-14 07:00:00	ES	Futures	4914.74	4921.49	4914.45	4920.09	13959.0
2021-07-14 08:00:00	ES	Futures	4920.09	4933.88	4918.12	4931.63	43320.0
2021-07-14 09:00:00	ES	Futures	4931.35	4938.39	4927.13	4928.25	150910.0
2021-07-14 10:00:00	ES	Futures	4928.25	4933.04	4922.62	4927.97	164937.0
2021-07-14 11:00:00	ES	Futures	4927.97	4928.53	4904.6	4905.44	190419.0
2021-07-14 12:00:00	ES	Futures	4905.73	4925.44	4904.88	4922.34	121272.0
2021-07-14 13:00:00	ES	Futures	4922.62	4924.03	4914.74	4922.06	90823.0
2021-07-14 14:00:00	ES	Futures	4922.06	4927.69	4920.93	4923.75	73899.0
2021-07-14 15:00:00	ES	Futures	4923.75	4929.1	4917.27	4919.52	240919.0
2021-07-14 16:00:00	ES	Futures	4919.52	4922.9	4917.27	4917.83	57457.0
2021-07-14 18:00:00	ES	Futures	4918.12	4920.37	4916.99	4918.68	3557.0
2021-07-14 19:00:00	ES	Futures	4918.68	4920.65	4917.27	4919.52	2677.0
2021-07-14 20:00:00	ES	Futures	4919.52	4919.8	4909.1	4911.08	9309.0
2021-07-14 21:00:00	ES	Futures	4911.08	4914.45	4908.26	4913.61	7540.0
2021-07-14 22:00:00	ES	Futures	4913.33	4915.58	4911.92	4913.89	6396.0
2021-07-14 23:00:00	ES	Futures	4913.61	4917.55	4912.76	4915.86	4334.0
2021-07-14 00:00:00	NQ	Futures	17235.46	17240.67	17214.6	17217.5	2815.0
2021-07-14 01:00:00	NQ	Futures	17217.5	17228.5	17210.25	17210.25	2727.0
2021-07-14 02:00:00	NQ	Futures	17209.96	17245.88	17196.93	17220.97	7586.0
2021-07-14 03:00:00	NQ	Futures	17221.84	17259.21	17216.05	17229.95	8561.0
2021-07-14 04:00:00	NQ	Futures	17230.24	17255.44	17213.73	17247.33	7320.0
2021-07-14 05:00:00	NQ	Futures	17247.91	17301.5	17247.62	17283.83	8680.0
2021-07-14 06:00:00	NQ	Futures	17283.54	17289.63	17273.4	17281.8	4099.0
2021-07-14 07:00:00	NQ	Futures	17280.94	17310.77	17268.48	17304.11	7373.0
2021-07-14 08:00:00	NQ	Futures	17304.4	17351.91	17291.36	17341.77	17034.0
2021-07-14 09:00:00	NQ	Futures	17341.77	17371.03	17305.56	17316.86	72204.0
2021-07-14 10:00:00	NQ	Futures	17317.44	17376.24	17308.17	17360.31	78973.0
2021-07-14 11:00:00	NQ	Futures	17360.6	17366.68	17220.97	17224.16	75035.0
2021-07-14 12:00:00	NQ	Futures	17223.87	17319.46	17221.55	17302.66	49862.0
2021-07-14 13:00:00	NQ	Futures	17303.24	17310.77	17257.18	17276.59	35993.0
2021-07-14 14:00:00	NQ	Futures	17276.01	17313.96	17270.8	17301.5	27811.0
2021-07-14 15:00:00	NQ	Futures	17301.5	17320.33	17243.57	17258.63	62483.0
2021-07-14 16:00:00	NQ	Futures	17258.34	17275.14	17257.18	17261.24	9962.0
2021-07-14 18:00:00	NQ	Futures	17259.21	17269.35	17256.02	17265.0	1873.0
2021-07-14 19:00:00	NQ	Futures	17265.0	17271.38	17260.66	17270.51	1351.0
2021-07-14 20:00:00	NQ	Futures	17269.06	17270.51	17235.75	17242.7	3684.0
2021-07-14 21:00:00	NQ	Futures	17242.99	17260.37	17236.61	17255.15	3916.0
2021-07-14 22:00:00	NQ	Futures	17254.86	17270.51	17247.62	17266.74	2783.0
2021-07-14 23:00:00	NQ	Futures	17266.45	17285.28	17265.29	17279.49	2738.0
2021-07-14 00:00:00	YM	Futures	38816.7	38821.2	38765.3	38772.0	1953.0
2021-07-14 01:00:00	YM	Futures	38772.0	38813.3	38768.6	38780.9	1423.0
2021-07-14 02:00:00	YM	Futures	38780.9	38811.1	38739.6	38751.9	3464.0
2021-07-14 03:00:00	YM	Futures	38751.9	38877.0	38731.8	38811.1	4325.0

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

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