PREVIEW / futures_1hour / 2013-05-31

all futures 1-hour files

  file:    by_date/futures_1hour/2013/2013-05-31.parquet
  size:    44 KB
  rows:    1,256

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-31 00:00:00	ES	Futures	1704.44	1705.98	1703.66	1704.69	4106.0
2013-05-31 01:00:00	ES	Futures	1704.44	1705.21	1703.66	1703.92	5886.0
2013-05-31 02:00:00	ES	Futures	1703.92	1704.69	1702.63	1703.41	11109.0
2013-05-31 03:00:00	ES	Futures	1703.15	1703.15	1693.62	1694.39	48431.0
2013-05-31 04:00:00	ES	Futures	1694.65	1696.45	1692.59	1692.84	27619.0
2013-05-31 05:00:00	ES	Futures	1692.59	1693.1	1690.01	1692.33	31149.0
2013-05-31 06:00:00	ES	Futures	1692.07	1695.68	1690.78	1694.65	27204.0
2013-05-31 07:00:00	ES	Futures	1694.65	1697.22	1694.13	1695.68	31139.0
2013-05-31 08:00:00	ES	Futures	1695.68	1696.97	1693.36	1694.9	37251.0
2013-05-31 09:00:00	ES	Futures	1695.16	1703.92	1694.9	1701.09	292104.0
2013-05-31 10:00:00	ES	Futures	1701.09	1702.89	1696.45	1699.8	306038.0
2013-05-31 11:00:00	ES	Futures	1699.8	1708.3	1699.28	1703.66	307651.0
2013-05-31 12:00:00	ES	Futures	1703.41	1703.66	1699.03	1700.57	167699.0
2013-05-31 13:00:00	ES	Futures	1700.57	1703.41	1698.77	1700.06	132321.0
2013-05-31 14:00:00	ES	Futures	1700.31	1700.57	1690.78	1691.04	255129.0
2013-05-31 15:00:00	ES	Futures	1691.04	1695.68	1677.65	1678.42	561432.0
2013-05-31 16:00:00	ES	Futures	1678.16	1680.22	1675.59	1676.62	269962.0
2013-05-31 17:00:00	ES	Futures	1676.62	1677.39	1676.36	1676.87	4529.0
2013-05-31 00:00:00	NQ	Futures	3513.43	3516.35	3512.56	3513.72	370.0
2013-05-31 01:00:00	NQ	Futures	3513.43	3515.47	3512.27	3513.14	526.0
2013-05-31 02:00:00	NQ	Futures	3513.14	3514.6	3510.52	3511.97	793.0
2013-05-31 03:00:00	NQ	Futures	3511.68	3511.97	3489.22	3490.97	8008.0
2013-05-31 04:00:00	NQ	Futures	3490.97	3494.47	3487.77	3488.64	2742.0
2013-05-31 05:00:00	NQ	Futures	3488.35	3488.93	3483.39	3487.18	2749.0
2013-05-31 06:00:00	NQ	Futures	3486.89	3493.89	3484.56	3491.85	3241.0
2013-05-31 07:00:00	NQ	Futures	3491.85	3500.02	3491.27	3496.81	4124.0
2013-05-31 08:00:00	NQ	Futures	3496.81	3500.6	3493.6	3495.64	4820.0
2013-05-31 09:00:00	NQ	Futures	3495.35	3516.64	3494.77	3511.68	39390.0
2013-05-31 10:00:00	NQ	Futures	3511.97	3516.06	3506.14	3512.27	34144.0
2013-05-31 11:00:00	NQ	Futures	3511.97	3526.56	3511.68	3520.14	33700.0
2013-05-31 12:00:00	NQ	Futures	3520.43	3520.43	3511.1	3516.35	18456.0
2013-05-31 13:00:00	NQ	Futures	3516.64	3522.18	3514.6	3516.06	11957.0
2013-05-31 14:00:00	NQ	Futures	3516.35	3516.64	3499.72	3500.6	30809.0
2013-05-31 15:00:00	NQ	Futures	3500.6	3508.18	3477.85	3479.31	56345.0
2013-05-31 16:00:00	NQ	Futures	3479.31	3483.39	3473.18	3473.18	17246.0
2013-05-31 17:00:00	NQ	Futures	3472.89	3474.06	3472.31	3472.31	200.0
2013-05-31 00:00:00	YM	Futures	15497.8	15509.9	15493.7	15500.8	528.0
2013-05-31 01:00:00	YM	Futures	15499.8	15505.9	15494.8	15495.8	545.0
2013-05-31 02:00:00	YM	Futures	15495.8	15500.8	15485.7	15487.7	883.0
2013-05-31 03:00:00	YM	Futures	15488.7	15488.7	15407.8	15412.9	5707.0
2013-05-31 04:00:00	YM	Futures	15412.9	15426.0	15395.7	15401.7	3692.0
2013-05-31 05:00:00	YM	Futures	15399.7	15400.7	15369.4	15392.6	3546.0
2013-05-31 06:00:00	YM	Futures	15390.6	15412.9	15381.5	15405.8	2589.0
2013-05-31 07:00:00	YM	Futures	15403.8	15423.0	15398.7	15410.8	2685.0
2013-05-31 08:00:00	YM	Futures	15410.8	15417.9	15396.7	15405.8	3706.0
2013-05-31 09:00:00	YM	Futures	15406.8	15495.8	15404.8	15475.5	26641.0
2013-05-31 10:00:00	YM	Futures	15476.6	15492.7	15436.1	15472.5	29619.0
2013-05-31 11:00:00	YM	Futures	15472.5	15550.4	15469.5	15507.9	26328.0
2013-05-31 12:00:00	YM	Futures	15507.9	15507.9	15459.4	15480.6	13965.0
2013-05-31 13:00:00	YM	Futures	15480.6	15507.9	15464.4	15476.6	10385.0

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

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