PREVIEW / futures_1hour / 2013-07-01

all futures 1-hour files

  file:    by_date/futures_1hour/2013/2013-07-01.parquet
  size:    49 KB
  rows:    1,473

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-01 00:00:00	ES	Futures	1649.71	1652.04	1649.2	1650.75	2696.0
2013-07-01 01:00:00	ES	Futures	1651.01	1655.14	1650.75	1654.11	5636.0
2013-07-01 02:00:00	ES	Futures	1654.11	1660.05	1653.85	1659.28	15014.0
2013-07-01 03:00:00	ES	Futures	1659.54	1664.45	1659.54	1662.9	36235.0
2013-07-01 04:00:00	ES	Futures	1662.9	1662.9	1656.43	1657.47	27785.0
2013-07-01 05:00:00	ES	Futures	1657.21	1664.19	1656.95	1663.41	23787.0
2013-07-01 06:00:00	ES	Futures	1663.67	1664.71	1659.8	1660.57	19813.0
2013-07-01 07:00:00	ES	Futures	1660.57	1662.64	1659.8	1661.09	16664.0
2013-07-01 08:00:00	ES	Futures	1661.09	1662.9	1659.8	1660.57	24599.0
2013-07-01 09:00:00	ES	Futures	1660.83	1670.13	1660.31	1668.84	242391.0
2013-07-01 10:00:00	ES	Futures	1669.1	1675.05	1668.33	1671.43	257688.0
2013-07-01 11:00:00	ES	Futures	1671.43	1674.79	1671.17	1674.53	136763.0
2013-07-01 12:00:00	ES	Futures	1674.53	1675.56	1671.17	1672.46	110646.0
2013-07-01 13:00:00	ES	Futures	1672.46	1673.5	1667.29	1667.55	111525.0
2013-07-01 14:00:00	ES	Futures	1667.29	1669.62	1665.22	1668.58	151911.0
2013-07-01 15:00:00	ES	Futures	1668.58	1670.39	1660.57	1663.67	250707.0
2013-07-01 16:00:00	ES	Futures	1663.67	1664.19	1660.05	1661.09	71828.0
2013-07-01 17:00:00	ES	Futures	1660.83	1661.86	1660.83	1661.09	2435.0
2013-07-01 18:00:00	ES	Futures	1661.35	1662.64	1660.83	1662.12	3750.0
2013-07-01 19:00:00	ES	Futures	1662.12	1662.9	1661.6	1662.64	1873.0
2013-07-01 20:00:00	ES	Futures	1662.38	1665.74	1662.38	1665.22	7934.0
2013-07-01 21:00:00	ES	Futures	1665.22	1666.52	1663.93	1664.45	5782.0
2013-07-01 22:00:00	ES	Futures	1664.71	1664.97	1663.16	1664.45	2753.0
2013-07-01 23:00:00	ES	Futures	1664.71	1665.22	1662.38	1663.16	3506.0
2013-07-01 00:00:00	NQ	Futures	3387.89	3393.15	3387.31	3390.81	354.0
2013-07-01 01:00:00	NQ	Futures	3390.52	3397.24	3390.23	3396.37	629.0
2013-07-01 02:00:00	NQ	Futures	3396.37	3411.56	3396.07	3410.39	2662.0
2013-07-01 03:00:00	NQ	Futures	3410.68	3422.67	3410.68	3417.7	5429.0
2013-07-01 04:00:00	NQ	Futures	3417.41	3417.7	3402.79	3404.55	4940.0
2013-07-01 05:00:00	NQ	Futures	3404.84	3420.91	3404.26	3418.87	2859.0
2013-07-01 06:00:00	NQ	Futures	3419.45	3420.91	3409.81	3411.56	2786.0
2013-07-01 07:00:00	NQ	Futures	3411.56	3415.65	3409.81	3413.02	2160.0
2013-07-01 08:00:00	NQ	Futures	3413.31	3420.04	3411.27	3413.02	4464.0
2013-07-01 09:00:00	NQ	Futures	3413.02	3436.4	3412.15	3436.4	33212.0
2013-07-01 10:00:00	NQ	Futures	3435.52	3444.58	3433.77	3434.06	33135.0
2013-07-01 11:00:00	NQ	Futures	3434.06	3439.62	3432.6	3439.03	19098.0
2013-07-01 12:00:00	NQ	Futures	3439.03	3440.49	3428.8	3431.43	17379.0
2013-07-01 13:00:00	NQ	Futures	3431.43	3435.23	3423.25	3423.54	13306.0
2013-07-01 14:00:00	NQ	Futures	3423.54	3429.1	3416.82	3427.34	18697.0
2013-07-01 15:00:00	NQ	Futures	3427.34	3429.97	3412.15	3415.65	29988.0
2013-07-01 16:00:00	NQ	Futures	3415.36	3416.53	3410.39	3412.73	4789.0
2013-07-01 17:00:00	NQ	Futures	3412.73	3413.02	3411.56	3412.15	290.0
2013-07-01 18:00:00	NQ	Futures	3412.44	3415.36	3411.56	3414.48	160.0
2013-07-01 19:00:00	NQ	Futures	3414.19	3414.78	3412.73	3414.48	191.0
2013-07-01 20:00:00	NQ	Futures	3414.78	3420.33	3414.48	3419.45	638.0
2013-07-01 21:00:00	NQ	Futures	3419.45	3421.79	3416.82	3417.7	568.0
2013-07-01 22:00:00	NQ	Futures	3417.7	3419.16	3415.07	3418.58	343.0
2013-07-01 23:00:00	NQ	Futures	3418.58	3418.87	3415.07	3415.95	365.0
2013-07-01 00:00:00	YM	Futures	15043.3	15061.5	15040.2	15050.4	530.0
2013-07-01 01:00:00	YM	Futures	15050.4	15077.8	15050.4	15076.8	1036.0

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

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