PREVIEW / futures_1hour / 2013-07-02

all futures 1-hour files

  file:    by_date/futures_1hour/2013/2013-07-02.parquet
  size:    50 KB
  rows:    1,543

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-02 00:00:00	ES	Futures	1663.16	1665.74	1662.38	1664.71	3200.0
2013-07-02 01:00:00	ES	Futures	1664.97	1666.26	1664.71	1665.74	4444.0
2013-07-02 02:00:00	ES	Futures	1666.0	1669.1	1665.74	1669.1	10349.0
2013-07-02 03:00:00	ES	Futures	1669.1	1669.1	1663.41	1663.93	27241.0
2013-07-02 04:00:00	ES	Futures	1664.19	1667.03	1661.86	1665.48	20803.0
2013-07-02 05:00:00	ES	Futures	1665.74	1667.81	1662.9	1664.97	17639.0
2013-07-02 06:00:00	ES	Futures	1664.97	1668.33	1664.71	1666.52	16420.0
2013-07-02 07:00:00	ES	Futures	1666.52	1667.03	1663.67	1664.19	17837.0
2013-07-02 08:00:00	ES	Futures	1664.19	1664.71	1659.28	1660.31	44539.0
2013-07-02 09:00:00	ES	Futures	1660.05	1671.17	1659.8	1669.1	211800.0
2013-07-02 10:00:00	ES	Futures	1669.36	1672.98	1667.03	1672.2	262318.0
2013-07-02 11:00:00	ES	Futures	1672.46	1673.5	1669.62	1672.2	163039.0
2013-07-02 12:00:00	ES	Futures	1671.94	1672.72	1666.77	1669.88	130820.0
2013-07-02 13:00:00	ES	Futures	1670.13	1670.39	1661.6	1664.19	151096.0
2013-07-02 14:00:00	ES	Futures	1664.19	1664.45	1654.63	1659.02	255336.0
2013-07-02 15:00:00	ES	Futures	1659.28	1663.67	1656.43	1661.6	220200.0
2013-07-02 16:00:00	ES	Futures	1661.35	1662.64	1660.31	1661.86	80134.0
2013-07-02 17:00:00	ES	Futures	1662.12	1662.12	1661.35	1661.86	1983.0
2013-07-02 18:00:00	ES	Futures	1661.6	1662.64	1661.09	1661.35	3787.0
2013-07-02 19:00:00	ES	Futures	1661.35	1663.16	1661.35	1662.12	2526.0
2013-07-02 20:00:00	ES	Futures	1662.12	1662.9	1661.09	1662.12	4489.0
2013-07-02 21:00:00	ES	Futures	1662.12	1663.16	1659.02	1659.8	8628.0
2013-07-02 22:00:00	ES	Futures	1659.8	1660.57	1657.73	1659.02	7565.0
2013-07-02 23:00:00	ES	Futures	1659.02	1659.8	1657.99	1659.54	5794.0
2013-07-02 00:00:00	NQ	Futures	3416.24	3420.91	3415.36	3418.87	299.0
2013-07-02 01:00:00	NQ	Futures	3418.87	3422.67	3418.87	3422.37	420.0
2013-07-02 02:00:00	NQ	Futures	3422.08	3429.68	3422.08	3429.68	1569.0
2013-07-02 03:00:00	NQ	Futures	3429.68	3429.68	3418.58	3419.74	4715.0
2013-07-02 04:00:00	NQ	Futures	3419.74	3425.3	3415.95	3422.96	2644.0
2013-07-02 05:00:00	NQ	Futures	3423.25	3426.76	3415.95	3420.04	2048.0
2013-07-02 06:00:00	NQ	Futures	3420.04	3428.22	3419.45	3423.25	1623.0
2013-07-02 07:00:00	NQ	Futures	3423.25	3423.84	3418.87	3419.16	1456.0
2013-07-02 08:00:00	NQ	Futures	3419.16	3419.45	3411.27	3412.44	4494.0
2013-07-02 09:00:00	NQ	Futures	3412.44	3433.77	3411.27	3428.22	28318.0
2013-07-02 10:00:00	NQ	Futures	3428.22	3436.4	3422.37	3435.82	32372.0
2013-07-02 11:00:00	NQ	Futures	3435.82	3438.15	3427.63	3435.82	18119.0
2013-07-02 12:00:00	NQ	Futures	3435.52	3436.11	3422.67	3430.26	18546.0
2013-07-02 13:00:00	NQ	Futures	3430.26	3430.56	3410.1	3417.11	20935.0
2013-07-02 14:00:00	NQ	Futures	3417.11	3417.41	3398.41	3406.89	31360.0
2013-07-02 15:00:00	NQ	Futures	3406.89	3420.62	3404.26	3416.24	27152.0
2013-07-02 16:00:00	NQ	Futures	3416.24	3418.87	3413.61	3417.11	4506.0
2013-07-02 17:00:00	NQ	Futures	3416.82	3417.7	3416.82	3417.11	42.0
2013-07-02 18:00:00	NQ	Futures	3417.11	3418.58	3414.19	3414.78	205.0
2013-07-02 19:00:00	NQ	Futures	3415.07	3417.41	3415.07	3416.24	173.0
2013-07-02 20:00:00	NQ	Futures	3415.95	3418.28	3414.78	3416.24	501.0
2013-07-02 21:00:00	NQ	Futures	3416.53	3418.87	3409.52	3410.98	912.0
2013-07-02 22:00:00	NQ	Futures	3410.68	3412.15	3406.59	3408.64	951.0
2013-07-02 23:00:00	NQ	Futures	3408.35	3412.73	3407.18	3411.56	736.0
2013-07-02 00:00:00	YM	Futures	15135.7	15155.0	15129.6	15145.8	450.0
2013-07-02 01:00:00	YM	Futures	15146.9	15159.0	15144.8	15158.0	660.0

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

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