PREVIEW / futures_1hour / 2011-08-11

all futures 1-hour files

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

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-11 00:00:00	ES	Futures	1133.05	1136.79	1132.05	1135.29	5293.0
2011-08-11 01:00:00	ES	Futures	1135.54	1142.03	1135.04	1141.78	11898.0
2011-08-11 02:00:00	ES	Futures	1141.78	1145.52	1138.04	1145.27	40247.0
2011-08-11 03:00:00	ES	Futures	1145.27	1145.52	1132.55	1140.03	100155.0
2011-08-11 04:00:00	ES	Futures	1140.03	1144.77	1137.29	1141.28	42161.0
2011-08-11 05:00:00	ES	Futures	1141.28	1141.78	1128.06	1128.31	58581.0
2011-08-11 06:00:00	ES	Futures	1128.31	1134.8	1122.57	1133.05	95740.0
2011-08-11 07:00:00	ES	Futures	1133.05	1133.8	1103.12	1108.11	182146.0
2011-08-11 08:00:00	ES	Futures	1108.11	1123.32	1100.38	1120.08	286766.0
2011-08-11 09:00:00	ES	Futures	1120.08	1137.04	1116.84	1127.56	613503.0
2011-08-11 10:00:00	ES	Futures	1127.81	1151.51	1126.56	1145.02	604955.0
2011-08-11 11:00:00	ES	Futures	1145.27	1150.01	1139.78	1145.27	401634.0
2011-08-11 12:00:00	ES	Futures	1145.52	1162.23	1142.28	1160.48	309460.0
2011-08-11 13:00:00	ES	Futures	1160.23	1160.73	1150.76	1158.74	346732.0
2011-08-11 14:00:00	ES	Futures	1158.49	1168.22	1156.49	1166.72	300436.0
2011-08-11 15:00:00	ES	Futures	1166.72	1181.18	1163.98	1165.22	759776.0
2011-08-11 16:00:00	ES	Futures	1164.97	1166.97	1161.73	1166.72	165964.0
2011-08-11 17:00:00	ES	Futures	1166.72	1166.97	1161.48	1163.73	8081.0
2011-08-11 18:00:00	ES	Futures	1164.47	1164.97	1159.49	1163.23	10223.0
2011-08-11 19:00:00	ES	Futures	1163.23	1164.23	1162.73	1163.48	4628.0
2011-08-11 20:00:00	ES	Futures	1163.48	1164.47	1159.74	1162.73	9101.0
2011-08-11 21:00:00	ES	Futures	1162.73	1162.98	1156.74	1159.74	8934.0
2011-08-11 22:00:00	ES	Futures	1159.99	1163.48	1157.49	1158.99	6013.0
2011-08-11 23:00:00	ES	Futures	1158.74	1158.99	1153.0	1155.25	8678.0
2011-08-11 00:00:00	NQ	Futures	2429.89	2436.8	2427.01	2432.77	557.0
2011-08-11 01:00:00	NQ	Futures	2432.48	2441.98	2429.31	2441.11	857.0
2011-08-11 02:00:00	NQ	Futures	2441.69	2450.03	2434.78	2448.88	2735.0
2011-08-11 03:00:00	NQ	Futures	2450.03	2450.03	2422.12	2440.83	4350.0
2011-08-11 04:00:00	NQ	Futures	2441.11	2451.76	2434.78	2443.99	2152.0
2011-08-11 05:00:00	NQ	Futures	2443.7	2445.14	2417.52	2417.8	1810.0
2011-08-11 06:00:00	NQ	Futures	2417.8	2432.77	2409.46	2428.45	3570.0
2011-08-11 07:00:00	NQ	Futures	2427.88	2428.74	2377.23	2389.03	9595.0
2011-08-11 08:00:00	NQ	Futures	2390.47	2412.91	2368.31	2407.73	16264.0
2011-08-11 09:00:00	NQ	Futures	2407.73	2438.52	2399.96	2421.54	72762.0
2011-08-11 10:00:00	NQ	Futures	2421.83	2473.05	2419.53	2458.95	84162.0
2011-08-11 11:00:00	NQ	Futures	2459.24	2467.59	2446.29	2459.24	35824.0
2011-08-11 12:00:00	NQ	Futures	2459.24	2487.44	2450.32	2484.57	32556.0
2011-08-11 13:00:00	NQ	Futures	2484.28	2485.14	2468.16	2482.26	29883.0
2011-08-11 14:00:00	NQ	Futures	2481.98	2495.5	2478.23	2492.05	32279.0
2011-08-11 15:00:00	NQ	Futures	2492.05	2514.49	2480.82	2485.72	66549.0
2011-08-11 16:00:00	NQ	Futures	2486.0	2490.61	2475.93	2488.02	16017.0
2011-08-11 17:00:00	NQ	Futures	2488.02	2488.02	2479.1	2484.28	547.0
2011-08-11 18:00:00	NQ	Futures	2481.98	2483.7	2472.77	2479.96	591.0
2011-08-11 19:00:00	NQ	Futures	2481.4	2483.7	2480.25	2482.84	243.0
2011-08-11 20:00:00	NQ	Futures	2483.13	2483.41	2473.34	2480.54	645.0
2011-08-11 21:00:00	NQ	Futures	2480.54	2480.82	2467.3	2473.92	885.0
2011-08-11 22:00:00	NQ	Futures	2473.92	2481.4	2468.74	2471.33	518.0
2011-08-11 23:00:00	NQ	Futures	2471.04	2471.04	2457.52	2463.27	1002.0
2011-08-11 00:00:00	YM	Futures	10491.6	10523.6	10483.9	10513.9	1210.0
2011-08-11 01:00:00	YM	Futures	10512.9	10562.3	10512.0	10560.4	1270.0

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

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