PREVIEW / futures_1hour / 2010-08-26

all futures 1-hour files

  file:    by_date/futures_1hour/2010/2010-08-26.parquet
  size:    44 KB
  rows:    1,336

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-26 00:00:00	ES	Futures	1037.22	1037.96	1036.73	1036.97	4063.0
2010-08-26 01:00:00	ES	Futures	1036.73	1037.46	1035.99	1036.24	3950.0
2010-08-26 02:00:00	ES	Futures	1035.99	1036.97	1035.01	1035.99	11298.0
2010-08-26 03:00:00	ES	Futures	1035.75	1038.94	1035.75	1037.71	29548.0
2010-08-26 04:00:00	ES	Futures	1037.71	1038.69	1035.01	1035.75	24198.0
2010-08-26 05:00:00	ES	Futures	1035.99	1038.2	1035.01	1037.71	15309.0
2010-08-26 06:00:00	ES	Futures	1037.71	1039.43	1036.48	1036.97	12981.0
2010-08-26 07:00:00	ES	Futures	1036.97	1037.22	1035.01	1035.01	20425.0
2010-08-26 08:00:00	ES	Futures	1035.01	1042.13	1034.03	1040.16	115921.0
2010-08-26 09:00:00	ES	Futures	1040.16	1040.41	1033.78	1036.73	276026.0
2010-08-26 10:00:00	ES	Futures	1036.73	1040.65	1036.48	1037.71	265635.0
2010-08-26 11:00:00	ES	Futures	1037.46	1038.2	1030.84	1034.77	283482.0
2010-08-26 12:00:00	ES	Futures	1034.77	1035.01	1030.59	1033.29	115416.0
2010-08-26 13:00:00	ES	Futures	1033.29	1033.78	1030.35	1030.35	80350.0
2010-08-26 14:00:00	ES	Futures	1030.35	1031.58	1023.72	1024.95	223843.0
2010-08-26 15:00:00	ES	Futures	1024.7	1031.82	1024.7	1027.16	357498.0
2010-08-26 16:00:00	ES	Futures	1027.16	1027.65	1023.23	1024.46	122206.0
2010-08-26 17:00:00	ES	Futures	1024.46	1024.7	1022.5	1023.23	2669.0
2010-08-26 18:00:00	ES	Futures	1023.23	1024.7	1022.99	1024.7	3160.0
2010-08-26 19:00:00	ES	Futures	1024.7	1025.2	1023.23	1024.95	3618.0
2010-08-26 20:00:00	ES	Futures	1024.7	1026.67	1024.46	1026.42	5970.0
2010-08-26 21:00:00	ES	Futures	1026.42	1027.4	1023.48	1024.21	7560.0
2010-08-26 22:00:00	ES	Futures	1024.21	1024.7	1023.48	1023.97	2377.0
2010-08-26 23:00:00	ES	Futures	1023.72	1026.67	1023.48	1026.42	6591.0
2010-08-26 00:00:00	NQ	Futures	2055.82	2057.26	2054.96	2055.25	144.0
2010-08-26 01:00:00	NQ	Futures	2054.68	2056.97	2054.39	2054.96	401.0
2010-08-26 02:00:00	NQ	Futures	2054.68	2056.4	2052.96	2054.96	642.0
2010-08-26 03:00:00	NQ	Futures	2054.68	2059.55	2053.82	2057.54	1607.0
2010-08-26 04:00:00	NQ	Futures	2057.26	2059.26	2051.53	2052.67	1355.0
2010-08-26 05:00:00	NQ	Futures	2052.96	2057.54	2051.81	2056.97	793.0
2010-08-26 06:00:00	NQ	Futures	2056.68	2059.84	2053.53	2054.11	1026.0
2010-08-26 07:00:00	NQ	Futures	2054.39	2055.25	2051.24	2051.24	1964.0
2010-08-26 08:00:00	NQ	Futures	2051.24	2066.43	2048.95	2063.28	15104.0
2010-08-26 09:00:00	NQ	Futures	2063.28	2064.42	2049.52	2057.83	51407.0
2010-08-26 10:00:00	NQ	Futures	2057.83	2064.14	2049.23	2052.1	50271.0
2010-08-26 11:00:00	NQ	Futures	2051.81	2052.96	2039.49	2048.09	51404.0
2010-08-26 12:00:00	NQ	Futures	2047.8	2048.09	2038.92	2043.79	23441.0
2010-08-26 13:00:00	NQ	Futures	2044.08	2045.79	2037.77	2038.34	19485.0
2010-08-26 14:00:00	NQ	Futures	2038.06	2040.06	2025.74	2028.03	39057.0
2010-08-26 15:00:00	NQ	Futures	2027.74	2040.06	2026.02	2028.31	51949.0
2010-08-26 16:00:00	NQ	Futures	2028.31	2030.32	2021.15	2023.73	13488.0
2010-08-26 17:00:00	NQ	Futures	2023.73	2024.59	2020.0	2020.86	213.0
2010-08-26 18:00:00	NQ	Futures	2021.15	2024.3	2021.15	2023.16	176.0
2010-08-26 19:00:00	NQ	Futures	2023.44	2024.02	2021.72	2023.44	157.0
2010-08-26 20:00:00	NQ	Futures	2023.44	2026.31	2022.87	2026.31	591.0
2010-08-26 21:00:00	NQ	Futures	2026.31	2027.45	2020.29	2022.3	431.0
2010-08-26 22:00:00	NQ	Futures	2022.87	2022.87	2021.15	2021.44	154.0
2010-08-26 23:00:00	NQ	Futures	2021.15	2026.88	2021.15	2026.88	227.0
2010-08-26 00:00:00	YM	Futures	9527.6	9531.4	9524.8	9524.8	175.0
2010-08-26 01:00:00	YM	Futures	9523.8	9528.5	9519.1	9520.0	132.0

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

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