PREVIEW / futures_1hour / 2009-05-20

all futures 1-hour files

  file:    by_date/futures_1hour/2009/2009-05-20.parquet
  size:    43 KB
  rows:    1,237

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-20 00:00:00	ES	Futures	866.04	867.47	865.8	866.76	2312.0
2009-05-20 01:00:00	ES	Futures	866.76	867.47	865.8	867.23	1415.0
2009-05-20 02:00:00	ES	Futures	867.23	868.91	866.52	868.43	6829.0
2009-05-20 03:00:00	ES	Futures	868.43	875.62	868.19	873.7	32407.0
2009-05-20 04:00:00	ES	Futures	873.47	875.62	872.27	873.94	13442.0
2009-05-20 05:00:00	ES	Futures	873.7	874.66	871.31	871.31	8667.0
2009-05-20 06:00:00	ES	Futures	871.31	873.7	869.63	872.99	16111.0
2009-05-20 07:00:00	ES	Futures	873.23	875.14	870.83	873.47	22011.0
2009-05-20 08:00:00	ES	Futures	873.47	875.86	873.47	875.14	35316.0
2009-05-20 09:00:00	ES	Futures	875.38	882.57	874.66	881.37	326902.0
2009-05-20 10:00:00	ES	Futures	881.37	885.21	880.41	880.65	417701.0
2009-05-20 11:00:00	ES	Futures	880.65	881.61	872.99	872.99	322170.0
2009-05-20 12:00:00	ES	Futures	873.23	874.66	870.11	870.35	253320.0
2009-05-20 13:00:00	ES	Futures	870.35	875.86	869.39	874.66	226215.0
2009-05-20 14:00:00	ES	Futures	874.66	876.58	870.35	874.18	381645.0
2009-05-20 15:00:00	ES	Futures	874.42	874.42	861.96	863.4	562551.0
2009-05-20 16:00:00	ES	Futures	863.64	864.36	861.48	863.4	110855.0
2009-05-20 17:00:00	ES	Futures	863.16	863.16	861.96	862.92	1863.0
2009-05-20 18:00:00	ES	Futures	862.92	863.4	861.0	861.24	4508.0
2009-05-20 19:00:00	ES	Futures	861.24	862.68	860.29	861.96	3098.0
2009-05-20 20:00:00	ES	Futures	861.72	862.2	859.33	859.57	4405.0
2009-05-20 21:00:00	ES	Futures	859.57	860.05	858.37	859.57	4266.0
2009-05-20 22:00:00	ES	Futures	859.33	860.52	858.61	859.09	4206.0
2009-05-20 23:00:00	ES	Futures	858.85	859.33	858.37	858.85	2594.0
2009-05-20 00:00:00	NQ	Futures	1578.68	1580.39	1578.4	1580.39	134.0
2009-05-20 01:00:00	NQ	Futures	1579.82	1582.09	1578.68	1582.09	95.0
2009-05-20 02:00:00	NQ	Futures	1582.09	1584.36	1579.82	1583.51	357.0
2009-05-20 03:00:00	NQ	Futures	1583.51	1594.31	1583.51	1591.18	2219.0
2009-05-20 04:00:00	NQ	Futures	1591.47	1595.16	1589.19	1592.89	680.0
2009-05-20 05:00:00	NQ	Futures	1592.6	1593.46	1585.78	1586.64	1304.0
2009-05-20 06:00:00	NQ	Futures	1586.35	1589.48	1582.94	1588.06	1620.0
2009-05-20 07:00:00	NQ	Futures	1588.34	1591.75	1584.93	1588.34	2030.0
2009-05-20 08:00:00	NQ	Futures	1588.34	1593.74	1588.06	1592.04	5170.0
2009-05-20 09:00:00	NQ	Futures	1592.04	1609.37	1590.05	1605.96	40247.0
2009-05-20 10:00:00	NQ	Futures	1605.96	1617.32	1605.67	1611.36	48281.0
2009-05-20 11:00:00	NQ	Futures	1611.36	1614.2	1599.42	1599.99	41638.0
2009-05-20 12:00:00	NQ	Futures	1599.99	1602.83	1587.49	1588.06	37655.0
2009-05-20 13:00:00	NQ	Futures	1587.77	1599.71	1585.5	1599.14	35207.0
2009-05-20 14:00:00	NQ	Futures	1599.14	1604.25	1591.18	1600.56	45478.0
2009-05-20 15:00:00	NQ	Futures	1600.56	1600.56	1577.54	1582.94	60052.0
2009-05-20 16:00:00	NQ	Futures	1582.37	1584.93	1580.1	1583.23	7123.0
2009-05-20 17:00:00	NQ	Futures	1583.51	1583.51	1580.95	1581.24	131.0
2009-05-20 18:00:00	NQ	Futures	1580.95	1582.09	1577.83	1579.82	300.0
2009-05-20 19:00:00	NQ	Futures	1578.97	1582.66	1577.26	1579.53	175.0
2009-05-20 20:00:00	NQ	Futures	1579.53	1579.53	1575.84	1575.84	159.0
2009-05-20 21:00:00	NQ	Futures	1575.84	1576.98	1574.42	1576.98	168.0
2009-05-20 22:00:00	NQ	Futures	1576.98	1578.4	1575.56	1576.41	186.0
2009-05-20 23:00:00	NQ	Futures	1576.41	1576.98	1575.56	1576.41	177.0
2009-05-20 00:00:00	YM	Futures	7749.5	7757.8	7747.7	7754.1	150.0
2009-05-20 01:00:00	YM	Futures	7755.9	7759.6	7748.6	7759.6	127.0

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

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