PREVIEW / futures_1hour / 2009-06-23

all futures 1-hour files

  file:    by_date/futures_1hour/2009/2009-06-23.parquet
  size:    42 KB
  rows:    1,246

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-23 00:00:00	ES	Futures	857.59	858.55	857.34	858.07	3065.0
2009-06-23 01:00:00	ES	Futures	857.83	858.31	855.9	855.9	4411.0
2009-06-23 02:00:00	ES	Futures	855.9	860.0	855.17	858.31	15814.0
2009-06-23 03:00:00	ES	Futures	858.31	862.17	858.07	860.72	24044.0
2009-06-23 04:00:00	ES	Futures	860.72	861.69	857.34	861.2	16695.0
2009-06-23 05:00:00	ES	Futures	861.2	862.65	860.48	860.96	14611.0
2009-06-23 06:00:00	ES	Futures	860.96	862.17	860.24	860.96	11235.0
2009-06-23 07:00:00	ES	Futures	860.96	861.44	859.52	860.0	16218.0
2009-06-23 08:00:00	ES	Futures	860.0	862.65	860.0	860.72	49585.0
2009-06-23 09:00:00	ES	Futures	860.72	862.41	857.83	861.93	258547.0
2009-06-23 10:00:00	ES	Futures	861.93	862.89	853.97	856.14	434117.0
2009-06-23 11:00:00	ES	Futures	856.14	858.79	853.0	858.55	214193.0
2009-06-23 12:00:00	ES	Futures	858.55	860.24	856.38	858.55	169710.0
2009-06-23 13:00:00	ES	Futures	858.55	861.69	856.86	856.86	134505.0
2009-06-23 14:00:00	ES	Futures	856.86	861.44	856.38	858.79	131503.0
2009-06-23 15:00:00	ES	Futures	858.79	861.93	856.62	858.55	227179.0
2009-06-23 16:00:00	ES	Futures	858.55	859.03	857.1	858.55	80933.0
2009-06-23 17:00:00	ES	Futures	858.55	858.79	857.59	858.31	1165.0
2009-06-23 18:00:00	ES	Futures	858.55	858.79	857.83	858.31	2079.0
2009-06-23 19:00:00	ES	Futures	858.07	858.55	857.1	858.31	2355.0
2009-06-23 20:00:00	ES	Futures	858.55	858.55	857.59	857.83	1617.0
2009-06-23 21:00:00	ES	Futures	858.07	858.07	856.86	857.1	1694.0
2009-06-23 22:00:00	ES	Futures	857.1	857.83	856.86	857.59	1635.0
2009-06-23 23:00:00	ES	Futures	857.34	859.52	857.34	859.03	2592.0
2009-06-23 00:00:00	NQ	Futures	1626.84	1627.98	1626.27	1626.84	150.0
2009-06-23 01:00:00	NQ	Futures	1626.55	1627.69	1623.7	1623.99	269.0
2009-06-23 02:00:00	NQ	Futures	1623.99	1630.54	1622.28	1627.41	692.0
2009-06-23 03:00:00	NQ	Futures	1626.84	1633.96	1626.27	1630.25	1690.0
2009-06-23 04:00:00	NQ	Futures	1630.25	1632.25	1624.56	1631.11	1884.0
2009-06-23 05:00:00	NQ	Futures	1631.39	1633.67	1629.69	1630.82	752.0
2009-06-23 06:00:00	NQ	Futures	1630.25	1632.53	1629.4	1631.39	888.0
2009-06-23 07:00:00	NQ	Futures	1631.39	1632.53	1629.12	1630.25	1526.0
2009-06-23 08:00:00	NQ	Futures	1630.25	1633.67	1629.4	1631.11	3312.0
2009-06-23 09:00:00	NQ	Futures	1631.11	1631.96	1615.73	1621.71	43547.0
2009-06-23 10:00:00	NQ	Futures	1621.71	1624.84	1609.46	1613.74	58394.0
2009-06-23 11:00:00	NQ	Futures	1614.02	1620.0	1608.61	1619.43	25727.0
2009-06-23 12:00:00	NQ	Futures	1619.72	1620.86	1613.17	1616.87	24695.0
2009-06-23 13:00:00	NQ	Futures	1617.15	1623.42	1614.88	1615.44	22399.0
2009-06-23 14:00:00	NQ	Futures	1615.16	1625.98	1614.02	1623.13	24593.0
2009-06-23 15:00:00	NQ	Futures	1623.13	1626.84	1619.15	1619.72	35612.0
2009-06-23 16:00:00	NQ	Futures	1619.72	1623.13	1613.74	1621.71	11375.0
2009-06-23 17:00:00	NQ	Futures	1621.71	1622.28	1618.86	1621.71	972.0
2009-06-23 18:00:00	NQ	Futures	1621.71	1621.71	1620.0	1621.14	85.0
2009-06-23 19:00:00	NQ	Futures	1621.43	1622.85	1620.29	1622.85	99.0
2009-06-23 20:00:00	NQ	Futures	1622.28	1622.57	1620.29	1620.29	80.0
2009-06-23 21:00:00	NQ	Futures	1621.14	1621.14	1618.29	1618.58	290.0
2009-06-23 22:00:00	NQ	Futures	1618.29	1620.29	1617.72	1620.0	102.0
2009-06-23 23:00:00	NQ	Futures	1619.72	1623.13	1619.72	1622.85	150.0
2009-06-23 00:00:00	YM	Futures	7663.4	7669.0	7658.8	7661.6	259.0
2009-06-23 01:00:00	YM	Futures	7660.6	7664.3	7643.1	7648.6	314.0

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

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