PREVIEW / futures_1hour / 2013-11-28

all futures 1-hour files

  file:    by_date/futures_1hour/2013/2013-11-28.parquet
  size:    32 KB
  rows:    977

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-28 00:00:00	ES	Futures	1863.51	1864.28	1863.25	1864.02	903.0
2013-11-28 01:00:00	ES	Futures	1864.28	1864.54	1863.51	1863.51	1521.0
2013-11-28 02:00:00	ES	Futures	1863.76	1863.76	1862.73	1862.73	3098.0
2013-11-28 03:00:00	ES	Futures	1862.73	1864.28	1862.73	1864.02	4944.0
2013-11-28 04:00:00	ES	Futures	1864.02	1867.38	1863.25	1866.6	24480.0
2013-11-28 05:00:00	ES	Futures	1866.86	1867.38	1866.34	1866.34	16018.0
2013-11-28 06:00:00	ES	Futures	1866.34	1866.86	1865.83	1866.6	10867.0
2013-11-28 07:00:00	ES	Futures	1866.6	1866.6	1865.83	1866.09	15577.0
2013-11-28 08:00:00	ES	Futures	1866.09	1867.63	1866.09	1867.12	4090.0
2013-11-28 09:00:00	ES	Futures	1867.12	1867.38	1865.83	1866.09	6088.0
2013-11-28 10:00:00	ES	Futures	1866.09	1866.86	1866.09	1866.34	3224.0
2013-11-28 11:00:00	ES	Futures	1866.09	1866.6	1865.83	1866.09	2961.0
2013-11-28 18:00:00	ES	Futures	1866.09	1866.09	1864.8	1865.05	1725.0
2013-11-28 19:00:00	ES	Futures	1865.31	1865.57	1865.05	1865.31	1176.0
2013-11-28 20:00:00	ES	Futures	1865.31	1866.09	1864.8	1866.09	2108.0
2013-11-28 21:00:00	ES	Futures	1866.09	1866.34	1865.31	1865.83	1430.0
2013-11-28 22:00:00	ES	Futures	1865.83	1866.09	1865.57	1866.09	618.0
2013-11-28 23:00:00	ES	Futures	1865.83	1865.83	1863.76	1864.02	4325.0
2013-11-28 00:00:00	NQ	Futures	4036.14	4039.34	4036.14	4039.34	526.0
2013-11-28 01:00:00	NQ	Futures	4039.63	4041.66	4038.17	4038.46	698.0
2013-11-28 02:00:00	NQ	Futures	4038.46	4038.75	4036.72	4037.01	324.0
2013-11-28 03:00:00	NQ	Futures	4037.3	4040.21	4037.01	4039.92	2038.0
2013-11-28 04:00:00	NQ	Futures	4040.21	4046.02	4039.04	4043.98	1877.0
2013-11-28 05:00:00	NQ	Futures	4044.27	4045.14	4042.82	4043.69	1278.0
2013-11-28 06:00:00	NQ	Futures	4043.4	4046.31	4043.11	4044.27	780.0
2013-11-28 07:00:00	NQ	Futures	4044.85	4044.85	4043.11	4043.69	454.0
2013-11-28 08:00:00	NQ	Futures	4043.4	4048.05	4043.4	4047.18	563.0
2013-11-28 09:00:00	NQ	Futures	4047.47	4047.76	4044.56	4044.85	1228.0
2013-11-28 10:00:00	NQ	Futures	4045.14	4047.47	4044.85	4045.72	1088.0
2013-11-28 11:00:00	NQ	Futures	4046.02	4047.18	4045.72	4046.02	545.0
2013-11-28 18:00:00	NQ	Futures	4045.72	4045.72	4043.98	4044.56	221.0
2013-11-28 19:00:00	NQ	Futures	4044.27	4045.72	4043.98	4045.43	189.0
2013-11-28 20:00:00	NQ	Futures	4045.72	4046.6	4044.56	4046.31	455.0
2013-11-28 21:00:00	NQ	Futures	4046.31	4047.76	4044.85	4046.89	456.0
2013-11-28 22:00:00	NQ	Futures	4046.6	4047.47	4046.31	4047.18	225.0
2013-11-28 23:00:00	NQ	Futures	4046.89	4047.18	4044.27	4044.27	691.0
2013-11-28 00:00:00	YM	Futures	16442.1	16446.2	16441.1	16446.2	175.0
2013-11-28 01:00:00	YM	Futures	16447.2	16448.2	16440.0	16441.1	283.0
2013-11-28 02:00:00	YM	Futures	16441.1	16443.1	16436.0	16436.0	382.0
2013-11-28 03:00:00	YM	Futures	16437.0	16446.2	16434.9	16443.1	1598.0
2013-11-28 04:00:00	YM	Futures	16443.1	16477.8	16441.1	16467.6	2291.0
2013-11-28 05:00:00	YM	Futures	16466.6	16472.7	16461.5	16462.5	1336.0
2013-11-28 06:00:00	YM	Futures	16461.5	16469.7	16460.5	16462.5	801.0
2013-11-28 07:00:00	YM	Futures	16463.5	16463.5	16458.4	16460.5	531.0
2013-11-28 08:00:00	YM	Futures	16461.5	16470.7	16461.5	16468.6	333.0
2013-11-28 09:00:00	YM	Futures	16468.6	16470.7	16458.4	16460.5	560.0
2013-11-28 10:00:00	YM	Futures	16462.5	16464.5	16458.4	16459.4	578.0
2013-11-28 11:00:00	YM	Futures	16460.5	16465.6	16457.4	16461.5	297.0
2013-11-28 18:00:00	YM	Futures	16457.4	16466.6	16452.3	16452.3	204.0
2013-11-28 19:00:00	YM	Futures	16453.3	16457.4	16450.2	16457.4	137.0

> showing 50 of 977 rows — these rows as CSV

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