PREVIEW / futures_1hour / 2009-05-27

all futures 1-hour files

  file:    by_date/futures_1hour/2009/2009-05-27.parquet
  size:    42 KB
  rows:    1,233

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-27 00:00:00	ES	Futures	872.51	872.51	868.91	871.07	5541.0
2009-05-27 01:00:00	ES	Futures	871.07	872.03	868.91	869.63	2515.0
2009-05-27 02:00:00	ES	Futures	869.63	870.83	868.43	870.35	8489.0
2009-05-27 03:00:00	ES	Futures	870.59	873.94	869.87	873.47	21620.0
2009-05-27 04:00:00	ES	Futures	873.23	873.94	871.31	871.55	14661.0
2009-05-27 05:00:00	ES	Futures	871.31	875.14	870.11	874.9	15169.0
2009-05-27 06:00:00	ES	Futures	874.9	876.1	872.51	874.66	14891.0
2009-05-27 07:00:00	ES	Futures	874.42	874.42	870.59	870.59	16101.0
2009-05-27 08:00:00	ES	Futures	870.59	873.23	867.95	870.83	49787.0
2009-05-27 09:00:00	ES	Futures	870.83	872.75	868.19	871.79	201503.0
2009-05-27 10:00:00	ES	Futures	871.79	874.9	867.23	872.27	447228.0
2009-05-27 11:00:00	ES	Futures	872.27	873.94	868.91	872.51	241571.0
2009-05-27 12:00:00	ES	Futures	872.51	874.9	869.63	870.59	177471.0
2009-05-27 13:00:00	ES	Futures	870.35	872.99	861.24	863.88	251648.0
2009-05-27 14:00:00	ES	Futures	863.88	864.84	859.09	861.72	302319.0
2009-05-27 15:00:00	ES	Futures	861.72	864.6	853.58	855.01	499879.0
2009-05-27 16:00:00	ES	Futures	855.01	857.17	853.82	854.05	99534.0
2009-05-27 17:00:00	ES	Futures	854.05	855.49	853.82	855.25	2852.0
2009-05-27 18:00:00	ES	Futures	855.25	855.49	851.66	851.66	9029.0
2009-05-27 19:00:00	ES	Futures	851.66	853.1	851.66	853.1	2715.0
2009-05-27 20:00:00	ES	Futures	852.86	854.77	852.86	854.53	5330.0
2009-05-27 21:00:00	ES	Futures	854.29	856.45	854.05	855.73	4789.0
2009-05-27 22:00:00	ES	Futures	855.73	855.73	854.05	854.05	2866.0
2009-05-27 23:00:00	ES	Futures	854.05	857.41	852.86	856.69	6243.0
2009-05-27 00:00:00	NQ	Futures	1604.82	1605.67	1601.41	1603.69	297.0
2009-05-27 01:00:00	NQ	Futures	1603.97	1605.39	1602.26	1602.55	206.0
2009-05-27 02:00:00	NQ	Futures	1603.12	1605.67	1601.13	1604.25	435.0
2009-05-27 03:00:00	NQ	Futures	1604.82	1608.52	1601.13	1605.67	2004.0
2009-05-27 04:00:00	NQ	Futures	1605.39	1607.66	1603.69	1603.69	934.0
2009-05-27 05:00:00	NQ	Futures	1603.69	1607.09	1601.98	1606.53	1677.0
2009-05-27 06:00:00	NQ	Futures	1606.53	1608.52	1601.13	1605.39	1236.0
2009-05-27 07:00:00	NQ	Futures	1605.39	1605.39	1600.56	1600.56	1614.0
2009-05-27 08:00:00	NQ	Futures	1600.56	1606.24	1596.01	1600.56	5447.0
2009-05-27 09:00:00	NQ	Futures	1600.56	1613.91	1596.01	1611.07	37267.0
2009-05-27 10:00:00	NQ	Futures	1611.07	1623.01	1604.25	1622.15	57024.0
2009-05-27 11:00:00	NQ	Futures	1621.87	1622.72	1615.62	1620.73	27311.0
2009-05-27 12:00:00	NQ	Futures	1620.73	1623.86	1613.63	1615.34	31298.0
2009-05-27 13:00:00	NQ	Futures	1615.34	1619.6	1597.43	1603.12	32939.0
2009-05-27 14:00:00	NQ	Futures	1603.12	1607.09	1596.3	1601.7	34602.0
2009-05-27 15:00:00	NQ	Futures	1601.7	1607.66	1588.63	1593.46	57881.0
2009-05-27 16:00:00	NQ	Futures	1593.46	1596.58	1591.47	1592.6	6969.0
2009-05-27 17:00:00	NQ	Futures	1592.6	1593.74	1591.47	1593.74	175.0
2009-05-27 18:00:00	NQ	Futures	1594.31	1594.31	1588.91	1589.48	260.0
2009-05-27 19:00:00	NQ	Futures	1589.48	1591.47	1589.19	1590.9	74.0
2009-05-27 20:00:00	NQ	Futures	1591.47	1595.45	1591.47	1594.59	174.0
2009-05-27 21:00:00	NQ	Futures	1594.31	1598.0	1594.02	1595.73	162.0
2009-05-27 22:00:00	NQ	Futures	1595.73	1596.01	1594.31	1594.59	157.0
2009-05-27 23:00:00	NQ	Futures	1594.02	1599.71	1591.47	1598.0	207.0
2009-05-27 00:00:00	YM	Futures	7787.2	7787.2	7759.6	7777.1	397.0
2009-05-27 01:00:00	YM	Futures	7777.1	7782.6	7761.4	7764.2	177.0

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

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