PREVIEW / futures_1hour / 2009-06-30

all futures 1-hour files

  file:    by_date/futures_1hour/2009/2009-06-30.parquet
  size:    43 KB
  rows:    1,257

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-30 00:00:00	ES	Futures	888.7	889.42	887.73	888.45	2373.0
2009-06-30 01:00:00	ES	Futures	888.45	890.14	888.45	890.14	1684.0
2009-06-30 02:00:00	ES	Futures	890.14	891.11	888.21	890.63	10763.0
2009-06-30 03:00:00	ES	Futures	890.87	891.59	889.18	890.63	18975.0
2009-06-30 04:00:00	ES	Futures	890.38	892.07	889.42	891.59	12274.0
2009-06-30 05:00:00	ES	Futures	891.35	892.31	890.63	891.83	8175.0
2009-06-30 06:00:00	ES	Futures	891.83	892.55	891.11	891.83	9351.0
2009-06-30 07:00:00	ES	Futures	891.83	892.07	889.66	889.9	12206.0
2009-06-30 08:00:00	ES	Futures	890.14	891.35	889.42	891.35	12151.0
2009-06-30 09:00:00	ES	Futures	891.35	893.52	889.42	891.59	196168.0
2009-06-30 10:00:00	ES	Futures	891.59	892.07	878.57	880.74	502941.0
2009-06-30 11:00:00	ES	Futures	880.74	881.46	876.16	878.33	294532.0
2009-06-30 12:00:00	ES	Futures	878.33	880.5	877.12	879.77	115580.0
2009-06-30 13:00:00	ES	Futures	879.77	880.01	877.36	877.84	82735.0
2009-06-30 14:00:00	ES	Futures	877.84	881.46	877.12	880.26	138568.0
2009-06-30 15:00:00	ES	Futures	880.5	884.11	879.05	883.63	435669.0
2009-06-30 16:00:00	ES	Futures	883.63	884.36	881.46	883.39	162841.0
2009-06-30 17:00:00	ES	Futures	883.39	883.39	882.67	883.15	1733.0
2009-06-30 18:00:00	ES	Futures	883.15	883.39	881.94	882.18	1863.0
2009-06-30 19:00:00	ES	Futures	882.18	883.15	881.94	882.67	2405.0
2009-06-30 20:00:00	ES	Futures	882.91	884.36	882.67	883.63	3867.0
2009-06-30 21:00:00	ES	Futures	883.87	884.11	881.7	882.91	4933.0
2009-06-30 22:00:00	ES	Futures	882.67	884.11	882.43	883.87	3171.0
2009-06-30 23:00:00	ES	Futures	884.11	885.08	883.63	884.84	3447.0
2009-06-30 00:00:00	NQ	Futures	1688.36	1689.21	1685.79	1686.93	103.0
2009-06-30 01:00:00	NQ	Futures	1686.93	1691.77	1686.93	1691.49	106.0
2009-06-30 02:00:00	NQ	Futures	1690.35	1692.63	1687.79	1692.34	641.0
2009-06-30 03:00:00	NQ	Futures	1692.34	1692.91	1688.07	1690.07	1100.0
2009-06-30 04:00:00	NQ	Futures	1690.07	1692.91	1688.07	1691.49	1088.0
2009-06-30 05:00:00	NQ	Futures	1692.06	1693.77	1690.63	1693.48	730.0
2009-06-30 06:00:00	NQ	Futures	1693.2	1694.62	1691.49	1692.34	671.0
2009-06-30 07:00:00	NQ	Futures	1692.34	1692.63	1688.64	1690.35	1039.0
2009-06-30 08:00:00	NQ	Futures	1690.35	1691.77	1688.36	1691.49	1718.0
2009-06-30 09:00:00	NQ	Futures	1691.49	1699.46	1688.36	1694.91	25164.0
2009-06-30 10:00:00	NQ	Futures	1694.91	1696.05	1673.26	1681.81	64138.0
2009-06-30 11:00:00	NQ	Futures	1681.81	1682.94	1674.12	1676.11	32650.0
2009-06-30 12:00:00	NQ	Futures	1676.11	1678.67	1671.84	1675.25	20928.0
2009-06-30 13:00:00	NQ	Futures	1675.25	1676.39	1672.41	1672.69	14566.0
2009-06-30 14:00:00	NQ	Futures	1672.69	1678.1	1669.84	1676.11	22206.0
2009-06-30 15:00:00	NQ	Futures	1676.11	1684.37	1673.83	1683.8	42453.0
2009-06-30 16:00:00	NQ	Futures	1683.8	1685.51	1680.67	1680.95	11456.0
2009-06-30 17:00:00	NQ	Futures	1681.81	1682.09	1680.38	1681.24	166.0
2009-06-30 18:00:00	NQ	Futures	1682.09	1682.09	1679.81	1679.81	238.0
2009-06-30 19:00:00	NQ	Futures	1679.81	1681.24	1679.53	1680.1	101.0
2009-06-30 20:00:00	NQ	Futures	1680.67	1684.08	1680.67	1683.51	295.0
2009-06-30 21:00:00	NQ	Futures	1683.51	1683.8	1680.95	1682.38	328.0
2009-06-30 22:00:00	NQ	Futures	1682.38	1684.94	1682.09	1684.65	109.0
2009-06-30 23:00:00	NQ	Futures	1684.08	1688.07	1683.8	1686.36	266.0
2009-06-30 00:00:00	YM	Futures	7820.6	7824.3	7816.0	7819.7	78.0
2009-06-30 01:00:00	YM	Futures	7820.6	7832.6	7820.6	7832.6	78.0

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

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