PREVIEW / futures_1hour / 2021-06-15

all futures 1-hour files

  file:    by_date/futures_1hour/2021/2021-06-15.parquet
  size:    59 KB
  rows:    1,892

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-06-15 00:00:00	ES	Futures	4790.0	4790.84	4789.43	4790.28	2404.0
2021-06-15 01:00:00	ES	Futures	4790.28	4791.97	4788.59	4791.68	5037.0
2021-06-15 02:00:00	ES	Futures	4791.68	4796.19	4789.43	4794.22	10859.0
2021-06-15 03:00:00	ES	Futures	4794.22	4795.91	4790.56	4791.12	19061.0
2021-06-15 04:00:00	ES	Futures	4791.12	4791.12	4787.18	4789.71	12172.0
2021-06-15 05:00:00	ES	Futures	4789.71	4790.0	4784.08	4784.36	9681.0
2021-06-15 06:00:00	ES	Futures	4784.36	4787.74	4782.11	4787.74	9703.0
2021-06-15 07:00:00	ES	Futures	4787.46	4789.15	4785.77	4787.46	13415.0
2021-06-15 08:00:00	ES	Futures	4787.18	4789.43	4782.39	4783.8	29097.0
2021-06-15 09:00:00	ES	Futures	4783.8	4786.05	4774.51	4775.92	122453.0
2021-06-15 10:00:00	ES	Futures	4775.92	4777.04	4768.03	4768.31	126448.0
2021-06-15 11:00:00	ES	Futures	4768.59	4771.69	4762.4	4766.91	99289.0
2021-06-15 12:00:00	ES	Futures	4767.19	4773.1	4766.91	4770.0	63583.0
2021-06-15 13:00:00	ES	Futures	4770.0	4775.63	4766.34	4774.51	67841.0
2021-06-15 14:00:00	ES	Futures	4774.51	4778.45	4771.97	4775.63	70234.0
2021-06-15 15:00:00	ES	Futures	4775.35	4777.89	4767.19	4772.82	178595.0
2021-06-15 16:00:00	ES	Futures	4772.82	4774.79	4771.41	4772.82	35669.0
2021-06-15 18:00:00	ES	Futures	4773.38	4775.35	4771.97	4772.82	2702.0
2021-06-15 19:00:00	ES	Futures	4772.54	4773.94	4770.28	4771.97	4270.0
2021-06-15 20:00:00	ES	Futures	4772.26	4774.79	4771.69	4772.54	4488.0
2021-06-15 21:00:00	ES	Futures	4772.54	4774.51	4771.13	4772.54	5006.0
2021-06-15 22:00:00	ES	Futures	4772.82	4773.38	4770.28	4771.41	3407.0
2021-06-15 23:00:00	ES	Futures	4771.41	4773.1	4769.72	4773.1	3388.0
2021-06-15 00:00:00	NQ	Futures	16378.58	16380.32	16370.47	16375.68	1483.0
2021-06-15 01:00:00	NQ	Futures	16375.68	16382.05	16366.41	16382.05	2331.0
2021-06-15 02:00:00	NQ	Futures	16381.19	16391.61	16369.31	16382.34	3372.0
2021-06-15 03:00:00	NQ	Futures	16382.63	16400.88	16376.55	16385.82	5028.0
2021-06-15 04:00:00	NQ	Futures	16385.82	16389.01	16376.84	16383.5	3906.0
2021-06-15 05:00:00	NQ	Futures	16382.63	16384.08	16369.6	16371.05	2133.0
2021-06-15 06:00:00	NQ	Futures	16371.05	16385.24	16362.07	16384.95	3442.0
2021-06-15 07:00:00	NQ	Futures	16384.66	16390.74	16375.39	16383.21	4466.0
2021-06-15 08:00:00	NQ	Futures	16382.63	16390.46	16349.03	16354.25	10483.0
2021-06-15 09:00:00	NQ	Futures	16353.96	16364.09	16296.02	16334.84	66353.0
2021-06-15 10:00:00	NQ	Futures	16335.13	16342.37	16279.51	16289.94	69901.0
2021-06-15 11:00:00	NQ	Futures	16289.94	16309.05	16254.02	16287.04	39572.0
2021-06-15 12:00:00	NQ	Futures	16286.75	16297.76	16258.07	16265.6	25866.0
2021-06-15 13:00:00	NQ	Futures	16266.47	16271.69	16247.64	16268.21	24199.0
2021-06-15 14:00:00	NQ	Futures	16267.63	16276.32	16230.84	16248.51	30245.0
2021-06-15 15:00:00	NQ	Futures	16248.51	16274.58	16223.02	16253.73	56207.0
2021-06-15 16:00:00	NQ	Futures	16254.02	16269.66	16243.88	16265.89	5771.0
2021-06-15 18:00:00	NQ	Futures	16267.34	16271.11	16259.23	16262.42	1388.0
2021-06-15 19:00:00	NQ	Futures	16261.55	16266.76	16251.99	16258.94	1485.0
2021-06-15 20:00:00	NQ	Futures	16258.94	16269.08	16254.31	16255.46	2140.0
2021-06-15 21:00:00	NQ	Futures	16255.46	16263.86	16249.67	16258.94	2108.0
2021-06-15 22:00:00	NQ	Futures	16258.94	16262.13	16250.25	16255.17	1589.0
2021-06-15 23:00:00	NQ	Futures	16255.17	16264.73	16251.12	16263.29	1500.0
2021-06-15 00:00:00	YM	Futures	38332.9	38341.9	38327.3	38336.3	560.0
2021-06-15 01:00:00	YM	Futures	38337.4	38354.1	38328.4	38354.1	966.0
2021-06-15 02:00:00	YM	Futures	38353.0	38397.7	38335.2	38379.8	2256.0
2021-06-15 03:00:00	YM	Futures	38379.8	38387.7	38334.0	38340.7	3643.0

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

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