PREVIEW / futures_1hour / 2013-07-09

all futures 1-hour files

  file:    by_date/futures_1hour/2013/2013-07-09.parquet
  size:    49 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-07-09 00:00:00	ES	Futures	1697.02	1698.05	1696.76	1698.05	4106.0
2013-07-09 01:00:00	ES	Futures	1698.05	1699.34	1697.28	1697.79	4788.0
2013-07-09 02:00:00	ES	Futures	1697.79	1699.34	1696.76	1697.79	7153.0
2013-07-09 03:00:00	ES	Futures	1697.79	1700.12	1697.02	1699.34	23810.0
2013-07-09 04:00:00	ES	Futures	1699.6	1700.9	1698.31	1699.09	15265.0
2013-07-09 05:00:00	ES	Futures	1698.83	1699.34	1697.54	1698.05	9124.0
2013-07-09 06:00:00	ES	Futures	1697.79	1698.31	1694.69	1695.98	23675.0
2013-07-09 07:00:00	ES	Futures	1695.98	1698.57	1695.98	1697.54	17871.0
2013-07-09 08:00:00	ES	Futures	1697.79	1700.64	1696.24	1700.12	32289.0
2013-07-09 09:00:00	ES	Futures	1700.12	1702.71	1698.05	1698.83	184213.0
2013-07-09 10:00:00	ES	Futures	1699.09	1699.34	1693.92	1699.09	253538.0
2013-07-09 11:00:00	ES	Futures	1699.09	1702.19	1698.83	1700.12	154241.0
2013-07-09 12:00:00	ES	Futures	1700.12	1703.74	1699.86	1703.48	96575.0
2013-07-09 13:00:00	ES	Futures	1703.22	1704.26	1700.64	1702.96	93763.0
2013-07-09 14:00:00	ES	Futures	1702.96	1705.03	1701.67	1702.19	82743.0
2013-07-09 15:00:00	ES	Futures	1701.93	1705.03	1701.15	1702.19	152659.0
2013-07-09 16:00:00	ES	Futures	1702.19	1702.96	1700.9	1701.93	76529.0
2013-07-09 17:00:00	ES	Futures	1701.93	1702.96	1701.67	1702.96	3862.0
2013-07-09 18:00:00	ES	Futures	1702.96	1703.48	1702.45	1702.71	2615.0
2013-07-09 19:00:00	ES	Futures	1702.96	1703.22	1702.19	1702.71	1254.0
2013-07-09 20:00:00	ES	Futures	1702.71	1703.22	1701.93	1702.19	3213.0
2013-07-09 21:00:00	ES	Futures	1702.19	1704.26	1701.93	1703.48	4249.0
2013-07-09 22:00:00	ES	Futures	1703.22	1703.22	1699.34	1700.38	12005.0
2013-07-09 23:00:00	ES	Futures	1700.38	1700.64	1699.09	1700.12	3368.0
2013-07-09 00:00:00	NQ	Futures	3470.01	3471.47	3469.72	3471.47	381.0
2013-07-09 01:00:00	NQ	Futures	3471.47	3474.39	3471.47	3472.35	526.0
2013-07-09 02:00:00	NQ	Futures	3472.35	3474.68	3471.18	3472.93	881.0
2013-07-09 03:00:00	NQ	Futures	3472.64	3480.53	3472.05	3478.48	3842.0
2013-07-09 04:00:00	NQ	Futures	3478.48	3479.94	3473.81	3475.56	1936.0
2013-07-09 05:00:00	NQ	Futures	3475.27	3475.85	3472.05	3472.93	1282.0
2013-07-09 06:00:00	NQ	Futures	3472.64	3473.81	3467.38	3469.72	2720.0
2013-07-09 07:00:00	NQ	Futures	3469.72	3472.35	3468.84	3470.3	2300.0
2013-07-09 08:00:00	NQ	Futures	3470.59	3477.9	3468.55	3477.61	4719.0
2013-07-09 09:00:00	NQ	Futures	3477.61	3480.24	3465.04	3467.96	30528.0
2013-07-09 10:00:00	NQ	Futures	3467.96	3474.39	3460.36	3473.22	31956.0
2013-07-09 11:00:00	NQ	Futures	3473.22	3482.57	3471.76	3476.73	20394.0
2013-07-09 12:00:00	NQ	Futures	3477.02	3482.87	3474.98	3482.28	9019.0
2013-07-09 13:00:00	NQ	Futures	3481.99	3483.74	3474.39	3480.82	10335.0
2013-07-09 14:00:00	NQ	Futures	3480.53	3485.2	3479.94	3483.16	10112.0
2013-07-09 15:00:00	NQ	Futures	3482.87	3489.3	3478.78	3481.11	23470.0
2013-07-09 16:00:00	NQ	Futures	3480.82	3481.41	3477.61	3479.07	3976.0
2013-07-09 17:00:00	NQ	Futures	3479.07	3481.11	3478.48	3481.11	296.0
2013-07-09 18:00:00	NQ	Futures	3480.24	3482.28	3480.24	3481.7	166.0
2013-07-09 19:00:00	NQ	Futures	3481.7	3481.99	3480.53	3480.82	122.0
2013-07-09 20:00:00	NQ	Futures	3481.11	3481.99	3479.65	3479.94	399.0
2013-07-09 21:00:00	NQ	Futures	3479.94	3483.74	3479.65	3481.99	423.0
2013-07-09 22:00:00	NQ	Futures	3481.99	3481.99	3474.68	3476.15	1463.0
2013-07-09 23:00:00	NQ	Futures	3476.44	3477.61	3474.98	3476.73	430.0
2013-07-09 00:00:00	YM	Futures	15446.5	15452.6	15444.4	15452.6	324.0
2013-07-09 01:00:00	YM	Futures	15451.6	15463.7	15451.6	15453.6	743.0

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

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