PREVIEW / futures_1hour / 2010-01-11

all futures 1-hour files

  file:    by_date/futures_1hour/2010/2010-01-11.parquet
  size:    46 KB
  rows:    1,362

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-11 00:00:00	ES	Futures	1115.83	1116.07	1115.1	1115.34	1670.0
2010-01-11 01:00:00	ES	Futures	1115.1	1115.34	1114.37	1114.61	3380.0
2010-01-11 02:00:00	ES	Futures	1114.61	1115.1	1113.4	1113.88	11346.0
2010-01-11 03:00:00	ES	Futures	1113.88	1117.04	1113.4	1116.8	21108.0
2010-01-11 04:00:00	ES	Futures	1116.56	1117.04	1115.83	1116.56	10828.0
2010-01-11 05:00:00	ES	Futures	1116.56	1117.04	1115.83	1116.56	8091.0
2010-01-11 06:00:00	ES	Futures	1116.8	1117.04	1114.13	1115.1	12036.0
2010-01-11 07:00:00	ES	Futures	1115.34	1115.34	1113.64	1114.13	15882.0
2010-01-11 08:00:00	ES	Futures	1114.13	1115.83	1113.88	1114.86	23972.0
2010-01-11 09:00:00	ES	Futures	1114.86	1115.83	1110.72	1111.21	213783.0
2010-01-11 10:00:00	ES	Futures	1110.96	1112.18	1108.53	1110.96	263764.0
2010-01-11 11:00:00	ES	Futures	1110.72	1110.96	1107.56	1110.48	188800.0
2010-01-11 12:00:00	ES	Futures	1110.48	1110.72	1107.07	1108.29	126839.0
2010-01-11 13:00:00	ES	Futures	1108.53	1110.23	1107.8	1109.99	82424.0
2010-01-11 14:00:00	ES	Futures	1109.75	1110.72	1109.02	1109.99	105131.0
2010-01-11 15:00:00	ES	Futures	1109.99	1113.4	1109.99	1112.18	252715.0
2010-01-11 16:00:00	ES	Futures	1111.94	1112.42	1108.77	1109.26	91860.0
2010-01-11 17:00:00	ES	Futures	1109.26	1109.75	1108.77	1109.75	3774.0
2010-01-11 18:00:00	ES	Futures	1109.5	1109.75	1108.29	1108.77	5389.0
2010-01-11 19:00:00	ES	Futures	1109.02	1111.21	1108.77	1110.96	6015.0
2010-01-11 20:00:00	ES	Futures	1110.96	1111.21	1109.75	1109.75	4649.0
2010-01-11 21:00:00	ES	Futures	1109.99	1109.99	1107.56	1108.53	9459.0
2010-01-11 22:00:00	ES	Futures	1108.53	1109.5	1108.29	1108.77	2579.0
2010-01-11 23:00:00	ES	Futures	1108.77	1109.02	1108.29	1108.53	1400.0
2010-01-11 00:00:00	NQ	Futures	2169.64	2169.92	2168.21	2168.21	45.0
2010-01-11 01:00:00	NQ	Futures	2168.21	2168.5	2166.5	2166.5	203.0
2010-01-11 02:00:00	NQ	Futures	2166.5	2167.07	2164.21	2165.35	890.0
2010-01-11 03:00:00	NQ	Futures	2165.35	2169.92	2164.21	2169.92	3820.0
2010-01-11 04:00:00	NQ	Futures	2169.92	2169.92	2167.93	2168.5	1082.0
2010-01-11 05:00:00	NQ	Futures	2168.21	2170.5	2167.64	2169.92	904.0
2010-01-11 06:00:00	NQ	Futures	2170.21	2170.5	2157.07	2166.5	4022.0
2010-01-11 07:00:00	NQ	Futures	2166.21	2166.5	2163.64	2164.21	2111.0
2010-01-11 08:00:00	NQ	Futures	2164.21	2167.35	2163.07	2163.93	3485.0
2010-01-11 09:00:00	NQ	Futures	2163.93	2165.64	2150.79	2151.36	46520.0
2010-01-11 10:00:00	NQ	Futures	2151.36	2154.79	2141.36	2148.79	52057.0
2010-01-11 11:00:00	NQ	Futures	2148.5	2150.5	2141.93	2150.22	29330.0
2010-01-11 12:00:00	NQ	Futures	2150.22	2152.5	2143.65	2145.93	19613.0
2010-01-11 13:00:00	NQ	Futures	2145.93	2148.79	2144.22	2146.5	11235.0
2010-01-11 14:00:00	NQ	Futures	2146.5	2147.36	2143.65	2145.36	21848.0
2010-01-11 15:00:00	NQ	Futures	2145.07	2155.36	2144.79	2152.79	34878.0
2010-01-11 16:00:00	NQ	Futures	2152.79	2153.93	2145.65	2146.22	10367.0
2010-01-11 17:00:00	NQ	Futures	2146.5	2148.79	2146.22	2147.07	313.0
2010-01-11 18:00:00	NQ	Futures	2147.07	2147.65	2145.93	2147.07	188.0
2010-01-11 19:00:00	NQ	Futures	2146.79	2150.79	2146.79	2150.5	376.0
2010-01-11 20:00:00	NQ	Futures	2150.22	2151.07	2148.22	2148.22	252.0
2010-01-11 21:00:00	NQ	Futures	2148.5	2148.79	2144.22	2145.65	601.0
2010-01-11 22:00:00	NQ	Futures	2145.65	2148.5	2145.36	2146.79	297.0
2010-01-11 23:00:00	NQ	Futures	2146.79	2147.36	2146.5	2146.79	73.0
2010-01-11 00:00:00	YM	Futures	9926.2	9927.1	9920.5	9920.5	146.0
2010-01-11 01:00:00	YM	Futures	9921.5	9921.5	9914.9	9914.9	75.0

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

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