PREVIEW / futures_1hour / 2008-07-03

all futures 1-hour files

  file:    by_date/futures_1hour/2008/2008-07-03.parquet
  size:    40 KB
  rows:    1,126

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
2008-07-03 00:00:00	ES	Futures	1174.63	1178.35	1174.39	1177.65	4559.0
2008-07-03 01:00:00	ES	Futures	1177.88	1178.58	1177.18	1177.65	1651.0
2008-07-03 02:00:00	ES	Futures	1177.65	1178.35	1173.23	1174.16	7438.0
2008-07-03 03:00:00	ES	Futures	1173.93	1176.02	1172.3	1175.09	16337.0
2008-07-03 04:00:00	ES	Futures	1175.32	1178.81	1175.09	1176.02	17418.0
2008-07-03 05:00:00	ES	Futures	1176.25	1179.28	1174.39	1174.86	16037.0
2008-07-03 06:00:00	ES	Futures	1174.63	1175.32	1173.7	1173.7	9463.0
2008-07-03 07:00:00	ES	Futures	1173.93	1176.95	1171.14	1174.63	37075.0
2008-07-03 08:00:00	ES	Futures	1174.63	1182.99	1171.84	1182.06	151160.0
2008-07-03 09:00:00	ES	Futures	1182.06	1184.16	1167.42	1172.54	417274.0
2008-07-03 10:00:00	ES	Futures	1172.54	1181.37	1163.7	1178.11	544536.0
2008-07-03 11:00:00	ES	Futures	1178.35	1183.23	1177.42	1179.28	285520.0
2008-07-03 12:00:00	ES	Futures	1179.04	1179.51	1172.77	1174.63	261066.0
2008-07-03 13:00:00	ES	Futures	1174.39	1176.49	1173.93	1176.49	51697.0
2008-07-03 16:00:00	ES	Futures	1176.49	1177.88	1172.77	1175.09	2236.0
2008-07-03 17:00:00	ES	Futures	1174.86	1178.35	1174.39	1176.72	692.0
2008-07-03 18:00:00	ES	Futures	1176.25	1179.04	1176.25	1177.18	700.0
2008-07-03 19:00:00	ES	Futures	1176.95	1176.95	1176.02	1176.25	896.0
2008-07-03 20:00:00	ES	Futures	1176.02	1177.88	1175.79	1176.02	474.0
2008-07-03 21:00:00	ES	Futures	1176.02	1176.72	1176.02	1176.25	270.0
2008-07-03 22:00:00	ES	Futures	1176.02	1176.72	1175.79	1176.49	307.0
2008-07-03 23:00:00	ES	Futures	1176.49	1176.95	1175.79	1176.25	534.0
2008-07-03 00:00:00	NQ	Futures	2044.69	2051.44	2044.69	2049.75	306.0
2008-07-03 01:00:00	NQ	Futures	2050.6	2052.85	2050.03	2052.0	296.0
2008-07-03 02:00:00	NQ	Futures	2052.56	2053.13	2043.28	2046.66	807.0
2008-07-03 03:00:00	NQ	Futures	2046.66	2050.31	2042.72	2045.81	1437.0
2008-07-03 04:00:00	NQ	Futures	2046.38	2053.69	2046.09	2050.31	2180.0
2008-07-03 05:00:00	NQ	Futures	2050.31	2055.94	2045.81	2047.22	1182.0
2008-07-03 06:00:00	NQ	Futures	2047.22	2048.06	2044.13	2045.25	917.0
2008-07-03 07:00:00	NQ	Futures	2044.97	2049.75	2039.34	2044.69	4070.0
2008-07-03 08:00:00	NQ	Futures	2044.69	2062.69	2036.53	2059.6	22669.0
2008-07-03 09:00:00	NQ	Futures	2059.88	2065.22	2037.94	2048.34	73759.0
2008-07-03 10:00:00	NQ	Futures	2048.63	2069.16	2032.31	2060.72	99440.0
2008-07-03 11:00:00	NQ	Futures	2061.0	2068.04	2057.35	2059.88	44039.0
2008-07-03 12:00:00	NQ	Futures	2059.88	2060.44	2045.53	2050.03	61485.0
2008-07-03 13:00:00	NQ	Futures	2050.03	2052.85	2048.06	2050.03	8604.0
2008-07-03 16:00:00	NQ	Futures	2050.03	2052.85	2047.22	2051.72	67.0
2008-07-03 17:00:00	NQ	Futures	2051.16	2053.97	2050.03	2053.69	87.0
2008-07-03 18:00:00	NQ	Futures	2053.69	2057.35	2051.72	2053.13	81.0
2008-07-03 19:00:00	NQ	Futures	2053.41	2054.25	2051.44	2053.13	26.0
2008-07-03 20:00:00	NQ	Futures	2051.72	2052.56	2050.31	2050.6	14.0
2008-07-03 21:00:00	NQ	Futures	2050.03	2052.28	2050.03	2050.31	7.0
2008-07-03 22:00:00	NQ	Futures	2051.44	2051.44	2051.16	2051.16	2.0
2008-07-03 23:00:00	NQ	Futures	2051.16	2052.85	2048.91	2049.47	43.0
2008-07-03 00:00:00	YM	Futures	10188.5	10215.7	10188.5	10211.2	227.0
2008-07-03 01:00:00	YM	Futures	10213.9	10213.9	10202.1	10205.7	146.0
2008-07-03 02:00:00	YM	Futures	10208.5	10210.3	10176.7	10181.2	470.0
2008-07-03 03:00:00	YM	Futures	10183.0	10196.7	10170.3	10186.7	979.0
2008-07-03 04:00:00	YM	Futures	10188.5	10214.8	10188.5	10197.6	1415.0
2008-07-03 05:00:00	YM	Futures	10198.5	10220.3	10181.2	10187.6	936.0

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

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