PREVIEW / futures_1hour / 2010-01-04

all futures 1-hour files

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

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-04 00:00:00	ES	Futures	1084.69	1085.18	1084.2	1084.69	1806.0
2010-01-04 01:00:00	ES	Futures	1084.69	1084.93	1083.96	1084.45	1417.0
2010-01-04 02:00:00	ES	Futures	1084.69	1087.85	1084.45	1086.64	12814.0
2010-01-04 03:00:00	ES	Futures	1086.88	1089.56	1086.39	1088.58	26945.0
2010-01-04 04:00:00	ES	Futures	1088.34	1088.83	1087.37	1087.85	15533.0
2010-01-04 05:00:00	ES	Futures	1088.1	1088.34	1087.37	1088.34	11261.0
2010-01-04 06:00:00	ES	Futures	1088.34	1088.34	1087.37	1087.85	8859.0
2010-01-04 07:00:00	ES	Futures	1087.85	1088.1	1087.12	1087.37	15803.0
2010-01-04 08:00:00	ES	Futures	1087.37	1088.83	1086.64	1088.83	33541.0
2010-01-04 09:00:00	ES	Futures	1088.83	1094.91	1088.58	1094.18	232556.0
2010-01-04 10:00:00	ES	Futures	1094.18	1097.83	1092.96	1096.37	219689.0
2010-01-04 11:00:00	ES	Futures	1096.37	1099.29	1096.37	1098.07	121268.0
2010-01-04 12:00:00	ES	Futures	1098.31	1099.04	1097.83	1098.56	89713.0
2010-01-04 13:00:00	ES	Futures	1098.8	1099.29	1097.1	1097.34	95032.0
2010-01-04 14:00:00	ES	Futures	1097.34	1099.29	1097.1	1098.07	80623.0
2010-01-04 15:00:00	ES	Futures	1098.31	1099.04	1097.1	1098.31	207890.0
2010-01-04 16:00:00	ES	Futures	1098.56	1098.56	1097.83	1098.07	88172.0
2010-01-04 17:00:00	ES	Futures	1098.07	1098.31	1097.58	1097.83	2812.0
2010-01-04 18:00:00	ES	Futures	1097.83	1098.07	1096.85	1097.83	4186.0
2010-01-04 19:00:00	ES	Futures	1098.07	1098.07	1096.61	1097.1	3722.0
2010-01-04 20:00:00	ES	Futures	1097.34	1097.34	1096.85	1097.1	1539.0
2010-01-04 21:00:00	ES	Futures	1097.34	1097.83	1096.85	1097.58	1385.0
2010-01-04 22:00:00	ES	Futures	1097.58	1098.31	1097.1	1097.83	3692.0
2010-01-04 23:00:00	ES	Futures	1097.83	1098.31	1097.34	1097.34	3016.0
2010-01-04 00:00:00	NQ	Futures	2135.65	2136.51	2135.08	2135.36	214.0
2010-01-04 01:00:00	NQ	Futures	2135.36	2136.22	2133.65	2135.08	303.0
2010-01-04 02:00:00	NQ	Futures	2134.79	2141.36	2134.79	2139.93	2055.0
2010-01-04 03:00:00	NQ	Futures	2140.22	2146.5	2139.93	2145.36	4331.0
2010-01-04 04:00:00	NQ	Futures	2145.36	2147.93	2144.79	2147.36	2725.0
2010-01-04 05:00:00	NQ	Futures	2147.36	2147.93	2145.65	2147.65	1771.0
2010-01-04 06:00:00	NQ	Futures	2147.93	2147.93	2145.36	2147.65	1825.0
2010-01-04 07:00:00	NQ	Futures	2147.93	2149.93	2145.36	2145.93	1747.0
2010-01-04 08:00:00	NQ	Futures	2145.93	2151.07	2143.36	2150.79	6617.0
2010-01-04 09:00:00	NQ	Futures	2150.79	2156.5	2148.5	2152.5	48352.0
2010-01-04 10:00:00	NQ	Futures	2152.79	2158.21	2149.07	2155.07	35532.0
2010-01-04 11:00:00	NQ	Futures	2154.79	2157.93	2154.21	2155.93	20835.0
2010-01-04 12:00:00	NQ	Futures	2156.21	2157.64	2154.79	2155.93	12552.0
2010-01-04 13:00:00	NQ	Futures	2155.93	2155.93	2151.36	2151.93	10507.0
2010-01-04 14:00:00	NQ	Futures	2151.93	2155.93	2151.64	2153.64	11524.0
2010-01-04 15:00:00	NQ	Futures	2153.64	2156.21	2151.64	2154.79	28612.0
2010-01-04 16:00:00	NQ	Futures	2154.79	2156.5	2153.36	2155.93	12230.0
2010-01-04 17:00:00	NQ	Futures	2155.93	2156.79	2155.64	2155.64	90.0
2010-01-04 18:00:00	NQ	Futures	2155.93	2156.79	2155.07	2156.79	624.0
2010-01-04 19:00:00	NQ	Futures	2156.5	2156.79	2154.79	2155.93	319.0
2010-01-04 20:00:00	NQ	Futures	2155.64	2155.64	2154.79	2155.36	148.0
2010-01-04 21:00:00	NQ	Futures	2155.07	2156.5	2154.21	2156.21	223.0
2010-01-04 22:00:00	NQ	Futures	2156.21	2156.5	2154.21	2155.93	1132.0
2010-01-04 23:00:00	NQ	Futures	2155.93	2156.5	2153.93	2154.21	457.0
2010-01-04 00:00:00	YM	Futures	9732.4	9734.3	9727.8	9729.6	117.0
2010-01-04 01:00:00	YM	Futures	9729.6	9731.5	9725.9	9729.6	170.0

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

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