PREVIEW / futures_1hour / 2010-07-29

all futures 1-hour files

  file:    by_date/futures_1hour/2010/2010-07-29.parquet
  size:    46 KB
  rows:    1,378

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-07-29 00:00:00	ES	Futures	1084.82	1085.07	1083.84	1084.09	1136.0
2010-07-29 01:00:00	ES	Futures	1083.84	1085.56	1082.61	1085.07	4771.0
2010-07-29 02:00:00	ES	Futures	1085.07	1087.28	1085.07	1086.05	11278.0
2010-07-29 03:00:00	ES	Futures	1086.05	1088.01	1084.82	1085.31	21487.0
2010-07-29 04:00:00	ES	Futures	1085.07	1089.24	1085.07	1087.77	27897.0
2010-07-29 05:00:00	ES	Futures	1087.77	1088.5	1087.03	1087.28	9578.0
2010-07-29 06:00:00	ES	Futures	1087.52	1088.26	1086.79	1087.03	11179.0
2010-07-29 07:00:00	ES	Futures	1087.03	1089.24	1086.54	1087.03	24566.0
2010-07-29 08:00:00	ES	Futures	1086.79	1089.98	1085.56	1089.73	76759.0
2010-07-29 09:00:00	ES	Futures	1089.73	1092.43	1087.52	1088.5	208923.0
2010-07-29 10:00:00	ES	Futures	1088.5	1088.75	1083.11	1085.07	310728.0
2010-07-29 11:00:00	ES	Futures	1085.07	1085.31	1071.33	1072.31	409494.0
2010-07-29 12:00:00	ES	Futures	1072.31	1074.27	1068.63	1073.78	232855.0
2010-07-29 13:00:00	ES	Futures	1073.78	1078.93	1073.29	1076.97	174709.0
2010-07-29 14:00:00	ES	Futures	1076.97	1083.11	1074.52	1081.88	260485.0
2010-07-29 15:00:00	ES	Futures	1081.63	1084.09	1076.97	1077.46	318038.0
2010-07-29 16:00:00	ES	Futures	1077.46	1077.46	1075.25	1076.73	118389.0
2010-07-29 17:00:00	ES	Futures	1076.73	1076.73	1076.23	1076.23	1951.0
2010-07-29 18:00:00	ES	Futures	1076.48	1076.97	1075.99	1076.23	2523.0
2010-07-29 19:00:00	ES	Futures	1075.99	1076.73	1075.74	1075.74	3298.0
2010-07-29 20:00:00	ES	Futures	1075.74	1076.23	1072.06	1073.29	12757.0
2010-07-29 21:00:00	ES	Futures	1073.04	1073.29	1071.82	1072.8	3913.0
2010-07-29 22:00:00	ES	Futures	1072.8	1074.52	1072.31	1072.55	4509.0
2010-07-29 23:00:00	ES	Futures	1072.8	1072.8	1070.1	1071.82	6477.0
2010-07-29 00:00:00	NQ	Futures	2147.24	2147.24	2144.37	2144.95	118.0
2010-07-29 01:00:00	NQ	Futures	2144.95	2148.96	2142.94	2148.39	390.0
2010-07-29 02:00:00	NQ	Futures	2148.67	2151.82	2148.39	2149.82	732.0
2010-07-29 03:00:00	NQ	Futures	2149.82	2154.12	2145.81	2146.38	2768.0
2010-07-29 04:00:00	NQ	Futures	2146.38	2154.69	2146.09	2153.26	1596.0
2010-07-29 05:00:00	NQ	Futures	2152.68	2153.54	2150.1	2151.82	767.0
2010-07-29 06:00:00	NQ	Futures	2151.25	2152.97	2149.82	2150.68	933.0
2010-07-29 07:00:00	NQ	Futures	2150.39	2154.69	2149.82	2150.68	1894.0
2010-07-29 08:00:00	NQ	Futures	2150.68	2157.27	2148.39	2156.98	7386.0
2010-07-29 09:00:00	NQ	Futures	2156.98	2162.43	2148.96	2152.11	40075.0
2010-07-29 10:00:00	NQ	Futures	2152.11	2152.4	2138.36	2142.65	50378.0
2010-07-29 11:00:00	NQ	Futures	2142.65	2142.94	2114.0	2117.44	65842.0
2010-07-29 12:00:00	NQ	Futures	2117.72	2118.3	2107.41	2117.72	45696.0
2010-07-29 13:00:00	NQ	Futures	2118.01	2133.48	2116.29	2128.9	36316.0
2010-07-29 14:00:00	NQ	Futures	2129.19	2147.53	2124.31	2144.37	49007.0
2010-07-29 15:00:00	NQ	Futures	2144.09	2149.25	2128.9	2129.19	64576.0
2010-07-29 16:00:00	NQ	Futures	2129.19	2130.33	2126.61	2129.76	13440.0
2010-07-29 17:00:00	NQ	Futures	2129.76	2130.33	2127.47	2128.9	494.0
2010-07-29 18:00:00	NQ	Futures	2127.75	2128.61	2127.47	2127.75	169.0
2010-07-29 19:00:00	NQ	Futures	2127.18	2128.61	2126.32	2126.32	100.0
2010-07-29 20:00:00	NQ	Futures	2126.61	2126.61	2121.16	2122.88	882.0
2010-07-29 21:00:00	NQ	Futures	2122.88	2123.45	2120.59	2122.59	367.0
2010-07-29 22:00:00	NQ	Futures	2122.59	2125.17	2121.73	2122.02	274.0
2010-07-29 23:00:00	NQ	Futures	2121.73	2121.73	2117.15	2119.16	412.0
2010-07-29 00:00:00	YM	Futures	9912.9	9912.9	9902.5	9905.3	126.0
2010-07-29 01:00:00	YM	Futures	9907.2	9918.5	9894.9	9913.8	314.0

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

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