PREVIEW / futures_1hour / 2012-09-18

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-09-18.parquet
  size:    48 KB
  rows:    1,491

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-09-18 00:00:00	ES	Futures	1486.8	1488.08	1486.8	1487.82	2276.0
2012-09-18 01:00:00	ES	Futures	1487.57	1487.82	1486.03	1486.54	3330.0
2012-09-18 02:00:00	ES	Futures	1486.54	1486.8	1484.5	1485.01	8051.0
2012-09-18 03:00:00	ES	Futures	1485.27	1485.78	1482.71	1483.22	31882.0
2012-09-18 04:00:00	ES	Futures	1483.22	1483.48	1480.67	1482.71	32542.0
2012-09-18 05:00:00	ES	Futures	1482.97	1483.48	1480.67	1481.43	19744.0
2012-09-18 06:00:00	ES	Futures	1481.18	1483.22	1480.67	1483.22	13435.0
2012-09-18 07:00:00	ES	Futures	1482.97	1485.01	1482.46	1484.76	30333.0
2012-09-18 08:00:00	ES	Futures	1484.5	1486.54	1482.71	1485.27	42806.0
2012-09-18 09:00:00	ES	Futures	1485.01	1485.52	1481.18	1483.99	169168.0
2012-09-18 10:00:00	ES	Futures	1483.99	1485.52	1482.46	1485.52	198426.0
2012-09-18 11:00:00	ES	Futures	1485.52	1487.05	1483.73	1484.5	165131.0
2012-09-18 12:00:00	ES	Futures	1484.24	1484.76	1481.69	1483.48	96749.0
2012-09-18 13:00:00	ES	Futures	1483.48	1484.5	1481.43	1482.2	77451.0
2012-09-18 14:00:00	ES	Futures	1482.2	1483.73	1481.69	1482.71	67555.0
2012-09-18 15:00:00	ES	Futures	1482.71	1485.52	1482.46	1485.01	155652.0
2012-09-18 16:00:00	ES	Futures	1485.01	1486.8	1484.24	1486.54	65430.0
2012-09-18 17:00:00	ES	Futures	1486.54	1486.8	1486.03	1486.54	1338.0
2012-09-18 18:00:00	ES	Futures	1486.54	1486.54	1486.03	1486.03	1383.0
2012-09-18 19:00:00	ES	Futures	1486.29	1486.54	1485.78	1486.29	1635.0
2012-09-18 20:00:00	ES	Futures	1486.29	1486.54	1485.01	1486.03	4658.0
2012-09-18 21:00:00	ES	Futures	1486.03	1486.29	1485.01	1486.03	3020.0
2012-09-18 22:00:00	ES	Futures	1485.78	1486.54	1485.52	1486.03	1732.0
2012-09-18 23:00:00	ES	Futures	1486.03	1490.12	1486.03	1488.84	12182.0
2012-09-18 00:00:00	NQ	Futures	3312.57	3314.9	3312.28	3314.31	156.0
2012-09-18 01:00:00	NQ	Futures	3314.02	3314.02	3310.25	3310.25	146.0
2012-09-18 02:00:00	NQ	Futures	3311.12	3311.12	3307.92	3308.5	837.0
2012-09-18 03:00:00	NQ	Futures	3308.5	3310.83	3304.14	3305.02	2245.0
2012-09-18 04:00:00	NQ	Futures	3305.02	3305.31	3299.79	3304.43	2704.0
2012-09-18 05:00:00	NQ	Futures	3304.43	3304.43	3299.2	3300.37	1390.0
2012-09-18 06:00:00	NQ	Futures	3300.08	3304.43	3298.91	3304.14	1203.0
2012-09-18 07:00:00	NQ	Futures	3303.56	3307.34	3302.69	3306.76	2003.0
2012-09-18 08:00:00	NQ	Futures	3307.05	3310.25	3303.27	3307.05	3087.0
2012-09-18 09:00:00	NQ	Futures	3307.05	3315.48	3303.85	3313.73	26512.0
2012-09-18 10:00:00	NQ	Futures	3314.31	3317.51	3308.21	3313.73	25642.0
2012-09-18 11:00:00	NQ	Futures	3314.02	3317.22	3312.28	3313.44	16636.0
2012-09-18 12:00:00	NQ	Futures	3313.15	3314.6	3306.76	3310.83	13572.0
2012-09-18 13:00:00	NQ	Futures	3310.83	3314.02	3307.34	3310.25	12065.0
2012-09-18 14:00:00	NQ	Futures	3310.25	3314.02	3309.37	3311.7	8883.0
2012-09-18 15:00:00	NQ	Futures	3311.7	3316.06	3310.54	3315.77	21637.0
2012-09-18 16:00:00	NQ	Futures	3315.77	3317.8	3312.57	3317.22	5638.0
2012-09-18 17:00:00	NQ	Futures	3316.93	3317.8	3316.35	3317.51	191.0
2012-09-18 18:00:00	NQ	Futures	3317.8	3317.8	3316.35	3317.51	303.0
2012-09-18 19:00:00	NQ	Futures	3316.93	3318.09	3316.93	3317.51	173.0
2012-09-18 20:00:00	NQ	Futures	3317.22	3317.51	3314.02	3316.35	485.0
2012-09-18 21:00:00	NQ	Futures	3316.35	3317.22	3314.6	3316.35	372.0
2012-09-18 22:00:00	NQ	Futures	3316.06	3317.22	3315.48	3316.93	136.0
2012-09-18 23:00:00	NQ	Futures	3316.93	3325.94	3316.64	3322.45	1613.0
2012-09-18 00:00:00	YM	Futures	13489.9	13497.9	13488.9	13494.9	120.0
2012-09-18 01:00:00	YM	Futures	13494.9	13495.9	13483.9	13484.9	179.0

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

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