PREVIEW / futures_1hour / 2009-05-19

all futures 1-hour files

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

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-19 00:00:00	ES	Futures	870.59	872.27	869.15	869.63	5648.0
2009-05-19 01:00:00	ES	Futures	869.63	872.99	869.15	872.27	3772.0
2009-05-19 02:00:00	ES	Futures	872.03	873.23	871.31	871.55	9027.0
2009-05-19 03:00:00	ES	Futures	871.55	872.27	869.39	871.31	22364.0
2009-05-19 04:00:00	ES	Futures	871.31	875.14	870.83	873.94	21171.0
2009-05-19 05:00:00	ES	Futures	874.18	876.58	871.79	874.42	19129.0
2009-05-19 06:00:00	ES	Futures	874.66	877.78	873.94	876.58	19583.0
2009-05-19 07:00:00	ES	Futures	876.34	876.58	873.47	874.18	21319.0
2009-05-19 08:00:00	ES	Futures	874.18	875.14	868.67	869.15	77054.0
2009-05-19 09:00:00	ES	Futures	869.39	872.27	866.52	866.52	279917.0
2009-05-19 10:00:00	ES	Futures	866.52	876.34	866.04	873.23	367702.0
2009-05-19 11:00:00	ES	Futures	873.23	875.14	870.35	873.7	175161.0
2009-05-19 12:00:00	ES	Futures	873.7	875.38	870.83	870.83	141033.0
2009-05-19 13:00:00	ES	Futures	870.83	876.1	870.83	873.47	151656.0
2009-05-19 14:00:00	ES	Futures	873.23	877.06	871.31	875.14	200105.0
2009-05-19 15:00:00	ES	Futures	875.14	877.06	867.95	868.91	341656.0
2009-05-19 16:00:00	ES	Futures	868.91	870.83	866.52	866.52	101883.0
2009-05-19 17:00:00	ES	Futures	866.76	867.0	864.84	865.8	6283.0
2009-05-19 18:00:00	ES	Futures	866.28	868.19	866.04	867.0	6159.0
2009-05-19 19:00:00	ES	Futures	867.0	868.91	867.0	868.67	4406.0
2009-05-19 20:00:00	ES	Futures	868.67	868.91	865.56	866.04	4634.0
2009-05-19 21:00:00	ES	Futures	865.8	866.28	865.08	866.28	2710.0
2009-05-19 22:00:00	ES	Futures	866.28	866.52	865.08	866.28	4900.0
2009-05-19 23:00:00	ES	Futures	866.04	866.52	865.56	866.28	2138.0
2009-05-19 00:00:00	NQ	Futures	1578.68	1581.52	1575.27	1575.27	289.0
2009-05-19 01:00:00	NQ	Futures	1575.56	1580.67	1574.99	1579.53	373.0
2009-05-19 02:00:00	NQ	Futures	1579.25	1583.51	1578.68	1580.95	521.0
2009-05-19 03:00:00	NQ	Futures	1580.95	1581.24	1576.12	1579.53	1533.0
2009-05-19 04:00:00	NQ	Futures	1579.53	1585.22	1578.68	1583.51	1749.0
2009-05-19 05:00:00	NQ	Futures	1582.94	1587.77	1579.82	1585.22	1401.0
2009-05-19 06:00:00	NQ	Futures	1584.93	1589.48	1584.36	1587.21	1417.0
2009-05-19 07:00:00	NQ	Futures	1587.21	1587.49	1579.82	1580.95	3214.0
2009-05-19 08:00:00	NQ	Futures	1580.95	1581.81	1572.43	1573.0	8481.0
2009-05-19 09:00:00	NQ	Futures	1573.28	1581.81	1567.32	1572.15	40642.0
2009-05-19 10:00:00	NQ	Futures	1572.71	1590.9	1570.73	1585.22	46760.0
2009-05-19 11:00:00	NQ	Futures	1584.93	1587.49	1578.97	1584.65	23572.0
2009-05-19 12:00:00	NQ	Futures	1584.93	1590.9	1583.51	1585.22	18811.0
2009-05-19 13:00:00	NQ	Futures	1585.22	1599.99	1585.22	1595.16	30996.0
2009-05-19 14:00:00	NQ	Futures	1595.16	1603.12	1591.47	1598.85	27516.0
2009-05-19 15:00:00	NQ	Futures	1598.85	1601.13	1585.5	1586.64	44725.0
2009-05-19 16:00:00	NQ	Futures	1586.64	1590.9	1576.41	1580.1	13884.0
2009-05-19 17:00:00	NQ	Futures	1580.95	1580.95	1577.54	1578.68	736.0
2009-05-19 18:00:00	NQ	Futures	1579.25	1582.09	1578.11	1579.53	357.0
2009-05-19 19:00:00	NQ	Futures	1579.53	1582.66	1578.97	1582.66	207.0
2009-05-19 20:00:00	NQ	Futures	1581.81	1582.37	1576.69	1577.54	196.0
2009-05-19 21:00:00	NQ	Futures	1577.54	1578.97	1575.84	1578.68	132.0
2009-05-19 22:00:00	NQ	Futures	1578.97	1578.97	1576.69	1578.11	141.0
2009-05-19 23:00:00	NQ	Futures	1577.83	1578.68	1577.83	1578.68	153.0
2009-05-19 00:00:00	YM	Futures	7787.2	7800.0	7776.1	7778.9	384.0
2009-05-19 01:00:00	YM	Futures	7779.8	7805.6	7776.1	7797.3	346.0

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

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