PREVIEW / futures_1hour / 2013-11-14

all futures 1-hour files

  file:    by_date/futures_1hour/2013/2013-11-14.parquet
  size:    49 KB
  rows:    1,532

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
2013-11-14 00:00:00	ES	Futures	1839.77	1840.55	1839.26	1840.29	5126.0
2013-11-14 01:00:00	ES	Futures	1840.29	1840.81	1839.77	1840.03	5027.0
2013-11-14 02:00:00	ES	Futures	1839.77	1841.84	1839.52	1841.32	12211.0
2013-11-14 03:00:00	ES	Futures	1841.06	1842.1	1839.52	1841.58	27949.0
2013-11-14 04:00:00	ES	Futures	1841.58	1842.1	1840.29	1841.32	19820.0
2013-11-14 05:00:00	ES	Futures	1841.06	1841.06	1839.77	1840.29	16332.0
2013-11-14 06:00:00	ES	Futures	1840.55	1840.81	1837.45	1837.97	30306.0
2013-11-14 07:00:00	ES	Futures	1837.97	1839.0	1836.94	1838.23	20930.0
2013-11-14 08:00:00	ES	Futures	1838.23	1839.52	1837.19	1837.71	42894.0
2013-11-14 09:00:00	ES	Futures	1837.45	1839.0	1834.36	1837.19	239597.0
2013-11-14 10:00:00	ES	Futures	1837.19	1842.35	1833.84	1840.55	330741.0
2013-11-14 11:00:00	ES	Futures	1840.29	1845.45	1839.52	1841.58	263433.0
2013-11-14 12:00:00	ES	Futures	1841.58	1843.39	1840.81	1841.32	82178.0
2013-11-14 13:00:00	ES	Futures	1841.58	1843.64	1841.06	1842.87	73491.0
2013-11-14 14:00:00	ES	Futures	1843.13	1844.67	1842.1	1843.13	107049.0
2013-11-14 15:00:00	ES	Futures	1843.39	1845.96	1842.87	1844.93	180066.0
2013-11-14 16:00:00	ES	Futures	1844.93	1845.19	1844.16	1844.93	65600.0
2013-11-14 17:00:00	ES	Futures	1844.93	1844.93	1844.42	1844.67	2865.0
2013-11-14 18:00:00	ES	Futures	1844.67	1844.93	1843.39	1843.9	4823.0
2013-11-14 19:00:00	ES	Futures	1843.9	1844.67	1843.64	1843.9	3234.0
2013-11-14 20:00:00	ES	Futures	1843.9	1845.45	1843.9	1845.45	6091.0
2013-11-14 21:00:00	ES	Futures	1845.45	1846.48	1845.19	1846.22	4449.0
2013-11-14 22:00:00	ES	Futures	1846.22	1847.77	1845.96	1847.25	5548.0
2013-11-14 23:00:00	ES	Futures	1847.51	1847.51	1846.48	1847.25	2442.0
2013-11-14 00:00:00	NQ	Futures	3948.72	3949.59	3946.98	3948.72	514.0
2013-11-14 01:00:00	NQ	Futures	3949.3	3951.62	3949.01	3950.17	562.0
2013-11-14 02:00:00	NQ	Futures	3950.17	3953.37	3948.43	3952.21	1395.0
2013-11-14 03:00:00	NQ	Futures	3951.92	3953.37	3946.69	3949.01	3157.0
2013-11-14 04:00:00	NQ	Futures	3949.3	3950.17	3945.53	3946.4	2776.0
2013-11-14 05:00:00	NQ	Futures	3946.11	3946.4	3943.2	3944.07	2207.0
2013-11-14 06:00:00	NQ	Futures	3943.78	3944.36	3940.01	3940.88	3428.0
2013-11-14 07:00:00	NQ	Futures	3940.88	3943.78	3940.01	3942.91	2382.0
2013-11-14 08:00:00	NQ	Futures	3942.91	3948.14	3939.72	3940.88	5766.0
2013-11-14 09:00:00	NQ	Futures	3940.88	3949.59	3934.49	3948.43	48362.0
2013-11-14 10:00:00	NQ	Futures	3948.43	3957.72	3938.26	3952.21	44805.0
2013-11-14 11:00:00	NQ	Futures	3951.92	3963.24	3949.88	3952.5	28820.0
2013-11-14 12:00:00	NQ	Futures	3952.79	3956.27	3948.72	3953.37	17229.0
2013-11-14 13:00:00	NQ	Futures	3953.66	3959.47	3952.5	3959.47	10730.0
2013-11-14 14:00:00	NQ	Futures	3959.47	3963.24	3957.43	3960.63	15598.0
2013-11-14 15:00:00	NQ	Futures	3960.92	3968.18	3960.05	3963.24	25726.0
2013-11-14 16:00:00	NQ	Futures	3962.95	3964.11	3961.5	3963.24	5340.0
2013-11-14 17:00:00	NQ	Futures	3963.24	3964.11	3963.24	3964.11	136.0
2013-11-14 18:00:00	NQ	Futures	3964.11	3964.11	3960.05	3961.5	564.0
2013-11-14 19:00:00	NQ	Futures	3961.21	3963.53	3960.92	3962.37	392.0
2013-11-14 20:00:00	NQ	Futures	3962.37	3966.73	3962.08	3965.57	578.0
2013-11-14 21:00:00	NQ	Futures	3965.57	3967.89	3964.98	3967.89	514.0
2013-11-14 22:00:00	NQ	Futures	3967.6	3971.66	3967.02	3971.37	1165.0
2013-11-14 23:00:00	NQ	Futures	3971.08	3971.08	3969.34	3970.21	496.0
2013-11-14 00:00:00	YM	Futures	16144.9	16148.0	16139.8	16144.9	448.0
2013-11-14 01:00:00	YM	Futures	16144.9	16153.1	16143.9	16148.0	710.0

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

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