PREVIEW / futures_1hour / 2010-01-12

all futures 1-hour files

  file:    by_date/futures_1hour/2010/2010-01-12.parquet
  size:    47 KB
  rows:    1,399

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
2010-01-12 00:00:00	ES	Futures	1108.53	1110.48	1108.53	1110.23	2388.0
2010-01-12 01:00:00	ES	Futures	1110.23	1112.18	1110.23	1111.45	11097.0
2010-01-12 02:00:00	ES	Futures	1111.45	1111.69	1109.75	1109.99	4350.0
2010-01-12 03:00:00	ES	Futures	1109.99	1110.96	1107.31	1107.56	28944.0
2010-01-12 04:00:00	ES	Futures	1107.56	1108.04	1105.37	1107.07	32147.0
2010-01-12 05:00:00	ES	Futures	1107.31	1108.77	1106.58	1107.8	13765.0
2010-01-12 06:00:00	ES	Futures	1108.04	1108.29	1102.45	1103.91	52782.0
2010-01-12 07:00:00	ES	Futures	1103.91	1105.61	1103.42	1104.39	25564.0
2010-01-12 08:00:00	ES	Futures	1104.39	1105.12	1102.21	1103.67	59471.0
2010-01-12 09:00:00	ES	Futures	1103.67	1106.58	1101.96	1106.1	288917.0
2010-01-12 10:00:00	ES	Futures	1106.34	1107.07	1104.15	1106.34	245642.0
2010-01-12 11:00:00	ES	Futures	1106.34	1106.58	1103.67	1103.91	185139.0
2010-01-12 12:00:00	ES	Futures	1103.91	1104.15	1097.83	1098.56	338331.0
2010-01-12 13:00:00	ES	Futures	1098.56	1100.5	1097.34	1100.02	173868.0
2010-01-12 14:00:00	ES	Futures	1100.26	1101.72	1098.31	1101.48	172385.0
2010-01-12 15:00:00	ES	Futures	1101.23	1101.96	1098.07	1101.48	290898.0
2010-01-12 16:00:00	ES	Futures	1101.48	1103.91	1101.48	1103.42	132745.0
2010-01-12 17:00:00	ES	Futures	1103.42	1103.91	1103.18	1103.67	1881.0
2010-01-12 18:00:00	ES	Futures	1103.18	1103.67	1102.69	1103.67	3986.0
2010-01-12 19:00:00	ES	Futures	1103.67	1105.85	1103.18	1104.64	6913.0
2010-01-12 20:00:00	ES	Futures	1104.64	1105.12	1103.42	1103.67	4769.0
2010-01-12 21:00:00	ES	Futures	1103.91	1106.34	1103.42	1104.15	10816.0
2010-01-12 22:00:00	ES	Futures	1103.91	1104.64	1103.18	1104.39	4791.0
2010-01-12 23:00:00	ES	Futures	1104.39	1105.61	1104.15	1105.37	3606.0
2010-01-12 00:00:00	NQ	Futures	2147.07	2149.64	2146.5	2149.07	208.0
2010-01-12 01:00:00	NQ	Futures	2149.64	2152.22	2149.64	2151.07	466.0
2010-01-12 02:00:00	NQ	Futures	2151.36	2151.64	2148.5	2149.07	454.0
2010-01-12 03:00:00	NQ	Futures	2148.79	2150.79	2142.22	2142.79	3313.0
2010-01-12 04:00:00	NQ	Futures	2142.79	2143.65	2138.79	2143.36	2340.0
2010-01-12 05:00:00	NQ	Futures	2143.36	2146.22	2141.93	2144.5	1167.0
2010-01-12 06:00:00	NQ	Futures	2144.79	2145.36	2134.79	2136.79	4744.0
2010-01-12 07:00:00	NQ	Futures	2136.79	2139.08	2136.22	2138.79	2744.0
2010-01-12 08:00:00	NQ	Futures	2138.79	2140.22	2135.08	2138.51	4646.0
2010-01-12 09:00:00	NQ	Futures	2138.51	2142.22	2126.79	2133.65	58003.0
2010-01-12 10:00:00	NQ	Futures	2133.65	2138.51	2131.36	2136.22	39651.0
2010-01-12 11:00:00	NQ	Futures	2135.93	2136.51	2129.08	2131.36	28911.0
2010-01-12 12:00:00	NQ	Futures	2131.36	2131.94	2113.94	2116.51	58220.0
2010-01-12 13:00:00	NQ	Futures	2116.23	2120.23	2113.66	2119.94	29100.0
2010-01-12 14:00:00	NQ	Futures	2120.23	2124.51	2116.51	2123.94	27573.0
2010-01-12 15:00:00	NQ	Futures	2123.65	2125.65	2117.94	2125.37	42454.0
2010-01-12 16:00:00	NQ	Futures	2125.65	2132.79	2125.08	2131.36	23202.0
2010-01-12 17:00:00	NQ	Futures	2131.08	2131.94	2130.79	2131.36	154.0
2010-01-12 18:00:00	NQ	Futures	2131.08	2131.65	2129.65	2130.51	908.0
2010-01-12 19:00:00	NQ	Futures	2130.51	2134.79	2130.22	2133.08	1036.0
2010-01-12 20:00:00	NQ	Futures	2133.08	2133.65	2130.51	2131.08	327.0
2010-01-12 21:00:00	NQ	Futures	2131.08	2135.93	2130.51	2130.51	904.0
2010-01-12 22:00:00	NQ	Futures	2130.51	2130.51	2128.79	2130.51	854.0
2010-01-12 23:00:00	NQ	Futures	2130.22	2132.79	2129.94	2132.22	402.0
2010-01-12 00:00:00	YM	Futures	9901.8	9912.1	9897.1	9912.1	135.0
2010-01-12 01:00:00	YM	Futures	9912.1	9922.4	9912.1	9918.7	395.0

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

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