PREVIEW / futures_1hour / 2012-09-21

all futures 1-hour files

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

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-21 00:00:00	ES	Futures	1488.59	1490.38	1488.33	1489.61	3412.0
2012-09-21 01:00:00	ES	Futures	1489.61	1492.16	1489.35	1490.89	9465.0
2012-09-21 02:00:00	ES	Futures	1490.89	1490.89	1489.35	1489.61	9840.0
2012-09-21 03:00:00	ES	Futures	1489.61	1490.63	1488.33	1490.12	31300.0
2012-09-21 04:00:00	ES	Futures	1490.12	1491.4	1488.59	1491.4	30581.0
2012-09-21 05:00:00	ES	Futures	1491.4	1491.65	1488.33	1489.35	36584.0
2012-09-21 06:00:00	ES	Futures	1489.35	1489.61	1487.05	1487.57	19960.0
2012-09-21 07:00:00	ES	Futures	1487.57	1490.63	1487.57	1489.61	55102.0
2012-09-21 08:00:00	ES	Futures	1489.61	1491.65	1489.1	1491.65	57385.0
2012-09-21 09:00:00	ES	Futures	1491.4	1494.21	1489.86	1491.65	267646.0
2012-09-21 10:00:00	ES	Futures	1491.4	1492.16	1488.59	1488.84	209817.0
2012-09-21 11:00:00	ES	Futures	1488.84	1490.63	1488.08	1489.86	189201.0
2012-09-21 12:00:00	ES	Futures	1489.86	1490.38	1487.82	1489.1	85490.0
2012-09-21 13:00:00	ES	Futures	1488.84	1489.86	1488.33	1489.35	62781.0
2012-09-21 14:00:00	ES	Futures	1489.35	1489.35	1486.29	1487.31	97344.0
2012-09-21 15:00:00	ES	Futures	1487.31	1488.33	1484.24	1484.76	237315.0
2012-09-21 16:00:00	ES	Futures	1485.01	1485.78	1482.2	1483.22	123782.0
2012-09-21 00:00:00	NQ	Futures	3323.61	3326.52	3323.32	3324.48	486.0
2012-09-21 01:00:00	NQ	Futures	3325.07	3330.01	3325.07	3327.39	678.0
2012-09-21 02:00:00	NQ	Futures	3327.39	3327.39	3323.61	3323.9	617.0
2012-09-21 03:00:00	NQ	Futures	3324.19	3326.81	3321.58	3326.23	2300.0
2012-09-21 04:00:00	NQ	Futures	3325.94	3328.55	3322.45	3328.55	1771.0
2012-09-21 05:00:00	NQ	Futures	3328.55	3329.13	3322.74	3325.07	1864.0
2012-09-21 06:00:00	NQ	Futures	3325.07	3325.07	3320.13	3321.0	1465.0
2012-09-21 07:00:00	NQ	Futures	3321.0	3327.68	3321.0	3325.94	2736.0
2012-09-21 08:00:00	NQ	Futures	3325.65	3332.33	3325.07	3332.04	5851.0
2012-09-21 09:00:00	NQ	Futures	3332.04	3337.85	3331.46	3334.95	34696.0
2012-09-21 10:00:00	NQ	Futures	3334.95	3336.11	3330.3	3330.59	23043.0
2012-09-21 11:00:00	NQ	Futures	3330.59	3332.33	3327.97	3330.88	18260.0
2012-09-21 12:00:00	NQ	Futures	3330.88	3333.2	3327.1	3332.04	10326.0
2012-09-21 13:00:00	NQ	Futures	3332.04	3333.2	3327.97	3328.55	9749.0
2012-09-21 14:00:00	NQ	Futures	3328.55	3328.84	3318.96	3322.45	15843.0
2012-09-21 15:00:00	NQ	Futures	3322.16	3325.94	3316.35	3320.13	26486.0
2012-09-21 16:00:00	NQ	Futures	3320.42	3322.45	3315.19	3316.64	8548.0
2012-09-21 00:00:00	YM	Futures	13558.0	13571.0	13556.0	13566.0	760.0
2012-09-21 01:00:00	YM	Futures	13566.0	13586.0	13566.0	13574.0	1004.0
2012-09-21 02:00:00	YM	Futures	13574.0	13578.0	13565.0	13567.0	1244.0
2012-09-21 03:00:00	YM	Futures	13566.0	13577.0	13561.0	13573.0	2049.0
2012-09-21 04:00:00	YM	Futures	13573.0	13583.0	13560.0	13583.0	1555.0
2012-09-21 05:00:00	YM	Futures	13584.0	13586.0	13558.0	13564.0	1542.0
2012-09-21 06:00:00	YM	Futures	13563.0	13564.0	13547.0	13550.0	1395.0
2012-09-21 07:00:00	YM	Futures	13550.0	13575.0	13550.0	13567.0	2420.0
2012-09-21 08:00:00	YM	Futures	13565.0	13582.0	13563.0	13579.0	3792.0
2012-09-21 09:00:00	YM	Futures	13579.0	13595.0	13548.0	13568.0	16840.0
2012-09-21 10:00:00	YM	Futures	13567.0	13579.0	13549.0	13553.0	12881.0
2012-09-21 11:00:00	YM	Futures	13553.0	13572.0	13543.0	13567.0	11469.0
2012-09-21 12:00:00	YM	Futures	13567.0	13574.0	13549.0	13555.0	5168.0
2012-09-21 13:00:00	YM	Futures	13556.0	13563.0	13551.0	13560.0	3942.0
2012-09-21 14:00:00	YM	Futures	13561.0	13561.0	13539.0	13542.0	6187.0
2012-09-21 15:00:00	YM	Futures	13541.0	13548.0	13502.9	13511.0	11500.0

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

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