PREVIEW / futures_1hour / 2009-07-09

all futures 1-hour files

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

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-09 00:00:00	ES	Futures	846.73	846.97	846.01	846.25	1789.0
2009-07-09 01:00:00	ES	Futures	846.25	846.73	846.01	846.25	1923.0
2009-07-09 02:00:00	ES	Futures	846.49	848.42	845.77	848.18	8880.0
2009-07-09 03:00:00	ES	Futures	848.18	849.87	846.73	849.87	21272.0
2009-07-09 04:00:00	ES	Futures	849.87	850.83	849.14	849.87	11910.0
2009-07-09 05:00:00	ES	Futures	849.63	851.8	849.39	850.83	13898.0
2009-07-09 06:00:00	ES	Futures	850.83	851.8	849.14	849.14	10997.0
2009-07-09 07:00:00	ES	Futures	849.39	850.35	847.7	850.11	17858.0
2009-07-09 08:00:00	ES	Futures	849.87	853.0	848.9	851.07	75458.0
2009-07-09 09:00:00	ES	Futures	851.07	851.56	844.8	846.97	260012.0
2009-07-09 10:00:00	ES	Futures	847.22	849.87	844.32	847.7	331593.0
2009-07-09 11:00:00	ES	Futures	847.7	850.11	843.36	847.7	220252.0
2009-07-09 12:00:00	ES	Futures	847.7	850.83	846.73	850.35	115657.0
2009-07-09 13:00:00	ES	Futures	850.35	851.8	847.22	850.35	168025.0
2009-07-09 14:00:00	ES	Futures	850.11	853.24	849.39	849.87	156795.0
2009-07-09 15:00:00	ES	Futures	849.87	850.35	845.77	846.73	253889.0
2009-07-09 16:00:00	ES	Futures	846.49	848.18	845.77	847.7	76684.0
2009-07-09 17:00:00	ES	Futures	847.7	847.7	847.22	847.46	1179.0
2009-07-09 18:00:00	ES	Futures	847.7	847.94	846.97	847.46	1584.0
2009-07-09 19:00:00	ES	Futures	847.22	847.94	847.22	847.7	957.0
2009-07-09 20:00:00	ES	Futures	847.7	847.94	847.22	847.94	1643.0
2009-07-09 21:00:00	ES	Futures	847.7	848.18	846.25	846.25	3018.0
2009-07-09 22:00:00	ES	Futures	846.49	846.73	844.56	844.8	4483.0
2009-07-09 23:00:00	ES	Futures	845.05	846.49	844.8	845.77	1710.0
2009-07-09 00:00:00	NQ	Futures	1607.47	1608.32	1606.62	1606.9	87.0
2009-07-09 01:00:00	NQ	Futures	1607.47	1607.47	1606.05	1606.9	97.0
2009-07-09 02:00:00	NQ	Futures	1606.9	1610.32	1606.33	1609.46	503.0
2009-07-09 03:00:00	NQ	Futures	1609.46	1611.17	1606.62	1610.89	1337.0
2009-07-09 04:00:00	NQ	Futures	1610.89	1613.45	1610.32	1611.46	950.0
2009-07-09 05:00:00	NQ	Futures	1611.46	1614.31	1611.17	1612.6	1007.0
2009-07-09 06:00:00	NQ	Futures	1612.6	1614.88	1611.17	1611.17	1342.0
2009-07-09 07:00:00	NQ	Futures	1611.46	1613.17	1608.32	1612.88	1484.0
2009-07-09 08:00:00	NQ	Futures	1612.88	1617.44	1610.32	1614.88	5039.0
2009-07-09 09:00:00	NQ	Futures	1614.88	1616.01	1602.34	1607.47	40956.0
2009-07-09 10:00:00	NQ	Futures	1607.75	1612.88	1602.91	1608.89	37613.0
2009-07-09 11:00:00	NQ	Futures	1609.18	1615.44	1602.63	1611.46	28576.0
2009-07-09 12:00:00	NQ	Futures	1611.17	1616.01	1610.03	1614.31	15037.0
2009-07-09 13:00:00	NQ	Futures	1614.31	1618.86	1609.46	1614.31	25325.0
2009-07-09 14:00:00	NQ	Futures	1614.02	1619.15	1612.88	1615.16	19450.0
2009-07-09 15:00:00	NQ	Futures	1615.16	1616.01	1605.76	1607.75	33921.0
2009-07-09 16:00:00	NQ	Futures	1607.75	1610.89	1606.33	1610.32	8919.0
2009-07-09 17:00:00	NQ	Futures	1610.32	1611.17	1610.03	1610.32	245.0
2009-07-09 18:00:00	NQ	Futures	1610.32	1610.89	1610.03	1610.6	50.0
2009-07-09 19:00:00	NQ	Futures	1610.6	1611.17	1610.6	1611.17	89.0
2009-07-09 20:00:00	NQ	Futures	1610.89	1610.89	1609.75	1610.89	230.0
2009-07-09 21:00:00	NQ	Futures	1610.89	1610.89	1608.04	1608.32	136.0
2009-07-09 22:00:00	NQ	Futures	1608.04	1608.32	1604.91	1605.19	241.0
2009-07-09 23:00:00	NQ	Futures	1605.19	1606.62	1604.91	1606.05	133.0
2009-07-09 00:00:00	YM	Futures	7528.4	7533.0	7525.6	7528.4	105.0
2009-07-09 01:00:00	YM	Futures	7528.4	7531.2	7525.6	7526.6	72.0

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

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