PREVIEW / futures_1hour / 2010-01-13

all futures 1-hour files

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

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-13 00:00:00	ES	Futures	1105.12	1105.85	1104.15	1104.15	3223.0
2010-01-13 01:00:00	ES	Futures	1104.15	1104.15	1103.42	1103.67	3683.0
2010-01-13 02:00:00	ES	Futures	1103.67	1103.67	1101.72	1101.72	10831.0
2010-01-13 03:00:00	ES	Futures	1101.96	1105.61	1101.72	1104.88	21983.0
2010-01-13 04:00:00	ES	Futures	1104.88	1106.34	1104.39	1105.12	17466.0
2010-01-13 05:00:00	ES	Futures	1105.12	1105.61	1103.42	1104.64	15319.0
2010-01-13 06:00:00	ES	Futures	1104.64	1104.88	1103.67	1103.91	10005.0
2010-01-13 07:00:00	ES	Futures	1103.91	1106.58	1103.67	1106.1	19479.0
2010-01-13 08:00:00	ES	Futures	1106.1	1106.83	1104.88	1105.12	30834.0
2010-01-13 09:00:00	ES	Futures	1104.88	1106.1	1102.94	1103.42	208471.0
2010-01-13 10:00:00	ES	Futures	1103.42	1103.91	1098.8	1102.21	356207.0
2010-01-13 11:00:00	ES	Futures	1102.21	1106.1	1101.23	1105.37	246611.0
2010-01-13 12:00:00	ES	Futures	1105.37	1110.23	1105.37	1108.29	460228.0
2010-01-13 13:00:00	ES	Futures	1108.29	1109.75	1107.56	1108.04	141254.0
2010-01-13 14:00:00	ES	Futures	1108.04	1111.69	1107.8	1111.45	172541.0
2010-01-13 15:00:00	ES	Futures	1111.45	1114.37	1110.23	1111.45	285667.0
2010-01-13 16:00:00	ES	Futures	1111.45	1111.45	1110.48	1110.96	80518.0
2010-01-13 17:00:00	ES	Futures	1110.96	1111.21	1110.48	1110.48	797.0
2010-01-13 18:00:00	ES	Futures	1110.48	1111.21	1110.23	1111.21	1801.0
2010-01-13 19:00:00	ES	Futures	1110.96	1112.91	1110.72	1112.67	6684.0
2010-01-13 20:00:00	ES	Futures	1112.67	1113.15	1111.69	1112.67	3000.0
2010-01-13 21:00:00	ES	Futures	1112.67	1113.88	1112.42	1113.15	4102.0
2010-01-13 22:00:00	ES	Futures	1113.4	1114.13	1112.91	1113.4	3240.0
2010-01-13 23:00:00	ES	Futures	1113.4	1113.88	1112.91	1113.64	1500.0
2010-01-13 00:00:00	NQ	Futures	2132.22	2133.36	2131.36	2131.36	368.0
2010-01-13 01:00:00	NQ	Futures	2131.08	2131.65	2130.51	2130.51	221.0
2010-01-13 02:00:00	NQ	Futures	2130.22	2130.51	2126.51	2126.51	799.0
2010-01-13 03:00:00	NQ	Futures	2126.51	2133.94	2126.51	2132.79	2986.0
2010-01-13 04:00:00	NQ	Futures	2132.51	2135.93	2131.94	2133.36	1485.0
2010-01-13 05:00:00	NQ	Futures	2133.65	2134.79	2131.08	2133.08	992.0
2010-01-13 06:00:00	NQ	Futures	2132.79	2133.08	2131.36	2132.22	648.0
2010-01-13 07:00:00	NQ	Futures	2131.94	2136.79	2131.36	2135.08	1423.0
2010-01-13 08:00:00	NQ	Futures	2135.08	2137.08	2132.51	2132.51	2428.0
2010-01-13 09:00:00	NQ	Futures	2132.51	2139.08	2127.65	2127.94	41292.0
2010-01-13 10:00:00	NQ	Futures	2128.22	2129.37	2117.37	2127.65	50152.0
2010-01-13 11:00:00	NQ	Futures	2127.94	2132.79	2124.51	2130.22	29458.0
2010-01-13 12:00:00	NQ	Futures	2130.22	2145.93	2130.22	2143.65	45775.0
2010-01-13 13:00:00	NQ	Futures	2143.65	2149.93	2141.36	2146.79	31400.0
2010-01-13 14:00:00	NQ	Futures	2146.5	2153.93	2146.22	2153.93	37482.0
2010-01-13 15:00:00	NQ	Futures	2153.93	2158.79	2149.64	2151.93	48292.0
2010-01-13 16:00:00	NQ	Futures	2151.93	2152.22	2149.64	2150.22	13446.0
2010-01-13 17:00:00	NQ	Futures	2150.22	2150.79	2149.93	2149.93	120.0
2010-01-13 18:00:00	NQ	Futures	2149.93	2151.07	2148.79	2150.79	228.0
2010-01-13 19:00:00	NQ	Futures	2150.5	2153.36	2150.5	2153.07	774.0
2010-01-13 20:00:00	NQ	Futures	2153.07	2153.64	2151.07	2153.64	405.0
2010-01-13 21:00:00	NQ	Futures	2153.64	2156.5	2153.36	2155.36	683.0
2010-01-13 22:00:00	NQ	Futures	2155.64	2156.21	2154.5	2155.07	526.0
2010-01-13 23:00:00	NQ	Futures	2155.07	2155.64	2154.21	2155.07	174.0
2010-01-13 00:00:00	YM	Futures	9919.6	9924.3	9911.2	9911.2	170.0
2010-01-13 01:00:00	YM	Futures	9910.2	9911.2	9905.6	9906.5	196.0

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

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