PREVIEW / futures_1hour / 2014-08-15

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-08-15.parquet
  size:    42 KB
  rows:    1,241

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-08-15 00:00:00	ES	Futures	2036.7	2036.96	2035.92	2035.92	1377.0
2014-08-15 01:00:00	ES	Futures	2035.92	2036.44	2035.66	2035.66	1758.0
2014-08-15 02:00:00	ES	Futures	2035.92	2036.7	2035.66	2036.44	5181.0
2014-08-15 03:00:00	ES	Futures	2036.18	2038.52	2035.66	2037.74	19388.0
2014-08-15 04:00:00	ES	Futures	2037.74	2041.91	2037.74	2041.65	23652.0
2014-08-15 05:00:00	ES	Futures	2041.65	2042.69	2040.61	2041.65	19958.0
2014-08-15 06:00:00	ES	Futures	2041.65	2042.17	2039.83	2041.91	16857.0
2014-08-15 07:00:00	ES	Futures	2041.91	2042.43	2040.35	2040.87	15545.0
2014-08-15 08:00:00	ES	Futures	2041.13	2041.91	2040.35	2040.61	22141.0
2014-08-15 09:00:00	ES	Futures	2040.61	2042.69	2039.04	2041.91	151211.0
2014-08-15 10:00:00	ES	Futures	2041.65	2044.26	2024.19	2030.96	460475.0
2014-08-15 11:00:00	ES	Futures	2030.7	2034.61	2019.5	2023.41	391501.0
2014-08-15 12:00:00	ES	Futures	2023.41	2030.7	2020.8	2027.58	203310.0
2014-08-15 13:00:00	ES	Futures	2027.58	2029.66	2024.71	2025.75	110666.0
2014-08-15 14:00:00	ES	Futures	2025.49	2034.61	2025.49	2032.01	126473.0
2014-08-15 15:00:00	ES	Futures	2032.27	2036.18	2030.44	2034.35	148171.0
2014-08-15 16:00:00	ES	Futures	2034.35	2036.7	2034.35	2035.13	68239.0
2014-08-15 17:00:00	ES	Futures	2035.4	2036.96	2035.4	2036.7	2754.0
2014-08-15 00:00:00	NQ	Futures	4639.82	4640.41	4638.65	4638.65	241.0
2014-08-15 01:00:00	NQ	Futures	4638.65	4639.53	4638.07	4638.95	280.0
2014-08-15 02:00:00	NQ	Futures	4638.65	4641.28	4638.07	4638.95	1136.0
2014-08-15 03:00:00	NQ	Futures	4639.24	4642.16	4637.49	4640.7	2497.0
2014-08-15 04:00:00	NQ	Futures	4640.7	4649.75	4640.41	4649.75	4501.0
2014-08-15 05:00:00	NQ	Futures	4649.75	4652.09	4647.41	4650.04	3012.0
2014-08-15 06:00:00	NQ	Futures	4649.75	4652.38	4645.66	4651.5	3290.0
2014-08-15 07:00:00	NQ	Futures	4651.5	4652.96	4648.29	4649.75	3529.0
2014-08-15 08:00:00	NQ	Futures	4649.46	4652.09	4648.58	4649.46	4131.0
2014-08-15 09:00:00	NQ	Futures	4649.17	4662.89	4646.83	4658.22	34460.0
2014-08-15 10:00:00	NQ	Futures	4657.93	4665.81	4623.47	4636.61	84172.0
2014-08-15 11:00:00	NQ	Futures	4636.32	4646.83	4610.62	4619.67	90559.0
2014-08-15 12:00:00	NQ	Futures	4619.96	4638.65	4612.96	4631.94	45403.0
2014-08-15 13:00:00	NQ	Futures	4631.94	4637.78	4626.68	4631.06	20409.0
2014-08-15 14:00:00	NQ	Futures	4631.06	4652.96	4630.48	4647.41	25864.0
2014-08-15 15:00:00	NQ	Futures	4647.41	4656.47	4641.87	4653.25	29041.0
2014-08-15 16:00:00	NQ	Futures	4652.96	4658.22	4652.67	4654.71	6873.0
2014-08-15 17:00:00	NQ	Futures	4654.42	4657.63	4654.13	4656.17	313.0
2014-08-15 00:00:00	YM	Futures	17259.7	17262.8	17255.6	17255.6	227.0
2014-08-15 01:00:00	YM	Futures	17255.6	17259.7	17252.5	17254.5	397.0
2014-08-15 02:00:00	YM	Futures	17253.5	17259.7	17252.5	17255.6	728.0
2014-08-15 03:00:00	YM	Futures	17256.6	17274.2	17250.4	17269.0	2392.0
2014-08-15 04:00:00	YM	Futures	17268.0	17308.3	17268.0	17307.3	3812.0
2014-08-15 05:00:00	YM	Futures	17308.3	17314.5	17296.9	17307.3	3594.0
2014-08-15 06:00:00	YM	Futures	17306.3	17312.5	17294.9	17307.3	2597.0
2014-08-15 07:00:00	YM	Futures	17307.3	17311.4	17296.9	17303.1	2109.0
2014-08-15 08:00:00	YM	Futures	17303.1	17310.4	17299.0	17299.0	2176.0
2014-08-15 09:00:00	YM	Futures	17299.0	17315.6	17286.6	17306.3	13207.0
2014-08-15 10:00:00	YM	Futures	17306.3	17319.7	17156.2	17206.9	44781.0
2014-08-15 11:00:00	YM	Futures	17208.0	17235.9	17107.6	17139.7	49530.0
2014-08-15 12:00:00	YM	Futures	17140.7	17185.2	17122.1	17164.5	24829.0
2014-08-15 13:00:00	YM	Futures	17164.5	17179.0	17137.6	17143.8	12629.0

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

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