PREVIEW / futures_1hour / 2013-05-28

all futures 1-hour files

  file:    by_date/futures_1hour/2013/2013-05-28.parquet
  size:    49 KB
  rows:    1,465

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-28 00:00:00	ES	Futures	1706.75	1707.01	1705.47	1706.24	3052.0
2013-05-28 01:00:00	ES	Futures	1705.98	1707.27	1705.98	1707.27	3361.0
2013-05-28 02:00:00	ES	Futures	1707.27	1708.81	1706.5	1707.78	11514.0
2013-05-28 03:00:00	ES	Futures	1707.78	1714.22	1707.53	1713.19	43580.0
2013-05-28 04:00:00	ES	Futures	1713.45	1714.22	1712.68	1712.68	16866.0
2013-05-28 05:00:00	ES	Futures	1712.68	1713.45	1711.91	1713.19	11161.0
2013-05-28 06:00:00	ES	Futures	1712.94	1713.19	1710.88	1711.91	14247.0
2013-05-28 07:00:00	ES	Futures	1711.91	1714.74	1711.65	1712.42	29297.0
2013-05-28 08:00:00	ES	Futures	1712.42	1715.25	1712.42	1715.0	34575.0
2013-05-28 09:00:00	ES	Futures	1715.0	1720.92	1713.97	1720.66	262954.0
2013-05-28 10:00:00	ES	Futures	1720.92	1723.5	1717.83	1718.86	299322.0
2013-05-28 11:00:00	ES	Futures	1718.86	1719.12	1712.42	1712.68	248379.0
2013-05-28 12:00:00	ES	Futures	1712.68	1715.25	1712.16	1713.71	126729.0
2013-05-28 13:00:00	ES	Futures	1713.71	1715.51	1704.95	1706.24	236610.0
2013-05-28 14:00:00	ES	Futures	1706.24	1708.56	1702.89	1707.27	213916.0
2013-05-28 15:00:00	ES	Futures	1707.27	1711.65	1705.98	1708.3	245237.0
2013-05-28 16:00:00	ES	Futures	1708.3	1709.84	1703.92	1707.01	107164.0
2013-05-28 17:00:00	ES	Futures	1707.01	1707.01	1705.98	1705.98	3266.0
2013-05-28 18:00:00	ES	Futures	1704.44	1705.47	1702.63	1704.44	10135.0
2013-05-28 19:00:00	ES	Futures	1704.18	1705.98	1704.18	1705.21	3095.0
2013-05-28 20:00:00	ES	Futures	1705.47	1705.98	1702.12	1703.92	10400.0
2013-05-28 21:00:00	ES	Futures	1704.18	1704.18	1701.6	1703.41	7122.0
2013-05-28 22:00:00	ES	Futures	1703.66	1704.18	1703.15	1703.66	2986.0
2013-05-28 23:00:00	ES	Futures	1703.41	1704.18	1702.89	1703.92	3007.0
2013-05-28 00:00:00	NQ	Futures	3508.77	3509.35	3507.31	3508.18	354.0
2013-05-28 01:00:00	NQ	Futures	3507.89	3510.22	3507.31	3509.93	378.0
2013-05-28 02:00:00	NQ	Futures	3509.93	3513.43	3509.06	3511.68	816.0
2013-05-28 03:00:00	NQ	Futures	3511.39	3527.72	3510.52	3524.81	4716.0
2013-05-28 04:00:00	NQ	Futures	3524.81	3526.56	3522.77	3523.35	2697.0
2013-05-28 05:00:00	NQ	Futures	3523.64	3525.39	3521.31	3524.22	1694.0
2013-05-28 06:00:00	NQ	Futures	3524.22	3525.1	3520.14	3521.02	1863.0
2013-05-28 07:00:00	NQ	Futures	3520.72	3524.81	3520.43	3521.89	2570.0
2013-05-28 08:00:00	NQ	Futures	3521.89	3524.52	3521.6	3523.93	5294.0
2013-05-28 09:00:00	NQ	Futures	3523.64	3539.39	3522.47	3539.1	38688.0
2013-05-28 10:00:00	NQ	Futures	3538.81	3542.89	3530.06	3533.27	30419.0
2013-05-28 11:00:00	NQ	Futures	3533.27	3535.89	3521.6	3522.18	22694.0
2013-05-28 12:00:00	NQ	Futures	3522.18	3525.97	3518.1	3522.47	18962.0
2013-05-28 13:00:00	NQ	Futures	3522.47	3525.97	3504.39	3506.14	28034.0
2013-05-28 14:00:00	NQ	Futures	3505.85	3513.72	3500.89	3510.81	23788.0
2013-05-28 15:00:00	NQ	Futures	3511.1	3519.85	3507.89	3511.97	28918.0
2013-05-28 16:00:00	NQ	Futures	3511.68	3514.31	3503.52	3507.89	7770.0
2013-05-28 17:00:00	NQ	Futures	3507.89	3507.89	3506.43	3506.72	114.0
2013-05-28 18:00:00	NQ	Futures	3505.56	3505.56	3501.18	3504.1	750.0
2013-05-28 19:00:00	NQ	Futures	3504.1	3507.89	3504.1	3507.02	300.0
2013-05-28 20:00:00	NQ	Futures	3507.02	3507.6	3500.31	3504.68	1107.0
2013-05-28 21:00:00	NQ	Futures	3504.68	3505.27	3500.6	3503.22	909.0
2013-05-28 22:00:00	NQ	Futures	3503.22	3504.97	3502.64	3503.81	433.0
2013-05-28 23:00:00	NQ	Futures	3504.1	3505.27	3502.93	3504.97	356.0
2013-05-28 00:00:00	YM	Futures	15524.1	15526.1	15516.0	15519.0	422.0
2013-05-28 01:00:00	YM	Futures	15518.0	15529.1	15517.0	15527.1	439.0

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

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