PREVIEW / futures_1hour / 2010-09-01

all futures 1-hour files

  file:    by_date/futures_1hour/2010/2010-09-01.parquet
  size:    46 KB
  rows:    1,364

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-09-01 00:00:00	ES	Futures	1037.96	1038.45	1036.48	1037.46	3670.0
2010-09-01 01:00:00	ES	Futures	1037.46	1037.46	1036.48	1036.97	3107.0
2010-09-01 02:00:00	ES	Futures	1036.73	1038.2	1035.75	1036.48	8906.0
2010-09-01 03:00:00	ES	Futures	1036.48	1036.73	1031.33	1033.29	35985.0
2010-09-01 04:00:00	ES	Futures	1033.29	1038.94	1033.05	1038.69	32263.0
2010-09-01 05:00:00	ES	Futures	1038.69	1043.11	1037.46	1040.65	52620.0
2010-09-01 06:00:00	ES	Futures	1040.65	1042.13	1039.92	1041.39	16988.0
2010-09-01 07:00:00	ES	Futures	1041.39	1041.64	1039.67	1040.41	27701.0
2010-09-01 08:00:00	ES	Futures	1040.41	1042.62	1037.96	1041.39	93496.0
2010-09-01 09:00:00	ES	Futures	1041.39	1047.28	1041.15	1046.05	316034.0
2010-09-01 10:00:00	ES	Futures	1046.05	1058.57	1043.84	1057.09	641481.0
2010-09-01 11:00:00	ES	Futures	1057.34	1059.55	1056.11	1058.08	191089.0
2010-09-01 12:00:00	ES	Futures	1057.83	1058.57	1055.87	1056.6	113690.0
2010-09-01 13:00:00	ES	Futures	1056.85	1059.06	1056.36	1058.32	90631.0
2010-09-01 14:00:00	ES	Futures	1058.08	1059.06	1055.38	1056.36	144127.0
2010-09-01 15:00:00	ES	Futures	1056.11	1060.78	1055.13	1059.3	357579.0
2010-09-01 16:00:00	ES	Futures	1059.06	1062.49	1058.81	1061.02	169487.0
2010-09-01 17:00:00	ES	Futures	1061.02	1061.76	1060.28	1060.28	2636.0
2010-09-01 18:00:00	ES	Futures	1060.28	1061.27	1060.04	1060.28	2832.0
2010-09-01 19:00:00	ES	Futures	1060.53	1062.25	1060.04	1061.02	4512.0
2010-09-01 20:00:00	ES	Futures	1061.27	1061.51	1058.32	1058.57	9773.0
2010-09-01 21:00:00	ES	Futures	1058.57	1059.06	1058.08	1058.81	4022.0
2010-09-01 22:00:00	ES	Futures	1058.81	1059.3	1058.08	1058.32	3438.0
2010-09-01 23:00:00	ES	Futures	1058.32	1058.57	1056.6	1056.85	5514.0
2010-09-01 00:00:00	NQ	Futures	2046.37	2046.65	2042.93	2044.65	240.0
2010-09-01 01:00:00	NQ	Futures	2044.36	2044.65	2042.07	2042.93	369.0
2010-09-01 02:00:00	NQ	Futures	2042.93	2045.22	2040.64	2042.36	582.0
2010-09-01 03:00:00	NQ	Futures	2042.07	2042.64	2032.61	2036.62	1687.0
2010-09-01 04:00:00	NQ	Futures	2036.62	2048.09	2036.62	2047.8	1657.0
2010-09-01 05:00:00	NQ	Futures	2047.8	2056.97	2046.08	2053.25	3667.0
2010-09-01 06:00:00	NQ	Futures	2053.25	2054.96	2050.67	2052.67	1630.0
2010-09-01 07:00:00	NQ	Futures	2052.96	2053.53	2049.81	2051.81	1959.0
2010-09-01 08:00:00	NQ	Futures	2051.81	2055.82	2047.8	2053.53	7608.0
2010-09-01 09:00:00	NQ	Futures	2053.53	2070.73	2052.67	2062.99	63670.0
2010-09-01 10:00:00	NQ	Futures	2062.7	2091.93	2057.54	2088.21	112022.0
2010-09-01 11:00:00	NQ	Futures	2087.92	2091.93	2087.06	2088.21	38008.0
2010-09-01 12:00:00	NQ	Futures	2088.49	2089.35	2083.62	2084.19	24745.0
2010-09-01 13:00:00	NQ	Futures	2084.19	2087.92	2081.9	2085.34	22198.0
2010-09-01 14:00:00	NQ	Futures	2085.63	2087.06	2078.18	2080.18	29178.0
2010-09-01 15:00:00	NQ	Futures	2080.47	2088.21	2077.32	2085.05	59745.0
2010-09-01 16:00:00	NQ	Futures	2085.05	2090.21	2084.48	2086.2	14193.0
2010-09-01 17:00:00	NQ	Futures	2086.2	2087.06	2085.05	2085.05	127.0
2010-09-01 18:00:00	NQ	Futures	2085.63	2087.35	2084.77	2086.2	151.0
2010-09-01 19:00:00	NQ	Futures	2085.91	2088.21	2085.34	2086.77	293.0
2010-09-01 20:00:00	NQ	Futures	2087.35	2087.35	2081.62	2081.9	324.0
2010-09-01 21:00:00	NQ	Futures	2081.9	2083.05	2080.76	2082.19	195.0
2010-09-01 22:00:00	NQ	Futures	2082.19	2082.76	2079.9	2080.47	324.0
2010-09-01 23:00:00	NQ	Futures	2081.04	2081.04	2078.46	2079.04	424.0
2010-09-01 00:00:00	YM	Futures	9540.8	9542.7	9528.5	9537.1	219.0
2010-09-01 01:00:00	YM	Futures	9536.1	9537.1	9527.6	9531.4	170.0

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

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