PREVIEW / futures_1hour / 2009-11-18

all futures 1-hour files

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

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-18 00:00:00	ES	Futures	1072.07	1072.8	1071.59	1072.32	2429.0
2009-11-18 01:00:00	ES	Futures	1072.32	1073.28	1071.59	1073.04	1888.0
2009-11-18 02:00:00	ES	Futures	1072.8	1074.25	1072.32	1072.32	6489.0
2009-11-18 03:00:00	ES	Futures	1072.56	1074.01	1071.83	1072.56	16196.0
2009-11-18 04:00:00	ES	Futures	1072.56	1073.28	1071.83	1073.28	11388.0
2009-11-18 05:00:00	ES	Futures	1073.04	1074.25	1072.8	1074.01	5515.0
2009-11-18 06:00:00	ES	Futures	1074.01	1075.71	1073.77	1075.46	10658.0
2009-11-18 07:00:00	ES	Futures	1075.46	1075.71	1073.53	1075.22	17714.0
2009-11-18 08:00:00	ES	Futures	1075.22	1075.71	1070.38	1072.07	76032.0
2009-11-18 09:00:00	ES	Futures	1071.83	1074.98	1067.96	1068.92	257923.0
2009-11-18 10:00:00	ES	Futures	1068.68	1072.8	1066.5	1071.59	259999.0
2009-11-18 11:00:00	ES	Futures	1071.59	1073.53	1069.89	1072.07	133420.0
2009-11-18 12:00:00	ES	Futures	1071.83	1072.56	1068.68	1069.17	111668.0
2009-11-18 13:00:00	ES	Futures	1069.17	1070.62	1066.99	1069.65	157831.0
2009-11-18 14:00:00	ES	Futures	1069.89	1071.83	1068.68	1069.89	93099.0
2009-11-18 15:00:00	ES	Futures	1070.14	1074.01	1069.89	1073.53	209242.0
2009-11-18 16:00:00	ES	Futures	1073.53	1074.74	1072.8	1074.5	74405.0
2009-11-18 17:00:00	ES	Futures	1074.5	1074.98	1074.25	1074.98	1204.0
2009-11-18 18:00:00	ES	Futures	1074.5	1074.98	1074.01	1074.01	2642.0
2009-11-18 19:00:00	ES	Futures	1074.01	1074.5	1072.56	1072.8	6211.0
2009-11-18 20:00:00	ES	Futures	1072.8	1073.04	1070.38	1072.07	7969.0
2009-11-18 21:00:00	ES	Futures	1072.07	1072.56	1071.1	1071.59	3388.0
2009-11-18 22:00:00	ES	Futures	1071.83	1071.83	1069.89	1070.14	5188.0
2009-11-18 23:00:00	ES	Futures	1070.38	1071.59	1069.65	1071.1	4202.0
2009-11-18 00:00:00	NQ	Futures	2059.96	2061.95	2059.96	2061.38	127.0
2009-11-18 01:00:00	NQ	Futures	2061.1	2062.81	2060.24	2062.81	183.0
2009-11-18 02:00:00	NQ	Futures	2062.81	2065.95	2061.95	2061.95	839.0
2009-11-18 03:00:00	NQ	Futures	2061.95	2064.52	2060.53	2062.81	1802.0
2009-11-18 04:00:00	NQ	Futures	2062.81	2063.95	2061.1	2063.66	609.0
2009-11-18 05:00:00	NQ	Futures	2063.66	2064.81	2062.81	2064.52	366.0
2009-11-18 06:00:00	NQ	Futures	2064.52	2067.37	2063.95	2066.8	1011.0
2009-11-18 07:00:00	NQ	Futures	2066.52	2066.52	2062.24	2062.81	4028.0
2009-11-18 08:00:00	NQ	Futures	2062.81	2063.38	2055.68	2058.25	7861.0
2009-11-18 09:00:00	NQ	Futures	2057.96	2061.1	2045.41	2046.84	44226.0
2009-11-18 10:00:00	NQ	Futures	2046.84	2053.11	2041.99	2050.26	52158.0
2009-11-18 11:00:00	NQ	Futures	2050.55	2055.39	2046.55	2051.12	27273.0
2009-11-18 12:00:00	NQ	Futures	2050.83	2051.97	2045.7	2045.98	17093.0
2009-11-18 13:00:00	NQ	Futures	2045.7	2046.55	2040.56	2045.13	26391.0
2009-11-18 14:00:00	NQ	Futures	2045.13	2050.55	2044.56	2046.27	22963.0
2009-11-18 15:00:00	NQ	Futures	2046.27	2055.11	2045.98	2055.11	35487.0
2009-11-18 16:00:00	NQ	Futures	2055.11	2055.68	2053.68	2054.54	10177.0
2009-11-18 17:00:00	NQ	Futures	2054.25	2055.68	2054.25	2055.68	274.0
2009-11-18 18:00:00	NQ	Futures	2055.39	2055.68	2055.11	2055.11	218.0
2009-11-18 19:00:00	NQ	Futures	2054.82	2054.82	2051.4	2052.26	445.0
2009-11-18 20:00:00	NQ	Futures	2052.54	2053.11	2047.98	2051.69	586.0
2009-11-18 21:00:00	NQ	Futures	2051.12	2052.26	2048.83	2050.26	409.0
2009-11-18 22:00:00	NQ	Futures	2050.26	2050.26	2047.41	2047.98	371.0
2009-11-18 23:00:00	NQ	Futures	2047.98	2049.98	2046.27	2049.98	251.0
2009-11-18 00:00:00	YM	Futures	9661.8	9670.2	9659.0	9668.3	169.0
2009-11-18 01:00:00	YM	Futures	9667.4	9674.9	9661.8	9674.9	230.0

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

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