PREVIEW / futures_1hour / 2014-10-03

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-10-03.parquet
  size:    44 KB
  rows:    1,283

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
2014-10-03 00:00:00	ES	Futures	2035.22	2035.75	2034.96	2035.49	1737.0
2014-10-03 01:00:00	ES	Futures	2035.49	2039.94	2035.22	2039.68	9160.0
2014-10-03 02:00:00	ES	Futures	2039.68	2041.25	2038.63	2038.89	13802.0
2014-10-03 03:00:00	ES	Futures	2038.89	2039.94	2037.58	2038.63	18426.0
2014-10-03 04:00:00	ES	Futures	2038.89	2043.08	2038.63	2041.77	21056.0
2014-10-03 05:00:00	ES	Futures	2041.77	2042.82	2039.68	2039.68	11238.0
2014-10-03 06:00:00	ES	Futures	2039.94	2041.51	2039.15	2040.2	11066.0
2014-10-03 07:00:00	ES	Futures	2039.94	2043.08	2039.68	2042.3	20059.0
2014-10-03 08:00:00	ES	Futures	2042.3	2047.28	2038.63	2040.99	147750.0
2014-10-03 09:00:00	ES	Futures	2041.25	2050.94	2038.63	2048.85	267656.0
2014-10-03 10:00:00	ES	Futures	2048.85	2053.82	2045.44	2048.58	244988.0
2014-10-03 11:00:00	ES	Futures	2048.58	2051.73	2047.54	2050.16	129830.0
2014-10-03 12:00:00	ES	Futures	2050.16	2056.97	2048.85	2055.66	132766.0
2014-10-03 13:00:00	ES	Futures	2055.66	2056.18	2051.99	2053.82	82539.0
2014-10-03 14:00:00	ES	Futures	2053.82	2058.02	2053.56	2056.44	103859.0
2014-10-03 15:00:00	ES	Futures	2056.71	2058.54	2053.82	2053.82	204453.0
2014-10-03 16:00:00	ES	Futures	2054.09	2054.87	2053.3	2054.09	98809.0
2014-10-03 17:00:00	ES	Futures	2053.82	2054.09	2053.3	2053.56	1873.0
2014-10-03 00:00:00	NQ	Futures	4672.27	4673.73	4671.68	4672.27	360.0
2014-10-03 01:00:00	NQ	Futures	4672.27	4681.35	4672.27	4680.77	1851.0
2014-10-03 02:00:00	NQ	Futures	4680.47	4684.58	4679.01	4679.59	1629.0
2014-10-03 03:00:00	NQ	Futures	4679.3	4681.65	4674.91	4678.72	2190.0
2014-10-03 04:00:00	NQ	Futures	4678.72	4686.63	4678.42	4682.52	3229.0
2014-10-03 05:00:00	NQ	Futures	4682.82	4686.63	4679.01	4679.3	1601.0
2014-10-03 06:00:00	NQ	Futures	4679.3	4683.7	4677.25	4678.42	1522.0
2014-10-03 07:00:00	NQ	Futures	4678.72	4686.63	4678.13	4684.87	2232.0
2014-10-03 08:00:00	NQ	Futures	4684.87	4701.57	4678.42	4685.75	22621.0
2014-10-03 09:00:00	NQ	Futures	4685.75	4706.84	4673.44	4703.91	47877.0
2014-10-03 10:00:00	NQ	Futures	4703.91	4719.74	4700.98	4713.29	54692.0
2014-10-03 11:00:00	NQ	Futures	4713.29	4717.39	4702.45	4708.02	24694.0
2014-10-03 12:00:00	NQ	Futures	4707.72	4722.37	4705.96	4719.15	23047.0
2014-10-03 13:00:00	NQ	Futures	4719.15	4721.2	4710.65	4717.1	12881.0
2014-10-03 14:00:00	NQ	Futures	4717.1	4727.35	4716.81	4723.55	20366.0
2014-10-03 15:00:00	NQ	Futures	4723.55	4728.82	4709.19	4709.48	46708.0
2014-10-03 16:00:00	NQ	Futures	4709.48	4711.24	4705.67	4707.43	12922.0
2014-10-03 17:00:00	NQ	Futures	4707.43	4707.72	4706.26	4706.26	136.0
2014-10-03 00:00:00	YM	Futures	17420.2	17423.3	17419.2	17421.2	209.0
2014-10-03 01:00:00	YM	Futures	17421.2	17454.5	17421.2	17454.5	1534.0
2014-10-03 02:00:00	YM	Futures	17453.5	17462.8	17443.1	17443.1	1692.0
2014-10-03 03:00:00	YM	Futures	17442.0	17449.3	17430.6	17437.9	2418.0
2014-10-03 04:00:00	YM	Futures	17437.9	17467.0	17437.9	17456.6	2845.0
2014-10-03 05:00:00	YM	Futures	17458.7	17467.0	17446.2	17447.2	1734.0
2014-10-03 06:00:00	YM	Futures	17445.1	17458.7	17444.1	17450.3	1770.0
2014-10-03 07:00:00	YM	Futures	17451.4	17476.3	17451.4	17474.3	2488.0
2014-10-03 08:00:00	YM	Futures	17474.3	17514.8	17448.3	17474.3	14148.0
2014-10-03 09:00:00	YM	Futures	17476.3	17558.5	17451.4	17535.6	25814.0
2014-10-03 10:00:00	YM	Futures	17535.6	17571.0	17494.0	17513.8	23627.0
2014-10-03 11:00:00	YM	Futures	17512.7	17535.6	17500.3	17529.4	11961.0
2014-10-03 12:00:00	YM	Futures	17528.3	17603.2	17520.0	17592.8	14510.0
2014-10-03 13:00:00	YM	Futures	17592.8	17595.9	17568.9	17582.4	6985.0

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

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