PREVIEW / futures_1hour / 2014-01-03

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-01-03.parquet
  size:    42 KB
  rows:    1,270

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-01-03 00:00:00	ES	Futures	1888.69	1888.69	1885.58	1885.58	5918.0
2014-01-03 01:00:00	ES	Futures	1885.58	1885.84	1883.51	1884.55	6619.0
2014-01-03 02:00:00	ES	Futures	1884.81	1888.17	1884.81	1887.91	7042.0
2014-01-03 03:00:00	ES	Futures	1887.91	1888.43	1885.58	1888.43	13241.0
2014-01-03 04:00:00	ES	Futures	1888.43	1891.27	1887.91	1891.01	14399.0
2014-01-03 05:00:00	ES	Futures	1891.01	1892.05	1890.5	1891.27	7984.0
2014-01-03 06:00:00	ES	Futures	1891.27	1891.79	1890.24	1890.5	6370.0
2014-01-03 07:00:00	ES	Futures	1890.76	1893.6	1890.5	1893.08	14478.0
2014-01-03 08:00:00	ES	Futures	1892.82	1895.41	1892.57	1893.08	31694.0
2014-01-03 09:00:00	ES	Futures	1893.34	1895.67	1891.27	1894.64	144382.0
2014-01-03 10:00:00	ES	Futures	1894.89	1896.45	1892.57	1893.6	125857.0
2014-01-03 11:00:00	ES	Futures	1893.86	1894.89	1886.62	1887.39	140064.0
2014-01-03 12:00:00	ES	Futures	1887.65	1889.98	1886.1	1888.69	72548.0
2014-01-03 13:00:00	ES	Futures	1888.69	1889.72	1886.62	1888.17	46881.0
2014-01-03 14:00:00	ES	Futures	1888.17	1893.34	1887.91	1892.31	84564.0
2014-01-03 15:00:00	ES	Futures	1892.31	1895.41	1887.65	1887.91	154766.0
2014-01-03 16:00:00	ES	Futures	1887.65	1889.46	1886.62	1886.62	62684.0
2014-01-03 17:00:00	ES	Futures	1886.62	1887.39	1886.1	1886.36	3133.0
2014-01-03 00:00:00	NQ	Futures	4135.86	4136.15	4129.47	4129.47	898.0
2014-01-03 01:00:00	NQ	Futures	4129.47	4129.47	4123.07	4124.82	1637.0
2014-01-03 02:00:00	NQ	Futures	4124.82	4129.76	4124.53	4129.47	1767.0
2014-01-03 03:00:00	NQ	Futures	4129.76	4132.08	4124.53	4131.5	2071.0
2014-01-03 04:00:00	NQ	Futures	4131.21	4137.9	4131.21	4137.9	1954.0
2014-01-03 05:00:00	NQ	Futures	4137.61	4140.22	4136.44	4139.06	961.0
2014-01-03 06:00:00	NQ	Futures	4139.06	4140.51	4137.9	4138.77	1151.0
2014-01-03 07:00:00	NQ	Futures	4138.77	4144.29	4138.48	4143.42	2049.0
2014-01-03 08:00:00	NQ	Futures	4143.71	4146.91	4139.64	4141.09	6927.0
2014-01-03 09:00:00	NQ	Futures	4141.09	4142.55	4130.92	4138.19	30785.0
2014-01-03 10:00:00	NQ	Futures	4138.19	4140.51	4124.53	4126.85	33623.0
2014-01-03 11:00:00	NQ	Futures	4127.14	4128.01	4106.5	4107.96	34420.0
2014-01-03 12:00:00	NQ	Futures	4107.96	4113.77	4106.5	4110.86	12393.0
2014-01-03 13:00:00	NQ	Futures	4110.86	4113.19	4107.96	4111.74	10090.0
2014-01-03 14:00:00	NQ	Futures	4112.03	4122.49	4110.57	4119.87	15120.0
2014-01-03 15:00:00	NQ	Futures	4119.58	4122.49	4107.08	4107.38	29282.0
2014-01-03 16:00:00	NQ	Futures	4107.38	4109.7	4102.72	4103.02	6156.0
2014-01-03 17:00:00	NQ	Futures	4102.72	4107.38	4101.27	4105.34	1038.0
2014-01-03 00:00:00	YM	Futures	16794.0	16795.1	16769.4	16770.5	1163.0
2014-01-03 01:00:00	YM	Futures	16770.5	16771.5	16751.0	16763.3	1461.0
2014-01-03 02:00:00	YM	Futures	16763.3	16794.0	16763.3	16791.0	1343.0
2014-01-03 03:00:00	YM	Futures	16792.0	16800.2	16773.5	16795.1	2263.0
2014-01-03 04:00:00	YM	Futures	16794.0	16815.6	16792.0	16814.6	2081.0
2014-01-03 05:00:00	YM	Futures	16814.6	16822.8	16810.5	16815.6	937.0
2014-01-03 06:00:00	YM	Futures	16814.6	16821.7	16809.4	16813.5	1026.0
2014-01-03 07:00:00	YM	Futures	16814.6	16833.0	16808.4	16828.9	1547.0
2014-01-03 08:00:00	YM	Futures	16829.9	16846.3	16827.9	16834.0	2498.0
2014-01-03 09:00:00	YM	Futures	16835.1	16860.7	16819.7	16853.5	13102.0
2014-01-03 10:00:00	YM	Futures	16853.5	16866.9	16841.2	16853.5	11947.0
2014-01-03 11:00:00	YM	Futures	16854.5	16861.7	16797.1	16802.3	14790.0
2014-01-03 12:00:00	YM	Futures	16802.3	16826.9	16789.9	16811.5	6692.0
2014-01-03 13:00:00	YM	Futures	16811.5	16816.6	16785.8	16801.2	5701.0

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

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