PREVIEW / futures_1hour / 2021-05-14

all futures 1-hour files

  file:    by_date/futures_1hour/2021/2021-05-14.parquet
  size:    54 KB
  rows:    1,586

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-05-14 00:00:00	ES	Futures	4636.56	4639.08	4633.75	4635.71	5704.0
2021-05-14 01:00:00	ES	Futures	4635.71	4643.3	4635.71	4641.89	11907.0
2021-05-14 02:00:00	ES	Futures	4641.89	4645.83	4634.03	4644.7	15000.0
2021-05-14 03:00:00	ES	Futures	4644.42	4645.27	4632.9	4636.84	22345.0
2021-05-14 04:00:00	ES	Futures	4636.56	4645.27	4634.87	4643.58	15009.0
2021-05-14 05:00:00	ES	Futures	4643.86	4650.6	4643.02	4644.7	17294.0
2021-05-14 06:00:00	ES	Futures	4644.42	4645.83	4641.05	4642.18	11712.0
2021-05-14 07:00:00	ES	Futures	4641.89	4649.2	4640.49	4646.39	21747.0
2021-05-14 08:00:00	ES	Futures	4646.11	4648.92	4633.47	4644.7	57397.0
2021-05-14 09:00:00	ES	Futures	4644.7	4666.62	4641.61	4666.62	208201.0
2021-05-14 10:00:00	ES	Futures	4666.34	4671.68	4657.07	4670.83	263284.0
2021-05-14 11:00:00	ES	Futures	4670.83	4676.17	4665.78	4671.96	119448.0
2021-05-14 12:00:00	ES	Futures	4671.96	4681.79	4671.12	4681.23	75910.0
2021-05-14 13:00:00	ES	Futures	4681.51	4684.88	4679.54	4683.76	78171.0
2021-05-14 14:00:00	ES	Futures	4683.48	4695.84	4682.07	4692.47	108207.0
2021-05-14 15:00:00	ES	Futures	4692.75	4694.72	4682.07	4685.44	293710.0
2021-05-14 16:00:00	ES	Futures	4685.16	4693.59	4683.48	4690.22	72343.0
2021-05-14 00:00:00	NQ	Futures	15262.48	15277.82	15248.59	15256.98	2863.0
2021-05-14 01:00:00	NQ	Futures	15256.11	15284.77	15253.8	15275.8	5904.0
2021-05-14 02:00:00	NQ	Futures	15275.51	15307.35	15242.51	15302.43	8768.0
2021-05-14 03:00:00	NQ	Futures	15301.27	15304.75	15246.27	15262.19	8832.0
2021-05-14 04:00:00	NQ	Futures	15261.32	15312.27	15256.98	15301.27	7575.0
2021-05-14 05:00:00	NQ	Futures	15302.72	15355.41	15298.09	15331.09	10368.0
2021-05-14 06:00:00	NQ	Futures	15331.09	15339.2	15312.27	15315.75	4133.0
2021-05-14 07:00:00	NQ	Futures	15315.46	15343.83	15306.48	15324.14	7555.0
2021-05-14 08:00:00	NQ	Futures	15323.27	15348.75	15287.67	15331.38	16734.0
2021-05-14 09:00:00	NQ	Futures	15331.38	15364.67	15295.48	15364.09	64012.0
2021-05-14 10:00:00	NQ	Futures	15363.23	15433.86	15322.99	15432.41	75799.0
2021-05-14 11:00:00	NQ	Futures	15431.84	15455.28	15411.28	15437.91	38750.0
2021-05-14 12:00:00	NQ	Futures	15437.34	15477.0	15431.26	15471.21	29298.0
2021-05-14 13:00:00	NQ	Futures	15471.5	15485.68	15456.15	15481.05	26487.0
2021-05-14 14:00:00	NQ	Futures	15481.34	15547.34	15473.52	15536.34	40394.0
2021-05-14 15:00:00	NQ	Futures	15536.63	15543.29	15487.71	15499.0	67862.0
2021-05-14 16:00:00	NQ	Futures	15498.71	15519.84	15489.45	15514.63	13068.0
2021-05-14 00:00:00	YM	Futures	37935.5	37960.0	37925.5	37940.0	1273.0
2021-05-14 01:00:00	YM	Futures	37938.9	38006.8	37937.8	37985.7	3007.0
2021-05-14 02:00:00	YM	Futures	37984.5	38014.6	37926.6	37999.0	3219.0
2021-05-14 03:00:00	YM	Futures	38000.1	38007.9	37914.4	37940.0	4540.0
2021-05-14 04:00:00	YM	Futures	37937.8	37986.8	37904.4	37974.5	3559.0
2021-05-14 05:00:00	YM	Futures	37974.5	38007.9	37951.1	37965.6	2742.0
2021-05-14 06:00:00	YM	Futures	37963.4	37982.3	37942.2	37954.5	2187.0
2021-05-14 07:00:00	YM	Futures	37954.5	38002.4	37943.3	37993.5	2901.0
2021-05-14 08:00:00	YM	Futures	37995.7	38011.3	37870.9	37954.5	7568.0
2021-05-14 09:00:00	YM	Futures	37954.5	38168.3	37928.9	38166.1	29157.0
2021-05-14 10:00:00	YM	Futures	38167.2	38181.7	38002.4	38109.3	30243.0
2021-05-14 11:00:00	YM	Futures	38107.1	38148.3	38062.5	38103.7	11348.0
2021-05-14 12:00:00	YM	Futures	38103.7	38188.4	38103.7	38183.9	8301.0
2021-05-14 13:00:00	YM	Futures	38183.9	38221.8	38172.8	38212.9	7285.0
2021-05-14 14:00:00	YM	Futures	38212.9	38295.3	38208.4	38264.1	11908.0
2021-05-14 15:00:00	YM	Futures	38265.2	38294.2	38201.7	38222.9	19556.0

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

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