PREVIEW / futures_1hour / 2013-11-20

all futures 1-hour files

  file:    by_date/futures_1hour/2013/2013-11-20.parquet
  size:    51 KB
  rows:    1,542

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-11-20 00:00:00	ES	Futures	1842.61	1842.61	1840.81	1841.06	2674.0
2013-11-20 01:00:00	ES	Futures	1840.81	1842.35	1840.29	1841.06	4197.0
2013-11-20 02:00:00	ES	Futures	1841.06	1842.87	1841.06	1841.84	5648.0
2013-11-20 03:00:00	ES	Futures	1841.84	1844.42	1841.06	1843.39	24746.0
2013-11-20 04:00:00	ES	Futures	1843.13	1843.39	1841.84	1842.61	13043.0
2013-11-20 05:00:00	ES	Futures	1842.35	1843.13	1838.74	1839.52	29693.0
2013-11-20 06:00:00	ES	Futures	1839.52	1841.32	1838.74	1841.06	30610.0
2013-11-20 07:00:00	ES	Futures	1841.06	1842.1	1840.55	1840.81	31819.0
2013-11-20 08:00:00	ES	Futures	1840.81	1846.22	1840.55	1846.22	54729.0
2013-11-20 09:00:00	ES	Futures	1845.96	1847.25	1842.61	1845.19	227776.0
2013-11-20 10:00:00	ES	Futures	1845.45	1851.38	1842.61	1847.25	395467.0
2013-11-20 11:00:00	ES	Futures	1847.25	1848.03	1844.93	1846.48	146643.0
2013-11-20 12:00:00	ES	Futures	1846.22	1848.03	1844.93	1844.93	83504.0
2013-11-20 13:00:00	ES	Futures	1844.93	1846.74	1844.16	1845.45	78392.0
2013-11-20 14:00:00	ES	Futures	1845.71	1845.96	1835.13	1837.45	463681.0
2013-11-20 15:00:00	ES	Futures	1837.45	1837.45	1831.0	1835.9	342130.0
2013-11-20 16:00:00	ES	Futures	1836.16	1837.71	1835.65	1836.94	91297.0
2013-11-20 17:00:00	ES	Futures	1837.19	1837.19	1836.42	1836.42	2261.0
2013-11-20 18:00:00	ES	Futures	1836.16	1837.19	1835.39	1836.94	6083.0
2013-11-20 19:00:00	ES	Futures	1836.68	1837.19	1835.13	1836.68	7308.0
2013-11-20 20:00:00	ES	Futures	1836.42	1837.45	1834.87	1835.65	6718.0
2013-11-20 21:00:00	ES	Futures	1835.65	1835.9	1834.36	1834.61	4325.0
2013-11-20 22:00:00	ES	Futures	1834.87	1835.65	1834.61	1834.87	3314.0
2013-11-20 23:00:00	ES	Futures	1834.87	1835.39	1832.81	1832.81	5162.0
2013-11-20 00:00:00	NQ	Futures	3925.2	3925.49	3922.58	3922.58	428.0
2013-11-20 01:00:00	NQ	Futures	3922.29	3923.16	3919.97	3921.42	526.0
2013-11-20 02:00:00	NQ	Futures	3921.13	3925.49	3921.13	3923.45	595.0
2013-11-20 03:00:00	NQ	Futures	3923.45	3928.97	3919.97	3926.65	3125.0
2013-11-20 04:00:00	NQ	Futures	3926.65	3926.65	3922.58	3924.03	1669.0
2013-11-20 05:00:00	NQ	Futures	3923.45	3925.2	3915.9	3917.64	2721.0
2013-11-20 06:00:00	NQ	Futures	3917.35	3924.61	3915.9	3923.74	3036.0
2013-11-20 07:00:00	NQ	Futures	3923.74	3926.36	3922.29	3923.16	2291.0
2013-11-20 08:00:00	NQ	Futures	3923.16	3935.36	3922.58	3935.07	6785.0
2013-11-20 09:00:00	NQ	Futures	3935.07	3943.2	3925.78	3932.46	35377.0
2013-11-20 10:00:00	NQ	Futures	3932.46	3948.14	3926.07	3940.01	53801.0
2013-11-20 11:00:00	NQ	Futures	3940.01	3943.49	3933.91	3938.56	20476.0
2013-11-20 12:00:00	NQ	Futures	3938.56	3943.49	3933.62	3933.91	18397.0
2013-11-20 13:00:00	NQ	Futures	3933.91	3938.26	3930.71	3935.65	15478.0
2013-11-20 14:00:00	NQ	Futures	3935.65	3937.39	3911.25	3916.48	65025.0
2013-11-20 15:00:00	NQ	Futures	3916.48	3917.06	3901.67	3911.55	48855.0
2013-11-20 16:00:00	NQ	Futures	3911.55	3915.03	3910.38	3912.71	6025.0
2013-11-20 17:00:00	NQ	Futures	3912.71	3913.58	3912.42	3913.0	149.0
2013-11-20 18:00:00	NQ	Futures	3912.42	3913.58	3909.51	3913.58	509.0
2013-11-20 19:00:00	NQ	Futures	3913.0	3914.16	3909.8	3912.71	600.0
2013-11-20 20:00:00	NQ	Futures	3912.71	3913.87	3909.51	3910.96	928.0
2013-11-20 21:00:00	NQ	Futures	3910.96	3911.25	3908.35	3908.64	623.0
2013-11-20 22:00:00	NQ	Futures	3909.22	3910.38	3908.64	3909.51	412.0
2013-11-20 23:00:00	NQ	Futures	3909.8	3909.8	3905.74	3906.03	573.0
2013-11-20 00:00:00	YM	Futures	16279.7	16280.7	16268.5	16269.5	635.0
2013-11-20 01:00:00	YM	Futures	16269.5	16276.6	16263.4	16270.5	674.0

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

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