PREVIEW / futures_1hour / 2013-10-07

all futures 1-hour files

  file:    by_date/futures_1hour/2013/2013-10-07.parquet
  size:    47 KB
  rows:    1,485

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-07 00:00:00	ES	Futures	1727.3	1727.3	1727.04	1727.3	1110.0
2013-10-07 01:00:00	ES	Futures	1727.3	1728.08	1726.01	1727.04	4423.0
2013-10-07 02:00:00	ES	Futures	1726.79	1727.82	1725.76	1726.53	6235.0
2013-10-07 03:00:00	ES	Futures	1726.27	1726.27	1719.56	1720.85	37893.0
2013-10-07 04:00:00	ES	Futures	1720.85	1721.37	1719.56	1721.37	16284.0
2013-10-07 05:00:00	ES	Futures	1721.11	1722.92	1720.08	1722.92	13575.0
2013-10-07 06:00:00	ES	Futures	1722.92	1722.92	1721.11	1722.4	11253.0
2013-10-07 07:00:00	ES	Futures	1722.4	1724.72	1721.37	1723.69	28091.0
2013-10-07 08:00:00	ES	Futures	1723.69	1725.24	1722.92	1723.95	29328.0
2013-10-07 09:00:00	ES	Futures	1723.95	1727.04	1720.34	1725.24	226240.0
2013-10-07 10:00:00	ES	Futures	1725.5	1732.46	1724.21	1730.14	279249.0
2013-10-07 11:00:00	ES	Futures	1730.4	1732.2	1727.56	1730.4	171851.0
2013-10-07 12:00:00	ES	Futures	1730.66	1730.66	1726.01	1726.79	104516.0
2013-10-07 13:00:00	ES	Futures	1726.53	1731.43	1726.53	1731.17	99511.0
2013-10-07 14:00:00	ES	Futures	1731.17	1732.98	1728.85	1730.66	166542.0
2013-10-07 15:00:00	ES	Futures	1730.66	1731.43	1721.89	1722.4	244936.0
2013-10-07 16:00:00	ES	Futures	1722.4	1722.66	1720.08	1721.11	105589.0
2013-10-07 17:00:00	ES	Futures	1721.11	1721.37	1720.34	1720.6	2134.0
2013-10-07 18:00:00	ES	Futures	1720.08	1721.63	1717.76	1721.11	11742.0
2013-10-07 19:00:00	ES	Futures	1720.85	1721.11	1720.08	1720.6	3269.0
2013-10-07 20:00:00	ES	Futures	1720.6	1721.11	1717.76	1717.76	9009.0
2013-10-07 21:00:00	ES	Futures	1717.76	1719.31	1715.69	1719.05	15509.0
2013-10-07 22:00:00	ES	Futures	1718.79	1720.08	1718.02	1719.82	4882.0
2013-10-07 23:00:00	ES	Futures	1719.82	1720.08	1718.27	1719.82	4503.0
2013-10-07 00:00:00	NQ	Futures	3739.32	3740.77	3739.32	3740.48	190.0
2013-10-07 01:00:00	NQ	Futures	3740.77	3741.93	3738.74	3740.19	865.0
2013-10-07 02:00:00	NQ	Futures	3739.9	3741.35	3737.87	3739.32	800.0
2013-10-07 03:00:00	NQ	Futures	3739.03	3739.03	3719.86	3720.73	6600.0
2013-10-07 04:00:00	NQ	Futures	3720.73	3723.64	3719.57	3723.34	2434.0
2013-10-07 05:00:00	NQ	Futures	3723.34	3728.57	3721.02	3728.57	1629.0
2013-10-07 06:00:00	NQ	Futures	3728.57	3728.57	3723.34	3727.12	1836.0
2013-10-07 07:00:00	NQ	Futures	3727.12	3732.06	3724.8	3729.73	2502.0
2013-10-07 08:00:00	NQ	Futures	3730.02	3734.67	3727.99	3731.77	3769.0
2013-10-07 09:00:00	NQ	Futures	3731.77	3747.16	3723.05	3740.19	40423.0
2013-10-07 10:00:00	NQ	Futures	3740.19	3755.58	3737.29	3746.87	36036.0
2013-10-07 11:00:00	NQ	Futures	3747.16	3748.32	3737.29	3743.68	20738.0
2013-10-07 12:00:00	NQ	Futures	3743.38	3745.42	3730.61	3732.06	18138.0
2013-10-07 13:00:00	NQ	Futures	3732.06	3747.45	3731.48	3747.45	17035.0
2013-10-07 14:00:00	NQ	Futures	3747.16	3750.06	3739.32	3744.84	30401.0
2013-10-07 15:00:00	NQ	Futures	3744.84	3746.0	3725.96	3727.41	40863.0
2013-10-07 16:00:00	NQ	Futures	3727.41	3727.7	3723.05	3725.67	7574.0
2013-10-07 17:00:00	NQ	Futures	3725.96	3725.96	3724.51	3725.09	204.0
2013-10-07 18:00:00	NQ	Futures	3725.09	3727.12	3718.7	3725.67	1287.0
2013-10-07 19:00:00	NQ	Futures	3726.25	3726.83	3723.34	3725.38	439.0
2013-10-07 20:00:00	NQ	Futures	3725.09	3725.96	3718.99	3719.28	940.0
2013-10-07 21:00:00	NQ	Futures	3719.28	3723.05	3715.21	3721.89	2246.0
2013-10-07 22:00:00	NQ	Futures	3721.6	3725.09	3720.15	3724.22	807.0
2013-10-07 23:00:00	NQ	Futures	3723.93	3725.67	3721.31	3724.22	720.0
2013-10-07 00:00:00	YM	Futures	15236.0	15241.1	15236.0	15240.1	227.0
2013-10-07 01:00:00	YM	Futures	15239.0	15245.2	15227.8	15236.0	740.0

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

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