PREVIEW / futures_1hour / 2010-03-31

all futures 1-hour files

  file:    by_date/futures_1hour/2010/2010-03-31.parquet
  size:    45 KB
  rows:    1,394

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-31 00:00:00	ES	Futures	1142.45	1142.69	1141.72	1141.96	1577.0
2010-03-31 01:00:00	ES	Futures	1142.2	1142.2	1140.0	1140.49	5387.0
2010-03-31 02:00:00	ES	Futures	1140.49	1140.98	1139.03	1139.52	8208.0
2010-03-31 03:00:00	ES	Futures	1139.76	1142.69	1139.52	1141.72	16016.0
2010-03-31 04:00:00	ES	Futures	1141.96	1142.94	1141.47	1142.45	10998.0
2010-03-31 05:00:00	ES	Futures	1142.45	1142.94	1141.47	1141.96	8749.0
2010-03-31 06:00:00	ES	Futures	1141.96	1142.69	1141.23	1142.2	6776.0
2010-03-31 07:00:00	ES	Futures	1141.96	1142.94	1141.23	1142.2	17844.0
2010-03-31 08:00:00	ES	Futures	1142.45	1143.67	1136.83	1138.29	124966.0
2010-03-31 09:00:00	ES	Futures	1138.29	1140.98	1135.36	1137.56	262881.0
2010-03-31 10:00:00	ES	Futures	1137.56	1142.69	1137.32	1140.98	314235.0
2010-03-31 11:00:00	ES	Futures	1140.98	1143.67	1139.27	1143.18	229221.0
2010-03-31 12:00:00	ES	Futures	1142.94	1144.4	1141.96	1142.69	159686.0
2010-03-31 13:00:00	ES	Futures	1142.69	1143.67	1141.72	1143.18	75503.0
2010-03-31 14:00:00	ES	Futures	1143.43	1144.4	1139.76	1140.49	164626.0
2010-03-31 15:00:00	ES	Futures	1140.49	1140.74	1136.83	1139.03	503284.0
2010-03-31 16:00:00	ES	Futures	1139.03	1141.96	1138.78	1140.98	175760.0
2010-03-31 17:00:00	ES	Futures	1140.74	1141.47	1140.49	1141.23	2146.0
2010-03-31 18:00:00	ES	Futures	1141.47	1142.2	1141.23	1141.96	4415.0
2010-03-31 19:00:00	ES	Futures	1141.96	1142.94	1141.47	1142.69	4827.0
2010-03-31 20:00:00	ES	Futures	1142.69	1142.94	1139.76	1140.49	9287.0
2010-03-31 21:00:00	ES	Futures	1140.49	1141.23	1139.76	1140.98	4202.0
2010-03-31 22:00:00	ES	Futures	1140.98	1141.23	1140.0	1140.49	2465.0
2010-03-31 23:00:00	ES	Futures	1140.74	1141.72	1140.25	1140.74	2918.0
2010-03-31 00:00:00	NQ	Futures	2248.88	2248.88	2247.45	2248.6	83.0
2010-03-31 01:00:00	NQ	Futures	2248.31	2248.31	2244.87	2245.45	190.0
2010-03-31 02:00:00	NQ	Futures	2245.16	2245.73	2243.73	2244.59	520.0
2010-03-31 03:00:00	NQ	Futures	2244.59	2249.46	2244.59	2248.02	700.0
2010-03-31 04:00:00	NQ	Futures	2248.02	2249.46	2247.74	2248.31	377.0
2010-03-31 05:00:00	NQ	Futures	2248.31	2249.46	2248.31	2248.88	384.0
2010-03-31 06:00:00	NQ	Futures	2249.17	2250.03	2248.31	2249.46	487.0
2010-03-31 07:00:00	NQ	Futures	2249.17	2250.03	2247.45	2249.17	894.0
2010-03-31 08:00:00	NQ	Futures	2249.17	2250.6	2238.86	2242.58	8871.0
2010-03-31 09:00:00	NQ	Futures	2242.3	2250.6	2238.0	2240.87	38492.0
2010-03-31 10:00:00	NQ	Futures	2240.87	2250.89	2240.58	2248.02	33112.0
2010-03-31 11:00:00	NQ	Futures	2248.02	2252.89	2244.87	2250.32	29984.0
2010-03-31 12:00:00	NQ	Futures	2250.32	2252.32	2248.02	2249.46	18807.0
2010-03-31 13:00:00	NQ	Futures	2249.17	2252.03	2247.74	2251.46	13142.0
2010-03-31 14:00:00	NQ	Futures	2251.75	2253.75	2242.58	2244.3	23775.0
2010-03-31 15:00:00	NQ	Futures	2244.3	2245.16	2236.57	2241.72	48128.0
2010-03-31 16:00:00	NQ	Futures	2241.72	2246.59	2237.72	2242.87	13596.0
2010-03-31 17:00:00	NQ	Futures	2242.87	2242.87	2241.72	2242.87	148.0
2010-03-31 18:00:00	NQ	Futures	2242.87	2243.73	2242.01	2243.73	338.0
2010-03-31 19:00:00	NQ	Futures	2243.73	2244.59	2243.16	2244.3	312.0
2010-03-31 20:00:00	NQ	Futures	2244.3	2244.3	2241.15	2241.44	339.0
2010-03-31 21:00:00	NQ	Futures	2241.44	2242.87	2240.01	2242.58	297.0
2010-03-31 22:00:00	NQ	Futures	2242.3	2242.58	2240.87	2241.72	211.0
2010-03-31 23:00:00	NQ	Futures	2241.44	2244.02	2241.44	2242.01	335.0
2010-03-31 00:00:00	YM	Futures	10206.8	10208.7	10198.3	10202.1	225.0
2010-03-31 01:00:00	YM	Futures	10203.0	10203.0	10186.1	10190.8	270.0

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

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