PREVIEW / futures_1hour / 2010-03-29

all futures 1-hour files

  file:    by_date/futures_1hour/2010/2010-03-29.parquet
  size:    43 KB
  rows:    1,332

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-29 00:00:00	ES	Futures	1140.98	1141.47	1140.25	1140.74	3180.0
2010-03-29 01:00:00	ES	Futures	1140.49	1141.47	1140.49	1140.49	2580.0
2010-03-29 02:00:00	ES	Futures	1140.74	1143.91	1140.49	1142.69	11845.0
2010-03-29 03:00:00	ES	Futures	1142.69	1143.67	1141.72	1143.43	17282.0
2010-03-29 04:00:00	ES	Futures	1143.43	1144.89	1143.43	1143.67	19815.0
2010-03-29 05:00:00	ES	Futures	1143.43	1144.16	1142.69	1143.43	8430.0
2010-03-29 06:00:00	ES	Futures	1143.43	1144.4	1142.94	1143.18	10720.0
2010-03-29 07:00:00	ES	Futures	1143.43	1143.67	1141.72	1142.2	12190.0
2010-03-29 08:00:00	ES	Futures	1141.96	1142.94	1140.74	1141.23	37880.0
2010-03-29 09:00:00	ES	Futures	1140.98	1143.67	1140.0	1140.74	238342.0
2010-03-29 10:00:00	ES	Futures	1140.49	1142.69	1139.27	1142.45	251127.0
2010-03-29 11:00:00	ES	Futures	1142.45	1144.89	1142.2	1142.94	154376.0
2010-03-29 12:00:00	ES	Futures	1142.94	1143.43	1140.74	1141.23	122100.0
2010-03-29 13:00:00	ES	Futures	1141.23	1143.18	1140.49	1141.72	124409.0
2010-03-29 14:00:00	ES	Futures	1141.96	1142.94	1140.25	1142.94	139907.0
2010-03-29 15:00:00	ES	Futures	1142.94	1143.91	1142.2	1142.94	193130.0
2010-03-29 16:00:00	ES	Futures	1142.69	1143.18	1142.2	1142.69	89042.0
2010-03-29 17:00:00	ES	Futures	1142.69	1142.94	1142.69	1142.94	836.0
2010-03-29 18:00:00	ES	Futures	1142.94	1143.91	1142.94	1143.67	3477.0
2010-03-29 19:00:00	ES	Futures	1143.43	1143.67	1142.69	1143.18	1977.0
2010-03-29 20:00:00	ES	Futures	1142.94	1143.43	1141.72	1142.2	4900.0
2010-03-29 21:00:00	ES	Futures	1141.96	1142.69	1141.72	1142.2	2732.0
2010-03-29 22:00:00	ES	Futures	1142.2	1142.69	1141.96	1142.2	1259.0
2010-03-29 23:00:00	ES	Futures	1141.96	1142.45	1141.47	1141.96	2643.0
2010-03-29 00:00:00	NQ	Futures	2240.87	2241.72	2239.72	2240.01	95.0
2010-03-29 01:00:00	NQ	Futures	2239.72	2241.72	2239.72	2240.87	72.0
2010-03-29 02:00:00	NQ	Futures	2240.87	2245.45	2240.87	2243.73	604.0
2010-03-29 03:00:00	NQ	Futures	2243.73	2245.45	2242.3	2245.45	1608.0
2010-03-29 04:00:00	NQ	Futures	2245.16	2249.46	2244.87	2247.45	2783.0
2010-03-29 05:00:00	NQ	Futures	2247.74	2248.88	2246.02	2246.59	579.0
2010-03-29 06:00:00	NQ	Futures	2246.88	2248.02	2245.73	2246.31	331.0
2010-03-29 07:00:00	NQ	Futures	2246.31	2247.17	2243.73	2244.3	660.0
2010-03-29 08:00:00	NQ	Futures	2244.59	2245.73	2242.58	2243.73	2303.0
2010-03-29 09:00:00	NQ	Futures	2243.44	2251.75	2240.87	2245.73	41384.0
2010-03-29 10:00:00	NQ	Futures	2245.73	2250.32	2244.02	2247.17	44136.0
2010-03-29 11:00:00	NQ	Futures	2246.88	2252.32	2246.02	2250.6	29266.0
2010-03-29 12:00:00	NQ	Futures	2250.32	2250.89	2242.87	2243.44	18096.0
2010-03-29 13:00:00	NQ	Futures	2243.44	2246.31	2239.43	2242.01	19724.0
2010-03-29 14:00:00	NQ	Futures	2241.72	2243.73	2238.29	2242.87	19220.0
2010-03-29 15:00:00	NQ	Futures	2242.58	2244.87	2240.29	2244.02	30122.0
2010-03-29 16:00:00	NQ	Futures	2244.02	2245.45	2242.3	2244.87	7654.0
2010-03-29 17:00:00	NQ	Futures	2244.87	2246.02	2244.87	2245.73	218.0
2010-03-29 18:00:00	NQ	Futures	2248.88	2251.17	2248.31	2248.88	1205.0
2010-03-29 19:00:00	NQ	Futures	2248.88	2249.46	2248.31	2249.46	455.0
2010-03-29 20:00:00	NQ	Futures	2249.46	2249.74	2246.88	2247.17	467.0
2010-03-29 21:00:00	NQ	Futures	2247.17	2248.02	2246.59	2246.88	367.0
2010-03-29 22:00:00	NQ	Futures	2246.88	2247.45	2245.45	2246.59	449.0
2010-03-29 23:00:00	NQ	Futures	2246.59	2247.17	2246.02	2246.59	75.0
2010-03-29 00:00:00	YM	Futures	10185.2	10188.9	10180.5	10180.5	99.0
2010-03-29 01:00:00	YM	Futures	10180.5	10188.0	10180.5	10184.2	123.0

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

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