PREVIEW / futures_1hour / 2019-01-23

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-01-23.parquet
  size:    56 KB
  rows:    1,769

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-01-23 00:00:00	ES	Futures	2865.49	2865.49	2862.5	2863.04	4844.0
2019-01-23 01:00:00	ES	Futures	2863.32	2865.76	2863.04	2863.86	3206.0
2019-01-23 02:00:00	ES	Futures	2863.86	2864.4	2858.43	2858.7	11126.0
2019-01-23 03:00:00	ES	Futures	2858.97	2860.33	2854.35	2858.7	21666.0
2019-01-23 04:00:00	ES	Futures	2858.7	2867.12	2858.43	2866.58	14612.0
2019-01-23 05:00:00	ES	Futures	2866.85	2869.56	2865.49	2866.58	14203.0
2019-01-23 06:00:00	ES	Futures	2866.58	2870.11	2864.4	2868.75	13451.0
2019-01-23 07:00:00	ES	Futures	2869.02	2876.35	2867.93	2873.64	34504.0
2019-01-23 08:00:00	ES	Futures	2873.64	2875.81	2868.75	2872.01	26509.0
2019-01-23 09:00:00	ES	Futures	2872.28	2881.78	2871.19	2879.34	171345.0
2019-01-23 10:00:00	ES	Futures	2879.61	2882.87	2859.79	2861.96	231206.0
2019-01-23 11:00:00	ES	Futures	2861.96	2866.58	2841.86	2844.85	231120.0
2019-01-23 12:00:00	ES	Futures	2844.85	2854.9	2838.06	2853.81	173852.0
2019-01-23 13:00:00	ES	Futures	2853.81	2859.24	2847.29	2857.34	141649.0
2019-01-23 14:00:00	ES	Futures	2857.34	2863.04	2851.64	2855.71	154908.0
2019-01-23 15:00:00	ES	Futures	2855.71	2867.93	2855.44	2867.12	189873.0
2019-01-23 16:00:00	ES	Futures	2867.12	2868.2	2863.32	2865.49	53932.0
2019-01-23 18:00:00	ES	Futures	2862.5	2866.3	2859.24	2860.6	8699.0
2019-01-23 19:00:00	ES	Futures	2860.6	2865.76	2858.16	2863.86	9847.0
2019-01-23 20:00:00	ES	Futures	2863.59	2873.09	2861.96	2863.32	16878.0
2019-01-23 21:00:00	ES	Futures	2863.32	2865.49	2858.7	2864.95	12166.0
2019-01-23 22:00:00	ES	Futures	2864.67	2867.39	2863.59	2864.13	5636.0
2019-01-23 23:00:00	ES	Futures	2864.4	2865.76	2861.96	2864.95	3722.0
2019-01-23 00:00:00	NQ	Futures	7801.16	7801.16	7787.72	7790.94	2316.0
2019-01-23 01:00:00	NQ	Futures	7791.23	7799.12	7790.35	7791.81	1532.0
2019-01-23 02:00:00	NQ	Futures	7792.11	7793.86	7768.15	7769.61	5465.0
2019-01-23 03:00:00	NQ	Futures	7769.02	7783.05	7758.5	7777.2	7531.0
2019-01-23 04:00:00	NQ	Futures	7776.62	7802.04	7776.03	7799.99	5146.0
2019-01-23 05:00:00	NQ	Futures	7799.99	7806.71	7793.86	7797.95	4542.0
2019-01-23 06:00:00	NQ	Futures	7797.66	7806.13	7790.06	7803.5	4457.0
2019-01-23 07:00:00	NQ	Futures	7803.5	7824.54	7802.62	7816.36	9592.0
2019-01-23 08:00:00	NQ	Futures	7816.36	7823.08	7800.87	7813.73	11138.0
2019-01-23 09:00:00	NQ	Futures	7813.43	7857.56	7811.97	7845.58	59258.0
2019-01-23 10:00:00	NQ	Futures	7845.28	7859.02	7780.13	7788.6	72337.0
2019-01-23 11:00:00	NQ	Futures	7788.31	7798.53	7720.23	7729.87	66518.0
2019-01-23 12:00:00	NQ	Futures	7729.87	7754.41	7704.74	7750.32	60304.0
2019-01-23 13:00:00	NQ	Futures	7750.61	7769.61	7728.41	7760.26	53478.0
2019-01-23 14:00:00	NQ	Futures	7760.55	7780.42	7739.8	7754.41	44834.0
2019-01-23 15:00:00	NQ	Futures	7754.12	7794.44	7752.08	7794.44	62731.0
2019-01-23 16:00:00	NQ	Futures	7794.15	7800.58	7778.66	7796.49	10992.0
2019-01-23 18:00:00	NQ	Futures	7787.43	7801.46	7779.25	7784.8	3437.0
2019-01-23 19:00:00	NQ	Futures	7784.8	7800.58	7775.74	7794.15	5403.0
2019-01-23 20:00:00	NQ	Futures	7793.86	7823.95	7790.06	7794.15	9044.0
2019-01-23 21:00:00	NQ	Futures	7794.44	7804.38	7779.83	7802.92	6584.0
2019-01-23 22:00:00	NQ	Futures	7802.62	7810.22	7795.9	7798.53	3669.0
2019-01-23 23:00:00	NQ	Futures	7798.53	7803.5	7791.23	7797.95	2097.0
2019-01-23 00:00:00	YM	Futures	26547.7	26547.7	26515.1	26522.7	1276.0
2019-01-23 01:00:00	YM	Futures	26523.8	26548.8	26522.7	26533.6	871.0
2019-01-23 02:00:00	YM	Futures	26533.6	26539.0	26478.2	26489.1	3301.0
2019-01-23 03:00:00	YM	Futures	26489.1	26505.4	26441.3	26488.0	7137.0

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

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