PREVIEW / futures_1hour / 2013-01-31

all futures 1-hour files

  file:    by_date/futures_1hour/2013/2013-01-31.parquet
  size:    51 KB
  rows:    1,579

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
2013-01-31 00:00:00	ES	Futures	1533.64	1534.67	1533.13	1533.9	4854.0
2013-01-31 01:00:00	ES	Futures	1534.16	1534.41	1533.39	1533.9	3772.0
2013-01-31 02:00:00	ES	Futures	1533.9	1535.44	1532.88	1534.93	11808.0
2013-01-31 03:00:00	ES	Futures	1534.93	1535.44	1533.39	1534.16	23623.0
2013-01-31 04:00:00	ES	Futures	1534.41	1534.93	1532.62	1534.41	23398.0
2013-01-31 05:00:00	ES	Futures	1534.67	1535.44	1532.62	1533.13	18063.0
2013-01-31 06:00:00	ES	Futures	1533.13	1533.39	1531.59	1533.13	20396.0
2013-01-31 07:00:00	ES	Futures	1533.13	1535.44	1532.88	1534.41	32843.0
2013-01-31 08:00:00	ES	Futures	1534.41	1534.67	1530.57	1534.41	72731.0
2013-01-31 09:00:00	ES	Futures	1534.41	1539.55	1532.62	1538.26	277787.0
2013-01-31 10:00:00	ES	Futures	1538.26	1538.52	1534.41	1534.41	245207.0
2013-01-31 11:00:00	ES	Futures	1534.41	1534.93	1531.34	1532.36	204133.0
2013-01-31 12:00:00	ES	Futures	1532.36	1536.21	1532.36	1535.7	101403.0
2013-01-31 13:00:00	ES	Futures	1535.95	1536.72	1534.41	1536.21	58715.0
2013-01-31 14:00:00	ES	Futures	1536.47	1537.75	1534.93	1536.47	78818.0
2013-01-31 15:00:00	ES	Futures	1536.72	1536.72	1532.36	1533.9	295201.0
2013-01-31 16:00:00	ES	Futures	1533.64	1535.44	1532.36	1535.18	134926.0
2013-01-31 17:00:00	ES	Futures	1535.18	1535.7	1534.93	1535.44	1886.0
2013-01-31 18:00:00	ES	Futures	1535.44	1537.49	1535.18	1537.24	8255.0
2013-01-31 19:00:00	ES	Futures	1536.98	1537.75	1536.47	1536.98	4723.0
2013-01-31 20:00:00	ES	Futures	1536.98	1537.24	1535.44	1535.7	9487.0
2013-01-31 21:00:00	ES	Futures	1535.7	1536.98	1535.18	1535.18	4868.0
2013-01-31 22:00:00	ES	Futures	1535.18	1536.21	1535.18	1535.95	3239.0
2013-01-31 23:00:00	ES	Futures	1535.95	1538.01	1535.95	1537.75	5244.0
2013-01-31 00:00:00	NQ	Futures	3180.51	3181.97	3178.77	3181.09	575.0
2013-01-31 01:00:00	NQ	Futures	3181.09	3181.68	3179.06	3179.35	729.0
2013-01-31 02:00:00	NQ	Futures	3179.06	3183.13	3177.89	3183.13	847.0
2013-01-31 03:00:00	NQ	Futures	3182.55	3183.42	3173.82	3177.31	5368.0
2013-01-31 04:00:00	NQ	Futures	3177.31	3178.77	3174.4	3178.77	2526.0
2013-01-31 05:00:00	NQ	Futures	3178.77	3180.8	3173.82	3174.69	1767.0
2013-01-31 06:00:00	NQ	Futures	3174.4	3175.56	3171.49	3174.98	2260.0
2013-01-31 07:00:00	NQ	Futures	3174.69	3178.77	3174.11	3177.89	3163.0
2013-01-31 08:00:00	NQ	Futures	3177.89	3177.89	3171.2	3175.85	6582.0
2013-01-31 09:00:00	NQ	Futures	3175.85	3197.39	3175.56	3194.48	38988.0
2013-01-31 10:00:00	NQ	Futures	3194.48	3195.94	3181.09	3181.09	35342.0
2013-01-31 11:00:00	NQ	Futures	3181.39	3181.97	3171.49	3175.27	30345.0
2013-01-31 12:00:00	NQ	Futures	3175.27	3182.84	3174.11	3181.39	14285.0
2013-01-31 13:00:00	NQ	Futures	3181.68	3182.26	3177.31	3180.51	9004.0
2013-01-31 14:00:00	NQ	Futures	3180.51	3185.17	3176.73	3181.97	14755.0
2013-01-31 15:00:00	NQ	Futures	3181.97	3182.26	3172.36	3175.56	40288.0
2013-01-31 16:00:00	NQ	Futures	3175.56	3180.8	3174.11	3179.06	7520.0
2013-01-31 17:00:00	NQ	Futures	3179.06	3181.68	3178.77	3181.68	182.0
2013-01-31 18:00:00	NQ	Futures	3181.97	3184.3	3180.51	3184.0	917.0
2013-01-31 19:00:00	NQ	Futures	3184.0	3184.88	3182.84	3183.13	319.0
2013-01-31 20:00:00	NQ	Futures	3183.71	3183.71	3179.64	3181.39	736.0
2013-01-31 21:00:00	NQ	Futures	3181.09	3184.3	3180.8	3181.39	692.0
2013-01-31 22:00:00	NQ	Futures	3181.09	3182.84	3181.09	3182.26	422.0
2013-01-31 23:00:00	NQ	Futures	3182.55	3186.04	3182.55	3185.46	554.0
2013-01-31 00:00:00	YM	Futures	13911.3	13920.4	13909.3	13916.3	269.0
2013-01-31 01:00:00	YM	Futures	13916.3	13920.4	13913.3	13915.3	268.0

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

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