PREVIEW / futures_1hour / 2013-10-01

all futures 1-hour files

  file:    by_date/futures_1hour/2013/2013-10-01.parquet
  size:    51 KB
  rows:    1,541

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-01 00:00:00	ES	Futures	1729.88	1733.24	1729.37	1731.69	7538.0
2013-10-01 01:00:00	ES	Futures	1731.69	1733.24	1730.91	1731.69	5062.0
2013-10-01 02:00:00	ES	Futures	1731.43	1732.98	1731.17	1732.46	6286.0
2013-10-01 03:00:00	ES	Futures	1732.46	1737.11	1732.2	1736.85	30114.0
2013-10-01 04:00:00	ES	Futures	1737.11	1737.88	1735.3	1736.07	17455.0
2013-10-01 05:00:00	ES	Futures	1736.07	1736.85	1732.98	1735.04	20807.0
2013-10-01 06:00:00	ES	Futures	1735.04	1736.33	1734.78	1734.78	9161.0
2013-10-01 07:00:00	ES	Futures	1735.04	1735.3	1731.17	1732.98	37788.0
2013-10-01 08:00:00	ES	Futures	1732.72	1734.27	1729.62	1732.72	51297.0
2013-10-01 09:00:00	ES	Futures	1732.72	1736.07	1728.59	1731.69	257141.0
2013-10-01 10:00:00	ES	Futures	1731.43	1742.01	1730.91	1740.97	363248.0
2013-10-01 11:00:00	ES	Futures	1740.97	1743.3	1739.17	1742.01	163260.0
2013-10-01 12:00:00	ES	Futures	1742.01	1744.33	1740.72	1741.49	108799.0
2013-10-01 13:00:00	ES	Futures	1741.23	1742.52	1739.69	1740.97	87528.0
2013-10-01 14:00:00	ES	Futures	1740.97	1740.97	1736.33	1738.4	123380.0
2013-10-01 15:00:00	ES	Futures	1738.65	1743.04	1735.82	1742.01	241842.0
2013-10-01 16:00:00	ES	Futures	1742.26	1746.13	1742.01	1744.59	165086.0
2013-10-01 17:00:00	ES	Futures	1744.84	1745.88	1744.59	1745.62	3128.0
2013-10-01 18:00:00	ES	Futures	1745.36	1745.62	1744.33	1744.84	7662.0
2013-10-01 19:00:00	ES	Futures	1744.84	1744.84	1742.78	1743.04	5158.0
2013-10-01 20:00:00	ES	Futures	1743.04	1743.55	1742.52	1742.78	5099.0
2013-10-01 21:00:00	ES	Futures	1743.04	1743.04	1741.49	1741.75	6973.0
2013-10-01 22:00:00	ES	Futures	1741.75	1742.26	1740.72	1742.01	5875.0
2013-10-01 23:00:00	ES	Futures	1742.26	1742.26	1740.46	1740.46	4718.0
2013-10-01 00:00:00	NQ	Futures	3734.96	3742.51	3734.67	3739.03	880.0
2013-10-01 01:00:00	NQ	Futures	3739.61	3742.8	3737.87	3739.61	619.0
2013-10-01 02:00:00	NQ	Futures	3739.32	3742.22	3738.45	3741.64	432.0
2013-10-01 03:00:00	NQ	Futures	3741.35	3750.94	3740.77	3749.77	3975.0
2013-10-01 04:00:00	NQ	Futures	3750.06	3750.65	3744.84	3746.58	1601.0
2013-10-01 05:00:00	NQ	Futures	3746.58	3748.03	3739.03	3743.68	2224.0
2013-10-01 06:00:00	NQ	Futures	3743.38	3746.29	3742.51	3742.51	958.0
2013-10-01 07:00:00	NQ	Futures	3742.51	3743.68	3737.0	3739.61	3269.0
2013-10-01 08:00:00	NQ	Futures	3739.32	3743.09	3733.51	3741.64	5195.0
2013-10-01 09:00:00	NQ	Futures	3741.35	3750.35	3732.64	3737.29	40233.0
2013-10-01 10:00:00	NQ	Futures	3737.58	3766.04	3737.0	3763.71	55544.0
2013-10-01 11:00:00	NQ	Futures	3764.01	3768.65	3759.94	3766.91	21320.0
2013-10-01 12:00:00	NQ	Futures	3766.91	3774.17	3765.17	3767.2	22837.0
2013-10-01 13:00:00	NQ	Futures	3767.49	3769.23	3761.39	3764.59	16261.0
2013-10-01 14:00:00	NQ	Futures	3764.59	3764.88	3755.0	3759.65	19268.0
2013-10-01 15:00:00	NQ	Futures	3759.36	3772.14	3754.13	3770.98	34964.0
2013-10-01 16:00:00	NQ	Futures	3770.98	3777.07	3770.39	3774.75	12986.0
2013-10-01 17:00:00	NQ	Futures	3774.75	3777.07	3774.46	3777.07	556.0
2013-10-01 18:00:00	NQ	Futures	3776.78	3776.78	3774.46	3774.46	493.0
2013-10-01 19:00:00	NQ	Futures	3774.17	3774.17	3770.69	3770.69	405.0
2013-10-01 20:00:00	NQ	Futures	3770.69	3773.01	3770.69	3771.85	524.0
2013-10-01 21:00:00	NQ	Futures	3771.56	3771.56	3768.07	3768.36	1004.0
2013-10-01 22:00:00	NQ	Futures	3768.65	3769.52	3766.62	3769.52	717.0
2013-10-01 23:00:00	NQ	Futures	3769.52	3769.52	3765.75	3765.75	456.0
2013-10-01 00:00:00	YM	Futures	15384.1	15409.6	15379.0	15395.3	1367.0
2013-10-01 01:00:00	YM	Futures	15396.3	15407.6	15389.2	15394.3	1146.0

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

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