PREVIEW / futures_1hour / 2014-09-19

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-09-19.parquet
  size:    44 KB
  rows:    1,280

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-09-19 00:00:00	ES	Futures	2109.1	2110.93	2108.84	2109.62	8142.0
2014-09-19 01:00:00	ES	Futures	2109.36	2109.89	2107.53	2107.53	5931.0
2014-09-19 02:00:00	ES	Futures	2107.53	2108.58	2107.0	2108.58	11532.0
2014-09-19 03:00:00	ES	Futures	2108.31	2108.58	2105.43	2106.22	23407.0
2014-09-19 04:00:00	ES	Futures	2105.96	2108.31	2105.96	2107.79	15742.0
2014-09-19 05:00:00	ES	Futures	2108.05	2108.31	2106.48	2106.74	10696.0
2014-09-19 06:00:00	ES	Futures	2107.0	2108.31	2106.22	2107.27	22394.0
2014-09-19 07:00:00	ES	Futures	2107.27	2107.53	2104.65	2105.69	28696.0
2014-09-19 08:00:00	ES	Futures	2105.43	2107.79	2103.6	2107.27	43941.0
2014-09-19 09:00:00	ES	Futures	2107.27	2109.1	2104.38	2105.96	256756.0
2014-09-19 10:00:00	ES	Futures	2106.22	2107.0	2101.5	2103.34	223336.0
2014-09-19 11:00:00	ES	Futures	2103.34	2104.91	2099.93	2101.24	174270.0
2014-09-19 12:00:00	ES	Futures	2101.24	2101.5	2096.52	2097.83	175298.0
2014-09-19 13:00:00	ES	Futures	2098.1	2099.14	2093.91	2098.1	134689.0
2014-09-19 14:00:00	ES	Futures	2098.1	2102.03	2097.57	2101.24	98385.0
2014-09-19 15:00:00	ES	Futures	2101.5	2102.55	2097.83	2098.36	191584.0
2014-09-19 16:00:00	ES	Futures	2098.36	2100.98	2095.74	2097.31	137155.0
2014-09-19 17:00:00	ES	Futures	2097.31	2097.83	2096.0	2096.0	4255.0
2014-09-19 00:00:00	NQ	Futures	4822.0	4827.27	4821.7	4824.63	1929.0
2014-09-19 01:00:00	NQ	Futures	4824.63	4825.22	4821.12	4821.41	1358.0
2014-09-19 02:00:00	NQ	Futures	4821.41	4823.75	4819.65	4822.87	1305.0
2014-09-19 03:00:00	NQ	Futures	4822.87	4822.87	4814.38	4817.31	3253.0
2014-09-19 04:00:00	NQ	Futures	4817.31	4823.17	4816.43	4821.41	2200.0
2014-09-19 05:00:00	NQ	Futures	4821.41	4822.0	4818.19	4818.48	1715.0
2014-09-19 06:00:00	NQ	Futures	4818.19	4821.41	4816.72	4819.07	2402.0
2014-09-19 07:00:00	NQ	Futures	4818.77	4820.24	4813.79	4815.84	3621.0
2014-09-19 08:00:00	NQ	Futures	4815.84	4820.53	4812.33	4819.94	5614.0
2014-09-19 09:00:00	NQ	Futures	4819.94	4821.41	4809.4	4816.43	43410.0
2014-09-19 10:00:00	NQ	Futures	4816.43	4818.77	4802.66	4810.27	39058.0
2014-09-19 11:00:00	NQ	Futures	4810.27	4814.08	4796.21	4802.07	35712.0
2014-09-19 12:00:00	NQ	Futures	4802.07	4802.66	4778.63	4785.37	46161.0
2014-09-19 13:00:00	NQ	Futures	4785.37	4794.45	4777.17	4790.94	26456.0
2014-09-19 14:00:00	NQ	Futures	4790.94	4803.24	4787.71	4801.48	15314.0
2014-09-19 15:00:00	NQ	Futures	4801.48	4805.29	4794.45	4795.62	27056.0
2014-09-19 16:00:00	NQ	Futures	4795.62	4800.61	4789.76	4790.64	9957.0
2014-09-19 17:00:00	NQ	Futures	4790.94	4791.52	4788.01	4788.01	1041.0
2014-09-19 00:00:00	YM	Futures	17949.4	17966.1	17948.4	17952.6	1644.0
2014-09-19 01:00:00	YM	Futures	17952.6	17955.7	17941.1	17943.2	1014.0
2014-09-19 02:00:00	YM	Futures	17942.2	17947.4	17937.0	17943.2	2021.0
2014-09-19 03:00:00	YM	Futures	17944.2	17945.3	17923.4	17926.6	3462.0
2014-09-19 04:00:00	YM	Futures	17925.5	17941.1	17924.5	17940.1	2763.0
2014-09-19 05:00:00	YM	Futures	17940.1	17942.2	17930.7	17933.8	2322.0
2014-09-19 06:00:00	YM	Futures	17932.8	17941.1	17928.6	17934.9	2742.0
2014-09-19 07:00:00	YM	Futures	17933.8	17935.9	17916.2	17922.4	3083.0
2014-09-19 08:00:00	YM	Futures	17921.4	17939.0	17908.9	17938.0	4312.0
2014-09-19 09:00:00	YM	Futures	17937.0	17951.5	17920.3	17930.7	21207.0
2014-09-19 10:00:00	YM	Futures	17930.7	17940.1	17904.7	17918.2	16073.0
2014-09-19 11:00:00	YM	Futures	17918.2	17928.6	17896.4	17903.7	14888.0
2014-09-19 12:00:00	YM	Futures	17903.7	17905.8	17877.7	17888.1	14296.0
2014-09-19 13:00:00	YM	Futures	17887.0	17894.3	17852.7	17889.1	12932.0

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

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