PREVIEW / futures_1hour / 2021-12-14

all futures 1-hour files

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

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-12-14 00:00:00	ES	Futures	5278.22	5279.92	5276.52	5277.65	2594.0
2021-12-14 01:00:00	ES	Futures	5277.94	5282.46	5275.11	5280.2	3821.0
2021-12-14 02:00:00	ES	Futures	5280.48	5286.14	5278.5	5283.31	6313.0
2021-12-14 03:00:00	ES	Futures	5283.59	5290.38	5282.74	5283.31	13178.0
2021-12-14 04:00:00	ES	Futures	5283.31	5287.27	5251.63	5252.48	28399.0
2021-12-14 05:00:00	ES	Futures	5252.77	5260.4	5249.37	5256.16	20143.0
2021-12-14 06:00:00	ES	Futures	5255.88	5263.23	5255.59	5258.14	19192.0
2021-12-14 07:00:00	ES	Futures	5258.42	5266.91	5257.86	5260.4	15385.0
2021-12-14 08:00:00	ES	Futures	5260.68	5264.93	5235.8	5238.91	51287.0
2021-12-14 09:00:00	ES	Futures	5238.91	5262.38	5229.86	5247.96	242070.0
2021-12-14 10:00:00	ES	Futures	5248.24	5251.35	5210.06	5216.28	267949.0
2021-12-14 11:00:00	ES	Futures	5216.28	5221.66	5204.69	5208.65	199162.0
2021-12-14 12:00:00	ES	Futures	5208.37	5211.19	5199.32	5203.84	140504.0
2021-12-14 13:00:00	ES	Futures	5203.84	5213.46	5201.58	5204.12	93511.0
2021-12-14 14:00:00	ES	Futures	5204.12	5226.75	5202.43	5224.77	126290.0
2021-12-14 15:00:00	ES	Futures	5224.49	5247.11	5223.35	5236.08	255591.0
2021-12-14 16:00:00	ES	Futures	5236.08	5237.21	5230.71	5236.65	47708.0
2021-12-14 18:00:00	ES	Futures	5236.36	5239.76	5230.71	5234.1	8904.0
2021-12-14 19:00:00	ES	Futures	5234.38	5242.02	5233.54	5240.04	9435.0
2021-12-14 20:00:00	ES	Futures	5240.04	5240.61	5229.01	5237.49	10197.0
2021-12-14 21:00:00	ES	Futures	5237.21	5240.04	5232.12	5239.47	7499.0
2021-12-14 22:00:00	ES	Futures	5239.76	5242.87	5238.91	5242.02	5486.0
2021-12-14 23:00:00	ES	Futures	5242.3	5243.15	5240.32	5242.02	3288.0
2021-12-14 00:00:00	NQ	Futures	18664.8	18667.7	18656.98	18662.78	1646.0
2021-12-14 01:00:00	NQ	Futures	18662.2	18669.44	18652.05	18657.56	1973.0
2021-12-14 02:00:00	NQ	Futures	18658.43	18685.38	18653.79	18681.03	3526.0
2021-12-14 03:00:00	NQ	Futures	18681.61	18702.19	18671.18	18672.63	6512.0
2021-12-14 04:00:00	NQ	Futures	18672.63	18688.28	18505.4	18506.56	15110.0
2021-12-14 05:00:00	NQ	Futures	18507.14	18545.4	18501.64	18529.17	11256.0
2021-12-14 06:00:00	NQ	Futures	18528.88	18550.91	18512.36	18523.37	8889.0
2021-12-14 07:00:00	NQ	Futures	18523.95	18575.83	18522.21	18549.17	10566.0
2021-12-14 08:00:00	NQ	Futures	18549.75	18570.32	18421.94	18444.54	28103.0
2021-12-14 09:00:00	NQ	Futures	18444.54	18546.85	18381.94	18462.8	100296.0
2021-12-14 10:00:00	NQ	Futures	18463.38	18482.22	18300.79	18326.88	111338.0
2021-12-14 11:00:00	NQ	Futures	18326.59	18340.79	18265.44	18295.58	79472.0
2021-12-14 12:00:00	NQ	Futures	18295.58	18306.01	18239.93	18276.16	51523.0
2021-12-14 13:00:00	NQ	Futures	18275.58	18318.18	18258.48	18269.49	33506.0
2021-12-14 14:00:00	NQ	Futures	18270.36	18398.75	18260.51	18376.73	46820.0
2021-12-14 15:00:00	NQ	Futures	18376.44	18509.17	18371.51	18462.51	75097.0
2021-12-14 16:00:00	NQ	Futures	18462.51	18482.22	18449.18	18463.67	10834.0
2021-12-14 18:00:00	NQ	Futures	18465.99	18485.99	18443.67	18449.18	4553.0
2021-12-14 19:00:00	NQ	Futures	18449.76	18479.9	18443.96	18470.92	4487.0
2021-12-14 20:00:00	NQ	Futures	18470.05	18473.81	18423.97	18458.74	5925.0
2021-12-14 21:00:00	NQ	Futures	18458.45	18465.99	18439.33	18462.8	3550.0
2021-12-14 22:00:00	NQ	Futures	18463.38	18469.18	18456.72	18464.54	2030.0
2021-12-14 23:00:00	NQ	Futures	18464.54	18470.92	18459.61	18466.57	1285.0
2021-12-14 00:00:00	YM	Futures	39985.9	40002.8	39971.3	39983.7	680.0
2021-12-14 01:00:00	YM	Futures	39983.7	40030.9	39960.1	40017.4	1046.0
2021-12-14 02:00:00	YM	Futures	40020.8	40059.0	39997.2	40028.6	2080.0
2021-12-14 03:00:00	YM	Futures	40028.6	40099.4	40023.0	40032.0	3775.0

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

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