PREVIEW / futures_1hour / 2012-09-27

all futures 1-hour files

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

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-27 00:00:00	ES	Futures	1464.06	1464.32	1463.55	1464.32	3481.0
2012-09-27 01:00:00	ES	Futures	1464.32	1466.62	1464.06	1466.11	14288.0
2012-09-27 02:00:00	ES	Futures	1466.11	1466.62	1464.32	1464.83	10313.0
2012-09-27 03:00:00	ES	Futures	1465.08	1466.36	1463.81	1464.57	24197.0
2012-09-27 04:00:00	ES	Futures	1464.57	1465.08	1462.79	1463.55	18884.0
2012-09-27 05:00:00	ES	Futures	1463.55	1465.34	1463.04	1464.83	19051.0
2012-09-27 06:00:00	ES	Futures	1465.08	1466.36	1464.57	1465.85	18384.0
2012-09-27 07:00:00	ES	Futures	1465.85	1466.62	1464.57	1465.08	21836.0
2012-09-27 08:00:00	ES	Futures	1465.08	1466.62	1463.04	1465.34	83888.0
2012-09-27 09:00:00	ES	Futures	1465.6	1465.85	1462.02	1463.04	166241.0
2012-09-27 10:00:00	ES	Futures	1462.79	1465.6	1461.0	1464.57	243923.0
2012-09-27 11:00:00	ES	Futures	1464.32	1468.41	1461.51	1467.89	252474.0
2012-09-27 12:00:00	ES	Futures	1467.89	1473.0	1467.38	1471.47	297395.0
2012-09-27 13:00:00	ES	Futures	1471.47	1475.81	1470.96	1473.77	128187.0
2012-09-27 14:00:00	ES	Futures	1474.03	1476.07	1473.51	1473.77	85880.0
2012-09-27 15:00:00	ES	Futures	1473.51	1474.79	1471.47	1472.75	243219.0
2012-09-27 16:00:00	ES	Futures	1473.0	1473.26	1471.47	1473.0	85973.0
2012-09-27 17:00:00	ES	Futures	1472.75	1473.26	1472.75	1472.75	1361.0
2012-09-27 18:00:00	ES	Futures	1473.0	1474.28	1472.75	1474.03	2944.0
2012-09-27 19:00:00	ES	Futures	1474.03	1474.79	1473.26	1474.03	2913.0
2012-09-27 20:00:00	ES	Futures	1474.03	1474.54	1472.75	1474.28	4602.0
2012-09-27 21:00:00	ES	Futures	1474.03	1474.54	1471.98	1473.77	6512.0
2012-09-27 22:00:00	ES	Futures	1474.03	1475.05	1473.26	1473.77	4904.0
2012-09-27 23:00:00	ES	Futures	1473.77	1474.54	1472.24	1473.26	4429.0
2012-09-27 00:00:00	NQ	Futures	3235.57	3235.86	3234.41	3235.57	309.0
2012-09-27 01:00:00	NQ	Futures	3235.57	3240.51	3235.28	3240.51	1231.0
2012-09-27 02:00:00	NQ	Futures	3240.22	3241.67	3237.6	3238.47	1072.0
2012-09-27 03:00:00	NQ	Futures	3238.76	3240.8	3236.15	3238.18	1439.0
2012-09-27 04:00:00	NQ	Futures	3237.89	3238.76	3232.08	3234.41	1254.0
2012-09-27 05:00:00	NQ	Futures	3234.12	3238.47	3233.24	3237.89	649.0
2012-09-27 06:00:00	NQ	Futures	3237.6	3240.22	3236.73	3239.35	703.0
2012-09-27 07:00:00	NQ	Futures	3239.35	3241.09	3236.73	3237.02	1553.0
2012-09-27 08:00:00	NQ	Futures	3237.31	3239.93	3231.79	3235.86	7493.0
2012-09-27 09:00:00	NQ	Futures	3235.57	3236.73	3229.18	3232.95	29923.0
2012-09-27 10:00:00	NQ	Futures	3232.95	3246.32	3228.88	3243.41	40723.0
2012-09-27 11:00:00	NQ	Futures	3243.12	3254.16	3237.6	3253.87	28752.0
2012-09-27 12:00:00	NQ	Futures	3253.58	3268.98	3253.29	3264.04	35147.0
2012-09-27 13:00:00	NQ	Futures	3264.04	3275.09	3262.59	3271.02	14020.0
2012-09-27 14:00:00	NQ	Futures	3271.02	3279.15	3270.15	3272.47	14629.0
2012-09-27 15:00:00	NQ	Futures	3272.47	3277.7	3270.44	3272.18	29621.0
2012-09-27 16:00:00	NQ	Futures	3272.18	3272.47	3268.4	3271.31	7263.0
2012-09-27 17:00:00	NQ	Futures	3271.31	3271.6	3270.15	3271.02	132.0
2012-09-27 18:00:00	NQ	Futures	3271.31	3273.34	3270.73	3273.34	536.0
2012-09-27 19:00:00	NQ	Futures	3273.05	3274.21	3271.89	3273.05	266.0
2012-09-27 20:00:00	NQ	Futures	3273.05	3274.21	3270.73	3273.63	439.0
2012-09-27 21:00:00	NQ	Futures	3273.92	3274.21	3268.98	3271.89	823.0
2012-09-27 22:00:00	NQ	Futures	3271.89	3273.63	3270.15	3271.02	835.0
2012-09-27 23:00:00	NQ	Futures	3271.6	3272.47	3268.11	3270.15	613.0
2012-09-27 00:00:00	YM	Futures	13397.9	13399.9	13391.9	13397.9	415.0
2012-09-27 01:00:00	YM	Futures	13397.9	13419.9	13396.9	13417.9	1306.0

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

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