PREVIEW / futures_1hour / 2010-01-20

all futures 1-hour files

  file:    by_date/futures_1hour/2010/2010-01-20.parquet
  size:    48 KB
  rows:    1,426

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-20 00:00:00	ES	Futures	1113.15	1113.4	1111.45	1111.69	4419.0
2010-01-20 01:00:00	ES	Futures	1111.94	1112.18	1111.45	1111.45	6391.0
2010-01-20 02:00:00	ES	Futures	1111.69	1111.94	1110.48	1110.48	17212.0
2010-01-20 03:00:00	ES	Futures	1110.48	1111.69	1109.02	1111.21	36811.0
2010-01-20 04:00:00	ES	Futures	1111.45	1112.42	1110.23	1110.48	17134.0
2010-01-20 05:00:00	ES	Futures	1110.48	1111.94	1109.5	1110.96	14552.0
2010-01-20 06:00:00	ES	Futures	1111.21	1111.94	1108.53	1108.53	27980.0
2010-01-20 07:00:00	ES	Futures	1108.53	1110.23	1107.31	1110.23	56620.0
2010-01-20 08:00:00	ES	Futures	1110.23	1112.18	1106.83	1107.31	112635.0
2010-01-20 09:00:00	ES	Futures	1107.31	1107.8	1102.45	1104.39	364093.0
2010-01-20 10:00:00	ES	Futures	1104.64	1105.12	1097.58	1098.07	456940.0
2010-01-20 11:00:00	ES	Futures	1098.31	1098.56	1094.91	1097.1	331167.0
2010-01-20 12:00:00	ES	Futures	1097.34	1099.29	1096.12	1097.58	173621.0
2010-01-20 13:00:00	ES	Futures	1097.58	1100.5	1095.39	1099.53	170068.0
2010-01-20 14:00:00	ES	Futures	1099.29	1102.21	1098.8	1101.96	193947.0
2010-01-20 15:00:00	ES	Futures	1101.72	1104.88	1100.99	1103.91	282840.0
2010-01-20 16:00:00	ES	Futures	1103.67	1104.64	1103.18	1104.15	78881.0
2010-01-20 17:00:00	ES	Futures	1103.91	1104.64	1103.91	1104.64	1172.0
2010-01-20 18:00:00	ES	Futures	1104.15	1105.37	1103.91	1104.88	4448.0
2010-01-20 19:00:00	ES	Futures	1105.12	1106.1	1104.88	1105.12	5893.0
2010-01-20 20:00:00	ES	Futures	1105.12	1105.85	1104.64	1104.64	5125.0
2010-01-20 21:00:00	ES	Futures	1104.64	1107.56	1103.42	1104.88	13656.0
2010-01-20 22:00:00	ES	Futures	1104.88	1106.83	1104.39	1106.58	4095.0
2010-01-20 23:00:00	ES	Futures	1106.83	1107.56	1105.61	1107.07	4547.0
2010-01-20 00:00:00	NQ	Futures	2155.64	2156.21	2152.79	2153.07	480.0
2010-01-20 01:00:00	NQ	Futures	2153.07	2153.64	2151.93	2152.5	257.0
2010-01-20 02:00:00	NQ	Futures	2152.79	2153.07	2150.5	2150.79	825.0
2010-01-20 03:00:00	NQ	Futures	2150.79	2152.79	2148.5	2151.93	4069.0
2010-01-20 04:00:00	NQ	Futures	2151.64	2153.93	2149.64	2150.22	1326.0
2010-01-20 05:00:00	NQ	Futures	2149.93	2151.93	2148.22	2150.5	1415.0
2010-01-20 06:00:00	NQ	Futures	2150.22	2151.64	2146.22	2146.5	1770.0
2010-01-20 07:00:00	NQ	Futures	2146.5	2151.07	2144.22	2150.79	4428.0
2010-01-20 08:00:00	NQ	Futures	2151.07	2154.79	2146.5	2148.22	8128.0
2010-01-20 09:00:00	NQ	Futures	2148.5	2148.79	2136.51	2138.22	60960.0
2010-01-20 10:00:00	NQ	Futures	2137.93	2139.93	2115.37	2117.08	106327.0
2010-01-20 11:00:00	NQ	Futures	2117.37	2120.23	2108.51	2117.94	56623.0
2010-01-20 12:00:00	NQ	Futures	2117.94	2122.51	2114.8	2116.23	28824.0
2010-01-20 13:00:00	NQ	Futures	2116.23	2124.8	2112.8	2121.65	28849.0
2010-01-20 14:00:00	NQ	Futures	2121.65	2125.94	2119.37	2124.8	27333.0
2010-01-20 15:00:00	NQ	Futures	2124.8	2133.36	2123.08	2131.65	52430.0
2010-01-20 16:00:00	NQ	Futures	2131.65	2136.51	2130.79	2135.36	15195.0
2010-01-20 17:00:00	NQ	Futures	2135.36	2137.08	2135.08	2137.08	309.0
2010-01-20 18:00:00	NQ	Futures	2135.93	2137.36	2135.65	2136.79	478.0
2010-01-20 19:00:00	NQ	Futures	2136.79	2139.65	2136.79	2137.65	636.0
2010-01-20 20:00:00	NQ	Futures	2137.65	2139.36	2137.08	2137.36	505.0
2010-01-20 21:00:00	NQ	Futures	2137.08	2142.22	2135.08	2136.22	1090.0
2010-01-20 22:00:00	NQ	Futures	2136.22	2140.22	2135.93	2139.65	301.0
2010-01-20 23:00:00	NQ	Futures	2139.93	2141.36	2137.93	2140.5	288.0
2010-01-20 00:00:00	YM	Futures	9966.4	9968.3	9952.4	9957.0	432.0
2010-01-20 01:00:00	YM	Futures	9957.0	9959.8	9955.2	9956.1	188.0

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

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