PREVIEW / futures_1hour / 2012-09-14

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-09-14.parquet
  size:    41 KB
  rows:    1,173

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-14 00:00:00	ES	Futures	1486.03	1487.31	1485.52	1486.8	2092.0
2012-09-14 01:00:00	ES	Futures	1486.8	1487.82	1484.76	1485.27	5388.0
2012-09-14 02:00:00	ES	Futures	1485.27	1486.8	1484.5	1485.27	8468.0
2012-09-14 03:00:00	ES	Futures	1485.27	1487.05	1483.99	1487.05	28561.0
2012-09-14 04:00:00	ES	Futures	1486.8	1487.31	1484.76	1486.03	20989.0
2012-09-14 05:00:00	ES	Futures	1486.29	1488.84	1486.03	1488.59	19231.0
2012-09-14 06:00:00	ES	Futures	1488.33	1490.12	1487.82	1489.86	23518.0
2012-09-14 07:00:00	ES	Futures	1489.61	1490.38	1487.82	1488.08	32568.0
2012-09-14 08:00:00	ES	Futures	1488.08	1489.86	1485.27	1486.03	55835.0
2012-09-14 09:00:00	ES	Futures	1486.03	1494.72	1485.27	1492.42	256634.0
2012-09-14 10:00:00	ES	Futures	1492.42	1500.08	1492.16	1493.7	489721.0
2012-09-14 11:00:00	ES	Futures	1493.7	1494.72	1490.12	1491.14	303689.0
2012-09-14 12:00:00	ES	Futures	1491.4	1495.23	1491.14	1492.67	101058.0
2012-09-14 13:00:00	ES	Futures	1492.93	1493.19	1488.08	1491.4	124530.0
2012-09-14 14:00:00	ES	Futures	1491.14	1492.42	1489.35	1491.91	91906.0
2012-09-14 15:00:00	ES	Futures	1491.91	1491.91	1486.03	1490.63	255651.0
2012-09-14 16:00:00	ES	Futures	1490.89	1492.16	1490.12	1491.14	94324.0
2012-09-14 00:00:00	NQ	Futures	3289.32	3291.65	3288.16	3291.07	188.0
2012-09-14 01:00:00	NQ	Futures	3291.07	3292.52	3286.42	3287.29	424.0
2012-09-14 02:00:00	NQ	Futures	3288.16	3291.36	3286.13	3288.16	640.0
2012-09-14 03:00:00	NQ	Futures	3288.16	3291.07	3284.38	3290.78	1810.0
2012-09-14 04:00:00	NQ	Futures	3291.36	3291.94	3287.58	3290.78	1621.0
2012-09-14 05:00:00	NQ	Futures	3290.78	3296.59	3290.78	3296.01	1751.0
2012-09-14 06:00:00	NQ	Futures	3295.72	3299.49	3294.85	3297.46	2184.0
2012-09-14 07:00:00	NQ	Futures	3297.46	3298.62	3293.97	3294.56	1733.0
2012-09-14 08:00:00	NQ	Futures	3294.56	3297.46	3288.16	3289.91	5265.0
2012-09-14 09:00:00	NQ	Futures	3289.62	3313.73	3287.29	3308.5	40405.0
2012-09-14 10:00:00	NQ	Futures	3308.79	3323.32	3308.21	3315.48	46739.0
2012-09-14 11:00:00	NQ	Futures	3315.48	3319.25	3311.12	3313.73	30143.0
2012-09-14 12:00:00	NQ	Futures	3313.73	3323.03	3312.86	3319.84	12569.0
2012-09-14 13:00:00	NQ	Futures	3319.84	3321.0	3308.5	3311.99	16836.0
2012-09-14 14:00:00	NQ	Futures	3311.99	3318.38	3309.67	3317.22	12522.0
2012-09-14 15:00:00	NQ	Futures	3316.93	3317.51	3303.27	3311.7	29744.0
2012-09-14 16:00:00	NQ	Futures	3311.7	3315.19	3311.12	3314.02	7385.0
2012-09-14 00:00:00	YM	Futures	13487.9	13495.9	13481.9	13489.9	217.0
2012-09-14 01:00:00	YM	Futures	13493.9	13500.9	13477.9	13482.9	504.0
2012-09-14 02:00:00	YM	Futures	13483.9	13493.9	13474.9	13480.9	378.0
2012-09-14 03:00:00	YM	Futures	13481.9	13494.9	13470.9	13494.9	854.0
2012-09-14 04:00:00	YM	Futures	13495.9	13498.9	13478.9	13491.9	628.0
2012-09-14 05:00:00	YM	Futures	13491.9	13512.0	13490.9	13509.0	919.0
2012-09-14 06:00:00	YM	Futures	13506.0	13516.0	13501.9	13515.0	1266.0
2012-09-14 07:00:00	YM	Futures	13514.0	13520.0	13502.9	13505.0	1122.0
2012-09-14 08:00:00	YM	Futures	13506.0	13511.0	13481.9	13485.9	3068.0
2012-09-14 09:00:00	YM	Futures	13484.9	13548.0	13480.9	13528.0	15744.0
2012-09-14 10:00:00	YM	Futures	13528.0	13583.0	13524.0	13534.0	19979.0
2012-09-14 11:00:00	YM	Futures	13534.0	13542.0	13500.9	13512.0	15788.0
2012-09-14 12:00:00	YM	Futures	13511.0	13543.0	13510.0	13520.0	5812.0
2012-09-14 13:00:00	YM	Futures	13520.0	13523.0	13486.9	13514.0	7425.0
2012-09-14 14:00:00	YM	Futures	13513.0	13525.0	13500.9	13519.0	7910.0
2012-09-14 15:00:00	YM	Futures	13519.0	13529.0	13478.9	13525.0	16646.0

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

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