PREVIEW / futures_1hour / 2010-01-07

all futures 1-hour files

  file:    by_date/futures_1hour/2010/2010-01-07.parquet
  size:    45 KB
  rows:    1,379

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-07 00:00:00	ES	Futures	1100.99	1101.23	1100.02	1100.26	3619.0
2010-01-07 01:00:00	ES	Futures	1100.5	1100.5	1099.04	1099.77	5667.0
2010-01-07 02:00:00	ES	Futures	1100.02	1100.75	1099.04	1100.5	8346.0
2010-01-07 03:00:00	ES	Futures	1100.5	1100.75	1097.58	1097.83	22167.0
2010-01-07 04:00:00	ES	Futures	1098.07	1100.02	1096.61	1097.1	19863.0
2010-01-07 05:00:00	ES	Futures	1097.34	1098.56	1096.85	1097.83	11119.0
2010-01-07 06:00:00	ES	Futures	1097.83	1099.53	1097.34	1098.31	10472.0
2010-01-07 07:00:00	ES	Futures	1098.56	1099.53	1097.83	1098.07	18244.0
2010-01-07 08:00:00	ES	Futures	1098.31	1100.5	1098.07	1099.77	39994.0
2010-01-07 09:00:00	ES	Futures	1099.77	1101.96	1097.1	1097.83	195883.0
2010-01-07 10:00:00	ES	Futures	1097.58	1104.39	1097.34	1103.18	264434.0
2010-01-07 11:00:00	ES	Futures	1102.94	1103.91	1101.96	1102.94	126929.0
2010-01-07 12:00:00	ES	Futures	1102.69	1105.37	1102.45	1103.67	150770.0
2010-01-07 13:00:00	ES	Futures	1103.67	1105.12	1102.69	1104.15	107561.0
2010-01-07 14:00:00	ES	Futures	1104.15	1107.8	1103.91	1107.07	181095.0
2010-01-07 15:00:00	ES	Futures	1106.83	1108.04	1103.91	1107.07	295544.0
2010-01-07 16:00:00	ES	Futures	1106.83	1107.31	1106.1	1106.83	83924.0
2010-01-07 17:00:00	ES	Futures	1106.83	1106.83	1106.34	1106.34	1122.0
2010-01-07 18:00:00	ES	Futures	1106.58	1106.83	1106.1	1106.83	3344.0
2010-01-07 19:00:00	ES	Futures	1106.58	1107.31	1106.58	1107.07	2996.0
2010-01-07 20:00:00	ES	Futures	1107.31	1107.56	1106.34	1106.58	2697.0
2010-01-07 21:00:00	ES	Futures	1106.58	1107.07	1106.34	1106.83	2044.0
2010-01-07 22:00:00	ES	Futures	1106.83	1108.04	1106.83	1107.31	2861.0
2010-01-07 23:00:00	ES	Futures	1107.56	1107.56	1106.1	1107.07	2125.0
2010-01-07 00:00:00	NQ	Futures	2144.22	2144.22	2142.79	2143.08	170.0
2010-01-07 01:00:00	NQ	Futures	2142.79	2143.08	2140.5	2141.93	298.0
2010-01-07 02:00:00	NQ	Futures	2141.93	2142.79	2140.5	2142.79	578.0
2010-01-07 03:00:00	NQ	Futures	2142.79	2143.36	2137.65	2138.79	3244.0
2010-01-07 04:00:00	NQ	Futures	2138.51	2143.08	2137.08	2138.51	1968.0
2010-01-07 05:00:00	NQ	Futures	2138.22	2139.65	2136.79	2137.65	1905.0
2010-01-07 06:00:00	NQ	Futures	2137.65	2142.79	2137.65	2139.93	1391.0
2010-01-07 07:00:00	NQ	Futures	2139.93	2141.08	2138.51	2138.79	2665.0
2010-01-07 08:00:00	NQ	Futures	2138.79	2145.07	2138.79	2143.65	3775.0
2010-01-07 09:00:00	NQ	Futures	2143.65	2147.93	2133.94	2135.08	41583.0
2010-01-07 10:00:00	NQ	Futures	2135.08	2147.36	2131.65	2143.08	50741.0
2010-01-07 11:00:00	NQ	Futures	2142.79	2144.5	2135.36	2136.79	22821.0
2010-01-07 12:00:00	NQ	Futures	2136.79	2141.93	2135.36	2136.22	18668.0
2010-01-07 13:00:00	NQ	Futures	2136.51	2139.36	2133.65	2135.93	17470.0
2010-01-07 14:00:00	NQ	Futures	2136.22	2142.79	2135.93	2141.36	24112.0
2010-01-07 15:00:00	NQ	Futures	2141.08	2143.93	2135.93	2143.93	36257.0
2010-01-07 16:00:00	NQ	Futures	2143.93	2145.65	2143.36	2145.07	11824.0
2010-01-07 17:00:00	NQ	Futures	2145.36	2145.36	2144.22	2144.79	179.0
2010-01-07 18:00:00	NQ	Futures	2144.5	2145.36	2144.22	2144.5	261.0
2010-01-07 19:00:00	NQ	Futures	2144.5	2145.93	2144.5	2145.65	358.0
2010-01-07 20:00:00	NQ	Futures	2145.93	2146.22	2144.5	2144.5	203.0
2010-01-07 21:00:00	NQ	Futures	2144.79	2145.93	2143.36	2145.36	489.0
2010-01-07 22:00:00	NQ	Futures	2145.36	2147.36	2145.36	2145.93	412.0
2010-01-07 23:00:00	NQ	Futures	2145.93	2146.79	2143.65	2146.22	508.0
2010-01-07 00:00:00	YM	Futures	9830.7	9831.6	9824.2	9825.1	167.0
2010-01-07 01:00:00	YM	Futures	9826.0	9826.0	9813.9	9822.3	368.0

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

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