PREVIEW / futures_1hour / 2013-05-09

all futures 1-hour files

  file:    by_date/futures_1hour/2013/2013-05-09.parquet
  size:    50 KB
  rows:    1,541

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-05-09 00:00:00	ES	Futures	1678.42	1678.42	1677.13	1677.39	3220.0
2013-05-09 01:00:00	ES	Futures	1677.39	1678.16	1677.13	1677.39	3214.0
2013-05-09 02:00:00	ES	Futures	1677.65	1677.9	1676.62	1676.87	7199.0
2013-05-09 03:00:00	ES	Futures	1676.87	1677.39	1675.84	1676.1	15711.0
2013-05-09 04:00:00	ES	Futures	1676.1	1678.16	1675.59	1676.36	19668.0
2013-05-09 05:00:00	ES	Futures	1676.62	1677.9	1675.84	1677.65	14060.0
2013-05-09 06:00:00	ES	Futures	1677.65	1677.9	1676.62	1677.65	10304.0
2013-05-09 07:00:00	ES	Futures	1677.9	1677.9	1675.59	1676.36	22224.0
2013-05-09 08:00:00	ES	Futures	1676.36	1677.13	1673.53	1676.1	62398.0
2013-05-09 09:00:00	ES	Futures	1676.1	1679.45	1676.1	1678.68	219579.0
2013-05-09 10:00:00	ES	Futures	1678.68	1678.68	1673.01	1674.3	260795.0
2013-05-09 11:00:00	ES	Futures	1674.3	1676.87	1673.78	1675.84	134027.0
2013-05-09 12:00:00	ES	Futures	1675.59	1678.16	1674.04	1677.9	111042.0
2013-05-09 13:00:00	ES	Futures	1677.9	1681.77	1677.39	1681.0	170996.0
2013-05-09 14:00:00	ES	Futures	1681.0	1681.25	1671.46	1671.46	245123.0
2013-05-09 15:00:00	ES	Futures	1671.72	1675.84	1669.15	1673.53	385106.0
2013-05-09 16:00:00	ES	Futures	1673.53	1675.84	1673.01	1675.33	79752.0
2013-05-09 17:00:00	ES	Futures	1675.59	1675.84	1675.33	1675.59	2160.0
2013-05-09 18:00:00	ES	Futures	1675.33	1676.36	1675.33	1675.33	5176.0
2013-05-09 19:00:00	ES	Futures	1675.33	1676.62	1675.33	1676.1	3527.0
2013-05-09 20:00:00	ES	Futures	1675.84	1676.36	1675.33	1675.59	3924.0
2013-05-09 21:00:00	ES	Futures	1675.59	1678.68	1675.33	1678.16	8212.0
2013-05-09 22:00:00	ES	Futures	1678.16	1678.68	1676.87	1676.87	4194.0
2013-05-09 23:00:00	ES	Futures	1677.13	1677.9	1676.87	1677.9	1608.0
2013-05-09 00:00:00	NQ	Futures	3458.02	3458.02	3455.97	3456.56	144.0
2013-05-09 01:00:00	NQ	Futures	3456.56	3458.02	3456.27	3457.14	215.0
2013-05-09 02:00:00	NQ	Futures	3457.43	3457.72	3454.81	3455.97	436.0
2013-05-09 03:00:00	NQ	Futures	3455.97	3456.27	3449.85	3450.14	1647.0
2013-05-09 04:00:00	NQ	Futures	3450.14	3453.06	3448.97	3449.56	2417.0
2013-05-09 05:00:00	NQ	Futures	3449.85	3451.31	3447.81	3451.31	1300.0
2013-05-09 06:00:00	NQ	Futures	3451.02	3452.18	3449.56	3451.31	1804.0
2013-05-09 07:00:00	NQ	Futures	3451.02	3452.18	3448.1	3448.97	2343.0
2013-05-09 08:00:00	NQ	Futures	3449.27	3449.56	3441.68	3447.52	8031.0
2013-05-09 09:00:00	NQ	Futures	3447.22	3458.89	3446.93	3455.68	28066.0
2013-05-09 10:00:00	NQ	Futures	3455.97	3456.27	3446.64	3450.43	21857.0
2013-05-09 11:00:00	NQ	Futures	3450.14	3459.18	3449.56	3457.72	15288.0
2013-05-09 12:00:00	NQ	Futures	3457.72	3461.52	3453.06	3460.93	11550.0
2013-05-09 13:00:00	NQ	Futures	3461.22	3474.64	3459.77	3472.02	19066.0
2013-05-09 14:00:00	NQ	Futures	3472.31	3472.6	3451.6	3451.89	24341.0
2013-05-09 15:00:00	NQ	Futures	3451.6	3458.89	3444.6	3451.89	35626.0
2013-05-09 16:00:00	NQ	Futures	3451.6	3458.02	3451.6	3456.56	6018.0
2013-05-09 17:00:00	NQ	Futures	3456.85	3456.85	3455.39	3456.85	148.0
2013-05-09 18:00:00	NQ	Futures	3454.81	3458.02	3454.81	3455.68	266.0
2013-05-09 19:00:00	NQ	Futures	3455.68	3457.72	3455.1	3456.85	165.0
2013-05-09 20:00:00	NQ	Futures	3456.85	3457.14	3455.97	3456.56	355.0
2013-05-09 21:00:00	NQ	Futures	3456.27	3462.68	3455.97	3462.1	810.0
2013-05-09 22:00:00	NQ	Futures	3461.81	3462.97	3458.89	3459.18	451.0
2013-05-09 23:00:00	NQ	Futures	3459.18	3460.64	3459.18	3460.35	279.0
2013-05-09 00:00:00	YM	Futures	15234.9	15236.0	15226.9	15229.9	422.0
2013-05-09 01:00:00	YM	Futures	15230.9	15233.9	15226.9	15228.9	644.0

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

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