PREVIEW / futures_1hour / 2019-11-25

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-11-25.parquet
  size:    56 KB
  rows:    1,842

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-11-25 00:00:00	ES	Futures	3388.05	3390.5	3387.51	3390.23	5884.0
2019-11-25 01:00:00	ES	Futures	3390.23	3390.77	3389.14	3389.95	4172.0
2019-11-25 02:00:00	ES	Futures	3390.23	3390.5	3388.32	3388.87	8451.0
2019-11-25 03:00:00	ES	Futures	3388.6	3389.95	3387.51	3389.41	16442.0
2019-11-25 04:00:00	ES	Futures	3389.14	3389.68	3388.05	3389.41	8923.0
2019-11-25 05:00:00	ES	Futures	3389.41	3389.95	3388.6	3389.14	8107.0
2019-11-25 06:00:00	ES	Futures	3389.14	3389.68	3387.51	3388.6	5361.0
2019-11-25 07:00:00	ES	Futures	3388.32	3389.68	3386.7	3387.78	13686.0
2019-11-25 08:00:00	ES	Futures	3387.51	3391.04	3386.42	3390.5	19073.0
2019-11-25 09:00:00	ES	Futures	3390.77	3397.56	3388.87	3397.29	139603.0
2019-11-25 10:00:00	ES	Futures	3397.02	3401.91	3396.75	3398.92	123875.0
2019-11-25 11:00:00	ES	Futures	3399.19	3400.28	3397.02	3399.46	89737.0
2019-11-25 12:00:00	ES	Futures	3399.73	3400.28	3397.83	3399.46	52596.0
2019-11-25 13:00:00	ES	Futures	3399.46	3401.36	3398.65	3399.46	46841.0
2019-11-25 14:00:00	ES	Futures	3399.46	3400.82	3398.65	3399.73	36807.0
2019-11-25 15:00:00	ES	Futures	3399.73	3404.62	3399.46	3404.35	177751.0
2019-11-25 16:00:00	ES	Futures	3404.35	3404.62	3401.63	3402.45	61387.0
2019-11-25 18:00:00	ES	Futures	3402.18	3403.54	3401.09	3403.54	5253.0
2019-11-25 19:00:00	ES	Futures	3403.54	3408.7	3402.45	3408.43	14748.0
2019-11-25 20:00:00	ES	Futures	3408.15	3417.12	3405.44	3411.14	41293.0
2019-11-25 21:00:00	ES	Futures	3411.41	3411.69	3404.89	3405.17	22716.0
2019-11-25 22:00:00	ES	Futures	3405.44	3406.25	3404.08	3404.89	8709.0
2019-11-25 23:00:00	ES	Futures	3405.17	3406.25	3404.08	3405.98	5318.0
2019-11-25 00:00:00	NQ	Futures	9650.74	9658.29	9648.12	9657.13	2429.0
2019-11-25 01:00:00	NQ	Futures	9657.42	9660.03	9654.22	9657.13	1629.0
2019-11-25 02:00:00	NQ	Futures	9657.42	9658.58	9649.57	9651.61	2382.0
2019-11-25 03:00:00	NQ	Futures	9652.19	9657.71	9649.28	9655.38	5198.0
2019-11-25 04:00:00	NQ	Futures	9655.09	9658.58	9652.19	9656.55	3623.0
2019-11-25 05:00:00	NQ	Futures	9656.55	9658.87	9653.93	9656.55	2004.0
2019-11-25 06:00:00	NQ	Futures	9656.55	9657.71	9650.74	9653.93	1893.0
2019-11-25 07:00:00	NQ	Futures	9653.93	9657.13	9646.38	9650.44	3766.0
2019-11-25 08:00:00	NQ	Futures	9650.15	9662.65	9645.8	9661.48	6985.0
2019-11-25 09:00:00	NQ	Futures	9661.48	9706.22	9656.84	9703.31	50817.0
2019-11-25 10:00:00	NQ	Futures	9703.61	9727.72	9700.12	9720.16	42574.0
2019-11-25 11:00:00	NQ	Futures	9720.16	9723.36	9713.48	9719.0	24024.0
2019-11-25 12:00:00	NQ	Futures	9718.71	9719.87	9713.77	9718.42	14416.0
2019-11-25 13:00:00	NQ	Futures	9718.42	9723.36	9717.26	9720.16	14153.0
2019-11-25 14:00:00	NQ	Futures	9720.16	9722.78	9714.64	9719.58	13252.0
2019-11-25 15:00:00	NQ	Futures	9719.58	9734.4	9717.26	9733.53	38467.0
2019-11-25 16:00:00	NQ	Futures	9733.82	9736.43	9726.84	9731.49	9211.0
2019-11-25 18:00:00	NQ	Futures	9730.62	9733.24	9726.84	9731.78	1775.0
2019-11-25 19:00:00	NQ	Futures	9732.07	9753.86	9729.17	9751.54	5362.0
2019-11-25 20:00:00	NQ	Futures	9751.54	9786.1	9740.21	9761.99	12271.0
2019-11-25 21:00:00	NQ	Futures	9761.99	9763.45	9740.5	9742.24	7086.0
2019-11-25 22:00:00	NQ	Futures	9742.82	9747.47	9738.75	9742.53	3406.0
2019-11-25 23:00:00	NQ	Futures	9742.53	9746.31	9738.17	9744.56	2159.0
2019-11-25 00:00:00	YM	Futures	30395.5	30416.2	30389.0	30411.8	941.0
2019-11-25 01:00:00	YM	Futures	30412.9	30418.4	30402.0	30409.7	711.0
2019-11-25 02:00:00	YM	Futures	30410.7	30412.9	30396.6	30399.9	1259.0
2019-11-25 03:00:00	YM	Futures	30400.9	30416.2	30394.4	30406.4	2636.0

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

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