PREVIEW / futures_1hour / 2020-07-13

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-07-13.parquet
  size:    61 KB
  rows:    1,841

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-13 00:00:00	ES	Futures	3565.66	3567.89	3564.82	3565.38	4274.0
2020-07-13 01:00:00	ES	Futures	3565.66	3573.48	3565.38	3572.64	9641.0
2020-07-13 02:00:00	ES	Futures	3572.64	3577.39	3566.78	3566.78	17975.0
2020-07-13 03:00:00	ES	Futures	3566.78	3570.41	3561.47	3563.15	28787.0
2020-07-13 04:00:00	ES	Futures	3562.87	3564.82	3554.49	3560.35	19778.0
2020-07-13 05:00:00	ES	Futures	3560.63	3566.22	3557.28	3565.38	18853.0
2020-07-13 06:00:00	ES	Futures	3565.38	3571.25	3562.31	3570.41	17915.0
2020-07-13 07:00:00	ES	Futures	3570.41	3579.06	3569.57	3576.27	26848.0
2020-07-13 08:00:00	ES	Futures	3576.27	3577.67	3571.52	3573.2	25555.0
2020-07-13 09:00:00	ES	Futures	3573.2	3578.51	3567.62	3568.73	158644.0
2020-07-13 10:00:00	ES	Futures	3568.45	3591.91	3564.26	3591.63	224336.0
2020-07-13 11:00:00	ES	Futures	3591.63	3599.45	3589.4	3592.47	191203.0
2020-07-13 12:00:00	ES	Futures	3592.75	3596.1	3590.23	3591.91	108046.0
2020-07-13 13:00:00	ES	Futures	3591.91	3603.64	3590.23	3594.98	121075.0
2020-07-13 14:00:00	ES	Futures	3594.7	3596.66	3563.15	3577.95	314378.0
2020-07-13 15:00:00	ES	Futures	3577.67	3579.06	3507.86	3516.23	567335.0
2020-07-13 16:00:00	ES	Futures	3515.96	3519.59	3508.69	3516.79	86033.0
2020-07-13 18:00:00	ES	Futures	3518.19	3529.36	3517.63	3521.82	19661.0
2020-07-13 19:00:00	ES	Futures	3521.54	3531.03	3521.26	3524.33	17390.0
2020-07-13 20:00:00	ES	Futures	3524.05	3527.4	3518.75	3522.38	15173.0
2020-07-13 21:00:00	ES	Futures	3522.38	3525.73	3510.65	3524.33	21446.0
2020-07-13 22:00:00	ES	Futures	3524.05	3526.57	3515.68	3520.14	16846.0
2020-07-13 23:00:00	ES	Futures	3520.14	3524.33	3517.35	3519.31	9030.0
2020-07-13 00:00:00	NQ	Futures	12583.31	12588.23	12576.95	12583.89	2164.0
2020-07-13 01:00:00	NQ	Futures	12584.18	12609.63	12583.31	12606.74	4217.0
2020-07-13 02:00:00	NQ	Futures	12606.45	12627.85	12602.98	12605.58	7576.0
2020-07-13 03:00:00	NQ	Futures	12605.0	12612.52	12589.97	12592.86	11049.0
2020-07-13 04:00:00	NQ	Futures	12592.57	12597.77	12568.86	12590.26	9295.0
2020-07-13 05:00:00	NQ	Futures	12590.54	12605.0	12576.66	12602.98	7720.0
2020-07-13 06:00:00	NQ	Futures	12602.69	12620.04	12595.17	12617.44	7016.0
2020-07-13 07:00:00	NQ	Futures	12617.15	12655.61	12615.41	12654.45	10630.0
2020-07-13 08:00:00	NQ	Futures	12654.45	12668.04	12640.57	12650.4	10060.0
2020-07-13 09:00:00	NQ	Futures	12650.12	12720.39	12642.31	12683.37	67210.0
2020-07-13 10:00:00	NQ	Futures	12683.37	12757.98	12658.21	12756.53	72192.0
2020-07-13 11:00:00	NQ	Futures	12755.95	12791.52	12741.78	12761.45	60707.0
2020-07-13 12:00:00	NQ	Futures	12761.74	12772.15	12682.5	12684.24	43878.0
2020-07-13 13:00:00	NQ	Futures	12684.82	12741.21	12656.48	12661.39	53264.0
2020-07-13 14:00:00	NQ	Futures	12661.1	12674.98	12469.96	12574.06	127918.0
2020-07-13 15:00:00	NQ	Futures	12574.06	12578.11	12216.64	12259.43	173226.0
2020-07-13 16:00:00	NQ	Futures	12260.01	12281.7	12223.58	12262.62	25855.0
2020-07-13 18:00:00	NQ	Futures	12263.48	12316.4	12261.75	12299.63	7999.0
2020-07-13 19:00:00	NQ	Futures	12299.34	12331.73	12299.05	12314.38	5596.0
2020-07-13 20:00:00	NQ	Futures	12313.51	12323.34	12283.73	12312.35	8560.0
2020-07-13 21:00:00	NQ	Futures	12312.93	12324.21	12273.32	12321.32	7867.0
2020-07-13 22:00:00	NQ	Futures	12321.32	12329.42	12281.7	12292.4	7128.0
2020-07-13 23:00:00	NQ	Futures	12292.11	12309.75	12282.86	12292.4	3483.0
2020-07-13 00:00:00	YM	Futures	28765.1	28786.0	28754.1	28762.9	1279.0
2020-07-13 01:00:00	YM	Futures	28764.0	28833.4	28761.8	28820.1	3342.0
2020-07-13 02:00:00	YM	Futures	28821.2	28866.4	28770.6	28771.7	4033.0
2020-07-13 03:00:00	YM	Futures	28769.5	28801.4	28715.5	28730.9	5694.0

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

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