PREVIEW / futures_1hour / 2010-04-29

all futures 1-hour files

  file:    by_date/futures_1hour/2010/2010-04-29.parquet
  size:    46 KB
  rows:    1,377

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
2010-04-29 00:00:00	ES	Futures	1162.74	1162.98	1162.25	1162.74	921.0
2010-04-29 01:00:00	ES	Futures	1162.49	1162.98	1162.0	1162.49	2003.0
2010-04-29 02:00:00	ES	Futures	1162.25	1166.4	1161.51	1165.42	15205.0
2010-04-29 03:00:00	ES	Futures	1165.42	1165.91	1162.98	1164.45	46244.0
2010-04-29 04:00:00	ES	Futures	1164.2	1168.11	1163.96	1166.65	37012.0
2010-04-29 05:00:00	ES	Futures	1166.89	1169.09	1165.67	1168.6	26298.0
2010-04-29 06:00:00	ES	Futures	1168.6	1170.8	1168.36	1169.34	35623.0
2010-04-29 07:00:00	ES	Futures	1169.09	1170.31	1168.6	1170.07	27131.0
2010-04-29 08:00:00	ES	Futures	1170.07	1171.78	1169.34	1170.31	73334.0
2010-04-29 09:00:00	ES	Futures	1170.31	1172.76	1169.09	1170.31	280478.0
2010-04-29 10:00:00	ES	Futures	1170.07	1177.65	1169.34	1176.18	338195.0
2010-04-29 11:00:00	ES	Futures	1176.42	1177.65	1173.0	1176.67	243734.0
2010-04-29 12:00:00	ES	Futures	1176.67	1178.87	1175.2	1177.4	151891.0
2010-04-29 13:00:00	ES	Futures	1177.16	1178.62	1176.42	1178.62	94456.0
2010-04-29 14:00:00	ES	Futures	1178.62	1179.36	1175.45	1176.18	167475.0
2010-04-29 15:00:00	ES	Futures	1176.18	1177.65	1174.71	1176.42	266621.0
2010-04-29 16:00:00	ES	Futures	1176.42	1178.87	1175.93	1177.89	143153.0
2010-04-29 17:00:00	ES	Futures	1177.89	1179.11	1177.89	1179.11	2860.0
2010-04-29 18:00:00	ES	Futures	1178.87	1178.87	1178.38	1178.62	2128.0
2010-04-29 19:00:00	ES	Futures	1178.62	1178.62	1175.93	1176.42	7164.0
2010-04-29 20:00:00	ES	Futures	1176.18	1176.67	1175.2	1175.69	6572.0
2010-04-29 21:00:00	ES	Futures	1175.69	1176.42	1174.71	1175.2	4669.0
2010-04-29 22:00:00	ES	Futures	1174.96	1176.18	1174.71	1174.96	4430.0
2010-04-29 23:00:00	ES	Futures	1174.96	1177.65	1174.71	1177.4	6212.0
2010-04-29 00:00:00	NQ	Futures	2297.85	2298.43	2297.57	2298.14	29.0
2010-04-29 01:00:00	NQ	Futures	2297.85	2299.0	2297.28	2297.85	198.0
2010-04-29 02:00:00	NQ	Futures	2297.57	2303.29	2296.42	2302.72	1117.0
2010-04-29 03:00:00	NQ	Futures	2302.44	2302.72	2297.85	2300.43	2465.0
2010-04-29 04:00:00	NQ	Futures	2300.43	2305.3	2299.57	2303.01	2330.0
2010-04-29 05:00:00	NQ	Futures	2303.87	2307.3	2301.29	2306.44	2514.0
2010-04-29 06:00:00	NQ	Futures	2306.73	2309.88	2306.44	2307.88	1871.0
2010-04-29 07:00:00	NQ	Futures	2308.16	2310.74	2307.02	2310.17	1702.0
2010-04-29 08:00:00	NQ	Futures	2310.17	2313.6	2308.74	2311.89	6238.0
2010-04-29 09:00:00	NQ	Futures	2312.17	2319.05	2307.3	2315.9	49423.0
2010-04-29 10:00:00	NQ	Futures	2315.61	2329.64	2313.03	2327.35	55525.0
2010-04-29 11:00:00	NQ	Futures	2327.35	2334.8	2323.91	2332.79	43353.0
2010-04-29 12:00:00	NQ	Futures	2332.79	2339.95	2330.79	2338.23	28533.0
2010-04-29 13:00:00	NQ	Futures	2338.23	2341.38	2335.37	2339.66	18370.0
2010-04-29 14:00:00	NQ	Futures	2339.95	2340.81	2333.36	2335.65	24699.0
2010-04-29 15:00:00	NQ	Futures	2335.65	2340.81	2333.08	2336.51	40003.0
2010-04-29 16:00:00	NQ	Futures	2336.23	2338.8	2335.65	2337.09	13310.0
2010-04-29 17:00:00	NQ	Futures	2336.8	2339.66	2336.8	2339.09	447.0
2010-04-29 18:00:00	NQ	Futures	2339.09	2339.09	2338.23	2338.23	128.0
2010-04-29 19:00:00	NQ	Futures	2338.8	2338.8	2333.08	2333.36	396.0
2010-04-29 20:00:00	NQ	Futures	2333.36	2335.08	2332.22	2333.08	826.0
2010-04-29 21:00:00	NQ	Futures	2333.08	2334.22	2331.36	2331.36	368.0
2010-04-29 22:00:00	NQ	Futures	2331.65	2334.22	2331.36	2332.79	889.0
2010-04-29 23:00:00	NQ	Futures	2332.79	2336.8	2332.79	2336.51	519.0
2010-04-29 00:00:00	YM	Futures	10358.3	10361.1	10355.5	10359.2	36.0
2010-04-29 01:00:00	YM	Futures	10358.3	10358.3	10353.6	10354.5	101.0

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

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