PREVIEW / futures_1hour / 2013-08-27

all futures 1-hour files

  file:    by_date/futures_1hour/2013/2013-08-27.parquet
  size:    51 KB
  rows:    1,540

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-08-27 00:00:00	ES	Futures	1709.17	1709.43	1706.32	1706.58	4292.0
2013-08-27 01:00:00	ES	Futures	1706.32	1707.36	1706.07	1707.1	6637.0
2013-08-27 02:00:00	ES	Futures	1707.1	1709.17	1706.84	1707.88	8138.0
2013-08-27 03:00:00	ES	Futures	1708.13	1710.98	1701.93	1703.48	45436.0
2013-08-27 04:00:00	ES	Futures	1703.48	1704.26	1699.34	1701.93	42554.0
2013-08-27 05:00:00	ES	Futures	1701.93	1702.71	1700.64	1702.71	16948.0
2013-08-27 06:00:00	ES	Futures	1702.71	1702.96	1697.28	1698.31	30745.0
2013-08-27 07:00:00	ES	Futures	1698.31	1701.93	1697.54	1700.9	33442.0
2013-08-27 08:00:00	ES	Futures	1700.9	1700.9	1691.33	1693.66	96504.0
2013-08-27 09:00:00	ES	Futures	1693.4	1700.12	1691.85	1697.79	257325.0
2013-08-27 10:00:00	ES	Futures	1698.05	1699.6	1690.81	1695.98	350636.0
2013-08-27 11:00:00	ES	Futures	1695.98	1697.79	1693.14	1694.95	237686.0
2013-08-27 12:00:00	ES	Futures	1694.95	1694.95	1689.52	1690.81	194218.0
2013-08-27 13:00:00	ES	Futures	1690.56	1691.85	1686.94	1689.78	185705.0
2013-08-27 14:00:00	ES	Futures	1689.78	1689.78	1684.09	1686.68	210121.0
2013-08-27 15:00:00	ES	Futures	1686.68	1688.75	1681.51	1683.06	355833.0
2013-08-27 16:00:00	ES	Futures	1682.8	1684.61	1682.28	1684.09	136041.0
2013-08-27 17:00:00	ES	Futures	1684.09	1684.09	1683.06	1683.32	2028.0
2013-08-27 18:00:00	ES	Futures	1683.58	1684.35	1682.8	1683.58	4457.0
2013-08-27 19:00:00	ES	Futures	1683.84	1684.35	1682.28	1682.54	5107.0
2013-08-27 20:00:00	ES	Futures	1682.8	1686.94	1682.54	1686.68	12113.0
2013-08-27 21:00:00	ES	Futures	1686.68	1689.01	1686.42	1687.45	12516.0
2013-08-27 22:00:00	ES	Futures	1687.45	1687.97	1686.42	1687.71	4236.0
2013-08-27 23:00:00	ES	Futures	1687.71	1687.71	1684.61	1685.13	5381.0
2013-08-27 00:00:00	NQ	Futures	3648.27	3648.86	3643.3	3643.6	638.0
2013-08-27 01:00:00	NQ	Futures	3643.89	3644.47	3641.84	3643.3	1007.0
2013-08-27 02:00:00	NQ	Futures	3643.3	3648.27	3643.3	3645.93	1128.0
2013-08-27 03:00:00	NQ	Futures	3646.23	3652.07	3632.49	3636.0	6129.0
2013-08-27 04:00:00	NQ	Futures	3636.29	3637.75	3628.11	3633.08	7958.0
2013-08-27 05:00:00	NQ	Futures	3633.08	3633.08	3628.4	3632.2	3778.0
2013-08-27 06:00:00	NQ	Futures	3632.2	3632.49	3614.67	3615.83	6148.0
2013-08-27 07:00:00	NQ	Futures	3615.83	3625.19	3614.67	3623.72	5109.0
2013-08-27 08:00:00	NQ	Futures	3623.72	3624.02	3604.14	3607.36	9721.0
2013-08-27 09:00:00	NQ	Futures	3607.07	3625.77	3605.31	3619.63	42987.0
2013-08-27 10:00:00	NQ	Futures	3619.63	3623.72	3601.22	3612.91	49206.0
2013-08-27 11:00:00	NQ	Futures	3613.2	3619.34	3605.02	3608.53	41216.0
2013-08-27 12:00:00	NQ	Futures	3608.53	3608.53	3591.29	3594.21	31381.0
2013-08-27 13:00:00	NQ	Futures	3593.92	3594.5	3580.47	3586.61	36491.0
2013-08-27 14:00:00	NQ	Futures	3586.9	3586.9	3572.88	3581.93	41014.0
2013-08-27 15:00:00	NQ	Futures	3581.93	3588.66	3568.2	3575.51	61577.0
2013-08-27 16:00:00	NQ	Futures	3575.51	3580.18	3574.92	3579.01	10356.0
2013-08-27 17:00:00	NQ	Futures	3579.01	3579.3	3577.26	3577.84	68.0
2013-08-27 18:00:00	NQ	Futures	3578.72	3579.6	3576.09	3578.14	454.0
2013-08-27 19:00:00	NQ	Futures	3578.72	3579.3	3574.63	3575.51	357.0
2013-08-27 20:00:00	NQ	Futures	3575.51	3584.27	3575.21	3583.69	949.0
2013-08-27 21:00:00	NQ	Futures	3583.98	3587.2	3583.98	3584.27	1000.0
2013-08-27 22:00:00	NQ	Futures	3584.27	3585.15	3581.64	3583.98	569.0
2013-08-27 23:00:00	NQ	Futures	3583.98	3584.27	3578.43	3580.18	637.0
2013-08-27 00:00:00	YM	Futures	15156.0	15158.0	15131.6	15131.6	566.0
2013-08-27 01:00:00	YM	Futures	15132.6	15138.7	15125.5	15138.7	1174.0

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

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