PREVIEW / futures_1hour / 2009-06-26

all futures 1-hour files

  file:    by_date/futures_1hour/2009/2009-06-26.parquet
  size:    35 KB
  rows:    969

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-26 00:00:00	ES	Futures	880.5	881.22	880.01	880.74	2973.0
2009-06-26 01:00:00	ES	Futures	880.74	882.43	880.5	881.94	3336.0
2009-06-26 02:00:00	ES	Futures	881.94	883.15	881.7	882.18	6652.0
2009-06-26 03:00:00	ES	Futures	882.43	884.84	882.18	882.43	20326.0
2009-06-26 04:00:00	ES	Futures	882.18	884.36	881.22	884.36	10466.0
2009-06-26 05:00:00	ES	Futures	884.36	884.6	881.46	881.7	7146.0
2009-06-26 06:00:00	ES	Futures	881.7	882.67	880.26	881.7	10272.0
2009-06-26 07:00:00	ES	Futures	881.7	883.39	881.46	882.91	9314.0
2009-06-26 08:00:00	ES	Futures	882.91	886.53	879.29	880.26	55529.0
2009-06-26 09:00:00	ES	Futures	880.26	883.87	878.33	879.05	243933.0
2009-06-26 10:00:00	ES	Futures	878.81	882.18	877.36	878.57	260301.0
2009-06-26 11:00:00	ES	Futures	878.57	879.77	876.4	879.53	156536.0
2009-06-26 12:00:00	ES	Futures	879.53	882.18	878.33	880.98	122107.0
2009-06-26 13:00:00	ES	Futures	880.98	881.46	879.05	879.77	89533.0
2009-06-26 14:00:00	ES	Futures	879.77	882.67	878.57	882.43	75059.0
2009-06-26 15:00:00	ES	Futures	882.43	885.8	880.98	880.98	213234.0
2009-06-26 16:00:00	ES	Futures	880.98	882.18	880.74	881.7	100176.0
2009-06-26 00:00:00	NQ	Futures	1672.41	1673.55	1672.12	1672.98	108.0
2009-06-26 01:00:00	NQ	Futures	1672.12	1675.82	1672.12	1675.54	142.0
2009-06-26 02:00:00	NQ	Futures	1674.97	1677.25	1674.97	1676.39	282.0
2009-06-26 03:00:00	NQ	Futures	1676.11	1680.38	1675.54	1676.11	1245.0
2009-06-26 04:00:00	NQ	Futures	1675.82	1679.53	1674.69	1679.24	1084.0
2009-06-26 05:00:00	NQ	Futures	1679.53	1680.1	1673.83	1674.69	788.0
2009-06-26 06:00:00	NQ	Futures	1674.69	1675.82	1671.84	1674.12	1057.0
2009-06-26 07:00:00	NQ	Futures	1673.83	1676.39	1672.41	1675.54	865.0
2009-06-26 08:00:00	NQ	Futures	1675.54	1680.38	1668.7	1670.13	4361.0
2009-06-26 09:00:00	NQ	Futures	1669.84	1684.65	1667.57	1675.82	46310.0
2009-06-26 10:00:00	NQ	Futures	1675.54	1682.94	1672.98	1676.96	34359.0
2009-06-26 11:00:00	NQ	Futures	1676.68	1681.52	1672.98	1680.95	18242.0
2009-06-26 12:00:00	NQ	Futures	1680.67	1686.08	1679.53	1683.23	18813.0
2009-06-26 13:00:00	NQ	Futures	1683.23	1685.51	1680.95	1682.66	18199.0
2009-06-26 14:00:00	NQ	Futures	1682.66	1686.08	1680.95	1685.51	14010.0
2009-06-26 15:00:00	NQ	Futures	1685.79	1688.36	1681.81	1682.94	37914.0
2009-06-26 16:00:00	NQ	Futures	1682.66	1684.65	1679.24	1682.38	9790.0
2009-06-26 00:00:00	YM	Futures	7751.2	7754.9	7746.6	7753.1	182.0
2009-06-26 01:00:00	YM	Futures	7754.0	7763.3	7747.5	7763.3	247.0
2009-06-26 02:00:00	YM	Futures	7763.3	7771.6	7759.6	7766.0	348.0
2009-06-26 03:00:00	YM	Futures	7766.0	7783.6	7762.3	7762.3	1772.0
2009-06-26 04:00:00	YM	Futures	7761.4	7778.1	7756.8	7777.1	1037.0
2009-06-26 05:00:00	YM	Futures	7777.1	7779.9	7758.6	7761.4	715.0
2009-06-26 06:00:00	YM	Futures	7760.5	7766.0	7748.5	7754.9	1086.0
2009-06-26 07:00:00	YM	Futures	7757.7	7770.7	7753.1	7766.0	530.0
2009-06-26 08:00:00	YM	Futures	7765.1	7796.6	7740.1	7747.5	3290.0
2009-06-26 09:00:00	YM	Futures	7746.6	7776.2	7731.8	7741.1	18368.0
2009-06-26 10:00:00	YM	Futures	7740.1	7764.2	7721.7	7733.7	23219.0
2009-06-26 11:00:00	YM	Futures	7732.8	7735.5	7713.3	7731.8	13226.0
2009-06-26 12:00:00	YM	Futures	7731.8	7751.2	7719.8	7743.8	9438.0
2009-06-26 13:00:00	YM	Futures	7743.8	7744.8	7722.6	7733.7	8997.0
2009-06-26 14:00:00	YM	Futures	7731.8	7751.2	7721.7	7747.5	8500.0
2009-06-26 15:00:00	YM	Futures	7748.5	7775.3	7733.7	7737.4	16155.0

> showing 50 of 969 rows — these rows as CSV

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