PREVIEW / futures_1hour / 2017-06-21

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-06-21.parquet
  size:    52 KB
  rows:    1,613

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-21 00:00:00	ES	Futures	2660.68	2661.5	2660.41	2661.23	2687.0
2017-06-21 01:00:00	ES	Futures	2661.5	2662.6	2660.68	2660.68	4072.0
2017-06-21 02:00:00	ES	Futures	2660.68	2661.78	2659.59	2661.5	8708.0
2017-06-21 03:00:00	ES	Futures	2661.78	2661.78	2656.04	2657.4	32751.0
2017-06-21 04:00:00	ES	Futures	2657.68	2660.68	2655.49	2658.77	28050.0
2017-06-21 05:00:00	ES	Futures	2659.04	2660.14	2656.31	2658.77	17133.0
2017-06-21 06:00:00	ES	Futures	2658.5	2662.05	2658.5	2661.78	14232.0
2017-06-21 07:00:00	ES	Futures	2661.78	2662.6	2659.04	2660.14	19054.0
2017-06-21 08:00:00	ES	Futures	2660.14	2664.51	2659.59	2663.96	31054.0
2017-06-21 09:00:00	ES	Futures	2663.69	2666.42	2661.78	2662.05	185719.0
2017-06-21 10:00:00	ES	Futures	2662.32	2667.79	2661.78	2663.69	211531.0
2017-06-21 11:00:00	ES	Futures	2663.69	2663.69	2657.4	2662.87	192550.0
2017-06-21 12:00:00	ES	Futures	2663.14	2663.42	2657.4	2657.4	131192.0
2017-06-21 13:00:00	ES	Futures	2657.68	2659.86	2654.67	2656.04	97393.0
2017-06-21 14:00:00	ES	Futures	2656.04	2661.78	2654.94	2660.14	99841.0
2017-06-21 15:00:00	ES	Futures	2660.41	2661.5	2657.4	2660.41	178981.0
2017-06-21 16:00:00	ES	Futures	2660.41	2661.23	2658.22	2659.59	65594.0
2017-06-21 18:00:00	ES	Futures	2658.77	2659.32	2656.04	2656.86	9886.0
2017-06-21 19:00:00	ES	Futures	2657.13	2658.5	2656.58	2657.13	2933.0
2017-06-21 20:00:00	ES	Futures	2657.13	2658.22	2656.86	2657.4	3562.0
2017-06-21 21:00:00	ES	Futures	2657.13	2658.5	2656.31	2658.22	4167.0
2017-06-21 22:00:00	ES	Futures	2658.22	2658.77	2656.58	2657.13	3975.0
2017-06-21 23:00:00	ES	Futures	2657.4	2661.23	2656.86	2660.68	6156.0
2017-06-21 00:00:00	NQ	Futures	6811.95	6816.12	6809.87	6813.74	837.0
2017-06-21 01:00:00	NQ	Futures	6813.74	6819.1	6812.25	6812.85	941.0
2017-06-21 02:00:00	NQ	Futures	6812.55	6817.01	6809.87	6816.12	1178.0
2017-06-21 03:00:00	NQ	Futures	6816.12	6816.42	6795.28	6798.26	3993.0
2017-06-21 04:00:00	NQ	Futures	6798.26	6810.46	6787.54	6800.94	5930.0
2017-06-21 05:00:00	NQ	Futures	6800.94	6806.3	6792.0	6803.91	2407.0
2017-06-21 06:00:00	NQ	Futures	6803.62	6820.89	6801.83	6816.42	5694.0
2017-06-21 07:00:00	NQ	Futures	6816.12	6820.89	6808.08	6813.44	5734.0
2017-06-21 08:00:00	NQ	Futures	6813.44	6838.16	6812.55	6834.88	8667.0
2017-06-21 09:00:00	NQ	Futures	6834.58	6854.53	6834.58	6840.24	44293.0
2017-06-21 10:00:00	NQ	Futures	6840.83	6877.16	6840.54	6868.53	48839.0
2017-06-21 11:00:00	NQ	Futures	6868.23	6875.37	6850.66	6874.18	39114.0
2017-06-21 12:00:00	NQ	Futures	6874.48	6881.03	6862.57	6864.36	27890.0
2017-06-21 13:00:00	NQ	Futures	6864.65	6878.65	6864.06	6871.8	21974.0
2017-06-21 14:00:00	NQ	Futures	6871.5	6891.45	6865.25	6886.69	35240.0
2017-06-21 15:00:00	NQ	Futures	6886.39	6896.81	6882.52	6892.94	41342.0
2017-06-21 16:00:00	NQ	Futures	6892.94	6903.66	6891.75	6902.77	9237.0
2017-06-21 18:00:00	NQ	Futures	6899.79	6900.68	6892.64	6896.22	1532.0
2017-06-21 19:00:00	NQ	Futures	6895.32	6901.28	6893.83	6897.71	640.0
2017-06-21 20:00:00	NQ	Futures	6898.0	6901.58	6896.51	6897.11	746.0
2017-06-21 21:00:00	NQ	Futures	6897.11	6900.39	6894.73	6899.19	802.0
2017-06-21 22:00:00	NQ	Futures	6899.49	6900.39	6894.43	6896.81	981.0
2017-06-21 23:00:00	NQ	Futures	6896.81	6915.87	6895.32	6913.78	2288.0
2017-06-21 00:00:00	YM	Futures	23320.7	23327.3	23307.7	23322.9	1136.0
2017-06-21 01:00:00	YM	Futures	23324.0	23329.4	23316.4	23316.4	767.0
2017-06-21 02:00:00	YM	Futures	23316.4	23325.1	23313.1	23324.0	1293.0
2017-06-21 03:00:00	YM	Futures	23324.0	23324.0	23294.6	23305.5	4624.0

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

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