PREVIEW / futures_1hour / 2011-08-10

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-08-10.parquet
  size:    52 KB
  rows:    1,499

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-10 00:00:00	ES	Futures	1165.22	1165.97	1161.98	1165.47	11645.0
2011-08-10 01:00:00	ES	Futures	1165.72	1168.71	1162.73	1165.22	11938.0
2011-08-10 02:00:00	ES	Futures	1165.22	1170.21	1159.74	1170.21	45805.0
2011-08-10 03:00:00	ES	Futures	1170.21	1173.7	1162.23	1162.48	75246.0
2011-08-10 04:00:00	ES	Futures	1162.48	1163.48	1154.25	1161.23	80247.0
2011-08-10 05:00:00	ES	Futures	1160.98	1170.46	1160.73	1164.47	48751.0
2011-08-10 06:00:00	ES	Futures	1164.72	1166.72	1161.48	1163.98	32472.0
2011-08-10 07:00:00	ES	Futures	1163.73	1165.47	1157.74	1158.99	61956.0
2011-08-10 08:00:00	ES	Futures	1158.99	1160.48	1147.51	1148.51	167743.0
2011-08-10 09:00:00	ES	Futures	1148.51	1150.76	1132.05	1133.8	676253.0
2011-08-10 10:00:00	ES	Futures	1134.05	1139.78	1119.83	1128.56	924010.0
2011-08-10 11:00:00	ES	Futures	1128.31	1134.55	1118.83	1131.3	568984.0
2011-08-10 12:00:00	ES	Futures	1131.05	1137.29	1123.82	1134.8	315444.0
2011-08-10 13:00:00	ES	Futures	1134.8	1144.52	1125.82	1143.77	358007.0
2011-08-10 14:00:00	ES	Futures	1143.77	1154.5	1138.04	1138.54	480633.0
2011-08-10 15:00:00	ES	Futures	1138.54	1141.03	1111.1	1114.09	747788.0
2011-08-10 16:00:00	ES	Futures	1114.09	1125.32	1112.35	1124.82	184041.0
2011-08-10 17:00:00	ES	Futures	1124.82	1124.82	1119.08	1120.08	9458.0
2011-08-10 18:00:00	ES	Futures	1118.33	1119.33	1112.6	1114.09	19667.0
2011-08-10 19:00:00	ES	Futures	1113.85	1121.83	1113.85	1120.83	14054.0
2011-08-10 20:00:00	ES	Futures	1120.83	1131.05	1119.58	1130.06	31643.0
2011-08-10 21:00:00	ES	Futures	1130.31	1135.29	1126.81	1134.05	23315.0
2011-08-10 22:00:00	ES	Futures	1134.3	1140.28	1132.05	1137.04	22511.0
2011-08-10 23:00:00	ES	Futures	1137.29	1139.53	1131.05	1133.05	12483.0
2011-08-10 00:00:00	NQ	Futures	2472.48	2473.34	2466.44	2473.05	836.0
2011-08-10 01:00:00	NQ	Futures	2472.77	2478.81	2467.01	2472.48	1096.0
2011-08-10 02:00:00	NQ	Futures	2472.48	2480.54	2460.39	2480.54	3563.0
2011-08-10 03:00:00	NQ	Futures	2480.54	2488.31	2466.44	2468.74	4899.0
2011-08-10 04:00:00	NQ	Futures	2468.74	2469.6	2452.34	2465.29	3791.0
2011-08-10 05:00:00	NQ	Futures	2465.0	2483.41	2464.13	2471.9	2538.0
2011-08-10 06:00:00	NQ	Futures	2472.19	2477.08	2466.15	2470.75	1773.0
2011-08-10 07:00:00	NQ	Futures	2471.33	2476.22	2453.49	2455.5	6478.0
2011-08-10 08:00:00	NQ	Futures	2455.5	2456.65	2431.04	2432.48	13450.0
2011-08-10 09:00:00	NQ	Futures	2431.9	2438.24	2405.72	2411.47	89553.0
2011-08-10 10:00:00	NQ	Futures	2411.19	2425.57	2389.6	2404.57	105355.0
2011-08-10 11:00:00	NQ	Futures	2404.57	2424.42	2386.44	2416.65	60690.0
2011-08-10 12:00:00	NQ	Futures	2416.37	2430.47	2402.55	2422.41	40017.0
2011-08-10 13:00:00	NQ	Futures	2422.12	2444.85	2405.14	2444.28	43883.0
2011-08-10 14:00:00	NQ	Futures	2444.57	2462.98	2425.86	2426.15	58278.0
2011-08-10 15:00:00	NQ	Futures	2426.44	2433.92	2378.67	2381.83	78601.0
2011-08-10 16:00:00	NQ	Futures	2381.83	2408.88	2377.8	2406.29	20954.0
2011-08-10 17:00:00	NQ	Futures	2405.72	2405.72	2393.92	2394.49	567.0
2011-08-10 18:00:00	NQ	Futures	2393.06	2396.22	2383.27	2387.88	1275.0
2011-08-10 19:00:00	NQ	Futures	2387.3	2404.85	2387.3	2402.84	960.0
2011-08-10 20:00:00	NQ	Futures	2402.55	2420.11	2399.96	2418.67	2048.0
2011-08-10 21:00:00	NQ	Futures	2418.95	2434.21	2410.61	2433.63	1831.0
2011-08-10 22:00:00	NQ	Futures	2433.92	2442.55	2428.45	2437.37	1213.0
2011-08-10 23:00:00	NQ	Futures	2436.51	2441.98	2424.13	2429.6	893.0
2011-08-10 00:00:00	YM	Futures	10805.4	10808.3	10778.3	10807.3	693.0
2011-08-10 01:00:00	YM	Futures	10808.3	10831.5	10785.1	10802.5	897.0

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

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