PREVIEW / futures_1hour / 2020-09-29

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-09-29.parquet
  size:    60 KB
  rows:    1,874

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-09-29 00:00:00	ES	Futures	3758.87	3766.43	3758.59	3766.15	8196.0
2020-09-29 01:00:00	ES	Futures	3766.43	3767.83	3756.35	3761.95	17726.0
2020-09-29 02:00:00	ES	Futures	3762.23	3762.79	3749.91	3751.59	18808.0
2020-09-29 03:00:00	ES	Futures	3751.31	3752.99	3735.62	3742.06	33237.0
2020-09-29 04:00:00	ES	Futures	3742.34	3746.54	3733.1	3743.74	23540.0
2020-09-29 05:00:00	ES	Futures	3743.46	3747.38	3737.58	3745.98	18601.0
2020-09-29 06:00:00	ES	Futures	3746.26	3750.75	3744.02	3746.26	16459.0
2020-09-29 07:00:00	ES	Futures	3746.26	3752.15	3742.06	3743.18	19789.0
2020-09-29 08:00:00	ES	Futures	3743.46	3747.38	3738.7	3745.98	20830.0
2020-09-29 09:00:00	ES	Futures	3745.7	3747.94	3736.46	3741.5	135519.0
2020-09-29 10:00:00	ES	Futures	3741.78	3751.31	3727.5	3731.14	213011.0
2020-09-29 11:00:00	ES	Futures	3730.86	3735.62	3717.97	3721.9	190975.0
2020-09-29 12:00:00	ES	Futures	3721.9	3728.62	3716.85	3727.78	114796.0
2020-09-29 13:00:00	ES	Futures	3728.06	3738.14	3715.73	3734.22	125731.0
2020-09-29 14:00:00	ES	Futures	3734.5	3741.5	3730.58	3735.06	80655.0
2020-09-29 15:00:00	ES	Futures	3735.34	3740.38	3724.42	3724.98	172241.0
2020-09-29 16:00:00	ES	Futures	3724.98	3738.98	3724.14	3730.58	50210.0
2020-09-29 18:00:00	ES	Futures	3730.86	3738.98	3728.06	3735.9	10052.0
2020-09-29 19:00:00	ES	Futures	3736.18	3739.82	3735.9	3737.86	6339.0
2020-09-29 20:00:00	ES	Futures	3737.58	3742.62	3734.78	3736.46	10846.0
2020-09-29 21:00:00	ES	Futures	3735.9	3749.34	3735.34	3748.78	21349.0
2020-09-29 22:00:00	ES	Futures	3748.78	3762.51	3728.9	3733.66	44620.0
2020-09-29 23:00:00	ES	Futures	3733.66	3734.78	3712.65	3713.21	31993.0
2020-09-29 00:00:00	NQ	Futures	13213.09	13251.88	13210.77	13250.72	3743.0
2020-09-29 01:00:00	NQ	Futures	13251.3	13256.22	13213.09	13240.59	8596.0
2020-09-29 02:00:00	NQ	Futures	13240.3	13243.48	13174.3	13184.72	7067.0
2020-09-29 03:00:00	NQ	Futures	13183.27	13192.54	13134.93	13169.38	11019.0
2020-09-29 04:00:00	NQ	Futures	13170.54	13173.43	13123.06	13159.54	8964.0
2020-09-29 05:00:00	NQ	Futures	13158.96	13176.33	13132.91	13165.9	6105.0
2020-09-29 06:00:00	NQ	Futures	13165.33	13188.19	13151.72	13168.51	5587.0
2020-09-29 07:00:00	NQ	Futures	13170.54	13191.38	13140.14	13145.64	8850.0
2020-09-29 08:00:00	NQ	Futures	13144.77	13170.54	13130.59	13163.88	10455.0
2020-09-29 09:00:00	NQ	Futures	13163.59	13176.62	13117.56	13138.12	57538.0
2020-09-29 10:00:00	NQ	Futures	13137.83	13183.56	13071.83	13104.83	76998.0
2020-09-29 11:00:00	NQ	Futures	13104.83	13157.8	13084.56	13112.64	55272.0
2020-09-29 12:00:00	NQ	Futures	13112.35	13143.04	13095.85	13137.54	35269.0
2020-09-29 13:00:00	NQ	Futures	13136.96	13153.46	13074.72	13138.41	34890.0
2020-09-29 14:00:00	NQ	Futures	13138.41	13160.12	13119.01	13136.09	28361.0
2020-09-29 15:00:00	NQ	Futures	13136.38	13149.98	13078.2	13095.27	45224.0
2020-09-29 16:00:00	NQ	Futures	13095.27	13138.98	13093.25	13107.14	8978.0
2020-09-29 18:00:00	NQ	Futures	13108.3	13138.69	13098.46	13132.04	3135.0
2020-09-29 19:00:00	NQ	Futures	13132.04	13143.04	13124.22	13130.59	2489.0
2020-09-29 20:00:00	NQ	Futures	13130.01	13149.98	13113.22	13123.93	4012.0
2020-09-29 21:00:00	NQ	Futures	13122.48	13175.17	13119.01	13170.54	9173.0
2020-09-29 22:00:00	NQ	Futures	13170.83	13231.04	13107.43	13121.33	18336.0
2020-09-29 23:00:00	NQ	Futures	13121.91	13128.56	13033.62	13040.85	13776.0
2020-09-29 00:00:00	YM	Futures	30468.7	30528.4	30465.3	30521.7	1892.0
2020-09-29 01:00:00	YM	Futures	30522.8	30536.1	30431.1	30479.7	3415.0
2020-09-29 02:00:00	YM	Futures	30479.7	30487.5	30389.1	30400.1	3502.0
2020-09-29 03:00:00	YM	Futures	30399.0	30410.1	30271.9	30315.0	6369.0

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

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