PREVIEW / futures_1hour / 2013-09-09

all futures 1-hour files

  file:    by_date/futures_1hour/2013/2013-09-09.parquet
  size:    47 KB
  rows:    1,463

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-09-09 00:00:00	ES	Futures	1714.34	1714.6	1713.82	1714.08	1000.0
2013-09-09 01:00:00	ES	Futures	1714.08	1714.85	1713.56	1714.85	2183.0
2013-09-09 02:00:00	ES	Futures	1714.85	1715.63	1714.08	1715.11	6421.0
2013-09-09 03:00:00	ES	Futures	1714.85	1715.37	1712.79	1714.08	19699.0
2013-09-09 04:00:00	ES	Futures	1714.34	1716.15	1713.56	1715.63	17754.0
2013-09-09 05:00:00	ES	Futures	1715.89	1715.89	1712.79	1713.05	15041.0
2013-09-09 06:00:00	ES	Futures	1713.05	1715.37	1712.53	1712.53	13530.0
2013-09-09 07:00:00	ES	Futures	1712.53	1714.85	1712.27	1713.3	17478.0
2013-09-09 08:00:00	ES	Futures	1713.56	1714.6	1712.79	1714.6	19772.0
2013-09-09 09:00:00	ES	Futures	1714.6	1721.32	1714.08	1720.54	194479.0
2013-09-09 10:00:00	ES	Futures	1720.28	1721.83	1716.66	1718.47	205701.0
2013-09-09 11:00:00	ES	Futures	1718.47	1721.32	1717.44	1720.54	181435.0
2013-09-09 12:00:00	ES	Futures	1720.54	1723.64	1720.28	1722.61	137266.0
2013-09-09 13:00:00	ES	Futures	1722.35	1725.19	1721.83	1724.94	93901.0
2013-09-09 14:00:00	ES	Futures	1724.94	1728.55	1724.94	1726.49	175475.0
2013-09-09 15:00:00	ES	Futures	1726.49	1728.3	1725.45	1727.26	182706.0
2013-09-09 16:00:00	ES	Futures	1727.26	1728.04	1724.94	1727.26	101731.0
2013-09-09 17:00:00	ES	Futures	1727.0	1728.04	1727.0	1727.78	4251.0
2013-09-09 18:00:00	ES	Futures	1727.78	1729.07	1727.26	1728.04	6893.0
2013-09-09 19:00:00	ES	Futures	1728.04	1729.07	1727.78	1728.81	3057.0
2013-09-09 20:00:00	ES	Futures	1728.55	1728.55	1727.52	1727.78	4198.0
2013-09-09 21:00:00	ES	Futures	1727.52	1727.78	1725.71	1726.23	5913.0
2013-09-09 22:00:00	ES	Futures	1726.23	1728.04	1726.23	1726.75	3104.0
2013-09-09 23:00:00	ES	Futures	1726.75	1727.0	1725.71	1726.49	5086.0
2013-09-09 00:00:00	NQ	Futures	3671.65	3672.24	3670.77	3671.07	197.0
2013-09-09 01:00:00	NQ	Futures	3671.36	3672.53	3670.48	3672.53	438.0
2013-09-09 02:00:00	NQ	Futures	3672.24	3674.87	3671.94	3673.11	625.0
2013-09-09 03:00:00	NQ	Futures	3673.11	3674.87	3669.9	3673.4	2664.0
2013-09-09 04:00:00	NQ	Futures	3673.7	3677.79	3673.11	3676.62	3260.0
2013-09-09 05:00:00	NQ	Futures	3676.91	3676.91	3672.24	3672.82	2590.0
2013-09-09 06:00:00	NQ	Futures	3672.82	3678.08	3671.65	3671.65	2234.0
2013-09-09 07:00:00	NQ	Futures	3671.65	3677.5	3670.77	3674.57	3024.0
2013-09-09 08:00:00	NQ	Futures	3674.87	3676.33	3671.94	3675.74	3149.0
2013-09-09 09:00:00	NQ	Futures	3675.74	3690.35	3674.57	3687.72	31728.0
2013-09-09 10:00:00	NQ	Futures	3688.02	3690.06	3677.79	3682.76	27554.0
2013-09-09 11:00:00	NQ	Futures	3682.46	3693.28	3680.13	3690.65	19680.0
2013-09-09 12:00:00	NQ	Futures	3690.94	3698.83	3690.94	3695.61	18346.0
2013-09-09 13:00:00	NQ	Futures	3695.32	3702.04	3693.86	3701.46	14201.0
2013-09-09 14:00:00	NQ	Futures	3701.46	3711.69	3701.17	3706.43	26259.0
2013-09-09 15:00:00	NQ	Futures	3706.43	3709.93	3702.92	3704.38	25596.0
2013-09-09 16:00:00	NQ	Futures	3704.38	3707.89	3700.29	3705.55	7278.0
2013-09-09 17:00:00	NQ	Futures	3705.55	3707.89	3705.26	3707.89	159.0
2013-09-09 18:00:00	NQ	Futures	3707.3	3709.64	3704.38	3705.26	724.0
2013-09-09 19:00:00	NQ	Futures	3705.26	3707.3	3704.67	3707.01	287.0
2013-09-09 20:00:00	NQ	Futures	3706.72	3707.3	3704.09	3704.38	630.0
2013-09-09 21:00:00	NQ	Futures	3704.38	3704.97	3702.34	3704.09	489.0
2013-09-09 22:00:00	NQ	Futures	3703.8	3707.01	3703.8	3704.09	306.0
2013-09-09 23:00:00	NQ	Futures	3704.67	3705.55	3702.63	3704.97	473.0
2013-09-09 00:00:00	YM	Futures	15178.3	15180.4	15175.3	15175.3	246.0
2013-09-09 01:00:00	YM	Futures	15177.3	15180.4	15170.2	15177.3	489.0

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

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