PREVIEW / futures_1hour / 2012-04-09

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-04-09.parquet
  size:    39 KB
  rows:    1,147

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
2012-04-09 00:00:00	ES	Futures	1391.67	1392.17	1390.91	1391.41	1238.0
2012-04-09 01:00:00	ES	Futures	1391.41	1392.68	1391.41	1392.43	2212.0
2012-04-09 02:00:00	ES	Futures	1392.43	1392.93	1391.92	1392.17	1750.0
2012-04-09 03:00:00	ES	Futures	1392.17	1392.43	1390.91	1391.67	2381.0
2012-04-09 04:00:00	ES	Futures	1391.92	1392.93	1391.67	1392.17	2313.0
2012-04-09 05:00:00	ES	Futures	1392.43	1394.7	1391.16	1391.41	7950.0
2012-04-09 06:00:00	ES	Futures	1391.67	1392.17	1390.66	1391.41	5358.0
2012-04-09 07:00:00	ES	Futures	1391.41	1393.44	1390.66	1391.41	11730.0
2012-04-09 08:00:00	ES	Futures	1391.41	1392.17	1390.91	1392.17	16242.0
2012-04-09 09:00:00	ES	Futures	1391.92	1393.94	1389.64	1390.66	179658.0
2012-04-09 10:00:00	ES	Futures	1390.66	1395.21	1390.66	1394.2	187879.0
2012-04-09 11:00:00	ES	Futures	1393.94	1394.2	1390.4	1392.68	95303.0
2012-04-09 12:00:00	ES	Futures	1392.68	1396.47	1391.92	1395.71	88315.0
2012-04-09 13:00:00	ES	Futures	1395.71	1397.99	1393.94	1397.49	82396.0
2012-04-09 14:00:00	ES	Futures	1397.74	1399.26	1395.71	1397.99	82437.0
2012-04-09 15:00:00	ES	Futures	1397.99	1399.0	1393.44	1393.69	179142.0
2012-04-09 16:00:00	ES	Futures	1393.69	1393.94	1390.66	1391.67	111012.0
2012-04-09 17:00:00	ES	Futures	1391.92	1391.92	1391.41	1391.67	1600.0
2012-04-09 18:00:00	ES	Futures	1392.17	1393.18	1391.92	1392.43	3567.0
2012-04-09 19:00:00	ES	Futures	1392.43	1392.93	1391.67	1392.43	3244.0
2012-04-09 20:00:00	ES	Futures	1392.43	1393.69	1392.17	1393.69	4721.0
2012-04-09 21:00:00	ES	Futures	1393.44	1395.71	1392.93	1394.96	8327.0
2012-04-09 22:00:00	ES	Futures	1394.96	1395.71	1394.45	1395.71	2862.0
2012-04-09 23:00:00	ES	Futures	1395.71	1395.97	1393.94	1394.96	6112.0
2012-04-09 00:00:00	NQ	Futures	3152.0	3154.02	3151.71	3153.15	424.0
2012-04-09 01:00:00	NQ	Futures	3153.15	3154.6	3153.15	3154.31	87.0
2012-04-09 02:00:00	NQ	Futures	3154.31	3155.47	3153.73	3153.73	198.0
2012-04-09 03:00:00	NQ	Futures	3153.73	3153.73	3150.55	3152.58	507.0
2012-04-09 04:00:00	NQ	Futures	3152.86	3154.89	3152.58	3154.31	117.0
2012-04-09 05:00:00	NQ	Futures	3154.31	3158.07	3151.71	3152.0	708.0
2012-04-09 06:00:00	NQ	Futures	3152.0	3153.73	3150.84	3151.42	341.0
2012-04-09 07:00:00	NQ	Futures	3151.13	3154.6	3150.55	3151.71	718.0
2012-04-09 08:00:00	NQ	Futures	3152.29	3154.89	3152.0	3154.89	1851.0
2012-04-09 09:00:00	NQ	Futures	3155.18	3159.23	3145.06	3147.37	35132.0
2012-04-09 10:00:00	NQ	Futures	3147.66	3172.53	3147.08	3172.53	47122.0
2012-04-09 11:00:00	NQ	Futures	3172.24	3172.53	3158.94	3167.32	20883.0
2012-04-09 12:00:00	NQ	Futures	3167.04	3175.42	3163.85	3173.98	16624.0
2012-04-09 13:00:00	NQ	Futures	3174.27	3175.13	3167.9	3174.55	10534.0
2012-04-09 14:00:00	NQ	Futures	3174.55	3178.89	3170.79	3175.71	15719.0
2012-04-09 15:00:00	NQ	Futures	3176.0	3178.02	3164.72	3165.88	27324.0
2012-04-09 16:00:00	NQ	Futures	3165.59	3166.46	3155.47	3158.36	11777.0
2012-04-09 17:00:00	NQ	Futures	3158.65	3159.52	3158.36	3159.23	97.0
2012-04-09 18:00:00	NQ	Futures	3159.52	3161.25	3159.23	3160.09	289.0
2012-04-09 19:00:00	NQ	Futures	3160.09	3160.67	3157.78	3159.23	533.0
2012-04-09 20:00:00	NQ	Futures	3159.81	3162.7	3159.23	3162.7	314.0
2012-04-09 21:00:00	NQ	Futures	3162.7	3167.04	3161.25	3165.59	555.0
2012-04-09 22:00:00	NQ	Futures	3165.59	3167.04	3164.43	3167.04	276.0
2012-04-09 23:00:00	NQ	Futures	3166.75	3167.04	3163.85	3165.59	413.0
2012-04-09 00:00:00	YM	Futures	12811.4	12813.4	12805.4	12808.4	150.0
2012-04-09 01:00:00	YM	Futures	12809.4	12817.4	12809.4	12815.4	104.0

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

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