PREVIEW / futures_1hour / 2013-07-05

all futures 1-hour files

  file:    by_date/futures_1hour/2013/2013-07-05.parquet
  size:    41 KB
  rows:    1,147

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-05 00:00:00	ES	Futures	1679.44	1679.96	1678.92	1679.18	2435.0
2013-07-05 01:00:00	ES	Futures	1679.18	1680.22	1679.18	1680.22	2322.0
2013-07-05 02:00:00	ES	Futures	1679.96	1680.99	1679.44	1679.96	5826.0
2013-07-05 03:00:00	ES	Futures	1679.7	1682.03	1678.41	1681.25	26461.0
2013-07-05 04:00:00	ES	Futures	1680.99	1681.25	1677.63	1678.92	14113.0
2013-07-05 05:00:00	ES	Futures	1678.92	1679.7	1677.89	1678.67	12324.0
2013-07-05 06:00:00	ES	Futures	1678.41	1679.96	1677.63	1678.15	12171.0
2013-07-05 07:00:00	ES	Futures	1678.15	1678.41	1675.3	1676.6	25755.0
2013-07-05 08:00:00	ES	Futures	1676.6	1686.16	1675.82	1678.41	181597.0
2013-07-05 09:00:00	ES	Futures	1678.67	1678.67	1670.91	1671.43	289472.0
2013-07-05 10:00:00	ES	Futures	1671.43	1672.2	1662.9	1669.1	286053.0
2013-07-05 11:00:00	ES	Futures	1669.1	1673.75	1665.48	1673.24	129130.0
2013-07-05 12:00:00	ES	Futures	1673.24	1675.82	1672.98	1674.27	104636.0
2013-07-05 13:00:00	ES	Futures	1674.53	1676.08	1671.94	1674.27	73496.0
2013-07-05 14:00:00	ES	Futures	1674.01	1679.7	1674.01	1677.63	115717.0
2013-07-05 15:00:00	ES	Futures	1677.37	1681.51	1672.46	1680.47	152995.0
2013-07-05 16:00:00	ES	Futures	1680.47	1684.61	1679.96	1684.61	84516.0
2013-07-05 17:00:00	ES	Futures	1684.61	1684.87	1684.09	1684.61	2629.0
2013-07-05 00:00:00	NQ	Futures	3467.38	3468.55	3466.79	3466.79	193.0
2013-07-05 01:00:00	NQ	Futures	3467.09	3469.13	3466.5	3468.55	185.0
2013-07-05 02:00:00	NQ	Futures	3468.55	3470.59	3467.09	3467.09	645.0
2013-07-05 03:00:00	NQ	Futures	3467.09	3471.47	3464.46	3470.59	3757.0
2013-07-05 04:00:00	NQ	Futures	3470.3	3470.59	3464.16	3466.21	2319.0
2013-07-05 05:00:00	NQ	Futures	3466.5	3467.09	3462.99	3465.04	1935.0
2013-07-05 06:00:00	NQ	Futures	3465.04	3468.26	3463.87	3464.16	1704.0
2013-07-05 07:00:00	NQ	Futures	3463.87	3465.04	3460.07	3460.95	2210.0
2013-07-05 08:00:00	NQ	Futures	3460.95	3473.22	3456.27	3458.9	17936.0
2013-07-05 09:00:00	NQ	Futures	3458.9	3459.49	3442.83	3444.0	37041.0
2013-07-05 10:00:00	NQ	Futures	3444.0	3446.34	3422.37	3439.91	48881.0
2013-07-05 11:00:00	NQ	Futures	3439.91	3447.51	3432.6	3447.21	22458.0
2013-07-05 12:00:00	NQ	Futures	3447.51	3453.06	3446.05	3447.51	15370.0
2013-07-05 13:00:00	NQ	Futures	3447.8	3448.97	3441.08	3446.63	10335.0
2013-07-05 14:00:00	NQ	Futures	3446.92	3457.15	3446.92	3453.35	16554.0
2013-07-05 15:00:00	NQ	Futures	3453.06	3458.32	3443.42	3455.69	21092.0
2013-07-05 16:00:00	NQ	Futures	3455.69	3463.58	3454.52	3462.7	5440.0
2013-07-05 17:00:00	NQ	Futures	3462.99	3463.58	3462.41	3462.99	75.0
2013-07-05 00:00:00	YM	Futures	15286.0	15290.1	15283.0	15283.0	210.0
2013-07-05 01:00:00	YM	Futures	15284.0	15293.1	15281.9	15291.1	353.0
2013-07-05 02:00:00	YM	Futures	15291.1	15307.3	15291.1	15297.2	1115.0
2013-07-05 03:00:00	YM	Futures	15297.2	15310.4	15274.8	15308.3	3354.0
2013-07-05 04:00:00	YM	Futures	15307.3	15307.3	15280.9	15291.1	1782.0
2013-07-05 05:00:00	YM	Futures	15292.1	15299.2	15283.0	15291.1	1793.0
2013-07-05 06:00:00	YM	Futures	15290.1	15299.2	15279.9	15280.9	1466.0
2013-07-05 07:00:00	YM	Futures	15280.9	15284.0	15261.6	15274.8	2398.0
2013-07-05 08:00:00	YM	Futures	15272.8	15349.0	15254.5	15289.1	15316.0
2013-07-05 09:00:00	YM	Futures	15289.1	15290.1	15210.8	15213.9	24971.0
2013-07-05 10:00:00	YM	Futures	15212.9	15221.0	15128.6	15169.2	32245.0
2013-07-05 11:00:00	YM	Futures	15168.2	15219.0	15145.8	15216.9	13664.0
2013-07-05 12:00:00	YM	Futures	15216.9	15262.6	15216.9	15248.4	12228.0
2013-07-05 13:00:00	YM	Futures	15249.4	15261.6	15228.1	15245.4	7327.0

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

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