PREVIEW / futures_1hour / 2013-12-17

all futures 1-hour files

  file:    by_date/futures_1hour/2013/2013-12-17.parquet
  size:    48 KB
  rows:    1,548

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-17 00:00:00	ES	Futures	1841.61	1842.13	1841.35	1841.87	1387.0
2013-12-17 01:00:00	ES	Futures	1842.13	1842.13	1841.35	1841.35	657.0
2013-12-17 02:00:00	ES	Futures	1841.61	1841.87	1840.06	1841.61	5133.0
2013-12-17 03:00:00	ES	Futures	1841.61	1841.87	1839.28	1841.09	10327.0
2013-12-17 04:00:00	ES	Futures	1841.09	1841.35	1839.02	1840.32	10022.0
2013-12-17 05:00:00	ES	Futures	1840.58	1841.61	1839.54	1841.35	8526.0
2013-12-17 06:00:00	ES	Futures	1841.09	1841.35	1840.32	1841.09	4767.0
2013-12-17 07:00:00	ES	Futures	1841.09	1843.42	1841.09	1842.9	18490.0
2013-12-17 08:00:00	ES	Futures	1842.9	1844.2	1841.61	1842.9	27594.0
2013-12-17 09:00:00	ES	Futures	1842.9	1843.94	1835.4	1839.28	201095.0
2013-12-17 10:00:00	ES	Futures	1839.28	1840.32	1832.82	1833.85	210137.0
2013-12-17 11:00:00	ES	Futures	1834.11	1834.63	1831.52	1834.11	156631.0
2013-12-17 12:00:00	ES	Futures	1834.11	1837.21	1833.08	1836.18	87672.0
2013-12-17 13:00:00	ES	Futures	1836.18	1837.47	1834.89	1836.18	69747.0
2013-12-17 14:00:00	ES	Futures	1836.18	1840.84	1835.92	1837.47	125814.0
2013-12-17 15:00:00	ES	Futures	1837.21	1839.54	1835.4	1835.4	185417.0
2013-12-17 16:00:00	ES	Futures	1835.66	1835.66	1832.82	1833.33	86529.0
2013-12-17 17:00:00	ES	Futures	1833.33	1833.85	1833.08	1833.08	1805.0
2013-12-17 18:00:00	ES	Futures	1833.33	1835.4	1833.33	1835.14	4589.0
2013-12-17 19:00:00	ES	Futures	1835.14	1837.99	1834.89	1836.7	8094.0
2013-12-17 20:00:00	ES	Futures	1836.7	1837.47	1834.89	1835.66	5116.0
2013-12-17 21:00:00	ES	Futures	1835.66	1837.47	1835.66	1837.47	2795.0
2013-12-17 22:00:00	ES	Futures	1837.47	1837.47	1836.7	1837.21	2350.0
2013-12-17 23:00:00	ES	Futures	1837.47	1837.73	1836.96	1837.21	2085.0
2013-12-17 00:00:00	NQ	Futures	4034.7	4036.16	4034.41	4036.16	203.0
2013-12-17 01:00:00	NQ	Futures	4036.16	4036.74	4035.58	4035.58	167.0
2013-12-17 02:00:00	NQ	Futures	4034.99	4035.58	4031.8	4034.99	457.0
2013-12-17 03:00:00	NQ	Futures	4034.99	4034.99	4028.6	4032.09	2660.0
2013-12-17 04:00:00	NQ	Futures	4032.09	4032.38	4027.44	4030.34	1512.0
2013-12-17 05:00:00	NQ	Futures	4030.63	4034.7	4028.89	4034.12	1459.0
2013-12-17 06:00:00	NQ	Futures	4033.83	4034.41	4031.51	4033.83	724.0
2013-12-17 07:00:00	NQ	Futures	4034.12	4039.36	4034.12	4037.03	1775.0
2013-12-17 08:00:00	NQ	Futures	4036.74	4039.94	4036.16	4036.45	2755.0
2013-12-17 09:00:00	NQ	Futures	4036.45	4037.03	4021.91	4029.76	33024.0
2013-12-17 10:00:00	NQ	Futures	4029.47	4035.87	4021.62	4023.66	30454.0
2013-12-17 11:00:00	NQ	Futures	4023.95	4028.02	4018.72	4025.98	23098.0
2013-12-17 12:00:00	NQ	Futures	4025.98	4035.87	4023.37	4033.25	13115.0
2013-12-17 13:00:00	NQ	Futures	4032.96	4037.32	4030.34	4032.67	13919.0
2013-12-17 14:00:00	NQ	Futures	4032.67	4045.17	4031.8	4036.16	21203.0
2013-12-17 15:00:00	NQ	Futures	4036.45	4040.81	4028.31	4028.31	23353.0
2013-12-17 16:00:00	NQ	Futures	4028.6	4028.6	4021.91	4022.5	5402.0
2013-12-17 17:00:00	NQ	Futures	4022.5	4023.37	4021.62	4022.79	200.0
2013-12-17 18:00:00	NQ	Futures	4022.79	4026.27	4022.79	4025.69	341.0
2013-12-17 19:00:00	NQ	Futures	4025.4	4029.47	4025.4	4028.31	813.0
2013-12-17 20:00:00	NQ	Futures	4028.31	4029.47	4024.82	4026.27	475.0
2013-12-17 21:00:00	NQ	Futures	4026.56	4029.76	4026.56	4029.47	291.0
2013-12-17 22:00:00	NQ	Futures	4029.47	4030.34	4028.6	4029.76	241.0
2013-12-17 23:00:00	NQ	Futures	4029.76	4031.22	4029.18	4029.47	261.0
2013-12-17 00:00:00	YM	Futures	16234.2	16240.3	16232.1	16237.3	251.0
2013-12-17 01:00:00	YM	Futures	16237.3	16241.4	16232.1	16232.1	331.0

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

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