PREVIEW / futures_1hour / 2009-05-07

all futures 1-hour files

  file:    by_date/futures_1hour/2009/2009-05-07.parquet
  size:    46 KB
  rows:    1,286

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-07 00:00:00	ES	Futures	874.42	877.3	874.18	876.34	4110.0
2009-05-07 01:00:00	ES	Futures	876.58	878.74	875.14	878.5	3057.0
2009-05-07 02:00:00	ES	Futures	878.74	878.74	876.34	878.26	7944.0
2009-05-07 03:00:00	ES	Futures	878.26	879.94	874.18	878.98	22326.0
2009-05-07 04:00:00	ES	Futures	879.22	881.85	878.26	881.85	18442.0
2009-05-07 05:00:00	ES	Futures	881.61	884.25	880.65	883.77	15271.0
2009-05-07 06:00:00	ES	Futures	883.77	885.45	883.05	884.25	13839.0
2009-05-07 07:00:00	ES	Futures	884.25	885.93	882.81	885.21	20873.0
2009-05-07 08:00:00	ES	Futures	885.45	890.96	884.97	885.69	87744.0
2009-05-07 09:00:00	ES	Futures	885.69	888.56	880.41	881.37	341858.0
2009-05-07 10:00:00	ES	Futures	881.37	882.81	870.83	874.66	530717.0
2009-05-07 11:00:00	ES	Futures	874.66	876.1	868.91	873.7	269412.0
2009-05-07 12:00:00	ES	Futures	873.7	874.9	870.59	873.23	132315.0
2009-05-07 13:00:00	ES	Futures	873.23	873.94	863.64	866.52	317261.0
2009-05-07 14:00:00	ES	Futures	866.76	868.19	861.48	863.64	273999.0
2009-05-07 15:00:00	ES	Futures	863.88	868.91	860.76	866.04	521908.0
2009-05-07 16:00:00	ES	Futures	866.04	870.59	865.56	867.23	122279.0
2009-05-07 17:00:00	ES	Futures	867.47	873.47	867.0	872.75	18342.0
2009-05-07 18:00:00	ES	Futures	873.47	875.62	873.23	873.7	7564.0
2009-05-07 19:00:00	ES	Futures	873.94	874.66	873.47	874.42	2173.0
2009-05-07 20:00:00	ES	Futures	874.18	877.06	873.94	875.62	6690.0
2009-05-07 21:00:00	ES	Futures	875.62	876.34	874.66	874.66	4823.0
2009-05-07 22:00:00	ES	Futures	874.9	875.62	873.47	874.9	3579.0
2009-05-07 23:00:00	ES	Futures	875.14	877.06	874.42	876.1	2168.0
2009-05-07 00:00:00	NQ	Futures	1611.07	1615.05	1610.79	1612.49	184.0
2009-05-07 01:00:00	NQ	Futures	1612.78	1617.61	1611.64	1617.61	126.0
2009-05-07 02:00:00	NQ	Futures	1616.76	1618.18	1613.91	1617.04	461.0
2009-05-07 03:00:00	NQ	Futures	1617.32	1619.88	1610.22	1618.18	1371.0
2009-05-07 04:00:00	NQ	Futures	1617.89	1623.01	1616.76	1622.15	1268.0
2009-05-07 05:00:00	NQ	Futures	1622.72	1627.55	1621.02	1626.98	1093.0
2009-05-07 06:00:00	NQ	Futures	1626.98	1628.97	1625.28	1627.55	1210.0
2009-05-07 07:00:00	NQ	Futures	1627.55	1627.55	1623.01	1626.13	2201.0
2009-05-07 08:00:00	NQ	Futures	1625.85	1634.09	1624.71	1625.0	9923.0
2009-05-07 09:00:00	NQ	Futures	1625.0	1627.84	1595.73	1596.3	57330.0
2009-05-07 10:00:00	NQ	Futures	1596.3	1599.14	1577.54	1585.22	84718.0
2009-05-07 11:00:00	NQ	Futures	1584.93	1588.34	1574.99	1584.93	39797.0
2009-05-07 12:00:00	NQ	Futures	1584.93	1586.07	1578.68	1584.65	22117.0
2009-05-07 13:00:00	NQ	Futures	1584.36	1585.5	1569.02	1571.86	40311.0
2009-05-07 14:00:00	NQ	Futures	1571.86	1574.42	1563.91	1570.16	44293.0
2009-05-07 15:00:00	NQ	Futures	1570.44	1582.94	1563.05	1576.69	67989.0
2009-05-07 16:00:00	NQ	Futures	1577.26	1586.07	1576.98	1580.67	13116.0
2009-05-07 17:00:00	NQ	Futures	1580.67	1589.76	1576.98	1586.07	1690.0
2009-05-07 18:00:00	NQ	Futures	1587.21	1589.19	1584.93	1585.22	755.0
2009-05-07 19:00:00	NQ	Futures	1585.22	1587.49	1584.36	1584.93	326.0
2009-05-07 20:00:00	NQ	Futures	1585.78	1592.04	1585.5	1588.91	822.0
2009-05-07 21:00:00	NQ	Futures	1588.91	1590.05	1587.21	1587.21	312.0
2009-05-07 22:00:00	NQ	Futures	1587.77	1588.63	1584.65	1587.49	246.0
2009-05-07 23:00:00	NQ	Futures	1587.21	1591.18	1586.64	1590.61	66.0
2009-05-07 00:00:00	YM	Futures	7745.8	7769.7	7742.1	7757.8	402.0
2009-05-07 01:00:00	YM	Futures	7758.7	7778.9	7749.5	7778.9	253.0

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

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