PREVIEW / futures_1hour / 2010-06-10

all futures 1-hour files

  file:    by_date/futures_1hour/2010/2010-06-10.parquet
  size:    45 KB
  rows:    1,325

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-10 00:00:00	ES	Futures	1034.9	1038.81	1034.41	1038.08	14189.0
2010-06-10 01:00:00	ES	Futures	1038.08	1038.81	1035.63	1038.57	5631.0
2010-06-10 02:00:00	ES	Futures	1038.32	1038.81	1037.35	1038.32	13974.0
2010-06-10 03:00:00	ES	Futures	1038.57	1040.77	1036.37	1037.35	45471.0
2010-06-10 04:00:00	ES	Futures	1037.1	1044.92	1036.37	1042.72	50431.0
2010-06-10 05:00:00	ES	Futures	1042.97	1045.66	1041.99	1043.7	34425.0
2010-06-10 06:00:00	ES	Futures	1043.7	1043.94	1041.74	1043.46	21226.0
2010-06-10 07:00:00	ES	Futures	1043.7	1044.43	1040.77	1041.01	37131.0
2010-06-10 08:00:00	ES	Futures	1040.77	1044.19	1038.81	1042.97	89619.0
2010-06-10 09:00:00	ES	Futures	1042.97	1056.9	1041.99	1056.65	364708.0
2010-06-10 10:00:00	ES	Futures	1056.65	1059.1	1050.79	1053.72	254746.0
2010-06-10 11:00:00	ES	Futures	1053.72	1056.9	1051.52	1053.48	156887.0
2010-06-10 12:00:00	ES	Futures	1053.72	1054.21	1047.86	1051.03	170530.0
2010-06-10 13:00:00	ES	Futures	1051.28	1055.68	1048.34	1053.97	104554.0
2010-06-10 14:00:00	ES	Futures	1054.21	1059.59	1051.03	1057.39	110018.0
2010-06-10 15:00:00	ES	Futures	1057.63	1063.5	1056.41	1062.52	212787.0
2010-06-10 16:00:00	ES	Futures	1062.52	1062.77	1058.85	1060.81	81254.0
2010-06-10 17:00:00	ES	Futures	1061.05	1061.3	1060.57	1061.3	731.0
2010-06-10 18:00:00	ES	Futures	1061.3	1061.54	1059.83	1060.08	1774.0
2010-06-10 19:00:00	ES	Futures	1060.57	1060.81	1059.59	1060.32	1684.0
2010-06-10 20:00:00	ES	Futures	1060.57	1060.57	1057.88	1058.85	4543.0
2010-06-10 21:00:00	ES	Futures	1058.85	1060.32	1058.37	1058.61	2079.0
2010-06-10 22:00:00	ES	Futures	1058.61	1058.61	1057.39	1057.39	2059.0
2010-06-10 23:00:00	ES	Futures	1057.39	1059.1	1057.39	1058.37	1375.0
2010-06-10 00:00:00	NQ	Futures	2046.42	2052.15	2045.85	2052.15	666.0
2010-06-10 01:00:00	NQ	Futures	2052.15	2052.15	2046.42	2051.29	168.0
2010-06-10 02:00:00	NQ	Futures	2051.86	2053.29	2049.0	2052.43	654.0
2010-06-10 03:00:00	NQ	Futures	2052.15	2057.01	2047.85	2049.57	3109.0
2010-06-10 04:00:00	NQ	Futures	2049.28	2063.31	2048.14	2059.31	3090.0
2010-06-10 05:00:00	NQ	Futures	2059.31	2065.32	2057.59	2060.74	1704.0
2010-06-10 06:00:00	NQ	Futures	2061.02	2061.6	2057.3	2059.59	1688.0
2010-06-10 07:00:00	NQ	Futures	2059.59	2062.74	2052.72	2053.01	3378.0
2010-06-10 08:00:00	NQ	Futures	2053.29	2059.02	2046.13	2054.72	9495.0
2010-06-10 09:00:00	NQ	Futures	2054.72	2079.64	2053.29	2078.21	39683.0
2010-06-10 10:00:00	NQ	Futures	2077.92	2083.65	2069.9	2076.77	24811.0
2010-06-10 11:00:00	NQ	Futures	2077.06	2083.07	2069.33	2075.63	13790.0
2010-06-10 12:00:00	NQ	Futures	2075.63	2076.77	2064.17	2069.61	14542.0
2010-06-10 13:00:00	NQ	Futures	2069.61	2080.21	2064.75	2078.21	12211.0
2010-06-10 14:00:00	NQ	Futures	2077.63	2092.81	2071.33	2088.8	16651.0
2010-06-10 15:00:00	NQ	Futures	2088.52	2098.25	2086.22	2097.11	23848.0
2010-06-10 16:00:00	NQ	Futures	2097.11	2097.11	2085.94	2088.8	5692.0
2010-06-10 17:00:00	NQ	Futures	2088.8	2089.66	2088.52	2089.37	14.0
2010-06-10 18:00:00	NQ	Futures	2090.23	2091.38	2087.66	2088.23	246.0
2010-06-10 19:00:00	NQ	Futures	2088.8	2089.37	2087.94	2089.09	59.0
2010-06-10 20:00:00	NQ	Futures	2088.23	2088.52	2084.79	2086.22	165.0
2010-06-10 21:00:00	NQ	Futures	2087.08	2089.37	2085.37	2086.22	127.0
2010-06-10 22:00:00	NQ	Futures	2085.37	2085.94	2083.36	2083.93	102.0
2010-06-10 23:00:00	NQ	Futures	2083.65	2085.94	2083.65	2084.51	30.0
2010-06-10 00:00:00	YM	Futures	9340.2	9368.6	9336.4	9359.1	38.0
2010-06-10 01:00:00	YM	Futures	9357.2	9370.5	9351.5	9370.5	38.0

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

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