PREVIEW / futures_1hour / 2013-06-13

all futures 1-hour files

  file:    by_date/futures_1hour/2013/2013-06-13.parquet
  size:    51 KB
  rows:    1,515

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-06-13 00:00:00	ES	Futures	1653.18	1653.69	1651.12	1651.89	6600.0
2013-06-13 01:00:00	ES	Futures	1652.15	1652.66	1648.02	1648.8	19859.0
2013-06-13 02:00:00	ES	Futures	1648.54	1651.12	1645.96	1649.83	31751.0
2013-06-13 03:00:00	ES	Futures	1649.83	1653.95	1646.74	1652.66	44204.0
2013-06-13 04:00:00	ES	Futures	1652.66	1652.92	1646.99	1651.12	30100.0
2013-06-13 05:00:00	ES	Futures	1650.86	1652.92	1648.8	1651.37	18178.0
2013-06-13 06:00:00	ES	Futures	1651.12	1656.01	1651.12	1653.95	36348.0
2013-06-13 07:00:00	ES	Futures	1653.95	1655.24	1652.4	1654.46	31213.0
2013-06-13 08:00:00	ES	Futures	1654.21	1661.16	1653.18	1659.87	103743.0
2013-06-13 09:00:00	ES	Futures	1660.13	1663.74	1656.01	1663.22	338244.0
2013-06-13 10:00:00	ES	Futures	1663.22	1667.6	1660.39	1664.77	286755.0
2013-06-13 11:00:00	ES	Futures	1664.77	1668.89	1663.74	1668.12	145597.0
2013-06-13 12:00:00	ES	Futures	1668.37	1674.04	1667.09	1674.04	138721.0
2013-06-13 13:00:00	ES	Futures	1674.04	1674.3	1670.43	1673.01	114570.0
2013-06-13 14:00:00	ES	Futures	1673.27	1679.19	1673.01	1679.19	160011.0
2013-06-13 15:00:00	ES	Futures	1678.93	1689.24	1678.93	1686.15	340854.0
2013-06-13 16:00:00	ES	Futures	1686.15	1686.92	1685.37	1686.4	86436.0
2013-06-13 17:00:00	ES	Futures	1686.4	1687.18	1686.15	1687.18	3190.0
2013-06-13 18:00:00	ES	Futures	1687.43	1689.75	1686.92	1686.92	7095.0
2013-06-13 19:00:00	ES	Futures	1686.92	1688.72	1686.92	1687.95	2630.0
2013-06-13 20:00:00	ES	Futures	1687.69	1688.21	1683.83	1683.83	8796.0
2013-06-13 21:00:00	ES	Futures	1683.83	1684.86	1682.03	1683.06	8860.0
2013-06-13 22:00:00	ES	Futures	1683.06	1684.34	1681.77	1682.28	3407.0
2013-06-13 23:00:00	ES	Futures	1682.28	1683.31	1681.51	1682.03	3212.0
2013-06-13 00:00:00	NQ	Futures	3396.18	3397.93	3392.97	3394.14	690.0
2013-06-13 01:00:00	NQ	Futures	3394.14	3395.02	3384.52	3385.97	2141.0
2013-06-13 02:00:00	NQ	Futures	3385.68	3390.35	3380.72	3388.89	3048.0
2013-06-13 03:00:00	NQ	Futures	3388.6	3398.22	3386.27	3396.77	7235.0
2013-06-13 04:00:00	NQ	Futures	3396.18	3396.77	3384.22	3392.97	3311.0
2013-06-13 05:00:00	NQ	Futures	3392.97	3395.6	3387.43	3392.68	2156.0
2013-06-13 06:00:00	NQ	Futures	3392.97	3399.68	3391.81	3397.35	2991.0
2013-06-13 07:00:00	NQ	Futures	3397.06	3400.27	3395.89	3398.81	2948.0
2013-06-13 08:00:00	NQ	Futures	3398.81	3411.35	3397.35	3410.18	12121.0
2013-06-13 09:00:00	NQ	Futures	3410.18	3416.6	3399.1	3415.43	48790.0
2013-06-13 10:00:00	NQ	Futures	3415.14	3425.93	3406.68	3419.52	44923.0
2013-06-13 11:00:00	NQ	Futures	3419.81	3427.97	3416.89	3426.81	20227.0
2013-06-13 12:00:00	NQ	Futures	3427.1	3436.72	3423.89	3436.43	14785.0
2013-06-13 13:00:00	NQ	Futures	3436.72	3437.31	3429.43	3435.56	13220.0
2013-06-13 14:00:00	NQ	Futures	3435.56	3449.56	3435.56	3446.35	20064.0
2013-06-13 15:00:00	NQ	Futures	3446.35	3464.43	3446.35	3455.97	34209.0
2013-06-13 16:00:00	NQ	Futures	3455.68	3458.31	3454.22	3457.43	4539.0
2013-06-13 17:00:00	NQ	Futures	3457.14	3460.06	3456.85	3459.47	239.0
2013-06-13 18:00:00	NQ	Futures	3460.64	3463.27	3458.6	3460.06	205.0
2013-06-13 19:00:00	NQ	Futures	3458.6	3462.39	3458.02	3461.81	90.0
2013-06-13 20:00:00	NQ	Futures	3461.22	3461.22	3456.27	3456.85	1400.0
2013-06-13 21:00:00	NQ	Futures	3456.27	3458.6	3452.18	3454.52	494.0
2013-06-13 22:00:00	NQ	Futures	3454.22	3456.56	3451.89	3452.77	301.0
2013-06-13 23:00:00	NQ	Futures	3453.06	3454.22	3451.02	3452.18	133.0
2013-06-13 00:00:00	YM	Futures	15081.9	15093.0	15078.8	15080.8	22.0
2013-06-13 01:00:00	YM	Futures	15073.7	15076.8	15051.4	15055.4	37.0

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

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