PREVIEW / futures_1hour / 2010-06-08

all futures 1-hour files

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

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-08 00:00:00	ES	Futures	1032.7	1032.95	1030.5	1030.75	3949.0
2010-06-08 01:00:00	ES	Futures	1030.75	1034.41	1030.5	1034.17	7347.0
2010-06-08 02:00:00	ES	Futures	1033.92	1037.35	1033.68	1036.12	22442.0
2010-06-08 03:00:00	ES	Futures	1036.12	1036.86	1031.72	1032.7	44540.0
2010-06-08 04:00:00	ES	Futures	1032.95	1033.92	1024.88	1025.12	57642.0
2010-06-08 05:00:00	ES	Futures	1024.88	1026.1	1022.19	1022.92	55849.0
2010-06-08 06:00:00	ES	Futures	1023.17	1028.3	1022.92	1025.61	32456.0
2010-06-08 07:00:00	ES	Futures	1025.61	1029.28	1025.12	1027.81	34620.0
2010-06-08 08:00:00	ES	Futures	1027.81	1031.23	1027.57	1028.79	69201.0
2010-06-08 09:00:00	ES	Futures	1028.79	1032.46	1023.17	1024.88	328483.0
2010-06-08 10:00:00	ES	Futures	1024.63	1030.26	1018.28	1023.9	568072.0
2010-06-08 11:00:00	ES	Futures	1023.9	1034.41	1018.04	1031.97	561093.0
2010-06-08 12:00:00	ES	Futures	1031.97	1033.43	1027.57	1031.72	217173.0
2010-06-08 13:00:00	ES	Futures	1031.72	1032.7	1019.75	1023.66	266820.0
2010-06-08 14:00:00	ES	Futures	1023.9	1032.95	1021.21	1027.57	346245.0
2010-06-08 15:00:00	ES	Futures	1027.57	1039.54	1025.12	1036.86	524635.0
2010-06-08 16:00:00	ES	Futures	1036.86	1037.1	1034.66	1036.61	115179.0
2010-06-08 17:00:00	ES	Futures	1036.61	1037.1	1036.12	1036.86	2744.0
2010-06-08 18:00:00	ES	Futures	1036.86	1037.1	1035.39	1036.86	4446.0
2010-06-08 19:00:00	ES	Futures	1036.86	1037.59	1034.9	1035.15	4154.0
2010-06-08 20:00:00	ES	Futures	1035.15	1035.39	1028.79	1031.23	15913.0
2010-06-08 21:00:00	ES	Futures	1031.23	1033.92	1029.52	1033.19	8430.0
2010-06-08 22:00:00	ES	Futures	1033.19	1033.43	1030.99	1032.21	6367.0
2010-06-08 23:00:00	ES	Futures	1031.97	1032.95	1031.48	1031.97	3866.0
2010-06-08 00:00:00	NQ	Futures	2072.76	2073.34	2068.76	2069.04	265.0
2010-06-08 01:00:00	NQ	Futures	2069.33	2074.48	2069.04	2074.2	469.0
2010-06-08 02:00:00	NQ	Futures	2074.2	2082.22	2073.91	2079.64	1716.0
2010-06-08 03:00:00	NQ	Futures	2079.64	2079.92	2071.05	2072.76	2981.0
2010-06-08 04:00:00	NQ	Futures	2072.76	2075.34	2058.45	2058.73	3182.0
2010-06-08 05:00:00	NQ	Futures	2058.45	2060.16	2051.86	2053.58	3029.0
2010-06-08 06:00:00	NQ	Futures	2054.15	2064.17	2054.15	2057.59	2157.0
2010-06-08 07:00:00	NQ	Futures	2057.3	2065.03	2056.73	2061.6	2535.0
2010-06-08 08:00:00	NQ	Futures	2061.6	2069.9	2061.6	2065.89	6210.0
2010-06-08 09:00:00	NQ	Futures	2066.18	2069.33	2042.98	2046.7	49324.0
2010-06-08 10:00:00	NQ	Futures	2046.42	2056.73	2029.81	2041.55	69017.0
2010-06-08 11:00:00	NQ	Futures	2041.55	2063.03	2028.95	2056.73	71417.0
2010-06-08 12:00:00	NQ	Futures	2056.73	2060.45	2045.85	2051.29	30376.0
2010-06-08 13:00:00	NQ	Futures	2051.29	2054.44	2027.52	2034.39	34283.0
2010-06-08 14:00:00	NQ	Futures	2034.39	2051.86	2028.38	2038.97	47795.0
2010-06-08 15:00:00	NQ	Futures	2038.97	2059.31	2031.24	2055.3	64443.0
2010-06-08 16:00:00	NQ	Futures	2055.3	2055.87	2050.71	2055.01	13519.0
2010-06-08 17:00:00	NQ	Futures	2055.3	2055.87	2054.15	2054.15	182.0
2010-06-08 18:00:00	NQ	Futures	2055.01	2055.58	2052.15	2054.72	365.0
2010-06-08 19:00:00	NQ	Futures	2054.44	2056.44	2052.72	2053.01	269.0
2010-06-08 20:00:00	NQ	Futures	2052.43	2052.43	2040.4	2045.27	1369.0
2010-06-08 21:00:00	NQ	Futures	2045.27	2051.0	2042.12	2049.28	722.0
2010-06-08 22:00:00	NQ	Futures	2049.0	2049.57	2044.7	2046.13	397.0
2010-06-08 23:00:00	NQ	Futures	2047.56	2049.28	2046.42	2046.7	335.0
2010-06-08 00:00:00	YM	Futures	9277.1	9280.9	9266.8	9266.8	278.0
2010-06-08 01:00:00	YM	Futures	9267.7	9288.4	9263.0	9286.5	459.0

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

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