PREVIEW / futures_1hour / 2010-03-10

all futures 1-hour files

  file:    by_date/futures_1hour/2010/2010-03-10.parquet
  size:    42 KB
  rows:    1,304

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-03-10 00:00:00	ES	Futures	1109.02	1109.99	1108.77	1109.5	1465.0
2010-03-10 01:00:00	ES	Futures	1109.5	1109.75	1109.02	1109.5	1799.0
2010-03-10 02:00:00	ES	Futures	1109.75	1109.99	1107.56	1108.04	6982.0
2010-03-10 03:00:00	ES	Futures	1108.04	1109.75	1107.07	1108.77	15971.0
2010-03-10 04:00:00	ES	Futures	1109.02	1111.21	1108.53	1109.26	17674.0
2010-03-10 05:00:00	ES	Futures	1109.26	1110.23	1108.53	1109.99	9399.0
2010-03-10 06:00:00	ES	Futures	1109.75	1111.45	1108.77	1110.48	13663.0
2010-03-10 07:00:00	ES	Futures	1110.48	1111.45	1109.02	1109.75	18342.0
2010-03-10 08:00:00	ES	Futures	1109.5	1110.72	1109.02	1109.99	24534.0
2010-03-10 09:00:00	ES	Futures	1109.75	1112.91	1108.53	1111.94	158929.0
2010-03-10 10:00:00	ES	Futures	1112.18	1116.56	1111.94	1115.34	275711.0
2010-03-10 11:00:00	ES	Futures	1115.58	1117.04	1113.4	1114.61	230174.0
2010-03-10 12:00:00	ES	Futures	1114.61	1114.86	1108.53	1112.91	297387.0
2010-03-10 13:00:00	ES	Futures	1112.67	1114.37	1111.45	1112.18	142084.0
2010-03-10 14:00:00	ES	Futures	1112.18	1116.56	1111.45	1114.13	175806.0
2010-03-10 15:00:00	ES	Futures	1114.13	1116.07	1110.72	1113.88	324578.0
2010-03-10 16:00:00	ES	Futures	1114.13	1115.58	1113.64	1114.61	102379.0
2010-03-10 17:00:00	ES	Futures	1114.61	1114.61	1114.13	1114.37	1568.0
2010-03-10 18:00:00	ES	Futures	1114.13	1114.61	1113.15	1113.64	3957.0
2010-03-10 19:00:00	ES	Futures	1113.4	1114.86	1112.91	1113.4	4188.0
2010-03-10 20:00:00	ES	Futures	1113.15	1114.86	1113.15	1114.37	1619.0
2010-03-10 21:00:00	ES	Futures	1114.13	1114.13	1109.75	1109.75	13318.0
2010-03-10 22:00:00	ES	Futures	1109.75	1110.72	1109.26	1109.26	6296.0
2010-03-10 23:00:00	ES	Futures	1109.26	1110.23	1108.77	1109.99	5361.0
2010-03-10 00:00:00	NQ	Futures	2173.07	2173.92	2173.07	2173.07	37.0
2010-03-10 01:00:00	NQ	Futures	2173.35	2174.21	2173.35	2173.92	78.0
2010-03-10 02:00:00	NQ	Futures	2173.92	2174.21	2172.5	2172.5	681.0
2010-03-10 03:00:00	NQ	Futures	2172.5	2175.64	2170.78	2174.49	1324.0
2010-03-10 04:00:00	NQ	Futures	2174.49	2177.92	2174.49	2174.78	1059.0
2010-03-10 05:00:00	NQ	Futures	2174.49	2176.21	2173.64	2175.35	726.0
2010-03-10 06:00:00	NQ	Futures	2175.35	2177.07	2173.92	2176.21	804.0
2010-03-10 07:00:00	NQ	Futures	2176.21	2177.35	2173.64	2175.07	1040.0
2010-03-10 08:00:00	NQ	Futures	2175.07	2176.49	2173.07	2174.78	4500.0
2010-03-10 09:00:00	NQ	Futures	2174.78	2181.06	2171.92	2180.49	35442.0
2010-03-10 10:00:00	NQ	Futures	2180.49	2190.49	2180.21	2188.78	50102.0
2010-03-10 11:00:00	NQ	Futures	2188.78	2192.77	2185.92	2190.49	40692.0
2010-03-10 12:00:00	NQ	Futures	2190.2	2191.06	2182.21	2188.78	44057.0
2010-03-10 13:00:00	NQ	Futures	2188.78	2192.2	2186.78	2187.35	27789.0
2010-03-10 14:00:00	NQ	Futures	2187.63	2195.06	2186.21	2191.35	29209.0
2010-03-10 15:00:00	NQ	Futures	2191.35	2194.77	2186.21	2189.06	52151.0
2010-03-10 16:00:00	NQ	Futures	2189.35	2192.2	2189.06	2190.78	20280.0
2010-03-10 17:00:00	NQ	Futures	2190.2	2190.49	2188.78	2190.49	218.0
2010-03-10 18:00:00	NQ	Futures	2190.2	2190.49	2188.2	2188.49	427.0
2010-03-10 19:00:00	NQ	Futures	2188.49	2190.2	2186.49	2187.92	385.0
2010-03-10 20:00:00	NQ	Futures	2187.63	2189.92	2187.63	2189.63	133.0
2010-03-10 21:00:00	NQ	Futures	2189.06	2189.06	2185.06	2185.06	1347.0
2010-03-10 22:00:00	NQ	Futures	2185.35	2186.49	2184.49	2184.49	303.0
2010-03-10 23:00:00	NQ	Futures	2184.21	2186.21	2183.92	2185.06	221.0
2010-03-10 00:00:00	YM	Futures	9882.2	9882.2	9880.3	9880.3	4.0
2010-03-10 01:00:00	YM	Futures	9877.5	9879.3	9877.5	9879.3	5.0

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

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