PREVIEW / futures_1hour / 2009-05-06

all futures 1-hour files

  file:    by_date/futures_1hour/2009/2009-05-06.parquet
  size:    43 KB
  rows:    1,257

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-06 00:00:00	ES	Futures	856.45	856.45	854.53	855.49	3566.0
2009-05-06 01:00:00	ES	Futures	855.49	856.45	854.77	855.97	3620.0
2009-05-06 02:00:00	ES	Futures	855.97	857.89	855.49	856.93	6069.0
2009-05-06 03:00:00	ES	Futures	857.17	860.05	856.93	858.85	19808.0
2009-05-06 04:00:00	ES	Futures	858.85	862.44	858.85	862.2	15978.0
2009-05-06 05:00:00	ES	Futures	861.96	863.88	861.0	861.48	14702.0
2009-05-06 06:00:00	ES	Futures	861.48	861.48	859.09	861.24	8953.0
2009-05-06 07:00:00	ES	Futures	861.0	861.48	857.41	860.52	20460.0
2009-05-06 08:00:00	ES	Futures	860.52	873.94	860.05	872.03	139134.0
2009-05-06 09:00:00	ES	Futures	872.27	874.66	869.87	872.75	267902.0
2009-05-06 10:00:00	ES	Futures	872.75	873.7	863.88	868.67	420682.0
2009-05-06 11:00:00	ES	Futures	868.67	870.59	864.84	870.35	281118.0
2009-05-06 12:00:00	ES	Futures	870.35	873.23	869.15	869.63	198514.0
2009-05-06 13:00:00	ES	Futures	869.63	875.14	866.76	874.9	260043.0
2009-05-06 14:00:00	ES	Futures	874.9	879.22	874.18	877.06	312320.0
2009-05-06 15:00:00	ES	Futures	877.06	878.98	870.35	878.5	506446.0
2009-05-06 16:00:00	ES	Futures	878.74	879.94	876.34	876.58	118983.0
2009-05-06 17:00:00	ES	Futures	876.82	877.78	876.58	877.78	2544.0
2009-05-06 18:00:00	ES	Futures	878.02	879.7	878.02	878.74	4161.0
2009-05-06 19:00:00	ES	Futures	878.74	879.22	877.06	877.54	2199.0
2009-05-06 20:00:00	ES	Futures	877.54	879.94	874.9	875.62	6582.0
2009-05-06 21:00:00	ES	Futures	875.62	876.82	874.9	876.1	4362.0
2009-05-06 22:00:00	ES	Futures	876.1	878.02	875.38	876.34	5030.0
2009-05-06 23:00:00	ES	Futures	876.34	876.82	874.42	874.42	4256.0
2009-05-06 00:00:00	NQ	Futures	1605.96	1606.81	1603.69	1604.82	144.0
2009-05-06 01:00:00	NQ	Futures	1604.82	1607.66	1604.54	1607.66	137.0
2009-05-06 02:00:00	NQ	Futures	1607.66	1609.65	1605.96	1607.09	334.0
2009-05-06 03:00:00	NQ	Futures	1607.95	1612.78	1607.09	1610.5	810.0
2009-05-06 04:00:00	NQ	Futures	1611.36	1616.47	1610.5	1616.19	1231.0
2009-05-06 05:00:00	NQ	Futures	1615.9	1619.6	1614.48	1615.05	1020.0
2009-05-06 06:00:00	NQ	Futures	1615.34	1615.34	1611.64	1615.34	653.0
2009-05-06 07:00:00	NQ	Futures	1615.34	1616.19	1608.23	1614.48	2931.0
2009-05-06 08:00:00	NQ	Futures	1614.77	1630.68	1611.93	1626.7	15142.0
2009-05-06 09:00:00	NQ	Futures	1626.7	1631.53	1617.61	1622.15	39952.0
2009-05-06 10:00:00	NQ	Futures	1622.44	1623.01	1590.05	1601.7	90257.0
2009-05-06 11:00:00	NQ	Futures	1601.98	1610.22	1596.01	1609.65	44353.0
2009-05-06 12:00:00	NQ	Futures	1609.65	1613.63	1602.83	1603.97	31525.0
2009-05-06 13:00:00	NQ	Futures	1603.97	1611.64	1598.29	1611.36	40442.0
2009-05-06 14:00:00	NQ	Futures	1611.07	1623.86	1609.65	1615.9	48619.0
2009-05-06 15:00:00	NQ	Futures	1616.19	1617.89	1604.54	1616.76	58561.0
2009-05-06 16:00:00	NQ	Futures	1616.76	1626.42	1605.96	1614.48	20406.0
2009-05-06 17:00:00	NQ	Futures	1613.91	1616.76	1611.93	1616.19	483.0
2009-05-06 18:00:00	NQ	Futures	1616.19	1619.31	1615.05	1617.89	279.0
2009-05-06 19:00:00	NQ	Futures	1619.03	1619.03	1615.05	1616.19	136.0
2009-05-06 20:00:00	NQ	Futures	1616.76	1620.17	1611.93	1614.2	470.0
2009-05-06 21:00:00	NQ	Futures	1612.78	1615.9	1612.49	1615.05	361.0
2009-05-06 22:00:00	NQ	Futures	1614.77	1618.46	1614.2	1614.48	202.0
2009-05-06 23:00:00	NQ	Futures	1614.2	1615.62	1611.07	1611.07	108.0
2009-05-06 00:00:00	YM	Futures	7634.6	7638.3	7618.1	7627.3	395.0
2009-05-06 01:00:00	YM	Futures	7626.4	7633.7	7621.8	7631.9	169.0

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

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