PREVIEW / futures_1hour / 2011-07-06

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-07-06.parquet
  size:    48 KB
  rows:    1,466

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-07-06 00:00:00	ES	Futures	1336.81	1337.06	1335.82	1336.07	2393.0
2011-07-06 01:00:00	ES	Futures	1336.31	1337.56	1335.57	1337.31	6268.0
2011-07-06 02:00:00	ES	Futures	1337.31	1337.56	1332.57	1332.57	18585.0
2011-07-06 03:00:00	ES	Futures	1332.82	1333.57	1329.08	1329.58	42251.0
2011-07-06 04:00:00	ES	Futures	1329.58	1330.33	1327.34	1329.33	32993.0
2011-07-06 05:00:00	ES	Futures	1329.08	1330.83	1328.08	1330.33	18381.0
2011-07-06 06:00:00	ES	Futures	1330.33	1331.33	1326.59	1327.59	39937.0
2011-07-06 07:00:00	ES	Futures	1327.59	1327.84	1325.09	1326.84	57965.0
2011-07-06 08:00:00	ES	Futures	1327.09	1327.84	1325.59	1327.09	44841.0
2011-07-06 09:00:00	ES	Futures	1327.09	1329.33	1325.84	1326.84	208846.0
2011-07-06 10:00:00	ES	Futures	1326.84	1328.58	1323.35	1328.08	400587.0
2011-07-06 11:00:00	ES	Futures	1327.84	1332.07	1326.34	1331.33	265997.0
2011-07-06 12:00:00	ES	Futures	1331.33	1333.57	1330.33	1333.32	115122.0
2011-07-06 13:00:00	ES	Futures	1333.57	1333.57	1329.83	1331.58	110945.0
2011-07-06 14:00:00	ES	Futures	1331.83	1332.32	1328.83	1329.83	115928.0
2011-07-06 15:00:00	ES	Futures	1329.83	1332.07	1328.58	1332.07	213749.0
2011-07-06 16:00:00	ES	Futures	1332.07	1335.57	1331.58	1334.82	84757.0
2011-07-06 17:00:00	ES	Futures	1334.57	1335.07	1334.07	1335.07	1278.0
2011-07-06 18:00:00	ES	Futures	1335.07	1335.32	1333.82	1334.07	2334.0
2011-07-06 19:00:00	ES	Futures	1334.32	1335.82	1334.07	1335.57	3140.0
2011-07-06 20:00:00	ES	Futures	1335.57	1336.07	1334.57	1335.82	5571.0
2011-07-06 21:00:00	ES	Futures	1335.57	1336.81	1335.32	1336.31	7104.0
2011-07-06 22:00:00	ES	Futures	1336.07	1340.31	1335.07	1339.06	22623.0
2011-07-06 23:00:00	ES	Futures	1339.31	1340.06	1337.81	1338.06	11239.0
2011-07-06 00:00:00	NQ	Futures	2736.94	2737.51	2736.36	2736.94	326.0
2011-07-06 01:00:00	NQ	Futures	2736.94	2739.81	2735.5	2739.53	338.0
2011-07-06 02:00:00	NQ	Futures	2739.53	2739.53	2731.18	2731.18	1786.0
2011-07-06 03:00:00	NQ	Futures	2731.18	2731.76	2723.12	2723.7	5654.0
2011-07-06 04:00:00	NQ	Futures	2723.99	2727.15	2715.35	2725.14	5663.0
2011-07-06 05:00:00	NQ	Futures	2725.14	2726.86	2721.68	2726.0	2671.0
2011-07-06 06:00:00	NQ	Futures	2726.29	2728.88	2721.97	2723.12	5567.0
2011-07-06 07:00:00	NQ	Futures	2723.41	2724.27	2719.09	2721.4	3445.0
2011-07-06 08:00:00	NQ	Futures	2721.4	2723.99	2719.38	2722.55	5164.0
2011-07-06 09:00:00	NQ	Futures	2722.84	2728.88	2720.25	2725.14	47405.0
2011-07-06 10:00:00	NQ	Futures	2725.14	2727.73	2714.78	2726.0	59574.0
2011-07-06 11:00:00	NQ	Futures	2726.0	2735.78	2721.4	2733.48	35803.0
2011-07-06 12:00:00	NQ	Futures	2733.48	2740.39	2731.47	2739.53	14688.0
2011-07-06 13:00:00	NQ	Futures	2739.81	2740.1	2731.18	2734.63	16113.0
2011-07-06 14:00:00	NQ	Futures	2734.92	2735.5	2724.56	2728.88	17295.0
2011-07-06 15:00:00	NQ	Futures	2728.59	2735.78	2725.43	2735.5	25060.0
2011-07-06 16:00:00	NQ	Futures	2735.21	2739.81	2733.48	2738.37	8001.0
2011-07-06 17:00:00	NQ	Futures	2738.37	2740.1	2738.37	2739.53	101.0
2011-07-06 18:00:00	NQ	Futures	2739.53	2739.81	2736.94	2738.37	397.0
2011-07-06 19:00:00	NQ	Futures	2738.37	2739.81	2737.51	2739.53	327.0
2011-07-06 20:00:00	NQ	Futures	2739.81	2742.69	2738.37	2741.54	512.0
2011-07-06 21:00:00	NQ	Futures	2741.83	2743.55	2740.96	2742.98	710.0
2011-07-06 22:00:00	NQ	Futures	2742.69	2749.89	2741.25	2748.45	1931.0
2011-07-06 23:00:00	NQ	Futures	2748.73	2749.89	2745.86	2746.72	770.0
2011-07-06 00:00:00	YM	Futures	12165.0	12165.0	12157.3	12160.2	85.0
2011-07-06 01:00:00	YM	Futures	12161.2	12167.9	12154.4	12167.0	216.0

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

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