PREVIEW / futures_1hour / 2008-04-23

all futures 1-hour files

  file:    by_date/futures_1hour/2008/2008-04-23.parquet
  size:    42 KB
  rows:    1,215

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-04-23 00:00:00	ES	Futures	1288.79	1289.26	1288.32	1288.56	639.0
2008-04-23 01:00:00	ES	Futures	1288.79	1289.26	1286.46	1286.93	2307.0
2008-04-23 02:00:00	ES	Futures	1286.93	1288.56	1286.46	1288.56	4718.0
2008-04-23 03:00:00	ES	Futures	1288.56	1291.58	1288.32	1290.42	12111.0
2008-04-23 04:00:00	ES	Futures	1290.42	1291.35	1288.79	1289.26	8173.0
2008-04-23 05:00:00	ES	Futures	1289.26	1289.72	1287.63	1288.56	8926.0
2008-04-23 06:00:00	ES	Futures	1288.56	1288.79	1282.97	1283.67	26813.0
2008-04-23 07:00:00	ES	Futures	1283.67	1283.9	1279.24	1283.2	57526.0
2008-04-23 08:00:00	ES	Futures	1283.2	1286.0	1282.74	1284.83	39340.0
2008-04-23 09:00:00	ES	Futures	1284.83	1288.32	1281.57	1282.97	204188.0
2008-04-23 10:00:00	ES	Futures	1283.2	1294.38	1281.34	1291.12	409792.0
2008-04-23 11:00:00	ES	Futures	1290.89	1292.52	1287.63	1288.56	223396.0
2008-04-23 12:00:00	ES	Futures	1288.79	1288.79	1278.54	1281.57	237899.0
2008-04-23 13:00:00	ES	Futures	1281.34	1285.06	1280.17	1284.37	163735.0
2008-04-23 14:00:00	ES	Futures	1284.6	1286.23	1282.5	1283.43	125087.0
2008-04-23 15:00:00	ES	Futures	1283.43	1288.56	1283.2	1286.69	223816.0
2008-04-23 16:00:00	ES	Futures	1286.69	1288.09	1278.78	1279.94	91843.0
2008-04-23 17:00:00	ES	Futures	1280.17	1281.34	1277.61	1280.87	6822.0
2008-04-23 18:00:00	ES	Futures	1281.8	1282.27	1281.11	1281.57	2301.0
2008-04-23 19:00:00	ES	Futures	1281.57	1281.57	1279.71	1280.17	1115.0
2008-04-23 20:00:00	ES	Futures	1280.17	1280.17	1277.85	1278.08	2055.0
2008-04-23 21:00:00	ES	Futures	1278.08	1281.11	1277.38	1280.64	3268.0
2008-04-23 22:00:00	ES	Futures	1280.64	1283.2	1280.64	1282.27	3557.0
2008-04-23 23:00:00	ES	Futures	1282.04	1282.27	1279.71	1279.94	1625.0
2008-04-23 00:00:00	NQ	Futures	2149.5	2150.35	2148.08	2150.35	107.0
2008-04-23 01:00:00	NQ	Futures	2150.63	2150.63	2148.08	2148.37	88.0
2008-04-23 02:00:00	NQ	Futures	2148.37	2149.5	2146.95	2148.08	304.0
2008-04-23 03:00:00	NQ	Futures	2149.21	2154.02	2149.21	2151.48	865.0
2008-04-23 04:00:00	NQ	Futures	2151.48	2152.61	2148.37	2148.65	807.0
2008-04-23 05:00:00	NQ	Futures	2149.21	2150.35	2147.8	2148.93	381.0
2008-04-23 06:00:00	NQ	Futures	2148.37	2150.91	2141.01	2142.43	2034.0
2008-04-23 07:00:00	NQ	Futures	2142.14	2149.78	2137.05	2146.67	5197.0
2008-04-23 08:00:00	NQ	Futures	2146.95	2151.76	2146.1	2150.06	2678.0
2008-04-23 09:00:00	NQ	Futures	2150.06	2157.42	2142.14	2150.35	34072.0
2008-04-23 10:00:00	NQ	Futures	2150.91	2171.28	2147.23	2167.03	64491.0
2008-04-23 11:00:00	NQ	Futures	2166.75	2170.99	2163.36	2164.49	31486.0
2008-04-23 12:00:00	NQ	Futures	2164.49	2164.77	2146.67	2150.91	36761.0
2008-04-23 13:00:00	NQ	Futures	2150.91	2160.81	2148.08	2159.11	24442.0
2008-04-23 14:00:00	NQ	Futures	2159.11	2162.79	2156.85	2157.42	25835.0
2008-04-23 15:00:00	NQ	Futures	2157.7	2165.9	2155.72	2161.38	44037.0
2008-04-23 16:00:00	NQ	Futures	2161.38	2170.71	2138.47	2140.73	29853.0
2008-04-23 17:00:00	NQ	Futures	2141.01	2143.56	2134.79	2142.43	2758.0
2008-04-23 18:00:00	NQ	Futures	2143.84	2144.41	2141.3	2143.56	674.0
2008-04-23 19:00:00	NQ	Futures	2142.99	2143.28	2141.01	2141.58	87.0
2008-04-23 20:00:00	NQ	Futures	2140.73	2142.14	2138.47	2138.75	94.0
2008-04-23 21:00:00	NQ	Futures	2139.03	2142.99	2138.47	2142.99	104.0
2008-04-23 22:00:00	NQ	Futures	2142.99	2145.54	2142.14	2144.12	259.0
2008-04-23 23:00:00	NQ	Futures	2144.12	2144.97	2141.58	2142.14	72.0
2008-04-23 00:00:00	YM	Futures	11592.6	11595.3	11589.8	11594.4	44.0
2008-04-23 01:00:00	YM	Futures	11592.6	11594.4	11577.1	11580.8	128.0

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

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