PREVIEW / futures_1hour / 2010-09-02

all futures 1-hour files

  file:    by_date/futures_1hour/2010/2010-09-02.parquet
  size:    44 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-02 00:00:00	ES	Futures	1057.09	1058.81	1056.6	1056.85	4795.0
2010-09-02 01:00:00	ES	Futures	1056.85	1058.57	1056.6	1057.83	7579.0
2010-09-02 02:00:00	ES	Futures	1058.08	1059.79	1057.09	1059.55	11146.0
2010-09-02 03:00:00	ES	Futures	1059.55	1059.79	1056.85	1058.08	36072.0
2010-09-02 04:00:00	ES	Futures	1058.32	1061.76	1057.59	1058.81	31559.0
2010-09-02 05:00:00	ES	Futures	1058.81	1062.49	1058.81	1062.0	21752.0
2010-09-02 06:00:00	ES	Futures	1062.0	1062.0	1059.06	1060.04	13703.0
2010-09-02 07:00:00	ES	Futures	1060.04	1064.7	1060.04	1062.0	47678.0
2010-09-02 08:00:00	ES	Futures	1062.0	1064.46	1060.28	1062.74	79658.0
2010-09-02 09:00:00	ES	Futures	1062.74	1063.97	1059.3	1063.72	226582.0
2010-09-02 10:00:00	ES	Futures	1063.47	1065.93	1061.02	1064.95	289496.0
2010-09-02 11:00:00	ES	Futures	1065.19	1066.42	1061.51	1063.97	177956.0
2010-09-02 12:00:00	ES	Futures	1063.72	1065.44	1062.49	1062.74	94451.0
2010-09-02 13:00:00	ES	Futures	1062.74	1064.46	1062.0	1063.97	62653.0
2010-09-02 14:00:00	ES	Futures	1063.97	1066.91	1063.47	1065.68	125281.0
2010-09-02 15:00:00	ES	Futures	1065.44	1069.12	1064.46	1069.12	222075.0
2010-09-02 16:00:00	ES	Futures	1068.87	1070.35	1068.87	1069.12	106378.0
2010-09-02 17:00:00	ES	Futures	1069.12	1069.36	1068.38	1068.87	2877.0
2010-09-02 18:00:00	ES	Futures	1068.87	1069.12	1068.38	1068.87	1455.0
2010-09-02 19:00:00	ES	Futures	1068.63	1068.87	1067.4	1067.89	2987.0
2010-09-02 20:00:00	ES	Futures	1067.89	1069.85	1067.4	1068.87	7549.0
2010-09-02 21:00:00	ES	Futures	1068.87	1069.61	1066.91	1067.4	6807.0
2010-09-02 22:00:00	ES	Futures	1067.4	1068.87	1066.91	1066.91	2649.0
2010-09-02 23:00:00	ES	Futures	1066.91	1068.38	1066.91	1067.16	2614.0
2010-09-02 00:00:00	NQ	Futures	2079.04	2081.62	2078.18	2079.61	292.0
2010-09-02 01:00:00	NQ	Futures	2079.32	2081.62	2079.04	2080.47	279.0
2010-09-02 02:00:00	NQ	Futures	2079.9	2085.05	2079.61	2084.48	1207.0
2010-09-02 03:00:00	NQ	Futures	2084.77	2085.05	2078.75	2081.62	2054.0
2010-09-02 04:00:00	NQ	Futures	2081.62	2088.49	2080.76	2081.9	5117.0
2010-09-02 05:00:00	NQ	Futures	2082.19	2088.49	2082.19	2087.92	1073.0
2010-09-02 06:00:00	NQ	Futures	2087.92	2087.92	2083.05	2084.77	851.0
2010-09-02 07:00:00	NQ	Futures	2085.05	2093.08	2084.19	2087.06	3043.0
2010-09-02 08:00:00	NQ	Futures	2087.06	2092.22	2084.48	2089.35	8805.0
2010-09-02 09:00:00	NQ	Futures	2089.07	2094.8	2083.05	2093.94	39350.0
2010-09-02 10:00:00	NQ	Futures	2093.08	2101.1	2088.49	2099.96	46993.0
2010-09-02 11:00:00	NQ	Futures	2099.96	2102.25	2095.66	2099.67	27828.0
2010-09-02 12:00:00	NQ	Futures	2099.67	2102.53	2095.94	2097.09	20591.0
2010-09-02 13:00:00	NQ	Futures	2097.09	2099.96	2095.66	2099.38	14119.0
2010-09-02 14:00:00	NQ	Futures	2099.38	2106.26	2098.52	2101.96	25222.0
2010-09-02 15:00:00	NQ	Futures	2102.25	2109.13	2099.96	2109.13	40531.0
2010-09-02 16:00:00	NQ	Futures	2108.84	2110.56	2105.97	2106.55	11953.0
2010-09-02 17:00:00	NQ	Futures	2106.55	2107.41	2105.97	2106.55	131.0
2010-09-02 18:00:00	NQ	Futures	2106.55	2107.98	2106.26	2106.26	138.0
2010-09-02 19:00:00	NQ	Futures	2106.55	2106.83	2104.83	2104.83	125.0
2010-09-02 20:00:00	NQ	Futures	2104.83	2108.27	2104.83	2107.41	280.0
2010-09-02 21:00:00	NQ	Futures	2107.69	2108.55	2103.97	2105.11	316.0
2010-09-02 22:00:00	NQ	Futures	2105.11	2107.12	2103.97	2103.97	112.0
2010-09-02 23:00:00	NQ	Futures	2104.25	2105.97	2103.39	2103.68	227.0
2010-09-02 00:00:00	YM	Futures	9687.6	9699.9	9686.6	9688.5	282.0
2010-09-02 01:00:00	YM	Futures	9688.5	9698.0	9684.7	9693.3	442.0

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

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