PREVIEW / futures_1hour / 2010-06-02

all futures 1-hour files

  file:    by_date/futures_1hour/2010/2010-06-02.parquet
  size:    46 KB
  rows:    1,363

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-06-02 00:00:00	ES	Futures	1047.86	1049.81	1044.43	1045.66	8675.0
2010-06-02 01:00:00	ES	Futures	1045.41	1049.81	1043.94	1049.08	8028.0
2010-06-02 02:00:00	ES	Futures	1049.08	1050.79	1047.61	1050.54	11763.0
2010-06-02 03:00:00	ES	Futures	1050.3	1053.97	1048.34	1049.08	50780.0
2010-06-02 04:00:00	ES	Futures	1049.08	1051.03	1044.92	1046.63	33262.0
2010-06-02 05:00:00	ES	Futures	1046.63	1053.72	1046.63	1052.26	23518.0
2010-06-02 06:00:00	ES	Futures	1052.01	1052.74	1048.34	1052.01	24777.0
2010-06-02 07:00:00	ES	Futures	1051.77	1052.99	1049.81	1051.77	31346.0
2010-06-02 08:00:00	ES	Futures	1051.77	1052.01	1047.86	1049.08	51970.0
2010-06-02 09:00:00	ES	Futures	1049.08	1053.72	1046.88	1050.3	280317.0
2010-06-02 10:00:00	ES	Futures	1050.3	1056.65	1048.83	1053.97	366641.0
2010-06-02 11:00:00	ES	Futures	1053.97	1061.3	1053.72	1060.32	247509.0
2010-06-02 12:00:00	ES	Futures	1060.08	1062.03	1058.85	1061.54	114901.0
2010-06-02 13:00:00	ES	Futures	1061.54	1062.77	1058.37	1059.1	126911.0
2010-06-02 14:00:00	ES	Futures	1058.85	1066.43	1056.17	1065.21	244456.0
2010-06-02 15:00:00	ES	Futures	1065.45	1073.76	1064.97	1073.28	412591.0
2010-06-02 16:00:00	ES	Futures	1073.28	1073.52	1071.56	1073.28	107740.0
2010-06-02 17:00:00	ES	Futures	1073.52	1075.23	1073.03	1074.74	3752.0
2010-06-02 18:00:00	ES	Futures	1074.74	1074.74	1071.56	1072.3	5463.0
2010-06-02 19:00:00	ES	Futures	1072.05	1073.76	1071.81	1072.54	3130.0
2010-06-02 20:00:00	ES	Futures	1072.54	1074.5	1070.83	1073.52	9119.0
2010-06-02 21:00:00	ES	Futures	1073.52	1076.45	1073.52	1074.74	10696.0
2010-06-02 22:00:00	ES	Futures	1074.5	1075.72	1073.52	1074.01	4664.0
2010-06-02 23:00:00	ES	Futures	1074.25	1077.19	1074.01	1075.48	4637.0
2010-06-02 00:00:00	NQ	Futures	2105.12	2107.99	2099.68	2100.26	388.0
2010-06-02 01:00:00	NQ	Futures	2100.26	2108.28	2098.54	2107.13	463.0
2010-06-02 02:00:00	NQ	Futures	2107.13	2110.85	2104.55	2109.71	891.0
2010-06-02 03:00:00	NQ	Futures	2109.99	2115.43	2105.41	2107.7	3607.0
2010-06-02 04:00:00	NQ	Futures	2107.7	2111.71	2100.26	2103.12	2596.0
2010-06-02 05:00:00	NQ	Futures	2103.41	2116.58	2103.12	2114.0	1578.0
2010-06-02 06:00:00	NQ	Futures	2113.14	2114.0	2107.42	2113.43	1706.0
2010-06-02 07:00:00	NQ	Futures	2113.43	2116.58	2111.71	2114.86	3443.0
2010-06-02 08:00:00	NQ	Futures	2114.58	2115.15	2107.13	2109.13	7261.0
2010-06-02 09:00:00	NQ	Futures	2109.42	2116.29	2098.82	2106.84	52084.0
2010-06-02 10:00:00	NQ	Futures	2106.84	2123.17	2105.12	2117.73	49662.0
2010-06-02 11:00:00	NQ	Futures	2118.01	2130.9	2117.73	2128.61	28728.0
2010-06-02 12:00:00	NQ	Futures	2128.61	2135.77	2128.03	2134.62	18434.0
2010-06-02 13:00:00	NQ	Futures	2134.62	2136.91	2128.03	2129.18	24032.0
2010-06-02 14:00:00	NQ	Futures	2128.89	2139.49	2120.3	2137.2	35657.0
2010-06-02 15:00:00	NQ	Futures	2137.2	2152.66	2136.34	2151.52	57554.0
2010-06-02 16:00:00	NQ	Futures	2151.52	2152.09	2148.08	2151.23	12377.0
2010-06-02 17:00:00	NQ	Futures	2151.23	2155.53	2150.94	2154.38	296.0
2010-06-02 18:00:00	NQ	Futures	2154.09	2155.53	2149.51	2149.8	430.0
2010-06-02 19:00:00	NQ	Futures	2150.37	2152.95	2149.23	2150.66	210.0
2010-06-02 20:00:00	NQ	Futures	2150.37	2154.67	2148.08	2153.52	1010.0
2010-06-02 21:00:00	NQ	Futures	2153.24	2158.1	2153.24	2154.67	925.0
2010-06-02 22:00:00	NQ	Futures	2154.67	2156.67	2152.09	2153.52	727.0
2010-06-02 23:00:00	NQ	Futures	2153.81	2159.25	2153.81	2156.96	535.0
2010-06-02 00:00:00	YM	Futures	9447.4	9456.8	9420.1	9427.7	618.0
2010-06-02 01:00:00	YM	Futures	9426.7	9463.4	9415.4	9454.0	494.0

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

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