PREVIEW / futures_1hour / 2021-01-07

all futures 1-hour files

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

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-01-07 00:00:00	ES	Futures	4219.26	4223.47	4215.61	4222.63	7058.0
2021-01-07 01:00:00	ES	Futures	4222.63	4231.33	4222.35	4231.05	7031.0
2021-01-07 02:00:00	ES	Futures	4231.05	4236.1	4228.24	4230.2	15937.0
2021-01-07 03:00:00	ES	Futures	4229.92	4231.33	4217.85	4224.31	25928.0
2021-01-07 04:00:00	ES	Futures	4224.31	4227.4	4213.64	4218.98	17337.0
2021-01-07 05:00:00	ES	Futures	4218.7	4221.78	4209.72	4210.28	14780.0
2021-01-07 06:00:00	ES	Futures	4210.28	4217.85	4206.63	4210.28	17172.0
2021-01-07 07:00:00	ES	Futures	4210.28	4224.59	4209.72	4221.5	18052.0
2021-01-07 08:00:00	ES	Futures	4221.5	4225.15	4216.45	4219.54	25425.0
2021-01-07 09:00:00	ES	Futures	4219.54	4248.17	4219.26	4247.32	186647.0
2021-01-07 10:00:00	ES	Futures	4247.32	4266.13	4245.64	4265.29	243017.0
2021-01-07 11:00:00	ES	Futures	4265.29	4269.78	4256.03	4257.71	119985.0
2021-01-07 12:00:00	ES	Futures	4257.99	4259.95	4252.1	4259.11	73720.0
2021-01-07 13:00:00	ES	Futures	4259.39	4262.2	4253.78	4259.67	82549.0
2021-01-07 14:00:00	ES	Futures	4259.95	4263.32	4256.03	4263.32	72447.0
2021-01-07 15:00:00	ES	Futures	4263.32	4270.62	4257.99	4260.8	197212.0
2021-01-07 16:00:00	ES	Futures	4260.8	4264.73	4257.15	4261.64	53829.0
2021-01-07 18:00:00	ES	Futures	4263.6	4267.81	4257.99	4265.57	8714.0
2021-01-07 19:00:00	ES	Futures	4265.57	4270.34	4262.2	4270.06	10803.0
2021-01-07 20:00:00	ES	Futures	4270.34	4278.76	4268.37	4276.79	14468.0
2021-01-07 21:00:00	ES	Futures	4276.79	4281.57	4275.67	4276.79	10622.0
2021-01-07 22:00:00	ES	Futures	4276.79	4281.57	4274.55	4279.88	7339.0
2021-01-07 23:00:00	ES	Futures	4280.16	4280.72	4273.43	4277.92	6743.0
2021-01-07 00:00:00	NQ	Futures	14703.23	14718.57	14694.55	14714.23	3664.0
2021-01-07 01:00:00	NQ	Futures	14714.81	14752.73	14712.79	14750.7	3662.0
2021-01-07 02:00:00	NQ	Futures	14750.99	14775.01	14701.5	14714.52	9611.0
2021-01-07 03:00:00	NQ	Futures	14713.94	14722.34	14657.21	14688.76	11402.0
2021-01-07 04:00:00	NQ	Futures	14689.63	14723.78	14672.26	14688.18	9641.0
2021-01-07 05:00:00	NQ	Futures	14687.31	14715.68	14669.08	14671.4	7213.0
2021-01-07 06:00:00	NQ	Futures	14671.69	14702.37	14659.82	14687.6	6314.0
2021-01-07 07:00:00	NQ	Futures	14687.6	14732.18	14685.58	14720.31	8615.0
2021-01-07 08:00:00	NQ	Futures	14720.89	14735.36	14708.44	14715.1	9851.0
2021-01-07 09:00:00	NQ	Futures	14714.81	14865.03	14713.94	14863.0	74963.0
2021-01-07 10:00:00	NQ	Futures	14863.29	14945.2	14856.63	14935.36	72625.0
2021-01-07 11:00:00	NQ	Futures	14935.36	14958.8	14906.71	14925.52	42079.0
2021-01-07 12:00:00	NQ	Futures	14925.81	14936.23	14898.6	14927.83	28442.0
2021-01-07 13:00:00	NQ	Futures	14927.83	14955.62	14899.18	14949.54	26595.0
2021-01-07 14:00:00	NQ	Futures	14949.83	14960.54	14938.25	14955.33	20899.0
2021-01-07 15:00:00	NQ	Futures	14955.33	15003.09	14951.28	14964.3	52065.0
2021-01-07 16:00:00	NQ	Futures	14964.01	14980.8	14957.65	14964.59	13149.0
2021-01-07 18:00:00	NQ	Futures	14966.04	14986.3	14956.78	14979.93	3865.0
2021-01-07 19:00:00	NQ	Futures	14981.09	15001.06	14972.41	14995.85	3919.0
2021-01-07 20:00:00	NQ	Futures	14995.85	15021.03	14981.38	15009.45	5036.0
2021-01-07 21:00:00	NQ	Futures	15009.74	15025.37	14995.85	15002.8	4327.0
2021-01-07 22:00:00	NQ	Futures	15002.8	15014.09	14991.8	15012.06	2426.0
2021-01-07 23:00:00	NQ	Futures	15011.48	15013.51	14988.33	15001.35	3349.0
2021-01-07 00:00:00	YM	Futures	34207.6	34237.5	34181.0	34234.2	1835.0
2021-01-07 01:00:00	YM	Futures	34235.3	34281.9	34233.1	34275.2	1951.0
2021-01-07 02:00:00	YM	Futures	34275.2	34317.4	34275.2	34295.2	4772.0
2021-01-07 03:00:00	YM	Futures	34294.1	34297.4	34192.0	34243.1	7411.0

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

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