PREVIEW / futures_1hour / 2008-06-19

all futures 1-hour files

  file:    by_date/futures_1hour/2008/2008-06-19.parquet
  size:    43 KB
  rows:    1,235

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-06-19 00:00:00	ES	Futures	1243.65	1244.12	1242.49	1242.96	1154.0
2008-06-19 01:00:00	ES	Futures	1242.96	1243.89	1242.03	1243.42	1944.0
2008-06-19 02:00:00	ES	Futures	1243.89	1244.12	1241.1	1242.49	4671.0
2008-06-19 03:00:00	ES	Futures	1242.49	1245.05	1240.17	1241.8	18399.0
2008-06-19 04:00:00	ES	Futures	1241.8	1246.68	1241.33	1245.51	12539.0
2008-06-19 05:00:00	ES	Futures	1245.51	1246.91	1244.35	1245.98	10155.0
2008-06-19 06:00:00	ES	Futures	1245.98	1246.21	1244.12	1245.05	6992.0
2008-06-19 07:00:00	ES	Futures	1244.82	1248.54	1244.58	1248.3	22184.0
2008-06-19 08:00:00	ES	Futures	1248.07	1249.0	1245.28	1245.98	36215.0
2008-06-19 09:00:00	ES	Futures	1245.98	1249.46	1241.56	1243.89	259970.0
2008-06-19 10:00:00	ES	Futures	1244.12	1247.14	1238.77	1246.44	395254.0
2008-06-19 11:00:00	ES	Futures	1246.44	1248.54	1238.54	1241.33	346480.0
2008-06-19 12:00:00	ES	Futures	1241.33	1248.54	1240.87	1245.28	260764.0
2008-06-19 13:00:00	ES	Futures	1245.05	1248.54	1242.96	1245.05	142098.0
2008-06-19 14:00:00	ES	Futures	1245.05	1252.72	1242.96	1251.79	244195.0
2008-06-19 15:00:00	ES	Futures	1252.02	1254.81	1249.0	1249.93	282085.0
2008-06-19 16:00:00	ES	Futures	1249.93	1250.16	1246.91	1248.07	80573.0
2008-06-19 17:00:00	ES	Futures	1248.07	1249.0	1247.84	1249.0	2208.0
2008-06-19 18:00:00	ES	Futures	1248.54	1248.77	1246.68	1247.14	4892.0
2008-06-19 19:00:00	ES	Futures	1246.91	1247.14	1243.89	1244.58	4510.0
2008-06-19 20:00:00	ES	Futures	1244.58	1244.82	1244.12	1244.58	1302.0
2008-06-19 21:00:00	ES	Futures	1244.58	1244.82	1243.19	1244.58	3600.0
2008-06-19 22:00:00	ES	Futures	1244.58	1246.68	1244.35	1246.21	2655.0
2008-06-19 23:00:00	ES	Futures	1246.21	1246.44	1244.58	1244.82	1822.0
2008-06-19 00:00:00	NQ	Futures	2199.68	2199.68	2195.18	2199.12	353.0
2008-06-19 01:00:00	NQ	Futures	2199.12	2201.08	2198.27	2199.68	136.0
2008-06-19 02:00:00	NQ	Futures	2201.08	2201.08	2196.58	2198.83	517.0
2008-06-19 03:00:00	NQ	Futures	2198.83	2203.62	2195.18	2197.43	1713.0
2008-06-19 04:00:00	NQ	Futures	2196.87	2205.3	2196.02	2203.9	1401.0
2008-06-19 05:00:00	NQ	Futures	2203.9	2206.43	2201.37	2205.02	990.0
2008-06-19 06:00:00	NQ	Futures	2205.3	2205.3	2201.93	2203.05	452.0
2008-06-19 07:00:00	NQ	Futures	2202.77	2208.68	2202.77	2208.12	1353.0
2008-06-19 08:00:00	NQ	Futures	2208.12	2210.09	2201.93	2202.49	4009.0
2008-06-19 09:00:00	NQ	Futures	2203.05	2212.9	2197.99	2204.74	43859.0
2008-06-19 10:00:00	NQ	Futures	2204.46	2212.62	2186.46	2210.37	86017.0
2008-06-19 11:00:00	NQ	Futures	2210.37	2216.84	2197.15	2211.77	62500.0
2008-06-19 12:00:00	NQ	Futures	2211.77	2235.68	2211.49	2225.84	95489.0
2008-06-19 13:00:00	NQ	Futures	2225.84	2234.56	2222.18	2227.24	39062.0
2008-06-19 14:00:00	NQ	Futures	2227.24	2251.44	2222.46	2246.37	87108.0
2008-06-19 15:00:00	NQ	Futures	2246.93	2252.28	2238.21	2241.59	74524.0
2008-06-19 16:00:00	NQ	Futures	2241.59	2243.56	2238.78	2242.15	15497.0
2008-06-19 17:00:00	NQ	Futures	2241.87	2243.56	2241.87	2243.0	183.0
2008-06-19 18:00:00	NQ	Futures	2243.28	2243.28	2238.78	2239.62	854.0
2008-06-19 19:00:00	NQ	Futures	2239.34	2240.18	2234.84	2236.81	245.0
2008-06-19 20:00:00	NQ	Futures	2236.81	2237.09	2235.96	2235.96	31.0
2008-06-19 21:00:00	NQ	Futures	2235.96	2236.81	2233.71	2236.81	214.0
2008-06-19 22:00:00	NQ	Futures	2236.53	2238.78	2235.96	2238.21	188.0
2008-06-19 23:00:00	NQ	Futures	2238.21	2238.78	2235.96	2236.81	172.0
2008-06-19 00:00:00	YM	Futures	10927.4	10927.4	10918.3	10920.1	101.0
2008-06-19 01:00:00	YM	Futures	10920.1	10926.5	10914.7	10923.8	224.0

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

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