PREVIEW / futures_1hour / 2019-08-23

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-08-23.parquet
  size:    51 KB
  rows:    1,491

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
2019-08-23 00:00:00	ES	Futures	3174.83	3175.91	3173.48	3174.83	2970.0
2019-08-23 01:00:00	ES	Futures	3175.1	3177.81	3174.02	3177.81	6508.0
2019-08-23 02:00:00	ES	Futures	3178.08	3179.97	3175.91	3175.91	13006.0
2019-08-23 03:00:00	ES	Futures	3175.91	3179.7	3173.75	3174.56	19825.0
2019-08-23 04:00:00	ES	Futures	3174.56	3178.89	3173.48	3176.45	14823.0
2019-08-23 05:00:00	ES	Futures	3176.45	3178.62	3173.75	3175.64	15312.0
2019-08-23 06:00:00	ES	Futures	3175.64	3176.72	3169.41	3171.58	26421.0
2019-08-23 07:00:00	ES	Futures	3171.58	3176.99	3171.31	3174.83	25021.0
2019-08-23 08:00:00	ES	Futures	3174.56	3174.83	3142.89	3152.63	208720.0
2019-08-23 09:00:00	ES	Futures	3152.9	3153.44	3141.26	3149.92	205586.0
2019-08-23 10:00:00	ES	Futures	3149.92	3170.23	3144.51	3159.67	379469.0
2019-08-23 11:00:00	ES	Futures	3159.94	3162.65	3103.09	3103.9	571698.0
2019-08-23 12:00:00	ES	Futures	3103.9	3114.73	3100.39	3104.99	226234.0
2019-08-23 13:00:00	ES	Futures	3104.99	3107.15	3093.89	3103.09	182161.0
2019-08-23 14:00:00	ES	Futures	3103.36	3103.36	3089.29	3095.24	142548.0
2019-08-23 15:00:00	ES	Futures	3095.24	3099.57	3068.71	3083.6	477754.0
2019-08-23 16:00:00	ES	Futures	3083.6	3097.14	3082.79	3087.66	161569.0
2019-08-23 00:00:00	NQ	Futures	8992.38	8996.45	8986.87	8990.93	1718.0
2019-08-23 01:00:00	NQ	Futures	8991.22	9003.12	8989.77	9003.12	3075.0
2019-08-23 02:00:00	NQ	Futures	9003.41	9008.34	8995.0	8995.58	5135.0
2019-08-23 03:00:00	NQ	Futures	8995.58	9007.76	8984.55	8987.16	9543.0
2019-08-23 04:00:00	NQ	Futures	8987.45	9004.57	8984.55	8997.03	6740.0
2019-08-23 05:00:00	NQ	Futures	8997.03	9003.7	8987.16	8992.67	6015.0
2019-08-23 06:00:00	NQ	Futures	8992.38	8997.32	8968.01	8976.72	8757.0
2019-08-23 07:00:00	NQ	Futures	8976.43	8993.55	8973.24	8984.84	8901.0
2019-08-23 08:00:00	NQ	Futures	8984.84	8984.84	8867.04	8903.6	58635.0
2019-08-23 09:00:00	NQ	Futures	8903.31	8906.5	8852.83	8884.16	56742.0
2019-08-23 10:00:00	NQ	Futures	8883.87	8973.24	8866.75	8934.65	117641.0
2019-08-23 11:00:00	NQ	Futures	8935.23	8944.8	8730.1	8730.68	145234.0
2019-08-23 12:00:00	NQ	Futures	8730.68	8762.88	8719.07	8738.51	64031.0
2019-08-23 13:00:00	NQ	Futures	8738.51	8738.51	8688.61	8715.59	64949.0
2019-08-23 14:00:00	NQ	Futures	8715.59	8715.59	8677.0	8695.57	44909.0
2019-08-23 15:00:00	NQ	Futures	8696.15	8714.72	8643.63	8673.81	95543.0
2019-08-23 16:00:00	NQ	Futures	8673.81	8721.1	8670.62	8692.67	28515.0
2019-08-23 00:00:00	YM	Futures	28606.7	28617.6	28594.7	28604.5	685.0
2019-08-23 01:00:00	YM	Futures	28605.6	28636.1	28599.1	28635.0	1477.0
2019-08-23 02:00:00	YM	Futures	28636.1	28652.4	28616.5	28618.7	2033.0
2019-08-23 03:00:00	YM	Futures	28618.7	28645.8	28598.0	28604.5	3073.0
2019-08-23 04:00:00	YM	Futures	28604.5	28635.0	28593.6	28618.7	2304.0
2019-08-23 05:00:00	YM	Futures	28619.7	28636.1	28596.9	28614.3	2126.0
2019-08-23 06:00:00	YM	Futures	28613.2	28621.9	28550.1	28569.7	3989.0
2019-08-23 07:00:00	YM	Futures	28569.7	28629.5	28568.6	28612.1	3699.0
2019-08-23 08:00:00	YM	Futures	28612.1	28612.1	28323.9	28410.9	31230.0
2019-08-23 09:00:00	YM	Futures	28413.1	28445.7	28338.1	28427.3	27307.0
2019-08-23 10:00:00	YM	Futures	28428.3	28610.0	28380.5	28525.1	50113.0
2019-08-23 11:00:00	YM	Futures	28525.1	28544.7	28010.7	28019.4	74797.0
2019-08-23 12:00:00	YM	Futures	28019.4	28108.6	27991.2	28016.2	34112.0
2019-08-23 13:00:00	YM	Futures	28016.2	28051.0	27935.7	28026.0	25672.0
2019-08-23 14:00:00	YM	Futures	28026.0	28026.0	27895.5	27942.2	17718.0
2019-08-23 15:00:00	YM	Futures	27942.2	27984.6	27722.6	27859.6	39127.0

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

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