PREVIEW / futures_1hour / 2013-10-03

all futures 1-hour files

  file:    by_date/futures_1hour/2013/2013-10-03.parquet
  size:    49 KB
  rows:    1,532

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-10-03 00:00:00	ES	Futures	1734.27	1734.78	1733.75	1734.78	1431.0
2013-10-03 01:00:00	ES	Futures	1734.53	1735.3	1733.75	1735.3	3013.0
2013-10-03 02:00:00	ES	Futures	1735.04	1735.3	1731.95	1734.01	5398.0
2013-10-03 03:00:00	ES	Futures	1733.75	1735.56	1732.46	1733.75	13498.0
2013-10-03 04:00:00	ES	Futures	1733.75	1734.01	1731.69	1733.24	9631.0
2013-10-03 05:00:00	ES	Futures	1733.24	1734.53	1730.66	1730.91	11737.0
2013-10-03 06:00:00	ES	Futures	1730.91	1732.46	1730.66	1732.2	9785.0
2013-10-03 07:00:00	ES	Futures	1731.95	1734.53	1731.43	1733.75	17124.0
2013-10-03 08:00:00	ES	Futures	1733.75	1737.62	1732.72	1736.85	43650.0
2013-10-03 09:00:00	ES	Futures	1737.11	1738.4	1730.91	1731.95	215914.0
2013-10-03 10:00:00	ES	Futures	1731.95	1732.2	1723.43	1726.01	349064.0
2013-10-03 11:00:00	ES	Futures	1726.01	1727.56	1716.73	1717.76	340758.0
2013-10-03 12:00:00	ES	Futures	1717.76	1724.72	1716.21	1723.95	313381.0
2013-10-03 13:00:00	ES	Futures	1724.21	1730.91	1722.66	1730.4	285643.0
2013-10-03 14:00:00	ES	Futures	1730.14	1730.4	1721.37	1727.04	263777.0
2013-10-03 15:00:00	ES	Futures	1727.04	1729.11	1723.69	1724.98	216196.0
2013-10-03 16:00:00	ES	Futures	1724.98	1725.24	1720.6	1720.85	103704.0
2013-10-03 17:00:00	ES	Futures	1720.85	1721.11	1720.6	1720.6	2470.0
2013-10-03 18:00:00	ES	Futures	1721.11	1723.95	1721.11	1722.92	4557.0
2013-10-03 19:00:00	ES	Futures	1722.92	1723.43	1722.4	1723.18	1532.0
2013-10-03 20:00:00	ES	Futures	1722.92	1723.43	1720.6	1721.63	4969.0
2013-10-03 21:00:00	ES	Futures	1721.63	1723.43	1720.6	1723.18	7161.0
2013-10-03 22:00:00	ES	Futures	1722.92	1725.24	1722.92	1724.47	7003.0
2013-10-03 23:00:00	ES	Futures	1724.47	1725.24	1722.92	1724.21	4050.0
2013-10-03 00:00:00	NQ	Futures	3759.65	3760.52	3758.2	3760.52	238.0
2013-10-03 01:00:00	NQ	Futures	3760.23	3761.39	3757.91	3761.39	588.0
2013-10-03 02:00:00	NQ	Futures	3760.52	3761.39	3755.29	3759.36	543.0
2013-10-03 03:00:00	NQ	Futures	3759.36	3763.71	3757.03	3760.23	2802.0
2013-10-03 04:00:00	NQ	Futures	3759.94	3760.23	3754.71	3758.49	1820.0
2013-10-03 05:00:00	NQ	Futures	3758.78	3761.39	3752.97	3753.26	2064.0
2013-10-03 06:00:00	NQ	Futures	3753.26	3756.45	3752.97	3756.16	1691.0
2013-10-03 07:00:00	NQ	Futures	3756.16	3760.23	3755.0	3758.2	2135.0
2013-10-03 08:00:00	NQ	Futures	3758.49	3767.78	3756.45	3766.62	4372.0
2013-10-03 09:00:00	NQ	Futures	3766.91	3773.3	3753.55	3757.33	36913.0
2013-10-03 10:00:00	NQ	Futures	3757.03	3757.33	3729.73	3738.16	61261.0
2013-10-03 11:00:00	NQ	Futures	3738.45	3744.26	3706.5	3708.82	62784.0
2013-10-03 12:00:00	NQ	Futures	3708.53	3723.05	3705.05	3721.31	44156.0
2013-10-03 13:00:00	NQ	Futures	3721.6	3736.7	3717.25	3735.54	45530.0
2013-10-03 14:00:00	NQ	Futures	3735.83	3736.12	3713.18	3723.64	46176.0
2013-10-03 15:00:00	NQ	Futures	3723.93	3730.9	3720.73	3725.67	32791.0
2013-10-03 16:00:00	NQ	Futures	3725.67	3725.96	3718.12	3718.41	8480.0
2013-10-03 17:00:00	NQ	Futures	3718.41	3719.28	3718.12	3718.41	118.0
2013-10-03 18:00:00	NQ	Futures	3718.99	3724.51	3718.99	3722.47	602.0
2013-10-03 19:00:00	NQ	Futures	3722.76	3723.93	3721.6	3723.34	297.0
2013-10-03 20:00:00	NQ	Futures	3723.05	3724.22	3718.12	3719.57	721.0
2013-10-03 21:00:00	NQ	Futures	3719.86	3724.51	3718.41	3723.64	1240.0
2013-10-03 22:00:00	NQ	Futures	3723.93	3727.41	3723.93	3725.67	956.0
2013-10-03 23:00:00	NQ	Futures	3725.67	3726.54	3722.47	3724.51	501.0
2013-10-03 00:00:00	YM	Futures	15325.9	15329.9	15320.7	15327.9	391.0
2013-10-03 01:00:00	YM	Futures	15328.9	15332.0	15320.7	15331.0	629.0

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

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