PREVIEW / futures_1hour / 2013-09-26

all futures 1-hour files

  file:    by_date/futures_1hour/2013/2013-09-26.parquet
  size:    48 KB
  rows:    1,506

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-09-26 00:00:00	ES	Futures	1742.52	1742.52	1740.97	1742.01	3034.0
2013-09-26 01:00:00	ES	Futures	1741.75	1744.84	1741.75	1744.59	6621.0
2013-09-26 02:00:00	ES	Futures	1744.59	1747.17	1744.33	1746.39	11006.0
2013-09-26 03:00:00	ES	Futures	1746.13	1746.39	1743.55	1744.33	19263.0
2013-09-26 04:00:00	ES	Futures	1744.33	1744.59	1742.01	1743.04	15185.0
2013-09-26 05:00:00	ES	Futures	1742.78	1743.3	1741.75	1742.78	11836.0
2013-09-26 06:00:00	ES	Futures	1742.78	1742.78	1740.46	1741.75	14852.0
2013-09-26 07:00:00	ES	Futures	1741.75	1743.81	1741.49	1743.3	15922.0
2013-09-26 08:00:00	ES	Futures	1743.3	1744.84	1741.23	1743.81	33150.0
2013-09-26 09:00:00	ES	Futures	1743.81	1748.97	1742.01	1748.71	168476.0
2013-09-26 10:00:00	ES	Futures	1748.71	1751.55	1742.26	1743.55	322239.0
2013-09-26 11:00:00	ES	Futures	1743.55	1744.59	1740.2	1743.55	218815.0
2013-09-26 12:00:00	ES	Futures	1743.81	1746.13	1742.01	1744.59	99618.0
2013-09-26 13:00:00	ES	Futures	1744.84	1746.91	1742.52	1744.07	96633.0
2013-09-26 14:00:00	ES	Futures	1743.81	1744.07	1739.43	1740.97	142047.0
2013-09-26 15:00:00	ES	Futures	1740.97	1746.39	1739.69	1745.88	194886.0
2013-09-26 16:00:00	ES	Futures	1746.13	1748.2	1745.62	1747.42	71305.0
2013-09-26 17:00:00	ES	Futures	1747.68	1748.46	1747.42	1748.2	2224.0
2013-09-26 18:00:00	ES	Futures	1748.46	1749.49	1747.94	1749.49	3957.0
2013-09-26 19:00:00	ES	Futures	1749.23	1749.49	1747.94	1748.2	2096.0
2013-09-26 20:00:00	ES	Futures	1748.46	1748.46	1746.91	1746.91	4128.0
2013-09-26 21:00:00	ES	Futures	1746.91	1747.68	1746.13	1746.39	3081.0
2013-09-26 22:00:00	ES	Futures	1746.65	1746.65	1746.13	1746.13	2523.0
2013-09-26 23:00:00	ES	Futures	1746.39	1746.39	1746.13	1746.13	977.0
2013-09-26 00:00:00	NQ	Futures	3727.99	3728.57	3725.67	3727.41	414.0
2013-09-26 01:00:00	NQ	Futures	3727.12	3733.8	3727.12	3733.8	808.0
2013-09-26 02:00:00	NQ	Futures	3733.51	3739.9	3733.22	3739.03	2306.0
2013-09-26 03:00:00	NQ	Futures	3739.32	3739.32	3733.8	3735.83	3036.0
2013-09-26 04:00:00	NQ	Futures	3735.83	3736.41	3730.61	3732.93	2336.0
2013-09-26 05:00:00	NQ	Futures	3732.64	3733.8	3730.61	3732.06	1328.0
2013-09-26 06:00:00	NQ	Futures	3731.77	3732.06	3727.12	3730.02	1567.0
2013-09-26 07:00:00	NQ	Futures	3730.02	3734.67	3730.02	3734.09	2643.0
2013-09-26 08:00:00	NQ	Futures	3734.09	3738.16	3730.61	3737.29	4054.0
2013-09-26 09:00:00	NQ	Futures	3737.0	3750.65	3733.22	3750.06	29972.0
2013-09-26 10:00:00	NQ	Futures	3750.06	3758.49	3741.64	3743.09	44216.0
2013-09-26 11:00:00	NQ	Futures	3743.09	3746.58	3733.51	3745.13	35297.0
2013-09-26 12:00:00	NQ	Futures	3745.42	3752.1	3741.93	3750.65	13222.0
2013-09-26 13:00:00	NQ	Futures	3750.65	3755.58	3744.84	3748.61	13732.0
2013-09-26 14:00:00	NQ	Futures	3748.61	3748.61	3738.45	3741.35	18206.0
2013-09-26 15:00:00	NQ	Futures	3741.06	3750.35	3737.87	3748.32	26271.0
2013-09-26 16:00:00	NQ	Futures	3748.61	3752.1	3747.74	3750.94	6370.0
2013-09-26 17:00:00	NQ	Futures	3750.94	3752.39	3750.94	3752.1	100.0
2013-09-26 18:00:00	NQ	Futures	3752.1	3756.45	3752.1	3756.16	982.0
2013-09-26 19:00:00	NQ	Futures	3756.16	3756.45	3752.68	3752.97	489.0
2013-09-26 20:00:00	NQ	Futures	3753.26	3753.26	3750.94	3750.94	618.0
2013-09-26 21:00:00	NQ	Futures	3750.94	3752.68	3749.48	3750.06	442.0
2013-09-26 22:00:00	NQ	Futures	3750.35	3750.65	3749.48	3750.06	276.0
2013-09-26 23:00:00	NQ	Futures	3749.77	3750.65	3749.77	3750.06	74.0
2013-09-26 00:00:00	YM	Futures	15557.7	15557.7	15548.5	15554.6	335.0
2013-09-26 01:00:00	YM	Futures	15554.6	15575.0	15553.6	15575.0	1322.0

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

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