PREVIEW / futures_1hour / 2009-07-13

all futures 1-hour files

  file:    by_date/futures_1hour/2009/2009-07-13.parquet
  size:    44 KB
  rows:    1,266

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-13 00:00:00	ES	Futures	838.05	839.74	835.4	836.6	4359.0
2009-07-13 01:00:00	ES	Futures	836.36	837.57	835.16	836.12	3925.0
2009-07-13 02:00:00	ES	Futures	835.88	838.53	834.92	838.53	8289.0
2009-07-13 03:00:00	ES	Futures	838.29	840.95	836.6	840.95	21428.0
2009-07-13 04:00:00	ES	Futures	840.7	842.15	839.5	840.22	11016.0
2009-07-13 05:00:00	ES	Futures	840.22	840.7	837.81	837.81	10073.0
2009-07-13 06:00:00	ES	Futures	837.81	844.32	837.33	844.08	17050.0
2009-07-13 07:00:00	ES	Futures	844.08	844.56	840.22	844.08	23107.0
2009-07-13 08:00:00	ES	Futures	844.08	850.59	844.08	848.9	57357.0
2009-07-13 09:00:00	ES	Futures	848.9	850.11	844.08	844.56	226987.0
2009-07-13 10:00:00	ES	Futures	844.56	852.28	840.46	852.04	382567.0
2009-07-13 11:00:00	ES	Futures	852.04	859.76	850.59	858.55	348450.0
2009-07-13 12:00:00	ES	Futures	858.55	859.52	856.86	857.59	109749.0
2009-07-13 13:00:00	ES	Futures	857.83	861.69	857.34	860.0	142327.0
2009-07-13 14:00:00	ES	Futures	860.0	862.65	859.27	860.72	178282.0
2009-07-13 15:00:00	ES	Futures	860.72	865.54	860.24	865.06	338744.0
2009-07-13 16:00:00	ES	Futures	865.06	866.03	862.89	863.61	144494.0
2009-07-13 17:00:00	ES	Futures	863.61	864.58	863.13	863.86	2897.0
2009-07-13 18:00:00	ES	Futures	864.34	865.3	863.37	863.61	2553.0
2009-07-13 19:00:00	ES	Futures	863.61	863.86	862.89	863.37	2928.0
2009-07-13 20:00:00	ES	Futures	863.37	863.61	861.93	862.17	5646.0
2009-07-13 21:00:00	ES	Futures	861.93	863.37	861.93	863.37	3749.0
2009-07-13 22:00:00	ES	Futures	863.13	863.61	862.65	863.37	1768.0
2009-07-13 23:00:00	ES	Futures	863.13	866.03	863.13	865.79	4696.0
2009-07-13 00:00:00	NQ	Futures	1604.62	1607.47	1600.63	1601.77	398.0
2009-07-13 01:00:00	NQ	Futures	1602.06	1604.05	1600.63	1601.2	379.0
2009-07-13 02:00:00	NQ	Futures	1601.2	1602.34	1598.64	1602.06	1093.0
2009-07-13 03:00:00	NQ	Futures	1602.06	1605.76	1598.36	1605.48	1890.0
2009-07-13 04:00:00	NQ	Futures	1605.48	1608.61	1603.77	1604.91	1352.0
2009-07-13 05:00:00	NQ	Futures	1604.91	1606.33	1601.77	1601.77	1089.0
2009-07-13 06:00:00	NQ	Futures	1601.77	1614.31	1601.2	1613.45	1517.0
2009-07-13 07:00:00	NQ	Futures	1613.45	1616.01	1608.04	1615.44	2381.0
2009-07-13 08:00:00	NQ	Futures	1615.16	1625.98	1615.16	1622.0	4796.0
2009-07-13 09:00:00	NQ	Futures	1621.71	1622.85	1596.65	1601.2	52790.0
2009-07-13 10:00:00	NQ	Futures	1601.2	1625.13	1594.37	1624.84	61918.0
2009-07-13 11:00:00	NQ	Futures	1624.84	1641.65	1621.71	1638.8	61647.0
2009-07-13 12:00:00	NQ	Futures	1638.8	1639.94	1633.96	1634.81	22068.0
2009-07-13 13:00:00	NQ	Futures	1634.81	1642.5	1633.1	1639.37	19121.0
2009-07-13 14:00:00	NQ	Futures	1639.08	1645.35	1637.66	1640.79	29447.0
2009-07-13 15:00:00	NQ	Futures	1640.51	1647.06	1639.08	1645.92	45044.0
2009-07-13 16:00:00	NQ	Futures	1645.92	1648.2	1641.65	1642.79	16425.0
2009-07-13 17:00:00	NQ	Futures	1643.07	1644.21	1641.93	1643.93	360.0
2009-07-13 18:00:00	NQ	Futures	1643.36	1644.5	1642.5	1642.5	137.0
2009-07-13 19:00:00	NQ	Futures	1642.79	1643.36	1642.22	1643.36	123.0
2009-07-13 20:00:00	NQ	Futures	1643.07	1643.07	1640.51	1640.51	338.0
2009-07-13 21:00:00	NQ	Futures	1640.51	1641.36	1639.94	1641.36	297.0
2009-07-13 22:00:00	NQ	Futures	1641.08	1641.36	1640.22	1641.08	195.0
2009-07-13 23:00:00	NQ	Futures	1641.08	1645.07	1640.79	1645.07	320.0
2009-07-13 00:00:00	YM	Futures	7435.9	7449.8	7415.6	7423.0	391.0
2009-07-13 01:00:00	YM	Futures	7421.1	7433.2	7415.6	7421.1	217.0

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

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