PREVIEW / futures_1hour / 2009-06-01

all futures 1-hour files

  file:    by_date/futures_1hour/2009/2009-06-01.parquet
  size:    44 KB
  rows:    1,273

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-01 00:00:00	ES	Futures	886.17	886.41	885.45	885.69	2521.0
2009-06-01 01:00:00	ES	Futures	885.69	886.65	885.45	886.41	3312.0
2009-06-01 02:00:00	ES	Futures	886.41	893.83	885.69	891.2	28125.0
2009-06-01 03:00:00	ES	Futures	891.44	895.99	888.8	893.59	34838.0
2009-06-01 04:00:00	ES	Futures	893.83	895.03	893.12	894.79	13055.0
2009-06-01 05:00:00	ES	Futures	894.79	895.99	893.35	895.27	10653.0
2009-06-01 06:00:00	ES	Futures	895.51	898.15	892.88	893.12	18067.0
2009-06-01 07:00:00	ES	Futures	893.35	894.07	890.0	891.44	23264.0
2009-06-01 08:00:00	ES	Futures	891.44	895.75	891.44	893.59	45007.0
2009-06-01 09:00:00	ES	Futures	893.35	898.87	890.96	896.47	274811.0
2009-06-01 10:00:00	ES	Futures	896.71	902.94	896.47	902.22	383958.0
2009-06-01 11:00:00	ES	Futures	902.22	904.62	901.5	903.66	180185.0
2009-06-01 12:00:00	ES	Futures	903.42	905.34	902.46	902.94	135068.0
2009-06-01 13:00:00	ES	Futures	902.7	907.25	901.98	906.53	140661.0
2009-06-01 14:00:00	ES	Futures	906.53	907.97	902.94	904.14	258742.0
2009-06-01 15:00:00	ES	Futures	904.14	907.01	900.3	903.66	434369.0
2009-06-01 16:00:00	ES	Futures	903.66	904.14	898.39	899.59	169252.0
2009-06-01 17:00:00	ES	Futures	899.59	900.06	899.59	900.06	1931.0
2009-06-01 18:00:00	ES	Futures	900.06	900.3	899.59	900.06	1763.0
2009-06-01 19:00:00	ES	Futures	900.06	900.54	899.35	900.54	1966.0
2009-06-01 20:00:00	ES	Futures	900.3	900.54	898.39	898.87	4042.0
2009-06-01 21:00:00	ES	Futures	898.87	899.59	898.39	898.63	4213.0
2009-06-01 22:00:00	ES	Futures	898.63	899.11	898.15	899.11	3327.0
2009-06-01 23:00:00	ES	Futures	898.87	900.06	898.39	899.82	2784.0
2009-06-01 00:00:00	NQ	Futures	1638.07	1639.2	1636.93	1636.93	102.0
2009-06-01 01:00:00	NQ	Futures	1637.21	1639.77	1637.21	1639.77	103.0
2009-06-01 02:00:00	NQ	Futures	1639.49	1649.15	1637.78	1646.31	1796.0
2009-06-01 03:00:00	NQ	Futures	1646.87	1653.13	1642.9	1646.87	2514.0
2009-06-01 04:00:00	NQ	Futures	1646.87	1650.57	1646.02	1650.28	1442.0
2009-06-01 05:00:00	NQ	Futures	1650.85	1652.84	1649.15	1651.7	1168.0
2009-06-01 06:00:00	NQ	Futures	1652.56	1657.39	1648.3	1649.15	1737.0
2009-06-01 07:00:00	NQ	Futures	1648.86	1649.15	1644.32	1646.31	2138.0
2009-06-01 08:00:00	NQ	Futures	1646.31	1653.13	1646.02	1648.86	4114.0
2009-06-01 09:00:00	NQ	Futures	1648.86	1663.35	1643.46	1660.23	52172.0
2009-06-01 10:00:00	NQ	Futures	1660.23	1673.58	1659.94	1671.88	56532.0
2009-06-01 11:00:00	NQ	Futures	1671.59	1678.13	1671.59	1676.14	28102.0
2009-06-01 12:00:00	NQ	Futures	1675.86	1682.68	1674.44	1676.99	29858.0
2009-06-01 13:00:00	NQ	Futures	1676.99	1683.81	1673.02	1682.68	23086.0
2009-06-01 14:00:00	NQ	Futures	1682.39	1684.67	1675.57	1679.83	36512.0
2009-06-01 15:00:00	NQ	Futures	1679.83	1681.82	1671.03	1679.55	59496.0
2009-06-01 16:00:00	NQ	Futures	1679.55	1680.4	1668.75	1670.74	14835.0
2009-06-01 17:00:00	NQ	Futures	1671.59	1672.45	1671.03	1672.45	142.0
2009-06-01 18:00:00	NQ	Futures	1672.16	1672.73	1671.31	1671.31	53.0
2009-06-01 19:00:00	NQ	Futures	1671.31	1672.45	1670.46	1672.45	225.0
2009-06-01 20:00:00	NQ	Futures	1672.16	1672.16	1668.47	1669.61	188.0
2009-06-01 21:00:00	NQ	Futures	1669.61	1670.46	1668.47	1668.75	195.0
2009-06-01 22:00:00	NQ	Futures	1668.47	1669.04	1667.9	1668.47	125.0
2009-06-01 23:00:00	NQ	Futures	1668.75	1671.03	1668.19	1669.61	138.0
2009-06-01 00:00:00	YM	Futures	7845.1	7847.8	7838.6	7839.6	111.0
2009-06-01 01:00:00	YM	Futures	7841.4	7846.9	7838.6	7846.9	132.0

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

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