PREVIEW / futures_1hour / 2013-12-05

all futures 1-hour files

  file:    by_date/futures_1hour/2013/2013-12-05.parquet
  size:    49 KB
  rows:    1,533

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-05 00:00:00	ES	Futures	1848.29	1848.54	1846.48	1847.0	5584.0
2013-12-05 01:00:00	ES	Futures	1847.0	1847.77	1846.48	1846.74	2910.0
2013-12-05 02:00:00	ES	Futures	1846.48	1847.51	1845.71	1846.48	7322.0
2013-12-05 03:00:00	ES	Futures	1846.48	1848.29	1845.19	1848.29	19697.0
2013-12-05 04:00:00	ES	Futures	1848.29	1849.83	1848.03	1849.58	11912.0
2013-12-05 05:00:00	ES	Futures	1849.32	1849.83	1847.77	1848.03	5831.0
2013-12-05 06:00:00	ES	Futures	1847.77	1849.83	1847.25	1848.29	19169.0
2013-12-05 07:00:00	ES	Futures	1848.29	1850.09	1848.03	1849.32	24716.0
2013-12-05 08:00:00	ES	Futures	1849.06	1851.38	1845.96	1846.22	66065.0
2013-12-05 09:00:00	ES	Futures	1846.48	1847.51	1841.84	1845.19	265861.0
2013-12-05 10:00:00	ES	Futures	1845.19	1849.06	1840.81	1842.1	258923.0
2013-12-05 11:00:00	ES	Futures	1842.1	1844.67	1840.03	1844.16	197540.0
2013-12-05 12:00:00	ES	Futures	1844.16	1847.0	1843.9	1845.45	111885.0
2013-12-05 13:00:00	ES	Futures	1845.71	1845.96	1841.58	1842.87	80856.0
2013-12-05 14:00:00	ES	Futures	1842.61	1844.93	1839.0	1840.03	111327.0
2013-12-05 15:00:00	ES	Futures	1840.03	1844.67	1838.74	1841.32	256537.0
2013-12-05 16:00:00	ES	Futures	1841.06	1842.1	1839.77	1840.55	71588.0
2013-12-05 17:00:00	ES	Futures	1840.55	1840.55	1840.03	1840.55	2272.0
2013-12-05 18:00:00	ES	Futures	1841.32	1842.61	1841.06	1841.32	6643.0
2013-12-05 19:00:00	ES	Futures	1841.58	1843.39	1841.32	1842.87	4082.0
2013-12-05 20:00:00	ES	Futures	1842.61	1843.64	1842.35	1843.64	3489.0
2013-12-05 21:00:00	ES	Futures	1843.64	1843.9	1842.87	1842.87	2416.0
2013-12-05 22:00:00	ES	Futures	1843.13	1845.45	1842.61	1844.42	7272.0
2013-12-05 23:00:00	ES	Futures	1844.42	1845.19	1843.64	1844.67	2889.0
2013-12-05 00:00:00	NQ	Futures	4044.56	4045.14	4041.95	4042.53	551.0
2013-12-05 01:00:00	NQ	Futures	4042.53	4044.85	4042.24	4043.4	269.0
2013-12-05 02:00:00	NQ	Futures	4043.11	4044.56	4041.37	4043.11	1027.0
2013-12-05 03:00:00	NQ	Futures	4043.11	4047.18	4041.08	4047.18	3805.0
2013-12-05 04:00:00	NQ	Futures	4047.18	4053.28	4046.89	4052.99	3694.0
2013-12-05 05:00:00	NQ	Futures	4052.99	4053.28	4048.92	4049.79	1829.0
2013-12-05 06:00:00	NQ	Futures	4049.79	4053.86	4048.34	4050.37	3605.0
2013-12-05 07:00:00	NQ	Futures	4050.66	4054.44	4050.66	4050.95	3747.0
2013-12-05 08:00:00	NQ	Futures	4050.95	4056.76	4046.6	4048.63	9974.0
2013-12-05 09:00:00	NQ	Futures	4048.92	4053.86	4038.46	4046.31	40696.0
2013-12-05 10:00:00	NQ	Futures	4046.6	4052.4	4036.72	4039.63	50622.0
2013-12-05 11:00:00	NQ	Futures	4039.92	4043.69	4031.78	4037.59	34036.0
2013-12-05 12:00:00	NQ	Futures	4037.59	4049.5	4037.59	4046.02	18292.0
2013-12-05 13:00:00	NQ	Futures	4046.31	4046.89	4038.17	4041.08	13039.0
2013-12-05 14:00:00	NQ	Futures	4041.08	4045.72	4030.04	4031.78	18638.0
2013-12-05 15:00:00	NQ	Futures	4032.07	4050.37	4029.75	4041.66	36507.0
2013-12-05 16:00:00	NQ	Futures	4041.37	4042.82	4039.34	4039.63	4296.0
2013-12-05 17:00:00	NQ	Futures	4039.63	4039.92	4039.04	4039.63	75.0
2013-12-05 18:00:00	NQ	Futures	4040.5	4043.98	4039.34	4039.92	846.0
2013-12-05 19:00:00	NQ	Futures	4039.92	4043.69	4039.92	4043.11	627.0
2013-12-05 20:00:00	NQ	Futures	4043.11	4043.98	4041.37	4043.69	386.0
2013-12-05 21:00:00	NQ	Futures	4043.98	4044.27	4042.82	4043.11	321.0
2013-12-05 22:00:00	NQ	Futures	4042.24	4047.18	4041.95	4045.72	823.0
2013-12-05 23:00:00	NQ	Futures	4046.02	4047.18	4044.85	4046.31	306.0
2013-12-05 00:00:00	YM	Futures	16223.5	16223.5	16210.3	16212.3	750.0
2013-12-05 01:00:00	YM	Futures	16211.3	16218.4	16210.3	16211.3	313.0

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

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