PREVIEW / futures_1hour / 2013-05-27

all futures 1-hour files

  file:    by_date/futures_1hour/2013/2013-05-27.parquet
  size:    33 KB
  rows:    948

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-27 00:00:00	ES	Futures	1702.12	1703.41	1701.09	1703.15	2506.0
2013-05-27 01:00:00	ES	Futures	1703.15	1703.41	1702.12	1702.37	3016.0
2013-05-27 02:00:00	ES	Futures	1702.37	1702.63	1699.54	1700.06	5575.0
2013-05-27 03:00:00	ES	Futures	1700.06	1703.41	1699.8	1701.6	12450.0
2013-05-27 04:00:00	ES	Futures	1701.34	1701.86	1699.28	1700.31	6316.0
2013-05-27 05:00:00	ES	Futures	1700.31	1700.57	1694.13	1694.9	10494.0
2013-05-27 06:00:00	ES	Futures	1694.9	1697.22	1694.65	1696.97	5386.0
2013-05-27 07:00:00	ES	Futures	1696.97	1699.28	1696.71	1698.77	5352.0
2013-05-27 08:00:00	ES	Futures	1698.51	1699.54	1697.74	1699.03	3701.0
2013-05-27 09:00:00	ES	Futures	1699.03	1700.06	1698.51	1699.8	5683.0
2013-05-27 10:00:00	ES	Futures	1699.8	1702.63	1698.77	1702.12	14188.0
2013-05-27 11:00:00	ES	Futures	1702.12	1704.18	1701.86	1702.63	8436.0
2013-05-27 18:00:00	ES	Futures	1702.37	1702.89	1701.34	1702.89	3134.0
2013-05-27 19:00:00	ES	Futures	1702.89	1703.15	1701.6	1702.63	1407.0
2013-05-27 20:00:00	ES	Futures	1702.63	1707.01	1702.12	1705.98	15474.0
2013-05-27 21:00:00	ES	Futures	1705.72	1708.04	1705.72	1706.24	10967.0
2013-05-27 22:00:00	ES	Futures	1706.24	1707.01	1704.69	1704.95	5832.0
2013-05-27 23:00:00	ES	Futures	1705.21	1707.27	1704.69	1706.75	5878.0
2013-05-27 00:00:00	NQ	Futures	3496.22	3498.85	3494.77	3497.97	287.0
2013-05-27 01:00:00	NQ	Futures	3497.97	3499.14	3496.22	3496.81	375.0
2013-05-27 02:00:00	NQ	Futures	3496.52	3496.81	3490.97	3491.56	355.0
2013-05-27 03:00:00	NQ	Futures	3491.56	3499.43	3490.97	3494.18	1333.0
2013-05-27 04:00:00	NQ	Futures	3494.47	3494.77	3489.52	3492.72	664.0
2013-05-27 05:00:00	NQ	Futures	3492.72	3492.72	3482.52	3483.39	1013.0
2013-05-27 06:00:00	NQ	Futures	3483.1	3488.35	3482.81	3488.35	389.0
2013-05-27 07:00:00	NQ	Futures	3488.06	3491.85	3488.06	3491.27	329.0
2013-05-27 08:00:00	NQ	Futures	3491.27	3493.02	3490.39	3492.72	266.0
2013-05-27 09:00:00	NQ	Futures	3492.43	3496.22	3490.97	3495.06	1127.0
2013-05-27 10:00:00	NQ	Futures	3495.35	3501.77	3494.47	3499.72	1300.0
2013-05-27 11:00:00	NQ	Futures	3499.72	3503.22	3498.56	3500.31	573.0
2013-05-27 18:00:00	NQ	Futures	3500.31	3500.89	3497.97	3500.6	169.0
2013-05-27 19:00:00	NQ	Futures	3500.31	3501.18	3498.27	3499.72	146.0
2013-05-27 20:00:00	NQ	Futures	3500.02	3507.89	3499.72	3505.56	1626.0
2013-05-27 21:00:00	NQ	Futures	3505.56	3511.1	3505.56	3507.6	2229.0
2013-05-27 22:00:00	NQ	Futures	3507.89	3509.64	3505.85	3506.14	540.0
2013-05-27 23:00:00	NQ	Futures	3506.14	3509.64	3506.14	3508.77	518.0
2013-05-27 00:00:00	YM	Futures	15486.7	15495.8	15481.6	15491.7	302.0
2013-05-27 01:00:00	YM	Futures	15493.7	15495.8	15484.6	15488.7	450.0
2013-05-27 02:00:00	YM	Futures	15486.7	15488.7	15468.5	15469.5	514.0
2013-05-27 03:00:00	YM	Futures	15470.5	15495.8	15469.5	15482.6	817.0
2013-05-27 04:00:00	YM	Futures	15480.6	15488.7	15469.5	15475.5	422.0
2013-05-27 05:00:00	YM	Futures	15474.5	15476.6	15437.1	15439.2	787.0
2013-05-27 06:00:00	YM	Futures	15439.2	15456.3	15437.1	15452.3	486.0
2013-05-27 07:00:00	YM	Futures	15453.3	15466.4	15452.3	15464.4	346.0
2013-05-27 08:00:00	YM	Futures	15464.4	15466.4	15457.4	15465.4	226.0
2013-05-27 09:00:00	YM	Futures	15466.4	15469.5	15459.4	15465.4	544.0
2013-05-27 10:00:00	YM	Futures	15465.4	15493.7	15460.4	15491.7	646.0
2013-05-27 11:00:00	YM	Futures	15490.7	15502.8	15487.7	15491.7	335.0
2013-05-27 18:00:00	YM	Futures	15494.8	15497.8	15483.6	15491.7	183.0
2013-05-27 19:00:00	YM	Futures	15492.7	15494.8	15480.6	15489.7	450.0

> showing 50 of 948 rows — these rows as CSV

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