PREVIEW / futures_1hour / 2011-05-10

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-05-10.parquet
  size:    49 KB
  rows:    1,468

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-05-10 00:00:00	ES	Futures	1332.08	1332.58	1330.59	1331.59	2127.0
2011-05-10 01:00:00	ES	Futures	1331.34	1332.08	1330.59	1331.34	6112.0
2011-05-10 02:00:00	ES	Futures	1331.34	1333.58	1331.09	1332.83	8892.0
2011-05-10 03:00:00	ES	Futures	1332.83	1337.8	1331.84	1336.8	34809.0
2011-05-10 04:00:00	ES	Futures	1336.8	1338.3	1334.82	1338.05	19033.0
2011-05-10 05:00:00	ES	Futures	1338.05	1340.03	1338.05	1338.79	25073.0
2011-05-10 06:00:00	ES	Futures	1338.54	1341.28	1338.54	1340.28	21236.0
2011-05-10 07:00:00	ES	Futures	1340.03	1341.28	1339.29	1340.78	19957.0
2011-05-10 08:00:00	ES	Futures	1340.78	1342.02	1339.29	1339.79	41543.0
2011-05-10 09:00:00	ES	Futures	1340.03	1341.03	1336.8	1340.78	220804.0
2011-05-10 10:00:00	ES	Futures	1340.78	1343.26	1339.79	1342.27	208656.0
2011-05-10 11:00:00	ES	Futures	1342.27	1343.02	1339.54	1341.03	171012.0
2011-05-10 12:00:00	ES	Futures	1341.03	1342.52	1340.28	1341.03	161406.0
2011-05-10 13:00:00	ES	Futures	1341.03	1342.52	1339.54	1342.27	81033.0
2011-05-10 14:00:00	ES	Futures	1342.27	1346.0	1340.78	1346.0	152027.0
2011-05-10 15:00:00	ES	Futures	1345.75	1347.98	1344.51	1345.5	263292.0
2011-05-10 16:00:00	ES	Futures	1345.75	1346.99	1344.51	1346.0	103511.0
2011-05-10 17:00:00	ES	Futures	1346.0	1346.25	1345.5	1346.25	901.0
2011-05-10 18:00:00	ES	Futures	1346.25	1347.24	1346.0	1346.74	3320.0
2011-05-10 19:00:00	ES	Futures	1346.49	1347.24	1346.49	1346.74	2210.0
2011-05-10 20:00:00	ES	Futures	1346.74	1347.74	1346.49	1347.49	5404.0
2011-05-10 21:00:00	ES	Futures	1347.49	1347.98	1346.49	1346.99	3600.0
2011-05-10 22:00:00	ES	Futures	1346.99	1347.24	1345.25	1346.0	7761.0
2011-05-10 23:00:00	ES	Futures	1345.75	1346.99	1345.5	1346.49	2972.0
2011-05-10 00:00:00	NQ	Futures	2740.98	2741.85	2738.4	2739.83	103.0
2011-05-10 01:00:00	NQ	Futures	2739.83	2741.85	2738.97	2739.55	438.0
2011-05-10 02:00:00	NQ	Futures	2739.55	2745.01	2739.26	2744.14	432.0
2011-05-10 03:00:00	NQ	Futures	2744.14	2751.9	2740.98	2748.74	2392.0
2011-05-10 04:00:00	NQ	Futures	2749.03	2751.61	2744.43	2750.75	1544.0
2011-05-10 05:00:00	NQ	Futures	2751.04	2756.5	2750.75	2753.91	2269.0
2011-05-10 06:00:00	NQ	Futures	2753.62	2760.52	2753.34	2758.51	1835.0
2011-05-10 07:00:00	NQ	Futures	2758.51	2760.23	2755.92	2758.8	1467.0
2011-05-10 08:00:00	NQ	Futures	2759.08	2760.23	2753.62	2754.77	3849.0
2011-05-10 09:00:00	NQ	Futures	2754.77	2762.82	2748.17	2762.53	58104.0
2011-05-10 10:00:00	NQ	Futures	2762.24	2763.68	2754.49	2758.51	37367.0
2011-05-10 11:00:00	NQ	Futures	2758.8	2760.81	2752.76	2756.21	16219.0
2011-05-10 12:00:00	NQ	Futures	2756.21	2758.22	2753.62	2754.49	58888.0
2011-05-10 13:00:00	NQ	Futures	2754.49	2759.66	2751.61	2758.8	32424.0
2011-05-10 14:00:00	NQ	Futures	2758.8	2768.57	2756.21	2767.99	31720.0
2011-05-10 15:00:00	NQ	Futures	2767.99	2772.01	2764.83	2767.99	33307.0
2011-05-10 16:00:00	NQ	Futures	2767.99	2769.71	2765.69	2767.99	8439.0
2011-05-10 17:00:00	NQ	Futures	2768.28	2770.0	2768.28	2770.0	106.0
2011-05-10 18:00:00	NQ	Futures	2769.43	2774.02	2769.14	2772.59	460.0
2011-05-10 19:00:00	NQ	Futures	2772.59	2774.31	2772.59	2773.74	437.0
2011-05-10 20:00:00	NQ	Futures	2773.45	2775.75	2773.16	2775.46	807.0
2011-05-10 21:00:00	NQ	Futures	2775.17	2775.46	2772.59	2773.74	465.0
2011-05-10 22:00:00	NQ	Futures	2773.16	2773.16	2769.71	2770.86	547.0
2011-05-10 23:00:00	NQ	Futures	2770.86	2774.02	2770.29	2772.59	246.0
2011-05-10 00:00:00	YM	Futures	12148.7	12152.5	12137.1	12142.9	132.0
2011-05-10 01:00:00	YM	Futures	12143.9	12148.7	12139.1	12144.8	244.0

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

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