PREVIEW / futures_1hour / 2009-12-02

all futures 1-hour files

  file:    by_date/futures_1hour/2009/2009-12-02.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
2009-12-02 00:00:00	ES	Futures	1073.77	1074.5	1073.04	1074.25	2143.0
2009-12-02 01:00:00	ES	Futures	1074.25	1074.5	1073.77	1074.25	1590.0
2009-12-02 02:00:00	ES	Futures	1074.25	1074.5	1072.32	1073.53	9600.0
2009-12-02 03:00:00	ES	Futures	1073.53	1076.43	1072.56	1073.53	27762.0
2009-12-02 04:00:00	ES	Futures	1073.28	1074.25	1071.59	1074.01	17544.0
2009-12-02 05:00:00	ES	Futures	1074.01	1075.22	1073.04	1074.01	10395.0
2009-12-02 06:00:00	ES	Futures	1073.77	1074.25	1070.86	1072.56	18939.0
2009-12-02 07:00:00	ES	Futures	1072.8	1074.98	1072.07	1074.74	18744.0
2009-12-02 08:00:00	ES	Futures	1074.74	1076.43	1072.32	1073.04	56483.0
2009-12-02 09:00:00	ES	Futures	1073.04	1076.43	1072.32	1074.74	200362.0
2009-12-02 10:00:00	ES	Futures	1074.98	1080.79	1074.74	1077.89	351665.0
2009-12-02 11:00:00	ES	Futures	1077.89	1078.13	1072.8	1074.25	228078.0
2009-12-02 12:00:00	ES	Futures	1074.25	1074.98	1069.89	1072.56	154281.0
2009-12-02 13:00:00	ES	Futures	1072.32	1073.53	1071.35	1072.8	84115.0
2009-12-02 14:00:00	ES	Futures	1073.04	1074.25	1070.62	1072.56	171568.0
2009-12-02 15:00:00	ES	Futures	1072.32	1075.22	1071.59	1073.53	221494.0
2009-12-02 16:00:00	ES	Futures	1073.77	1074.01	1073.04	1073.28	62513.0
2009-12-02 17:00:00	ES	Futures	1073.28	1074.25	1071.59	1073.28	7385.0
2009-12-02 18:00:00	ES	Futures	1074.25	1076.92	1074.25	1076.19	12585.0
2009-12-02 19:00:00	ES	Futures	1076.19	1076.43	1074.5	1075.46	8772.0
2009-12-02 20:00:00	ES	Futures	1075.71	1076.43	1075.22	1075.46	5431.0
2009-12-02 21:00:00	ES	Futures	1075.71	1076.68	1074.98	1076.43	5754.0
2009-12-02 22:00:00	ES	Futures	1076.68	1076.92	1075.95	1076.43	4049.0
2009-12-02 23:00:00	ES	Futures	1076.68	1078.13	1075.71	1077.89	6295.0
2009-12-02 00:00:00	NQ	Futures	2041.99	2043.42	2041.7	2043.42	78.0
2009-12-02 01:00:00	NQ	Futures	2043.13	2043.42	2042.28	2043.13	203.0
2009-12-02 02:00:00	NQ	Futures	2043.13	2043.7	2039.42	2041.99	865.0
2009-12-02 03:00:00	NQ	Futures	2041.7	2047.98	2040.56	2041.42	2935.0
2009-12-02 04:00:00	NQ	Futures	2041.42	2043.7	2038.57	2043.42	1532.0
2009-12-02 05:00:00	NQ	Futures	2043.13	2045.98	2041.13	2043.42	677.0
2009-12-02 06:00:00	NQ	Futures	2043.42	2043.7	2037.71	2041.42	1822.0
2009-12-02 07:00:00	NQ	Futures	2041.7	2045.13	2040.85	2043.42	2499.0
2009-12-02 08:00:00	NQ	Futures	2043.99	2046.55	2040.85	2041.99	4346.0
2009-12-02 09:00:00	NQ	Futures	2042.28	2052.54	2041.42	2049.41	34595.0
2009-12-02 10:00:00	NQ	Futures	2049.41	2060.81	2048.83	2057.96	46278.0
2009-12-02 11:00:00	NQ	Futures	2057.96	2058.25	2047.12	2048.26	32379.0
2009-12-02 12:00:00	NQ	Futures	2048.55	2049.69	2038.28	2043.7	27091.0
2009-12-02 13:00:00	NQ	Futures	2043.7	2045.41	2039.71	2043.99	15819.0
2009-12-02 14:00:00	NQ	Futures	2043.99	2046.55	2037.43	2042.85	28187.0
2009-12-02 15:00:00	NQ	Futures	2042.85	2045.13	2039.14	2041.7	35948.0
2009-12-02 16:00:00	NQ	Futures	2041.7	2044.56	2040.85	2043.99	8304.0
2009-12-02 17:00:00	NQ	Futures	2043.99	2044.84	2040.85	2044.27	834.0
2009-12-02 18:00:00	NQ	Futures	2044.84	2050.26	2044.84	2048.55	986.0
2009-12-02 19:00:00	NQ	Futures	2048.83	2049.41	2046.27	2047.98	394.0
2009-12-02 20:00:00	NQ	Futures	2048.55	2049.69	2047.41	2048.26	305.0
2009-12-02 21:00:00	NQ	Futures	2048.26	2049.98	2046.84	2049.41	236.0
2009-12-02 22:00:00	NQ	Futures	2049.69	2050.83	2049.12	2050.26	204.0
2009-12-02 23:00:00	NQ	Futures	2049.69	2052.54	2048.83	2051.97	286.0
2009-12-02 00:00:00	YM	Futures	9729.7	9736.2	9727.9	9736.2	192.0
2009-12-02 01:00:00	YM	Futures	9734.4	9736.2	9729.7	9736.2	233.0

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

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