PREVIEW / futures_1hour / 2013-11-18

all futures 1-hour files

  file:    by_date/futures_1hour/2013/2013-11-18.parquet
  size:    48 KB
  rows:    1,488

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-18 00:00:00	ES	Futures	1849.32	1849.83	1848.03	1848.54	4482.0
2013-11-18 01:00:00	ES	Futures	1848.8	1849.58	1848.54	1849.58	1913.0
2013-11-18 02:00:00	ES	Futures	1849.58	1849.58	1847.77	1847.77	5211.0
2013-11-18 03:00:00	ES	Futures	1847.77	1850.09	1847.25	1847.77	23027.0
2013-11-18 04:00:00	ES	Futures	1847.51	1850.61	1847.51	1850.09	20093.0
2013-11-18 05:00:00	ES	Futures	1850.09	1852.67	1850.09	1851.9	23723.0
2013-11-18 06:00:00	ES	Futures	1851.9	1854.48	1851.9	1854.22	29228.0
2013-11-18 07:00:00	ES	Futures	1853.96	1854.74	1852.67	1853.45	23642.0
2013-11-18 08:00:00	ES	Futures	1853.19	1854.22	1852.41	1854.22	29524.0
2013-11-18 09:00:00	ES	Futures	1853.96	1857.06	1850.61	1850.87	245320.0
2013-11-18 10:00:00	ES	Futures	1850.87	1854.48	1849.58	1854.48	207440.0
2013-11-18 11:00:00	ES	Futures	1854.22	1856.03	1852.41	1853.19	143698.0
2013-11-18 12:00:00	ES	Futures	1852.93	1854.74	1851.9	1852.41	107246.0
2013-11-18 13:00:00	ES	Futures	1852.67	1854.48	1852.16	1853.7	60380.0
2013-11-18 14:00:00	ES	Futures	1853.96	1855.51	1849.83	1849.83	121022.0
2013-11-18 15:00:00	ES	Futures	1849.83	1850.09	1841.58	1846.48	388971.0
2013-11-18 16:00:00	ES	Futures	1846.48	1846.74	1845.45	1846.74	83664.0
2013-11-18 17:00:00	ES	Futures	1846.74	1847.0	1846.22	1846.48	5268.0
2013-11-18 18:00:00	ES	Futures	1846.48	1846.74	1844.67	1845.71	6075.0
2013-11-18 19:00:00	ES	Futures	1845.71	1847.77	1845.45	1846.74	4789.0
2013-11-18 20:00:00	ES	Futures	1846.48	1846.48	1843.9	1844.42	6919.0
2013-11-18 21:00:00	ES	Futures	1844.16	1846.74	1844.16	1845.71	2756.0
2013-11-18 22:00:00	ES	Futures	1845.96	1847.25	1845.19	1847.0	3745.0
2013-11-18 23:00:00	ES	Futures	1847.0	1847.25	1845.96	1846.48	1962.0
2013-11-18 00:00:00	NQ	Futures	3968.18	3969.63	3966.15	3967.31	563.0
2013-11-18 01:00:00	NQ	Futures	3967.31	3969.63	3967.02	3969.34	228.0
2013-11-18 02:00:00	NQ	Futures	3969.63	3969.63	3965.28	3965.28	545.0
2013-11-18 03:00:00	NQ	Futures	3965.28	3969.92	3963.24	3964.11	2575.0
2013-11-18 04:00:00	NQ	Futures	3963.82	3970.79	3963.82	3970.21	1745.0
2013-11-18 05:00:00	NQ	Futures	3970.21	3974.57	3970.21	3972.83	3077.0
2013-11-18 06:00:00	NQ	Futures	3973.12	3974.28	3970.21	3973.41	3028.0
2013-11-18 07:00:00	NQ	Futures	3973.41	3973.99	3970.79	3972.25	1881.0
2013-11-18 08:00:00	NQ	Futures	3972.25	3972.25	3968.18	3971.37	2659.0
2013-11-18 09:00:00	NQ	Futures	3971.37	3979.8	3963.82	3964.11	36984.0
2013-11-18 10:00:00	NQ	Futures	3964.11	3971.96	3955.98	3970.79	27848.0
2013-11-18 11:00:00	NQ	Futures	3970.79	3973.7	3961.79	3963.82	15790.0
2013-11-18 12:00:00	NQ	Futures	3963.82	3969.92	3962.08	3962.95	17706.0
2013-11-18 13:00:00	NQ	Futures	3962.95	3966.73	3961.5	3963.24	14993.0
2013-11-18 14:00:00	NQ	Futures	3963.24	3967.02	3951.92	3952.21	24025.0
2013-11-18 15:00:00	NQ	Futures	3952.5	3952.5	3926.94	3934.78	56293.0
2013-11-18 16:00:00	NQ	Futures	3934.78	3935.94	3931.0	3934.2	9457.0
2013-11-18 17:00:00	NQ	Futures	3934.49	3934.78	3933.62	3934.2	162.0
2013-11-18 18:00:00	NQ	Futures	3935.65	3936.52	3930.71	3933.62	677.0
2013-11-18 19:00:00	NQ	Futures	3933.33	3937.97	3933.04	3933.91	1125.0
2013-11-18 20:00:00	NQ	Futures	3934.2	3934.78	3928.1	3928.68	1556.0
2013-11-18 21:00:00	NQ	Futures	3928.68	3934.2	3928.68	3931.88	661.0
2013-11-18 22:00:00	NQ	Futures	3931.58	3935.94	3931.0	3934.78	559.0
2013-11-18 23:00:00	NQ	Futures	3935.07	3935.36	3933.04	3933.62	349.0
2013-11-18 00:00:00	YM	Futures	16246.0	16249.1	16236.8	16239.9	577.0
2013-11-18 01:00:00	YM	Futures	16239.9	16248.0	16238.8	16246.0	334.0

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

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