PREVIEW / futures_1hour / 2008-01-25

all futures 1-hour files

  file:    by_date/futures_1hour/2008/2008-01-25.parquet
  size:    27 KB
  rows:    630

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-01-25 00:00:00	ES	Futures	1263.94	1270.7	1263.71	1270.23	4484.0
2008-01-25 01:00:00	ES	Futures	1270.47	1271.17	1268.6	1270.93	2764.0
2008-01-25 02:00:00	ES	Futures	1271.17	1273.27	1268.14	1271.63	13525.0
2008-01-25 03:00:00	ES	Futures	1271.63	1274.9	1271.63	1274.2	27717.0
2008-01-25 04:00:00	ES	Futures	1273.97	1274.2	1265.11	1269.07	31989.0
2008-01-25 05:00:00	ES	Futures	1269.3	1271.4	1266.27	1268.84	12524.0
2008-01-25 06:00:00	ES	Futures	1268.84	1272.8	1266.5	1270.23	15363.0
2008-01-25 07:00:00	ES	Futures	1270.0	1271.17	1267.2	1270.7	18770.0
2008-01-25 08:00:00	ES	Futures	1270.7	1273.5	1269.07	1273.03	42401.0
2008-01-25 09:00:00	ES	Futures	1272.8	1278.4	1270.7	1271.87	259636.0
2008-01-25 10:00:00	ES	Futures	1271.87	1273.03	1259.04	1259.98	451317.0
2008-01-25 11:00:00	ES	Futures	1259.98	1265.34	1256.01	1264.17	291468.0
2008-01-25 12:00:00	ES	Futures	1264.17	1264.87	1249.95	1252.05	211590.0
2008-01-25 13:00:00	ES	Futures	1251.82	1255.08	1238.76	1242.72	353601.0
2008-01-25 14:00:00	ES	Futures	1242.72	1248.09	1239.46	1243.66	261966.0
2008-01-25 15:00:00	ES	Futures	1243.42	1252.51	1238.99	1242.72	387976.0
2008-01-25 16:00:00	ES	Futures	1242.72	1245.52	1241.79	1243.89	82299.0
2008-01-25 00:00:00	NQ	Futures	2101.01	2108.11	2101.01	2107.82	343.0
2008-01-25 01:00:00	NQ	Futures	2107.82	2107.82	2104.7	2107.26	86.0
2008-01-25 02:00:00	NQ	Futures	2107.82	2109.81	2103.0	2106.4	524.0
2008-01-25 03:00:00	NQ	Futures	2106.97	2111.8	2104.98	2104.98	2299.0
2008-01-25 04:00:00	NQ	Futures	2105.27	2107.54	2097.6	2106.4	4858.0
2008-01-25 05:00:00	NQ	Futures	2106.4	2112.65	2104.42	2107.26	1208.0
2008-01-25 06:00:00	NQ	Futures	2106.69	2113.22	2104.98	2107.82	1117.0
2008-01-25 07:00:00	NQ	Futures	2108.11	2110.95	2104.7	2109.81	2058.0
2008-01-25 08:00:00	NQ	Futures	2110.38	2121.45	2109.53	2120.6	7856.0
2008-01-25 09:00:00	NQ	Futures	2120.6	2127.12	2100.44	2102.43	64257.0
2008-01-25 10:00:00	NQ	Futures	2102.71	2103.0	2072.34	2076.6	99171.0
2008-01-25 11:00:00	NQ	Futures	2076.6	2083.41	2066.38	2081.43	67146.0
2008-01-25 12:00:00	NQ	Futures	2081.43	2084.26	2059.57	2061.84	44287.0
2008-01-25 13:00:00	NQ	Futures	2061.84	2066.1	2043.96	2047.65	70033.0
2008-01-25 14:00:00	NQ	Futures	2047.65	2057.87	2040.27	2046.23	54384.0
2008-01-25 15:00:00	NQ	Futures	2045.95	2060.14	2036.29	2038.57	72924.0
2008-01-25 16:00:00	NQ	Futures	2038.85	2039.13	2033.46	2033.46	16146.0
2008-01-25 00:00:00	YM	Futures	11261.7	11302.6	11257.2	11302.6	340.0
2008-01-25 01:00:00	YM	Futures	11300.8	11310.8	11295.4	11309.9	254.0
2008-01-25 02:00:00	YM	Futures	11308.1	11319.9	11284.5	11307.2	611.0
2008-01-25 03:00:00	YM	Futures	11309.9	11331.7	11309.9	11323.5	1122.0
2008-01-25 04:00:00	YM	Futures	11315.3	11329.9	11265.4	11292.6	973.0
2008-01-25 05:00:00	YM	Futures	11292.6	11309.9	11277.2	11294.4	449.0
2008-01-25 06:00:00	YM	Futures	11289.0	11317.2	11277.2	11298.1	861.0
2008-01-25 07:00:00	YM	Futures	11297.2	11304.4	11279.0	11300.8	550.0
2008-01-25 08:00:00	YM	Futures	11299.9	11318.1	11289.0	11312.6	2581.0
2008-01-25 09:00:00	YM	Futures	11315.3	11347.1	11299.9	11309.9	19660.0
2008-01-25 10:00:00	YM	Futures	11309.0	11321.7	11222.7	11231.8	35128.0
2008-01-25 11:00:00	YM	Futures	11231.8	11272.6	11197.2	11266.3	25058.0
2008-01-25 12:00:00	YM	Futures	11266.3	11273.6	11157.3	11170.0	20163.0
2008-01-25 13:00:00	YM	Futures	11170.9	11196.3	11083.7	11108.2	29683.0
2008-01-25 14:00:00	YM	Futures	11107.3	11138.2	11076.4	11107.3	25796.0
2008-01-25 15:00:00	YM	Futures	11106.4	11182.7	11074.6	11088.2	33123.0

> showing 50 of 630 rows — these rows as CSV

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