PREVIEW / futures_1hour / 2018-08-06

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-08-06.parquet
  size:    52 KB
  rows:    1,649

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-06 00:00:00	ES	Futures	3098.76	3098.76	3097.94	3098.49	1444.0
2018-08-06 01:00:00	ES	Futures	3098.76	3099.03	3097.67	3098.49	3996.0
2018-08-06 02:00:00	ES	Futures	3098.21	3098.76	3096.03	3096.58	5601.0
2018-08-06 03:00:00	ES	Futures	3096.58	3097.67	3092.76	3093.31	15669.0
2018-08-06 04:00:00	ES	Futures	3093.04	3093.58	3090.04	3090.31	11698.0
2018-08-06 05:00:00	ES	Futures	3090.31	3095.76	3089.77	3095.22	12145.0
2018-08-06 06:00:00	ES	Futures	3095.22	3098.76	3094.4	3098.21	17055.0
2018-08-06 07:00:00	ES	Futures	3097.94	3098.49	3095.22	3095.22	11725.0
2018-08-06 08:00:00	ES	Futures	3095.22	3096.03	3092.49	3093.31	15928.0
2018-08-06 09:00:00	ES	Futures	3093.31	3097.4	3090.31	3096.58	102536.0
2018-08-06 10:00:00	ES	Futures	3096.58	3099.3	3094.13	3099.03	97682.0
2018-08-06 11:00:00	ES	Futures	3099.3	3103.39	3097.12	3102.85	75815.0
2018-08-06 12:00:00	ES	Futures	3103.12	3107.75	3102.85	3107.48	88880.0
2018-08-06 13:00:00	ES	Futures	3107.48	3109.93	3103.39	3104.21	86462.0
2018-08-06 14:00:00	ES	Futures	3104.21	3108.3	3102.85	3106.66	54120.0
2018-08-06 15:00:00	ES	Futures	3106.66	3107.21	3104.21	3106.66	97307.0
2018-08-06 16:00:00	ES	Futures	3106.66	3107.21	3105.03	3105.03	45790.0
2018-08-06 18:00:00	ES	Futures	3105.3	3105.84	3104.21	3105.3	2851.0
2018-08-06 19:00:00	ES	Futures	3105.03	3106.12	3105.03	3105.84	1413.0
2018-08-06 20:00:00	ES	Futures	3105.84	3106.66	3105.03	3106.12	3579.0
2018-08-06 21:00:00	ES	Futures	3106.12	3107.75	3105.84	3106.12	4860.0
2018-08-06 22:00:00	ES	Futures	3106.12	3107.21	3105.57	3106.93	2959.0
2018-08-06 23:00:00	ES	Futures	3106.93	3108.84	3106.93	3108.57	4033.0
2018-08-06 00:00:00	NQ	Futures	8731.56	8733.33	8727.14	8731.26	713.0
2018-08-06 01:00:00	NQ	Futures	8730.97	8733.91	8725.67	8727.44	1304.0
2018-08-06 02:00:00	NQ	Futures	8727.14	8729.2	8723.61	8727.14	1222.0
2018-08-06 03:00:00	NQ	Futures	8727.14	8730.68	8717.72	8720.08	3009.0
2018-08-06 04:00:00	NQ	Futures	8719.49	8722.43	8708.89	8710.95	3185.0
2018-08-06 05:00:00	NQ	Futures	8710.66	8729.5	8707.71	8728.32	3151.0
2018-08-06 06:00:00	NQ	Futures	8727.44	8736.56	8722.43	8732.15	3855.0
2018-08-06 07:00:00	NQ	Futures	8732.15	8735.09	8722.73	8723.02	2795.0
2018-08-06 08:00:00	NQ	Futures	8722.73	8725.97	8708.59	8712.13	5222.0
2018-08-06 09:00:00	NQ	Futures	8712.13	8730.68	8700.06	8727.73	42429.0
2018-08-06 10:00:00	NQ	Futures	8727.73	8742.16	8710.66	8723.9	43738.0
2018-08-06 11:00:00	NQ	Futures	8724.2	8740.69	8712.72	8738.63	25031.0
2018-08-06 12:00:00	NQ	Futures	8738.63	8759.23	8737.45	8758.94	25907.0
2018-08-06 13:00:00	NQ	Futures	8759.23	8771.6	8748.34	8752.76	28142.0
2018-08-06 14:00:00	NQ	Futures	8752.76	8768.07	8750.4	8763.65	15585.0
2018-08-06 15:00:00	NQ	Futures	8763.36	8771.6	8758.35	8770.13	23399.0
2018-08-06 16:00:00	NQ	Futures	8770.42	8773.37	8764.83	8764.83	9106.0
2018-08-06 18:00:00	NQ	Futures	8764.83	8766.01	8762.18	8764.53	978.0
2018-08-06 19:00:00	NQ	Futures	8764.53	8768.07	8762.77	8767.48	510.0
2018-08-06 20:00:00	NQ	Futures	8766.89	8772.19	8765.71	8771.01	1631.0
2018-08-06 21:00:00	NQ	Futures	8770.72	8773.37	8768.66	8769.83	1614.0
2018-08-06 22:00:00	NQ	Futures	8770.13	8773.66	8767.18	8772.78	1464.0
2018-08-06 23:00:00	NQ	Futures	8773.07	8788.09	8773.07	8781.9	2813.0
2018-08-06 00:00:00	YM	Futures	27678.6	27679.7	27669.9	27676.4	425.0
2018-08-06 01:00:00	YM	Futures	27674.2	27684.0	27662.3	27668.8	1018.0
2018-08-06 02:00:00	YM	Futures	27668.8	27674.2	27644.9	27657.9	1188.0
2018-08-06 03:00:00	YM	Futures	27656.8	27667.7	27623.1	27629.6	2247.0

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

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