PREVIEW / futures_1hour / 2009-07-02

all futures 1-hour files

  file:    by_date/futures_1hour/2009/2009-07-02.parquet
  size:    42 KB
  rows:    1,188

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-02 00:00:00	ES	Futures	884.84	885.08	884.36	884.6	1646.0
2009-07-02 01:00:00	ES	Futures	884.36	885.32	883.87	883.87	2195.0
2009-07-02 02:00:00	ES	Futures	884.11	886.28	883.87	885.56	7023.0
2009-07-02 03:00:00	ES	Futures	885.8	886.04	880.26	881.7	21547.0
2009-07-02 04:00:00	ES	Futures	881.7	882.91	881.22	882.91	7322.0
2009-07-02 05:00:00	ES	Futures	882.67	884.11	881.46	881.7	8645.0
2009-07-02 06:00:00	ES	Futures	881.7	881.94	879.77	880.5	9899.0
2009-07-02 07:00:00	ES	Futures	880.5	883.39	880.26	883.15	11763.0
2009-07-02 08:00:00	ES	Futures	883.15	883.15	873.02	874.95	148288.0
2009-07-02 09:00:00	ES	Futures	874.71	875.19	866.99	868.2	361307.0
2009-07-02 10:00:00	ES	Futures	868.44	869.64	865.54	867.96	339044.0
2009-07-02 11:00:00	ES	Futures	867.96	868.92	864.58	866.03	164491.0
2009-07-02 12:00:00	ES	Futures	866.03	867.23	865.06	865.79	94063.0
2009-07-02 13:00:00	ES	Futures	865.79	867.23	864.58	865.54	134109.0
2009-07-02 14:00:00	ES	Futures	865.54	866.75	864.82	866.03	104762.0
2009-07-02 15:00:00	ES	Futures	866.03	866.51	861.2	861.93	290178.0
2009-07-02 16:00:00	ES	Futures	861.93	863.13	857.59	858.79	146834.0
2009-07-02 17:00:00	ES	Futures	858.79	860.0	858.79	860.0	2996.0
2009-07-02 18:00:00	ES	Futures	859.52	860.24	858.31	860.0	2600.0
2009-07-02 19:00:00	ES	Futures	860.24	860.96	860.0	860.96	2207.0
2009-07-02 20:00:00	ES	Futures	860.72	861.69	860.48	861.69	2908.0
2009-07-02 21:00:00	ES	Futures	861.69	862.89	861.44	862.65	3731.0
2009-07-02 22:00:00	ES	Futures	862.65	863.61	862.41	863.37	3662.0
2009-07-02 23:00:00	ES	Futures	863.37	863.86	861.93	862.17	2855.0
2009-07-02 00:00:00	NQ	Futures	1680.67	1681.52	1680.38	1680.67	196.0
2009-07-02 01:00:00	NQ	Futures	1680.67	1681.81	1678.67	1678.96	202.0
2009-07-02 02:00:00	NQ	Futures	1678.67	1683.51	1678.67	1682.38	561.0
2009-07-02 03:00:00	NQ	Futures	1682.38	1682.66	1674.69	1676.39	1754.0
2009-07-02 04:00:00	NQ	Futures	1676.39	1677.82	1674.97	1677.53	893.0
2009-07-02 05:00:00	NQ	Futures	1677.53	1680.38	1675.25	1675.54	498.0
2009-07-02 06:00:00	NQ	Futures	1675.25	1676.39	1673.26	1673.83	1023.0
2009-07-02 07:00:00	NQ	Futures	1674.12	1678.67	1673.55	1678.67	1057.0
2009-07-02 08:00:00	NQ	Futures	1678.39	1683.23	1668.13	1671.27	19748.0
2009-07-02 09:00:00	NQ	Futures	1671.27	1672.12	1646.77	1648.77	69681.0
2009-07-02 10:00:00	NQ	Futures	1649.05	1652.75	1641.93	1650.48	52382.0
2009-07-02 11:00:00	NQ	Futures	1650.48	1651.33	1643.36	1647.91	23658.0
2009-07-02 12:00:00	NQ	Futures	1647.63	1649.91	1645.07	1648.2	14200.0
2009-07-02 13:00:00	NQ	Futures	1647.91	1651.33	1647.63	1648.77	14304.0
2009-07-02 14:00:00	NQ	Futures	1648.77	1653.32	1648.48	1651.62	12631.0
2009-07-02 15:00:00	NQ	Futures	1651.9	1652.75	1645.07	1646.49	35867.0
2009-07-02 16:00:00	NQ	Futures	1646.49	1649.62	1638.8	1640.22	15298.0
2009-07-02 17:00:00	NQ	Futures	1640.51	1642.79	1639.08	1641.36	238.0
2009-07-02 18:00:00	NQ	Futures	1641.36	1642.22	1639.37	1641.36	205.0
2009-07-02 19:00:00	NQ	Futures	1641.65	1643.36	1641.08	1641.93	297.0
2009-07-02 20:00:00	NQ	Futures	1642.5	1645.92	1642.5	1645.92	308.0
2009-07-02 21:00:00	NQ	Futures	1645.92	1647.63	1645.63	1647.06	207.0
2009-07-02 22:00:00	NQ	Futures	1647.34	1648.77	1646.77	1648.2	434.0
2009-07-02 23:00:00	NQ	Futures	1648.48	1649.05	1646.2	1646.77	267.0
2009-07-02 00:00:00	YM	Futures	7794.7	7796.6	7791.0	7794.7	120.0
2009-07-02 01:00:00	YM	Futures	7794.7	7797.5	7788.2	7788.2	75.0

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

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