PREVIEW / futures_1hour / 2009-11-17

all futures 1-hour files

  file:    by_date/futures_1hour/2009/2009-11-17.parquet
  size:    43 KB
  rows:    1,312

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-17 00:00:00	ES	Futures	1068.68	1069.41	1066.74	1066.99	6890.0
2009-11-17 01:00:00	ES	Futures	1067.23	1069.41	1066.99	1069.17	3737.0
2009-11-17 02:00:00	ES	Futures	1069.17	1071.35	1069.17	1069.17	10220.0
2009-11-17 03:00:00	ES	Futures	1069.17	1070.62	1067.96	1068.68	22926.0
2009-11-17 04:00:00	ES	Futures	1068.68	1072.07	1067.96	1071.59	15728.0
2009-11-17 05:00:00	ES	Futures	1071.83	1072.07	1069.41	1069.89	12897.0
2009-11-17 06:00:00	ES	Futures	1070.14	1072.07	1069.65	1071.35	13195.0
2009-11-17 07:00:00	ES	Futures	1071.59	1071.83	1067.23	1069.41	28499.0
2009-11-17 08:00:00	ES	Futures	1069.41	1071.35	1067.71	1070.38	40049.0
2009-11-17 09:00:00	ES	Futures	1070.38	1073.04	1068.2	1070.86	206940.0
2009-11-17 10:00:00	ES	Futures	1070.86	1072.32	1066.02	1068.68	296575.0
2009-11-17 11:00:00	ES	Futures	1068.68	1069.65	1065.78	1068.68	179755.0
2009-11-17 12:00:00	ES	Futures	1068.92	1072.56	1067.96	1070.62	108570.0
2009-11-17 13:00:00	ES	Futures	1070.62	1073.77	1069.17	1072.32	131519.0
2009-11-17 14:00:00	ES	Futures	1072.32	1072.56	1069.65	1071.35	115451.0
2009-11-17 15:00:00	ES	Futures	1071.1	1074.5	1070.86	1074.25	214326.0
2009-11-17 16:00:00	ES	Futures	1074.25	1074.25	1072.56	1073.04	78426.0
2009-11-17 17:00:00	ES	Futures	1073.04	1073.28	1072.8	1072.8	1621.0
2009-11-17 18:00:00	ES	Futures	1073.04	1074.25	1072.56	1074.01	4145.0
2009-11-17 19:00:00	ES	Futures	1074.01	1076.19	1074.01	1075.71	6478.0
2009-11-17 20:00:00	ES	Futures	1075.71	1075.95	1073.04	1073.28	7032.0
2009-11-17 21:00:00	ES	Futures	1073.28	1074.5	1072.56	1073.53	3400.0
2009-11-17 22:00:00	ES	Futures	1073.53	1074.25	1071.1	1071.83	4729.0
2009-11-17 23:00:00	ES	Futures	1071.83	1072.32	1070.86	1071.83	4451.0
2009-11-17 00:00:00	NQ	Futures	2052.26	2053.11	2047.98	2048.83	366.0
2009-11-17 01:00:00	NQ	Futures	2048.55	2052.54	2047.98	2052.26	301.0
2009-11-17 02:00:00	NQ	Futures	2051.97	2055.96	2051.97	2052.83	1025.0
2009-11-17 03:00:00	NQ	Futures	2052.83	2055.68	2050.83	2052.83	2754.0
2009-11-17 04:00:00	NQ	Futures	2052.83	2059.39	2051.12	2057.39	1732.0
2009-11-17 05:00:00	NQ	Futures	2057.96	2058.25	2053.11	2053.97	1101.0
2009-11-17 06:00:00	NQ	Futures	2053.97	2058.25	2053.4	2056.82	958.0
2009-11-17 07:00:00	NQ	Futures	2056.82	2057.39	2049.41	2053.11	2392.0
2009-11-17 08:00:00	NQ	Futures	2053.11	2054.25	2049.12	2053.4	4913.0
2009-11-17 09:00:00	NQ	Futures	2053.68	2063.95	2051.69	2059.67	40976.0
2009-11-17 10:00:00	NQ	Futures	2059.39	2061.67	2050.26	2053.68	35214.0
2009-11-17 11:00:00	NQ	Futures	2053.68	2056.82	2049.98	2056.25	21667.0
2009-11-17 12:00:00	NQ	Futures	2056.25	2062.52	2054.82	2058.25	17585.0
2009-11-17 13:00:00	NQ	Futures	2058.25	2063.95	2056.25	2061.95	17424.0
2009-11-17 14:00:00	NQ	Futures	2062.24	2062.24	2057.39	2061.38	18607.0
2009-11-17 15:00:00	NQ	Futures	2061.38	2066.8	2060.53	2066.52	31805.0
2009-11-17 16:00:00	NQ	Futures	2066.52	2066.8	2062.52	2063.66	12910.0
2009-11-17 17:00:00	NQ	Futures	2063.66	2063.66	2062.81	2063.38	34.0
2009-11-17 18:00:00	NQ	Futures	2063.66	2065.09	2062.81	2065.09	426.0
2009-11-17 19:00:00	NQ	Futures	2065.09	2068.51	2065.09	2067.94	437.0
2009-11-17 20:00:00	NQ	Futures	2067.94	2067.94	2063.09	2063.09	476.0
2009-11-17 21:00:00	NQ	Futures	2063.38	2065.66	2062.52	2063.66	478.0
2009-11-17 22:00:00	NQ	Futures	2063.66	2064.24	2059.39	2060.81	445.0
2009-11-17 23:00:00	NQ	Futures	2061.1	2061.1	2058.25	2059.96	266.0
2009-11-17 00:00:00	YM	Futures	9622.8	9628.3	9609.7	9610.7	331.0
2009-11-17 01:00:00	YM	Futures	9609.7	9627.4	9607.9	9624.6	536.0

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

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