PREVIEW / futures_1hour / 2017-06-23

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-06-23.parquet
  size:    42 KB
  rows:    1,298

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-23 00:00:00	ES	Futures	2661.5	2662.32	2661.23	2661.78	1592.0
2017-06-23 01:00:00	ES	Futures	2661.78	2662.05	2661.5	2661.78	1354.0
2017-06-23 02:00:00	ES	Futures	2661.78	2662.32	2661.23	2661.5	4094.0
2017-06-23 03:00:00	ES	Futures	2661.5	2663.42	2660.96	2661.78	13259.0
2017-06-23 04:00:00	ES	Futures	2661.78	2664.24	2661.5	2662.6	8463.0
2017-06-23 05:00:00	ES	Futures	2662.32	2663.14	2659.86	2660.68	10263.0
2017-06-23 06:00:00	ES	Futures	2660.41	2661.5	2656.86	2658.5	19769.0
2017-06-23 07:00:00	ES	Futures	2658.22	2659.86	2658.22	2659.59	9680.0
2017-06-23 08:00:00	ES	Futures	2659.32	2661.5	2659.04	2661.5	11562.0
2017-06-23 09:00:00	ES	Futures	2661.23	2662.32	2654.94	2658.5	155009.0
2017-06-23 10:00:00	ES	Futures	2658.5	2665.06	2657.95	2663.69	182170.0
2017-06-23 11:00:00	ES	Futures	2663.69	2664.78	2662.6	2664.24	81572.0
2017-06-23 12:00:00	ES	Futures	2663.96	2666.42	2663.69	2664.51	67154.0
2017-06-23 13:00:00	ES	Futures	2664.51	2666.42	2663.14	2665.06	69772.0
2017-06-23 14:00:00	ES	Futures	2665.06	2665.6	2662.05	2662.32	81804.0
2017-06-23 15:00:00	ES	Futures	2662.32	2664.51	2657.95	2662.87	355090.0
2017-06-23 16:00:00	ES	Futures	2662.87	2663.69	2658.5	2659.04	95829.0
2017-06-23 00:00:00	NQ	Futures	6900.09	6901.28	6898.6	6900.39	276.0
2017-06-23 01:00:00	NQ	Futures	6900.09	6901.28	6898.3	6899.19	364.0
2017-06-23 02:00:00	NQ	Futures	6898.6	6901.58	6896.22	6899.79	633.0
2017-06-23 03:00:00	NQ	Futures	6899.49	6908.42	6897.11	6903.96	2069.0
2017-06-23 04:00:00	NQ	Futures	6903.96	6908.13	6899.49	6901.87	1386.0
2017-06-23 05:00:00	NQ	Futures	6901.28	6905.15	6891.45	6896.81	1720.0
2017-06-23 06:00:00	NQ	Futures	6896.22	6898.9	6878.05	6885.5	6348.0
2017-06-23 07:00:00	NQ	Futures	6885.2	6886.09	6880.44	6882.22	3624.0
2017-06-23 08:00:00	NQ	Futures	6882.22	6890.56	6881.63	6889.96	3084.0
2017-06-23 09:00:00	NQ	Futures	6889.67	6892.94	6863.76	6875.97	29981.0
2017-06-23 10:00:00	NQ	Futures	6876.27	6901.28	6873.59	6897.71	34145.0
2017-06-23 11:00:00	NQ	Futures	6897.71	6909.62	6895.62	6907.83	17363.0
2017-06-23 12:00:00	NQ	Futures	6907.53	6923.01	6902.47	6915.57	17012.0
2017-06-23 13:00:00	NQ	Futures	6915.87	6926.29	6913.19	6922.12	16285.0
2017-06-23 14:00:00	NQ	Futures	6922.12	6923.61	6909.32	6914.08	16650.0
2017-06-23 15:00:00	NQ	Futures	6914.08	6920.63	6898.0	6917.06	48095.0
2017-06-23 16:00:00	NQ	Futures	6917.06	6923.31	6913.19	6914.38	9961.0
2017-06-23 00:00:00	YM	Futures	23258.7	23261.9	23257.6	23258.7	243.0
2017-06-23 01:00:00	YM	Futures	23258.7	23260.9	23256.5	23257.6	406.0
2017-06-23 02:00:00	YM	Futures	23257.6	23261.9	23253.2	23256.5	1021.0
2017-06-23 03:00:00	YM	Futures	23255.4	23267.4	23251.1	23256.5	2275.0
2017-06-23 04:00:00	YM	Futures	23256.5	23267.4	23252.1	23256.5	1395.0
2017-06-23 05:00:00	YM	Futures	23255.4	23258.7	23221.7	23229.3	3097.0
2017-06-23 06:00:00	YM	Futures	23228.2	23232.6	23178.1	23191.2	5405.0
2017-06-23 07:00:00	YM	Futures	23191.2	23198.8	23187.9	23196.6	2285.0
2017-06-23 08:00:00	YM	Futures	23195.5	23220.6	23195.5	23219.5	3010.0
2017-06-23 09:00:00	YM	Futures	23219.5	23230.4	23165.1	23201.0	18408.0
2017-06-23 10:00:00	YM	Futures	23203.2	23263.0	23201.0	23244.5	17520.0
2017-06-23 11:00:00	YM	Futures	23245.6	23256.5	23233.6	23248.9	9423.0
2017-06-23 12:00:00	YM	Futures	23247.8	23265.2	23245.6	23246.7	5360.0
2017-06-23 13:00:00	YM	Futures	23246.7	23253.2	23230.4	23246.7	6094.0
2017-06-23 14:00:00	YM	Futures	23247.8	23248.9	23228.2	23228.2	4978.0
2017-06-23 15:00:00	YM	Futures	23228.2	23250.0	23191.2	23238.0	19171.0

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

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