PREVIEW / futures_1hour / 2013-12-04

all futures 1-hour files

  file:    by_date/futures_1hour/2013/2013-12-04.parquet
  size:    50 KB
  rows:    1,550

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-12-04 00:00:00	ES	Futures	1849.83	1850.09	1849.06	1849.06	4801.0
2013-12-04 01:00:00	ES	Futures	1849.06	1850.61	1848.54	1850.35	3694.0
2013-12-04 02:00:00	ES	Futures	1850.35	1852.41	1850.09	1851.9	12729.0
2013-12-04 03:00:00	ES	Futures	1851.9	1851.9	1850.09	1851.12	18120.0
2013-12-04 04:00:00	ES	Futures	1851.12	1852.93	1850.87	1851.12	13168.0
2013-12-04 05:00:00	ES	Futures	1851.38	1851.64	1848.54	1849.32	18505.0
2013-12-04 06:00:00	ES	Futures	1849.32	1850.35	1848.29	1848.8	19848.0
2013-12-04 07:00:00	ES	Futures	1848.54	1849.32	1844.93	1845.45	44355.0
2013-12-04 08:00:00	ES	Futures	1845.45	1846.22	1841.84	1844.42	94406.0
2013-12-04 09:00:00	ES	Futures	1844.67	1845.96	1841.32	1844.67	228217.0
2013-12-04 10:00:00	ES	Futures	1844.67	1856.8	1844.42	1856.03	374947.0
2013-12-04 11:00:00	ES	Futures	1856.03	1856.03	1850.35	1851.38	173677.0
2013-12-04 12:00:00	ES	Futures	1851.38	1851.38	1844.16	1846.48	224054.0
2013-12-04 13:00:00	ES	Futures	1846.74	1848.54	1834.36	1838.74	311493.0
2013-12-04 14:00:00	ES	Futures	1838.74	1845.96	1838.48	1845.19	194131.0
2013-12-04 15:00:00	ES	Futures	1845.19	1852.93	1843.39	1848.54	239397.0
2013-12-04 16:00:00	ES	Futures	1848.29	1849.83	1847.77	1849.83	73393.0
2013-12-04 17:00:00	ES	Futures	1849.83	1850.09	1849.06	1849.32	3352.0
2013-12-04 18:00:00	ES	Futures	1849.58	1849.58	1848.8	1849.06	4408.0
2013-12-04 19:00:00	ES	Futures	1849.06	1849.83	1848.54	1849.32	3077.0
2013-12-04 20:00:00	ES	Futures	1849.06	1849.58	1848.29	1849.06	4272.0
2013-12-04 21:00:00	ES	Futures	1849.06	1849.83	1848.29	1848.29	2133.0
2013-12-04 22:00:00	ES	Futures	1848.29	1849.58	1848.29	1848.8	3237.0
2013-12-04 23:00:00	ES	Futures	1848.8	1849.32	1848.03	1848.54	2883.0
2013-12-04 00:00:00	NQ	Futures	4040.79	4041.37	4039.63	4039.63	870.0
2013-12-04 01:00:00	NQ	Futures	4039.34	4041.08	4038.17	4040.79	291.0
2013-12-04 02:00:00	NQ	Futures	4040.79	4045.14	4040.79	4043.69	1311.0
2013-12-04 03:00:00	NQ	Futures	4043.69	4046.02	4040.21	4045.43	3475.0
2013-12-04 04:00:00	NQ	Futures	4045.14	4048.92	4044.56	4048.63	3660.0
2013-12-04 05:00:00	NQ	Futures	4048.63	4048.63	4041.95	4043.4	2381.0
2013-12-04 06:00:00	NQ	Futures	4043.4	4046.02	4041.08	4042.24	1999.0
2013-12-04 07:00:00	NQ	Futures	4041.95	4043.4	4032.95	4034.11	3337.0
2013-12-04 08:00:00	NQ	Futures	4034.11	4035.56	4028.3	4030.62	11535.0
2013-12-04 09:00:00	NQ	Futures	4030.33	4037.59	4022.78	4034.98	34792.0
2013-12-04 10:00:00	NQ	Futures	4034.69	4059.08	4034.11	4058.79	49096.0
2013-12-04 11:00:00	NQ	Futures	4058.79	4058.79	4045.14	4046.6	22213.0
2013-12-04 12:00:00	NQ	Futures	4046.6	4046.6	4031.78	4038.75	31028.0
2013-12-04 13:00:00	NQ	Futures	4039.04	4043.69	4011.74	4021.33	46467.0
2013-12-04 14:00:00	NQ	Futures	4021.04	4038.75	4020.46	4036.43	25196.0
2013-12-04 15:00:00	NQ	Futures	4036.43	4055.6	4032.36	4046.31	35004.0
2013-12-04 16:00:00	NQ	Futures	4046.02	4047.47	4044.27	4047.18	4249.0
2013-12-04 17:00:00	NQ	Futures	4047.47	4047.47	4044.85	4046.31	192.0
2013-12-04 18:00:00	NQ	Futures	4045.72	4046.89	4043.98	4044.27	575.0
2013-12-04 19:00:00	NQ	Futures	4044.27	4046.02	4043.69	4044.85	581.0
2013-12-04 20:00:00	NQ	Futures	4044.56	4044.85	4041.95	4044.85	804.0
2013-12-04 21:00:00	NQ	Futures	4044.85	4046.31	4044.27	4044.27	326.0
2013-12-04 22:00:00	NQ	Futures	4044.27	4046.6	4044.27	4045.43	595.0
2013-12-04 23:00:00	NQ	Futures	4045.14	4046.02	4044.27	4045.14	481.0
2013-12-04 00:00:00	YM	Futures	16244.0	16245.0	16235.8	16237.8	431.0
2013-12-04 01:00:00	YM	Futures	16235.8	16246.0	16234.8	16245.0	434.0

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

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