PREVIEW / futures_1hour / 2010-07-08

all futures 1-hour files

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

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-07-08 00:00:00	ES	Futures	1039.67	1040.65	1038.2	1038.45	3440.0
2010-07-08 01:00:00	ES	Futures	1038.45	1040.16	1037.22	1037.71	8604.0
2010-07-08 02:00:00	ES	Futures	1037.46	1038.94	1036.73	1037.22	18088.0
2010-07-08 03:00:00	ES	Futures	1037.22	1038.2	1036.24	1036.97	30154.0
2010-07-08 04:00:00	ES	Futures	1036.97	1037.96	1035.99	1036.24	21416.0
2010-07-08 05:00:00	ES	Futures	1036.48	1038.69	1035.5	1036.97	28772.0
2010-07-08 06:00:00	ES	Futures	1036.97	1039.43	1036.73	1038.94	15947.0
2010-07-08 07:00:00	ES	Futures	1038.94	1039.43	1036.97	1038.2	11982.0
2010-07-08 08:00:00	ES	Futures	1038.2	1045.56	1037.96	1044.09	107206.0
2010-07-08 09:00:00	ES	Futures	1044.09	1048.02	1040.9	1042.86	309126.0
2010-07-08 10:00:00	ES	Futures	1042.86	1044.83	1039.67	1040.41	317560.0
2010-07-08 11:00:00	ES	Futures	1040.41	1041.39	1035.75	1036.97	275348.0
2010-07-08 12:00:00	ES	Futures	1037.22	1040.16	1036.24	1037.71	142979.0
2010-07-08 13:00:00	ES	Futures	1037.96	1042.37	1037.71	1038.69	128379.0
2010-07-08 14:00:00	ES	Futures	1038.94	1040.9	1034.52	1039.67	177301.0
2010-07-08 15:00:00	ES	Futures	1039.92	1046.79	1037.22	1046.54	343476.0
2010-07-08 16:00:00	ES	Futures	1046.79	1048.75	1046.3	1046.79	112415.0
2010-07-08 17:00:00	ES	Futures	1046.79	1047.28	1045.81	1047.28	2258.0
2010-07-08 18:00:00	ES	Futures	1047.03	1047.28	1045.56	1046.05	2645.0
2010-07-08 19:00:00	ES	Futures	1046.05	1046.79	1044.58	1045.56	3166.0
2010-07-08 20:00:00	ES	Futures	1045.56	1045.81	1044.58	1044.58	5440.0
2010-07-08 21:00:00	ES	Futures	1044.58	1046.3	1044.58	1045.81	4116.0
2010-07-08 22:00:00	ES	Futures	1045.81	1048.02	1045.32	1047.77	4055.0
2010-07-08 23:00:00	ES	Futures	1047.53	1048.26	1046.54	1048.02	3870.0
2010-07-08 00:00:00	NQ	Futures	2051.53	2052.67	2048.95	2049.52	351.0
2010-07-08 01:00:00	NQ	Futures	2049.52	2050.67	2047.23	2048.37	632.0
2010-07-08 02:00:00	NQ	Futures	2048.37	2050.09	2046.65	2046.65	1582.0
2010-07-08 03:00:00	NQ	Futures	2046.65	2048.09	2044.94	2045.79	1840.0
2010-07-08 04:00:00	NQ	Futures	2046.08	2047.23	2042.93	2043.79	1792.0
2010-07-08 05:00:00	NQ	Futures	2044.08	2047.8	2043.22	2044.94	1474.0
2010-07-08 06:00:00	NQ	Futures	2045.22	2048.95	2044.65	2048.37	1155.0
2010-07-08 07:00:00	NQ	Futures	2048.66	2049.23	2044.94	2048.09	1190.0
2010-07-08 08:00:00	NQ	Futures	2048.09	2061.27	2047.23	2059.84	12418.0
2010-07-08 09:00:00	NQ	Futures	2059.84	2067.0	2052.39	2057.83	65461.0
2010-07-08 10:00:00	NQ	Futures	2057.54	2064.42	2052.67	2055.54	46142.0
2010-07-08 11:00:00	NQ	Futures	2055.54	2056.11	2035.77	2039.49	40248.0
2010-07-08 12:00:00	NQ	Futures	2039.78	2048.09	2037.77	2039.49	24244.0
2010-07-08 13:00:00	NQ	Futures	2039.49	2050.38	2038.92	2043.5	21973.0
2010-07-08 14:00:00	NQ	Futures	2043.5	2048.09	2034.05	2045.51	24422.0
2010-07-08 15:00:00	NQ	Futures	2045.51	2060.12	2039.78	2057.54	51355.0
2010-07-08 16:00:00	NQ	Futures	2057.54	2062.42	2057.26	2058.69	10296.0
2010-07-08 17:00:00	NQ	Futures	2058.69	2059.26	2056.97	2057.54	177.0
2010-07-08 18:00:00	NQ	Futures	2058.12	2058.12	2055.25	2056.68	127.0
2010-07-08 19:00:00	NQ	Futures	2056.68	2057.26	2054.39	2055.25	155.0
2010-07-08 20:00:00	NQ	Futures	2055.54	2056.4	2054.11	2054.11	345.0
2010-07-08 21:00:00	NQ	Futures	2054.39	2058.12	2054.11	2056.97	326.0
2010-07-08 22:00:00	NQ	Futures	2056.97	2060.41	2054.39	2060.12	299.0
2010-07-08 23:00:00	NQ	Futures	2060.12	2060.98	2058.4	2060.12	275.0
2010-07-08 00:00:00	YM	Futures	9447.1	9450.9	9432.9	9435.8	349.0
2010-07-08 01:00:00	YM	Futures	9436.7	9445.2	9425.4	9432.0	542.0

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

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