PREVIEW / futures_1hour / 2010-03-09

all futures 1-hour files

  file:    by_date/futures_1hour/2010/2010-03-09.parquet
  size:    44 KB
  rows:    1,366

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-09 00:00:00	ES	Futures	1104.88	1105.12	1104.39	1104.64	862.0
2010-03-09 01:00:00	ES	Futures	1104.64	1105.12	1104.15	1104.39	1345.0
2010-03-09 02:00:00	ES	Futures	1104.64	1105.61	1103.91	1105.12	5686.0
2010-03-09 03:00:00	ES	Futures	1104.88	1106.58	1103.18	1103.42	19771.0
2010-03-09 04:00:00	ES	Futures	1103.42	1103.91	1102.21	1102.69	26475.0
2010-03-09 05:00:00	ES	Futures	1102.69	1103.67	1101.72	1102.21	14018.0
2010-03-09 06:00:00	ES	Futures	1101.96	1102.69	1100.99	1101.72	14993.0
2010-03-09 07:00:00	ES	Futures	1101.48	1103.91	1101.23	1103.18	22121.0
2010-03-09 08:00:00	ES	Futures	1102.94	1103.91	1101.72	1102.94	33885.0
2010-03-09 09:00:00	ES	Futures	1103.18	1106.83	1102.21	1106.34	166326.0
2010-03-09 10:00:00	ES	Futures	1106.58	1110.48	1105.37	1109.75	263917.0
2010-03-09 11:00:00	ES	Futures	1109.99	1111.45	1107.56	1111.21	191122.0
2010-03-09 12:00:00	ES	Futures	1111.21	1113.64	1110.23	1113.64	127724.0
2010-03-09 13:00:00	ES	Futures	1113.4	1114.37	1111.94	1112.67	120806.0
2010-03-09 14:00:00	ES	Futures	1112.67	1113.88	1109.5	1110.23	165940.0
2010-03-09 15:00:00	ES	Futures	1110.48	1110.96	1105.61	1109.02	404139.0
2010-03-09 16:00:00	ES	Futures	1109.02	1109.99	1108.53	1109.75	80622.0
2010-03-09 17:00:00	ES	Futures	1109.5	1109.5	1108.53	1109.02	3304.0
2010-03-09 18:00:00	ES	Futures	1109.26	1109.99	1108.77	1108.77	2448.0
2010-03-09 19:00:00	ES	Futures	1108.77	1109.02	1108.04	1108.53	2945.0
2010-03-09 20:00:00	ES	Futures	1108.77	1109.75	1108.29	1109.26	2350.0
2010-03-09 21:00:00	ES	Futures	1109.5	1109.75	1108.53	1108.77	2095.0
2010-03-09 22:00:00	ES	Futures	1108.77	1109.75	1108.53	1109.5	1247.0
2010-03-09 23:00:00	ES	Futures	1109.5	1109.5	1108.53	1109.02	1326.0
2010-03-09 00:00:00	NQ	Futures	2155.93	2156.21	2155.07	2155.36	85.0
2010-03-09 01:00:00	NQ	Futures	2155.07	2155.93	2154.79	2155.07	87.0
2010-03-09 02:00:00	NQ	Futures	2155.36	2157.93	2154.79	2157.07	459.0
2010-03-09 03:00:00	NQ	Futures	2157.07	2159.36	2153.36	2153.36	1377.0
2010-03-09 04:00:00	NQ	Futures	2153.36	2154.21	2151.64	2152.79	1237.0
2010-03-09 05:00:00	NQ	Futures	2152.79	2153.93	2150.79	2151.07	1070.0
2010-03-09 06:00:00	NQ	Futures	2150.79	2151.64	2149.07	2150.5	1351.0
2010-03-09 07:00:00	NQ	Futures	2150.5	2153.36	2149.93	2152.5	844.0
2010-03-09 08:00:00	NQ	Futures	2152.22	2153.64	2150.79	2152.79	2336.0
2010-03-09 09:00:00	NQ	Futures	2152.5	2164.78	2151.93	2163.64	40571.0
2010-03-09 10:00:00	NQ	Futures	2163.64	2177.92	2161.64	2176.49	69891.0
2010-03-09 11:00:00	NQ	Futures	2176.21	2177.92	2169.35	2176.49	40466.0
2010-03-09 12:00:00	NQ	Futures	2176.21	2183.06	2175.07	2183.06	24060.0
2010-03-09 13:00:00	NQ	Futures	2183.06	2184.49	2178.49	2180.78	29912.0
2010-03-09 14:00:00	NQ	Futures	2180.78	2183.35	2173.35	2173.92	30731.0
2010-03-09 15:00:00	NQ	Futures	2173.64	2175.64	2163.36	2172.5	69410.0
2010-03-09 16:00:00	NQ	Futures	2172.21	2173.64	2171.35	2173.07	11662.0
2010-03-09 17:00:00	NQ	Futures	2172.78	2172.78	2171.64	2171.92	85.0
2010-03-09 18:00:00	NQ	Futures	2172.21	2173.64	2171.92	2172.5	244.0
2010-03-09 19:00:00	NQ	Futures	2172.5	2173.35	2172.5	2173.35	494.0
2010-03-09 20:00:00	NQ	Futures	2173.07	2173.64	2172.5	2173.35	319.0
2010-03-09 21:00:00	NQ	Futures	2173.35	2173.64	2172.5	2172.78	238.0
2010-03-09 22:00:00	NQ	Futures	2172.78	2174.49	2172.5	2174.21	231.0
2010-03-09 23:00:00	NQ	Futures	2174.21	2174.49	2172.78	2173.35	197.0
2010-03-09 00:00:00	YM	Futures	9852.2	9854.1	9849.4	9851.3	61.0
2010-03-09 01:00:00	YM	Futures	9850.4	9852.2	9845.7	9846.6	150.0

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

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