PREVIEW / futures_1hour / 2012-09-19

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-09-19.parquet
  size:    49 KB
  rows:    1,507

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-19 00:00:00	ES	Futures	1488.84	1490.89	1488.59	1490.38	8985.0
2012-09-19 01:00:00	ES	Futures	1490.63	1490.89	1489.35	1490.63	4790.0
2012-09-19 02:00:00	ES	Futures	1490.63	1490.89	1489.1	1489.35	7254.0
2012-09-19 03:00:00	ES	Futures	1489.1	1491.14	1488.84	1488.84	24588.0
2012-09-19 04:00:00	ES	Futures	1488.59	1489.86	1485.52	1486.29	32840.0
2012-09-19 05:00:00	ES	Futures	1486.03	1487.82	1486.03	1486.54	20963.0
2012-09-19 06:00:00	ES	Futures	1486.54	1487.57	1486.03	1486.54	13180.0
2012-09-19 07:00:00	ES	Futures	1486.54	1486.8	1485.27	1485.78	25098.0
2012-09-19 08:00:00	ES	Futures	1485.52	1487.57	1485.27	1487.31	43947.0
2012-09-19 09:00:00	ES	Futures	1487.57	1488.08	1482.97	1483.99	172826.0
2012-09-19 10:00:00	ES	Futures	1483.99	1488.84	1483.73	1485.78	254282.0
2012-09-19 11:00:00	ES	Futures	1485.78	1489.86	1485.27	1488.84	191334.0
2012-09-19 12:00:00	ES	Futures	1488.84	1490.89	1487.82	1489.86	123927.0
2012-09-19 13:00:00	ES	Futures	1490.12	1490.38	1487.57	1488.59	53086.0
2012-09-19 14:00:00	ES	Futures	1488.33	1490.38	1488.33	1490.38	46309.0
2012-09-19 15:00:00	ES	Futures	1490.12	1490.89	1486.03	1486.03	188208.0
2012-09-19 16:00:00	ES	Futures	1486.29	1487.05	1482.97	1483.73	89090.0
2012-09-19 17:00:00	ES	Futures	1483.73	1484.5	1483.48	1484.24	1308.0
2012-09-19 18:00:00	ES	Futures	1483.99	1485.27	1483.73	1485.27	3368.0
2012-09-19 19:00:00	ES	Futures	1485.01	1485.52	1484.5	1484.5	2182.0
2012-09-19 20:00:00	ES	Futures	1484.76	1485.78	1483.48	1485.27	5073.0
2012-09-19 21:00:00	ES	Futures	1485.27	1485.78	1483.73	1483.99	3024.0
2012-09-19 22:00:00	ES	Futures	1484.24	1484.24	1482.2	1482.46	6670.0
2012-09-19 23:00:00	ES	Futures	1482.46	1482.71	1480.92	1481.43	8862.0
2012-09-19 00:00:00	NQ	Futures	3323.32	3327.39	3322.74	3325.65	494.0
2012-09-19 01:00:00	NQ	Futures	3325.65	3326.52	3323.61	3326.23	371.0
2012-09-19 02:00:00	NQ	Futures	3326.23	3326.52	3323.9	3325.07	1091.0
2012-09-19 03:00:00	NQ	Futures	3324.78	3327.39	3323.32	3323.32	2676.0
2012-09-19 04:00:00	NQ	Futures	3323.03	3325.65	3317.8	3319.54	2332.0
2012-09-19 05:00:00	NQ	Futures	3319.54	3322.74	3318.96	3319.84	1296.0
2012-09-19 06:00:00	NQ	Futures	3319.84	3321.0	3318.67	3319.84	957.0
2012-09-19 07:00:00	NQ	Futures	3319.54	3320.42	3316.35	3317.22	2255.0
2012-09-19 08:00:00	NQ	Futures	3317.51	3320.71	3316.06	3318.67	4480.0
2012-09-19 09:00:00	NQ	Futures	3318.67	3319.54	3307.92	3313.44	24147.0
2012-09-19 10:00:00	NQ	Futures	3313.73	3320.13	3306.47	3314.02	35827.0
2012-09-19 11:00:00	NQ	Futures	3314.02	3323.9	3313.15	3320.42	21907.0
2012-09-19 12:00:00	NQ	Futures	3320.42	3327.1	3318.67	3325.07	24552.0
2012-09-19 13:00:00	NQ	Futures	3324.78	3325.94	3321.0	3324.19	9077.0
2012-09-19 14:00:00	NQ	Futures	3323.9	3330.01	3323.03	3329.42	10040.0
2012-09-19 15:00:00	NQ	Futures	3329.42	3331.46	3322.16	3322.45	21788.0
2012-09-19 16:00:00	NQ	Futures	3322.45	3323.61	3316.06	3316.93	7688.0
2012-09-19 17:00:00	NQ	Futures	3317.22	3318.38	3317.22	3317.8	41.0
2012-09-19 18:00:00	NQ	Futures	3317.51	3321.0	3317.51	3321.0	130.0
2012-09-19 19:00:00	NQ	Futures	3321.29	3321.87	3318.67	3318.67	301.0
2012-09-19 20:00:00	NQ	Futures	3318.38	3319.54	3316.35	3318.96	530.0
2012-09-19 21:00:00	NQ	Futures	3318.96	3320.13	3315.77	3316.35	452.0
2012-09-19 22:00:00	NQ	Futures	3316.06	3316.64	3313.15	3314.02	526.0
2012-09-19 23:00:00	NQ	Futures	3313.73	3314.02	3310.83	3311.41	418.0
2012-09-19 00:00:00	YM	Futures	13543.0	13564.0	13543.0	13561.0	2976.0
2012-09-19 01:00:00	YM	Futures	13560.0	13564.0	13551.0	13562.0	1075.0

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

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