PREVIEW / futures_1hour / 2019-05-21

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-05-21.parquet
  size:    57 KB
  rows:    1,834

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-05-21 00:00:00	ES	Futures	3098.16	3098.16	3095.99	3097.07	3749.0
2019-05-21 01:00:00	ES	Futures	3097.07	3097.07	3094.09	3096.8	6278.0
2019-05-21 02:00:00	ES	Futures	3097.07	3097.61	3094.09	3095.45	7167.0
2019-05-21 03:00:00	ES	Futures	3095.17	3095.72	3086.5	3093.01	24778.0
2019-05-21 04:00:00	ES	Futures	3093.01	3094.9	3089.75	3092.46	17354.0
2019-05-21 05:00:00	ES	Futures	3092.46	3101.14	3089.21	3101.14	26181.0
2019-05-21 06:00:00	ES	Futures	3101.14	3104.66	3100.33	3103.58	23101.0
2019-05-21 07:00:00	ES	Futures	3103.31	3104.12	3097.34	3099.51	22127.0
2019-05-21 08:00:00	ES	Futures	3099.51	3104.66	3097.61	3104.39	57099.0
2019-05-21 09:00:00	ES	Futures	3104.39	3105.21	3097.61	3100.05	194458.0
2019-05-21 10:00:00	ES	Futures	3100.05	3113.07	3097.61	3110.36	224428.0
2019-05-21 11:00:00	ES	Futures	3110.36	3111.98	3101.41	3103.58	135138.0
2019-05-21 12:00:00	ES	Futures	3103.85	3108.73	3103.58	3108.19	89956.0
2019-05-21 13:00:00	ES	Futures	3108.19	3110.63	3107.37	3110.36	52874.0
2019-05-21 14:00:00	ES	Futures	3110.36	3112.53	3108.46	3109.27	78039.0
2019-05-21 15:00:00	ES	Futures	3109.27	3111.98	3106.02	3108.19	166701.0
2019-05-21 16:00:00	ES	Futures	3107.92	3109.54	3106.29	3106.29	51467.0
2019-05-21 18:00:00	ES	Futures	3106.56	3110.36	3105.75	3109.81	9004.0
2019-05-21 19:00:00	ES	Futures	3109.81	3109.81	3107.37	3109.27	3099.0
2019-05-21 20:00:00	ES	Futures	3109.27	3110.36	3102.77	3103.85	19486.0
2019-05-21 21:00:00	ES	Futures	3103.85	3110.63	3103.58	3109.81	13930.0
2019-05-21 22:00:00	ES	Futures	3110.09	3111.71	3108.19	3109.81	8941.0
2019-05-21 23:00:00	ES	Futures	3109.81	3110.9	3107.92	3109.27	4277.0
2019-05-21 00:00:00	NQ	Futures	8668.01	8668.01	8661.31	8663.64	2421.0
2019-05-21 01:00:00	NQ	Futures	8663.35	8663.35	8651.12	8660.44	3703.0
2019-05-21 02:00:00	NQ	Futures	8660.73	8662.18	8647.63	8653.74	4127.0
2019-05-21 03:00:00	NQ	Futures	8653.74	8655.49	8619.09	8646.75	11257.0
2019-05-21 04:00:00	NQ	Futures	8647.04	8655.49	8636.56	8645.59	9019.0
2019-05-21 05:00:00	NQ	Futures	8645.59	8681.4	8634.23	8681.11	12414.0
2019-05-21 06:00:00	NQ	Futures	8680.82	8697.12	8677.91	8691.59	9643.0
2019-05-21 07:00:00	NQ	Futures	8691.3	8693.05	8658.98	8668.88	10748.0
2019-05-21 08:00:00	NQ	Futures	8668.88	8685.77	8656.07	8683.44	21477.0
2019-05-21 09:00:00	NQ	Futures	8683.44	8693.63	8661.31	8670.63	69975.0
2019-05-21 10:00:00	NQ	Futures	8670.04	8711.1	8649.08	8702.07	77578.0
2019-05-21 11:00:00	NQ	Futures	8702.36	8709.06	8670.63	8679.65	49368.0
2019-05-21 12:00:00	NQ	Futures	8679.94	8704.11	8679.94	8695.96	28124.0
2019-05-21 13:00:00	NQ	Futures	8696.25	8707.02	8690.72	8706.73	17890.0
2019-05-21 14:00:00	NQ	Futures	8706.44	8717.5	8694.5	8696.54	23423.0
2019-05-21 15:00:00	NQ	Futures	8696.54	8705.57	8683.15	8691.88	40144.0
2019-05-21 16:00:00	NQ	Futures	8691.59	8699.45	8688.1	8691.01	8801.0
2019-05-21 18:00:00	NQ	Futures	8691.3	8705.57	8686.64	8703.82	2536.0
2019-05-21 19:00:00	NQ	Futures	8703.82	8703.82	8695.08	8700.62	1648.0
2019-05-21 20:00:00	NQ	Futures	8700.91	8704.98	8672.37	8675.58	6349.0
2019-05-21 21:00:00	NQ	Futures	8675.58	8697.41	8674.12	8695.08	6157.0
2019-05-21 22:00:00	NQ	Futures	8695.08	8702.65	8689.84	8694.79	3882.0
2019-05-21 23:00:00	NQ	Futures	8694.79	8697.12	8687.22	8691.88	2098.0
2019-05-21 00:00:00	YM	Futures	28058.6	28058.6	28040.1	28053.1	1444.0
2019-05-21 01:00:00	YM	Futures	28052.0	28052.0	28027.0	28047.7	1927.0
2019-05-21 02:00:00	YM	Futures	28048.8	28050.9	28027.0	28035.7	1802.0
2019-05-21 03:00:00	YM	Futures	28036.8	28040.1	27965.0	28012.9	6158.0

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

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