PREVIEW / futures_1hour / 2013-06-14

all futures 1-hour files

  file:    by_date/futures_1hour/2013/2013-06-14.parquet
  size:    41 KB
  rows:    1,212

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-06-14 00:00:00	ES	Futures	1682.03	1685.13	1681.25	1685.13	3038.0
2013-06-14 01:00:00	ES	Futures	1685.13	1685.64	1683.32	1683.84	2451.0
2013-06-14 02:00:00	ES	Futures	1683.84	1686.68	1683.32	1685.9	5581.0
2013-06-14 03:00:00	ES	Futures	1686.16	1687.2	1681.77	1687.2	15933.0
2013-06-14 04:00:00	ES	Futures	1687.2	1687.71	1685.13	1687.71	15314.0
2013-06-14 05:00:00	ES	Futures	1687.71	1688.23	1682.8	1682.8	12629.0
2013-06-14 06:00:00	ES	Futures	1682.8	1684.35	1681.77	1682.8	12293.0
2013-06-14 07:00:00	ES	Futures	1682.54	1686.16	1682.54	1684.35	22941.0
2013-06-14 08:00:00	ES	Futures	1684.61	1685.13	1681.77	1684.35	34690.0
2013-06-14 09:00:00	ES	Futures	1684.09	1688.75	1682.54	1688.49	185807.0
2013-06-14 10:00:00	ES	Futures	1688.49	1690.56	1678.15	1679.18	212350.0
2013-06-14 11:00:00	ES	Futures	1679.18	1682.8	1676.6	1680.22	200708.0
2013-06-14 12:00:00	ES	Futures	1680.22	1682.03	1676.86	1677.63	115319.0
2013-06-14 13:00:00	ES	Futures	1677.63	1677.89	1672.46	1674.53	127632.0
2013-06-14 14:00:00	ES	Futures	1674.53	1679.96	1672.2	1675.3	142687.0
2013-06-14 15:00:00	ES	Futures	1675.05	1680.73	1673.24	1675.3	166702.0
2013-06-14 16:00:00	ES	Futures	1675.3	1675.82	1672.98	1673.24	73401.0
2013-06-14 17:00:00	ES	Futures	1672.98	1673.5	1672.72	1672.72	1179.0
2013-06-14 00:00:00	NQ	Futures	3452.18	3458.61	3451.01	3458.03	328.0
2013-06-14 01:00:00	NQ	Futures	3458.03	3459.2	3454.52	3454.52	326.0
2013-06-14 02:00:00	NQ	Futures	3454.81	3460.66	3454.81	3460.07	473.0
2013-06-14 03:00:00	NQ	Futures	3460.07	3460.36	3451.6	3459.49	3366.0
2013-06-14 04:00:00	NQ	Futures	3459.49	3461.24	3456.57	3460.66	1707.0
2013-06-14 05:00:00	NQ	Futures	3460.95	3462.41	3452.18	3452.18	2673.0
2013-06-14 06:00:00	NQ	Futures	3452.18	3454.52	3449.26	3451.89	1866.0
2013-06-14 07:00:00	NQ	Futures	3451.31	3457.15	3451.01	3455.1	3007.0
2013-06-14 08:00:00	NQ	Futures	3455.4	3458.9	3451.89	3456.86	3830.0
2013-06-14 09:00:00	NQ	Futures	3457.15	3460.66	3450.43	3459.2	29695.0
2013-06-14 10:00:00	NQ	Futures	3459.2	3462.12	3436.99	3439.91	27883.0
2013-06-14 11:00:00	NQ	Futures	3439.62	3444.88	3432.89	3441.08	22735.0
2013-06-14 12:00:00	NQ	Futures	3440.79	3450.43	3436.11	3440.49	19902.0
2013-06-14 13:00:00	NQ	Futures	3440.49	3441.66	3429.39	3433.77	14628.0
2013-06-14 14:00:00	NQ	Futures	3433.77	3443.71	3429.39	3436.11	14810.0
2013-06-14 15:00:00	NQ	Futures	3435.82	3445.75	3433.19	3434.94	17648.0
2013-06-14 16:00:00	NQ	Futures	3435.23	3437.57	3432.02	3433.19	4835.0
2013-06-14 17:00:00	NQ	Futures	3433.19	3433.19	3431.73	3431.73	68.0
2013-06-14 00:00:00	YM	Futures	15319.5	15346.9	15316.5	15346.9	375.0
2013-06-14 01:00:00	YM	Futures	15346.9	15349.0	15332.7	15333.7	275.0
2013-06-14 02:00:00	YM	Futures	15335.8	15356.1	15330.7	15351.0	599.0
2013-06-14 03:00:00	YM	Futures	15351.0	15364.2	15318.5	15362.2	1417.0
2013-06-14 04:00:00	YM	Futures	15363.2	15370.3	15349.0	15367.3	1048.0
2013-06-14 05:00:00	YM	Futures	15369.3	15375.4	15327.6	15327.6	1100.0
2013-06-14 06:00:00	YM	Futures	15326.6	15336.8	15317.5	15326.6	1120.0
2013-06-14 07:00:00	YM	Futures	15324.6	15353.0	15324.6	15340.9	1423.0
2013-06-14 08:00:00	YM	Futures	15341.9	15342.9	15321.6	15340.9	2456.0
2013-06-14 09:00:00	YM	Futures	15340.9	15358.1	15309.4	15356.1	15486.0
2013-06-14 10:00:00	YM	Futures	15356.1	15375.4	15264.7	15275.8	22571.0
2013-06-14 11:00:00	YM	Futures	15274.8	15293.1	15240.3	15271.8	18556.0
2013-06-14 12:00:00	YM	Futures	15271.8	15281.9	15245.4	15249.4	11924.0
2013-06-14 13:00:00	YM	Futures	15248.4	15249.4	15209.8	15228.1	12502.0

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

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