PREVIEW / futures_1hour / 2013-11-29

all futures 1-hour files

  file:    by_date/futures_1hour/2013/2013-11-29.parquet
  size:    32 KB
  rows:    920

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-29 00:00:00	ES	Futures	1864.28	1864.8	1864.02	1864.8	1612.0
2013-11-29 01:00:00	ES	Futures	1864.8	1865.83	1864.54	1865.05	1477.0
2013-11-29 02:00:00	ES	Futures	1864.8	1865.83	1864.8	1865.57	1509.0
2013-11-29 03:00:00	ES	Futures	1865.31	1866.86	1864.8	1865.05	6724.0
2013-11-29 04:00:00	ES	Futures	1865.05	1866.34	1864.8	1865.83	7096.0
2013-11-29 05:00:00	ES	Futures	1865.83	1866.09	1865.05	1865.05	5218.0
2013-11-29 06:00:00	ES	Futures	1865.05	1866.09	1864.8	1865.83	5771.0
2013-11-29 07:00:00	ES	Futures	1865.83	1866.86	1865.31	1866.34	25221.0
2013-11-29 08:00:00	ES	Futures	1866.34	1866.6	1865.05	1865.57	15585.0
2013-11-29 09:00:00	ES	Futures	1865.57	1868.41	1864.54	1868.15	107337.0
2013-11-29 10:00:00	ES	Futures	1868.15	1870.21	1867.38	1868.92	114915.0
2013-11-29 11:00:00	ES	Futures	1868.92	1869.7	1867.63	1868.67	81586.0
2013-11-29 12:00:00	ES	Futures	1868.41	1869.18	1860.15	1861.44	227032.0
2013-11-29 13:00:00	ES	Futures	1861.44	1862.99	1860.41	1861.7	86158.0
2013-11-29 00:00:00	NQ	Futures	4044.85	4045.72	4043.98	4045.14	220.0
2013-11-29 01:00:00	NQ	Futures	4045.43	4046.6	4045.14	4045.14	129.0
2013-11-29 02:00:00	NQ	Futures	4044.85	4046.02	4044.85	4045.72	138.0
2013-11-29 03:00:00	NQ	Futures	4045.43	4047.47	4044.27	4044.27	1134.0
2013-11-29 04:00:00	NQ	Futures	4044.56	4049.5	4043.98	4048.05	1703.0
2013-11-29 05:00:00	NQ	Futures	4048.34	4049.21	4047.18	4047.76	819.0
2013-11-29 06:00:00	NQ	Futures	4047.76	4049.5	4047.47	4047.76	1096.0
2013-11-29 07:00:00	NQ	Futures	4047.76	4050.95	4047.47	4048.34	2166.0
2013-11-29 08:00:00	NQ	Futures	4048.34	4048.92	4043.4	4044.56	2064.0
2013-11-29 09:00:00	NQ	Futures	4044.85	4052.7	4043.4	4050.95	21325.0
2013-11-29 10:00:00	NQ	Futures	4050.95	4057.34	4048.05	4055.02	15412.0
2013-11-29 11:00:00	NQ	Futures	4055.31	4061.99	4053.28	4057.92	10971.0
2013-11-29 12:00:00	NQ	Futures	4057.92	4060.83	4048.34	4053.86	19222.0
2013-11-29 13:00:00	NQ	Futures	4053.57	4058.79	4052.4	4056.18	6058.0
2013-11-29 00:00:00	YM	Futures	16445.1	16451.3	16443.1	16450.2	168.0
2013-11-29 01:00:00	YM	Futures	16450.2	16459.4	16448.2	16453.3	186.0
2013-11-29 02:00:00	YM	Futures	16454.3	16459.4	16454.3	16457.4	136.0
2013-11-29 03:00:00	YM	Futures	16455.4	16468.6	16454.3	16454.3	1068.0
2013-11-29 04:00:00	YM	Futures	16454.3	16463.5	16451.3	16459.4	762.0
2013-11-29 05:00:00	YM	Futures	16459.4	16461.5	16456.4	16459.4	839.0
2013-11-29 06:00:00	YM	Futures	16458.4	16461.5	16454.3	16456.4	881.0
2013-11-29 07:00:00	YM	Futures	16456.4	16469.7	16454.3	16467.6	1948.0
2013-11-29 08:00:00	YM	Futures	16466.6	16466.6	16453.3	16456.4	1193.0
2013-11-29 09:00:00	YM	Futures	16455.4	16491.1	16444.1	16480.9	10428.0
2013-11-29 10:00:00	YM	Futures	16481.9	16505.4	16475.8	16483.9	11109.0
2013-11-29 11:00:00	YM	Futures	16483.9	16489.1	16470.7	16474.8	11061.0
2013-11-29 12:00:00	YM	Futures	16473.7	16482.9	16402.2	16408.4	13650.0
2013-11-29 13:00:00	YM	Futures	16410.4	16436.0	16405.3	16426.8	2976.0
2013-11-29 00:00:00	CL	Futures	145.72	145.73	145.57	145.67	310.0
2013-11-29 01:00:00	CL	Futures	145.65	145.73	145.57	145.68	277.0
2013-11-29 02:00:00	CL	Futures	145.7	145.76	145.6	145.7	535.0
2013-11-29 03:00:00	CL	Futures	145.68	146.39	145.67	146.19	3410.0
2013-11-29 04:00:00	CL	Futures	146.21	146.39	146.14	146.28	1559.0
2013-11-29 05:00:00	CL	Futures	146.28	146.41	146.17	146.3	1568.0
2013-11-29 06:00:00	CL	Futures	146.3	146.32	146.14	146.22	769.0
2013-11-29 07:00:00	CL	Futures	146.24	146.77	146.17	146.58	4373.0

> showing 50 of 920 rows — these rows as CSV

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