PREVIEW / futures_1hour / 2013-04-02

all futures 1-hour files

  file:    by_date/futures_1hour/2013/2013-04-02.parquet
  size:    50 KB
  rows:    1,566

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-04-02 00:00:00	ES	Futures	1603.72	1604.24	1603.46	1603.72	2545.0
2013-04-02 01:00:00	ES	Futures	1603.46	1604.24	1602.69	1603.2	4163.0
2013-04-02 02:00:00	ES	Futures	1603.2	1603.98	1602.43	1603.2	6000.0
2013-04-02 03:00:00	ES	Futures	1603.2	1606.81	1602.95	1606.55	35171.0
2013-04-02 04:00:00	ES	Futures	1606.3	1608.61	1606.04	1608.36	22077.0
2013-04-02 05:00:00	ES	Futures	1608.36	1610.16	1607.58	1610.16	27197.0
2013-04-02 06:00:00	ES	Futures	1610.16	1610.93	1609.39	1610.16	32542.0
2013-04-02 07:00:00	ES	Futures	1610.16	1610.42	1609.39	1610.16	23169.0
2013-04-02 08:00:00	ES	Futures	1610.42	1611.19	1608.61	1609.64	39426.0
2013-04-02 09:00:00	ES	Futures	1609.64	1612.99	1608.1	1612.22	212229.0
2013-04-02 10:00:00	ES	Futures	1611.96	1615.05	1611.19	1614.8	326452.0
2013-04-02 11:00:00	ES	Futures	1614.8	1615.57	1613.25	1613.77	168411.0
2013-04-02 12:00:00	ES	Futures	1614.02	1615.05	1613.51	1614.8	68194.0
2013-04-02 13:00:00	ES	Futures	1614.8	1615.05	1612.48	1613.77	96332.0
2013-04-02 14:00:00	ES	Futures	1613.77	1614.28	1609.64	1611.19	150370.0
2013-04-02 15:00:00	ES	Futures	1611.19	1611.96	1606.81	1611.45	274132.0
2013-04-02 16:00:00	ES	Futures	1611.45	1612.99	1610.42	1612.74	82332.0
2013-04-02 17:00:00	ES	Futures	1612.74	1613.77	1612.48	1613.51	3457.0
2013-04-02 18:00:00	ES	Futures	1613.51	1613.51	1612.48	1613.51	3638.0
2013-04-02 19:00:00	ES	Futures	1613.25	1613.51	1612.74	1612.74	2089.0
2013-04-02 20:00:00	ES	Futures	1612.99	1613.25	1612.22	1612.99	4232.0
2013-04-02 21:00:00	ES	Futures	1613.25	1613.51	1611.45	1611.96	7224.0
2013-04-02 22:00:00	ES	Futures	1611.71	1612.22	1611.19	1611.96	4042.0
2013-04-02 23:00:00	ES	Futures	1611.96	1611.96	1611.19	1611.45	1806.0
2013-04-02 00:00:00	NQ	Futures	3254.43	3255.01	3253.56	3254.14	181.0
2013-04-02 01:00:00	NQ	Futures	3254.43	3254.72	3252.68	3253.26	214.0
2013-04-02 02:00:00	NQ	Futures	3253.26	3255.31	3252.68	3253.56	533.0
2013-04-02 03:00:00	NQ	Futures	3253.56	3260.85	3253.56	3260.56	3207.0
2013-04-02 04:00:00	NQ	Futures	3260.56	3269.01	3260.56	3268.43	3222.0
2013-04-02 05:00:00	NQ	Futures	3268.43	3274.26	3267.85	3273.97	4034.0
2013-04-02 06:00:00	NQ	Futures	3273.97	3275.14	3272.51	3272.51	4052.0
2013-04-02 07:00:00	NQ	Futures	3272.51	3275.72	3272.22	3274.26	2575.0
2013-04-02 08:00:00	NQ	Futures	3274.56	3276.01	3270.18	3271.64	6184.0
2013-04-02 09:00:00	NQ	Futures	3271.64	3286.22	3269.6	3283.6	34737.0
2013-04-02 10:00:00	NQ	Futures	3283.89	3292.64	3281.56	3289.72	41781.0
2013-04-02 11:00:00	NQ	Futures	3290.01	3293.51	3286.81	3288.85	20000.0
2013-04-02 12:00:00	NQ	Futures	3288.56	3293.51	3287.97	3292.06	12248.0
2013-04-02 13:00:00	NQ	Futures	3291.76	3292.64	3286.22	3287.97	14874.0
2013-04-02 14:00:00	NQ	Futures	3287.68	3290.01	3275.43	3279.81	27082.0
2013-04-02 15:00:00	NQ	Futures	3280.1	3283.31	3272.81	3281.85	28788.0
2013-04-02 16:00:00	NQ	Futures	3281.85	3284.76	3280.97	3283.01	6488.0
2013-04-02 17:00:00	NQ	Futures	3283.01	3285.06	3282.72	3284.76	223.0
2013-04-02 18:00:00	NQ	Futures	3283.31	3284.47	3282.72	3284.18	449.0
2013-04-02 19:00:00	NQ	Futures	3284.18	3284.76	3283.31	3283.31	119.0
2013-04-02 20:00:00	NQ	Futures	3283.31	3284.76	3282.43	3284.18	363.0
2013-04-02 21:00:00	NQ	Futures	3284.47	3284.76	3282.72	3283.01	646.0
2013-04-02 22:00:00	NQ	Futures	3283.01	3283.31	3281.85	3282.43	365.0
2013-04-02 23:00:00	NQ	Futures	3282.43	3283.31	3281.85	3282.72	188.0
2013-04-02 00:00:00	YM	Futures	14664.8	14666.8	14659.7	14661.7	215.0
2013-04-02 01:00:00	YM	Futures	14660.7	14663.8	14655.7	14656.7	313.0

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

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