PREVIEW / futures_1hour / 2013-10-08

all futures 1-hour files

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

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-08 00:00:00	ES	Futures	1719.82	1721.11	1719.05	1720.34	3039.0
2013-10-08 01:00:00	ES	Futures	1720.6	1722.4	1719.56	1722.14	5252.0
2013-10-08 02:00:00	ES	Futures	1721.89	1722.92	1720.85	1722.4	8282.0
2013-10-08 03:00:00	ES	Futures	1722.4	1723.95	1720.6	1722.4	23311.0
2013-10-08 04:00:00	ES	Futures	1722.4	1723.43	1720.34	1721.37	19327.0
2013-10-08 05:00:00	ES	Futures	1721.37	1721.63	1719.05	1720.6	10357.0
2013-10-08 06:00:00	ES	Futures	1720.6	1721.89	1719.82	1720.34	10068.0
2013-10-08 07:00:00	ES	Futures	1720.34	1722.14	1719.31	1721.89	22408.0
2013-10-08 08:00:00	ES	Futures	1721.89	1724.72	1721.63	1723.43	51079.0
2013-10-08 09:00:00	ES	Futures	1723.18	1724.47	1718.27	1723.43	275605.0
2013-10-08 10:00:00	ES	Futures	1723.43	1723.95	1714.4	1715.44	368092.0
2013-10-08 11:00:00	ES	Futures	1715.44	1716.21	1708.21	1711.31	378075.0
2013-10-08 12:00:00	ES	Futures	1711.31	1711.31	1705.89	1710.28	254255.0
2013-10-08 13:00:00	ES	Futures	1710.28	1711.57	1706.15	1706.67	168873.0
2013-10-08 14:00:00	ES	Futures	1706.67	1708.73	1703.31	1706.41	235736.0
2013-10-08 15:00:00	ES	Futures	1706.41	1710.02	1700.73	1702.02	325520.0
2013-10-08 16:00:00	ES	Futures	1702.28	1704.34	1698.93	1698.93	137739.0
2013-10-08 17:00:00	ES	Futures	1699.19	1699.96	1698.41	1698.67	4762.0
2013-10-08 18:00:00	ES	Futures	1700.48	1707.18	1699.96	1707.18	22750.0
2013-10-08 19:00:00	ES	Futures	1707.18	1710.28	1706.67	1707.18	17661.0
2013-10-08 20:00:00	ES	Futures	1707.18	1707.96	1705.89	1706.92	7741.0
2013-10-08 21:00:00	ES	Futures	1706.92	1708.73	1706.41	1707.18	5804.0
2013-10-08 22:00:00	ES	Futures	1706.92	1709.5	1706.92	1707.44	7997.0
2013-10-08 23:00:00	ES	Futures	1707.44	1709.25	1707.18	1708.21	3824.0
2013-10-08 00:00:00	NQ	Futures	3723.93	3727.99	3723.64	3725.67	474.0
2013-10-08 01:00:00	NQ	Futures	3725.67	3730.61	3723.64	3729.15	735.0
2013-10-08 02:00:00	NQ	Futures	3728.86	3731.19	3726.54	3730.9	1132.0
2013-10-08 03:00:00	NQ	Futures	3730.9	3732.93	3724.8	3729.15	3173.0
2013-10-08 04:00:00	NQ	Futures	3729.15	3731.19	3723.93	3726.25	2431.0
2013-10-08 05:00:00	NQ	Futures	3726.25	3726.25	3721.02	3724.51	1778.0
2013-10-08 06:00:00	NQ	Futures	3724.22	3727.99	3722.18	3724.22	1655.0
2013-10-08 07:00:00	NQ	Futures	3724.51	3727.12	3721.89	3726.54	3529.0
2013-10-08 08:00:00	NQ	Futures	3726.54	3734.38	3726.54	3730.32	3567.0
2013-10-08 09:00:00	NQ	Futures	3730.32	3730.32	3711.73	3721.31	47410.0
2013-10-08 10:00:00	NQ	Futures	3721.6	3722.76	3684.72	3687.04	75865.0
2013-10-08 11:00:00	NQ	Futures	3687.04	3688.78	3665.84	3674.84	61316.0
2013-10-08 12:00:00	NQ	Futures	3675.13	3675.13	3658.0	3669.61	45255.0
2013-10-08 13:00:00	NQ	Futures	3669.61	3673.39	3660.61	3661.48	32679.0
2013-10-08 14:00:00	NQ	Futures	3661.19	3665.84	3652.77	3661.48	52930.0
2013-10-08 15:00:00	NQ	Futures	3661.48	3672.23	3653.93	3656.25	61711.0
2013-10-08 16:00:00	NQ	Futures	3656.55	3663.23	3653.06	3653.64	15531.0
2013-10-08 17:00:00	NQ	Futures	3654.22	3655.38	3652.77	3653.06	374.0
2013-10-08 18:00:00	NQ	Futures	3655.09	3668.16	3655.09	3667.87	2328.0
2013-10-08 19:00:00	NQ	Futures	3667.87	3674.26	3667.58	3669.03	2226.0
2013-10-08 20:00:00	NQ	Futures	3669.32	3669.91	3666.13	3667.87	1224.0
2013-10-08 21:00:00	NQ	Futures	3667.58	3671.65	3666.71	3668.74	895.0
2013-10-08 22:00:00	NQ	Futures	3668.74	3672.23	3668.16	3668.74	949.0
2013-10-08 23:00:00	NQ	Futures	3668.45	3671.94	3668.16	3669.91	707.0
2013-10-08 00:00:00	YM	Futures	15159.4	15171.6	15156.3	15162.5	531.0
2013-10-08 01:00:00	YM	Futures	15163.5	15180.8	15157.3	15176.8	821.0

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

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