PREVIEW / futures_1hour / 2017-05-22

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-05-22.parquet
  size:    52 KB
  rows:    1,631

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-05-22 00:00:00	ES	Futures	2604.96	2605.24	2603.87	2603.87	1789.0
2017-05-22 01:00:00	ES	Futures	2604.15	2604.96	2603.6	2604.96	3669.0
2017-05-22 02:00:00	ES	Futures	2604.69	2606.06	2604.69	2605.24	8776.0
2017-05-22 03:00:00	ES	Futures	2604.96	2605.78	2600.59	2602.51	19519.0
2017-05-22 04:00:00	ES	Futures	2602.23	2603.6	2601.14	2602.78	12097.0
2017-05-22 05:00:00	ES	Futures	2602.78	2603.6	2598.41	2600.32	18551.0
2017-05-22 06:00:00	ES	Futures	2600.32	2602.51	2599.77	2601.69	13075.0
2017-05-22 07:00:00	ES	Futures	2601.69	2604.15	2601.69	2603.87	12601.0
2017-05-22 08:00:00	ES	Futures	2603.6	2604.96	2602.51	2604.42	20889.0
2017-05-22 09:00:00	ES	Futures	2604.42	2612.07	2604.42	2610.7	164776.0
2017-05-22 10:00:00	ES	Futures	2610.43	2612.07	2605.78	2607.7	217530.0
2017-05-22 11:00:00	ES	Futures	2607.42	2610.97	2606.6	2610.97	94768.0
2017-05-22 12:00:00	ES	Futures	2610.97	2614.8	2610.43	2612.34	113837.0
2017-05-22 13:00:00	ES	Futures	2612.34	2613.98	2611.79	2612.07	56591.0
2017-05-22 14:00:00	ES	Futures	2611.79	2613.98	2610.97	2612.89	63511.0
2017-05-22 15:00:00	ES	Futures	2612.89	2615.89	2612.61	2613.71	170713.0
2017-05-22 16:00:00	ES	Futures	2613.71	2615.62	2613.16	2615.34	79021.0
2017-05-22 18:00:00	ES	Futures	2615.07	2616.44	2610.43	2610.7	13403.0
2017-05-22 19:00:00	ES	Futures	2610.97	2611.25	2607.7	2608.24	12683.0
2017-05-22 20:00:00	ES	Futures	2608.24	2610.7	2608.24	2610.43	10823.0
2017-05-22 21:00:00	ES	Futures	2610.43	2611.25	2609.61	2609.88	5578.0
2017-05-22 22:00:00	ES	Futures	2609.88	2612.61	2609.61	2612.61	6085.0
2017-05-22 23:00:00	ES	Futures	2612.61	2612.61	2611.79	2612.07	1942.0
2017-05-22 00:00:00	NQ	Futures	6754.07	6754.66	6751.68	6751.68	501.0
2017-05-22 01:00:00	NQ	Futures	6751.98	6753.47	6750.49	6752.58	694.0
2017-05-22 02:00:00	NQ	Futures	6752.28	6756.16	6751.98	6753.47	1514.0
2017-05-22 03:00:00	NQ	Futures	6753.47	6754.96	6740.65	6746.02	3425.0
2017-05-22 04:00:00	NQ	Futures	6746.02	6751.09	6743.33	6749.3	1907.0
2017-05-22 05:00:00	NQ	Futures	6749.6	6750.79	6736.48	6742.44	3112.0
2017-05-22 06:00:00	NQ	Futures	6742.14	6747.81	6740.95	6746.02	2427.0
2017-05-22 07:00:00	NQ	Futures	6745.72	6751.09	6745.72	6748.7	1895.0
2017-05-22 08:00:00	NQ	Futures	6749.0	6751.98	6741.84	6750.79	4676.0
2017-05-22 09:00:00	NQ	Futures	6750.79	6779.71	6750.49	6777.32	33988.0
2017-05-22 10:00:00	NQ	Futures	6777.32	6782.39	6772.85	6776.73	34389.0
2017-05-22 11:00:00	NQ	Futures	6776.43	6789.55	6774.34	6788.65	22367.0
2017-05-22 12:00:00	NQ	Futures	6788.35	6795.81	6785.37	6791.34	21358.0
2017-05-22 13:00:00	NQ	Futures	6791.34	6793.12	6786.57	6788.35	12171.0
2017-05-22 14:00:00	NQ	Futures	6788.06	6796.11	6784.18	6794.02	14395.0
2017-05-22 15:00:00	NQ	Futures	6794.32	6802.37	6792.83	6798.79	25462.0
2017-05-22 16:00:00	NQ	Futures	6798.79	6802.66	6797.3	6801.17	6021.0
2017-05-22 18:00:00	NQ	Futures	6799.39	6804.45	6786.27	6789.25	2718.0
2017-05-22 19:00:00	NQ	Futures	6788.35	6790.44	6783.88	6785.67	1701.0
2017-05-22 20:00:00	NQ	Futures	6785.97	6792.83	6785.97	6791.34	2432.0
2017-05-22 21:00:00	NQ	Futures	6791.34	6793.72	6789.55	6791.34	1358.0
2017-05-22 22:00:00	NQ	Futures	6791.04	6797.6	6790.14	6797.6	1087.0
2017-05-22 23:00:00	NQ	Futures	6797.6	6798.19	6795.81	6797.0	560.0
2017-05-22 00:00:00	YM	Futures	22623.7	22625.9	22614.0	22615.0	251.0
2017-05-22 01:00:00	YM	Futures	22615.0	22628.1	22611.8	22628.1	721.0
2017-05-22 02:00:00	YM	Futures	22627.0	22640.0	22627.0	22631.3	1639.0
2017-05-22 03:00:00	YM	Futures	22632.4	22637.9	22595.5	22609.6	2680.0

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

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