PREVIEW / futures_1hour / 2013-10-25

all futures 1-hour files

  file:    by_date/futures_1hour/2013/2013-10-25.parquet
  size:    40 KB
  rows:    1,230

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-25 00:00:00	ES	Futures	1802.63	1802.89	1800.05	1801.34	6810.0
2013-10-25 01:00:00	ES	Futures	1801.6	1801.6	1799.53	1799.53	5012.0
2013-10-25 02:00:00	ES	Futures	1799.79	1800.56	1798.76	1799.53	7651.0
2013-10-25 03:00:00	ES	Futures	1799.53	1800.82	1798.5	1799.02	14858.0
2013-10-25 04:00:00	ES	Futures	1799.27	1802.11	1798.24	1801.85	11727.0
2013-10-25 05:00:00	ES	Futures	1801.85	1803.4	1800.56	1802.89	11639.0
2013-10-25 06:00:00	ES	Futures	1802.89	1803.4	1801.6	1803.14	11370.0
2013-10-25 07:00:00	ES	Futures	1802.89	1805.21	1802.89	1804.18	27110.0
2013-10-25 08:00:00	ES	Futures	1804.18	1804.95	1802.11	1804.95	36646.0
2013-10-25 09:00:00	ES	Futures	1804.95	1807.79	1803.66	1807.01	163655.0
2013-10-25 10:00:00	ES	Futures	1807.27	1809.59	1803.14	1805.21	239226.0
2013-10-25 11:00:00	ES	Futures	1804.95	1807.53	1803.4	1804.43	164851.0
2013-10-25 12:00:00	ES	Futures	1804.69	1806.24	1802.37	1805.72	107869.0
2013-10-25 13:00:00	ES	Futures	1805.72	1807.01	1804.69	1805.98	79954.0
2013-10-25 14:00:00	ES	Futures	1805.98	1808.04	1805.46	1807.27	75205.0
2013-10-25 15:00:00	ES	Futures	1807.53	1810.62	1805.72	1810.62	185190.0
2013-10-25 16:00:00	ES	Futures	1810.62	1811.66	1809.08	1809.85	78589.0
2013-10-25 17:00:00	ES	Futures	1809.85	1810.11	1809.33	1809.59	744.0
2013-10-25 00:00:00	NQ	Futures	3919.39	3920.26	3917.64	3919.97	1117.0
2013-10-25 01:00:00	NQ	Futures	3920.26	3920.26	3915.9	3915.9	955.0
2013-10-25 02:00:00	NQ	Futures	3915.9	3916.77	3914.45	3916.19	1328.0
2013-10-25 03:00:00	NQ	Futures	3916.48	3918.22	3914.16	3914.45	2181.0
2013-10-25 04:00:00	NQ	Futures	3914.74	3919.97	3913.29	3919.97	2564.0
2013-10-25 05:00:00	NQ	Futures	3920.26	3924.61	3918.81	3924.32	2222.0
2013-10-25 06:00:00	NQ	Futures	3924.61	3925.49	3920.84	3924.61	1501.0
2013-10-25 07:00:00	NQ	Futures	3924.61	3930.42	3924.03	3925.49	3655.0
2013-10-25 08:00:00	NQ	Futures	3925.78	3929.26	3922.0	3929.26	5077.0
2013-10-25 09:00:00	NQ	Futures	3928.97	3939.43	3922.29	3937.97	45520.0
2013-10-25 10:00:00	NQ	Futures	3938.26	3941.46	3920.26	3923.16	38595.0
2013-10-25 11:00:00	NQ	Futures	3922.87	3924.61	3908.64	3910.67	36372.0
2013-10-25 12:00:00	NQ	Futures	3910.67	3915.9	3904.87	3915.61	21876.0
2013-10-25 13:00:00	NQ	Futures	3915.32	3921.71	3912.71	3918.81	13421.0
2013-10-25 14:00:00	NQ	Futures	3918.52	3923.74	3917.35	3921.42	10942.0
2013-10-25 15:00:00	NQ	Futures	3921.13	3922.87	3914.45	3922.0	25011.0
2013-10-25 16:00:00	NQ	Futures	3922.29	3924.32	3919.68	3922.0	5708.0
2013-10-25 17:00:00	NQ	Futures	3922.29	3922.29	3921.42	3921.42	84.0
2013-10-25 00:00:00	YM	Futures	15780.3	15780.3	15760.9	15773.2	1449.0
2013-10-25 01:00:00	YM	Futures	15775.2	15777.2	15760.9	15760.9	847.0
2013-10-25 02:00:00	YM	Futures	15760.9	15766.0	15753.8	15757.8	1136.0
2013-10-25 03:00:00	YM	Futures	15757.8	15766.0	15743.5	15750.7	3021.0
2013-10-25 04:00:00	YM	Futures	15749.7	15777.2	15744.6	15775.2	1838.0
2013-10-25 05:00:00	YM	Futures	15776.2	15785.4	15766.0	15783.4	1009.0
2013-10-25 06:00:00	YM	Futures	15784.4	15785.4	15771.1	15780.3	922.0
2013-10-25 07:00:00	YM	Futures	15780.3	15792.6	15779.3	15781.3	1410.0
2013-10-25 08:00:00	YM	Futures	15782.4	15786.4	15766.0	15784.4	2816.0
2013-10-25 09:00:00	YM	Futures	15785.4	15814.0	15777.2	15805.8	16093.0
2013-10-25 10:00:00	YM	Futures	15807.9	15828.3	15779.3	15796.6	18948.0
2013-10-25 11:00:00	YM	Futures	15795.6	15819.1	15786.4	15794.6	13301.0
2013-10-25 12:00:00	YM	Futures	15794.6	15806.9	15780.3	15803.8	7818.0
2013-10-25 13:00:00	YM	Futures	15804.8	15810.9	15793.6	15799.7	5381.0

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

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