PREVIEW / futures_1hour / 2009-06-19

all futures 1-hour files

  file:    by_date/futures_1hour/2009/2009-06-19.parquet
  size:    35 KB
  rows:    956

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-19 00:00:00	ES	Futures	881.94	882.91	881.94	882.67	1179.0
2009-06-19 01:00:00	ES	Futures	882.43	883.63	882.18	882.67	1604.0
2009-06-19 02:00:00	ES	Futures	882.67	883.63	881.94	883.39	4659.0
2009-06-19 03:00:00	ES	Futures	883.39	883.39	880.74	882.18	11737.0
2009-06-19 04:00:00	ES	Futures	882.18	883.87	881.7	882.43	11301.0
2009-06-19 05:00:00	ES	Futures	882.43	886.77	882.18	886.28	24156.0
2009-06-19 06:00:00	ES	Futures	886.04	887.73	885.08	887.01	15870.0
2009-06-19 07:00:00	ES	Futures	887.01	887.49	884.84	887.01	22092.0
2009-06-19 08:00:00	ES	Futures	886.77	889.9	886.53	888.45	50396.0
2009-06-19 09:00:00	ES	Futures	888.45	890.38	887.49	888.7	229380.0
2009-06-19 10:00:00	ES	Futures	888.94	890.14	885.32	889.18	216811.0
2009-06-19 11:00:00	ES	Futures	889.18	890.14	885.8	887.01	144422.0
2009-06-19 12:00:00	ES	Futures	887.01	887.25	881.46	881.7	170561.0
2009-06-19 13:00:00	ES	Futures	881.94	884.84	881.7	882.67	129204.0
2009-06-19 14:00:00	ES	Futures	882.43	883.15	878.57	881.94	145570.0
2009-06-19 15:00:00	ES	Futures	881.94	887.25	880.74	882.91	265172.0
2009-06-19 16:00:00	ES	Futures	883.15	883.87	881.7	883.63	85559.0
2009-06-19 00:00:00	NQ	Futures	1656.46	1658.17	1656.46	1656.74	166.0
2009-06-19 01:00:00	NQ	Futures	1657.31	1659.31	1657.03	1657.88	172.0
2009-06-19 02:00:00	NQ	Futures	1657.88	1658.74	1655.89	1658.45	396.0
2009-06-19 03:00:00	NQ	Futures	1658.17	1658.74	1653.04	1655.6	980.0
2009-06-19 04:00:00	NQ	Futures	1655.6	1659.31	1654.75	1655.32	780.0
2009-06-19 05:00:00	NQ	Futures	1655.6	1665.86	1655.6	1665.57	2249.0
2009-06-19 06:00:00	NQ	Futures	1665.57	1666.71	1663.58	1664.72	1215.0
2009-06-19 07:00:00	NQ	Futures	1664.43	1665.86	1659.59	1665.0	1998.0
2009-06-19 08:00:00	NQ	Futures	1664.72	1669.84	1663.58	1667.28	5774.0
2009-06-19 09:00:00	NQ	Futures	1667.28	1680.38	1665.86	1678.96	61471.0
2009-06-19 10:00:00	NQ	Futures	1678.67	1682.38	1673.55	1681.24	45514.0
2009-06-19 11:00:00	NQ	Futures	1681.24	1682.38	1674.97	1676.96	24014.0
2009-06-19 12:00:00	NQ	Futures	1676.68	1677.53	1667.28	1667.57	28155.0
2009-06-19 13:00:00	NQ	Futures	1667.57	1673.55	1667.0	1670.41	18412.0
2009-06-19 14:00:00	NQ	Futures	1670.41	1671.55	1661.58	1667.57	27933.0
2009-06-19 15:00:00	NQ	Futures	1667.85	1676.96	1665.57	1672.12	44240.0
2009-06-19 16:00:00	NQ	Futures	1672.41	1672.98	1668.13	1670.13	12785.0
2009-06-19 00:00:00	YM	Futures	7862.2	7866.8	7859.4	7864.1	71.0
2009-06-19 01:00:00	YM	Futures	7862.2	7872.4	7861.3	7865.0	167.0
2009-06-19 02:00:00	YM	Futures	7864.1	7874.2	7859.4	7870.5	321.0
2009-06-19 03:00:00	YM	Futures	7868.7	7872.4	7849.3	7862.2	646.0
2009-06-19 04:00:00	YM	Futures	7859.4	7873.3	7857.6	7861.3	439.0
2009-06-19 05:00:00	YM	Futures	7865.0	7898.3	7865.0	7892.7	1635.0
2009-06-19 06:00:00	YM	Futures	7892.7	7905.7	7882.5	7895.5	1682.0
2009-06-19 07:00:00	YM	Futures	7894.6	7902.0	7883.5	7898.3	1523.0
2009-06-19 08:00:00	YM	Futures	7899.2	7920.5	7894.6	7910.3	2581.0
2009-06-19 09:00:00	YM	Futures	7911.2	7918.6	7892.7	7904.7	16422.0
2009-06-19 10:00:00	YM	Futures	7905.7	7913.1	7875.1	7906.6	17073.0
2009-06-19 11:00:00	YM	Futures	7904.7	7913.1	7875.1	7880.7	9317.0
2009-06-19 12:00:00	YM	Futures	7879.8	7883.5	7830.8	7832.6	13460.0
2009-06-19 13:00:00	YM	Futures	7833.5	7856.7	7830.8	7835.4	8816.0
2009-06-19 14:00:00	YM	Futures	7835.4	7839.1	7801.2	7828.0	12652.0
2009-06-19 15:00:00	YM	Futures	7828.0	7868.7	7815.0	7838.2	18136.0

> showing 50 of 956 rows — these rows as CSV

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