PREVIEW / futures_1hour / 2020-07-07

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-07-07.parquet
  size:    59 KB
  rows:    1,818

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
2020-07-07 00:00:00	ES	Futures	3535.78	3536.9	3530.48	3535.22	5862.0
2020-07-07 01:00:00	ES	Futures	3534.94	3538.02	3527.68	3530.48	9271.0
2020-07-07 02:00:00	ES	Futures	3530.48	3531.31	3521.26	3527.4	16993.0
2020-07-07 03:00:00	ES	Futures	3527.12	3529.36	3512.6	3520.7	33301.0
2020-07-07 04:00:00	ES	Futures	3520.42	3527.12	3510.93	3514.84	26415.0
2020-07-07 05:00:00	ES	Futures	3514.84	3515.68	3507.58	3511.49	24021.0
2020-07-07 06:00:00	ES	Futures	3511.77	3518.47	3505.34	3511.77	28237.0
2020-07-07 07:00:00	ES	Futures	3511.77	3522.94	3509.53	3520.14	23402.0
2020-07-07 08:00:00	ES	Futures	3519.86	3522.38	3514.0	3520.98	26629.0
2020-07-07 09:00:00	ES	Futures	3520.7	3531.31	3516.51	3528.52	153885.0
2020-07-07 10:00:00	ES	Futures	3528.52	3540.25	3526.57	3538.02	173490.0
2020-07-07 11:00:00	ES	Futures	3537.74	3545.55	3534.94	3536.9	125487.0
2020-07-07 12:00:00	ES	Futures	3536.9	3539.69	3527.4	3532.71	81842.0
2020-07-07 13:00:00	ES	Futures	3532.71	3534.66	3525.17	3530.76	86628.0
2020-07-07 14:00:00	ES	Futures	3530.76	3531.87	3517.35	3522.66	109135.0
2020-07-07 15:00:00	ES	Futures	3522.94	3522.94	3498.92	3503.39	244985.0
2020-07-07 16:00:00	ES	Futures	3503.39	3506.46	3500.88	3502.27	52141.0
2020-07-07 18:00:00	ES	Futures	3501.99	3507.58	3501.16	3503.11	9684.0
2020-07-07 19:00:00	ES	Futures	3503.11	3509.25	3502.83	3507.58	6432.0
2020-07-07 20:00:00	ES	Futures	3507.58	3513.72	3501.71	3510.65	16103.0
2020-07-07 21:00:00	ES	Futures	3510.37	3518.19	3508.42	3508.69	16991.0
2020-07-07 22:00:00	ES	Futures	3508.69	3513.16	3503.95	3512.88	12013.0
2020-07-07 23:00:00	ES	Futures	3513.16	3515.68	3508.97	3509.81	6793.0
2020-07-07 00:00:00	NQ	Futures	12275.05	12275.92	12253.36	12265.22	3184.0
2020-07-07 01:00:00	NQ	Futures	12264.64	12276.5	12245.84	12253.65	4192.0
2020-07-07 02:00:00	NQ	Futures	12253.65	12257.12	12222.42	12238.9	7302.0
2020-07-07 03:00:00	NQ	Futures	12237.46	12244.69	12189.74	12212.01	9860.0
2020-07-07 04:00:00	NQ	Futures	12211.72	12238.32	12191.19	12201.31	9292.0
2020-07-07 05:00:00	NQ	Futures	12201.6	12209.41	12184.25	12202.47	6811.0
2020-07-07 06:00:00	NQ	Futures	12202.47	12215.77	12179.91	12203.33	7589.0
2020-07-07 07:00:00	NQ	Futures	12202.76	12225.89	12195.82	12220.4	7790.0
2020-07-07 08:00:00	NQ	Futures	12220.4	12232.54	12210.27	12230.81	7863.0
2020-07-07 09:00:00	NQ	Futures	12230.52	12299.63	12211.72	12269.56	63746.0
2020-07-07 10:00:00	NQ	Futures	12269.85	12345.61	12260.01	12333.46	61354.0
2020-07-07 11:00:00	NQ	Futures	12333.18	12370.48	12317.27	12325.66	42046.0
2020-07-07 12:00:00	NQ	Futures	12325.95	12336.93	12272.74	12303.1	36123.0
2020-07-07 13:00:00	NQ	Futures	12303.1	12310.04	12259.15	12274.47	34194.0
2020-07-07 14:00:00	NQ	Futures	12274.18	12279.68	12216.64	12245.84	41205.0
2020-07-07 15:00:00	NQ	Futures	12245.84	12246.13	12152.15	12164.87	62409.0
2020-07-07 16:00:00	NQ	Futures	12164.87	12189.45	12164.01	12176.44	12477.0
2020-07-07 18:00:00	NQ	Futures	12175.57	12201.31	12172.68	12189.45	3907.0
2020-07-07 19:00:00	NQ	Futures	12189.16	12207.96	12189.16	12203.62	2934.0
2020-07-07 20:00:00	NQ	Futures	12203.33	12225.89	12184.25	12210.85	6108.0
2020-07-07 21:00:00	NQ	Futures	12211.43	12229.65	12198.71	12199.86	6765.0
2020-07-07 22:00:00	NQ	Futures	12200.15	12211.43	12184.54	12210.85	5932.0
2020-07-07 23:00:00	NQ	Futures	12210.56	12219.53	12195.53	12199.57	3390.0
2020-07-07 00:00:00	YM	Futures	28739.8	28751.9	28689.1	28732.0	2075.0
2020-07-07 01:00:00	YM	Futures	28732.0	28760.7	28663.8	28685.8	2810.0
2020-07-07 02:00:00	YM	Futures	28688.0	28693.5	28599.9	28650.6	4904.0
2020-07-07 03:00:00	YM	Futures	28648.4	28671.5	28526.1	28595.5	8212.0

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

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