PREVIEW / futures_1hour / 2008-05-23

all futures 1-hour files

  file:    by_date/futures_1hour/2008/2008-05-23.parquet
  size:    36 KB
  rows:    979

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-05-23 00:00:00	ES	Futures	1298.34	1299.27	1298.1	1299.04	859.0
2008-05-23 01:00:00	ES	Futures	1298.8	1298.8	1297.64	1298.1	933.0
2008-05-23 02:00:00	ES	Futures	1298.1	1299.04	1296.94	1297.41	2583.0
2008-05-23 03:00:00	ES	Futures	1297.41	1297.64	1292.05	1293.21	18824.0
2008-05-23 04:00:00	ES	Futures	1293.21	1293.45	1290.42	1292.05	13056.0
2008-05-23 05:00:00	ES	Futures	1292.05	1292.98	1291.12	1292.75	6936.0
2008-05-23 06:00:00	ES	Futures	1292.75	1293.45	1290.65	1291.58	9455.0
2008-05-23 07:00:00	ES	Futures	1291.58	1294.15	1291.12	1294.15	16297.0
2008-05-23 08:00:00	ES	Futures	1293.91	1293.91	1291.58	1292.05	34887.0
2008-05-23 09:00:00	ES	Futures	1292.05	1294.61	1286.93	1288.32	200555.0
2008-05-23 10:00:00	ES	Futures	1288.56	1290.42	1282.97	1285.76	323993.0
2008-05-23 11:00:00	ES	Futures	1285.76	1285.76	1279.71	1283.67	247263.0
2008-05-23 12:00:00	ES	Futures	1283.43	1285.06	1279.01	1279.71	151724.0
2008-05-23 13:00:00	ES	Futures	1279.48	1284.37	1279.24	1280.41	106274.0
2008-05-23 14:00:00	ES	Futures	1280.41	1286.23	1279.71	1283.9	116561.0
2008-05-23 15:00:00	ES	Futures	1284.13	1286.69	1281.11	1281.8	177011.0
2008-05-23 16:00:00	ES	Futures	1282.04	1282.04	1278.54	1279.71	81693.0
2008-05-23 00:00:00	NQ	Futures	2225.86	2227.84	2225.86	2227.28	203.0
2008-05-23 01:00:00	NQ	Futures	2227.28	2227.28	2225.58	2226.43	43.0
2008-05-23 02:00:00	NQ	Futures	2226.71	2228.12	2224.16	2224.16	235.0
2008-05-23 03:00:00	NQ	Futures	2224.45	2224.73	2215.96	2217.94	1242.0
2008-05-23 04:00:00	NQ	Futures	2218.22	2218.51	2212.29	2214.83	1510.0
2008-05-23 05:00:00	NQ	Futures	2214.83	2216.53	2213.42	2216.53	2082.0
2008-05-23 06:00:00	NQ	Futures	2216.81	2218.51	2213.13	2215.11	693.0
2008-05-23 07:00:00	NQ	Futures	2214.55	2222.47	2214.55	2222.18	2070.0
2008-05-23 08:00:00	NQ	Futures	2222.18	2222.75	2216.25	2216.25	3864.0
2008-05-23 09:00:00	NQ	Futures	2216.81	2223.88	2215.68	2217.09	38889.0
2008-05-23 10:00:00	NQ	Futures	2217.38	2226.14	2209.17	2216.25	54240.0
2008-05-23 11:00:00	NQ	Futures	2216.25	2218.22	2201.26	2210.02	51139.0
2008-05-23 12:00:00	NQ	Futures	2210.02	2216.25	2201.54	2203.23	32228.0
2008-05-23 13:00:00	NQ	Futures	2203.23	2215.96	2202.1	2208.89	26077.0
2008-05-23 14:00:00	NQ	Futures	2208.89	2223.32	2207.19	2220.2	27139.0
2008-05-23 15:00:00	NQ	Futures	2219.92	2223.32	2213.7	2219.07	31646.0
2008-05-23 16:00:00	NQ	Futures	2219.36	2220.77	2213.7	2216.81	7589.0
2008-05-23 00:00:00	YM	Futures	11465.4	11472.6	11462.6	11469.0	96.0
2008-05-23 01:00:00	YM	Futures	11467.2	11467.2	11458.1	11464.5	89.0
2008-05-23 02:00:00	YM	Futures	11464.5	11469.9	11455.4	11457.2	158.0
2008-05-23 03:00:00	YM	Futures	11459.0	11459.0	11415.4	11423.6	1146.0
2008-05-23 04:00:00	YM	Futures	11423.6	11424.5	11400.9	11416.3	853.0
2008-05-23 05:00:00	YM	Futures	11417.2	11425.4	11409.0	11422.7	508.0
2008-05-23 06:00:00	YM	Futures	11424.5	11430.8	11409.0	11414.5	578.0
2008-05-23 07:00:00	YM	Futures	11414.5	11429.0	11407.2	11427.2	1217.0
2008-05-23 08:00:00	YM	Futures	11427.2	11427.2	11412.7	11416.3	2366.0
2008-05-23 09:00:00	YM	Futures	11419.0	11435.4	11382.7	11386.3	14499.0
2008-05-23 10:00:00	YM	Futures	11386.3	11406.3	11356.3	11372.7	29639.0
2008-05-23 11:00:00	YM	Futures	11373.6	11377.2	11338.2	11369.0	20432.0
2008-05-23 12:00:00	YM	Futures	11369.0	11380.9	11325.4	11330.9	12552.0
2008-05-23 13:00:00	YM	Futures	11330.9	11364.5	11326.3	11329.1	11278.0
2008-05-23 14:00:00	YM	Futures	11328.2	11375.4	11321.8	11356.3	13174.0
2008-05-23 15:00:00	YM	Futures	11356.3	11375.4	11333.6	11346.3	15426.0

> showing 50 of 979 rows — these rows as CSV

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