PREVIEW / futures_1hour / 2017-03-15

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-03-15.parquet
  size:    54 KB
  rows:    1,644

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-03-15 00:00:00	ES	Futures	2585.57	2586.94	2585.03	2586.39	2212.0
2017-03-15 01:00:00	ES	Futures	2586.39	2586.66	2585.84	2586.12	2108.0
2017-03-15 02:00:00	ES	Futures	2586.12	2586.66	2585.57	2586.12	2655.0
2017-03-15 03:00:00	ES	Futures	2586.12	2586.94	2585.03	2586.39	4960.0
2017-03-15 04:00:00	ES	Futures	2586.66	2589.67	2585.57	2588.58	23671.0
2017-03-15 05:00:00	ES	Futures	2588.58	2589.4	2586.94	2587.21	13358.0
2017-03-15 06:00:00	ES	Futures	2586.94	2587.76	2585.84	2586.12	9178.0
2017-03-15 07:00:00	ES	Futures	2585.84	2588.3	2585.84	2586.94	11408.0
2017-03-15 08:00:00	ES	Futures	2586.66	2588.3	2585.84	2588.3	18588.0
2017-03-15 09:00:00	ES	Futures	2588.03	2588.58	2584.75	2587.76	111781.0
2017-03-15 10:00:00	ES	Futures	2587.76	2589.94	2586.12	2587.76	134335.0
2017-03-15 11:00:00	ES	Futures	2587.76	2590.49	2587.76	2589.94	75294.0
2017-03-15 12:00:00	ES	Futures	2589.94	2594.31	2589.67	2593.22	106207.0
2017-03-15 13:00:00	ES	Futures	2593.49	2594.04	2589.94	2589.94	74084.0
2017-03-15 14:00:00	ES	Futures	2590.49	2604.42	2589.94	2601.96	311666.0
2017-03-15 15:00:00	ES	Futures	2601.96	2608.79	2600.59	2602.51	313307.0
2017-03-15 16:00:00	ES	Futures	2602.51	2602.78	2597.86	2599.5	120426.0
2017-03-15 18:00:00	ES	Futures	2599.5	2601.14	2598.41	2600.87	7525.0
2017-03-15 19:00:00	ES	Futures	2600.87	2602.78	2600.32	2602.78	5530.0
2017-03-15 20:00:00	ES	Futures	2602.51	2603.05	2601.69	2603.05	6385.0
2017-03-15 21:00:00	ES	Futures	2603.05	2605.78	2602.51	2604.96	9528.0
2017-03-15 22:00:00	ES	Futures	2604.69	2605.78	2604.15	2605.24	3949.0
2017-03-15 23:00:00	ES	Futures	2604.96	2606.33	2604.69	2605.78	5190.0
2017-03-15 00:00:00	NQ	Futures	6429.1	6430.88	6428.2	6430.59	583.0
2017-03-15 01:00:00	NQ	Futures	6430.59	6431.78	6429.99	6430.59	431.0
2017-03-15 02:00:00	NQ	Futures	6430.59	6433.87	6429.99	6431.78	899.0
2017-03-15 03:00:00	NQ	Futures	6431.78	6432.37	6429.1	6431.78	1094.0
2017-03-15 04:00:00	NQ	Futures	6432.08	6438.64	6430.59	6436.55	3620.0
2017-03-15 05:00:00	NQ	Futures	6436.55	6437.74	6433.87	6433.87	1807.0
2017-03-15 06:00:00	NQ	Futures	6433.87	6435.36	6431.18	6432.08	1573.0
2017-03-15 07:00:00	NQ	Futures	6431.78	6436.85	6431.48	6433.57	2039.0
2017-03-15 08:00:00	NQ	Futures	6433.27	6435.95	6431.78	6435.65	2703.0
2017-03-15 09:00:00	NQ	Futures	6435.95	6438.34	6421.34	6425.22	21734.0
2017-03-15 10:00:00	NQ	Futures	6424.92	6426.41	6415.98	6419.55	21321.0
2017-03-15 11:00:00	NQ	Futures	6419.55	6428.2	6418.96	6427.31	11757.0
2017-03-15 12:00:00	NQ	Futures	6427.01	6442.51	6427.01	6440.13	16029.0
2017-03-15 13:00:00	NQ	Futures	6439.83	6442.21	6432.67	6434.76	10200.0
2017-03-15 14:00:00	NQ	Futures	6434.76	6467.56	6434.16	6462.49	63733.0
2017-03-15 15:00:00	NQ	Futures	6462.49	6477.39	6460.4	6462.19	39714.0
2017-03-15 16:00:00	NQ	Futures	6462.19	6463.38	6455.03	6460.4	8988.0
2017-03-15 18:00:00	NQ	Futures	6460.1	6463.68	6457.72	6463.68	937.0
2017-03-15 19:00:00	NQ	Futures	6463.68	6466.66	6461.89	6465.77	571.0
2017-03-15 20:00:00	NQ	Futures	6466.06	6469.05	6464.87	6468.45	1492.0
2017-03-15 21:00:00	NQ	Futures	6468.75	6475.01	6467.56	6473.52	2295.0
2017-03-15 22:00:00	NQ	Futures	6473.52	6474.41	6471.13	6473.22	996.0
2017-03-15 23:00:00	NQ	Futures	6473.52	6477.1	6472.62	6477.1	1034.0
2017-03-15 00:00:00	YM	Futures	22640.0	22649.8	22635.7	22646.6	626.0
2017-03-15 01:00:00	YM	Futures	22645.5	22649.8	22642.2	22644.4	571.0
2017-03-15 02:00:00	YM	Futures	22644.4	22648.7	22641.1	22643.3	529.0
2017-03-15 03:00:00	YM	Futures	22641.1	22642.2	22631.3	22640.0	1410.0

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

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