PREVIEW / futures_1hour / 2011-08-24

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-08-24.parquet
  size:    48 KB
  rows:    1,430

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
2011-08-24 00:00:00	ES	Futures	1147.51	1151.26	1146.27	1151.01	8543.0
2011-08-24 01:00:00	ES	Futures	1151.26	1151.51	1143.27	1145.52	12077.0
2011-08-24 02:00:00	ES	Futures	1145.77	1148.51	1144.52	1146.77	20508.0
2011-08-24 03:00:00	ES	Futures	1146.77	1147.27	1139.78	1141.78	67496.0
2011-08-24 04:00:00	ES	Futures	1141.78	1149.01	1140.03	1146.52	42186.0
2011-08-24 05:00:00	ES	Futures	1146.52	1151.26	1145.02	1148.51	25724.0
2011-08-24 06:00:00	ES	Futures	1148.26	1148.51	1143.77	1144.52	19873.0
2011-08-24 07:00:00	ES	Futures	1144.52	1149.76	1143.77	1145.27	35923.0
2011-08-24 08:00:00	ES	Futures	1145.52	1156.99	1145.27	1154.75	124764.0
2011-08-24 09:00:00	ES	Futures	1155.0	1166.47	1150.76	1165.97	362795.0
2011-08-24 10:00:00	ES	Futures	1165.97	1171.21	1157.49	1157.74	524373.0
2011-08-24 11:00:00	ES	Futures	1157.74	1161.98	1155.5	1156.49	267832.0
2011-08-24 12:00:00	ES	Futures	1156.49	1158.74	1151.01	1157.99	200469.0
2011-08-24 13:00:00	ES	Futures	1157.99	1164.72	1156.49	1162.98	186091.0
2011-08-24 14:00:00	ES	Futures	1162.98	1165.47	1158.74	1164.72	136385.0
2011-08-24 15:00:00	ES	Futures	1164.72	1173.95	1162.98	1172.7	371328.0
2011-08-24 16:00:00	ES	Futures	1172.46	1173.2	1167.72	1168.46	114216.0
2011-08-24 17:00:00	ES	Futures	1168.22	1170.21	1167.72	1168.71	2408.0
2011-08-24 18:00:00	ES	Futures	1168.96	1169.21	1162.73	1164.72	15001.0
2011-08-24 19:00:00	ES	Futures	1164.72	1165.72	1163.23	1165.47	5655.0
2011-08-24 20:00:00	ES	Futures	1165.72	1168.71	1164.97	1166.97	11176.0
2011-08-24 21:00:00	ES	Futures	1166.97	1167.72	1163.73	1166.72	9767.0
2011-08-24 22:00:00	ES	Futures	1166.72	1168.22	1164.72	1166.47	4401.0
2011-08-24 23:00:00	ES	Futures	1166.47	1168.46	1165.72	1167.72	3837.0
2011-08-24 00:00:00	NQ	Futures	2428.74	2434.78	2426.15	2434.78	516.0
2011-08-24 01:00:00	NQ	Futures	2434.49	2434.78	2420.39	2424.42	956.0
2011-08-24 02:00:00	NQ	Futures	2424.71	2429.03	2421.83	2426.72	1495.0
2011-08-24 03:00:00	NQ	Futures	2426.44	2427.88	2412.91	2416.65	6175.0
2011-08-24 04:00:00	NQ	Futures	2416.37	2432.19	2413.2	2426.72	3409.0
2011-08-24 05:00:00	NQ	Futures	2426.72	2434.49	2423.85	2431.04	1957.0
2011-08-24 06:00:00	NQ	Futures	2430.47	2430.47	2420.39	2422.12	1469.0
2011-08-24 07:00:00	NQ	Futures	2422.41	2432.19	2421.26	2425.57	2269.0
2011-08-24 08:00:00	NQ	Futures	2425.57	2447.73	2425.0	2444.57	9243.0
2011-08-24 09:00:00	NQ	Futures	2444.57	2465.0	2435.65	2463.85	42255.0
2011-08-24 10:00:00	NQ	Futures	2463.56	2469.89	2436.51	2436.8	52917.0
2011-08-24 11:00:00	NQ	Futures	2436.8	2446.0	2429.6	2433.34	34762.0
2011-08-24 12:00:00	NQ	Futures	2433.06	2442.84	2421.26	2441.4	24188.0
2011-08-24 13:00:00	NQ	Futures	2441.4	2453.77	2437.08	2449.46	19583.0
2011-08-24 14:00:00	NQ	Futures	2450.03	2454.06	2439.39	2453.49	14798.0
2011-08-24 15:00:00	NQ	Futures	2453.49	2471.9	2450.61	2466.72	39561.0
2011-08-24 16:00:00	NQ	Futures	2466.72	2467.88	2458.38	2460.68	10351.0
2011-08-24 17:00:00	NQ	Futures	2460.39	2464.42	2459.24	2460.68	152.0
2011-08-24 18:00:00	NQ	Futures	2461.26	2463.27	2430.47	2437.95	5681.0
2011-08-24 19:00:00	NQ	Futures	2438.24	2439.1	2433.06	2438.52	2027.0
2011-08-24 20:00:00	NQ	Futures	2438.52	2445.72	2437.95	2442.55	1496.0
2011-08-24 21:00:00	NQ	Futures	2441.69	2443.42	2435.65	2442.26	674.0
2011-08-24 22:00:00	NQ	Futures	2442.26	2444.57	2438.24	2441.4	332.0
2011-08-24 23:00:00	NQ	Futures	2441.11	2444.57	2440.25	2442.84	283.0
2011-08-24 00:00:00	YM	Futures	10712.4	10744.4	10707.6	10743.4	395.0
2011-08-24 01:00:00	YM	Futures	10742.5	10748.3	10677.6	10700.8	824.0

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

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