PREVIEW / futures_1hour / 2018-08-16

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-08-16.parquet
  size:    53 KB
  rows:    1,687

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-16 00:00:00	ES	Futures	3084.05	3085.14	3082.96	3084.32	5136.0
2018-08-16 01:00:00	ES	Futures	3084.32	3087.04	3083.23	3087.04	9646.0
2018-08-16 02:00:00	ES	Futures	3086.77	3087.04	3084.05	3084.86	11122.0
2018-08-16 03:00:00	ES	Futures	3085.14	3085.14	3079.41	3080.5	15788.0
2018-08-16 04:00:00	ES	Futures	3080.5	3086.5	3079.69	3085.68	15292.0
2018-08-16 05:00:00	ES	Futures	3085.95	3087.04	3084.05	3086.23	9495.0
2018-08-16 06:00:00	ES	Futures	3086.23	3091.4	3085.68	3090.86	25407.0
2018-08-16 07:00:00	ES	Futures	3090.86	3092.22	3087.86	3089.5	18714.0
2018-08-16 08:00:00	ES	Futures	3089.77	3090.86	3086.23	3087.04	28167.0
2018-08-16 09:00:00	ES	Futures	3087.04	3094.13	3086.23	3091.68	146290.0
2018-08-16 10:00:00	ES	Futures	3091.68	3097.94	3091.4	3096.03	136575.0
2018-08-16 11:00:00	ES	Futures	3096.03	3103.39	3095.76	3103.12	116031.0
2018-08-16 12:00:00	ES	Futures	3103.12	3108.02	3100.94	3102.57	153759.0
2018-08-16 13:00:00	ES	Futures	3102.57	3105.57	3101.21	3101.76	82224.0
2018-08-16 14:00:00	ES	Futures	3102.03	3103.39	3096.31	3100.67	106390.0
2018-08-16 15:00:00	ES	Futures	3100.94	3102.3	3093.58	3097.94	197860.0
2018-08-16 16:00:00	ES	Futures	3097.94	3100.94	3097.67	3099.58	75468.0
2018-08-16 18:00:00	ES	Futures	3099.03	3099.3	3095.76	3098.21	6439.0
2018-08-16 19:00:00	ES	Futures	3098.21	3098.76	3096.03	3097.67	3432.0
2018-08-16 20:00:00	ES	Futures	3097.94	3098.49	3096.31	3098.49	5877.0
2018-08-16 21:00:00	ES	Futures	3098.49	3105.03	3098.49	3102.3	14063.0
2018-08-16 22:00:00	ES	Futures	3102.57	3104.48	3100.94	3101.76	5256.0
2018-08-16 23:00:00	ES	Futures	3101.76	3102.03	3099.3	3101.48	4222.0
2018-08-16 00:00:00	NQ	Futures	8718.9	8723.61	8713.31	8715.66	1792.0
2018-08-16 01:00:00	NQ	Futures	8715.95	8734.21	8715.07	8733.91	3087.0
2018-08-16 02:00:00	NQ	Futures	8733.62	8733.91	8718.6	8727.73	3719.0
2018-08-16 03:00:00	NQ	Futures	8728.03	8728.03	8708.3	8710.66	4486.0
2018-08-16 04:00:00	NQ	Futures	8711.24	8735.98	8707.42	8733.03	3776.0
2018-08-16 05:00:00	NQ	Futures	8733.33	8737.15	8726.26	8732.44	2415.0
2018-08-16 06:00:00	NQ	Futures	8732.74	8751.58	8731.85	8747.75	6464.0
2018-08-16 07:00:00	NQ	Futures	8747.46	8750.99	8733.62	8738.33	5043.0
2018-08-16 08:00:00	NQ	Futures	8738.33	8742.16	8722.43	8724.79	7337.0
2018-08-16 09:00:00	NQ	Futures	8724.79	8740.39	8710.95	8714.19	59420.0
2018-08-16 10:00:00	NQ	Futures	8714.48	8741.27	8714.19	8722.43	45285.0
2018-08-16 11:00:00	NQ	Futures	8722.73	8749.22	8721.84	8744.51	33885.0
2018-08-16 12:00:00	NQ	Futures	8744.51	8755.41	8732.15	8736.86	30905.0
2018-08-16 13:00:00	NQ	Futures	8737.45	8744.51	8720.37	8722.73	19629.0
2018-08-16 14:00:00	NQ	Futures	8723.02	8728.32	8695.64	8713.89	37297.0
2018-08-16 15:00:00	NQ	Futures	8714.19	8716.84	8681.8	8698.29	41037.0
2018-08-16 16:00:00	NQ	Futures	8698.29	8704.18	8690.05	8692.7	11438.0
2018-08-16 18:00:00	NQ	Futures	8694.17	8696.52	8677.68	8686.81	2262.0
2018-08-16 19:00:00	NQ	Futures	8686.22	8689.16	8680.62	8685.34	1236.0
2018-08-16 20:00:00	NQ	Futures	8685.63	8688.28	8680.92	8686.81	1579.0
2018-08-16 21:00:00	NQ	Futures	8687.1	8712.13	8687.1	8704.18	4784.0
2018-08-16 22:00:00	NQ	Futures	8704.18	8711.54	8696.52	8699.17	1821.0
2018-08-16 23:00:00	NQ	Futures	8698.88	8702.71	8692.4	8702.71	1193.0
2018-08-16 00:00:00	YM	Futures	27489.4	27500.3	27484.0	27492.7	866.0
2018-08-16 01:00:00	YM	Futures	27493.8	27522.0	27489.4	27518.8	1906.0
2018-08-16 02:00:00	YM	Futures	27518.8	27518.8	27490.5	27494.8	2073.0
2018-08-16 03:00:00	YM	Futures	27495.9	27495.9	27442.7	27451.4	3419.0

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

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