PREVIEW / futures_1hour / 2013-06-05

all futures 1-hour files

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

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-05 00:00:00	ES	Futures	1679.45	1681.0	1678.16	1679.45	6226.0
2013-06-05 01:00:00	ES	Futures	1679.71	1679.97	1674.04	1674.3	13390.0
2013-06-05 02:00:00	ES	Futures	1674.04	1675.59	1673.78	1675.33	16146.0
2013-06-05 03:00:00	ES	Futures	1675.33	1680.22	1674.3	1677.9	31000.0
2013-06-05 04:00:00	ES	Futures	1677.65	1679.71	1676.36	1678.42	19488.0
2013-06-05 05:00:00	ES	Futures	1678.16	1678.93	1674.81	1675.84	17740.0
2013-06-05 06:00:00	ES	Futures	1675.84	1676.1	1670.95	1673.01	40145.0
2013-06-05 07:00:00	ES	Futures	1673.01	1674.56	1671.46	1673.01	46427.0
2013-06-05 08:00:00	ES	Futures	1673.01	1677.13	1671.21	1675.84	85532.0
2013-06-05 09:00:00	ES	Futures	1676.1	1677.65	1671.98	1673.78	231672.0
2013-06-05 10:00:00	ES	Futures	1673.78	1678.16	1666.31	1667.34	429563.0
2013-06-05 11:00:00	ES	Futures	1667.6	1667.86	1661.16	1662.45	334933.0
2013-06-05 12:00:00	ES	Futures	1662.45	1663.48	1656.52	1657.81	278045.0
2013-06-05 13:00:00	ES	Futures	1657.81	1665.28	1656.27	1660.65	252490.0
2013-06-05 14:00:00	ES	Futures	1660.65	1662.45	1654.21	1659.36	260777.0
2013-06-05 15:00:00	ES	Futures	1659.36	1663.22	1655.49	1655.75	408183.0
2013-06-05 16:00:00	ES	Futures	1655.49	1657.81	1654.46	1656.78	115572.0
2013-06-05 17:00:00	ES	Futures	1656.78	1657.56	1656.52	1657.04	2933.0
2013-06-05 18:00:00	ES	Futures	1657.3	1658.33	1655.49	1657.3	6576.0
2013-06-05 19:00:00	ES	Futures	1657.56	1659.36	1657.3	1658.84	5223.0
2013-06-05 20:00:00	ES	Futures	1658.84	1660.9	1658.59	1660.65	11693.0
2013-06-05 21:00:00	ES	Futures	1660.65	1661.93	1660.13	1661.93	11573.0
2013-06-05 22:00:00	ES	Futures	1661.93	1662.19	1659.87	1661.42	8395.0
2013-06-05 23:00:00	ES	Futures	1661.68	1661.93	1660.39	1661.42	6289.0
2013-06-05 00:00:00	NQ	Futures	3469.39	3472.02	3467.35	3469.68	1159.0
2013-06-05 01:00:00	NQ	Futures	3470.27	3470.85	3459.77	3460.06	1158.0
2013-06-05 02:00:00	NQ	Futures	3460.06	3462.97	3459.47	3460.93	1646.0
2013-06-05 03:00:00	NQ	Futures	3460.93	3471.72	3459.47	3467.64	3498.0
2013-06-05 04:00:00	NQ	Futures	3467.06	3470.56	3463.85	3466.47	2140.0
2013-06-05 05:00:00	NQ	Futures	3466.18	3468.22	3460.93	3463.85	2177.0
2013-06-05 06:00:00	NQ	Futures	3463.85	3463.85	3454.52	3458.89	3755.0
2013-06-05 07:00:00	NQ	Futures	3458.89	3461.81	3455.1	3456.85	4694.0
2013-06-05 08:00:00	NQ	Futures	3457.14	3463.27	3453.64	3462.1	10604.0
2013-06-05 09:00:00	NQ	Futures	3462.1	3470.56	3450.72	3463.56	47388.0
2013-06-05 10:00:00	NQ	Futures	3463.27	3469.97	3442.56	3446.06	56126.0
2013-06-05 11:00:00	NQ	Futures	3446.06	3446.35	3434.97	3437.31	33812.0
2013-06-05 12:00:00	NQ	Futures	3437.31	3439.93	3422.43	3425.06	26973.0
2013-06-05 13:00:00	NQ	Futures	3425.06	3441.39	3422.43	3431.77	23979.0
2013-06-05 14:00:00	NQ	Futures	3432.06	3434.97	3420.68	3429.14	25715.0
2013-06-05 15:00:00	NQ	Futures	3429.43	3436.72	3421.27	3424.77	43772.0
2013-06-05 16:00:00	NQ	Futures	3424.77	3432.06	3423.31	3428.85	8098.0
2013-06-05 17:00:00	NQ	Futures	3428.85	3430.6	3428.56	3429.43	367.0
2013-06-05 18:00:00	NQ	Futures	3429.14	3432.06	3426.81	3430.31	432.0
2013-06-05 19:00:00	NQ	Futures	3430.6	3432.35	3430.6	3431.47	574.0
2013-06-05 20:00:00	NQ	Futures	3431.47	3434.39	3431.18	3433.52	1173.0
2013-06-05 21:00:00	NQ	Futures	3433.52	3435.27	3431.77	3434.39	688.0
2013-06-05 22:00:00	NQ	Futures	3434.39	3434.97	3432.35	3434.39	728.0
2013-06-05 23:00:00	NQ	Futures	3434.68	3434.97	3432.93	3433.81	484.0
2013-06-05 00:00:00	YM	Futures	15338.1	15347.2	15326.9	15338.1	879.0
2013-06-05 01:00:00	YM	Futures	15338.1	15342.1	15299.6	15299.6	1399.0

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

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