PREVIEW / futures_1hour / 2011-08-02

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-08-02.parquet
  size:    51 KB
  rows:    1,496

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-02 00:00:00	ES	Futures	1273.46	1273.96	1272.22	1272.47	3705.0
2011-08-02 01:00:00	ES	Futures	1272.47	1273.46	1269.97	1272.97	7402.0
2011-08-02 02:00:00	ES	Futures	1272.97	1274.46	1269.97	1270.22	23695.0
2011-08-02 03:00:00	ES	Futures	1270.22	1273.71	1267.48	1269.72	69413.0
2011-08-02 04:00:00	ES	Futures	1269.72	1272.47	1268.98	1269.72	30701.0
2011-08-02 05:00:00	ES	Futures	1269.47	1271.47	1267.73	1269.22	28327.0
2011-08-02 06:00:00	ES	Futures	1269.22	1272.97	1268.73	1270.97	31752.0
2011-08-02 07:00:00	ES	Futures	1270.97	1271.97	1267.23	1269.72	50948.0
2011-08-02 08:00:00	ES	Futures	1269.97	1271.47	1262.99	1270.72	140488.0
2011-08-02 09:00:00	ES	Futures	1270.97	1276.21	1267.98	1275.46	315276.0
2011-08-02 10:00:00	ES	Futures	1275.46	1276.96	1267.98	1268.73	401811.0
2011-08-02 11:00:00	ES	Futures	1268.48	1269.22	1264.24	1265.73	399353.0
2011-08-02 12:00:00	ES	Futures	1265.73	1268.48	1258.25	1260.0	326684.0
2011-08-02 13:00:00	ES	Futures	1260.0	1264.49	1255.01	1256.01	310247.0
2011-08-02 14:00:00	ES	Futures	1256.01	1261.49	1255.51	1260.5	231633.0
2011-08-02 15:00:00	ES	Futures	1260.5	1261.49	1246.78	1246.78	667181.0
2011-08-02 16:00:00	ES	Futures	1247.03	1247.78	1242.54	1243.29	210760.0
2011-08-02 17:00:00	ES	Futures	1243.29	1244.53	1242.29	1242.54	6313.0
2011-08-02 18:00:00	ES	Futures	1243.29	1244.53	1241.29	1242.79	12634.0
2011-08-02 19:00:00	ES	Futures	1242.79	1244.28	1242.54	1243.04	5770.0
2011-08-02 20:00:00	ES	Futures	1243.04	1245.03	1242.79	1243.79	7999.0
2011-08-02 21:00:00	ES	Futures	1243.54	1244.78	1242.29	1244.03	12205.0
2011-08-02 22:00:00	ES	Futures	1244.28	1245.28	1243.54	1245.28	5628.0
2011-08-02 23:00:00	ES	Futures	1245.03	1246.28	1244.28	1245.53	6737.0
2011-08-02 00:00:00	NQ	Futures	2690.89	2692.04	2688.3	2688.3	286.0
2011-08-02 01:00:00	NQ	Futures	2688.88	2690.61	2684.56	2690.03	638.0
2011-08-02 02:00:00	NQ	Futures	2690.32	2693.2	2686.29	2686.86	1343.0
2011-08-02 03:00:00	NQ	Futures	2687.15	2689.45	2681.68	2687.15	4698.0
2011-08-02 04:00:00	NQ	Futures	2687.44	2692.62	2686.58	2688.3	3160.0
2011-08-02 05:00:00	NQ	Futures	2688.02	2691.76	2682.84	2685.43	2447.0
2011-08-02 06:00:00	NQ	Futures	2685.14	2692.33	2684.85	2688.88	1982.0
2011-08-02 07:00:00	NQ	Futures	2688.59	2691.18	2683.12	2687.73	3202.0
2011-08-02 08:00:00	NQ	Futures	2687.73	2692.04	2676.22	2691.18	9506.0
2011-08-02 09:00:00	NQ	Futures	2691.18	2700.1	2684.56	2699.53	40362.0
2011-08-02 10:00:00	NQ	Futures	2699.24	2704.13	2688.02	2689.74	45060.0
2011-08-02 11:00:00	NQ	Futures	2689.45	2689.74	2677.94	2683.12	41407.0
2011-08-02 12:00:00	NQ	Futures	2683.12	2689.17	2661.54	2668.74	40616.0
2011-08-02 13:00:00	NQ	Futures	2668.74	2676.22	2650.61	2653.2	33312.0
2011-08-02 14:00:00	NQ	Futures	2653.2	2666.15	2651.18	2664.42	24599.0
2011-08-02 15:00:00	NQ	Futures	2664.71	2667.01	2633.34	2635.64	67283.0
2011-08-02 16:00:00	NQ	Futures	2635.64	2641.97	2628.45	2629.89	16608.0
2011-08-02 17:00:00	NQ	Futures	2630.17	2632.19	2627.3	2629.02	570.0
2011-08-02 18:00:00	NQ	Futures	2629.31	2632.19	2625.86	2629.02	1112.0
2011-08-02 19:00:00	NQ	Futures	2629.02	2632.48	2628.74	2629.89	372.0
2011-08-02 20:00:00	NQ	Futures	2630.17	2633.92	2629.6	2631.61	386.0
2011-08-02 21:00:00	NQ	Futures	2631.61	2632.76	2627.58	2630.46	766.0
2011-08-02 22:00:00	NQ	Futures	2630.17	2633.34	2629.31	2633.05	503.0
2011-08-02 23:00:00	NQ	Futures	2633.05	2635.35	2631.61	2633.63	387.0
2011-08-02 00:00:00	YM	Futures	11631.4	11639.2	11619.8	11622.7	311.0
2011-08-02 01:00:00	YM	Futures	11623.7	11635.3	11606.3	11630.5	652.0

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

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