PREVIEW / futures_1hour / 2009-06-25

all futures 1-hour files

  file:    by_date/futures_1hour/2009/2009-06-25.parquet
  size:    44 KB
  rows:    1,249

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-25 00:00:00	ES	Futures	867.96	876.4	867.96	874.47	19352.0
2009-06-25 01:00:00	ES	Futures	874.23	875.91	872.78	872.78	5870.0
2009-06-25 02:00:00	ES	Futures	872.78	874.71	871.33	872.3	10228.0
2009-06-25 03:00:00	ES	Futures	872.3	872.54	868.2	871.57	22982.0
2009-06-25 04:00:00	ES	Futures	871.33	874.71	870.37	871.33	15403.0
2009-06-25 05:00:00	ES	Futures	871.09	872.3	866.27	866.99	20497.0
2009-06-25 06:00:00	ES	Futures	866.99	867.96	864.34	865.79	19786.0
2009-06-25 07:00:00	ES	Futures	866.03	869.4	865.54	867.23	17072.0
2009-06-25 08:00:00	ES	Futures	867.23	867.23	859.52	860.24	76475.0
2009-06-25 09:00:00	ES	Futures	860.48	868.92	859.76	868.2	271524.0
2009-06-25 10:00:00	ES	Futures	867.96	873.74	867.96	870.13	401912.0
2009-06-25 11:00:00	ES	Futures	870.13	881.22	869.4	880.74	316826.0
2009-06-25 12:00:00	ES	Futures	880.74	882.43	879.53	879.53	190659.0
2009-06-25 13:00:00	ES	Futures	879.77	885.32	879.29	882.67	189994.0
2009-06-25 14:00:00	ES	Futures	882.91	883.15	878.08	880.26	207796.0
2009-06-25 15:00:00	ES	Futures	880.26	884.11	877.36	883.87	357439.0
2009-06-25 16:00:00	ES	Futures	883.87	885.32	883.39	883.87	115802.0
2009-06-25 17:00:00	ES	Futures	883.63	883.87	883.15	883.39	2222.0
2009-06-25 18:00:00	ES	Futures	883.39	883.87	883.15	883.39	1000.0
2009-06-25 19:00:00	ES	Futures	883.39	884.11	882.67	882.91	2171.0
2009-06-25 20:00:00	ES	Futures	882.91	882.91	881.46	881.7	3650.0
2009-06-25 21:00:00	ES	Futures	881.7	881.94	880.98	880.98	2349.0
2009-06-25 22:00:00	ES	Futures	880.98	882.18	880.01	880.01	3864.0
2009-06-25 23:00:00	ES	Futures	880.5	881.22	880.01	880.5	2051.0
2009-06-25 00:00:00	NQ	Futures	1650.19	1666.71	1650.19	1662.44	1315.0
2009-06-25 01:00:00	NQ	Futures	1661.58	1664.15	1659.31	1659.59	470.0
2009-06-25 02:00:00	NQ	Futures	1659.59	1661.87	1657.31	1658.17	577.0
2009-06-25 03:00:00	NQ	Futures	1658.17	1658.17	1649.62	1656.17	2049.0
2009-06-25 04:00:00	NQ	Futures	1656.17	1661.01	1653.61	1656.17	2300.0
2009-06-25 05:00:00	NQ	Futures	1655.03	1657.31	1647.06	1648.2	1038.0
2009-06-25 06:00:00	NQ	Futures	1648.48	1649.62	1643.64	1646.2	1777.0
2009-06-25 07:00:00	NQ	Futures	1646.2	1653.32	1645.63	1649.05	1347.0
2009-06-25 08:00:00	NQ	Futures	1649.05	1649.34	1636.52	1639.08	5537.0
2009-06-25 09:00:00	NQ	Futures	1639.08	1661.3	1632.25	1658.17	49047.0
2009-06-25 10:00:00	NQ	Futures	1657.88	1671.84	1657.6	1665.29	69165.0
2009-06-25 11:00:00	NQ	Futures	1665.0	1679.81	1663.86	1679.53	42562.0
2009-06-25 12:00:00	NQ	Futures	1679.53	1679.81	1673.26	1674.12	19782.0
2009-06-25 13:00:00	NQ	Futures	1673.83	1682.38	1672.98	1677.25	23278.0
2009-06-25 14:00:00	NQ	Futures	1677.53	1678.1	1670.13	1673.83	27687.0
2009-06-25 15:00:00	NQ	Futures	1673.83	1681.81	1668.7	1680.1	51753.0
2009-06-25 16:00:00	NQ	Futures	1680.1	1680.67	1676.68	1677.82	11611.0
2009-06-25 17:00:00	NQ	Futures	1677.82	1678.39	1676.96	1677.25	175.0
2009-06-25 18:00:00	NQ	Futures	1677.82	1678.67	1676.96	1677.25	131.0
2009-06-25 19:00:00	NQ	Futures	1677.25	1678.67	1676.11	1676.96	103.0
2009-06-25 20:00:00	NQ	Futures	1675.54	1676.68	1673.26	1673.26	263.0
2009-06-25 21:00:00	NQ	Futures	1673.26	1673.83	1672.69	1672.69	198.0
2009-06-25 22:00:00	NQ	Futures	1672.69	1674.69	1671.27	1671.55	279.0
2009-06-25 23:00:00	NQ	Futures	1671.84	1672.69	1671.27	1672.41	150.0
2009-06-25 00:00:00	YM	Futures	7655.1	7717.0	7655.1	7689.3	1642.0
2009-06-25 01:00:00	YM	Futures	7691.1	7703.2	7681.0	7682.8	343.0

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

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