PREVIEW / futures_1hour / 2013-11-21

all futures 1-hour files

  file:    by_date/futures_1hour/2013/2013-11-21.parquet
  size:    50 KB
  rows:    1,514

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-21 00:00:00	ES	Futures	1832.81	1833.84	1832.81	1833.32	3980.0
2013-11-21 01:00:00	ES	Futures	1833.07	1834.87	1833.07	1834.1	3939.0
2013-11-21 02:00:00	ES	Futures	1834.1	1836.16	1834.1	1835.13	9136.0
2013-11-21 03:00:00	ES	Futures	1835.13	1835.9	1832.29	1835.39	32889.0
2013-11-21 04:00:00	ES	Futures	1835.39	1839.52	1834.61	1839.0	44617.0
2013-11-21 05:00:00	ES	Futures	1839.0	1840.55	1838.23	1840.55	17220.0
2013-11-21 06:00:00	ES	Futures	1840.81	1840.81	1838.23	1839.26	28935.0
2013-11-21 07:00:00	ES	Futures	1839.52	1841.32	1838.48	1840.55	22749.0
2013-11-21 08:00:00	ES	Futures	1840.55	1842.87	1839.77	1839.77	45904.0
2013-11-21 09:00:00	ES	Futures	1839.77	1845.45	1839.77	1844.67	217962.0
2013-11-21 10:00:00	ES	Futures	1844.67	1848.8	1842.35	1847.51	245454.0
2013-11-21 11:00:00	ES	Futures	1847.77	1849.06	1846.22	1848.29	122551.0
2013-11-21 12:00:00	ES	Futures	1848.29	1848.54	1845.45	1845.45	79571.0
2013-11-21 13:00:00	ES	Futures	1845.45	1850.87	1845.45	1850.61	113696.0
2013-11-21 14:00:00	ES	Futures	1850.35	1851.9	1849.06	1850.61	89344.0
2013-11-21 15:00:00	ES	Futures	1850.87	1852.67	1849.58	1850.61	184166.0
2013-11-21 16:00:00	ES	Futures	1850.87	1851.64	1849.83	1851.12	84078.0
2013-11-21 17:00:00	ES	Futures	1850.87	1851.38	1850.61	1850.87	2659.0
2013-11-21 18:00:00	ES	Futures	1850.35	1852.67	1850.09	1852.41	9600.0
2013-11-21 19:00:00	ES	Futures	1852.16	1852.41	1851.12	1852.16	3622.0
2013-11-21 20:00:00	ES	Futures	1851.9	1852.16	1850.87	1851.64	3398.0
2013-11-21 21:00:00	ES	Futures	1851.64	1851.9	1851.12	1851.64	1562.0
2013-11-21 22:00:00	ES	Futures	1851.38	1851.64	1850.35	1850.35	2353.0
2013-11-21 23:00:00	ES	Futures	1850.61	1851.38	1849.58	1849.83	4283.0
2013-11-21 00:00:00	NQ	Futures	3905.74	3908.06	3905.16	3907.77	559.0
2013-11-21 01:00:00	NQ	Futures	3907.77	3911.25	3907.77	3909.51	571.0
2013-11-21 02:00:00	NQ	Futures	3909.51	3914.16	3909.51	3912.13	603.0
2013-11-21 03:00:00	NQ	Futures	3912.13	3912.13	3903.7	3909.22	3369.0
2013-11-21 04:00:00	NQ	Futures	3908.93	3919.1	3906.9	3918.52	5237.0
2013-11-21 05:00:00	NQ	Futures	3918.52	3924.32	3916.77	3923.16	7025.0
2013-11-21 06:00:00	NQ	Futures	3923.45	3923.74	3918.22	3920.55	4010.0
2013-11-21 07:00:00	NQ	Futures	3920.55	3924.9	3918.81	3924.03	3437.0
2013-11-21 08:00:00	NQ	Futures	3924.03	3928.1	3922.29	3923.16	5609.0
2013-11-21 09:00:00	NQ	Futures	3923.16	3943.78	3923.16	3940.59	34704.0
2013-11-21 10:00:00	NQ	Futures	3940.59	3944.94	3936.81	3941.46	35893.0
2013-11-21 11:00:00	NQ	Futures	3941.46	3943.78	3936.23	3940.01	19501.0
2013-11-21 12:00:00	NQ	Futures	3940.3	3941.46	3931.88	3933.04	14837.0
2013-11-21 13:00:00	NQ	Futures	3933.04	3947.56	3932.46	3946.69	17589.0
2013-11-21 14:00:00	NQ	Futures	3946.69	3956.85	3944.94	3952.79	17849.0
2013-11-21 15:00:00	NQ	Futures	3952.79	3956.56	3949.01	3952.5	23951.0
2013-11-21 16:00:00	NQ	Futures	3952.5	3953.37	3949.59	3953.37	5266.0
2013-11-21 17:00:00	NQ	Futures	3952.79	3953.37	3952.5	3953.37	113.0
2013-11-21 18:00:00	NQ	Futures	3950.75	3955.98	3950.46	3955.11	611.0
2013-11-21 19:00:00	NQ	Futures	3955.11	3955.11	3953.37	3953.66	405.0
2013-11-21 20:00:00	NQ	Futures	3953.95	3955.11	3953.08	3954.82	436.0
2013-11-21 21:00:00	NQ	Futures	3954.82	3955.4	3953.37	3954.24	221.0
2013-11-21 22:00:00	NQ	Futures	3953.95	3954.53	3952.21	3952.5	296.0
2013-11-21 23:00:00	NQ	Futures	3952.21	3954.24	3950.75	3951.62	428.0
2013-11-21 00:00:00	YM	Futures	16189.8	16194.9	16187.8	16192.9	697.0
2013-11-21 01:00:00	YM	Futures	16192.9	16202.1	16192.9	16198.0	845.0

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

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