PREVIEW / futures_1hour / 2009-05-28

all futures 1-hour files

  file:    by_date/futures_1hour/2009/2009-05-28.parquet
  size:    43 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-05-28 00:00:00	ES	Futures	856.45	857.65	855.49	857.17	2786.0
2009-05-28 01:00:00	ES	Futures	857.17	857.41	856.21	856.69	1869.0
2009-05-28 02:00:00	ES	Futures	856.93	857.41	854.77	855.25	7281.0
2009-05-28 03:00:00	ES	Futures	855.25	858.85	855.01	858.13	19486.0
2009-05-28 04:00:00	ES	Futures	858.37	858.85	856.93	858.61	12814.0
2009-05-28 05:00:00	ES	Futures	858.61	860.05	858.37	859.33	12935.0
2009-05-28 06:00:00	ES	Futures	859.09	859.33	857.17	858.13	8746.0
2009-05-28 07:00:00	ES	Futures	858.37	859.57	854.05	855.01	20300.0
2009-05-28 08:00:00	ES	Futures	855.25	859.57	855.01	857.89	59681.0
2009-05-28 09:00:00	ES	Futures	858.13	865.08	856.69	860.05	304143.0
2009-05-28 10:00:00	ES	Futures	860.29	860.52	849.5	856.93	533202.0
2009-05-28 11:00:00	ES	Futures	857.17	864.12	856.93	863.4	323669.0
2009-05-28 12:00:00	ES	Futures	863.4	864.12	854.77	856.21	212466.0
2009-05-28 13:00:00	ES	Futures	855.97	867.95	855.25	864.36	443508.0
2009-05-28 14:00:00	ES	Futures	864.36	871.07	863.64	868.91	270799.0
2009-05-28 15:00:00	ES	Futures	868.91	870.35	864.12	867.47	308319.0
2009-05-28 16:00:00	ES	Futures	867.47	868.43	865.8	867.71	102334.0
2009-05-28 17:00:00	ES	Futures	867.47	867.71	867.0	867.23	598.0
2009-05-28 18:00:00	ES	Futures	867.47	867.47	866.04	866.52	1750.0
2009-05-28 19:00:00	ES	Futures	866.28	867.23	866.04	867.0	1103.0
2009-05-28 20:00:00	ES	Futures	866.76	867.23	865.8	866.04	3461.0
2009-05-28 21:00:00	ES	Futures	865.8	867.23	865.56	867.0	3680.0
2009-05-28 22:00:00	ES	Futures	866.76	867.47	866.04	867.0	2496.0
2009-05-28 23:00:00	ES	Futures	867.0	867.0	865.56	866.04	2046.0
2009-05-28 00:00:00	NQ	Futures	1598.0	1602.26	1596.87	1600.28	287.0
2009-05-28 01:00:00	NQ	Futures	1600.56	1600.56	1599.14	1599.14	177.0
2009-05-28 02:00:00	NQ	Futures	1599.71	1600.84	1595.73	1598.0	340.0
2009-05-28 03:00:00	NQ	Futures	1598.29	1603.4	1597.15	1602.26	950.0
2009-05-28 04:00:00	NQ	Futures	1601.98	1602.55	1598.29	1602.55	1057.0
2009-05-28 05:00:00	NQ	Futures	1602.55	1604.25	1601.41	1602.83	704.0
2009-05-28 06:00:00	NQ	Futures	1602.55	1603.12	1599.42	1601.41	672.0
2009-05-28 07:00:00	NQ	Futures	1601.41	1602.55	1593.46	1595.45	1432.0
2009-05-28 08:00:00	NQ	Futures	1595.45	1603.4	1593.46	1599.42	4843.0
2009-05-28 09:00:00	NQ	Futures	1599.71	1611.93	1597.43	1600.28	33034.0
2009-05-28 10:00:00	NQ	Futures	1600.56	1601.13	1578.97	1592.04	65993.0
2009-05-28 11:00:00	NQ	Futures	1592.04	1603.12	1591.18	1602.26	36985.0
2009-05-28 12:00:00	NQ	Futures	1602.55	1603.97	1588.34	1591.18	25876.0
2009-05-28 13:00:00	NQ	Futures	1591.18	1613.06	1590.61	1606.24	49222.0
2009-05-28 14:00:00	NQ	Futures	1606.24	1618.46	1605.67	1615.62	35628.0
2009-05-28 15:00:00	NQ	Futures	1615.62	1618.74	1607.66	1612.78	42645.0
2009-05-28 16:00:00	NQ	Futures	1613.35	1615.34	1609.37	1612.21	12348.0
2009-05-28 17:00:00	NQ	Futures	1612.49	1613.06	1610.79	1611.64	135.0
2009-05-28 18:00:00	NQ	Futures	1611.64	1612.21	1609.65	1610.22	100.0
2009-05-28 19:00:00	NQ	Futures	1610.5	1611.36	1609.65	1611.36	64.0
2009-05-28 20:00:00	NQ	Futures	1610.79	1610.79	1609.08	1609.65	84.0
2009-05-28 21:00:00	NQ	Futures	1609.08	1610.79	1608.23	1610.5	128.0
2009-05-28 22:00:00	NQ	Futures	1610.79	1611.07	1608.8	1610.79	66.0
2009-05-28 23:00:00	NQ	Futures	1610.5	1611.07	1608.52	1609.08	33.0
2009-05-28 00:00:00	YM	Futures	7635.5	7645.7	7627.3	7642.0	188.0
2009-05-28 01:00:00	YM	Futures	7642.9	7642.9	7634.6	7638.3	168.0

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

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