PREVIEW / futures_1hour / 2009-06-22

all futures 1-hour files

  file:    by_date/futures_1hour/2009/2009-06-22.parquet
  size:    44 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-06-22 00:00:00	ES	Futures	883.39	886.77	883.15	886.04	4417.0
2009-06-22 01:00:00	ES	Futures	886.04	886.77	885.32	885.56	1779.0
2009-06-22 02:00:00	ES	Futures	885.8	886.53	881.7	882.91	6842.0
2009-06-22 03:00:00	ES	Futures	882.91	883.63	878.33	879.77	20969.0
2009-06-22 04:00:00	ES	Futures	879.77	880.01	875.67	876.88	18335.0
2009-06-22 05:00:00	ES	Futures	877.12	878.08	875.19	877.84	10971.0
2009-06-22 06:00:00	ES	Futures	877.84	878.33	875.43	876.16	13979.0
2009-06-22 07:00:00	ES	Futures	876.16	877.6	874.95	875.67	17856.0
2009-06-22 08:00:00	ES	Futures	875.91	876.88	873.02	874.23	31628.0
2009-06-22 09:00:00	ES	Futures	874.23	875.67	867.71	868.44	300821.0
2009-06-22 10:00:00	ES	Futures	868.44	869.89	864.58	865.54	379796.0
2009-06-22 11:00:00	ES	Futures	865.3	866.27	860.72	861.2	232296.0
2009-06-22 12:00:00	ES	Futures	861.2	862.89	860.48	862.17	149106.0
2009-06-22 13:00:00	ES	Futures	861.93	862.17	857.83	861.44	175142.0
2009-06-22 14:00:00	ES	Futures	861.44	862.89	859.76	861.93	163500.0
2009-06-22 15:00:00	ES	Futures	861.93	863.61	856.62	856.86	356440.0
2009-06-22 16:00:00	ES	Futures	857.1	858.55	856.38	858.07	144201.0
2009-06-22 17:00:00	ES	Futures	858.07	858.31	857.34	857.59	844.0
2009-06-22 18:00:00	ES	Futures	857.34	858.07	857.1	858.07	2186.0
2009-06-22 19:00:00	ES	Futures	857.83	858.79	857.59	858.55	2523.0
2009-06-22 20:00:00	ES	Futures	858.55	859.03	857.34	858.07	5333.0
2009-06-22 21:00:00	ES	Futures	858.07	859.03	857.59	858.07	3319.0
2009-06-22 22:00:00	ES	Futures	858.07	858.31	855.9	855.9	6561.0
2009-06-22 23:00:00	ES	Futures	856.14	858.07	855.9	857.59	3688.0
2009-06-22 00:00:00	NQ	Futures	1668.99	1675.25	1668.99	1674.69	264.0
2009-06-22 01:00:00	NQ	Futures	1674.12	1675.25	1669.56	1671.55	345.0
2009-06-22 02:00:00	NQ	Futures	1672.69	1673.83	1666.43	1668.7	870.0
2009-06-22 03:00:00	NQ	Futures	1668.7	1669.56	1659.88	1661.87	2096.0
2009-06-22 04:00:00	NQ	Futures	1661.3	1662.15	1653.04	1654.46	3700.0
2009-06-22 05:00:00	NQ	Futures	1654.75	1656.74	1651.05	1655.89	1902.0
2009-06-22 06:00:00	NQ	Futures	1655.89	1663.86	1653.04	1653.61	2946.0
2009-06-22 07:00:00	NQ	Futures	1653.32	1658.17	1653.04	1654.46	2225.0
2009-06-22 08:00:00	NQ	Futures	1654.46	1656.46	1651.33	1653.32	3694.0
2009-06-22 09:00:00	NQ	Futures	1653.04	1659.88	1639.65	1641.93	57844.0
2009-06-22 10:00:00	NQ	Futures	1642.22	1642.22	1629.12	1631.39	61504.0
2009-06-22 11:00:00	NQ	Futures	1631.39	1636.24	1624.84	1626.27	35109.0
2009-06-22 12:00:00	NQ	Futures	1626.27	1628.55	1622.57	1625.98	22124.0
2009-06-22 13:00:00	NQ	Futures	1625.7	1626.55	1619.15	1626.27	21740.0
2009-06-22 14:00:00	NQ	Futures	1626.27	1631.39	1624.56	1628.83	28322.0
2009-06-22 15:00:00	NQ	Futures	1628.83	1634.24	1622.0	1622.28	52918.0
2009-06-22 16:00:00	NQ	Futures	1622.57	1628.26	1622.0	1627.41	13760.0
2009-06-22 17:00:00	NQ	Futures	1627.69	1627.98	1625.98	1625.98	127.0
2009-06-22 18:00:00	NQ	Futures	1625.98	1626.55	1625.13	1626.27	96.0
2009-06-22 19:00:00	NQ	Futures	1625.98	1627.69	1625.98	1627.41	157.0
2009-06-22 20:00:00	NQ	Futures	1627.69	1629.12	1626.55	1628.26	538.0
2009-06-22 21:00:00	NQ	Futures	1628.55	1629.12	1627.12	1627.41	320.0
2009-06-22 22:00:00	NQ	Futures	1627.98	1627.98	1623.99	1623.99	309.0
2009-06-22 23:00:00	NQ	Futures	1624.27	1627.12	1623.7	1626.84	273.0
2009-06-22 00:00:00	YM	Futures	7840.0	7867.7	7840.0	7863.1	371.0
2009-06-22 01:00:00	YM	Futures	7862.2	7865.0	7854.8	7858.5	123.0

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

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