PREVIEW / futures_1hour / 2012-12-07

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-12-07.parquet
  size:    40 KB
  rows:    1,212

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-12-07 00:00:00	ES	Futures	1444.39	1445.41	1444.14	1444.39	3121.0
2012-12-07 01:00:00	ES	Futures	1444.39	1445.16	1444.14	1444.14	1792.0
2012-12-07 02:00:00	ES	Futures	1444.14	1444.9	1442.35	1442.6	7752.0
2012-12-07 03:00:00	ES	Futures	1442.35	1444.14	1440.82	1443.37	32336.0
2012-12-07 04:00:00	ES	Futures	1443.37	1443.88	1441.33	1442.86	19451.0
2012-12-07 05:00:00	ES	Futures	1442.6	1443.88	1442.09	1442.35	14621.0
2012-12-07 06:00:00	ES	Futures	1442.35	1443.11	1441.07	1442.86	13778.0
2012-12-07 07:00:00	ES	Futures	1442.86	1443.37	1439.54	1440.3	27479.0
2012-12-07 08:00:00	ES	Futures	1440.56	1453.33	1439.28	1449.76	161982.0
2012-12-07 09:00:00	ES	Futures	1449.76	1451.03	1444.14	1445.16	250811.0
2012-12-07 10:00:00	ES	Futures	1445.41	1448.73	1442.09	1443.37	311357.0
2012-12-07 11:00:00	ES	Futures	1443.63	1445.67	1440.3	1442.6	289053.0
2012-12-07 12:00:00	ES	Futures	1442.6	1445.41	1442.09	1444.65	102875.0
2012-12-07 13:00:00	ES	Futures	1444.9	1446.69	1444.39	1444.9	86393.0
2012-12-07 14:00:00	ES	Futures	1445.16	1447.97	1444.39	1446.44	89791.0
2012-12-07 15:00:00	ES	Futures	1446.18	1448.48	1444.65	1447.97	210346.0
2012-12-07 16:00:00	ES	Futures	1447.97	1448.22	1446.18	1447.97	68691.0
2012-12-07 17:00:00	ES	Futures	1447.97	1448.48	1447.46	1448.22	762.0
2012-12-07 00:00:00	NQ	Futures	3086.21	3088.25	3086.21	3086.21	233.0
2012-12-07 01:00:00	NQ	Futures	3086.21	3087.08	3084.47	3084.76	704.0
2012-12-07 02:00:00	NQ	Futures	3084.76	3086.21	3080.4	3080.69	1466.0
2012-12-07 03:00:00	NQ	Futures	3080.69	3082.72	3076.04	3080.69	4921.0
2012-12-07 04:00:00	NQ	Futures	3080.98	3083.02	3077.2	3080.69	2702.0
2012-12-07 05:00:00	NQ	Futures	3080.98	3083.6	3079.82	3080.98	1853.0
2012-12-07 06:00:00	NQ	Futures	3080.98	3082.72	3079.24	3082.14	1727.0
2012-12-07 07:00:00	NQ	Futures	3082.14	3082.43	3078.37	3080.4	2689.0
2012-12-07 08:00:00	NQ	Futures	3080.11	3107.13	3076.91	3100.74	18158.0
2012-12-07 09:00:00	NQ	Futures	3100.74	3104.52	3076.62	3077.49	44824.0
2012-12-07 10:00:00	NQ	Futures	3077.49	3089.99	3066.45	3069.36	62805.0
2012-12-07 11:00:00	NQ	Futures	3069.36	3072.85	3058.03	3058.9	44628.0
2012-12-07 12:00:00	NQ	Futures	3059.19	3067.61	3056.28	3063.84	21441.0
2012-12-07 13:00:00	NQ	Futures	3063.84	3067.32	3058.9	3062.97	15750.0
2012-12-07 14:00:00	NQ	Futures	3062.97	3073.43	3060.06	3067.61	16316.0
2012-12-07 15:00:00	NQ	Futures	3067.61	3071.39	3060.06	3066.74	26940.0
2012-12-07 16:00:00	NQ	Futures	3067.03	3068.49	3064.42	3065.29	4782.0
2012-12-07 17:00:00	NQ	Futures	3065.0	3066.16	3064.13	3065.58	52.0
2012-12-07 00:00:00	YM	Futures	13075.7	13085.7	13075.7	13084.7	601.0
2012-12-07 01:00:00	YM	Futures	13084.7	13086.7	13079.7	13079.7	224.0
2012-12-07 02:00:00	YM	Futures	13079.7	13084.7	13065.7	13069.7	956.0
2012-12-07 03:00:00	YM	Futures	13069.7	13077.7	13053.7	13073.7	2725.0
2012-12-07 04:00:00	YM	Futures	13073.7	13077.7	13058.7	13068.7	1411.0
2012-12-07 05:00:00	YM	Futures	13067.7	13071.7	13056.7	13059.7	1412.0
2012-12-07 06:00:00	YM	Futures	13058.7	13064.7	13050.7	13060.7	1632.0
2012-12-07 07:00:00	YM	Futures	13059.7	13060.7	13043.7	13049.7	2246.0
2012-12-07 08:00:00	YM	Futures	13049.7	13150.8	13043.7	13130.8	14388.0
2012-12-07 09:00:00	YM	Futures	13130.8	13146.8	13103.7	13112.7	21137.0
2012-12-07 10:00:00	YM	Futures	13113.7	13139.8	13091.7	13103.7	27610.0
2012-12-07 11:00:00	YM	Futures	13103.7	13124.8	13080.7	13103.7	21952.0
2012-12-07 12:00:00	YM	Futures	13104.7	13129.8	13100.7	13122.8	6854.0
2012-12-07 13:00:00	YM	Futures	13123.8	13141.8	13120.8	13125.8	7939.0

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

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