PREVIEW / futures_1hour / 2017-06-30

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-06-30.parquet
  size:    47 KB
  rows:    1,344

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-30 00:00:00	ES	Futures	2644.28	2646.2	2644.01	2646.2	2840.0
2017-06-30 01:00:00	ES	Futures	2646.2	2646.74	2645.38	2646.74	4075.0
2017-06-30 02:00:00	ES	Futures	2647.02	2648.11	2644.83	2645.1	14748.0
2017-06-30 03:00:00	ES	Futures	2645.1	2646.2	2640.46	2645.65	43146.0
2017-06-30 04:00:00	ES	Futures	2645.92	2646.74	2643.46	2646.47	18124.0
2017-06-30 05:00:00	ES	Futures	2646.74	2650.84	2645.92	2650.57	22878.0
2017-06-30 06:00:00	ES	Futures	2650.84	2653.3	2650.3	2652.21	24957.0
2017-06-30 07:00:00	ES	Futures	2652.21	2653.3	2651.39	2652.48	20482.0
2017-06-30 08:00:00	ES	Futures	2652.48	2652.48	2648.66	2649.2	39484.0
2017-06-30 09:00:00	ES	Futures	2649.2	2654.94	2648.38	2650.3	226938.0
2017-06-30 10:00:00	ES	Futures	2650.02	2650.57	2644.28	2647.84	235441.0
2017-06-30 11:00:00	ES	Futures	2647.84	2650.57	2644.28	2649.48	135153.0
2017-06-30 12:00:00	ES	Futures	2649.75	2650.57	2647.02	2648.38	72731.0
2017-06-30 13:00:00	ES	Futures	2648.38	2651.12	2648.11	2650.02	58261.0
2017-06-30 14:00:00	ES	Futures	2649.75	2654.94	2648.93	2654.4	95259.0
2017-06-30 15:00:00	ES	Futures	2654.4	2656.58	2645.65	2646.47	387668.0
2017-06-30 16:00:00	ES	Futures	2646.47	2649.75	2644.28	2647.56	171097.0
2017-06-30 00:00:00	NQ	Futures	6705.36	6720.54	6705.36	6718.16	1328.0
2017-06-30 01:00:00	NQ	Futures	6718.46	6719.95	6714.89	6719.65	1242.0
2017-06-30 02:00:00	NQ	Futures	6719.05	6731.26	6718.76	6725.31	3091.0
2017-06-30 03:00:00	NQ	Futures	6725.31	6728.58	6702.38	6723.52	6900.0
2017-06-30 04:00:00	NQ	Futures	6723.52	6744.07	6718.76	6742.58	5335.0
2017-06-30 05:00:00	NQ	Futures	6741.98	6757.17	6736.32	6753.89	4608.0
2017-06-30 06:00:00	NQ	Futures	6753.59	6766.1	6749.43	6759.55	7006.0
2017-06-30 07:00:00	NQ	Futures	6759.85	6762.53	6749.43	6753.59	4985.0
2017-06-30 08:00:00	NQ	Futures	6753.59	6756.27	6724.41	6734.54	10437.0
2017-06-30 09:00:00	NQ	Futures	6734.54	6772.65	6727.09	6744.96	66540.0
2017-06-30 10:00:00	NQ	Futures	6744.96	6754.19	6716.37	6747.34	74613.0
2017-06-30 11:00:00	NQ	Futures	6747.34	6753.59	6732.45	6747.94	27132.0
2017-06-30 12:00:00	NQ	Futures	6748.23	6754.19	6738.11	6742.87	19143.0
2017-06-30 13:00:00	NQ	Futures	6742.87	6752.4	6741.98	6747.94	14015.0
2017-06-30 14:00:00	NQ	Futures	6747.64	6761.34	6744.07	6759.85	18932.0
2017-06-30 15:00:00	NQ	Futures	6759.55	6762.23	6728.58	6730.37	41845.0
2017-06-30 16:00:00	NQ	Futures	6730.67	6738.71	6729.77	6738.11	11089.0
2017-06-30 00:00:00	YM	Futures	23136.8	23148.7	23135.7	23147.7	784.0
2017-06-30 01:00:00	YM	Futures	23147.7	23155.3	23144.4	23155.3	872.0
2017-06-30 02:00:00	YM	Futures	23155.3	23161.8	23141.1	23141.1	2419.0
2017-06-30 03:00:00	YM	Futures	23140.0	23150.9	23110.6	23147.7	6332.0
2017-06-30 04:00:00	YM	Futures	23147.7	23149.8	23129.2	23149.8	2757.0
2017-06-30 05:00:00	YM	Futures	23147.7	23171.6	23144.4	23169.4	2985.0
2017-06-30 06:00:00	YM	Futures	23170.5	23194.5	23169.4	23186.8	3622.0
2017-06-30 07:00:00	YM	Futures	23186.8	23194.5	23181.4	23189.0	1961.0
2017-06-30 08:00:00	YM	Futures	23189.0	23190.1	23170.5	23173.8	4338.0
2017-06-30 09:00:00	YM	Futures	23174.9	23232.6	23169.4	23217.3	21796.0
2017-06-30 10:00:00	YM	Futures	23216.2	23219.5	23157.5	23174.9	25659.0
2017-06-30 11:00:00	YM	Futures	23174.9	23199.9	23144.4	23190.1	13769.0
2017-06-30 12:00:00	YM	Futures	23191.2	23198.8	23169.4	23178.1	8099.0
2017-06-30 13:00:00	YM	Futures	23178.1	23205.3	23176.0	23196.6	6021.0
2017-06-30 14:00:00	YM	Futures	23195.5	23224.9	23189.0	23218.4	8657.0
2017-06-30 15:00:00	YM	Futures	23219.5	23256.5	23173.8	23178.1	20401.0

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

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