PREVIEW / futures_1hour / 2013-07-22

all futures 1-hour files

  file:    by_date/futures_1hour/2013/2013-07-22.parquet
  size:    47 KB
  rows:    1,475

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-07-22 00:00:00	ES	Futures	1748.98	1749.23	1748.46	1748.46	1343.0
2013-07-22 01:00:00	ES	Futures	1748.46	1749.23	1747.94	1748.72	2631.0
2013-07-22 02:00:00	ES	Futures	1748.98	1749.23	1747.94	1747.94	4810.0
2013-07-22 03:00:00	ES	Futures	1747.94	1748.72	1745.62	1746.13	21948.0
2013-07-22 04:00:00	ES	Futures	1746.13	1750.53	1746.13	1749.23	17541.0
2013-07-22 05:00:00	ES	Futures	1749.49	1749.49	1748.46	1749.23	6658.0
2013-07-22 06:00:00	ES	Futures	1749.23	1749.49	1746.91	1747.68	11063.0
2013-07-22 07:00:00	ES	Futures	1747.94	1749.49	1747.17	1748.2	15431.0
2013-07-22 08:00:00	ES	Futures	1748.2	1748.2	1746.13	1746.91	29011.0
2013-07-22 09:00:00	ES	Futures	1746.65	1747.94	1743.29	1743.81	148259.0
2013-07-22 10:00:00	ES	Futures	1743.81	1747.42	1742.77	1746.65	163371.0
2013-07-22 11:00:00	ES	Futures	1746.39	1750.53	1746.39	1747.94	121048.0
2013-07-22 12:00:00	ES	Futures	1747.68	1749.49	1747.42	1748.2	46083.0
2013-07-22 13:00:00	ES	Futures	1748.2	1748.98	1745.36	1746.39	58660.0
2013-07-22 14:00:00	ES	Futures	1746.65	1749.23	1745.87	1748.98	60635.0
2013-07-22 15:00:00	ES	Futures	1748.98	1749.23	1745.62	1747.94	99844.0
2013-07-22 16:00:00	ES	Futures	1748.2	1748.72	1747.68	1748.2	47931.0
2013-07-22 17:00:00	ES	Futures	1747.94	1748.46	1747.68	1747.94	1333.0
2013-07-22 18:00:00	ES	Futures	1747.94	1750.01	1747.68	1749.23	4399.0
2013-07-22 19:00:00	ES	Futures	1749.23	1749.75	1748.72	1749.23	1488.0
2013-07-22 20:00:00	ES	Futures	1749.23	1750.01	1748.46	1749.49	4018.0
2013-07-22 21:00:00	ES	Futures	1749.23	1751.3	1748.98	1751.04	4163.0
2013-07-22 22:00:00	ES	Futures	1750.79	1751.82	1750.27	1751.56	5298.0
2013-07-22 23:00:00	ES	Futures	1751.56	1752.59	1751.3	1752.34	6205.0
2013-07-22 00:00:00	NQ	Futures	3563.23	3564.11	3562.36	3562.65	204.0
2013-07-22 01:00:00	NQ	Futures	3562.65	3563.23	3561.48	3562.94	374.0
2013-07-22 02:00:00	NQ	Futures	3562.94	3563.52	3560.89	3560.89	707.0
2013-07-22 03:00:00	NQ	Futures	3560.6	3561.19	3553.88	3555.34	2976.0
2013-07-22 04:00:00	NQ	Futures	3555.93	3565.86	3555.34	3564.11	2742.0
2013-07-22 05:00:00	NQ	Futures	3564.11	3564.4	3562.65	3562.94	1091.0
2013-07-22 06:00:00	NQ	Futures	3563.23	3563.23	3557.68	3558.85	1102.0
2013-07-22 07:00:00	NQ	Futures	3558.85	3562.65	3558.26	3560.31	1766.0
2013-07-22 08:00:00	NQ	Futures	3560.31	3560.89	3555.93	3557.68	3998.0
2013-07-22 09:00:00	NQ	Futures	3557.97	3571.41	3551.83	3553.59	32953.0
2013-07-22 10:00:00	NQ	Futures	3553.3	3564.4	3553.0	3561.48	22187.0
2013-07-22 11:00:00	NQ	Futures	3561.19	3567.62	3561.19	3562.65	12612.0
2013-07-22 12:00:00	NQ	Futures	3562.65	3566.45	3562.06	3563.82	6617.0
2013-07-22 13:00:00	NQ	Futures	3563.82	3565.28	3552.71	3557.68	12536.0
2013-07-22 14:00:00	NQ	Futures	3557.68	3567.32	3557.09	3567.32	13728.0
2013-07-22 15:00:00	NQ	Futures	3567.03	3567.03	3559.73	3563.52	15237.0
2013-07-22 16:00:00	NQ	Futures	3563.52	3564.99	3562.36	3564.11	4143.0
2013-07-22 17:00:00	NQ	Futures	3564.11	3565.28	3563.82	3565.28	88.0
2013-07-22 18:00:00	NQ	Futures	3564.4	3569.66	3564.4	3569.08	594.0
2013-07-22 19:00:00	NQ	Futures	3568.49	3569.37	3567.91	3568.2	223.0
2013-07-22 20:00:00	NQ	Futures	3567.62	3569.95	3567.03	3568.2	394.0
2013-07-22 21:00:00	NQ	Futures	3568.49	3573.17	3567.91	3572.88	689.0
2013-07-22 22:00:00	NQ	Futures	3572.88	3573.75	3571.41	3573.17	545.0
2013-07-22 23:00:00	NQ	Futures	3573.17	3575.21	3573.17	3574.92	487.0
2013-07-22 00:00:00	YM	Futures	15766.4	15767.4	15760.3	15761.3	134.0
2013-07-22 01:00:00	YM	Futures	15761.3	15767.4	15758.3	15765.4	341.0

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

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