PREVIEW / futures_1hour / 2013-05-13

all futures 1-hour files

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

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-13 00:00:00	ES	Futures	1673.78	1674.81	1673.53	1674.56	1874.0
2013-05-13 01:00:00	ES	Futures	1674.81	1675.59	1674.04	1674.56	3707.0
2013-05-13 02:00:00	ES	Futures	1674.56	1675.07	1673.53	1674.81	8726.0
2013-05-13 03:00:00	ES	Futures	1674.81	1676.36	1672.5	1673.27	23140.0
2013-05-13 04:00:00	ES	Futures	1673.01	1674.3	1672.75	1673.53	12788.0
2013-05-13 05:00:00	ES	Futures	1673.53	1673.78	1671.46	1671.46	13757.0
2013-05-13 06:00:00	ES	Futures	1671.46	1673.78	1671.46	1672.75	10779.0
2013-05-13 07:00:00	ES	Futures	1673.01	1675.33	1672.75	1675.07	20310.0
2013-05-13 08:00:00	ES	Futures	1675.07	1677.13	1673.53	1676.62	67645.0
2013-05-13 09:00:00	ES	Futures	1676.62	1677.9	1672.5	1673.53	185644.0
2013-05-13 10:00:00	ES	Futures	1673.78	1679.19	1672.75	1677.9	243657.0
2013-05-13 11:00:00	ES	Futures	1677.9	1681.25	1675.84	1681.0	176046.0
2013-05-13 12:00:00	ES	Futures	1680.74	1682.8	1680.22	1680.74	107622.0
2013-05-13 13:00:00	ES	Futures	1680.74	1682.03	1677.9	1678.42	97757.0
2013-05-13 14:00:00	ES	Futures	1678.68	1681.0	1677.65	1681.0	83311.0
2013-05-13 15:00:00	ES	Futures	1680.74	1681.25	1677.39	1679.97	162575.0
2013-05-13 16:00:00	ES	Futures	1679.97	1681.0	1679.45	1680.22	44804.0
2013-05-13 17:00:00	ES	Futures	1680.22	1680.74	1679.97	1680.74	2192.0
2013-05-13 18:00:00	ES	Futures	1680.22	1680.48	1679.71	1680.22	3385.0
2013-05-13 19:00:00	ES	Futures	1680.22	1682.54	1680.22	1682.03	5761.0
2013-05-13 20:00:00	ES	Futures	1682.03	1682.28	1681.0	1681.77	4121.0
2013-05-13 21:00:00	ES	Futures	1682.03	1682.54	1681.25	1681.51	3908.0
2013-05-13 22:00:00	ES	Futures	1681.51	1682.8	1681.0	1682.03	4669.0
2013-05-13 23:00:00	ES	Futures	1682.03	1682.28	1681.0	1681.25	1856.0
2013-05-13 00:00:00	NQ	Futures	3462.68	3465.31	3462.68	3464.43	276.0
2013-05-13 01:00:00	NQ	Futures	3464.43	3466.18	3463.56	3464.72	364.0
2013-05-13 02:00:00	NQ	Futures	3464.72	3465.31	3462.1	3464.72	494.0
2013-05-13 03:00:00	NQ	Futures	3464.72	3468.52	3458.31	3459.77	1921.0
2013-05-13 04:00:00	NQ	Futures	3460.06	3460.64	3457.43	3458.02	1982.0
2013-05-13 05:00:00	NQ	Futures	3458.02	3458.02	3454.22	3454.52	1918.0
2013-05-13 06:00:00	NQ	Futures	3454.52	3458.31	3453.93	3457.43	1112.0
2013-05-13 07:00:00	NQ	Futures	3457.43	3462.68	3457.14	3462.39	1823.0
2013-05-13 08:00:00	NQ	Futures	3462.39	3469.1	3459.77	3467.93	7745.0
2013-05-13 09:00:00	NQ	Futures	3467.93	3473.77	3464.14	3466.47	23148.0
2013-05-13 10:00:00	NQ	Futures	3466.77	3478.43	3462.97	3472.31	31249.0
2013-05-13 11:00:00	NQ	Futures	3472.31	3480.47	3466.47	3479.89	19626.0
2013-05-13 12:00:00	NQ	Futures	3480.18	3485.43	3479.6	3480.18	18487.0
2013-05-13 13:00:00	NQ	Futures	3480.47	3482.22	3469.97	3472.89	15176.0
2013-05-13 14:00:00	NQ	Futures	3472.89	3478.43	3471.14	3478.43	9653.0
2013-05-13 15:00:00	NQ	Futures	3478.43	3479.31	3468.81	3477.27	18007.0
2013-05-13 16:00:00	NQ	Futures	3476.68	3479.6	3475.81	3477.56	4683.0
2013-05-13 17:00:00	NQ	Futures	3477.56	3479.02	3477.56	3479.02	281.0
2013-05-13 18:00:00	NQ	Futures	3478.14	3479.02	3477.56	3479.02	268.0
2013-05-13 19:00:00	NQ	Futures	3479.02	3483.68	3479.02	3482.81	585.0
2013-05-13 20:00:00	NQ	Futures	3482.81	3483.1	3481.35	3482.52	420.0
2013-05-13 21:00:00	NQ	Futures	3482.52	3483.97	3481.06	3481.64	527.0
2013-05-13 22:00:00	NQ	Futures	3481.64	3484.56	3480.77	3483.39	583.0
2013-05-13 23:00:00	NQ	Futures	3483.39	3483.39	3480.47	3481.06	431.0
2013-05-13 00:00:00	YM	Futures	15198.5	15210.7	15198.5	15205.6	319.0
2013-05-13 01:00:00	YM	Futures	15204.6	15213.7	15202.6	15206.6	362.0

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

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