PREVIEW / futures_1hour / 2018-08-30

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-08-30.parquet
  size:    54 KB
  rows:    1,688

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
2018-08-30 00:00:00	ES	Futures	3174.23	3174.78	3173.69	3174.23	1632.0
2018-08-30 01:00:00	ES	Futures	3174.5	3174.5	3172.05	3172.6	5672.0
2018-08-30 02:00:00	ES	Futures	3172.6	3174.23	3172.05	3173.96	5837.0
2018-08-30 03:00:00	ES	Futures	3174.23	3174.23	3170.96	3172.05	15378.0
2018-08-30 04:00:00	ES	Futures	3172.05	3172.87	3168.24	3170.15	24376.0
2018-08-30 05:00:00	ES	Futures	3170.15	3171.24	3169.33	3170.42	11664.0
2018-08-30 06:00:00	ES	Futures	3170.42	3172.87	3168.51	3171.51	17067.0
2018-08-30 07:00:00	ES	Futures	3171.51	3173.14	3170.42	3171.24	13241.0
2018-08-30 08:00:00	ES	Futures	3170.96	3173.96	3170.15	3170.96	22451.0
2018-08-30 09:00:00	ES	Futures	3170.96	3172.87	3168.51	3169.33	167160.0
2018-08-30 10:00:00	ES	Futures	3169.33	3174.78	3169.33	3172.05	126180.0
2018-08-30 11:00:00	ES	Futures	3172.05	3174.5	3164.97	3166.88	147308.0
2018-08-30 12:00:00	ES	Futures	3167.15	3172.87	3166.06	3172.05	82855.0
2018-08-30 13:00:00	ES	Futures	3172.05	3174.5	3171.78	3173.14	76953.0
2018-08-30 14:00:00	ES	Futures	3173.14	3174.5	3158.43	3160.88	247465.0
2018-08-30 15:00:00	ES	Futures	3160.61	3163.88	3155.7	3162.24	249241.0
2018-08-30 16:00:00	ES	Futures	3162.24	3164.42	3159.25	3159.52	47369.0
2018-08-30 18:00:00	ES	Futures	3158.43	3159.79	3156.25	3158.16	5853.0
2018-08-30 19:00:00	ES	Futures	3158.16	3160.06	3157.88	3157.88	2311.0
2018-08-30 20:00:00	ES	Futures	3158.16	3160.61	3156.79	3159.25	6545.0
2018-08-30 21:00:00	ES	Futures	3159.52	3162.79	3159.25	3161.7	9815.0
2018-08-30 22:00:00	ES	Futures	3161.7	3161.97	3159.25	3159.79	4798.0
2018-08-30 23:00:00	ES	Futures	3159.79	3163.06	3159.52	3162.24	4099.0
2018-08-30 00:00:00	NQ	Futures	9021.56	9023.33	9020.68	9022.15	798.0
2018-08-30 01:00:00	NQ	Futures	9021.86	9021.86	9015.38	9017.44	2428.0
2018-08-30 02:00:00	NQ	Futures	9017.14	9024.51	9014.79	9022.74	2349.0
2018-08-30 03:00:00	NQ	Futures	9022.74	9023.62	9013.91	9017.14	3968.0
2018-08-30 04:00:00	NQ	Futures	9017.14	9019.5	9006.55	9012.14	6016.0
2018-08-30 05:00:00	NQ	Futures	9012.14	9015.38	9009.49	9011.85	4009.0
2018-08-30 06:00:00	NQ	Futures	9011.85	9019.21	9005.96	9013.91	4943.0
2018-08-30 07:00:00	NQ	Futures	9013.91	9019.79	9012.14	9013.91	3721.0
2018-08-30 08:00:00	NQ	Futures	9013.91	9023.62	9011.85	9013.02	5970.0
2018-08-30 09:00:00	NQ	Futures	9012.73	9023.92	9000.36	9007.72	53193.0
2018-08-30 10:00:00	NQ	Futures	9007.43	9045.7	9006.84	9035.4	55505.0
2018-08-30 11:00:00	NQ	Futures	9035.4	9045.11	9017.44	9032.16	49120.0
2018-08-30 12:00:00	NQ	Futures	9032.16	9059.84	9031.87	9057.48	30146.0
2018-08-30 13:00:00	NQ	Futures	9057.48	9064.55	9050.41	9054.24	24597.0
2018-08-30 14:00:00	NQ	Futures	9054.54	9061.9	9000.95	9000.95	59891.0
2018-08-30 15:00:00	NQ	Futures	9000.95	9010.96	8981.23	9009.2	62713.0
2018-08-30 16:00:00	NQ	Futures	9009.2	9013.32	9000.36	9000.36	7283.0
2018-08-30 18:00:00	NQ	Futures	8999.48	9003.6	8991.82	8998.3	1697.0
2018-08-30 19:00:00	NQ	Futures	8998.01	9005.66	8997.71	8998.01	1547.0
2018-08-30 20:00:00	NQ	Futures	8998.3	9005.66	8993.0	9002.42	2730.0
2018-08-30 21:00:00	NQ	Futures	9002.13	9016.26	9002.13	9013.91	4380.0
2018-08-30 22:00:00	NQ	Futures	9014.2	9014.49	9004.48	9007.13	2607.0
2018-08-30 23:00:00	NQ	Futures	9007.13	9017.73	9005.66	9015.67	3276.0
2018-08-30 00:00:00	YM	Futures	28389.6	28391.7	28383.0	28387.4	414.0
2018-08-30 01:00:00	YM	Futures	28386.3	28388.5	28360.2	28367.8	1532.0
2018-08-30 02:00:00	YM	Futures	28366.7	28383.0	28360.2	28378.7	1158.0
2018-08-30 03:00:00	YM	Futures	28379.8	28380.9	28345.0	28353.7	2788.0

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

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