PREVIEW / futures_1hour / 2009-07-01

all futures 1-hour files

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

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-01 00:00:00	ES	Futures	884.84	885.56	884.84	885.56	2917.0
2009-07-01 01:00:00	ES	Futures	885.56	886.04	881.22	882.91	9812.0
2009-07-01 02:00:00	ES	Futures	882.91	884.36	881.22	884.11	7580.0
2009-07-01 03:00:00	ES	Futures	884.36	889.9	883.87	889.42	30660.0
2009-07-01 04:00:00	ES	Futures	889.66	889.9	887.97	888.94	10076.0
2009-07-01 05:00:00	ES	Futures	888.94	889.42	888.21	888.94	6321.0
2009-07-01 06:00:00	ES	Futures	888.94	891.11	887.73	888.21	13887.0
2009-07-01 07:00:00	ES	Futures	888.21	889.66	886.53	889.42	17594.0
2009-07-01 08:00:00	ES	Futures	889.42	889.66	884.84	887.49	60215.0
2009-07-01 09:00:00	ES	Futures	887.49	891.83	886.53	891.59	208239.0
2009-07-01 10:00:00	ES	Futures	891.59	895.45	887.25	894.0	362029.0
2009-07-01 11:00:00	ES	Futures	894.0	894.48	891.35	892.8	152715.0
2009-07-01 12:00:00	ES	Futures	892.55	893.76	890.87	890.87	97579.0
2009-07-01 13:00:00	ES	Futures	891.11	892.8	890.87	891.59	86721.0
2009-07-01 14:00:00	ES	Futures	891.59	892.07	888.45	889.18	137171.0
2009-07-01 15:00:00	ES	Futures	889.42	890.38	885.32	886.53	225008.0
2009-07-01 16:00:00	ES	Futures	886.77	887.49	885.8	887.01	81358.0
2009-07-01 17:00:00	ES	Futures	886.77	887.25	886.77	887.25	644.0
2009-07-01 18:00:00	ES	Futures	887.01	887.25	886.77	887.25	911.0
2009-07-01 19:00:00	ES	Futures	887.01	887.25	886.53	887.01	724.0
2009-07-01 20:00:00	ES	Futures	887.01	887.01	886.04	886.28	1792.0
2009-07-01 21:00:00	ES	Futures	886.04	886.77	885.8	886.77	1960.0
2009-07-01 22:00:00	ES	Futures	886.53	886.77	885.56	885.8	2538.0
2009-07-01 23:00:00	ES	Futures	885.56	886.04	884.36	884.84	2967.0
2009-07-01 00:00:00	NQ	Futures	1687.22	1688.07	1686.65	1688.07	49.0
2009-07-01 01:00:00	NQ	Futures	1687.79	1688.93	1681.52	1682.38	303.0
2009-07-01 02:00:00	NQ	Futures	1683.23	1683.51	1680.67	1683.51	759.0
2009-07-01 03:00:00	NQ	Futures	1683.51	1692.91	1683.51	1692.34	1683.0
2009-07-01 04:00:00	NQ	Futures	1692.06	1693.77	1690.07	1692.63	954.0
2009-07-01 05:00:00	NQ	Futures	1692.63	1693.48	1691.49	1692.34	421.0
2009-07-01 06:00:00	NQ	Futures	1692.06	1697.19	1691.49	1691.77	1447.0
2009-07-01 07:00:00	NQ	Futures	1691.77	1694.05	1689.5	1694.05	1308.0
2009-07-01 08:00:00	NQ	Futures	1694.05	1695.48	1687.22	1694.05	5163.0
2009-07-01 09:00:00	NQ	Futures	1694.05	1697.19	1688.36	1696.62	30125.0
2009-07-01 10:00:00	NQ	Futures	1696.62	1704.59	1689.5	1701.46	53146.0
2009-07-01 11:00:00	NQ	Futures	1701.46	1703.17	1698.04	1701.46	23548.0
2009-07-01 12:00:00	NQ	Futures	1701.74	1702.03	1695.76	1696.05	16924.0
2009-07-01 13:00:00	NQ	Futures	1696.05	1698.61	1694.62	1695.48	17341.0
2009-07-01 14:00:00	NQ	Futures	1695.48	1696.05	1688.64	1690.35	22444.0
2009-07-01 15:00:00	NQ	Futures	1690.35	1692.91	1683.51	1684.37	37859.0
2009-07-01 16:00:00	NQ	Futures	1684.37	1686.08	1682.94	1684.37	9096.0
2009-07-01 17:00:00	NQ	Futures	1684.37	1684.94	1684.37	1684.94	68.0
2009-07-01 18:00:00	NQ	Futures	1684.94	1684.94	1684.37	1684.37	69.0
2009-07-01 19:00:00	NQ	Futures	1684.65	1684.94	1684.08	1684.94	121.0
2009-07-01 20:00:00	NQ	Futures	1684.65	1684.94	1682.94	1682.94	99.0
2009-07-01 21:00:00	NQ	Futures	1682.66	1683.8	1682.66	1683.8	84.0
2009-07-01 22:00:00	NQ	Futures	1683.51	1683.51	1681.24	1681.81	88.0
2009-07-01 23:00:00	NQ	Futures	1681.24	1682.09	1680.38	1680.67	185.0
2009-07-01 00:00:00	YM	Futures	7782.7	7785.5	7781.8	7784.5	83.0
2009-07-01 01:00:00	YM	Futures	7783.6	7788.2	7753.1	7763.3	738.0

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

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