PREVIEW / futures_1hour / 2021-11-03

all futures 1-hour files

  file:    by_date/futures_1hour/2021/2021-11-03.parquet
  size:    66 KB
  rows:    1,991

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-11-03 00:00:00	ES	Futures	5213.59	5214.72	5213.03	5213.87	1408.0
2021-11-03 01:00:00	ES	Futures	5214.16	5214.72	5211.9	5212.46	2843.0
2021-11-03 02:00:00	ES	Futures	5212.75	5215.85	5211.62	5213.59	4177.0
2021-11-03 03:00:00	ES	Futures	5213.31	5215.57	5212.46	5214.44	4457.0
2021-11-03 04:00:00	ES	Futures	5214.44	5218.95	5213.59	5217.26	10473.0
2021-11-03 05:00:00	ES	Futures	5217.26	5220.08	5216.13	5217.54	7456.0
2021-11-03 06:00:00	ES	Futures	5217.54	5218.67	5213.31	5215.85	9341.0
2021-11-03 07:00:00	ES	Futures	5215.57	5216.98	5213.59	5216.13	11119.0
2021-11-03 08:00:00	ES	Futures	5216.13	5216.13	5211.05	5211.9	12865.0
2021-11-03 09:00:00	ES	Futures	5211.9	5215.85	5207.38	5213.59	126505.0
2021-11-03 10:00:00	ES	Futures	5213.87	5215.85	5207.38	5214.44	113952.0
2021-11-03 11:00:00	ES	Futures	5214.44	5215.29	5209.92	5214.44	64654.0
2021-11-03 12:00:00	ES	Futures	5214.44	5215.57	5211.62	5213.03	54011.0
2021-11-03 13:00:00	ES	Futures	5212.75	5214.16	5208.79	5211.05	44505.0
2021-11-03 14:00:00	ES	Futures	5211.33	5246.05	5207.67	5242.38	250697.0
2021-11-03 15:00:00	ES	Futures	5242.66	5257.05	5240.4	5251.69	240317.0
2021-11-03 16:00:00	ES	Futures	5251.69	5252.25	5248.3	5251.13	56969.0
2021-11-03 18:00:00	ES	Futures	5250.84	5256.49	5250.56	5255.64	4974.0
2021-11-03 19:00:00	ES	Futures	5255.64	5261.0	5255.36	5259.87	7518.0
2021-11-03 20:00:00	ES	Futures	5259.59	5259.59	5253.1	5254.51	7904.0
2021-11-03 21:00:00	ES	Futures	5254.23	5254.23	5250.0	5251.13	8249.0
2021-11-03 22:00:00	ES	Futures	5251.13	5254.23	5250.84	5253.67	3818.0
2021-11-03 23:00:00	ES	Futures	5253.67	5253.95	5250.84	5251.41	2930.0
2021-11-03 00:00:00	NQ	Futures	18500.19	18508.88	18496.13	18502.22	1188.0
2021-11-03 01:00:00	NQ	Futures	18501.64	18503.67	18491.78	18493.23	1888.0
2021-11-03 02:00:00	NQ	Futures	18493.81	18506.27	18493.52	18499.9	1332.0
2021-11-03 03:00:00	NQ	Futures	18499.03	18511.78	18493.81	18500.48	2621.0
2021-11-03 04:00:00	NQ	Futures	18499.9	18522.79	18497.58	18513.52	4692.0
2021-11-03 05:00:00	NQ	Futures	18512.65	18533.52	18512.65	18522.79	3546.0
2021-11-03 06:00:00	NQ	Futures	18522.79	18530.04	18504.54	18514.68	4236.0
2021-11-03 07:00:00	NQ	Futures	18514.1	18533.23	18508.59	18529.17	4682.0
2021-11-03 08:00:00	NQ	Futures	18529.17	18536.42	18511.2	18522.5	7001.0
2021-11-03 09:00:00	NQ	Futures	18522.79	18545.11	18482.51	18514.39	69670.0
2021-11-03 10:00:00	NQ	Futures	18514.39	18519.9	18473.24	18501.35	64434.0
2021-11-03 11:00:00	NQ	Futures	18501.35	18530.33	18480.77	18527.72	38345.0
2021-11-03 12:00:00	NQ	Futures	18527.43	18532.36	18510.62	18520.77	25642.0
2021-11-03 13:00:00	NQ	Futures	18520.77	18535.84	18507.14	18511.78	19125.0
2021-11-03 14:00:00	NQ	Futures	18511.78	18651.47	18496.71	18644.23	103604.0
2021-11-03 15:00:00	NQ	Futures	18644.52	18717.26	18630.9	18698.71	69083.0
2021-11-03 16:00:00	NQ	Futures	18698.71	18703.35	18689.73	18699.58	10977.0
2021-11-03 18:00:00	NQ	Futures	18698.42	18732.62	18698.42	18729.72	3490.0
2021-11-03 19:00:00	NQ	Futures	18729.72	18765.08	18729.43	18763.92	5499.0
2021-11-03 20:00:00	NQ	Futures	18762.76	18763.05	18740.16	18750.88	3438.0
2021-11-03 21:00:00	NQ	Futures	18750.88	18750.88	18725.09	18729.14	3149.0
2021-11-03 22:00:00	NQ	Futures	18729.72	18743.34	18726.25	18741.03	2164.0
2021-11-03 23:00:00	NQ	Futures	18741.03	18741.32	18728.56	18731.17	1177.0
2021-11-03 00:00:00	YM	Futures	40231.6	40238.3	40227.1	40231.6	511.0
2021-11-03 01:00:00	YM	Futures	40232.7	40239.5	40219.3	40224.9	787.0
2021-11-03 02:00:00	YM	Futures	40226.0	40250.7	40214.8	40236.1	1067.0
2021-11-03 03:00:00	YM	Futures	40235.0	40252.9	40227.1	40248.4	2055.0

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

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