PREVIEW / futures_1hour / 2013-09-20

all futures 1-hour files

  file:    by_date/futures_1hour/2013/2013-09-20.parquet
  size:    42 KB
  rows:    1,256

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-20 00:00:00	ES	Futures	1769.61	1770.12	1769.35	1770.12	848.0
2013-09-20 01:00:00	ES	Futures	1770.12	1770.64	1769.87	1770.64	1782.0
2013-09-20 02:00:00	ES	Futures	1770.64	1770.9	1769.09	1770.12	6081.0
2013-09-20 03:00:00	ES	Futures	1770.38	1771.93	1769.35	1771.16	18479.0
2013-09-20 04:00:00	ES	Futures	1771.41	1772.19	1770.9	1771.16	11346.0
2013-09-20 05:00:00	ES	Futures	1771.16	1772.19	1770.64	1771.93	14211.0
2013-09-20 06:00:00	ES	Futures	1771.93	1772.19	1771.16	1771.93	9577.0
2013-09-20 07:00:00	ES	Futures	1771.67	1773.22	1770.64	1770.9	25278.0
2013-09-20 08:00:00	ES	Futures	1771.16	1771.16	1768.32	1770.64	82134.0
2013-09-20 09:00:00	ES	Futures	1770.38	1774.25	1767.54	1769.09	275780.0
2013-09-20 10:00:00	ES	Futures	1768.83	1770.38	1766.25	1769.09	223140.0
2013-09-20 11:00:00	ES	Futures	1768.83	1769.87	1762.13	1762.64	203430.0
2013-09-20 12:00:00	ES	Futures	1762.64	1764.45	1761.1	1763.93	142231.0
2013-09-20 13:00:00	ES	Futures	1763.93	1764.45	1759.55	1759.81	124802.0
2013-09-20 14:00:00	ES	Futures	1759.81	1761.61	1758.26	1760.06	136758.0
2013-09-20 15:00:00	ES	Futures	1760.06	1761.35	1755.42	1756.97	297173.0
2013-09-20 16:00:00	ES	Futures	1756.97	1758.77	1755.42	1758.52	130918.0
2013-09-20 17:00:00	ES	Futures	1758.52	1759.03	1757.74	1758.0	3167.0
2013-09-20 00:00:00	NQ	Futures	3750.06	3752.1	3750.06	3752.1	230.0
2013-09-20 01:00:00	NQ	Futures	3751.52	3753.55	3750.94	3753.26	160.0
2013-09-20 02:00:00	NQ	Futures	3753.26	3754.71	3751.52	3753.26	760.0
2013-09-20 03:00:00	NQ	Futures	3753.26	3758.2	3751.81	3757.62	2233.0
2013-09-20 04:00:00	NQ	Futures	3757.91	3759.07	3756.74	3757.03	2237.0
2013-09-20 05:00:00	NQ	Futures	3757.03	3759.94	3756.16	3758.78	1810.0
2013-09-20 06:00:00	NQ	Futures	3758.78	3759.07	3757.33	3758.49	974.0
2013-09-20 07:00:00	NQ	Futures	3758.78	3760.81	3757.62	3758.49	3083.0
2013-09-20 08:00:00	NQ	Futures	3758.2	3759.94	3753.55	3758.78	6395.0
2013-09-20 09:00:00	NQ	Futures	3758.78	3764.3	3753.55	3755.58	29971.0
2013-09-20 10:00:00	NQ	Futures	3755.87	3765.75	3754.13	3761.39	24380.0
2013-09-20 11:00:00	NQ	Futures	3761.39	3762.26	3744.55	3746.29	33739.0
2013-09-20 12:00:00	NQ	Futures	3746.58	3752.68	3743.38	3752.39	20946.0
2013-09-20 13:00:00	NQ	Futures	3752.1	3752.97	3741.64	3743.97	15705.0
2013-09-20 14:00:00	NQ	Futures	3743.97	3748.32	3740.19	3744.84	19139.0
2013-09-20 15:00:00	NQ	Futures	3744.55	3747.45	3738.16	3740.48	35763.0
2013-09-20 16:00:00	NQ	Futures	3740.48	3743.09	3737.58	3739.61	7012.0
2013-09-20 17:00:00	NQ	Futures	3739.61	3740.48	3737.58	3737.58	424.0
2013-09-20 00:00:00	YM	Futures	15886.5	15888.6	15883.5	15888.6	173.0
2013-09-20 01:00:00	YM	Futures	15886.5	15891.6	15886.5	15890.6	248.0
2013-09-20 02:00:00	YM	Futures	15890.6	15893.7	15879.4	15887.5	562.0
2013-09-20 03:00:00	YM	Futures	15886.5	15899.8	15880.4	15897.8	1489.0
2013-09-20 04:00:00	YM	Futures	15898.8	15902.9	15894.7	15897.8	684.0
2013-09-20 05:00:00	YM	Futures	15896.7	15908.0	15894.7	15904.9	1108.0
2013-09-20 06:00:00	YM	Futures	15904.9	15904.9	15898.8	15902.9	709.0
2013-09-20 07:00:00	YM	Futures	15902.9	15911.0	15893.7	15895.7	1692.0
2013-09-20 08:00:00	YM	Futures	15894.7	15896.7	15875.3	15890.6	4919.0
2013-09-20 09:00:00	YM	Futures	15890.6	15915.1	15862.0	15872.2	16814.0
2013-09-20 10:00:00	YM	Futures	15872.2	15886.5	15854.9	15876.3	14552.0
2013-09-20 11:00:00	YM	Futures	15876.3	15881.4	15822.2	15825.2	13850.0
2013-09-20 12:00:00	YM	Futures	15825.2	15837.5	15808.9	15821.2	8782.0
2013-09-20 13:00:00	YM	Futures	15820.1	15824.2	15778.3	15779.3	9876.0

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

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