PREVIEW / futures_1hour / 2013-11-15

all futures 1-hour files

  file:    by_date/futures_1hour/2013/2013-11-15.parquet
  size:    41 KB
  rows:    1,247

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-15 00:00:00	ES	Futures	1847.0	1847.77	1846.48	1846.48	3137.0
2013-11-15 01:00:00	ES	Futures	1846.48	1847.0	1845.71	1846.22	3948.0
2013-11-15 02:00:00	ES	Futures	1846.22	1846.74	1845.45	1846.22	5367.0
2013-11-15 03:00:00	ES	Futures	1846.22	1847.0	1844.67	1846.22	23247.0
2013-11-15 04:00:00	ES	Futures	1846.22	1847.0	1845.96	1846.22	11394.0
2013-11-15 05:00:00	ES	Futures	1846.48	1848.8	1846.22	1848.03	19177.0
2013-11-15 06:00:00	ES	Futures	1848.03	1849.58	1847.77	1848.8	25364.0
2013-11-15 07:00:00	ES	Futures	1848.8	1849.83	1847.77	1849.06	28584.0
2013-11-15 08:00:00	ES	Futures	1848.8	1849.32	1847.51	1848.29	32977.0
2013-11-15 09:00:00	ES	Futures	1848.29	1848.8	1844.93	1847.51	185357.0
2013-11-15 10:00:00	ES	Futures	1847.51	1848.54	1845.45	1847.77	179566.0
2013-11-15 11:00:00	ES	Futures	1848.03	1849.06	1844.93	1845.96	141202.0
2013-11-15 12:00:00	ES	Futures	1845.71	1847.25	1845.19	1845.45	86692.0
2013-11-15 13:00:00	ES	Futures	1845.45	1848.8	1845.45	1847.77	65500.0
2013-11-15 14:00:00	ES	Futures	1847.77	1849.58	1847.51	1849.32	72922.0
2013-11-15 15:00:00	ES	Futures	1849.32	1852.67	1848.8	1852.41	205320.0
2013-11-15 16:00:00	ES	Futures	1852.67	1853.19	1850.35	1850.61	104244.0
2013-11-15 17:00:00	ES	Futures	1850.61	1851.38	1850.35	1851.38	1545.0
2013-11-15 00:00:00	NQ	Futures	3969.92	3971.37	3969.34	3969.34	606.0
2013-11-15 01:00:00	NQ	Futures	3969.63	3970.21	3967.89	3968.76	346.0
2013-11-15 02:00:00	NQ	Futures	3968.47	3970.79	3967.89	3969.63	688.0
2013-11-15 03:00:00	NQ	Futures	3969.63	3971.37	3967.02	3969.92	2810.0
2013-11-15 04:00:00	NQ	Futures	3969.92	3971.66	3968.47	3968.76	1725.0
2013-11-15 05:00:00	NQ	Futures	3969.05	3972.83	3968.76	3970.79	1937.0
2013-11-15 06:00:00	NQ	Futures	3970.79	3974.57	3969.63	3972.25	2654.0
2013-11-15 07:00:00	NQ	Futures	3971.96	3973.99	3966.73	3968.18	3996.0
2013-11-15 08:00:00	NQ	Futures	3968.18	3969.05	3966.15	3967.02	3673.0
2013-11-15 09:00:00	NQ	Futures	3967.02	3968.18	3955.98	3962.95	32545.0
2013-11-15 10:00:00	NQ	Futures	3962.95	3967.6	3959.76	3963.24	24744.0
2013-11-15 11:00:00	NQ	Futures	3963.24	3968.47	3957.72	3960.05	19142.0
2013-11-15 12:00:00	NQ	Futures	3960.05	3964.11	3958.3	3960.34	11350.0
2013-11-15 13:00:00	NQ	Futures	3960.05	3968.18	3960.05	3964.69	10016.0
2013-11-15 14:00:00	NQ	Futures	3964.69	3969.34	3964.11	3967.02	8961.0
2013-11-15 15:00:00	NQ	Futures	3967.02	3973.12	3966.15	3972.83	22412.0
2013-11-15 16:00:00	NQ	Futures	3972.83	3973.12	3968.47	3969.92	5051.0
2013-11-15 17:00:00	NQ	Futures	3969.63	3970.21	3969.34	3970.21	128.0
2013-11-15 00:00:00	YM	Futures	16189.8	16192.9	16186.8	16187.8	523.0
2013-11-15 01:00:00	YM	Futures	16187.8	16189.8	16182.7	16185.7	543.0
2013-11-15 02:00:00	YM	Futures	16185.7	16187.8	16179.6	16183.7	756.0
2013-11-15 03:00:00	YM	Futures	16184.7	16190.9	16173.5	16184.7	3417.0
2013-11-15 04:00:00	YM	Futures	16185.7	16190.9	16184.7	16185.7	1742.0
2013-11-15 05:00:00	YM	Futures	16185.7	16206.2	16184.7	16202.1	2751.0
2013-11-15 06:00:00	YM	Futures	16202.1	16212.3	16199.0	16208.2	2557.0
2013-11-15 07:00:00	YM	Futures	16208.2	16215.4	16201.1	16210.3	3113.0
2013-11-15 08:00:00	YM	Futures	16210.3	16212.3	16201.1	16206.2	2558.0
2013-11-15 09:00:00	YM	Futures	16205.1	16216.4	16184.7	16215.4	14065.0
2013-11-15 10:00:00	YM	Futures	16215.4	16229.7	16200.0	16227.6	14896.0
2013-11-15 11:00:00	YM	Futures	16227.6	16235.8	16212.3	16217.4	10724.0
2013-11-15 12:00:00	YM	Futures	16216.4	16228.6	16210.3	16215.4	6578.0
2013-11-15 13:00:00	YM	Futures	16216.4	16238.8	16215.4	16230.7	6208.0

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

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