PREVIEW / futures_1hour / 2013-11-22

all futures 1-hour files

  file:    by_date/futures_1hour/2013/2013-11-22.parquet
  size:    41 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
2013-11-22 00:00:00	ES	Futures	1849.83	1850.09	1849.06	1849.32	3136.0
2013-11-22 01:00:00	ES	Futures	1849.06	1850.61	1849.06	1850.61	2475.0
2013-11-22 02:00:00	ES	Futures	1850.35	1851.64	1850.09	1850.61	5736.0
2013-11-22 03:00:00	ES	Futures	1850.61	1853.19	1849.32	1851.64	32687.0
2013-11-22 04:00:00	ES	Futures	1851.38	1852.93	1850.09	1850.35	24291.0
2013-11-22 05:00:00	ES	Futures	1850.35	1852.16	1849.58	1849.58	29956.0
2013-11-22 06:00:00	ES	Futures	1849.58	1851.12	1849.58	1849.83	25675.0
2013-11-22 07:00:00	ES	Futures	1850.09	1851.64	1849.32	1850.61	27517.0
2013-11-22 08:00:00	ES	Futures	1850.87	1853.96	1850.35	1851.64	50733.0
2013-11-22 09:00:00	ES	Futures	1851.64	1852.93	1849.58	1852.16	162563.0
2013-11-22 10:00:00	ES	Futures	1852.16	1854.48	1850.09	1853.45	175553.0
2013-11-22 11:00:00	ES	Futures	1853.7	1857.83	1852.93	1857.32	155998.0
2013-11-22 12:00:00	ES	Futures	1857.06	1857.83	1856.28	1857.06	62100.0
2013-11-22 13:00:00	ES	Futures	1857.32	1857.83	1855.51	1855.77	61631.0
2013-11-22 14:00:00	ES	Futures	1855.77	1859.12	1855.77	1859.12	83817.0
2013-11-22 15:00:00	ES	Futures	1859.12	1860.67	1858.86	1860.15	205894.0
2013-11-22 16:00:00	ES	Futures	1860.15	1860.67	1858.09	1858.86	89429.0
2013-11-22 17:00:00	ES	Futures	1858.86	1858.86	1857.83	1858.6	1526.0
2013-11-22 00:00:00	NQ	Futures	3951.04	3951.62	3950.46	3950.46	261.0
2013-11-22 01:00:00	NQ	Futures	3950.46	3953.08	3950.46	3953.08	298.0
2013-11-22 02:00:00	NQ	Futures	3953.08	3955.69	3952.5	3955.11	914.0
2013-11-22 03:00:00	NQ	Futures	3954.82	3959.47	3952.5	3956.56	6078.0
2013-11-22 04:00:00	NQ	Futures	3956.27	3958.89	3952.5	3953.37	4661.0
2013-11-22 05:00:00	NQ	Futures	3953.37	3957.14	3949.88	3950.17	3197.0
2013-11-22 06:00:00	NQ	Futures	3950.17	3954.24	3949.88	3950.75	2940.0
2013-11-22 07:00:00	NQ	Futures	3951.33	3954.53	3950.46	3952.21	3475.0
2013-11-22 08:00:00	NQ	Futures	3952.21	3960.92	3951.92	3958.01	6427.0
2013-11-22 09:00:00	NQ	Futures	3958.01	3967.89	3957.14	3965.28	30067.0
2013-11-22 10:00:00	NQ	Futures	3965.86	3971.96	3960.63	3965.28	26429.0
2013-11-22 11:00:00	NQ	Futures	3965.28	3974.86	3964.11	3974.28	18554.0
2013-11-22 12:00:00	NQ	Futures	3973.99	3976.02	3971.96	3973.41	10253.0
2013-11-22 13:00:00	NQ	Futures	3973.41	3973.7	3966.44	3967.6	10161.0
2013-11-22 14:00:00	NQ	Futures	3967.31	3975.73	3967.02	3975.15	10512.0
2013-11-22 15:00:00	NQ	Futures	3975.15	3976.02	3971.66	3974.57	20019.0
2013-11-22 16:00:00	NQ	Futures	3974.57	3975.44	3972.83	3974.57	6655.0
2013-11-22 17:00:00	NQ	Futures	3974.57	3975.15	3973.41	3974.28	312.0
2013-11-22 00:00:00	YM	Futures	16312.4	16312.4	16305.2	16306.3	515.0
2013-11-22 01:00:00	YM	Futures	16306.3	16320.5	16306.3	16318.5	504.0
2013-11-22 02:00:00	YM	Futures	16318.5	16328.7	16315.4	16324.6	1458.0
2013-11-22 03:00:00	YM	Futures	16323.6	16344.0	16315.4	16328.7	6496.0
2013-11-22 04:00:00	YM	Futures	16327.7	16337.9	16316.5	16322.6	5620.0
2013-11-22 05:00:00	YM	Futures	16321.6	16334.8	16313.4	16314.4	3119.0
2013-11-22 06:00:00	YM	Futures	16314.4	16323.6	16312.4	16315.4	1872.0
2013-11-22 07:00:00	YM	Futures	16315.4	16328.7	16313.4	16320.5	2039.0
2013-11-22 08:00:00	YM	Futures	16320.5	16342.0	16319.5	16328.7	4118.0
2013-11-22 09:00:00	YM	Futures	16327.7	16333.8	16286.8	16314.4	14872.0
2013-11-22 10:00:00	YM	Futures	16315.4	16340.0	16298.1	16334.8	14573.0
2013-11-22 11:00:00	YM	Futures	16332.8	16347.1	16318.5	16343.0	12141.0
2013-11-22 12:00:00	YM	Futures	16343.0	16354.3	16337.9	16346.1	6494.0
2013-11-22 13:00:00	YM	Futures	16346.1	16350.2	16330.8	16337.9	4898.0

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

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