PREVIEW / futures_1hour / 2009-07-08

all futures 1-hour files

  file:    by_date/futures_1hour/2009/2009-07-08.parquet
  size:    43 KB
  rows:    1,256

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-07-08 00:00:00	ES	Futures	846.25	846.97	845.53	846.97	2582.0
2009-07-08 01:00:00	ES	Futures	846.97	846.97	846.01	846.25	2590.0
2009-07-08 02:00:00	ES	Futures	846.25	849.14	845.77	848.9	9984.0
2009-07-08 03:00:00	ES	Futures	849.14	851.32	847.46	848.9	25792.0
2009-07-08 04:00:00	ES	Futures	848.9	849.87	847.46	848.18	12858.0
2009-07-08 05:00:00	ES	Futures	848.18	850.83	847.94	850.35	11280.0
2009-07-08 06:00:00	ES	Futures	850.59	851.07	847.94	849.14	9942.0
2009-07-08 07:00:00	ES	Futures	849.14	851.07	848.42	848.42	12503.0
2009-07-08 08:00:00	ES	Futures	848.66	848.66	846.49	847.7	41300.0
2009-07-08 09:00:00	ES	Futures	847.46	851.32	847.46	847.7	238639.0
2009-07-08 10:00:00	ES	Futures	847.94	852.28	845.77	845.77	309657.0
2009-07-08 11:00:00	ES	Futures	845.77	846.25	838.77	840.22	384778.0
2009-07-08 12:00:00	ES	Futures	839.98	840.46	835.64	837.57	217157.0
2009-07-08 13:00:00	ES	Futures	837.33	843.12	837.33	840.7	249142.0
2009-07-08 14:00:00	ES	Futures	840.7	840.95	834.67	839.74	304818.0
2009-07-08 15:00:00	ES	Futures	839.5	847.94	837.81	844.32	499179.0
2009-07-08 16:00:00	ES	Futures	844.56	845.05	842.15	844.08	125072.0
2009-07-08 17:00:00	ES	Futures	844.08	845.29	844.08	845.05	2155.0
2009-07-08 18:00:00	ES	Futures	845.05	845.77	844.32	845.29	1685.0
2009-07-08 19:00:00	ES	Futures	845.29	845.29	844.32	845.05	1414.0
2009-07-08 20:00:00	ES	Futures	845.05	847.7	844.8	846.97	5137.0
2009-07-08 21:00:00	ES	Futures	846.97	848.42	846.25	847.7	6481.0
2009-07-08 22:00:00	ES	Futures	847.94	847.94	846.25	847.22	4476.0
2009-07-08 23:00:00	ES	Futures	847.22	847.46	846.49	846.73	1946.0
2009-07-08 00:00:00	NQ	Futures	1601.49	1602.91	1601.49	1602.63	543.0
2009-07-08 01:00:00	NQ	Futures	1602.63	1604.34	1602.63	1604.05	978.0
2009-07-08 02:00:00	NQ	Futures	1603.77	1607.19	1602.91	1607.19	663.0
2009-07-08 03:00:00	NQ	Futures	1607.19	1609.75	1604.05	1606.05	1661.0
2009-07-08 04:00:00	NQ	Futures	1605.76	1606.05	1603.2	1604.34	1593.0
2009-07-08 05:00:00	NQ	Futures	1604.34	1608.32	1604.05	1607.47	759.0
2009-07-08 06:00:00	NQ	Futures	1607.47	1608.32	1604.62	1606.05	966.0
2009-07-08 07:00:00	NQ	Futures	1606.33	1609.18	1605.48	1605.48	1353.0
2009-07-08 08:00:00	NQ	Futures	1605.48	1607.19	1600.06	1606.62	4926.0
2009-07-08 09:00:00	NQ	Futures	1606.9	1611.17	1599.21	1601.2	40690.0
2009-07-08 10:00:00	NQ	Futures	1601.77	1611.46	1598.07	1598.07	48566.0
2009-07-08 11:00:00	NQ	Futures	1598.07	1598.64	1588.1	1592.66	48484.0
2009-07-08 12:00:00	NQ	Futures	1592.66	1594.37	1586.39	1592.38	26533.0
2009-07-08 13:00:00	NQ	Futures	1592.38	1602.34	1592.09	1597.22	29739.0
2009-07-08 14:00:00	NQ	Futures	1596.93	1599.5	1588.67	1598.07	37994.0
2009-07-08 15:00:00	NQ	Futures	1598.36	1612.6	1596.08	1605.76	69082.0
2009-07-08 16:00:00	NQ	Futures	1605.76	1607.47	1600.92	1606.33	10120.0
2009-07-08 17:00:00	NQ	Futures	1605.76	1607.47	1605.76	1607.47	215.0
2009-07-08 18:00:00	NQ	Futures	1607.19	1607.47	1606.05	1606.9	92.0
2009-07-08 19:00:00	NQ	Futures	1607.19	1607.47	1605.48	1606.05	99.0
2009-07-08 20:00:00	NQ	Futures	1606.9	1609.75	1605.76	1609.46	463.0
2009-07-08 21:00:00	NQ	Futures	1609.75	1611.17	1607.75	1609.75	285.0
2009-07-08 22:00:00	NQ	Futures	1609.75	1609.75	1607.47	1608.32	161.0
2009-07-08 23:00:00	NQ	Futures	1608.32	1609.46	1607.47	1607.47	96.0
2009-07-08 00:00:00	YM	Futures	7499.7	7503.4	7493.3	7503.4	137.0
2009-07-08 01:00:00	YM	Futures	7504.4	7504.4	7496.0	7497.9	85.0

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

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