PREVIEW / futures_1hour / 2010-04-13

all futures 1-hour files

  file:    by_date/futures_1hour/2010/2010-04-13.parquet
  size:    45 KB
  rows:    1,385

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-13 00:00:00	ES	Futures	1161.76	1162.25	1161.51	1162.0	3504.0
2010-04-13 01:00:00	ES	Futures	1162.0	1162.98	1161.76	1162.74	3672.0
2010-04-13 02:00:00	ES	Futures	1162.74	1164.2	1162.25	1163.71	8256.0
2010-04-13 03:00:00	ES	Futures	1163.71	1165.42	1162.98	1163.22	18805.0
2010-04-13 04:00:00	ES	Futures	1163.22	1163.96	1162.25	1162.25	10915.0
2010-04-13 05:00:00	ES	Futures	1162.49	1162.98	1161.76	1162.98	13797.0
2010-04-13 06:00:00	ES	Futures	1162.98	1163.96	1162.74	1162.98	9442.0
2010-04-13 07:00:00	ES	Futures	1163.22	1163.71	1162.49	1162.98	14111.0
2010-04-13 08:00:00	ES	Futures	1162.98	1166.16	1162.98	1165.91	39810.0
2010-04-13 09:00:00	ES	Futures	1165.67	1165.91	1162.74	1164.2	178630.0
2010-04-13 10:00:00	ES	Futures	1164.2	1164.94	1158.58	1161.02	396469.0
2010-04-13 11:00:00	ES	Futures	1161.02	1162.49	1160.05	1161.76	145947.0
2010-04-13 12:00:00	ES	Futures	1162.0	1164.69	1161.27	1164.2	127216.0
2010-04-13 13:00:00	ES	Futures	1164.2	1166.89	1164.2	1166.4	139757.0
2010-04-13 14:00:00	ES	Futures	1166.65	1167.14	1164.94	1165.91	105795.0
2010-04-13 15:00:00	ES	Futures	1165.91	1169.09	1165.42	1167.14	233778.0
2010-04-13 16:00:00	ES	Futures	1167.38	1169.58	1165.91	1169.09	92498.0
2010-04-13 17:00:00	ES	Futures	1169.09	1169.34	1168.85	1169.09	1995.0
2010-04-13 18:00:00	ES	Futures	1168.85	1169.09	1167.87	1168.36	3615.0
2010-04-13 19:00:00	ES	Futures	1168.36	1168.85	1168.11	1168.6	1468.0
2010-04-13 20:00:00	ES	Futures	1168.36	1169.34	1168.11	1169.09	3414.0
2010-04-13 21:00:00	ES	Futures	1168.85	1169.09	1168.11	1168.11	2243.0
2010-04-13 22:00:00	ES	Futures	1168.11	1168.6	1167.87	1168.11	2254.0
2010-04-13 23:00:00	ES	Futures	1168.11	1168.6	1167.87	1168.36	2227.0
2010-04-13 00:00:00	NQ	Futures	2275.52	2275.8	2274.94	2275.23	133.0
2010-04-13 01:00:00	NQ	Futures	2275.23	2276.38	2275.23	2276.09	287.0
2010-04-13 02:00:00	NQ	Futures	2276.09	2278.38	2275.8	2278.38	832.0
2010-04-13 03:00:00	NQ	Futures	2278.38	2280.1	2277.81	2278.09	1373.0
2010-04-13 04:00:00	NQ	Futures	2278.09	2278.09	2275.52	2275.52	1276.0
2010-04-13 05:00:00	NQ	Futures	2275.8	2277.23	2275.23	2277.23	589.0
2010-04-13 06:00:00	NQ	Futures	2277.23	2277.23	2275.23	2275.8	877.0
2010-04-13 07:00:00	NQ	Futures	2275.8	2276.95	2274.94	2276.66	693.0
2010-04-13 08:00:00	NQ	Futures	2276.38	2281.24	2276.38	2280.38	2491.0
2010-04-13 09:00:00	NQ	Futures	2280.67	2288.98	2277.81	2284.68	36053.0
2010-04-13 10:00:00	NQ	Futures	2284.68	2286.69	2272.94	2278.95	51307.0
2010-04-13 11:00:00	NQ	Futures	2278.95	2284.11	2278.38	2281.82	27075.0
2010-04-13 12:00:00	NQ	Futures	2282.1	2287.26	2279.53	2286.4	19423.0
2010-04-13 13:00:00	NQ	Futures	2286.4	2293.27	2286.4	2292.99	30273.0
2010-04-13 14:00:00	NQ	Futures	2292.99	2293.56	2290.12	2291.27	18103.0
2010-04-13 15:00:00	NQ	Futures	2290.98	2295.56	2290.12	2292.99	26485.0
2010-04-13 16:00:00	NQ	Futures	2293.27	2303.58	2291.55	2299.57	12358.0
2010-04-13 17:00:00	NQ	Futures	2299.86	2301.86	2299.86	2301.86	484.0
2010-04-13 18:00:00	NQ	Futures	2301.58	2302.15	2300.14	2301.29	710.0
2010-04-13 19:00:00	NQ	Futures	2301.29	2302.15	2301.0	2301.58	286.0
2010-04-13 20:00:00	NQ	Futures	2301.29	2302.15	2300.72	2301.58	397.0
2010-04-13 21:00:00	NQ	Futures	2301.58	2301.86	2300.72	2301.0	178.0
2010-04-13 22:00:00	NQ	Futures	2300.72	2301.29	2300.14	2300.14	260.0
2010-04-13 23:00:00	NQ	Futures	2300.14	2301.0	2300.14	2300.72	109.0
2010-04-13 00:00:00	YM	Futures	10276.4	10278.3	10270.8	10273.6	464.0
2010-04-13 01:00:00	YM	Futures	10274.6	10285.9	10274.6	10284.0	238.0

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

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