PREVIEW / futures_1hour / 2013-12-16

all futures 1-hour files

  file:    by_date/futures_1hour/2013/2013-12-16.parquet
  size:    47 KB
  rows:    1,473

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-16 00:00:00	ES	Futures	1821.44	1822.21	1820.4	1820.66	2808.0
2013-12-16 01:00:00	ES	Futures	1820.4	1822.21	1819.88	1822.21	3624.0
2013-12-16 02:00:00	ES	Futures	1821.95	1824.8	1821.69	1823.76	8859.0
2013-12-16 03:00:00	ES	Futures	1824.02	1828.42	1823.25	1828.16	22095.0
2013-12-16 04:00:00	ES	Futures	1827.9	1832.82	1827.9	1831.78	17201.0
2013-12-16 05:00:00	ES	Futures	1831.78	1837.99	1831.52	1837.73	26144.0
2013-12-16 06:00:00	ES	Futures	1837.73	1840.06	1836.7	1837.47	17420.0
2013-12-16 07:00:00	ES	Futures	1837.47	1841.09	1837.21	1840.06	14752.0
2013-12-16 08:00:00	ES	Futures	1840.32	1841.09	1839.02	1839.54	24641.0
2013-12-16 09:00:00	ES	Futures	1839.8	1847.82	1838.51	1846.78	260292.0
2013-12-16 10:00:00	ES	Futures	1846.78	1848.08	1842.13	1843.16	159206.0
2013-12-16 11:00:00	ES	Futures	1843.16	1844.2	1841.09	1843.68	135957.0
2013-12-16 12:00:00	ES	Futures	1843.94	1843.94	1840.84	1841.61	81845.0
2013-12-16 13:00:00	ES	Futures	1841.87	1843.94	1839.28	1843.42	103317.0
2013-12-16 14:00:00	ES	Futures	1843.42	1845.49	1842.65	1844.2	70629.0
2013-12-16 15:00:00	ES	Futures	1843.94	1844.72	1841.61	1841.61	143290.0
2013-12-16 16:00:00	ES	Futures	1841.61	1842.13	1840.32	1840.58	82480.0
2013-12-16 17:00:00	ES	Futures	1840.58	1840.84	1840.06	1840.58	2060.0
2013-12-16 18:00:00	ES	Futures	1839.8	1840.84	1839.8	1840.58	2677.0
2013-12-16 19:00:00	ES	Futures	1840.32	1840.58	1839.28	1839.54	2114.0
2013-12-16 20:00:00	ES	Futures	1839.54	1840.58	1839.28	1840.32	1851.0
2013-12-16 21:00:00	ES	Futures	1840.32	1840.58	1839.8	1840.58	697.0
2013-12-16 22:00:00	ES	Futures	1840.32	1841.09	1840.06	1840.06	2080.0
2013-12-16 23:00:00	ES	Futures	1840.32	1841.61	1840.06	1841.35	1434.0
2013-12-16 00:00:00	NQ	Futures	3997.79	4000.69	3996.62	3997.21	767.0
2013-12-16 01:00:00	NQ	Futures	3996.92	4000.69	3996.04	4000.11	371.0
2013-12-16 02:00:00	NQ	Futures	4000.69	4006.22	3999.24	4005.34	872.0
2013-12-16 03:00:00	NQ	Futures	4005.34	4013.77	4005.34	4013.19	2516.0
2013-12-16 04:00:00	NQ	Futures	4012.9	4023.37	4012.9	4021.91	2711.0
2013-12-16 05:00:00	NQ	Futures	4021.91	4034.7	4021.33	4034.41	3150.0
2013-12-16 06:00:00	NQ	Futures	4034.41	4036.45	4031.22	4032.67	1921.0
2013-12-16 07:00:00	NQ	Futures	4032.67	4038.19	4032.38	4036.45	1535.0
2013-12-16 08:00:00	NQ	Futures	4036.74	4037.03	4031.8	4035.58	2321.0
2013-12-16 09:00:00	NQ	Futures	4035.58	4058.25	4031.8	4056.51	45062.0
2013-12-16 10:00:00	NQ	Futures	4056.8	4059.41	4043.72	4045.75	27949.0
2013-12-16 11:00:00	NQ	Futures	4045.46	4047.49	4038.77	4043.42	18730.0
2013-12-16 12:00:00	NQ	Futures	4043.42	4044.01	4036.45	4038.77	12868.0
2013-12-16 13:00:00	NQ	Futures	4038.77	4040.81	4030.34	4039.36	16243.0
2013-12-16 14:00:00	NQ	Futures	4039.36	4042.84	4037.61	4041.1	12720.0
2013-12-16 15:00:00	NQ	Futures	4041.1	4042.55	4032.96	4034.99	42024.0
2013-12-16 16:00:00	NQ	Futures	4035.29	4035.87	4031.8	4032.38	6048.0
2013-12-16 17:00:00	NQ	Futures	4032.38	4032.96	4031.51	4032.67	141.0
2013-12-16 18:00:00	NQ	Futures	4031.22	4032.96	4030.63	4031.22	331.0
2013-12-16 19:00:00	NQ	Futures	4031.51	4031.8	4030.34	4030.63	264.0
2013-12-16 20:00:00	NQ	Futures	4030.63	4032.09	4030.34	4031.22	500.0
2013-12-16 21:00:00	NQ	Futures	4031.22	4032.38	4030.34	4032.38	108.0
2013-12-16 22:00:00	NQ	Futures	4032.38	4033.25	4030.93	4030.93	250.0
2013-12-16 23:00:00	NQ	Futures	4030.93	4034.99	4030.93	4034.41	112.0
2013-12-16 00:00:00	YM	Futures	16036.3	16045.5	16029.1	16031.1	837.0
2013-12-16 01:00:00	YM	Futures	16030.1	16046.5	16028.1	16044.5	579.0

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

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