PREVIEW / futures_1hour / 2010-08-24

all futures 1-hour files

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

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-08-24 00:00:00	ES	Futures	1044.09	1044.83	1041.64	1042.13	4920.0
2010-08-24 01:00:00	ES	Futures	1042.37	1043.6	1041.88	1043.35	3381.0
2010-08-24 02:00:00	ES	Futures	1043.35	1043.6	1040.65	1041.15	16033.0
2010-08-24 03:00:00	ES	Futures	1041.15	1042.13	1036.48	1036.97	56261.0
2010-08-24 04:00:00	ES	Futures	1036.73	1038.45	1035.5	1037.71	32995.0
2010-08-24 05:00:00	ES	Futures	1037.71	1038.45	1036.48	1036.97	17672.0
2010-08-24 06:00:00	ES	Futures	1036.73	1039.18	1036.73	1037.96	17023.0
2010-08-24 07:00:00	ES	Futures	1037.96	1039.43	1034.52	1034.77	31627.0
2010-08-24 08:00:00	ES	Futures	1034.77	1035.99	1032.07	1033.05	92342.0
2010-08-24 09:00:00	ES	Futures	1032.8	1035.5	1029.37	1032.07	299470.0
2010-08-24 10:00:00	ES	Futures	1032.07	1034.27	1024.7	1033.78	542870.0
2010-08-24 11:00:00	ES	Futures	1033.78	1038.69	1032.31	1035.75	310311.0
2010-08-24 12:00:00	ES	Futures	1035.75	1037.96	1033.05	1033.78	141028.0
2010-08-24 13:00:00	ES	Futures	1033.78	1036.73	1030.35	1031.08	176523.0
2010-08-24 14:00:00	ES	Futures	1031.33	1035.01	1030.35	1034.27	203834.0
2010-08-24 15:00:00	ES	Futures	1034.52	1037.71	1029.61	1030.84	375528.0
2010-08-24 16:00:00	ES	Futures	1030.84	1031.08	1028.63	1028.63	104177.0
2010-08-24 17:00:00	ES	Futures	1028.88	1029.61	1027.89	1029.12	2470.0
2010-08-24 18:00:00	ES	Futures	1029.12	1030.59	1028.88	1029.86	2229.0
2010-08-24 19:00:00	ES	Futures	1029.86	1032.8	1028.88	1032.56	5725.0
2010-08-24 20:00:00	ES	Futures	1032.56	1034.03	1032.07	1033.54	8616.0
2010-08-24 21:00:00	ES	Futures	1033.78	1034.77	1033.29	1033.29	6502.0
2010-08-24 22:00:00	ES	Futures	1033.54	1034.52	1032.31	1033.29	4033.0
2010-08-24 23:00:00	ES	Futures	1033.54	1034.52	1032.8	1033.54	2582.0
2010-08-24 00:00:00	NQ	Futures	2071.3	2072.45	2064.42	2065.85	862.0
2010-08-24 01:00:00	NQ	Futures	2066.14	2069.29	2065.85	2069.29	190.0
2010-08-24 02:00:00	NQ	Futures	2069.29	2069.29	2063.56	2064.42	858.0
2010-08-24 03:00:00	NQ	Futures	2064.42	2064.99	2055.82	2056.68	5113.0
2010-08-24 04:00:00	NQ	Futures	2056.68	2059.55	2054.39	2058.4	1615.0
2010-08-24 05:00:00	NQ	Futures	2058.69	2059.84	2056.11	2057.54	1716.0
2010-08-24 06:00:00	NQ	Futures	2057.54	2062.13	2057.54	2059.26	1572.0
2010-08-24 07:00:00	NQ	Futures	2059.55	2062.13	2052.96	2053.53	1943.0
2010-08-24 08:00:00	NQ	Futures	2053.25	2055.82	2045.51	2048.37	10660.0
2010-08-24 09:00:00	NQ	Futures	2048.37	2050.67	2035.19	2038.34	54906.0
2010-08-24 10:00:00	NQ	Futures	2038.34	2042.36	2024.3	2042.07	60384.0
2010-08-24 11:00:00	NQ	Futures	2042.07	2055.25	2039.78	2046.94	42371.0
2010-08-24 12:00:00	NQ	Futures	2046.94	2052.39	2040.92	2041.78	21738.0
2010-08-24 13:00:00	NQ	Futures	2041.78	2047.23	2034.62	2036.62	25866.0
2010-08-24 14:00:00	NQ	Futures	2036.62	2042.64	2035.48	2041.5	27387.0
2010-08-24 15:00:00	NQ	Futures	2041.5	2048.66	2032.33	2033.76	48494.0
2010-08-24 16:00:00	NQ	Futures	2033.47	2034.62	2030.61	2030.61	9887.0
2010-08-24 17:00:00	NQ	Futures	2030.61	2031.75	2029.17	2031.75	185.0
2010-08-24 18:00:00	NQ	Futures	2030.89	2033.76	2030.89	2032.33	221.0
2010-08-24 19:00:00	NQ	Futures	2031.75	2036.91	2030.32	2036.91	436.0
2010-08-24 20:00:00	NQ	Futures	2036.91	2039.2	2036.05	2038.63	536.0
2010-08-24 21:00:00	NQ	Futures	2038.63	2040.35	2037.77	2038.06	415.0
2010-08-24 22:00:00	NQ	Futures	2037.77	2039.78	2035.77	2038.06	309.0
2010-08-24 23:00:00	NQ	Futures	2037.77	2039.78	2036.62	2037.48	146.0
2010-08-24 00:00:00	YM	Futures	9600.5	9602.4	9574.9	9580.6	470.0
2010-08-24 01:00:00	YM	Futures	9579.7	9592.0	9578.7	9590.1	225.0

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

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