PREVIEW / futures_1hour / 2013-10-02

all futures 1-hour files

  file:    by_date/futures_1hour/2013/2013-10-02.parquet
  size:    50 KB
  rows:    1,537

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-02 00:00:00	ES	Futures	1740.46	1740.97	1740.2	1740.46	3711.0
2013-10-02 01:00:00	ES	Futures	1740.46	1740.97	1738.14	1739.69	8872.0
2013-10-02 02:00:00	ES	Futures	1739.69	1739.69	1737.11	1738.14	9317.0
2013-10-02 03:00:00	ES	Futures	1737.88	1737.88	1729.62	1730.91	55854.0
2013-10-02 04:00:00	ES	Futures	1730.91	1732.2	1728.85	1730.4	29127.0
2013-10-02 05:00:00	ES	Futures	1730.4	1733.49	1729.37	1731.17	26227.0
2013-10-02 06:00:00	ES	Futures	1731.17	1731.95	1729.62	1731.17	21507.0
2013-10-02 07:00:00	ES	Futures	1731.17	1735.3	1730.4	1734.27	38359.0
2013-10-02 08:00:00	ES	Futures	1734.27	1735.04	1728.59	1730.14	78501.0
2013-10-02 09:00:00	ES	Futures	1730.4	1734.53	1729.37	1731.69	229158.0
2013-10-02 10:00:00	ES	Futures	1731.69	1732.72	1726.53	1731.43	273981.0
2013-10-02 11:00:00	ES	Futures	1731.43	1736.33	1730.91	1735.3	189830.0
2013-10-02 12:00:00	ES	Futures	1735.3	1739.17	1735.04	1737.88	137326.0
2013-10-02 13:00:00	ES	Futures	1737.88	1741.23	1737.36	1739.43	111507.0
2013-10-02 14:00:00	ES	Futures	1739.17	1739.43	1735.56	1736.85	122444.0
2013-10-02 15:00:00	ES	Futures	1736.85	1741.23	1735.82	1740.46	181302.0
2013-10-02 16:00:00	ES	Futures	1740.72	1740.72	1735.82	1737.11	97030.0
2013-10-02 17:00:00	ES	Futures	1737.11	1737.36	1736.33	1736.33	1856.0
2013-10-02 18:00:00	ES	Futures	1736.59	1737.11	1734.53	1734.78	6384.0
2013-10-02 19:00:00	ES	Futures	1735.04	1735.04	1726.79	1730.14	22104.0
2013-10-02 20:00:00	ES	Futures	1730.14	1730.91	1728.59	1729.37	11189.0
2013-10-02 21:00:00	ES	Futures	1729.37	1732.46	1729.37	1731.95	6495.0
2013-10-02 22:00:00	ES	Futures	1732.2	1733.49	1731.69	1733.24	4442.0
2013-10-02 23:00:00	ES	Futures	1733.24	1735.56	1733.24	1734.53	5869.0
2013-10-02 00:00:00	NQ	Futures	3766.04	3767.49	3765.46	3766.91	190.0
2013-10-02 01:00:00	NQ	Futures	3766.91	3767.2	3763.71	3765.75	965.0
2013-10-02 02:00:00	NQ	Futures	3765.46	3765.75	3762.26	3764.59	1082.0
2013-10-02 03:00:00	NQ	Futures	3764.59	3764.59	3746.87	3750.06	7572.0
2013-10-02 04:00:00	NQ	Futures	3750.06	3752.1	3744.84	3749.77	4318.0
2013-10-02 05:00:00	NQ	Futures	3749.77	3756.45	3747.16	3751.23	3776.0
2013-10-02 06:00:00	NQ	Futures	3751.52	3753.26	3748.32	3750.65	3424.0
2013-10-02 07:00:00	NQ	Futures	3750.35	3760.23	3749.48	3757.91	4030.0
2013-10-02 08:00:00	NQ	Futures	3757.91	3759.94	3746.58	3748.61	10311.0
2013-10-02 09:00:00	NQ	Futures	3748.61	3761.1	3743.68	3757.62	41582.0
2013-10-02 10:00:00	NQ	Futures	3757.33	3760.81	3741.93	3756.74	39800.0
2013-10-02 11:00:00	NQ	Futures	3756.74	3766.04	3755.58	3763.42	28446.0
2013-10-02 12:00:00	NQ	Futures	3763.42	3771.56	3761.97	3766.04	22143.0
2013-10-02 13:00:00	NQ	Futures	3766.33	3775.62	3763.13	3772.14	17890.0
2013-10-02 14:00:00	NQ	Futures	3771.85	3772.14	3761.97	3765.46	17103.0
2013-10-02 15:00:00	NQ	Futures	3765.17	3771.56	3761.39	3770.1	27353.0
2013-10-02 16:00:00	NQ	Futures	3770.1	3770.39	3761.68	3763.71	7568.0
2013-10-02 17:00:00	NQ	Futures	3763.71	3764.01	3762.84	3763.71	156.0
2013-10-02 18:00:00	NQ	Futures	3763.71	3763.71	3759.65	3759.65	419.0
2013-10-02 19:00:00	NQ	Futures	3759.94	3759.94	3744.26	3751.23	2230.0
2013-10-02 20:00:00	NQ	Futures	3751.52	3753.84	3748.03	3749.48	1912.0
2013-10-02 21:00:00	NQ	Futures	3750.06	3756.45	3749.77	3755.29	1247.0
2013-10-02 22:00:00	NQ	Futures	3755.29	3758.49	3754.42	3757.91	580.0
2013-10-02 23:00:00	NQ	Futures	3757.91	3761.97	3757.62	3758.78	905.0
2013-10-02 00:00:00	YM	Futures	15415.7	15421.9	15414.7	15417.8	422.0
2013-10-02 01:00:00	YM	Futures	15418.8	15419.8	15401.4	15413.7	1051.0

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

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