PREVIEW / futures_1hour / 2010-05-24

all futures 1-hour files

  file:    by_date/futures_1hour/2010/2010-05-24.parquet
  size:    46 KB
  rows:    1,345

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-24 00:00:00	ES	Futures	1055.19	1059.34	1054.7	1056.41	7025.0
2010-05-24 01:00:00	ES	Futures	1056.65	1058.37	1055.19	1055.92	6372.0
2010-05-24 02:00:00	ES	Futures	1055.68	1059.83	1055.43	1059.59	14647.0
2010-05-24 03:00:00	ES	Futures	1059.59	1062.52	1057.63	1057.88	40325.0
2010-05-24 04:00:00	ES	Futures	1057.63	1058.37	1052.74	1054.45	36977.0
2010-05-24 05:00:00	ES	Futures	1054.45	1056.65	1051.03	1052.26	27058.0
2010-05-24 06:00:00	ES	Futures	1052.26	1052.26	1046.14	1048.59	36455.0
2010-05-24 07:00:00	ES	Futures	1048.59	1052.5	1047.61	1050.54	45752.0
2010-05-24 08:00:00	ES	Futures	1050.54	1055.68	1049.81	1055.68	56129.0
2010-05-24 09:00:00	ES	Futures	1055.43	1060.81	1052.74	1054.45	332466.0
2010-05-24 10:00:00	ES	Futures	1054.45	1062.77	1051.77	1059.34	352195.0
2010-05-24 11:00:00	ES	Futures	1059.34	1062.28	1056.17	1061.3	212674.0
2010-05-24 12:00:00	ES	Futures	1061.3	1064.48	1059.83	1063.25	168684.0
2010-05-24 13:00:00	ES	Futures	1063.25	1064.23	1056.41	1058.85	191484.0
2010-05-24 14:00:00	ES	Futures	1058.61	1060.57	1055.19	1056.41	144294.0
2010-05-24 15:00:00	ES	Futures	1056.17	1057.88	1047.12	1048.1	359647.0
2010-05-24 16:00:00	ES	Futures	1048.1	1048.59	1042.72	1044.43	110190.0
2010-05-24 17:00:00	ES	Futures	1044.68	1045.17	1042.23	1042.48	4267.0
2010-05-24 18:00:00	ES	Futures	1042.72	1043.21	1040.28	1042.48	8787.0
2010-05-24 19:00:00	ES	Futures	1042.48	1042.72	1039.3	1040.52	6343.0
2010-05-24 20:00:00	ES	Futures	1040.52	1041.5	1033.68	1035.88	25773.0
2010-05-24 21:00:00	ES	Futures	1035.88	1037.35	1034.41	1034.9	14771.0
2010-05-24 22:00:00	ES	Futures	1035.15	1035.39	1031.72	1033.68	12862.0
2010-05-24 23:00:00	ES	Futures	1033.68	1035.39	1028.79	1029.52	13283.0
2010-05-24 00:00:00	NQ	Futures	2074.48	2081.64	2074.48	2076.77	512.0
2010-05-24 01:00:00	NQ	Futures	2076.77	2079.07	2071.62	2075.06	396.0
2010-05-24 02:00:00	NQ	Futures	2075.34	2083.07	2074.77	2081.64	757.0
2010-05-24 03:00:00	NQ	Futures	2081.93	2086.22	2077.63	2077.63	2412.0
2010-05-24 04:00:00	NQ	Futures	2077.35	2078.49	2068.76	2071.91	2435.0
2010-05-24 05:00:00	NQ	Futures	2071.33	2076.2	2065.89	2066.75	1536.0
2010-05-24 06:00:00	NQ	Futures	2066.46	2066.46	2057.3	2062.46	2716.0
2010-05-24 07:00:00	NQ	Futures	2062.74	2070.76	2060.16	2066.46	3401.0
2010-05-24 08:00:00	NQ	Futures	2066.46	2082.22	2066.18	2082.22	9252.0
2010-05-24 09:00:00	NQ	Futures	2081.93	2099.4	2079.35	2087.66	65094.0
2010-05-24 10:00:00	NQ	Futures	2087.94	2105.7	2082.5	2097.11	56103.0
2010-05-24 11:00:00	NQ	Futures	2097.11	2101.12	2090.23	2098.54	35423.0
2010-05-24 12:00:00	NQ	Futures	2098.25	2107.42	2096.82	2105.7	25121.0
2010-05-24 13:00:00	NQ	Futures	2105.98	2107.7	2095.96	2099.4	24204.0
2010-05-24 14:00:00	NQ	Futures	2099.4	2104.55	2096.25	2099.11	22547.0
2010-05-24 15:00:00	NQ	Futures	2099.11	2100.54	2075.91	2076.2	49590.0
2010-05-24 16:00:00	NQ	Futures	2076.49	2079.07	2067.9	2070.47	11806.0
2010-05-24 17:00:00	NQ	Futures	2070.76	2071.62	2068.18	2069.61	338.0
2010-05-24 18:00:00	NQ	Futures	2069.04	2069.33	2064.46	2067.9	399.0
2010-05-24 19:00:00	NQ	Futures	2067.9	2068.47	2062.74	2065.32	408.0
2010-05-24 20:00:00	NQ	Futures	2065.61	2066.46	2051.57	2055.58	1866.0
2010-05-24 21:00:00	NQ	Futures	2055.87	2057.87	2053.29	2054.44	1674.0
2010-05-24 22:00:00	NQ	Futures	2054.15	2054.44	2047.56	2051.57	1316.0
2010-05-24 23:00:00	NQ	Futures	2051.29	2055.01	2043.27	2044.99	1430.0
2010-05-24 00:00:00	YM	Futures	9524.6	9558.5	9524.6	9541.5	828.0
2010-05-24 01:00:00	YM	Futures	9539.7	9550.0	9528.4	9535.9	569.0

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

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