PREVIEW / futures_1hour / 2021-07-15

all futures 1-hour files

  file:    by_date/futures_1hour/2021/2021-07-15.parquet
  size:    63 KB
  rows:    1,962

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-15 00:00:00	ES	Futures	4916.14	4916.99	4913.61	4914.17	3168.0
2021-07-15 01:00:00	ES	Futures	4914.17	4916.99	4913.89	4915.86	4330.0
2021-07-15 02:00:00	ES	Futures	4916.14	4918.12	4913.33	4915.3	6355.0
2021-07-15 03:00:00	ES	Futures	4915.3	4916.99	4903.75	4911.36	27513.0
2021-07-15 04:00:00	ES	Futures	4911.36	4922.34	4908.26	4920.65	20228.0
2021-07-15 05:00:00	ES	Futures	4920.65	4920.65	4912.2	4916.14	18138.0
2021-07-15 06:00:00	ES	Futures	4916.14	4916.99	4900.94	4903.47	28742.0
2021-07-15 07:00:00	ES	Futures	4903.47	4907.41	4894.18	4903.19	42772.0
2021-07-15 08:00:00	ES	Futures	4903.19	4907.41	4897.84	4901.22	34044.0
2021-07-15 09:00:00	ES	Futures	4901.22	4910.23	4893.9	4909.67	220171.0
2021-07-15 10:00:00	ES	Futures	4909.39	4911.64	4896.43	4903.19	230294.0
2021-07-15 11:00:00	ES	Futures	4903.19	4909.67	4896.43	4902.63	154960.0
2021-07-15 12:00:00	ES	Futures	4902.35	4904.88	4894.18	4900.38	140779.0
2021-07-15 13:00:00	ES	Futures	4900.66	4900.94	4879.82	4880.38	216568.0
2021-07-15 14:00:00	ES	Futures	4880.38	4896.71	4880.1	4896.43	151653.0
2021-07-15 15:00:00	ES	Futures	4896.43	4903.47	4894.46	4902.91	187167.0
2021-07-15 16:00:00	ES	Futures	4902.91	4904.04	4895.87	4897.28	45870.0
2021-07-15 18:00:00	ES	Futures	4897.0	4897.84	4893.9	4896.15	4418.0
2021-07-15 19:00:00	ES	Futures	4896.43	4897.84	4891.08	4892.21	4526.0
2021-07-15 20:00:00	ES	Futures	4892.21	4897.0	4888.55	4889.39	11879.0
2021-07-15 21:00:00	ES	Futures	4889.39	4893.62	4886.58	4889.96	8729.0
2021-07-15 22:00:00	ES	Futures	4890.24	4893.62	4889.39	4893.34	4069.0
2021-07-15 23:00:00	ES	Futures	4893.62	4902.06	4893.62	4900.38	7232.0
2021-07-15 00:00:00	NQ	Futures	17279.49	17293.1	17278.33	17284.7	2398.0
2021-07-15 01:00:00	NQ	Futures	17284.7	17294.84	17274.56	17279.2	3331.0
2021-07-15 02:00:00	NQ	Futures	17279.78	17297.74	17277.75	17290.49	3468.0
2021-07-15 03:00:00	NQ	Futures	17289.63	17303.82	17261.82	17292.23	10429.0
2021-07-15 04:00:00	NQ	Futures	17292.81	17336.84	17285.28	17334.53	9091.0
2021-07-15 05:00:00	NQ	Futures	17334.53	17337.71	17312.22	17321.49	5295.0
2021-07-15 06:00:00	NQ	Futures	17320.91	17322.07	17263.26	17276.88	12416.0
2021-07-15 07:00:00	NQ	Futures	17276.88	17283.54	17223.29	17254.57	17714.0
2021-07-15 08:00:00	NQ	Futures	17255.15	17273.98	17236.32	17252.55	14468.0
2021-07-15 09:00:00	NQ	Futures	17252.84	17271.09	17144.21	17256.89	92062.0
2021-07-15 10:00:00	NQ	Futures	17256.31	17260.08	17096.99	17125.67	112065.0
2021-07-15 11:00:00	NQ	Futures	17125.38	17183.89	17094.67	17121.03	63212.0
2021-07-15 12:00:00	NQ	Futures	17121.03	17147.68	17071.21	17129.43	61825.0
2021-07-15 13:00:00	NQ	Futures	17128.85	17133.78	17042.82	17045.71	64039.0
2021-07-15 14:00:00	NQ	Futures	17045.42	17127.69	17043.98	17123.06	51942.0
2021-07-15 15:00:00	NQ	Futures	17123.35	17150.87	17095.83	17138.12	71488.0
2021-07-15 16:00:00	NQ	Futures	17138.41	17142.76	17107.71	17121.9	10249.0
2021-07-15 18:00:00	NQ	Futures	17124.22	17125.96	17110.6	17120.16	1988.0
2021-07-15 19:00:00	NQ	Futures	17120.45	17125.09	17094.67	17098.44	2373.0
2021-07-15 20:00:00	NQ	Futures	17099.31	17115.53	17081.63	17085.69	5335.0
2021-07-15 21:00:00	NQ	Futures	17085.11	17102.49	17076.13	17082.5	4203.0
2021-07-15 22:00:00	NQ	Futures	17083.66	17094.38	17074.97	17093.8	2441.0
2021-07-15 23:00:00	NQ	Futures	17094.09	17130.3	17094.09	17120.74	3324.0
2021-07-15 00:00:00	YM	Futures	38839.0	38844.6	38810.0	38814.5	778.0
2021-07-15 01:00:00	YM	Futures	38814.5	38835.7	38812.2	38827.9	908.0
2021-07-15 02:00:00	YM	Futures	38830.1	38849.1	38799.9	38817.8	1519.0
2021-07-15 03:00:00	YM	Futures	38818.9	38832.3	38706.1	38769.8	5912.0

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

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