PREVIEW / futures_1hour / 2013-03-04

all futures 1-hour files

  file:    by_date/futures_1hour/2013/2013-03-04.parquet
  size:    48 KB
  rows:    1,482

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
2013-03-04 00:00:00	ES	Futures	1547.76	1549.81	1547.24	1549.04	8215.0
2013-03-04 01:00:00	ES	Futures	1549.04	1550.32	1547.76	1548.78	7204.0
2013-03-04 02:00:00	ES	Futures	1548.78	1549.55	1546.73	1549.04	13915.0
2013-03-04 03:00:00	ES	Futures	1549.04	1551.09	1548.27	1550.58	35600.0
2013-03-04 04:00:00	ES	Futures	1550.58	1552.89	1550.58	1551.61	30631.0
2013-03-04 05:00:00	ES	Futures	1551.35	1552.38	1550.07	1551.09	13833.0
2013-03-04 06:00:00	ES	Futures	1551.09	1551.86	1549.04	1551.35	25133.0
2013-03-04 07:00:00	ES	Futures	1551.61	1556.48	1550.32	1554.43	55972.0
2013-03-04 08:00:00	ES	Futures	1554.43	1555.46	1553.66	1553.92	37832.0
2013-03-04 09:00:00	ES	Futures	1553.92	1556.48	1551.35	1554.69	258890.0
2013-03-04 10:00:00	ES	Futures	1554.43	1556.74	1552.12	1555.46	257140.0
2013-03-04 11:00:00	ES	Futures	1555.46	1557.76	1553.66	1556.74	217564.0
2013-03-04 12:00:00	ES	Futures	1556.74	1556.99	1550.32	1553.66	186794.0
2013-03-04 13:00:00	ES	Futures	1553.92	1558.53	1552.12	1557.76	159840.0
2013-03-04 14:00:00	ES	Futures	1557.76	1563.67	1556.48	1562.9	226076.0
2013-03-04 15:00:00	ES	Futures	1562.9	1564.44	1560.59	1564.18	192801.0
2013-03-04 16:00:00	ES	Futures	1564.44	1567.26	1564.18	1567.26	113842.0
2013-03-04 17:00:00	ES	Futures	1567.26	1567.77	1566.49	1567.77	4742.0
2013-03-04 18:00:00	ES	Futures	1567.0	1567.51	1566.23	1566.75	7501.0
2013-03-04 19:00:00	ES	Futures	1567.0	1567.26	1566.23	1567.0	4469.0
2013-03-04 20:00:00	ES	Futures	1566.75	1567.77	1566.49	1567.0	4764.0
2013-03-04 21:00:00	ES	Futures	1566.75	1567.0	1565.21	1565.98	5649.0
2013-03-04 22:00:00	ES	Futures	1565.98	1566.23	1564.95	1565.72	4479.0
2013-03-04 23:00:00	ES	Futures	1565.46	1565.98	1565.46	1565.72	1527.0
2013-03-04 00:00:00	NQ	Futures	3183.13	3187.21	3182.26	3185.75	534.0
2013-03-04 01:00:00	NQ	Futures	3186.04	3187.79	3181.68	3184.0	718.0
2013-03-04 02:00:00	NQ	Futures	3184.0	3186.33	3181.97	3185.75	1529.0
2013-03-04 03:00:00	NQ	Futures	3185.46	3190.7	3183.13	3189.83	3620.0
2013-03-04 04:00:00	NQ	Futures	3189.83	3194.48	3189.53	3190.12	1841.0
2013-03-04 05:00:00	NQ	Futures	3190.12	3192.74	3187.21	3188.95	1571.0
2013-03-04 06:00:00	NQ	Futures	3188.66	3188.95	3182.26	3185.75	2863.0
2013-03-04 07:00:00	NQ	Futures	3186.04	3195.36	3184.59	3193.32	2949.0
2013-03-04 08:00:00	NQ	Futures	3193.32	3194.48	3189.83	3190.7	3640.0
2013-03-04 09:00:00	NQ	Futures	3190.41	3197.68	3185.17	3189.53	46748.0
2013-03-04 10:00:00	NQ	Futures	3189.53	3196.81	3182.55	3194.77	41308.0
2013-03-04 11:00:00	NQ	Futures	3194.77	3200.89	3189.24	3197.68	33892.0
2013-03-04 12:00:00	NQ	Futures	3197.98	3198.85	3182.84	3190.12	20798.0
2013-03-04 13:00:00	NQ	Futures	3190.12	3202.63	3186.33	3200.3	20366.0
2013-03-04 14:00:00	NQ	Futures	3200.3	3211.95	3197.1	3210.49	23972.0
2013-03-04 15:00:00	NQ	Futures	3210.49	3212.24	3206.13	3211.66	21551.0
2013-03-04 16:00:00	NQ	Futures	3211.07	3217.48	3211.07	3217.48	8442.0
2013-03-04 17:00:00	NQ	Futures	3217.48	3217.77	3216.6	3217.77	205.0
2013-03-04 18:00:00	NQ	Futures	3216.31	3218.06	3216.02	3217.77	346.0
2013-03-04 19:00:00	NQ	Futures	3218.06	3218.64	3216.31	3217.19	299.0
2013-03-04 20:00:00	NQ	Futures	3217.19	3217.77	3216.6	3216.9	335.0
2013-03-04 21:00:00	NQ	Futures	3217.19	3217.77	3214.57	3216.9	543.0
2013-03-04 22:00:00	NQ	Futures	3216.9	3217.19	3215.73	3216.9	344.0
2013-03-04 23:00:00	NQ	Futures	3216.9	3217.48	3216.31	3216.9	126.0
2013-03-04 00:00:00	YM	Futures	14091.4	14111.5	14088.4	14104.5	1108.0
2013-03-04 01:00:00	YM	Futures	14104.5	14110.5	14088.4	14097.4	919.0

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

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