PREVIEW / futures_1hour / 2009-05-26

all futures 1-hour files

  file:    by_date/futures_1hour/2009/2009-05-26.parquet
  size:    44 KB
  rows:    1,288

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-26 00:00:00	ES	Futures	846.87	848.3	846.87	848.06	1442.0
2009-05-26 01:00:00	ES	Futures	848.06	850.46	847.11	849.26	2466.0
2009-05-26 02:00:00	ES	Futures	849.26	849.74	847.11	847.58	4508.0
2009-05-26 03:00:00	ES	Futures	847.58	848.54	845.19	846.15	20228.0
2009-05-26 04:00:00	ES	Futures	845.91	847.58	844.47	844.95	14661.0
2009-05-26 05:00:00	ES	Futures	844.95	846.15	843.27	845.67	10498.0
2009-05-26 06:00:00	ES	Futures	845.91	846.15	840.4	842.07	22115.0
2009-05-26 07:00:00	ES	Futures	842.07	845.91	841.59	844.47	19578.0
2009-05-26 08:00:00	ES	Futures	844.71	847.82	844.47	845.43	41569.0
2009-05-26 09:00:00	ES	Futures	845.43	851.9	841.83	851.18	369447.0
2009-05-26 10:00:00	ES	Futures	851.42	866.76	851.42	864.84	681482.0
2009-05-26 11:00:00	ES	Futures	864.84	867.95	863.64	866.52	221445.0
2009-05-26 12:00:00	ES	Futures	866.52	871.55	865.32	870.35	172102.0
2009-05-26 13:00:00	ES	Futures	870.35	872.03	868.91	871.55	150279.0
2009-05-26 14:00:00	ES	Futures	871.55	873.23	868.91	868.91	196302.0
2009-05-26 15:00:00	ES	Futures	868.91	871.79	865.8	870.83	447965.0
2009-05-26 16:00:00	ES	Futures	871.07	872.51	869.63	871.31	117298.0
2009-05-26 17:00:00	ES	Futures	871.31	872.03	870.83	871.55	1664.0
2009-05-26 18:00:00	ES	Futures	871.31	871.55	870.35	871.07	2238.0
2009-05-26 19:00:00	ES	Futures	871.31	872.27	870.59	870.59	2611.0
2009-05-26 20:00:00	ES	Futures	870.59	870.83	868.19	868.43	6073.0
2009-05-26 21:00:00	ES	Futures	868.19	870.11	867.71	869.39	6672.0
2009-05-26 22:00:00	ES	Futures	869.39	870.83	869.15	870.59	2857.0
2009-05-26 23:00:00	ES	Futures	870.35	872.75	870.11	872.51	4218.0
2009-05-26 00:00:00	NQ	Futures	1536.63	1538.9	1536.63	1538.9	82.0
2009-05-26 01:00:00	NQ	Futures	1538.9	1542.6	1537.48	1541.17	86.0
2009-05-26 02:00:00	NQ	Futures	1540.89	1542.31	1537.48	1537.48	323.0
2009-05-26 03:00:00	NQ	Futures	1538.05	1540.04	1534.64	1536.63	1291.0
2009-05-26 04:00:00	NQ	Futures	1536.63	1538.33	1532.93	1533.79	1254.0
2009-05-26 05:00:00	NQ	Futures	1533.79	1536.06	1530.09	1535.21	959.0
2009-05-26 06:00:00	NQ	Futures	1535.78	1535.78	1526.12	1528.39	1884.0
2009-05-26 07:00:00	NQ	Futures	1527.82	1536.63	1526.97	1535.78	2928.0
2009-05-26 08:00:00	NQ	Futures	1535.78	1543.16	1535.78	1539.47	5152.0
2009-05-26 09:00:00	NQ	Futures	1539.47	1568.45	1529.81	1567.32	69255.0
2009-05-26 10:00:00	NQ	Futures	1567.6	1597.72	1567.6	1594.02	101078.0
2009-05-26 11:00:00	NQ	Futures	1593.74	1601.41	1591.18	1599.99	35649.0
2009-05-26 12:00:00	NQ	Futures	1599.99	1604.82	1596.58	1602.55	25925.0
2009-05-26 13:00:00	NQ	Futures	1602.55	1607.38	1600.56	1606.24	26122.0
2009-05-26 14:00:00	NQ	Futures	1605.96	1607.66	1599.14	1599.71	24821.0
2009-05-26 15:00:00	NQ	Futures	1599.42	1606.53	1595.45	1604.82	54443.0
2009-05-26 16:00:00	NQ	Futures	1605.11	1607.09	1601.41	1604.54	12901.0
2009-05-26 17:00:00	NQ	Futures	1604.25	1608.23	1602.55	1605.67	219.0
2009-05-26 18:00:00	NQ	Futures	1604.25	1604.82	1602.55	1604.82	175.0
2009-05-26 19:00:00	NQ	Futures	1604.82	1606.81	1603.97	1604.54	275.0
2009-05-26 20:00:00	NQ	Futures	1603.69	1604.54	1599.99	1600.56	423.0
2009-05-26 21:00:00	NQ	Futures	1600.56	1602.26	1599.42	1601.98	361.0
2009-05-26 22:00:00	NQ	Futures	1601.7	1603.69	1601.13	1602.26	177.0
2009-05-26 23:00:00	NQ	Futures	1602.83	1606.53	1601.98	1604.82	211.0
2009-05-26 00:00:00	YM	Futures	7579.5	7590.5	7579.5	7590.5	125.0
2009-05-26 01:00:00	YM	Futures	7589.6	7606.1	7581.3	7597.0	324.0

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

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