PREVIEW / futures_1hour / 2019-08-14

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-08-14.parquet
  size:    62 KB
  rows:    1,887

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-14 00:00:00	ES	Futures	3169.41	3175.64	3169.41	3174.02	9644.0
2019-08-14 01:00:00	ES	Futures	3174.29	3176.18	3171.31	3172.93	6306.0
2019-08-14 02:00:00	ES	Futures	3173.2	3175.37	3170.77	3172.12	14153.0
2019-08-14 03:00:00	ES	Futures	3171.85	3172.39	3163.46	3167.79	32765.0
2019-08-14 04:00:00	ES	Futures	3168.06	3169.69	3159.94	3162.92	30313.0
2019-08-14 05:00:00	ES	Futures	3162.92	3163.73	3154.8	3156.15	31922.0
2019-08-14 06:00:00	ES	Futures	3155.88	3156.15	3142.34	3146.95	59082.0
2019-08-14 07:00:00	ES	Futures	3146.95	3148.57	3128.54	3132.33	73961.0
2019-08-14 08:00:00	ES	Futures	3132.33	3136.93	3125.02	3133.41	116438.0
2019-08-14 09:00:00	ES	Futures	3133.41	3135.31	3113.92	3123.94	353395.0
2019-08-14 10:00:00	ES	Futures	3123.94	3124.48	3104.99	3105.26	308142.0
2019-08-14 11:00:00	ES	Futures	3105.53	3107.42	3092.26	3095.78	318900.0
2019-08-14 12:00:00	ES	Futures	3095.51	3096.6	3079.27	3081.44	241360.0
2019-08-14 13:00:00	ES	Futures	3081.17	3098.76	3076.56	3093.35	248882.0
2019-08-14 14:00:00	ES	Futures	3093.62	3095.78	3076.83	3082.79	205288.0
2019-08-14 15:00:00	ES	Futures	3083.06	3094.43	3074.4	3076.56	439855.0
2019-08-14 16:00:00	ES	Futures	3076.29	3080.08	3070.61	3070.61	119491.0
2019-08-14 18:00:00	ES	Futures	3070.88	3076.29	3068.44	3070.07	15748.0
2019-08-14 19:00:00	ES	Futures	3070.07	3082.52	3070.07	3082.25	15355.0
2019-08-14 20:00:00	ES	Futures	3081.98	3085.77	3080.62	3082.79	24053.0
2019-08-14 21:00:00	ES	Futures	3083.06	3093.08	3080.89	3092.26	31629.0
2019-08-14 22:00:00	ES	Futures	3092.26	3094.16	3087.66	3090.37	18953.0
2019-08-14 23:00:00	ES	Futures	3090.64	3092.53	3083.06	3083.6	12803.0
2019-08-14 00:00:00	NQ	Futures	8976.43	9001.67	8976.43	8998.48	5141.0
2019-08-14 01:00:00	NQ	Futures	8998.48	9004.28	8984.26	8992.09	4435.0
2019-08-14 02:00:00	NQ	Futures	8992.38	8997.61	8982.81	8984.84	5199.0
2019-08-14 03:00:00	NQ	Futures	8984.26	8986.0	8954.67	8970.33	11144.0
2019-08-14 04:00:00	NQ	Futures	8970.33	8979.33	8945.96	8956.7	9421.0
2019-08-14 05:00:00	NQ	Futures	8956.41	8960.18	8922.75	8929.71	12387.0
2019-08-14 06:00:00	NQ	Futures	8929.13	8929.71	8885.03	8903.31	19840.0
2019-08-14 07:00:00	NQ	Futures	8903.89	8912.6	8849.34	8861.82	22159.0
2019-08-14 08:00:00	NQ	Futures	8862.4	8874.01	8831.65	8860.37	37272.0
2019-08-14 09:00:00	NQ	Futures	8860.66	8866.46	8804.08	8843.83	99334.0
2019-08-14 10:00:00	NQ	Futures	8843.54	8845.28	8776.81	8777.39	81861.0
2019-08-14 11:00:00	NQ	Futures	8777.1	8785.22	8727.77	8735.32	101956.0
2019-08-14 12:00:00	NQ	Futures	8735.03	8743.73	8696.15	8703.69	86297.0
2019-08-14 13:00:00	NQ	Futures	8703.4	8761.14	8691.22	8740.83	77109.0
2019-08-14 14:00:00	NQ	Futures	8740.83	8750.41	8695.28	8717.91	61988.0
2019-08-14 15:00:00	NQ	Futures	8717.91	8751.86	8696.15	8706.3	116240.0
2019-08-14 16:00:00	NQ	Futures	8706.01	8720.23	8677.58	8679.32	19901.0
2019-08-14 18:00:00	NQ	Futures	8668.3	8685.99	8665.39	8667.43	6262.0
2019-08-14 19:00:00	NQ	Futures	8668.01	8709.5	8668.01	8708.63	6800.0
2019-08-14 20:00:00	NQ	Futures	8708.63	8719.65	8695.57	8703.11	12136.0
2019-08-14 21:00:00	NQ	Futures	8703.4	8737.64	8697.31	8736.77	12689.0
2019-08-14 22:00:00	NQ	Futures	8736.77	8743.44	8723.13	8732.13	9020.0
2019-08-14 23:00:00	NQ	Futures	8732.42	8738.8	8705.72	8708.04	5586.0
2019-08-14 00:00:00	YM	Futures	28574.1	28617.6	28574.1	28602.3	2107.0
2019-08-14 01:00:00	YM	Futures	28603.4	28619.7	28583.9	28594.7	1433.0
2019-08-14 02:00:00	YM	Futures	28593.6	28612.1	28573.0	28587.1	2510.0
2019-08-14 03:00:00	YM	Futures	28584.9	28591.5	28516.4	28553.4	5626.0

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

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