PREVIEW / futures_1hour / 2013-11-19

all futures 1-hour files

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

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-19 00:00:00	ES	Futures	1846.48	1848.29	1846.22	1847.77	4515.0
2013-11-19 01:00:00	ES	Futures	1848.03	1848.03	1847.25	1847.25	2179.0
2013-11-19 02:00:00	ES	Futures	1847.0	1847.25	1845.45	1846.74	5300.0
2013-11-19 03:00:00	ES	Futures	1846.48	1847.51	1842.35	1842.35	25076.0
2013-11-19 04:00:00	ES	Futures	1842.61	1845.19	1842.61	1843.13	12848.0
2013-11-19 05:00:00	ES	Futures	1843.13	1843.64	1841.58	1843.13	17106.0
2013-11-19 06:00:00	ES	Futures	1843.13	1844.42	1842.61	1842.87	29811.0
2013-11-19 07:00:00	ES	Futures	1842.87	1843.13	1841.06	1842.35	28857.0
2013-11-19 08:00:00	ES	Futures	1842.35	1844.93	1842.1	1844.67	41103.0
2013-11-19 09:00:00	ES	Futures	1844.42	1846.74	1840.29	1845.71	236987.0
2013-11-19 10:00:00	ES	Futures	1845.71	1850.87	1845.45	1848.8	248902.0
2013-11-19 11:00:00	ES	Futures	1848.8	1849.06	1843.13	1845.71	155351.0
2013-11-19 12:00:00	ES	Futures	1845.71	1849.06	1844.93	1845.19	111813.0
2013-11-19 13:00:00	ES	Futures	1844.93	1845.45	1839.0	1839.77	185253.0
2013-11-19 14:00:00	ES	Futures	1839.77	1845.19	1838.74	1842.35	193099.0
2013-11-19 15:00:00	ES	Futures	1842.61	1846.48	1840.81	1842.35	195719.0
2013-11-19 16:00:00	ES	Futures	1842.35	1842.87	1841.32	1842.35	64698.0
2013-11-19 17:00:00	ES	Futures	1842.35	1842.61	1841.58	1841.84	1716.0
2013-11-19 18:00:00	ES	Futures	1842.35	1847.51	1841.84	1845.19	15703.0
2013-11-19 19:00:00	ES	Futures	1845.19	1845.45	1841.06	1841.32	10101.0
2013-11-19 20:00:00	ES	Futures	1841.32	1842.87	1841.06	1842.1	4390.0
2013-11-19 21:00:00	ES	Futures	1842.1	1842.1	1841.06	1841.58	3197.0
2013-11-19 22:00:00	ES	Futures	1841.32	1841.84	1840.81	1841.84	2088.0
2013-11-19 23:00:00	ES	Futures	1841.84	1842.61	1841.58	1842.61	1643.0
2013-11-19 00:00:00	NQ	Futures	3933.91	3938.26	3933.91	3936.81	664.0
2013-11-19 01:00:00	NQ	Futures	3936.81	3937.39	3935.65	3935.94	140.0
2013-11-19 02:00:00	NQ	Futures	3935.07	3936.23	3932.46	3935.94	666.0
2013-11-19 03:00:00	NQ	Futures	3935.65	3936.52	3924.61	3924.61	5441.0
2013-11-19 04:00:00	NQ	Futures	3924.9	3930.71	3924.9	3926.36	2303.0
2013-11-19 05:00:00	NQ	Futures	3926.36	3928.39	3922.0	3926.36	2390.0
2013-11-19 06:00:00	NQ	Futures	3926.36	3931.0	3926.07	3926.65	2918.0
2013-11-19 07:00:00	NQ	Futures	3926.65	3928.39	3923.74	3927.52	2372.0
2013-11-19 08:00:00	NQ	Futures	3927.81	3934.78	3927.52	3933.04	4173.0
2013-11-19 09:00:00	NQ	Futures	3933.04	3942.91	3923.45	3942.62	50584.0
2013-11-19 10:00:00	NQ	Futures	3942.91	3950.46	3937.97	3942.04	40252.0
2013-11-19 11:00:00	NQ	Futures	3941.75	3943.78	3931.29	3937.1	19648.0
2013-11-19 12:00:00	NQ	Futures	3937.1	3944.65	3931.88	3932.17	14049.0
2013-11-19 13:00:00	NQ	Futures	3931.88	3933.04	3916.19	3918.52	32598.0
2013-11-19 14:00:00	NQ	Futures	3917.93	3929.55	3915.9	3924.9	31096.0
2013-11-19 15:00:00	NQ	Futures	3924.9	3934.49	3920.84	3923.16	37707.0
2013-11-19 16:00:00	NQ	Futures	3923.16	3924.03	3919.97	3922.29	5796.0
2013-11-19 17:00:00	NQ	Futures	3922.29	3922.58	3921.42	3921.71	126.0
2013-11-19 18:00:00	NQ	Futures	3921.71	3932.46	3921.42	3928.39	1555.0
2013-11-19 19:00:00	NQ	Futures	3928.1	3928.97	3921.42	3921.71	1473.0
2013-11-19 20:00:00	NQ	Futures	3922.0	3925.78	3921.13	3923.74	700.0
2013-11-19 21:00:00	NQ	Futures	3923.45	3923.45	3920.84	3922.0	528.0
2013-11-19 22:00:00	NQ	Futures	3922.0	3922.87	3921.13	3922.87	168.0
2013-11-19 23:00:00	NQ	Futures	3923.16	3925.49	3922.29	3925.49	325.0
2013-11-19 00:00:00	YM	Futures	16281.7	16297.1	16281.7	16293.0	830.0
2013-11-19 01:00:00	YM	Futures	16293.0	16293.0	16285.8	16286.8	344.0

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

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