PREVIEW / futures_1hour / 2010-09-09

all futures 1-hour files

  file:    by_date/futures_1hour/2010/2010-09-09.parquet
  size:    46 KB
  rows:    1,358

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-09-09 00:00:00	ES	Futures	1076.97	1078.2	1076.73	1076.97	2556.0
2010-09-09 01:00:00	ES	Futures	1077.22	1078.2	1076.73	1077.22	3737.0
2010-09-09 02:00:00	ES	Futures	1077.46	1079.18	1076.97	1077.95	7275.0
2010-09-09 03:00:00	ES	Futures	1077.71	1079.18	1076.48	1077.46	21029.0
2010-09-09 04:00:00	ES	Futures	1077.71	1082.37	1077.46	1081.63	20611.0
2010-09-09 05:00:00	ES	Futures	1081.63	1083.11	1080.65	1082.86	22437.0
2010-09-09 06:00:00	ES	Futures	1082.86	1083.35	1082.12	1083.11	12702.0
2010-09-09 07:00:00	ES	Futures	1082.86	1083.6	1081.63	1081.88	13360.0
2010-09-09 08:00:00	ES	Futures	1081.88	1088.01	1081.63	1086.79	118267.0
2010-09-09 09:00:00	ES	Futures	1086.79	1091.45	1086.05	1088.75	240249.0
2010-09-09 10:00:00	ES	Futures	1088.5	1088.99	1084.58	1084.58	141215.0
2010-09-09 11:00:00	ES	Futures	1084.82	1088.75	1084.58	1087.03	84945.0
2010-09-09 12:00:00	ES	Futures	1087.28	1088.01	1083.6	1083.6	62905.0
2010-09-09 13:00:00	ES	Futures	1083.6	1084.58	1080.16	1081.39	114488.0
2010-09-09 14:00:00	ES	Futures	1081.14	1084.33	1080.41	1083.84	69845.0
2010-09-09 15:00:00	ES	Futures	1083.84	1086.54	1082.86	1083.35	101376.0
2010-09-09 16:00:00	ES	Futures	1083.11	1084.33	1081.14	1081.39	51811.0
2010-09-09 17:00:00	ES	Futures	1081.39	1082.61	1080.16	1081.63	5088.0
2010-09-09 18:00:00	ES	Futures	1081.39	1082.12	1080.9	1082.12	1003.0
2010-09-09 19:00:00	ES	Futures	1082.12	1082.37	1081.39	1081.63	974.0
2010-09-09 20:00:00	ES	Futures	1081.39	1084.09	1080.9	1083.6	5668.0
2010-09-09 21:00:00	ES	Futures	1083.84	1085.07	1082.37	1083.84	5058.0
2010-09-09 22:00:00	ES	Futures	1083.84	1084.33	1081.88	1082.12	2181.0
2010-09-09 23:00:00	ES	Futures	1082.12	1082.37	1080.41	1080.65	2478.0
2010-09-09 00:00:00	NQ	Futures	2150.1	2151.82	2149.53	2150.39	152.0
2010-09-09 01:00:00	NQ	Futures	2150.39	2151.54	2149.53	2150.39	180.0
2010-09-09 02:00:00	NQ	Futures	2150.68	2153.54	2150.1	2151.82	489.0
2010-09-09 03:00:00	NQ	Futures	2151.82	2154.12	2148.96	2150.96	2981.0
2010-09-09 04:00:00	NQ	Futures	2151.25	2159.56	2150.96	2158.7	1643.0
2010-09-09 05:00:00	NQ	Futures	2158.99	2160.99	2156.12	2160.42	2263.0
2010-09-09 06:00:00	NQ	Futures	2160.13	2161.57	2159.28	2161.28	938.0
2010-09-09 07:00:00	NQ	Futures	2160.99	2162.43	2158.42	2158.99	1052.0
2010-09-09 08:00:00	NQ	Futures	2158.99	2169.88	2157.27	2167.87	10894.0
2010-09-09 09:00:00	NQ	Futures	2168.16	2175.32	2166.44	2169.88	38042.0
2010-09-09 10:00:00	NQ	Futures	2169.88	2173.03	2163.29	2163.29	26120.0
2010-09-09 11:00:00	NQ	Futures	2163.57	2174.18	2163.57	2171.88	15161.0
2010-09-09 12:00:00	NQ	Futures	2172.17	2174.75	2167.87	2167.87	13960.0
2010-09-09 13:00:00	NQ	Futures	2167.87	2169.88	2159.85	2161.28	24826.0
2010-09-09 14:00:00	NQ	Futures	2161.28	2167.01	2158.13	2166.44	13593.0
2010-09-09 15:00:00	NQ	Futures	2166.44	2170.16	2161.28	2163.57	21202.0
2010-09-09 16:00:00	NQ	Futures	2163.29	2167.59	2161.28	2161.57	6885.0
2010-09-09 17:00:00	NQ	Futures	2161.28	2162.71	2158.7	2162.14	86.0
2010-09-09 18:00:00	NQ	Futures	2162.14	2162.43	2160.42	2162.14	44.0
2010-09-09 19:00:00	NQ	Futures	2161.85	2163.29	2160.99	2162.71	46.0
2010-09-09 20:00:00	NQ	Futures	2161.85	2167.01	2160.71	2165.87	281.0
2010-09-09 21:00:00	NQ	Futures	2166.15	2168.45	2163.29	2165.29	260.0
2010-09-09 22:00:00	NQ	Futures	2166.15	2166.73	2161.85	2162.14	144.0
2010-09-09 23:00:00	NQ	Futures	2162.43	2162.43	2159.28	2159.28	393.0
2010-09-09 00:00:00	YM	Futures	9821.0	9831.5	9820.1	9822.9	104.0
2010-09-09 01:00:00	YM	Futures	9821.0	9832.4	9820.1	9822.9	180.0

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

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