PREVIEW / futures_1hour / 2017-06-22

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-06-22.parquet
  size:    50 KB
  rows:    1,622

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
2017-06-22 00:00:00	ES	Futures	2660.96	2661.23	2659.32	2659.59	2972.0
2017-06-22 01:00:00	ES	Futures	2659.59	2661.23	2659.59	2660.14	3058.0
2017-06-22 02:00:00	ES	Futures	2660.14	2661.78	2658.5	2659.86	7502.0
2017-06-22 03:00:00	ES	Futures	2659.86	2659.86	2655.22	2655.76	24686.0
2017-06-22 04:00:00	ES	Futures	2655.49	2657.13	2655.22	2655.76	10809.0
2017-06-22 05:00:00	ES	Futures	2655.76	2657.95	2654.67	2657.4	15459.0
2017-06-22 06:00:00	ES	Futures	2657.4	2660.14	2656.58	2659.59	16730.0
2017-06-22 07:00:00	ES	Futures	2659.32	2660.41	2658.22	2659.32	9498.0
2017-06-22 08:00:00	ES	Futures	2659.59	2659.86	2657.95	2658.5	18003.0
2017-06-22 09:00:00	ES	Futures	2658.5	2661.23	2656.86	2659.86	149152.0
2017-06-22 10:00:00	ES	Futures	2659.86	2663.69	2657.13	2662.6	182897.0
2017-06-22 11:00:00	ES	Futures	2662.87	2666.15	2662.32	2665.06	138489.0
2017-06-22 12:00:00	ES	Futures	2665.06	2666.42	2662.6	2665.33	80283.0
2017-06-22 13:00:00	ES	Futures	2665.33	2666.7	2663.96	2665.33	61234.0
2017-06-22 14:00:00	ES	Futures	2665.06	2666.15	2663.42	2664.78	54883.0
2017-06-22 15:00:00	ES	Futures	2665.06	2666.15	2658.5	2659.04	179367.0
2017-06-22 16:00:00	ES	Futures	2659.04	2659.32	2657.4	2658.77	62387.0
2017-06-22 18:00:00	ES	Futures	2658.22	2660.14	2657.95	2659.86	2845.0
2017-06-22 19:00:00	ES	Futures	2659.86	2660.41	2659.59	2660.14	1614.0
2017-06-22 20:00:00	ES	Futures	2660.41	2661.23	2659.04	2661.23	4070.0
2017-06-22 21:00:00	ES	Futures	2661.23	2662.05	2659.59	2660.41	5251.0
2017-06-22 22:00:00	ES	Futures	2660.14	2661.78	2660.14	2661.78	2357.0
2017-06-22 23:00:00	ES	Futures	2661.5	2662.05	2661.23	2661.5	2226.0
2017-06-22 00:00:00	NQ	Futures	6913.49	6914.68	6908.42	6910.21	1180.0
2017-06-22 01:00:00	NQ	Futures	6910.21	6921.23	6909.62	6917.06	1637.0
2017-06-22 02:00:00	NQ	Futures	6917.36	6925.1	6914.08	6919.44	2060.0
2017-06-22 03:00:00	NQ	Futures	6919.74	6919.74	6891.15	6892.35	5491.0
2017-06-22 04:00:00	NQ	Futures	6892.35	6900.09	6890.26	6894.73	2206.0
2017-06-22 05:00:00	NQ	Futures	6894.13	6899.19	6884.9	6895.32	3253.0
2017-06-22 06:00:00	NQ	Futures	6895.32	6903.66	6890.56	6899.79	5703.0
2017-06-22 07:00:00	NQ	Futures	6899.49	6904.55	6895.92	6900.39	3015.0
2017-06-22 08:00:00	NQ	Futures	6900.39	6907.53	6893.54	6899.79	4874.0
2017-06-22 09:00:00	NQ	Futures	6899.79	6905.15	6876.86	6882.82	38644.0
2017-06-22 10:00:00	NQ	Futures	6882.82	6901.28	6872.99	6895.03	40293.0
2017-06-22 11:00:00	NQ	Futures	6895.32	6899.79	6888.77	6896.22	26963.0
2017-06-22 12:00:00	NQ	Futures	6896.22	6914.68	6890.26	6911.7	22371.0
2017-06-22 13:00:00	NQ	Futures	6911.4	6916.46	6908.13	6909.62	17283.0
2017-06-22 14:00:00	NQ	Futures	6909.91	6914.97	6900.98	6906.94	16753.0
2017-06-22 15:00:00	NQ	Futures	6906.94	6910.21	6888.18	6889.96	28776.0
2017-06-22 16:00:00	NQ	Futures	6889.67	6893.83	6888.48	6889.96	5482.0
2017-06-22 18:00:00	NQ	Futures	6890.56	6895.92	6889.67	6894.73	627.0
2017-06-22 19:00:00	NQ	Futures	6895.32	6898.9	6895.32	6897.41	623.0
2017-06-22 20:00:00	NQ	Futures	6897.41	6898.9	6893.83	6898.6	789.0
2017-06-22 21:00:00	NQ	Futures	6899.19	6901.87	6894.43	6896.81	885.0
2017-06-22 22:00:00	NQ	Futures	6896.81	6901.58	6895.92	6900.68	422.0
2017-06-22 23:00:00	NQ	Futures	6900.39	6901.28	6898.3	6899.79	301.0
2017-06-22 00:00:00	YM	Futures	23266.3	23267.4	23252.1	23255.4	628.0
2017-06-22 01:00:00	YM	Futures	23255.4	23272.8	23255.4	23265.2	895.0
2017-06-22 02:00:00	YM	Futures	23265.2	23276.1	23255.4	23261.9	1172.0
2017-06-22 03:00:00	YM	Futures	23261.9	23261.9	23236.9	23238.0	3827.0

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

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