PREVIEW / futures_1hour / 2013-09-05

all futures 1-hour files

  file:    by_date/futures_1hour/2013/2013-09-05.parquet
  size:    48 KB
  rows:    1,485

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-09-05 00:00:00	ES	Futures	1710.2	1711.75	1709.94	1711.49	2556.0
2013-09-05 01:00:00	ES	Futures	1711.49	1712.01	1709.94	1710.46	4454.0
2013-09-05 02:00:00	ES	Futures	1710.46	1710.72	1708.39	1708.65	6990.0
2013-09-05 03:00:00	ES	Futures	1708.65	1712.79	1708.13	1711.75	23609.0
2013-09-05 04:00:00	ES	Futures	1711.49	1712.27	1707.1	1709.17	33163.0
2013-09-05 05:00:00	ES	Futures	1708.91	1709.68	1706.58	1707.88	16432.0
2013-09-05 06:00:00	ES	Futures	1707.62	1710.72	1707.36	1709.68	18943.0
2013-09-05 07:00:00	ES	Futures	1709.68	1710.46	1708.13	1709.17	16490.0
2013-09-05 08:00:00	ES	Futures	1709.17	1712.27	1708.65	1710.2	44913.0
2013-09-05 09:00:00	ES	Futures	1710.2	1714.6	1707.36	1713.56	210595.0
2013-09-05 10:00:00	ES	Futures	1713.56	1714.34	1708.65	1709.17	235224.0
2013-09-05 11:00:00	ES	Futures	1709.17	1712.53	1708.91	1712.01	157592.0
2013-09-05 12:00:00	ES	Futures	1711.75	1712.27	1709.94	1710.72	86069.0
2013-09-05 13:00:00	ES	Futures	1710.72	1712.53	1709.43	1710.2	89305.0
2013-09-05 14:00:00	ES	Futures	1710.2	1713.05	1709.68	1712.27	80945.0
2013-09-05 15:00:00	ES	Futures	1712.27	1712.27	1708.91	1709.43	126971.0
2013-09-05 16:00:00	ES	Futures	1709.43	1709.68	1708.13	1708.39	63512.0
2013-09-05 17:00:00	ES	Futures	1708.65	1708.91	1707.88	1708.13	1755.0
2013-09-05 18:00:00	ES	Futures	1708.13	1710.2	1708.13	1709.68	2632.0
2013-09-05 19:00:00	ES	Futures	1709.68	1710.2	1709.17	1709.94	1019.0
2013-09-05 20:00:00	ES	Futures	1710.2	1710.2	1704.51	1705.03	9511.0
2013-09-05 21:00:00	ES	Futures	1705.03	1706.32	1704.51	1706.07	8410.0
2013-09-05 22:00:00	ES	Futures	1705.81	1707.36	1705.55	1707.36	2512.0
2013-09-05 23:00:00	ES	Futures	1707.36	1707.88	1707.1	1707.88	2550.0
2013-09-05 00:00:00	NQ	Futures	3659.09	3661.72	3658.79	3661.72	238.0
2013-09-05 01:00:00	NQ	Futures	3661.72	3663.47	3659.67	3660.84	724.0
2013-09-05 02:00:00	NQ	Futures	3660.84	3662.01	3656.75	3657.33	928.0
2013-09-05 03:00:00	NQ	Futures	3657.33	3664.64	3655.58	3662.3	2902.0
2013-09-05 04:00:00	NQ	Futures	3662.88	3663.47	3652.95	3657.62	3678.0
2013-09-05 05:00:00	NQ	Futures	3657.62	3659.38	3652.95	3655.87	2033.0
2013-09-05 06:00:00	NQ	Futures	3655.87	3662.01	3654.12	3659.38	2481.0
2013-09-05 07:00:00	NQ	Futures	3659.67	3660.84	3655.87	3658.79	1917.0
2013-09-05 08:00:00	NQ	Futures	3658.5	3665.22	3656.46	3657.92	6105.0
2013-09-05 09:00:00	NQ	Futures	3658.21	3667.85	3651.78	3662.88	27761.0
2013-09-05 10:00:00	NQ	Futures	3662.59	3665.51	3652.66	3653.82	28311.0
2013-09-05 11:00:00	NQ	Futures	3653.82	3662.59	3653.24	3660.84	19013.0
2013-09-05 12:00:00	NQ	Futures	3661.13	3661.72	3653.24	3655.87	12801.0
2013-09-05 13:00:00	NQ	Futures	3655.58	3660.55	3653.53	3656.16	10281.0
2013-09-05 14:00:00	NQ	Futures	3655.87	3664.64	3654.7	3663.76	12329.0
2013-09-05 15:00:00	NQ	Futures	3663.47	3664.05	3655.87	3658.5	14547.0
2013-09-05 16:00:00	NQ	Futures	3658.5	3659.67	3656.46	3657.62	4570.0
2013-09-05 17:00:00	NQ	Futures	3657.33	3658.21	3656.46	3657.92	99.0
2013-09-05 18:00:00	NQ	Futures	3657.04	3659.38	3656.75	3659.38	191.0
2013-09-05 19:00:00	NQ	Futures	3659.67	3659.67	3657.62	3659.38	105.0
2013-09-05 20:00:00	NQ	Futures	3659.38	3659.38	3648.56	3649.44	990.0
2013-09-05 21:00:00	NQ	Futures	3649.44	3652.36	3647.69	3651.49	986.0
2013-09-05 22:00:00	NQ	Futures	3651.49	3654.12	3650.32	3653.82	373.0
2013-09-05 23:00:00	NQ	Futures	3653.82	3655.29	3653.24	3654.99	283.0
2013-09-05 00:00:00	YM	Futures	15166.2	15179.4	15165.1	15179.4	282.0
2013-09-05 01:00:00	YM	Futures	15178.3	15183.4	15164.1	15168.2	441.0

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

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