PREVIEW / futures_1hour / 2010-01-26

all futures 1-hour files

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

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-26 00:00:00	ES	Futures	1052.82	1055.5	1051.85	1054.77	8695.0
2010-01-26 01:00:00	ES	Futures	1054.77	1055.26	1053.07	1053.31	5702.0
2010-01-26 02:00:00	ES	Futures	1053.07	1055.99	1053.07	1055.5	19273.0
2010-01-26 03:00:00	ES	Futures	1055.74	1058.18	1055.26	1057.2	39735.0
2010-01-26 04:00:00	ES	Futures	1056.96	1058.91	1055.5	1055.74	27947.0
2010-01-26 05:00:00	ES	Futures	1055.74	1057.69	1054.04	1057.45	23045.0
2010-01-26 06:00:00	ES	Futures	1057.69	1058.18	1055.99	1057.2	15867.0
2010-01-26 07:00:00	ES	Futures	1057.45	1061.34	1056.47	1060.61	47252.0
2010-01-26 08:00:00	ES	Futures	1060.61	1062.55	1058.91	1059.64	78716.0
2010-01-26 09:00:00	ES	Futures	1059.88	1062.31	1056.72	1059.64	304780.0
2010-01-26 10:00:00	ES	Futures	1059.39	1066.45	1058.18	1063.28	433666.0
2010-01-26 11:00:00	ES	Futures	1063.04	1068.64	1062.55	1067.42	256702.0
2010-01-26 12:00:00	ES	Futures	1067.42	1070.34	1066.93	1069.85	144250.0
2010-01-26 13:00:00	ES	Futures	1070.1	1070.1	1067.18	1070.1	130568.0
2010-01-26 14:00:00	ES	Futures	1070.1	1070.34	1065.23	1067.42	204993.0
2010-01-26 15:00:00	ES	Futures	1067.42	1067.66	1058.18	1058.91	455230.0
2010-01-26 16:00:00	ES	Futures	1058.91	1059.88	1056.23	1059.64	129340.0
2010-01-26 17:00:00	ES	Futures	1059.64	1060.85	1059.39	1060.12	4319.0
2010-01-26 18:00:00	ES	Futures	1059.88	1063.04	1059.64	1060.61	8816.0
2010-01-26 19:00:00	ES	Futures	1060.61	1062.07	1058.18	1060.85	11492.0
2010-01-26 20:00:00	ES	Futures	1060.85	1062.31	1058.66	1062.07	10724.0
2010-01-26 21:00:00	ES	Futures	1062.07	1062.55	1059.39	1060.37	7959.0
2010-01-26 22:00:00	ES	Futures	1060.61	1061.82	1059.64	1059.88	4025.0
2010-01-26 23:00:00	ES	Futures	1060.12	1060.61	1058.91	1060.37	4232.0
2010-01-26 00:00:00	NQ	Futures	2041.68	2046.53	2041.11	2044.82	676.0
2010-01-26 01:00:00	NQ	Futures	2044.53	2045.96	2039.68	2040.82	755.0
2010-01-26 02:00:00	NQ	Futures	2040.82	2045.39	2040.82	2043.68	1261.0
2010-01-26 03:00:00	NQ	Futures	2043.96	2049.67	2043.68	2047.68	3419.0
2010-01-26 04:00:00	NQ	Futures	2047.96	2052.82	2046.25	2046.53	2433.0
2010-01-26 05:00:00	NQ	Futures	2046.82	2051.67	2044.82	2051.67	2082.0
2010-01-26 06:00:00	NQ	Futures	2051.67	2051.96	2049.39	2050.25	1544.0
2010-01-26 07:00:00	NQ	Futures	2050.53	2058.53	2049.67	2057.39	3284.0
2010-01-26 08:00:00	NQ	Futures	2057.67	2060.24	2054.82	2055.96	4739.0
2010-01-26 09:00:00	NQ	Futures	2056.53	2056.53	2044.82	2049.96	49220.0
2010-01-26 10:00:00	NQ	Futures	2049.96	2069.38	2046.82	2063.38	76401.0
2010-01-26 11:00:00	NQ	Futures	2063.1	2075.38	2061.96	2073.67	46266.0
2010-01-26 12:00:00	NQ	Futures	2073.38	2083.09	2072.24	2081.95	39764.0
2010-01-26 13:00:00	NQ	Futures	2082.24	2083.09	2076.81	2083.09	23553.0
2010-01-26 14:00:00	NQ	Futures	2083.09	2083.66	2068.53	2073.95	43976.0
2010-01-26 15:00:00	NQ	Futures	2073.95	2074.52	2054.53	2057.67	66954.0
2010-01-26 16:00:00	NQ	Futures	2057.96	2060.24	2051.96	2058.53	14449.0
2010-01-26 17:00:00	NQ	Futures	2058.81	2059.39	2056.24	2056.53	950.0
2010-01-26 18:00:00	NQ	Futures	2056.24	2059.96	2055.67	2057.1	1277.0
2010-01-26 19:00:00	NQ	Futures	2057.1	2059.1	2052.53	2057.39	1011.0
2010-01-26 20:00:00	NQ	Futures	2057.1	2059.1	2053.1	2058.24	908.0
2010-01-26 21:00:00	NQ	Futures	2058.81	2059.39	2054.82	2056.53	1370.0
2010-01-26 22:00:00	NQ	Futures	2056.24	2058.53	2055.1	2055.67	371.0
2010-01-26 23:00:00	NQ	Futures	2055.67	2057.1	2053.67	2057.1	411.0
2010-01-26 00:00:00	YM	Futures	9418.0	9439.5	9414.3	9434.9	715.0
2010-01-26 01:00:00	YM	Futures	9433.0	9437.7	9420.8	9420.8	483.0

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

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