PREVIEW / futures_1hour / 2013-05-16

all futures 1-hour files

  file:    by_date/futures_1hour/2013/2013-05-16.parquet
  size:    50 KB
  rows:    1,537

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-05-16 00:00:00	ES	Futures	1703.66	1703.66	1703.15	1703.41	1458.0
2013-05-16 01:00:00	ES	Futures	1703.66	1703.92	1702.63	1703.15	4043.0
2013-05-16 02:00:00	ES	Futures	1703.15	1703.92	1702.37	1702.89	7573.0
2013-05-16 03:00:00	ES	Futures	1702.89	1703.66	1700.06	1701.6	22036.0
2013-05-16 04:00:00	ES	Futures	1701.86	1703.92	1700.83	1702.89	17286.0
2013-05-16 05:00:00	ES	Futures	1703.15	1704.44	1701.86	1702.12	11495.0
2013-05-16 06:00:00	ES	Futures	1702.12	1704.69	1702.12	1704.44	14911.0
2013-05-16 07:00:00	ES	Futures	1704.44	1705.98	1703.66	1705.98	20939.0
2013-05-16 08:00:00	ES	Futures	1705.98	1707.01	1700.83	1702.89	75754.0
2013-05-16 09:00:00	ES	Futures	1703.15	1708.3	1701.6	1706.75	255753.0
2013-05-16 10:00:00	ES	Futures	1707.01	1707.27	1700.83	1704.95	409933.0
2013-05-16 11:00:00	ES	Futures	1704.95	1709.07	1704.69	1707.01	197366.0
2013-05-16 12:00:00	ES	Futures	1707.27	1707.53	1704.95	1706.5	121938.0
2013-05-16 13:00:00	ES	Futures	1706.5	1706.5	1704.69	1705.21	87894.0
2013-05-16 14:00:00	ES	Futures	1705.21	1708.3	1702.63	1702.63	167336.0
2013-05-16 15:00:00	ES	Futures	1702.89	1703.92	1695.94	1698.25	378002.0
2013-05-16 16:00:00	ES	Futures	1698.51	1700.31	1697.48	1699.54	93572.0
2013-05-16 17:00:00	ES	Futures	1699.54	1700.31	1699.28	1699.28	1979.0
2013-05-16 18:00:00	ES	Futures	1699.54	1699.8	1698.25	1699.8	4241.0
2013-05-16 19:00:00	ES	Futures	1699.8	1700.31	1699.03	1699.8	1667.0
2013-05-16 20:00:00	ES	Futures	1700.06	1701.09	1699.28	1700.31	4556.0
2013-05-16 21:00:00	ES	Futures	1700.31	1700.83	1700.06	1700.31	2690.0
2013-05-16 22:00:00	ES	Futures	1700.57	1701.86	1700.06	1701.34	3311.0
2013-05-16 23:00:00	ES	Futures	1701.6	1701.86	1700.57	1700.83	1845.0
2013-05-16 00:00:00	NQ	Futures	3504.97	3504.97	3503.81	3504.68	133.0
2013-05-16 01:00:00	NQ	Futures	3504.68	3504.97	3502.64	3504.1	289.0
2013-05-16 02:00:00	NQ	Futures	3503.52	3505.56	3501.77	3502.64	628.0
2013-05-16 03:00:00	NQ	Futures	3502.93	3504.1	3496.22	3498.27	3789.0
2013-05-16 04:00:00	NQ	Futures	3498.27	3501.18	3495.35	3499.43	2264.0
2013-05-16 05:00:00	NQ	Futures	3499.43	3503.52	3498.27	3498.27	1662.0
2013-05-16 06:00:00	NQ	Futures	3498.27	3503.81	3498.27	3503.52	2068.0
2013-05-16 07:00:00	NQ	Futures	3503.81	3509.64	3502.64	3509.64	4160.0
2013-05-16 08:00:00	NQ	Futures	3509.64	3512.27	3503.22	3507.6	8471.0
2013-05-16 09:00:00	NQ	Futures	3507.6	3516.93	3503.81	3514.02	32595.0
2013-05-16 10:00:00	NQ	Futures	3514.31	3514.89	3501.47	3508.18	40641.0
2013-05-16 11:00:00	NQ	Futures	3508.18	3518.97	3508.18	3515.77	19241.0
2013-05-16 12:00:00	NQ	Futures	3515.47	3515.77	3507.6	3511.39	13618.0
2013-05-16 13:00:00	NQ	Futures	3511.1	3513.43	3508.77	3510.52	10132.0
2013-05-16 14:00:00	NQ	Futures	3510.81	3522.18	3507.89	3507.89	20513.0
2013-05-16 15:00:00	NQ	Futures	3507.89	3511.39	3495.64	3497.68	33212.0
2013-05-16 16:00:00	NQ	Futures	3497.97	3502.93	3496.52	3501.77	5545.0
2013-05-16 17:00:00	NQ	Futures	3501.18	3502.35	3500.6	3501.47	78.0
2013-05-16 18:00:00	NQ	Futures	3501.18	3501.18	3497.68	3500.31	414.0
2013-05-16 19:00:00	NQ	Futures	3500.31	3502.06	3500.31	3501.77	160.0
2013-05-16 20:00:00	NQ	Futures	3501.77	3504.39	3500.89	3502.93	423.0
2013-05-16 21:00:00	NQ	Futures	3503.22	3503.81	3502.06	3502.64	402.0
2013-05-16 22:00:00	NQ	Futures	3502.35	3504.68	3502.06	3503.52	357.0
2013-05-16 23:00:00	NQ	Futures	3504.1	3504.68	3502.06	3502.35	196.0
2013-05-16 00:00:00	YM	Futures	15393.7	15395.7	15389.6	15394.7	283.0
2013-05-16 01:00:00	YM	Futures	15395.7	15398.7	15387.6	15392.6	384.0

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

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