PREVIEW / futures_1hour / 2010-03-23

all futures 1-hour files

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

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-23 00:00:00	ES	Futures	1135.85	1136.83	1135.85	1136.58	1718.0
2010-03-23 01:00:00	ES	Futures	1136.34	1136.58	1135.85	1135.85	1159.0
2010-03-23 02:00:00	ES	Futures	1135.85	1136.09	1135.36	1135.36	2416.0
2010-03-23 03:00:00	ES	Futures	1135.6	1136.09	1134.87	1135.85	9160.0
2010-03-23 04:00:00	ES	Futures	1135.85	1138.54	1135.6	1137.56	22290.0
2010-03-23 05:00:00	ES	Futures	1137.56	1138.78	1137.32	1138.05	16127.0
2010-03-23 06:00:00	ES	Futures	1137.8	1138.29	1137.32	1137.56	7303.0
2010-03-23 07:00:00	ES	Futures	1137.8	1137.8	1134.87	1135.36	24727.0
2010-03-23 08:00:00	ES	Futures	1135.36	1137.07	1134.63	1136.83	30335.0
2010-03-23 09:00:00	ES	Futures	1137.07	1138.05	1133.65	1135.6	189737.0
2010-03-23 10:00:00	ES	Futures	1135.85	1139.03	1134.63	1135.36	338536.0
2010-03-23 11:00:00	ES	Futures	1135.12	1137.32	1133.16	1136.83	275837.0
2010-03-23 12:00:00	ES	Futures	1137.07	1138.78	1136.34	1137.32	156494.0
2010-03-23 13:00:00	ES	Futures	1137.32	1139.27	1136.34	1136.58	134839.0
2010-03-23 14:00:00	ES	Futures	1136.34	1139.52	1136.34	1139.03	139177.0
2010-03-23 15:00:00	ES	Futures	1139.27	1144.4	1138.54	1143.67	391862.0
2010-03-23 16:00:00	ES	Futures	1143.67	1143.91	1142.94	1143.67	87017.0
2010-03-23 17:00:00	ES	Futures	1143.67	1143.91	1143.43	1143.67	2845.0
2010-03-23 18:00:00	ES	Futures	1143.67	1143.91	1143.18	1143.67	1691.0
2010-03-23 19:00:00	ES	Futures	1143.43	1143.91	1142.94	1142.94	3367.0
2010-03-23 20:00:00	ES	Futures	1142.94	1143.67	1142.69	1142.94	2989.0
2010-03-23 21:00:00	ES	Futures	1142.94	1143.67	1142.45	1142.69	4261.0
2010-03-23 22:00:00	ES	Futures	1142.45	1142.94	1142.2	1142.69	2356.0
2010-03-23 23:00:00	ES	Futures	1142.69	1143.18	1142.2	1142.45	1951.0
2010-03-23 00:00:00	NQ	Futures	2229.98	2230.84	2229.98	2230.56	125.0
2010-03-23 01:00:00	NQ	Futures	2230.27	2230.56	2229.98	2229.98	57.0
2010-03-23 02:00:00	NQ	Futures	2229.7	2229.98	2229.12	2229.98	266.0
2010-03-23 03:00:00	NQ	Futures	2229.7	2230.56	2229.12	2229.98	245.0
2010-03-23 04:00:00	NQ	Futures	2229.98	2234.85	2229.7	2233.42	1714.0
2010-03-23 05:00:00	NQ	Futures	2233.42	2235.71	2232.27	2234.28	674.0
2010-03-23 06:00:00	NQ	Futures	2234.28	2235.14	2233.71	2234.28	455.0
2010-03-23 07:00:00	NQ	Futures	2234.28	2234.57	2229.98	2230.27	1969.0
2010-03-23 08:00:00	NQ	Futures	2230.56	2234.85	2229.41	2234.28	3045.0
2010-03-23 09:00:00	NQ	Futures	2234.28	2236.86	2227.41	2232.27	29461.0
2010-03-23 10:00:00	NQ	Futures	2232.56	2236.86	2226.26	2227.69	41480.0
2010-03-23 11:00:00	NQ	Futures	2227.41	2231.99	2222.82	2231.42	31556.0
2010-03-23 12:00:00	NQ	Futures	2231.42	2234.28	2230.27	2232.56	18992.0
2010-03-23 13:00:00	NQ	Futures	2232.27	2236.28	2230.84	2231.13	16865.0
2010-03-23 14:00:00	NQ	Futures	2231.13	2238.57	2231.13	2238.0	18367.0
2010-03-23 15:00:00	NQ	Futures	2238.0	2246.59	2237.14	2245.73	42771.0
2010-03-23 16:00:00	NQ	Futures	2245.73	2247.45	2245.16	2247.17	8744.0
2010-03-23 17:00:00	NQ	Futures	2247.17	2247.45	2245.73	2246.59	172.0
2010-03-23 18:00:00	NQ	Futures	2246.88	2247.17	2246.31	2246.88	137.0
2010-03-23 19:00:00	NQ	Futures	2246.59	2246.88	2245.73	2246.02	257.0
2010-03-23 20:00:00	NQ	Futures	2245.73	2247.17	2244.87	2245.73	294.0
2010-03-23 21:00:00	NQ	Futures	2245.73	2246.31	2244.87	2245.16	465.0
2010-03-23 22:00:00	NQ	Futures	2244.87	2245.45	2244.87	2245.45	123.0
2010-03-23 23:00:00	NQ	Futures	2245.16	2245.45	2244.87	2245.16	76.0
2010-03-23 00:00:00	YM	Futures	10092.0	10096.7	10091.1	10096.7	113.0
2010-03-23 01:00:00	YM	Futures	10095.8	10095.8	10091.1	10093.0	79.0

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

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