PREVIEW / futures_1hour / 2013-10-14

all futures 1-hour files

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

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-14 00:00:00	ES	Futures	1741.23	1742.01	1739.69	1740.72	2426.0
2013-10-14 01:00:00	ES	Futures	1740.46	1740.97	1739.17	1739.94	3461.0
2013-10-14 02:00:00	ES	Futures	1739.94	1740.97	1738.65	1740.2	7841.0
2013-10-14 03:00:00	ES	Futures	1740.2	1743.55	1737.88	1742.78	20941.0
2013-10-14 04:00:00	ES	Futures	1742.78	1742.78	1739.94	1741.75	12797.0
2013-10-14 05:00:00	ES	Futures	1741.75	1742.01	1740.2	1740.72	7834.0
2013-10-14 06:00:00	ES	Futures	1740.72	1742.52	1740.2	1741.75	11971.0
2013-10-14 07:00:00	ES	Futures	1742.01	1742.52	1739.94	1740.2	17626.0
2013-10-14 08:00:00	ES	Futures	1740.2	1740.72	1737.88	1739.69	38255.0
2013-10-14 09:00:00	ES	Futures	1739.43	1745.62	1739.17	1743.81	172322.0
2013-10-14 10:00:00	ES	Futures	1743.81	1744.84	1741.49	1742.78	179222.0
2013-10-14 11:00:00	ES	Futures	1743.04	1750.0	1742.01	1749.49	155619.0
2013-10-14 12:00:00	ES	Futures	1749.49	1750.78	1747.68	1750.52	119703.0
2013-10-14 13:00:00	ES	Futures	1750.52	1755.68	1749.49	1754.39	143621.0
2013-10-14 14:00:00	ES	Futures	1754.13	1758.77	1753.87	1755.94	220260.0
2013-10-14 15:00:00	ES	Futures	1755.94	1760.32	1754.65	1759.03	223587.0
2013-10-14 16:00:00	ES	Futures	1759.29	1761.1	1757.48	1759.81	74426.0
2013-10-14 17:00:00	ES	Futures	1759.81	1761.1	1759.81	1760.58	3737.0
2013-10-14 18:00:00	ES	Futures	1760.58	1761.1	1759.03	1759.29	4916.0
2013-10-14 19:00:00	ES	Futures	1759.29	1764.19	1759.03	1763.42	7871.0
2013-10-14 20:00:00	ES	Futures	1763.16	1763.42	1760.58	1762.13	6599.0
2013-10-14 21:00:00	ES	Futures	1762.13	1762.64	1758.77	1759.03	6914.0
2013-10-14 22:00:00	ES	Futures	1759.29	1760.32	1759.03	1760.06	2477.0
2013-10-14 23:00:00	ES	Futures	1760.06	1760.84	1759.81	1760.32	2595.0
2013-10-14 00:00:00	NQ	Futures	3730.61	3731.48	3725.96	3727.99	745.0
2013-10-14 01:00:00	NQ	Futures	3728.28	3728.57	3724.22	3726.83	779.0
2013-10-14 02:00:00	NQ	Futures	3727.41	3729.73	3724.8	3727.41	1167.0
2013-10-14 03:00:00	NQ	Futures	3727.41	3735.54	3723.64	3733.22	3536.0
2013-10-14 04:00:00	NQ	Futures	3733.51	3733.51	3727.41	3730.61	1848.0
2013-10-14 05:00:00	NQ	Futures	3730.9	3731.19	3727.12	3728.28	1345.0
2013-10-14 06:00:00	NQ	Futures	3728.28	3733.8	3727.7	3731.48	2211.0
2013-10-14 07:00:00	NQ	Futures	3731.48	3732.35	3727.41	3727.99	1598.0
2013-10-14 08:00:00	NQ	Futures	3728.28	3728.28	3722.76	3725.09	3529.0
2013-10-14 09:00:00	NQ	Futures	3724.8	3741.64	3722.76	3740.48	27235.0
2013-10-14 10:00:00	NQ	Futures	3740.77	3743.68	3730.9	3734.09	34613.0
2013-10-14 11:00:00	NQ	Futures	3734.09	3753.55	3732.64	3752.68	24489.0
2013-10-14 12:00:00	NQ	Futures	3752.68	3758.78	3748.61	3758.2	19744.0
2013-10-14 13:00:00	NQ	Futures	3758.2	3764.01	3756.45	3763.13	17142.0
2013-10-14 14:00:00	NQ	Futures	3763.13	3773.59	3762.55	3766.33	32013.0
2013-10-14 15:00:00	NQ	Futures	3766.62	3775.91	3764.59	3775.04	38635.0
2013-10-14 16:00:00	NQ	Futures	3775.04	3780.85	3773.01	3778.82	11140.0
2013-10-14 17:00:00	NQ	Futures	3778.82	3781.43	3778.53	3780.27	299.0
2013-10-14 18:00:00	NQ	Futures	3779.69	3781.14	3776.78	3776.78	671.0
2013-10-14 19:00:00	NQ	Futures	3777.07	3785.79	3776.49	3785.5	1131.0
2013-10-14 20:00:00	NQ	Futures	3785.5	3785.5	3780.27	3784.05	1283.0
2013-10-14 21:00:00	NQ	Futures	3783.75	3784.63	3776.78	3777.66	1314.0
2013-10-14 22:00:00	NQ	Futures	3777.66	3780.56	3777.66	3779.69	696.0
2013-10-14 23:00:00	NQ	Futures	3779.4	3781.72	3779.4	3780.85	606.0
2013-10-14 00:00:00	YM	Futures	15405.5	15409.6	15390.2	15397.3	606.0
2013-10-14 01:00:00	YM	Futures	15397.3	15399.4	15384.1	15391.2	838.0

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

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