PREVIEW / futures_1hour / 2013-05-17

all futures 1-hour files

  file:    by_date/futures_1hour/2013/2013-05-17.parquet
  size:    43 KB
  rows:    1,245

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-17 00:00:00	ES	Futures	1700.83	1701.09	1700.06	1700.31	2312.0
2013-05-17 01:00:00	ES	Futures	1700.31	1702.12	1699.8	1701.6	5279.0
2013-05-17 02:00:00	ES	Futures	1701.6	1703.15	1700.83	1701.86	8479.0
2013-05-17 03:00:00	ES	Futures	1701.6	1702.37	1699.54	1701.09	16503.0
2013-05-17 04:00:00	ES	Futures	1701.34	1701.6	1699.28	1700.31	9375.0
2013-05-17 05:00:00	ES	Futures	1700.31	1704.18	1700.06	1702.89	24591.0
2013-05-17 06:00:00	ES	Futures	1703.15	1704.44	1701.86	1702.89	18432.0
2013-05-17 07:00:00	ES	Futures	1702.63	1703.66	1701.86	1703.15	20722.0
2013-05-17 08:00:00	ES	Futures	1703.15	1705.72	1702.89	1705.21	38322.0
2013-05-17 09:00:00	ES	Futures	1704.95	1707.78	1702.63	1707.27	266435.0
2013-05-17 10:00:00	ES	Futures	1707.53	1709.33	1705.47	1705.47	345014.0
2013-05-17 11:00:00	ES	Futures	1705.72	1707.78	1703.41	1706.5	216471.0
2013-05-17 12:00:00	ES	Futures	1706.75	1707.27	1704.95	1705.72	133844.0
2013-05-17 13:00:00	ES	Futures	1705.98	1707.53	1705.47	1706.75	110505.0
2013-05-17 14:00:00	ES	Futures	1706.5	1713.19	1706.5	1713.19	205453.0
2013-05-17 15:00:00	ES	Futures	1713.19	1716.28	1712.16	1715.25	339456.0
2013-05-17 16:00:00	ES	Futures	1715.25	1715.77	1713.19	1714.48	125163.0
2013-05-17 17:00:00	ES	Futures	1714.48	1715.51	1714.22	1715.25	1861.0
2013-05-17 00:00:00	NQ	Futures	3502.64	3503.52	3502.06	3502.64	177.0
2013-05-17 01:00:00	NQ	Futures	3502.35	3504.97	3501.77	3504.39	386.0
2013-05-17 02:00:00	NQ	Futures	3504.1	3507.6	3502.93	3504.68	765.0
2013-05-17 03:00:00	NQ	Futures	3504.39	3505.56	3500.02	3502.06	1748.0
2013-05-17 04:00:00	NQ	Futures	3502.35	3503.22	3498.56	3499.14	1397.0
2013-05-17 05:00:00	NQ	Futures	3499.43	3506.72	3499.43	3503.52	3393.0
2013-05-17 06:00:00	NQ	Futures	3503.52	3506.72	3501.47	3504.68	2204.0
2013-05-17 07:00:00	NQ	Futures	3504.39	3508.47	3504.1	3507.89	3340.0
2013-05-17 08:00:00	NQ	Futures	3508.18	3511.97	3507.31	3510.52	4484.0
2013-05-17 09:00:00	NQ	Futures	3510.52	3522.77	3504.39	3514.6	43867.0
2013-05-17 10:00:00	NQ	Futures	3514.6	3519.85	3511.39	3514.02	25092.0
2013-05-17 11:00:00	NQ	Futures	3514.02	3515.18	3505.56	3512.85	22047.0
2013-05-17 12:00:00	NQ	Futures	3512.85	3514.02	3507.31	3512.27	12404.0
2013-05-17 13:00:00	NQ	Futures	3512.27	3513.72	3507.6	3511.97	10971.0
2013-05-17 14:00:00	NQ	Futures	3511.68	3525.68	3510.81	3525.1	18816.0
2013-05-17 15:00:00	NQ	Futures	3525.1	3532.97	3521.89	3531.52	27381.0
2013-05-17 16:00:00	NQ	Futures	3531.22	3532.1	3527.14	3528.31	7329.0
2013-05-17 17:00:00	NQ	Futures	3528.31	3530.93	3528.02	3530.06	274.0
2013-05-17 00:00:00	YM	Futures	15399.7	15400.7	15396.7	15397.7	280.0
2013-05-17 01:00:00	YM	Futures	15396.7	15407.8	15394.7	15404.8	455.0
2013-05-17 02:00:00	YM	Futures	15404.8	15422.0	15399.7	15409.8	1449.0
2013-05-17 03:00:00	YM	Futures	15410.8	15413.9	15392.6	15405.8	1723.0
2013-05-17 04:00:00	YM	Futures	15405.8	15408.8	15387.6	15394.7	1229.0
2013-05-17 05:00:00	YM	Futures	15393.7	15427.0	15393.7	15421.0	2182.0
2013-05-17 06:00:00	YM	Futures	15421.0	15433.1	15412.9	15417.9	1572.0
2013-05-17 07:00:00	YM	Futures	15417.9	15423.0	15409.8	15417.9	1142.0
2013-05-17 08:00:00	YM	Futures	15416.9	15435.1	15416.9	15428.0	1977.0
2013-05-17 09:00:00	YM	Futures	15427.0	15435.1	15397.7	15433.1	16532.0
2013-05-17 10:00:00	YM	Futures	15432.1	15451.3	15424.0	15429.0	18782.0
2013-05-17 11:00:00	YM	Futures	15429.0	15447.2	15413.9	15437.1	14060.0
2013-05-17 12:00:00	YM	Futures	15437.1	15442.2	15425.0	15429.0	7351.0
2013-05-17 13:00:00	YM	Futures	15429.0	15436.1	15424.0	15430.1	5372.0

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

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