PREVIEW / futures_1hour / 2009-06-18

all futures 1-hour files

  file:    by_date/futures_1hour/2009/2009-06-18.parquet
  size:    42 KB
  rows:    1,234

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-06-18 00:00:00	ES	Futures	875.43	875.91	873.5	873.98	2882.0
2009-06-18 01:00:00	ES	Futures	873.98	876.4	873.74	876.16	2146.0
2009-06-18 02:00:00	ES	Futures	875.91	879.05	875.19	878.08	6524.0
2009-06-18 03:00:00	ES	Futures	878.08	880.01	875.19	875.91	17309.0
2009-06-18 04:00:00	ES	Futures	875.67	876.88	872.78	874.23	19365.0
2009-06-18 05:00:00	ES	Futures	874.23	876.16	873.74	875.19	8308.0
2009-06-18 06:00:00	ES	Futures	875.19	876.16	871.57	871.81	11530.0
2009-06-18 07:00:00	ES	Futures	871.81	875.67	871.33	871.81	21008.0
2009-06-18 08:00:00	ES	Futures	871.81	877.36	871.09	876.4	59785.0
2009-06-18 09:00:00	ES	Futures	876.4	881.22	871.57	880.5	259400.0
2009-06-18 10:00:00	ES	Futures	880.5	883.87	878.57	879.53	335165.0
2009-06-18 11:00:00	ES	Futures	879.53	882.43	879.05	881.7	161464.0
2009-06-18 12:00:00	ES	Futures	881.7	883.39	880.26	883.39	94142.0
2009-06-18 13:00:00	ES	Futures	883.39	885.32	882.18	882.43	135912.0
2009-06-18 14:00:00	ES	Futures	882.43	883.39	880.01	883.39	169226.0
2009-06-18 15:00:00	ES	Futures	883.39	885.08	878.81	880.5	243583.0
2009-06-18 16:00:00	ES	Futures	880.26	882.18	878.81	880.98	95660.0
2009-06-18 17:00:00	ES	Futures	880.98	881.94	880.74	881.7	1719.0
2009-06-18 18:00:00	ES	Futures	882.43	882.91	882.18	882.91	3656.0
2009-06-18 19:00:00	ES	Futures	882.67	883.15	882.43	882.91	1118.0
2009-06-18 20:00:00	ES	Futures	883.15	883.63	882.43	882.91	3779.0
2009-06-18 21:00:00	ES	Futures	882.91	883.39	881.46	881.94	1907.0
2009-06-18 22:00:00	ES	Futures	881.94	882.67	881.22	881.94	1656.0
2009-06-18 23:00:00	ES	Futures	881.7	883.15	881.7	881.94	1885.0
2009-06-18 00:00:00	NQ	Futures	1655.89	1656.46	1652.47	1653.32	195.0
2009-06-18 01:00:00	NQ	Futures	1653.61	1656.74	1653.32	1656.46	356.0
2009-06-18 02:00:00	NQ	Futures	1656.46	1662.15	1655.32	1661.3	874.0
2009-06-18 03:00:00	NQ	Futures	1661.01	1662.72	1654.46	1655.6	1845.0
2009-06-18 04:00:00	NQ	Futures	1655.6	1656.74	1649.34	1652.75	2080.0
2009-06-18 05:00:00	NQ	Futures	1652.19	1654.46	1650.76	1653.32	762.0
2009-06-18 06:00:00	NQ	Futures	1653.04	1654.75	1646.77	1647.34	1102.0
2009-06-18 07:00:00	NQ	Futures	1647.34	1656.17	1647.34	1649.62	2489.0
2009-06-18 08:00:00	NQ	Futures	1649.91	1659.31	1648.77	1658.74	6224.0
2009-06-18 09:00:00	NQ	Futures	1658.45	1661.01	1643.93	1658.17	55091.0
2009-06-18 10:00:00	NQ	Futures	1658.17	1666.43	1651.33	1653.61	55181.0
2009-06-18 11:00:00	NQ	Futures	1653.61	1657.03	1649.91	1655.03	22257.0
2009-06-18 12:00:00	NQ	Futures	1654.75	1663.58	1653.61	1663.01	21260.0
2009-06-18 13:00:00	NQ	Futures	1663.29	1666.14	1659.02	1661.58	26234.0
2009-06-18 14:00:00	NQ	Futures	1661.3	1662.44	1657.31	1661.3	26614.0
2009-06-18 15:00:00	NQ	Futures	1661.3	1664.15	1652.75	1655.03	41400.0
2009-06-18 16:00:00	NQ	Futures	1655.03	1657.6	1647.06	1651.33	18498.0
2009-06-18 17:00:00	NQ	Futures	1651.33	1654.46	1650.19	1654.18	1142.0
2009-06-18 18:00:00	NQ	Futures	1655.89	1657.88	1655.89	1657.03	933.0
2009-06-18 19:00:00	NQ	Futures	1656.74	1658.17	1656.46	1657.03	153.0
2009-06-18 20:00:00	NQ	Futures	1657.31	1659.59	1656.17	1658.74	363.0
2009-06-18 21:00:00	NQ	Futures	1658.74	1658.74	1655.32	1655.89	295.0
2009-06-18 22:00:00	NQ	Futures	1656.74	1656.74	1655.03	1655.32	129.0
2009-06-18 23:00:00	NQ	Futures	1655.89	1658.17	1655.89	1657.03	129.0
2009-06-18 00:00:00	YM	Futures	7815.0	7818.7	7800.3	7803.0	220.0
2009-06-18 01:00:00	YM	Futures	7803.0	7823.4	7803.0	7821.5	170.0

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

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