PREVIEW / futures_1hour / 2011-04-28

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-04-28.parquet
  size:    48 KB
  rows:    1,462

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-04-28 00:00:00	ES	Futures	1346.49	1346.99	1346.0	1346.49	1805.0
2011-04-28 01:00:00	ES	Futures	1346.25	1346.49	1345.0	1345.5	6772.0
2011-04-28 02:00:00	ES	Futures	1345.5	1346.49	1344.75	1344.75	8527.0
2011-04-28 03:00:00	ES	Futures	1344.75	1345.75	1342.77	1343.02	23158.0
2011-04-28 04:00:00	ES	Futures	1342.77	1344.01	1342.02	1343.51	16385.0
2011-04-28 05:00:00	ES	Futures	1343.51	1344.51	1342.27	1342.77	11819.0
2011-04-28 06:00:00	ES	Futures	1342.77	1342.77	1341.52	1342.52	11730.0
2011-04-28 07:00:00	ES	Futures	1342.27	1342.52	1340.78	1341.03	23802.0
2011-04-28 08:00:00	ES	Futures	1341.28	1341.77	1338.3	1340.53	69090.0
2011-04-28 09:00:00	ES	Futures	1340.28	1344.75	1339.54	1344.75	184210.0
2011-04-28 10:00:00	ES	Futures	1344.75	1345.5	1343.02	1344.75	198728.0
2011-04-28 11:00:00	ES	Futures	1344.75	1346.74	1342.52	1343.76	232916.0
2011-04-28 12:00:00	ES	Futures	1343.51	1346.25	1342.77	1345.0	186846.0
2011-04-28 13:00:00	ES	Futures	1344.75	1345.75	1342.52	1344.75	181132.0
2011-04-28 14:00:00	ES	Futures	1345.0	1346.74	1344.26	1346.25	97527.0
2011-04-28 15:00:00	ES	Futures	1346.0	1349.97	1345.25	1347.98	317932.0
2011-04-28 16:00:00	ES	Futures	1348.23	1348.48	1345.5	1346.74	99422.0
2011-04-28 17:00:00	ES	Futures	1346.74	1346.99	1345.75	1346.0	1588.0
2011-04-28 18:00:00	ES	Futures	1346.0	1347.49	1346.0	1347.49	1904.0
2011-04-28 19:00:00	ES	Futures	1347.24	1347.74	1346.99	1347.24	1436.0
2011-04-28 20:00:00	ES	Futures	1346.99	1348.48	1345.75	1346.0	8171.0
2011-04-28 21:00:00	ES	Futures	1346.0	1346.49	1345.25	1346.0	5302.0
2011-04-28 22:00:00	ES	Futures	1346.0	1346.74	1345.75	1346.49	2576.0
2011-04-28 23:00:00	ES	Futures	1346.25	1346.99	1346.0	1346.49	2254.0
2011-04-28 00:00:00	NQ	Futures	2772.88	2773.45	2771.73	2772.3	264.0
2011-04-28 01:00:00	NQ	Futures	2772.3	2772.3	2770.0	2771.15	271.0
2011-04-28 02:00:00	NQ	Futures	2771.44	2773.74	2771.15	2771.15	898.0
2011-04-28 03:00:00	NQ	Futures	2771.15	2773.45	2767.13	2767.7	1538.0
2011-04-28 04:00:00	NQ	Futures	2767.7	2769.71	2766.55	2769.43	783.0
2011-04-28 05:00:00	NQ	Futures	2769.14	2771.44	2767.42	2767.99	635.0
2011-04-28 06:00:00	NQ	Futures	2767.7	2768.57	2763.97	2765.12	1752.0
2011-04-28 07:00:00	NQ	Futures	2765.12	2765.12	2763.11	2763.97	2091.0
2011-04-28 08:00:00	NQ	Futures	2763.97	2765.12	2759.95	2762.82	6390.0
2011-04-28 09:00:00	NQ	Futures	2762.82	2767.13	2759.08	2766.55	43517.0
2011-04-28 10:00:00	NQ	Futures	2766.27	2767.13	2756.79	2764.26	31177.0
2011-04-28 11:00:00	NQ	Futures	2764.26	2768.28	2755.92	2757.36	27627.0
2011-04-28 12:00:00	NQ	Futures	2757.36	2763.68	2755.35	2758.8	21272.0
2011-04-28 13:00:00	NQ	Futures	2759.08	2761.38	2753.91	2760.52	25511.0
2011-04-28 14:00:00	NQ	Futures	2760.52	2765.4	2758.22	2762.53	12434.0
2011-04-28 15:00:00	NQ	Futures	2762.82	2769.71	2760.81	2765.69	35633.0
2011-04-28 16:00:00	NQ	Futures	2765.69	2769.71	2755.64	2758.8	14586.0
2011-04-28 17:00:00	NQ	Futures	2758.8	2759.08	2755.64	2756.5	235.0
2011-04-28 18:00:00	NQ	Futures	2756.5	2759.66	2755.06	2759.37	254.0
2011-04-28 19:00:00	NQ	Futures	2759.08	2761.1	2758.8	2759.66	181.0
2011-04-28 20:00:00	NQ	Futures	2760.23	2762.24	2758.22	2758.51	287.0
2011-04-28 21:00:00	NQ	Futures	2758.51	2758.8	2755.92	2757.36	249.0
2011-04-28 22:00:00	NQ	Futures	2757.65	2759.66	2756.79	2758.22	220.0
2011-04-28 23:00:00	NQ	Futures	2758.51	2758.8	2757.07	2758.22	134.0
2011-04-28 00:00:00	YM	Futures	12208.4	12212.3	12206.5	12207.4	106.0
2011-04-28 01:00:00	YM	Futures	12208.4	12208.4	12197.8	12200.7	321.0

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

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