PREVIEW / futures_1hour / 2010-05-26

all futures 1-hour files

  file:    by_date/futures_1hour/2010/2010-05-26.parquet
  size:    47 KB
  rows:    1,396

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-05-26 00:00:00	ES	Futures	1053.97	1055.43	1052.74	1054.7	6430.0
2010-05-26 01:00:00	ES	Futures	1054.45	1054.7	1048.59	1048.83	7492.0
2010-05-26 02:00:00	ES	Futures	1048.59	1052.01	1047.37	1050.54	17913.0
2010-05-26 03:00:00	ES	Futures	1050.54	1054.94	1046.63	1054.45	57395.0
2010-05-26 04:00:00	ES	Futures	1054.45	1057.14	1052.26	1055.43	31389.0
2010-05-26 05:00:00	ES	Futures	1055.19	1057.88	1053.97	1054.94	25789.0
2010-05-26 06:00:00	ES	Futures	1054.7	1056.41	1052.74	1055.92	19412.0
2010-05-26 07:00:00	ES	Futures	1055.92	1059.1	1055.68	1058.37	36662.0
2010-05-26 08:00:00	ES	Futures	1058.37	1061.54	1055.92	1056.41	116423.0
2010-05-26 09:00:00	ES	Futures	1056.41	1063.25	1054.7	1062.28	361457.0
2010-05-26 10:00:00	ES	Futures	1062.03	1065.21	1059.34	1060.81	411865.0
2010-05-26 11:00:00	ES	Futures	1060.57	1061.79	1052.5	1056.65	374060.0
2010-05-26 12:00:00	ES	Futures	1056.65	1060.32	1054.7	1059.59	169004.0
2010-05-26 13:00:00	ES	Futures	1059.59	1062.52	1057.63	1060.32	148419.0
2010-05-26 14:00:00	ES	Futures	1060.32	1061.3	1050.06	1053.23	295324.0
2010-05-26 15:00:00	ES	Futures	1052.99	1055.92	1039.54	1042.48	590202.0
2010-05-26 16:00:00	ES	Futures	1042.23	1042.72	1035.39	1038.57	155829.0
2010-05-26 17:00:00	ES	Futures	1038.57	1038.57	1031.97	1032.46	9210.0
2010-05-26 18:00:00	ES	Futures	1032.46	1036.37	1032.46	1036.37	12062.0
2010-05-26 19:00:00	ES	Futures	1036.12	1039.79	1035.39	1039.54	8302.0
2010-05-26 20:00:00	ES	Futures	1039.3	1042.97	1039.06	1042.48	14514.0
2010-05-26 21:00:00	ES	Futures	1042.72	1044.92	1039.54	1040.03	14318.0
2010-05-26 22:00:00	ES	Futures	1040.03	1044.68	1037.83	1043.21	11630.0
2010-05-26 23:00:00	ES	Futures	1043.21	1045.17	1042.97	1044.68	5615.0
2010-05-26 00:00:00	NQ	Futures	2090.81	2093.38	2088.23	2092.24	433.0
2010-05-26 01:00:00	NQ	Futures	2091.67	2091.67	2081.36	2081.36	485.0
2010-05-26 02:00:00	NQ	Futures	2081.36	2086.8	2079.35	2083.36	1394.0
2010-05-26 03:00:00	NQ	Futures	2083.36	2092.52	2076.2	2092.24	3771.0
2010-05-26 04:00:00	NQ	Futures	2092.24	2095.67	2087.94	2092.24	1591.0
2010-05-26 05:00:00	NQ	Futures	2092.24	2096.82	2088.8	2090.52	1454.0
2010-05-26 06:00:00	NQ	Futures	2090.23	2094.53	2087.08	2093.1	1732.0
2010-05-26 07:00:00	NQ	Futures	2093.38	2098.25	2093.1	2097.97	1992.0
2010-05-26 08:00:00	NQ	Futures	2098.25	2104.55	2091.67	2093.1	11260.0
2010-05-26 09:00:00	NQ	Futures	2093.1	2112.86	2088.23	2111.14	64819.0
2010-05-26 10:00:00	NQ	Futures	2110.57	2118.87	2104.84	2107.42	55075.0
2010-05-26 11:00:00	NQ	Futures	2107.42	2108.56	2088.8	2096.82	44027.0
2010-05-26 12:00:00	NQ	Futures	2096.82	2102.26	2091.67	2099.97	23111.0
2010-05-26 13:00:00	NQ	Futures	2099.97	2104.27	2095.67	2099.97	21457.0
2010-05-26 14:00:00	NQ	Futures	2099.68	2101.4	2074.2	2082.5	44705.0
2010-05-26 15:00:00	NQ	Futures	2082.5	2087.37	2051.86	2056.44	87573.0
2010-05-26 16:00:00	NQ	Futures	2056.16	2056.44	2046.13	2053.01	20065.0
2010-05-26 17:00:00	NQ	Futures	2053.01	2053.01	2040.98	2041.84	1301.0
2010-05-26 18:00:00	NQ	Futures	2042.7	2048.71	2042.7	2048.14	977.0
2010-05-26 19:00:00	NQ	Futures	2048.14	2055.01	2046.7	2053.86	611.0
2010-05-26 20:00:00	NQ	Futures	2053.86	2062.17	2053.58	2061.31	1575.0
2010-05-26 21:00:00	NQ	Futures	2061.88	2065.32	2054.72	2055.87	1406.0
2010-05-26 22:00:00	NQ	Futures	2055.87	2065.03	2052.43	2063.31	1257.0
2010-05-26 23:00:00	NQ	Futures	2063.03	2066.46	2062.74	2065.61	785.0
2010-05-26 00:00:00	YM	Futures	9473.8	9484.1	9463.4	9475.7	411.0
2010-05-26 01:00:00	YM	Futures	9476.6	9476.6	9434.3	9435.2	573.0

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

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