PREVIEW / futures_1hour / 2009-11-16

all futures 1-hour files

  file:    by_date/futures_1hour/2009/2009-11-16.parquet
  size:    42 KB
  rows:    1,260

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
2009-11-16 00:00:00	ES	Futures	1064.08	1065.29	1063.84	1064.81	3037.0
2009-11-16 01:00:00	ES	Futures	1064.81	1065.05	1063.84	1064.08	2497.0
2009-11-16 02:00:00	ES	Futures	1063.84	1067.47	1063.6	1066.26	13160.0
2009-11-16 03:00:00	ES	Futures	1066.26	1066.99	1063.84	1064.08	20806.0
2009-11-16 04:00:00	ES	Futures	1064.32	1066.74	1063.6	1066.26	14563.0
2009-11-16 05:00:00	ES	Futures	1066.02	1066.5	1065.29	1065.53	6948.0
2009-11-16 06:00:00	ES	Futures	1065.78	1066.26	1064.56	1065.53	8038.0
2009-11-16 07:00:00	ES	Futures	1065.53	1066.74	1064.81	1066.02	12122.0
2009-11-16 08:00:00	ES	Futures	1066.02	1068.2	1063.84	1064.56	53245.0
2009-11-16 09:00:00	ES	Futures	1064.56	1073.04	1064.08	1071.83	261670.0
2009-11-16 10:00:00	ES	Futures	1072.07	1074.98	1071.59	1074.74	286841.0
2009-11-16 11:00:00	ES	Futures	1074.5	1075.46	1072.8	1074.5	173013.0
2009-11-16 12:00:00	ES	Futures	1074.25	1074.98	1070.38	1074.98	248346.0
2009-11-16 13:00:00	ES	Futures	1074.98	1076.43	1073.53	1075.46	133823.0
2009-11-16 14:00:00	ES	Futures	1075.46	1077.64	1074.5	1075.46	190903.0
2009-11-16 15:00:00	ES	Futures	1075.22	1075.71	1069.17	1072.8	407957.0
2009-11-16 16:00:00	ES	Futures	1072.8	1073.53	1071.59	1071.83	104290.0
2009-11-16 17:00:00	ES	Futures	1072.07	1072.07	1071.35	1071.59	1405.0
2009-11-16 18:00:00	ES	Futures	1071.59	1072.32	1070.38	1071.83	5523.0
2009-11-16 19:00:00	ES	Futures	1072.07	1072.32	1070.62	1070.86	3614.0
2009-11-16 20:00:00	ES	Futures	1070.86	1071.35	1068.68	1069.41	7159.0
2009-11-16 21:00:00	ES	Futures	1069.41	1069.89	1068.68	1069.41	2730.0
2009-11-16 22:00:00	ES	Futures	1069.17	1069.89	1068.2	1068.44	3432.0
2009-11-16 23:00:00	ES	Futures	1068.44	1069.17	1068.2	1068.92	1696.0
2009-11-16 00:00:00	NQ	Futures	2050.55	2052.83	2050.55	2051.97	383.0
2009-11-16 01:00:00	NQ	Futures	2051.97	2052.54	2050.83	2050.83	258.0
2009-11-16 02:00:00	NQ	Futures	2050.83	2055.11	2049.69	2053.4	1896.0
2009-11-16 03:00:00	NQ	Futures	2053.4	2054.25	2047.69	2047.98	2905.0
2009-11-16 04:00:00	NQ	Futures	2047.98	2053.11	2047.41	2051.12	2021.0
2009-11-16 05:00:00	NQ	Futures	2051.12	2051.97	2049.41	2050.83	1022.0
2009-11-16 06:00:00	NQ	Futures	2050.55	2051.69	2048.55	2051.12	657.0
2009-11-16 07:00:00	NQ	Futures	2050.83	2051.97	2049.69	2051.4	1426.0
2009-11-16 08:00:00	NQ	Futures	2051.4	2053.68	2047.12	2048.55	5668.0
2009-11-16 09:00:00	NQ	Futures	2048.83	2064.24	2043.7	2061.1	55768.0
2009-11-16 10:00:00	NQ	Futures	2061.1	2065.95	2059.67	2063.95	41838.0
2009-11-16 11:00:00	NQ	Futures	2063.95	2067.37	2060.24	2066.23	29813.0
2009-11-16 12:00:00	NQ	Futures	2066.23	2067.09	2059.1	2065.38	29414.0
2009-11-16 13:00:00	NQ	Futures	2065.09	2067.37	2062.52	2065.66	17122.0
2009-11-16 14:00:00	NQ	Futures	2065.66	2069.08	2063.09	2064.81	30013.0
2009-11-16 15:00:00	NQ	Futures	2064.81	2065.38	2054.25	2059.39	52366.0
2009-11-16 16:00:00	NQ	Futures	2059.39	2061.67	2054.25	2056.82	15100.0
2009-11-16 17:00:00	NQ	Futures	2057.39	2057.39	2056.25	2056.25	65.0
2009-11-16 18:00:00	NQ	Futures	2056.54	2058.25	2055.11	2057.68	315.0
2009-11-16 19:00:00	NQ	Futures	2057.39	2057.68	2055.39	2055.39	300.0
2009-11-16 20:00:00	NQ	Futures	2055.68	2056.25	2051.4	2052.54	523.0
2009-11-16 21:00:00	NQ	Futures	2052.26	2053.11	2050.83	2052.54	190.0
2009-11-16 22:00:00	NQ	Futures	2052.54	2053.4	2050.26	2050.55	273.0
2009-11-16 23:00:00	NQ	Futures	2050.83	2052.26	2050.55	2051.97	126.0
2009-11-16 00:00:00	YM	Futures	9576.3	9583.7	9573.5	9580.9	369.0
2009-11-16 01:00:00	YM	Futures	9580.0	9580.9	9574.4	9576.3	178.0

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

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