PREVIEW / futures_1hour / 2021-04-28

all futures 1-hour files

  file:    by_date/futures_1hour/2021/2021-04-28.parquet
  size:    63 KB
  rows:    1,945

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-04-28 00:00:00	ES	Futures	4702.86	4703.43	4702.02	4702.58	1128.0
2021-04-28 01:00:00	ES	Futures	4702.3	4703.71	4700.62	4701.18	5222.0
2021-04-28 02:00:00	ES	Futures	4701.18	4703.43	4700.34	4702.86	4637.0
2021-04-28 03:00:00	ES	Futures	4702.58	4704.27	4694.15	4697.53	16733.0
2021-04-28 04:00:00	ES	Futures	4697.53	4700.9	4695.28	4700.34	10203.0
2021-04-28 05:00:00	ES	Futures	4700.34	4702.02	4696.96	4700.34	11888.0
2021-04-28 06:00:00	ES	Futures	4700.34	4702.58	4698.37	4700.34	9185.0
2021-04-28 07:00:00	ES	Futures	4700.34	4703.15	4693.03	4696.12	17956.0
2021-04-28 08:00:00	ES	Futures	4696.12	4698.65	4695.28	4698.65	13272.0
2021-04-28 09:00:00	ES	Futures	4698.65	4706.52	4694.15	4706.24	151125.0
2021-04-28 10:00:00	ES	Futures	4706.24	4707.08	4698.93	4702.3	159640.0
2021-04-28 11:00:00	ES	Futures	4702.58	4703.15	4693.31	4693.87	123454.0
2021-04-28 12:00:00	ES	Futures	4694.15	4700.62	4692.19	4699.77	88658.0
2021-04-28 13:00:00	ES	Futures	4699.49	4700.05	4693.31	4694.44	49259.0
2021-04-28 14:00:00	ES	Futures	4694.15	4713.26	4689.66	4705.39	232775.0
2021-04-28 15:00:00	ES	Futures	4705.67	4708.2	4691.34	4695.56	272838.0
2021-04-28 16:00:00	ES	Futures	4695.28	4706.8	4694.72	4703.15	54825.0
2021-04-28 18:00:00	ES	Futures	4703.15	4705.67	4701.74	4705.39	4684.0
2021-04-28 19:00:00	ES	Futures	4705.11	4708.2	4703.99	4707.36	3002.0
2021-04-28 20:00:00	ES	Futures	4707.36	4714.1	4706.52	4712.7	8997.0
2021-04-28 21:00:00	ES	Futures	4712.7	4723.94	4711.57	4721.69	15195.0
2021-04-28 22:00:00	ES	Futures	4721.97	4721.97	4719.44	4720.28	6381.0
2021-04-28 23:00:00	ES	Futures	4720.28	4720.57	4718.04	4718.88	3422.0
2021-04-28 00:00:00	NQ	Futures	16180.76	16185.68	16178.73	16180.18	1005.0
2021-04-28 01:00:00	NQ	Futures	16180.47	16185.1	16157.6	16165.42	3435.0
2021-04-28 02:00:00	NQ	Futures	16165.71	16170.34	16159.63	16168.6	2209.0
2021-04-28 03:00:00	NQ	Futures	16168.89	16172.94	16101.44	16127.49	10057.0
2021-04-28 04:00:00	NQ	Futures	16127.2	16146.31	16119.68	16141.68	5859.0
2021-04-28 05:00:00	NQ	Futures	16141.39	16146.02	16119.1	16128.07	6139.0
2021-04-28 06:00:00	NQ	Futures	16128.36	16145.15	16126.91	16137.91	4059.0
2021-04-28 07:00:00	NQ	Futures	16138.78	16154.42	16116.49	16126.91	8151.0
2021-04-28 08:00:00	NQ	Futures	16126.33	16137.91	16120.54	16130.39	6871.0
2021-04-28 09:00:00	NQ	Futures	16130.97	16181.05	16079.15	16179.6	75423.0
2021-04-28 10:00:00	NQ	Futures	16179.6	16189.73	16096.52	16122.86	78443.0
2021-04-28 11:00:00	NQ	Futures	16122.86	16132.12	16081.17	16084.36	56044.0
2021-04-28 12:00:00	NQ	Futures	16084.36	16124.89	16070.46	16117.07	38909.0
2021-04-28 13:00:00	NQ	Futures	16116.78	16125.76	16099.41	16102.02	21565.0
2021-04-28 14:00:00	NQ	Futures	16102.31	16191.18	16075.38	16157.6	73459.0
2021-04-28 15:00:00	NQ	Futures	16157.89	16165.42	16078.57	16091.02	67892.0
2021-04-28 16:00:00	NQ	Futures	16090.73	16204.21	16090.15	16175.55	22945.0
2021-04-28 18:00:00	NQ	Futures	16181.05	16181.05	16156.73	16167.73	3303.0
2021-04-28 19:00:00	NQ	Futures	16167.73	16180.47	16163.68	16179.02	2165.0
2021-04-28 20:00:00	NQ	Futures	16179.02	16207.39	16176.13	16203.05	5056.0
2021-04-28 21:00:00	NQ	Futures	16203.05	16247.63	16193.79	16236.92	7477.0
2021-04-28 22:00:00	NQ	Futures	16237.5	16243.0	16231.71	16233.16	3298.0
2021-04-28 23:00:00	NQ	Futures	16233.74	16240.4	16228.82	16231.42	1884.0
2021-04-28 00:00:00	YM	Futures	37692.7	37703.9	37688.3	37690.5	347.0
2021-04-28 01:00:00	YM	Futures	37691.6	37709.4	37683.8	37692.7	915.0
2021-04-28 02:00:00	YM	Futures	37692.7	37712.8	37687.2	37703.9	861.0
2021-04-28 03:00:00	YM	Futures	37701.6	37722.8	37663.8	37677.1	3146.0

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

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