PREVIEW / futures_1hour / 2009-05-29

all futures 1-hour files

  file:    by_date/futures_1hour/2009/2009-05-29.parquet
  size:    36 KB
  rows:    987

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
2009-05-29 00:00:00	ES	Futures	866.04	867.47	865.56	867.23	1674.0
2009-05-29 01:00:00	ES	Futures	867.23	868.91	866.76	868.67	2601.0
2009-05-29 02:00:00	ES	Futures	868.67	872.51	868.19	871.31	12554.0
2009-05-29 03:00:00	ES	Futures	871.31	871.79	869.63	870.11	13147.0
2009-05-29 04:00:00	ES	Futures	870.11	871.31	868.43	870.35	10291.0
2009-05-29 05:00:00	ES	Futures	870.11	873.23	870.11	872.27	10546.0
2009-05-29 06:00:00	ES	Futures	872.27	874.18	871.31	873.7	11631.0
2009-05-29 07:00:00	ES	Futures	873.47	875.62	873.23	873.23	23653.0
2009-05-29 08:00:00	ES	Futures	873.23	874.42	871.31	871.55	37386.0
2009-05-29 09:00:00	ES	Futures	871.55	874.42	864.84	869.15	351398.0
2009-05-29 10:00:00	ES	Futures	869.15	873.7	866.76	871.07	317427.0
2009-05-29 11:00:00	ES	Futures	870.83	871.79	865.8	866.76	219024.0
2009-05-29 12:00:00	ES	Futures	866.76	870.59	866.52	868.43	114830.0
2009-05-29 13:00:00	ES	Futures	868.43	872.27	868.43	870.83	79205.0
2009-05-29 14:00:00	ES	Futures	870.59	872.03	866.04	867.95	96834.0
2009-05-29 15:00:00	ES	Futures	868.19	884.49	867.23	883.29	474138.0
2009-05-29 16:00:00	ES	Futures	883.53	889.28	881.13	883.53	205716.0
2009-05-29 00:00:00	NQ	Futures	1608.8	1610.79	1608.52	1610.79	91.0
2009-05-29 01:00:00	NQ	Futures	1611.07	1613.91	1609.94	1611.93	105.0
2009-05-29 02:00:00	NQ	Futures	1611.93	1620.73	1611.64	1618.46	950.0
2009-05-29 03:00:00	NQ	Futures	1618.18	1620.17	1615.9	1618.46	1096.0
2009-05-29 04:00:00	NQ	Futures	1618.18	1619.31	1615.34	1618.18	1063.0
2009-05-29 05:00:00	NQ	Futures	1617.61	1621.87	1615.9	1619.31	1093.0
2009-05-29 06:00:00	NQ	Futures	1619.03	1624.14	1617.89	1623.01	1564.0
2009-05-29 07:00:00	NQ	Futures	1623.29	1630.11	1621.87	1622.15	2321.0
2009-05-29 08:00:00	NQ	Futures	1622.15	1623.01	1614.2	1615.34	4738.0
2009-05-29 09:00:00	NQ	Futures	1615.34	1626.7	1607.38	1616.19	53567.0
2009-05-29 10:00:00	NQ	Futures	1616.19	1622.15	1612.21	1616.76	38614.0
2009-05-29 11:00:00	NQ	Futures	1616.47	1618.74	1603.69	1605.11	43754.0
2009-05-29 12:00:00	NQ	Futures	1605.39	1612.21	1605.11	1607.38	21251.0
2009-05-29 13:00:00	NQ	Futures	1607.38	1615.9	1607.38	1612.78	14630.0
2009-05-29 14:00:00	NQ	Futures	1613.06	1615.9	1605.11	1609.37	15126.0
2009-05-29 15:00:00	NQ	Futures	1609.37	1634.09	1607.66	1633.8	48348.0
2009-05-29 16:00:00	NQ	Futures	1634.09	1639.77	1626.13	1633.24	22227.0
2009-05-29 00:00:00	YM	Futures	7687.9	7702.6	7687.9	7702.6	183.0
2009-05-29 01:00:00	YM	Futures	7700.8	7713.7	7696.2	7711.8	201.0
2009-05-29 02:00:00	YM	Futures	7711.8	7741.2	7708.1	7733.0	681.0
2009-05-29 03:00:00	YM	Futures	7732.0	7737.6	7716.4	7724.7	1132.0
2009-05-29 04:00:00	YM	Futures	7723.8	7733.9	7710.9	7727.4	771.0
2009-05-29 05:00:00	YM	Futures	7725.6	7750.4	7723.8	7741.2	753.0
2009-05-29 06:00:00	YM	Futures	7739.4	7755.0	7734.8	7751.3	577.0
2009-05-29 07:00:00	YM	Futures	7753.2	7767.9	7747.7	7750.4	1229.0
2009-05-29 08:00:00	YM	Futures	7751.3	7758.7	7732.0	7733.9	2177.0
2009-05-29 09:00:00	YM	Futures	7733.0	7767.0	7679.7	7714.6	25064.0
2009-05-29 10:00:00	YM	Futures	7715.5	7744.0	7694.4	7722.8	21931.0
2009-05-29 11:00:00	YM	Futures	7721.9	7728.4	7675.1	7682.4	22066.0
2009-05-29 12:00:00	YM	Futures	7681.5	7712.7	7679.7	7697.1	14446.0
2009-05-29 13:00:00	YM	Futures	7698.0	7729.3	7697.1	7719.2	9176.0
2009-05-29 14:00:00	YM	Futures	7719.2	7733.0	7688.8	7705.4	8627.0
2009-05-29 15:00:00	YM	Futures	7705.4	7835.0	7696.2	7826.7	24297.0

> showing 50 of 987 rows — these rows as CSV

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