PREVIEW / futures_1hour / 2009-05-21

all futures 1-hour files

  file:    by_date/futures_1hour/2009/2009-05-21.parquet
  size:    44 KB
  rows:    1,233

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-21 00:00:00	ES	Futures	858.85	859.33	858.61	859.09	2454.0
2009-05-21 01:00:00	ES	Futures	859.09	860.76	858.61	860.76	3052.0
2009-05-21 02:00:00	ES	Futures	860.52	861.72	859.57	861.48	10004.0
2009-05-21 03:00:00	ES	Futures	861.24	862.2	859.09	861.24	25699.0
2009-05-21 04:00:00	ES	Futures	861.24	861.96	855.97	857.41	28073.0
2009-05-21 05:00:00	ES	Futures	857.41	858.61	855.97	858.13	13306.0
2009-05-21 06:00:00	ES	Futures	858.37	860.05	856.93	857.89	16691.0
2009-05-21 07:00:00	ES	Futures	857.65	859.09	856.45	858.37	17647.0
2009-05-21 08:00:00	ES	Futures	858.13	858.85	852.62	853.1	51298.0
2009-05-21 09:00:00	ES	Futures	852.86	856.21	850.94	851.9	294282.0
2009-05-21 10:00:00	ES	Futures	851.9	855.73	846.63	846.63	434269.0
2009-05-21 11:00:00	ES	Futures	846.63	852.38	845.91	852.14	249876.0
2009-05-21 12:00:00	ES	Futures	852.14	852.86	849.02	851.66	176825.0
2009-05-21 13:00:00	ES	Futures	851.66	852.86	845.91	848.06	152541.0
2009-05-21 14:00:00	ES	Futures	848.06	849.26	841.35	843.99	349713.0
2009-05-21 15:00:00	ES	Futures	843.75	850.7	842.55	850.22	432966.0
2009-05-21 16:00:00	ES	Futures	850.46	854.77	850.22	853.34	100622.0
2009-05-21 17:00:00	ES	Futures	853.34	853.58	852.38	852.86	1485.0
2009-05-21 18:00:00	ES	Futures	852.86	854.29	852.62	853.34	2404.0
2009-05-21 19:00:00	ES	Futures	853.1	853.58	851.66	851.9	2173.0
2009-05-21 20:00:00	ES	Futures	851.9	853.58	850.94	853.34	2640.0
2009-05-21 21:00:00	ES	Futures	853.34	855.97	853.34	855.49	5875.0
2009-05-21 22:00:00	ES	Futures	855.49	855.97	854.29	855.25	2746.0
2009-05-21 23:00:00	ES	Futures	855.25	855.73	853.82	854.05	3138.0
2009-05-21 00:00:00	NQ	Futures	1576.12	1577.54	1576.12	1577.26	56.0
2009-05-21 01:00:00	NQ	Futures	1576.41	1580.39	1576.41	1578.97	61.0
2009-05-21 02:00:00	NQ	Futures	1580.1	1582.37	1578.97	1582.37	321.0
2009-05-21 03:00:00	NQ	Futures	1581.81	1583.51	1577.26	1581.52	811.0
2009-05-21 04:00:00	NQ	Futures	1581.52	1582.37	1572.15	1575.56	1425.0
2009-05-21 05:00:00	NQ	Futures	1576.12	1577.83	1573.57	1576.98	945.0
2009-05-21 06:00:00	NQ	Futures	1576.69	1578.97	1573.85	1575.56	1108.0
2009-05-21 07:00:00	NQ	Futures	1574.99	1576.41	1571.29	1574.7	2073.0
2009-05-21 08:00:00	NQ	Futures	1574.7	1575.84	1566.46	1566.75	5661.0
2009-05-21 09:00:00	NQ	Futures	1566.46	1580.39	1561.06	1569.3	47211.0
2009-05-21 10:00:00	NQ	Futures	1569.59	1576.41	1551.4	1552.54	72379.0
2009-05-21 11:00:00	NQ	Futures	1552.82	1555.95	1545.72	1555.1	48228.0
2009-05-21 12:00:00	NQ	Futures	1555.1	1556.23	1547.14	1551.97	27488.0
2009-05-21 13:00:00	NQ	Futures	1551.97	1555.38	1542.88	1547.14	27425.0
2009-05-21 14:00:00	NQ	Futures	1547.14	1551.4	1536.63	1541.74	39541.0
2009-05-21 15:00:00	NQ	Futures	1541.74	1554.53	1540.32	1553.68	49201.0
2009-05-21 16:00:00	NQ	Futures	1553.68	1559.93	1553.11	1557.09	10131.0
2009-05-21 17:00:00	NQ	Futures	1557.09	1557.65	1555.38	1555.67	208.0
2009-05-21 18:00:00	NQ	Futures	1556.52	1557.65	1554.81	1556.52	262.0
2009-05-21 19:00:00	NQ	Futures	1556.52	1557.09	1555.1	1555.1	177.0
2009-05-21 20:00:00	NQ	Futures	1555.1	1556.8	1554.53	1556.8	417.0
2009-05-21 21:00:00	NQ	Futures	1557.09	1562.2	1557.09	1561.35	329.0
2009-05-21 22:00:00	NQ	Futures	1561.35	1562.77	1560.78	1561.63	141.0
2009-05-21 23:00:00	NQ	Futures	1561.63	1561.92	1560.21	1560.78	122.0
2009-05-21 00:00:00	YM	Futures	7684.3	7693.4	7682.4	7690.7	286.0
2009-05-21 01:00:00	YM	Futures	7689.8	7701.7	7685.2	7699.9	429.0

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

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